Z2nBGxc0

1    public static final String DATABASE_NAME = "_foobarrr.db";
2    private static final int DATABASE_VERSION = 1;
3
4    // SYSTEM DATABASE
5    public static final String SYSTEM_DB_TABLE = "_systemdata";
6    public static final String SYSTEM_TABLE_ID = "_id";
7    public static final String SYSTEM_TABLE_EN_NOTIFICATION = "_notification";
8    public static final String SYSTEM_TABLE_EN_VIBRATE = "_vibrate";
9    public static final String SYSTEM_TABLE_EN_SOUND = "_sound";
10    public static final String SYSTEM_TABLE_APPSECRET = "_appkey";
11    public static final String SYSTEM_TABLE_APPKEY = "_appsecret";
12    public static final String SYSTEM_TABLE_FBTOKEN = "_fbtoken";
13    public static final String SYSTEM_TABLE_LOGIN_STATUS = "_loginstatus";
14    public static final String SYSTEM_TABLE_LOGIN_FACEBOOK = "_loginfacebook";
15
16    // USER DATABASE
17    public static final String USER_DB_TABLE = "_userdata";
18    public static final String USER_TABLE_ID = "_id";
19    public static final String USER_TABLE_UID = "_uid";
20    public static final String USER_TABLE_USERNAME = "_username";
21    public static final String USER_TABLE_PASSWORD = "_password";
22    public static final String USER_TABLE_EMAIL = "_email";
23    public static final String USER_TABLE_FIRSTNAME = "_firstname";
24    public static final String USER_TABLE_LASTNAME = "_lastname";
25
26    // GASTRO DATABASE
27    public static final String GASTRO_DB_TABLE = "_gastrodata";
28    public static final String GASTRO_TABLE_ID = "_id";
29    public static final String GASTRO_TABLE_GASTROID = "_gastroid";
30    public static final String GASTRO_TABLE_NAME = "_name";
31    public static final String GASTRO_TABLE_PLZ = "_plz";
32    public static final String GASTRO_TABLE_ORT = "_ort";
33    public static final String GASTRO_TABLE_STREET = "_street";
34    public static final String GASTRO_TABLE_STREET_NUMBER = "_streetnumber";
35    public static final String GASTRO_TABLE_LATITUDE = "_latitude";
36    public static final String GASTRO_TABLE_LONGTITUDE = "_longtitude";
37    public static final String GASTRO_TABLE_TYPE = "_type";
38
39    // CITYS DATABASE
40    public static final String CITYS_DB_TABLE = "_citysdata";
41    public static final String CITYS_TABLE_ID = "_id";
42    public static final String CITYS_TABLE_CITYID = "_cityid";
43    public static final String CITYS_TABLE_NAME = "_name";
44    public static final String CITYS_TABLE_LATITUDE = "_latitude";
45    public static final String CITYS_TABLE_LONGTITUDE = "_longtitude";
46
47    // CITYS DATABASE
48    public static final String USERIMAGES_DB_TABLE = "_userimagesdata";
49    public static final String USERIMAGES_TABLE_ID = "_id";
50    public static final String USERIMAGES_TABLE_USERID = "_userid";
51
52    // TEMPTOUR DATABASE
53    public static final String TEMPTOUR_DB_TABLE = "_temptourdata";
54    public static final String TEMPTOUR_TABLE_ID = "_id";
55    public static final String TEMPTOUR_TITLE = "_title";
56    public static final String TEMPTOUR_CITY = "_city";
57    public static final String TEMPTOUR_DESCRIPTION = "_description";
58    public static final String TEMPTOUR_TYPE = "_type";
59    public static final String TEMPTOUR_EXIST = "_exist";
60
61    public DBHelper(Context context) {
62        super(context, DATABASE_NAME, null, DATABASE_VERSION);
63    }
64
65    @Override
66    public void onCreate(SQLiteDatabase db) {
67
68        // CREATE SYSTEM DATABASE TABLE
69        db.execSQL("CREATE TABLE IF NOT EXISTS " +
70                SYSTEM_DB_TABLE +
71                "(" +
72                SYSTEM_TABLE_ID + " INTEGER," +
73                SYSTEM_TABLE_EN_NOTIFICATION + " INTEGER," +
74                SYSTEM_TABLE_EN_VIBRATE + " INTEGER," +
75                SYSTEM_TABLE_EN_SOUND + " INTEGER," +
76                SYSTEM_TABLE_APPKEY + " TEXT," +
77                SYSTEM_TABLE_APPSECRET + " TEXT," +
78                SYSTEM_TABLE_FBTOKEN + " TEXT," +
79                SYSTEM_TABLE_LOGIN_STATUS + " INTEGER," +
80                SYSTEM_TABLE_LOGIN_FACEBOOK + " INTEGER" +
81                ")");
82
83        // CREATE USER DATABASE TABLE
84        db.execSQL("CREATE TABLE IF NOT EXISTS " +
85                USER_DB_TABLE +
86                "(" +
87                USER_TABLE_ID + " INTEGER," +
88                USER_TABLE_UID + " TEXT," +
89                USER_TABLE_USERNAME + " TEXT," +
90                USER_TABLE_PASSWORD + " TEXT," +
91                USER_TABLE_EMAIL + " TEXT," +
92                USER_TABLE_FIRSTNAME + " TEXT," +
93                USER_TABLE_LASTNAME + " TEXT" +
94                ")");
95
96        // CREATE TEMPTOUR DATABASE TABLE
97        db.execSQL("CREATE TABLE IF NOT EXISTS " +
98                TEMPTOUR_DB_TABLE +
99                "(" +
100                TEMPTOUR_TABLE_ID + " INTEGER," +
101                TEMPTOUR_TITLE + " TEXT," +
102                TEMPTOUR_CITY + " TEXT," +
103                TEMPTOUR_DESCRIPTION + " TEXT," +
104                TEMPTOUR_TYPE + " TEXT," +
105                TEMPTOUR_EXIST + " TEXT" +
106                ")");
107
108        // CREATE GASTRO DATABASE TABLE
109        db.execSQL("CREATE TABLE IF NOT EXISTS " +
110                GASTRO_DB_TABLE +
111                "(" +
112                GASTRO_TABLE_ID + " INTEGER," +
113                GASTRO_TABLE_GASTROID + " TEXT," +
114                GASTRO_TABLE_NAME + " TEXT," +
115                GASTRO_TABLE_PLZ + " TEXT," +
116                GASTRO_TABLE_ORT + " TEXT," +
117                GASTRO_TABLE_STREET + " TEXT," +
118                GASTRO_TABLE_STREET_NUMBER + " TEXT," +
119                GASTRO_TABLE_LATITUDE + " TEXT," +
120                GASTRO_TABLE_LONGTITUDE + " TEXT," +
121                GASTRO_TABLE_TYPE + " TEXT" +
122                ")");
123
124        // CREATE CITYS DATABASE TABLE
125        db.execSQL("CREATE TABLE IF NOT EXISTS " +
126                CITYS_DB_TABLE +
127                "(" +
128                CITYS_TABLE_ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
129                CITYS_TABLE_CITYID + " TEXT," +
130                CITYS_TABLE_NAME + " TEXT," +
131                CITYS_TABLE_LATITUDE + " TEXT," +
132                CITYS_TABLE_LONGTITUDE + " TEXT" +
133                ")");
134
135        // CREATE USERIMAGES DATABASE TABLE
136        db.execSQL("CREATE TABLE IF NOT EXISTS " +
137                USERIMAGES_DB_TABLE +
138                "(" +
139                USERIMAGES_TABLE_ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
140                USERIMAGES_TABLE_USERID + " TEXT" +
141                ")");
142    }