· 9 years ago · Dec 14, 2016, 08:18 AM
1 String objectTable = "CREATE TABLE " + ConstVal.objectTable
2 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.Id + " INTEGER, "
3 + ConstVal.objectTypeId + " INTEGER, " + ConstVal.lat + " REAL, " + ConstVal.lng
4 + " REAL, " + ConstVal.phone + " TEXT, " + ConstVal.email + " TEXT, "
5 + ConstVal.websiteURL + " TEXT, " + ConstVal.bookingcomURL + " TEXT, "
6 + ConstVal.tripAdvisorURL + " TEXT, " + ConstVal.properties + " INTEGER, "
7 + ConstVal.stars + " REAL, " + ConstVal.position + " INTEGER, "
8 + ConstVal.active + " INTEGER);";
9
10 String address_table = "CREATE TABLE " + ConstVal.address_table
11 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.main_address_id + " INTEGER, "
12 + ConstVal.address_id + " INTEGER, " + ConstVal.address_code + " TEXT, " + ConstVal.address_value + " TEXT);";
13
14 String photo_table = "CREATE TABLE " + ConstVal.photo_table
15 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.main_photo_id + " INTEGER, "
16 + ConstVal.photo_id + " INTEGER, " + ConstVal.fileURL + " TEXT);";
17
18 String name_table = "CREATE TABLE " + ConstVal.name_table
19 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.main_name_id + " INTEGER, "
20 + ConstVal.name_id + " INTEGER, " + ConstVal.name_code + " TEXT, " + ConstVal.name_value + " TEXT);";
21
22 String description_table = "CREATE TABLE " + ConstVal.description_table
23 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.main_description_id
24 + " INTEGER, " + ConstVal.description_id + " INTEGER, " + ConstVal.description_code
25 + " TEXT, " + ConstVal.description_value + " TEXT);";
26
27 String property_table = "CREATE TABLE " + ConstVal.property_table
28 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.property_type_Id
29 + " INTEGER, " + ConstVal.property_id + " INTEGER, " + ConstVal.property_valueTexts
30 + " TEXT, " + ConstVal.property_value + " TEXT, " + ConstVal.property_valuesId + " INTEGER);";
31
32 String value_text = "CREATE TABLE " + ConstVal.value_text_table
33 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.value_text_id + " TEXT, "
34 + ConstVal.value_code + " TEXT, " + ConstVal.value_value + " TEXT);";
35
36 String lake_table = "CREATE TABLE " + ConstVal.lake_table
37 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lake_id + " INTEGER, "
38 + ConstVal.lake_num + " INTEGER, "
39 + ConstVal.lake_main_ID + " INTEGER, "
40 + ConstVal.lake_pointer_lat + " REAL, "
41 + ConstVal.area + " REAL, "
42 + ConstVal.lake_pointer_lng + " REAL, " + ConstVal.lake_population_rating + " INTEGER, "
43 + ConstVal.depth + " INTEGER, " + ConstVal.maxDepth + " INTEGER, " + ConstVal.fishingLicenseURL
44 + " TEXT, " + ConstVal.lake_position + " INTEGER, " + ConstVal.lake_width + " REAL, "
45 + ConstVal.lake_lat + " REAL, " + ConstVal.lake_lng + " REAL, "
46 + ConstVal.lake_active + " INTEGER);";
47
48 String lake_description_table = "CREATE TABLE " + ConstVal.lake_description_table
49 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lake_description_ID
50 + " INTEGER, " + ConstVal.lake_description_table_id + " INTEGER, "
51 + ConstVal.lake_description_table_code + " TEXT, " + ConstVal.lake_description_table_value + " TEXT);";
52
53 String lake_photo_table = "CREATE TABLE " + ConstVal.lake_photo_table
54 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lake_photo_ID
55 + " INTEGER, " + ConstVal.lake_photo_table_id + " INTEGER, "
56 + ConstVal.lake_photo_path + " TEXT);";
57
58 String lake_name_table = "CREATE TABLE " + ConstVal.lake_name_table
59 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lake_name_ID + " INTEGER, "
60 + ConstVal.lake_main_ID + " INTEGER, "
61 + ConstVal.lake_name_table_id + " INTEGER, " + ConstVal.lake_name_table_code + " TEXT, "
62 + ConstVal.lake_name_table_value + " TEXT);";
63
64 String categoryNameTable = "CREATE TABLE " + ConstVal.categoryNameTable
65 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.categoryId + " INTEGER, "
66 + ConstVal.categoryNameId + " INTEGER, " + ConstVal.categoryCode + " TEXT, "
67 + ConstVal.categoryValue + " TEXT);";
68
69 String categoryObjectTable = "CREATE TABLE " + ConstVal.categoryObjectTable
70 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.categoryObjectId + " INTEGER, "
71 + ConstVal.categoryObjectTypeId + " INTEGER, " + ConstVal.categoryActive + " INTEGER);";
72
73 String objCatTabe = "CREATE TABLE " + ConstVal.objCatTabe
74 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.objCatObId + " INTEGER, "
75 + ConstVal.objCatCatd + " INTEGER);";
76
77 String objectPropertyTable = "CREATE TABLE " + ConstVal.objectPropertyTable
78 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.objectPropertyId
79 + " INTEGER, " + ConstVal.objectPropertyTypeIdFirst + " INTEGER, "
80 + ConstVal.objectPropertyTypeId + " INTEGER, " + ConstVal.objectPropertyActive + " INTEGER);";
81
82 String objectPropertyNameTable = "CREATE TABLE " + ConstVal.objectPropertyNameTable
83 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.objectPropertyNameMainId
84 + " INTEGER, " + ConstVal.objectPropertyNameId + " INTEGER, "
85 + ConstVal.objectPropertyCode + " TEXT, " + ConstVal.objectPropertyValue + " TEXT);";
86
87 String objectPropertyValueTable = "CREATE TABLE " + ConstVal.objectPropertyValueTable
88 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.objectPropertyValueMainId
89 + " INTEGER, " + ConstVal.objectPropertyValueValue + " INTEGER);";
90
91 String featuresValTable = "CREATE TABLE " + ConstVal.featuresValTable
92 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.featuresValId
93 + " INTEGER, " + ConstVal.featuresValPosition + " INTEGER, " + ConstVal.featuresValActive + " INTEGER);";
94
95 String featuresValNameTable = "CREATE TABLE " + ConstVal.featuresValNameTable
96 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.featuresValNameMainId + " INTEGER, "
97 + ConstVal.featuresValNameId + " INTEGER, " + ConstVal.featuresValNameCode + " TEXT, "
98 + ConstVal.featuresValNameValue + " TEXT);";
99
100 String distanceTable = "CREATE TABLE " + ConstVal.distanceTable
101 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.distId + " INTEGER, " + ConstVal.distanceVal + " REAL);";
102
103 String lakeDepthsTable = "CREATE TABLE " + ConstVal.lakeDepthsTable + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, "
104 + ConstVal.lakeDepthId + " INTEGER, " + ConstVal.actualDepth + " INTEGER);";
105
106 String population_density_table = "CREATE TABLE " + ConstVal.population_density_table
107 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.population_density_ID
108 + " INTEGER, " + ConstVal.population_density_table_id + " INTEGER, "
109 + ConstVal.population_density_table_code + " TEXT, " + ConstVal.population_density_table_value + " TEXT);";
110
111 String fishes_population_info_table = "CREATE TABLE " + ConstVal.fishes_population_info_table
112 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishes_population_info_ID
113 + " INTEGER, " + ConstVal.fishes_population_info_table_id + " INTEGER, "
114 + ConstVal.fishes_population_info_table_code + " TEXT, " + ConstVal.fishes_population_info_table_value + " TEXT);";
115
116 String lake_obj_categories_table = "CREATE TABLE " + ConstVal.lake_obj_categories_table
117 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lake_obj_categories_ID
118 + " INTEGER, " + ConstVal.lake_obj_categories_value + " INTEGER);";
119
120 String lake_coordinatesTable = "CREATE TABLE " + ConstVal.lake_coordinatesTable
121 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lakeID + " INTEGER, "
122 + ConstVal.lake_coordinatesID + " INTEGER, " + ConstVal.main_ID + " INTEGER, "
123 + ConstVal.lake_number + " INTEGER, " + ConstVal.lake_coordinates_lat + " REAL, "
124 + ConstVal.lake_coordinates_lng + " REAL, " + ConstVal.lake_coordinates_depth + " REAL, "
125 + ConstVal.lake_coordinates_first + " INTEGER,"
126 + ConstVal.lake_coordinates_color + " TEXT, "
127 + ConstVal.lake_coordinates_length + " REAL, " + ConstVal.lake_coordinates_earth_h + " INTEGER);" ;
128
129 String favoriteTable = "CREATE TABLE IF NOT EXISTS " + ConstVal.favoriteTable
130 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.favoriteTableId + " INTEGER, "
131 + ConstVal.favoriteCategoryId + " INTEGER, " + ConstVal.fav_lat + " REAL, "
132 + ConstVal.fav_lng + " REAL, " + ConstVal.fav_depth + " REAL);";
133
134
135 String fish_table = "CREATE TABLE " + ConstVal.fish_table
136 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_id + " INTEGER, "
137 + ConstVal.averageWeight + " TEXT, " + ConstVal.averageLength + " TEXT, " +
138 ConstVal.limitationsMaxWeight + " TEXT, " + ConstVal.limitationsMaxLength + " TEXT, "
139 + ConstVal.limitationsMaxQuantity + " INTEGER, " + ConstVal.limitationsNeedLicense + " INTEGER, " + ConstVal.fish_position + " INTEGER);";
140
141
142 String fish_name_table = "CREATE TABLE " + ConstVal.fish_name_table
143 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_name_ID + " INTEGER, "
144 + ConstVal.fish_name_table_id + " INTEGER, " + ConstVal.fish_name_code + " TEXT, "
145 + ConstVal.fish_name_value + " TEXT);";
146
147
148 String fish_description_table = "CREATE TABLE " + ConstVal.fish_description_table
149 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_description_ID + " INTEGER, "
150 + ConstVal.fish_description_table_id + " INTEGER, " + ConstVal.fish_description_code + " TEXT, "
151 + ConstVal.fish_description_value + " TEXT);";
152
153 String fish_photo_table = "CREATE TABLE " + ConstVal.fish_photo_table
154 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_photo_ID + " INTEGER, "
155 + ConstVal.fish_photo_table_id + " INTEGER, " + ConstVal.fish_photo_URL + " TEXT);";
156
157 String fish_populated_locations_table = "CREATE TABLE " + ConstVal.fish_populated_locations_table
158 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_populated_locations_ID + " INTEGER, "
159 + ConstVal.fish_populated_locations_table_id + " INTEGER, " + ConstVal.fish_populated_locations_code
160 + " TEXT, " + ConstVal.fish_populated_locations_value + " TEXT);";
161
162 String fish_limitation_periods_table = "CREATE TABLE " + ConstVal.fish_limitation_periods_table
163 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_limitation_periods_ID + " INTEGER, "
164 + ConstVal.fish_limitation_periods_from_month + " INTEGER, " + ConstVal.fish_limitation_periods_from_day
165 + " INTEGER, " + ConstVal.fish_limitation_periods_to_month + " INTEGER, "
166 + ConstVal.fish_limitation_periods_to_day + " TEXT);";
167
168 String fish_limitations_additional_table = "CREATE TABLE " + ConstVal.fish_limitations_additional_table
169 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_limitations_additional_ID + " INTEGER, "
170 + ConstVal.fish_limitations_additional_table_id + " INTEGER, " + ConstVal.fish_limitations_additional_code
171 + " TEXT, " + ConstVal.fish_limitations_additional_value + " TEXT);";
172
173
174 String fish_lakes_table = "CREATE TABLE " + ConstVal.fish_lakes_table
175 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_lakes_ID + " INTEGER, "
176 + ConstVal.fish_lakes_table_Id + " INTEGER, " + ConstVal.fish_lakes_raing + " INTEGER);";
177
178 String fish_lure_table = "CREATE TABLE " + ConstVal.fish_lure_table
179 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_lure_ID + " INTEGER, "
180 + ConstVal.fish_lure_table_value + " INTEGER);";
181
182 String fish_mathod_table = "CREATE TABLE " + ConstVal.fish_mathod_table
183 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fish_method_ID + " INTEGER, "
184 + ConstVal.fish_method_table_value + " INTEGER);";
185
186 String fishing_lake_object_table = "CREATE TABLE " + ConstVal.fishing_lake_objects_table
187 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_lake_objects_ID + " INTEGER, "
188 + ConstVal.fishing_lake_objects_table_Id + " INTEGER, " +
189 ConstVal.fishing_lake_objects_type + " INTEGER, " +
190 ConstVal.fishing_lake_objects_lat + " REAL, " +
191 ConstVal.fishing_lake_objects_lng + " REAL, " +
192 ConstVal.fishing_lake_objects_position + " INTEGER);";
193
194 String fishing_pictureTOP_table = "CREATE TABLE " + ConstVal.fishing_pictureTOP_table
195 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_pictureTOP_ID + " INTEGER, "
196 + ConstVal.fishing_pictureTOP_table_id + " INTEGER, " + ConstVal.fishing_pictureTOP_fileURl + " TEXT);";
197
198 String fishing_lake_TOP_obj_table = "CREATE TABLE " + ConstVal.fishing_lake_TOP_obj_table
199 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_lake_TOP_obj_ID + " INTEGER, "
200 + ConstVal.fishing_lake_TOP_obj_table_id + " INTEGER, " + ConstVal.fishing_lake_TOP_obj_type + " INTEGER, "
201 + ConstVal.fishing_lake_TOP_obj_lat + " REAL, " + ConstVal.fishing_lake_TOP_obj_lng + " REAL, " +
202 ConstVal.fishing_lake_TOP_obj_pos + " INTEGER, " + ConstVal.fishing_lake_TOP_obj_depth + " REAL);";;
203
204
205 String fishing_lake_object_TOP_description_table = "CREATE TABLE " + ConstVal.fishing_lake_object_TOP_description_table
206 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_lake_object_TOP_description_ID + " INTEGER, "
207 + ConstVal.fishing_lake_object_TOP_id + " INTEGER, " + ConstVal.fishing_lake_object_TOP_code + " TEXT, "
208 + ConstVal.fishing_lake_object_TOP_value + " TEXT, " + ConstVal.fishing_lake_TOP_obj_depth + " INTEGER);";
209
210
211 String lure_object_table = "CREATE TABLE " + ConstVal.lure_object_table
212 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lure_object_ID + " INTEGER, "
213 + ConstVal.lureObject_position + " INTEGER);";
214
215 String lure_name_table = "CREATE TABLE " + ConstVal.lure_name_table
216 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lure_name_ID + " INTEGER, "
217 + ConstVal.lure_name_table_id + " INTEGER, " + ConstVal.lure_name_value + " TEXT, "
218 + ConstVal.lure_name_code + " TEXT);";
219
220 String lure_description_table = "CREATE TABLE " + ConstVal.lure_description_table
221 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lure_description_ID + " INTEGER, "
222 + ConstVal.lure_description_table_id + " INTEGER, " + ConstVal.lure_description_code
223 + " TEXT, " + ConstVal.lure_description_value + " TEXT);";
224
225 String lure_photos_table = "CREATE TABLE " + ConstVal.lure_photos_table
226 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lure_photos_ID + " INTEGER, "
227 + ConstVal.lure_photos_table_id + " INTEGER, " + ConstVal.lure_photos_fileURL + " TEXT);";
228
229 String lure_fishes_table = "CREATE TABLE " + ConstVal.lure_fishes_table + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, "
230 + ConstVal.lure_fishes_ID + " INTEGER, " + ConstVal.lure_fishes_value + " INTEGER);";
231
232 String tourism_properties_table = "CREATE TABLE " + ConstVal.tourism_properties_table + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, "
233 + ConstVal.tourism_properties_id + " INTEGER, " + ConstVal.tourism_properties_objectType_id + " INTEGER, " + ConstVal.tourism_properties_type_id + " INTEGER);";
234
235
236 String tourism_properties_name_table = "CREATE TABLE " + ConstVal.tourism_properties_name_table + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, "
237 + ConstVal.tourism_properties_name_ID + " INTEGER, " + ConstVal.tourism_properties_name_table_id + " INTEGER, "
238 + ConstVal.tourism_properties_name_code + " TEXT, " + ConstVal.tourism_properties_name_value + " TEXT);";
239
240
241 String tourism_properties_values_table = "CREATE TABLE " + ConstVal.tourism_properties_values_table
242 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.tourism_properties_values_ID
243 + " INTEGER, " + ConstVal.tourism_properties_values_val + " INTEGER);";
244
245 String fishing_method_table = "CREATE TABLE " + ConstVal.fishing_method_table
246 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_method_table_ID
247 + " INTEGER, " + ConstVal.fishing_method_table_position + " INTEGER);";
248
249 String fishing_method_name_table = "CREATE TABLE " + ConstVal.fishing_method_name_table
250 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_method_name_ID
251 + " INTEGER, " + ConstVal.fishing_method_name_table_id + " INTEGER, " + ConstVal.fishing_method_name_code + " TEXT, " +
252 ConstVal.fishing_method_name_value + " TEXT);";
253
254 String fishing_method_description_table = "CREATE TABLE " + ConstVal.fishing_method_description_table
255 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_method_description_ID
256 + " INTEGER, " + ConstVal.fishing_method_description_table_id + " INTEGER, " + ConstVal.fishing_method_description_code + " TEXT, " +
257 ConstVal.fishing_method_description_value + " TEXT);";
258
259 String fishing_method_photo_table = "CREATE TABLE " + ConstVal.fishing_method_photo_table
260 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_method_photo_ID
261 + " INTEGER, " + ConstVal.fishing_method_photo_table_id + " INTEGER, " + ConstVal.fishing_method_photo_URL + " TEXT);";
262
263 String fishing_method_value_table = "CREATE TABLE " + ConstVal.fishing_method_value_table
264 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.fishing_method_value_ID
265 + " INTEGER, " + ConstVal.fishing_method_value_val + " INTEGER);";
266
267 String lakeObj_table = "CREATE TABLE " + ConstVal.lakeObj_table
268 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lakeObj_id
269 + " INTEGER, " + ConstVal.lakeObj_value + " INTEGER);";
270
271 String lakeFishTable = "CREATE TABLE " + ConstVal.lakeFishTable
272 + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + ConstVal.lakeFishID
273 + " INTEGER, " + ConstVal.lakeFishTableFishID + " INTEGER, " + ConstVal.lakeFishTable_rating + ");";
274
275 //---------------------
276 db.execSQL(objectTable);
277 db.execSQL(address_table);
278 db.execSQL(photo_table);
279 db.execSQL(name_table);
280 db.execSQL(description_table);
281 db.execSQL(property_table);
282 db.execSQL(value_text);
283 db.execSQL(lake_table);
284 db.execSQL(lake_name_table);
285 db.execSQL(lake_description_table);
286 db.execSQL(lake_photo_table);
287 db.execSQL(population_density_table);
288 db.execSQL(fishes_population_info_table);
289 db.execSQL(lake_coordinatesTable);
290 db.execSQL(fish_table);
291 db.execSQL(fish_description_table);
292 db.execSQL(fish_photo_table);
293 db.execSQL(fish_populated_locations_table);
294 db.execSQL(fish_limitation_periods_table);
295 db.execSQL(fish_limitations_additional_table);
296 db.execSQL(fish_lakes_table);
297 db.execSQL(fish_lure_table);
298 db.execSQL(fish_mathod_table);
299 db.execSQL(fishing_lake_object_table);
300 db.execSQL(fishing_pictureTOP_table);
301 db.execSQL(fishing_lake_TOP_obj_table);
302 db.execSQL(fishing_lake_object_TOP_description_table);
303 db.execSQL(lure_object_table);
304 db.execSQL(lure_name_table);
305 db.execSQL(lure_description_table);
306 db.execSQL(lure_photos_table);
307 db.execSQL(lure_fishes_table);
308 db.execSQL(tourism_properties_table);
309 db.execSQL(tourism_properties_name_table);
310 db.execSQL(tourism_properties_values_table);
311 db.execSQL(fishing_method_table);
312 db.execSQL(fishing_method_name_table);
313 db.execSQL(fishing_method_description_table);
314 db.execSQL(fishing_method_photo_table);
315 db.execSQL(lake_obj_categories_table);
316 db.execSQL(fishing_method_value_table);
317 db.execSQL(lakeObj_table);
318 db.execSQL(lakeFishTable);
319
320
321 db.execSQL(categoryNameTable);
322 db.execSQL(categoryObjectTable);
323 db.execSQL(objCatTabe);
324 db.execSQL(objectPropertyTable);
325 db.execSQL(objectPropertyNameTable);
326 db.execSQL(objectPropertyValueTable);
327 db.execSQL(featuresValTable);
328 db.execSQL(featuresValNameTable);
329 db.execSQL(distanceTable);
330 db.execSQL(lakeDepthsTable);
331 db.execSQL(fish_name_table);
332
333// db.execSQL(myFishingPlanFishingMethods);
334// db.execSQL(myFishingPlanBaits);
335// db.execSQL(myFishingPlanFacilities);
336// db.execSQL(myFishingPlanAccomodation);
337// db.execSQL(myFishingPlanLakes);
338// db.execSQL(myFishingPlanFood);
339 db.execSQL(favoriteTable);
340 }