· 9 years ago · Nov 07, 2016, 06:46 AM
1public interface IUserSchema {
2 String USER_TABLE = "users";
3 String COLUMN_ID = "_id";
4 String COLUMN_USER_NAME = "user_name";
5 String COLUMN_EMAIL = "email";
6 String COLUMN_DATE = "created_date";
7 String USER_TABLE_CREATE = "CREATE TABLE IF NOT EXISTS "
8 + USER_TABLE
9 + " ("
10 + COLUMN_ID
11 + " INTEGER PRIMARY KEY, "
12 + COLUMN_USER_NAME
13 + " TEXT NOT NULL, "
14 + COLUMN_EMAIL
15 + " TEXT,"
16 + COLUMN_DATE
17 + "BIGINT "
18 + ")";
19
20 String[] USER_COLUMNS = new String[] { COLUMN_ID,
21 COLUMN_USER_NAME, COLUMN_EMAIL, COLUMN_DATE };
22}