qRFUwy0i

1sqLiteDatabase.execSQL(
2                "CREATE TABLE IF NOT EXISTS " + TABLE_USER +
3                        "(" + COLUMN_USER_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
4                        "," + COLUMN_USER_NAME + " TEXT" +
5                        "," + COLUMN_USER_EMAIL + " TEXT" +
6                        "," + COLUMN_USER_PASSWORD + " TEXT" +
7                        "," + COLUMN_USER_IS_ADMIN + " TEXT" +
8                        "," + COLUMN_USER_SECURE_NUM + " INTEGER)");
9        sqLiteDatabase.execSQL(
10                "CREATE TABLE IF NOT EXISTS " + TABLE_LOCATION +
11                        "(" + COLUMN_LOCATION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
12                        "," + COLUMN_LOCATION_NAME + " TEXT" +
13                        "," + COLUMN_LOCATION_ADDRESS + " TEXT" +
14                        "," + COLUMN_LOCATION_CITY + " TEXT)");
15        sqLiteDatabase.execSQL(
16                "CREATE TABLE IF NOT EXISTS " + TABLE_USER_LOCATIONS +
17                        "(" + COLUMN_USER_LOCATION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
18                        "," + COLUMN_USER_ID_FK + " INTEGER" +
19                        "," + COLUMN_LOCATION_ID_FK + " INTEGER" +
20                        ",FOREIGN KEY (" + COLUMN_USER_ID_FK + ") " +
21                        "REFERENCES " + TABLE_USER + "(" + COLUMN_USER_ID + ")" +
22                        ",FOREIGN KEY (" + COLUMN_LOCATION_ID_FK + ") " +
23                        "REFERENCES " + TABLE_LOCATION + "(" + COLUMN_LOCATION_ID + "))");
24        sqLiteDatabase.execSQL(
25                "CREATE TABLE IF NOT EXISTS " + TABLE_SHIFTS +
26                        "(" + COLUMN_SHIFT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
27                        "," + COLUMN_SHIFT_DATE + " TEXT" +
28                        "," + COLUMN_SHIFT_TIME + " TEXT" +
29                        "," + COLUMN_SHIFT_END_TIME + " TEXT" +
30                        "," + COLUMN_SHIFT_AVAILABLITY + " TEXT" +
31                        "," + COLUMN_LOCATION_ID_FK + " INTEGER" +
32                        ",FOREIGN KEY (" + COLUMN_LOCATION_ID_FK + ") " +
33                        "REFERENCES " + TABLE_LOCATION + " (" + COLUMN_LOCATION_ID + "))");
34        sqLiteDatabase.execSQL(
35                "CREATE TABLE IF NOT EXISTS " + TABLE_USER_SHIFT +
36                        "(" + COLUMN_USER_SHIFT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
37                        "," + COLUMN_USER_SHIFT_COMPLETED + " TEXT" +
38                        "," + COLUMN_SHIFT_ID_FK + " INTEGER" +
39                        "," + COLUMN_USER_ID_FK + " INTEGER" +
40                        ",FOREIGN KEY (" + COLUMN_SHIFT_ID_FK + ") " +
41                        "REFERENCES " + TABLE_SHIFTS + " (" + COLUMN_SHIFT_ID + ")" +
42                        ",FOREIGN KEY (" + COLUMN_USER_ID_FK + ") " +
43                        "REFERENCES " + TABLE_USER + " (" + COLUMN_USER_ID + "))");
44        sqLiteDatabase.execSQL(
45                "CREATE TABLE IF NOT EXISTS " + TABLE_ARRESTS +
46                        "(" + COLUMN_ARREST_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
47                        "," + COLUMN_ARREST_DATE + " TEXT" +
48                        "," + COLUMN_ARREST_TIME + " TEXT" +
49                        "," + COLUMN_ARREST_TYPE + " TEXT" +
50                        "," + COLUMN_LOCATION_ID_FK + " INTEGER" +
51                        "," + COLUMN_USER_ID_FK + " INTEGER" +
52                        ",FOREIGN KEY (" + COLUMN_LOCATION_ID_FK + ") " +
53                        "REFERENCES " + TABLE_LOCATION + " (" + COLUMN_LOCATION_ID + ")" +
54                        ",FOREIGN KEY (" + COLUMN_USER_ID_FK + ") " +
55                        "REFERENCES " + TABLE_USER + " (" + COLUMN_USER_ID + "))");
56        sqLiteDatabase.execSQL(
57                "CREATE TABLE IF NOT EXISTS " + TABLE_DESCRIPTION +
58                        "(" + COLUMN_DESCRIPTION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
59                        "," + COLUMN_DESCRIPTION_NAME + " TEXT" +
60                        "," + COLUMN_DESCRIPTION_HEIGHT + " TEXT" +
61                        "," + COLUMN_DESCRIPTION_WEIGHT + " TEXT" +
62                        "," + COLUMN_DESCRIPTION_HAIR_COLOR + " TEXT" +
63                        "," + COLUMN_DESCRIPTION_EYE_COLOR + " TEXT" +
64                        "," + COLUMN_DESCRIPTION_SKIN_COLOR + " TEXT" +
65                        "," + COLUMN_DESCRIPTION_HAS_TATOO + " TEXT" +
66                        "," + COLUMN_ARREST_ID_FK + " INTEGER" +
67                        ",FOREIGN KEY (" + COLUMN_ARREST_ID_FK + ") " +
68                        "REFERENCES " + TABLE_ARRESTS + " (" + COLUMN_ARREST_ID + "))");
69        sqLiteDatabase.execSQL(
70                "CREATE TABLE IF NOT EXISTS " + TABLE_TATOO +
71                        "(" + COLUMN_TATOO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
72                        "," + COLUMN_TATOO_SIZE + " TEXT" +
73                        "," + COLUMN_TATOO_LOCATION + " TEXT" +
74                        "," + COLUMN_TATOO_DESCRIPTION + " TEXT" +
75                        "," + COLUMN_TATOO_COLOR_PRIMARY + " TEXT" +
76                        "," + COLUMN_TATOO_COLOR_SECONDARY + " TEXT" +
77                        "," + COLUMN_DESCRIPTION_ID_FK + " INTEGER" +
78                        ",FOREIGN KEY (" + COLUMN_DESCRIPTION_ID_FK + ") " +
79                        "REFERENCES " + TABLE_DESCRIPTION + " (" + COLUMN_DESCRIPTION_ID + "))");