112 -- INSERT ICON |
113 -- INSERT ICON |
113 INSERT INTO CA_ICON (IC_FILENAME, IC_SKIN_ID) |
114 INSERT INTO CA_ICON (IC_FILENAME, IC_SKIN_ID) |
114 VALUES ( new.ICON_FILENAME, new.ICON_SKIN_ID); |
115 VALUES ( new.ICON_FILENAME, new.ICON_SKIN_ID); |
115 -- DELETE IF ICON IS NULL OR IF IT IS DUPLICATE |
116 -- DELETE IF ICON IS NULL OR IF IT IS DUPLICATE |
116 DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND |
117 DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND |
117 ( (IC_FILENAME IS NULL AND IC_SKIN_ID IS NULL) OR |
118 ( (IC_FILENAME = "" AND IC_SKIN_ID ="") OR |
118 (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND ICON_ID <> last_insert_rowid()) IS NOT NULL OR |
119 (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND IC_SKIN_ID = new.ICON_SKIN_ID AND ICON_ID <> last_insert_rowid()) IS NOT NULL); |
119 (SELECT ICON_ID FROM CA_ICON WHERE IC_SKIN_ID = new.ICON_SKIN_ID AND ICON_ID <> last_insert_rowid()) IS NOT NULL); |
|
120 -- INSERT ENTRY |
120 -- INSERT ENTRY |
121 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_FLAGS, EN_ICON_ID ) |
121 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_FLAGS, EN_ICON_ID ) |
122 VALUES ( new.COLLECTION_NAME , 2, "collection", new.FLAGS, (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME OR IC_SKIN_ID = new.ICON_SKIN_ID )); |
122 VALUES ( new.COLLECTION_NAME , 2, "collection", new.FLAGS, (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND IC_SKIN_ID = new.ICON_SKIN_ID )); |
123 -- LOCALIZATION |
123 -- LOCALIZATION |
124 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID ) |
124 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID ) |
125 VALUES ( 'CA_ENTRY', 'EN_TEXT', new.COL_LOCNAME, ( SELECT DB_VALUE FROM CA_DB_PROPERTIES WHERE DB_PROPERTY = "QMfile" ), ( SELECT last_insert_rowid() ) ); |
125 VALUES ( 'CA_ENTRY', 'EN_TEXT', new.COLLECTION_NAME, new.TRANSLATION_FILE, ( SELECT MAX(ENTRY_ID) FROM CA_ENTRY ) ); |
126 DELETE FROM CA_LOCALIZATION_TEXT WHERE LT_STRING_ID IS NULL AND LOC_TEXT_ID = last_insert_rowid() ; |
126 DELETE FROM CA_LOCALIZATION_TEXT WHERE LT_QMFILENAME IS NULL AND LOC_TEXT_ID = last_insert_rowid() ; |
|
127 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID ) |
|
128 VALUES ( 'CA_ATTRIBUTE', 'short_name', new.COL_SHORT_NAME, new.TRANSLATION_FILE, ( SELECT MAX(ENTRY_ID) FROM CA_ENTRY ) ); |
|
129 DELETE FROM CA_LOCALIZATION_TEXT WHERE ( LT_QMFILENAME IS NULL OR LT_STRING_ID IS NULL ) AND LOC_TEXT_ID = last_insert_rowid(); |
|
130 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID ) |
|
131 VALUES ( 'CA_ATTRIBUTE', 'title_name', new.COL_TITLE_NAME, new.TRANSLATION_FILE, ( SELECT MAX(ENTRY_ID) FROM CA_ENTRY ) ); |
|
132 DELETE FROM CA_LOCALIZATION_TEXT WHERE ( LT_QMFILENAME IS NULL OR LT_STRING_ID IS NULL ) AND LOC_TEXT_ID = last_insert_rowid(); |
127 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
133 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
128 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
134 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
129 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections") , |
135 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections") , |
130 (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME), |
136 (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME), |
131 (SELECT IFNULL(MAX(GE_POSITION)+1, 1) FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections")) ); |
137 (SELECT IFNULL(MAX(GE_POSITION)+1, 1) FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections")) ); |
166 END; |
172 END; |
167 |
173 |
168 SELECT " CREATE TRIGGER item_to_collection_insert_url" AS " "; |
174 SELECT " CREATE TRIGGER item_to_collection_insert_url" AS " "; |
169 CREATE TRIGGER item_to_collection_insert_url INSTEAD OF INSERT ON ITEM_TO_COLLECTION WHEN new.ITEM_TYPE="url" |
175 CREATE TRIGGER item_to_collection_insert_url INSTEAD OF INSERT ON ITEM_TO_COLLECTION WHEN new.ITEM_TYPE="url" |
170 BEGIN |
176 BEGIN |
|
177 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
|
178 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
|
179 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME) , |
|
180 (SELECT ENTRY_ID FROM CA_ENTRY WHERE (EN_TEXT = new.ITEM_NAME AND EN_TYPE_NAME = new.ITEM_TYPE )), |
|
181 (SELECT IFNULL(MAX(GE_POSITION)+1, 1) FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME)) ); |
|
182 END; |
|
183 |
|
184 |
|
185 -- CREATE VIEW WIDGET _TO_COLLECTION |
|
186 SELECT "------------------------------------" AS " "; |
|
187 SELECT "CREATE VIEW WIDGET_TO_COLLECTION" AS " "; |
|
188 DROP VIEW IF EXISTS WIDGET_TO_COLLECTION; |
|
189 CREATE VIEW WIDGET_TO_COLLECTION |
|
190 AS SELECT |
|
191 "" AS "ITEM_TYPE", |
|
192 "" AS "ITEM_NAME", |
|
193 "" AS "ICON_FILENAME", |
|
194 "" AS "ICON_SKIN_ID", |
|
195 "" AS "PACKAGE_UID", |
|
196 "" AS "LIBRARY", |
|
197 "" AS "URI", |
|
198 "" AS "COLLECTION_NAME"; |
|
199 |
|
200 SELECT " CREATE TRIGGER insert_widget_to_collection" AS " "; |
|
201 CREATE TRIGGER item_to_collection_insert_widget INSTEAD OF INSERT ON WIDGET_TO_COLLECTION WHEN new.ITEM_TYPE="widget" |
|
202 BEGIN |
171 -- INSERT ICON |
203 -- INSERT ICON |
172 INSERT OR IGNORE INTO CA_ICON (IC_FILENAME, IC_SKIN_ID) |
204 INSERT OR IGNORE INTO CA_ICON (IC_FILENAME, IC_SKIN_ID) |
173 VALUES ( new.ICON_FILENAME, new.ICON_SKIN_ID); |
205 VALUES ( new.ICON_FILENAME, new.ICON_SKIN_ID); |
174 DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND |
206 DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND |
175 ( (IC_FILENAME IS NULL AND IC_SKIN_ID IS NULL) OR |
207 ( (IC_FILENAME = "" AND IC_SKIN_ID = "") OR |
176 (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND ICON_ID <> last_insert_rowid()) IS NOT NULL OR |
208 (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND IC_SKIN_ID = new.ICON_SKIN_ID AND ICON_ID <> last_insert_rowid()) IS NOT NULL); |
177 (SELECT ICON_ID FROM CA_ICON WHERE IC_SKIN_ID = new.ICON_SKIN_ID AND ICON_ID <> last_insert_rowid()) IS NOT NULL); |
|
178 -- INSERT ENTRY |
209 -- INSERT ENTRY |
179 INSERT OR IGNORE INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID ) |
210 INSERT OR IGNORE INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID ) |
180 VALUES ( new.ITEM_NAME, 1, "url", (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME OR IC_SKIN_ID = new.ICON_SKIN_ID )); |
211 VALUES ( new.ITEM_NAME, 1, "widget", (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND IC_SKIN_ID = new.ICON_SKIN_ID )); |
181 -- ADD ATTRIBUTES |
212 -- INSERT ATTRIBUTES |
182 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
213 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
183 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"url",new.ITEM_DEST ); |
214 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"packageuid",new.PACKAGE_UID); |
184 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
215 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
185 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"short_name", new.ITEM_SHORTNAME ); |
216 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"widget:library",new.LIBRARY); |
|
217 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
|
218 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"widget:uri",new.URI); |
186 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
219 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
187 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
220 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
188 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME) , |
221 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME) , |
189 (SELECT ENTRY_ID FROM CA_ENTRY WHERE (EN_TEXT = new.ITEM_NAME AND EN_TYPE_NAME = new.ITEM_TYPE )), |
222 (SELECT ENTRY_ID FROM CA_ENTRY WHERE (EN_TEXT = new.ITEM_NAME AND EN_TYPE_NAME = new.ITEM_TYPE)), |
190 (SELECT IFNULL(MAX(GE_POSITION)+1, 1) FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME)) ); |
223 (SELECT IFNULL(MAX(GE_POSITION)+1, 1) FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME)) ); |
191 END; |
224 END; |
192 |
225 |
193 |
226 |
194 -- CREATE VIEW WIDGET _TO_COLLECTION |
227 |
195 SELECT "------------------------------------" AS " "; |
228 -- CREATE VIEW URL |
196 SELECT "CREATE VIEW WIDGET_TO_COLLECTION" AS " "; |
229 SELECT "------------------------------------" AS " "; |
197 DROP VIEW IF EXISTS WIDGET_TO_COLLECTION; |
230 SELECT "CREATE VIEW URL" AS " "; |
198 CREATE VIEW WIDGET_TO_COLLECTION |
231 DROP VIEW IF EXISTS URL; |
199 AS SELECT |
232 CREATE VIEW URL |
200 "" AS "ITEM_TYPE", |
233 AS SELECT |
201 "" AS "ITEM_NAME", |
234 "" AS "URL_TITLE", |
202 "" AS "ICON_FILENAME", |
235 "" AS "URL_SHORT_TITLE", |
203 "" AS "ICON_SKIN_ID", |
236 "" AS "ICON_FILENAME", |
204 "" AS "PACKAGE_UID", |
237 "" AS "ICON_SKIN_ID", |
205 "" AS "LIBRARY", |
238 "" AS "URL_DEST"; |
206 "" AS "URI", |
239 |
207 "" AS "COLLECTION_NAME"; |
240 SELECT " CREATE TRIGGER insert_url" AS " "; |
208 |
241 CREATE TRIGGER insert_url INSTEAD OF INSERT ON URL |
209 SELECT " CREATE TRIGGER insert_widget_to_collection" AS " "; |
|
210 CREATE TRIGGER item_to_collection_insert_widget INSTEAD OF INSERT ON WIDGET_TO_COLLECTION WHEN new.ITEM_TYPE="widget" |
|
211 BEGIN |
242 BEGIN |
212 -- INSERT ICON |
243 -- INSERT ICON |
213 INSERT OR IGNORE INTO CA_ICON (IC_FILENAME, IC_SKIN_ID) |
244 INSERT OR IGNORE INTO CA_ICON (IC_FILENAME, IC_SKIN_ID) |
214 VALUES ( new.ICON_FILENAME, new.ICON_SKIN_ID); |
245 VALUES ( new.ICON_FILENAME, new.ICON_SKIN_ID); |
215 DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND |
246 DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND |
216 ( (IC_FILENAME IS NULL AND IC_SKIN_ID IS NULL) OR |
247 ( (IC_FILENAME = "" AND IC_SKIN_ID = "") OR |
217 (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND ICON_ID <> last_insert_rowid()) IS NOT NULL OR |
248 (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND IC_SKIN_ID = new.ICON_SKIN_ID AND ICON_ID <> last_insert_rowid()) IS NOT NULL); |
218 (SELECT ICON_ID FROM CA_ICON WHERE IC_SKIN_ID = new.ICON_SKIN_ID AND ICON_ID <> last_insert_rowid()) IS NOT NULL); |
|
219 -- INSERT ENTRY |
249 -- INSERT ENTRY |
220 INSERT OR IGNORE INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID ) |
250 INSERT OR IGNORE INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID ) |
221 VALUES ( new.ITEM_NAME, 1, "widget", (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME OR IC_SKIN_ID = new.ICON_SKIN_ID )); |
251 VALUES ( new.URL_TITLE, 1, "url", (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON_FILENAME AND IC_SKIN_ID = new.ICON_SKIN_ID ) ); |
222 -- INSERT ATTRIBUTES |
252 -- ADD ATTRIBUTES |
223 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
253 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
224 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"packageuid",new.PACKAGE_UID); |
254 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.URL_TITLE ), "url", new.URL_DEST ); |
225 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
255 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
226 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"widget:library",new.LIBRARY); |
256 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.URL_TITLE ) ,"short_name", new.URL_SHORT_TITLE ); |
227 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
|
228 VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"widget:uri",new.URI); |
|
229 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
|
230 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
|
231 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME) , |
|
232 (SELECT ENTRY_ID FROM CA_ENTRY WHERE (EN_TEXT = new.ITEM_NAME AND EN_TYPE_NAME = new.ITEM_TYPE)), |
|
233 (SELECT IFNULL(MAX(GE_POSITION)+1, 1) FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME)) ); |
|
234 END; |
257 END; |
235 |
258 |
236 |
259 |
237 |
260 |
238 -- insert neccessary items |
261 -- insert neccessary items |
243 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
266 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
244 VALUES ( last_insert_rowid(), "appgroup_name", "AllCollections" ); |
267 VALUES ( last_insert_rowid(), "appgroup_name", "AllCollections" ); |
245 |
268 |
246 SELECT "------------------------------------" AS " "; |
269 SELECT "------------------------------------" AS " "; |
247 SELECT "INSERT Downloaded collection ENTRY" AS " "; |
270 SELECT "INSERT Downloaded collection ENTRY" AS " "; |
248 INSERT INTO CA_ICON (IC_FILENAME) |
271 INSERT INTO CA_ICON (IC_FILENAME, IC_SKIN_ID) |
249 VALUES ( "qtg_large_applications_download"); |
272 VALUES ( "qtg_large_applications_download", "" ); |
250 |
273 |
251 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_FLAGS ) |
274 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_FLAGS ) |
252 VALUES ( 'Downloaded', 2, "collection::downloaded", last_insert_rowid() , 8 ); |
275 VALUES ( 'txt_applib_dblist_downloads', 2, "collection::downloaded", ( SELECT MAX(ICON_ID) FROM CA_ICON ) , 8 ); |
253 |
276 |
254 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
277 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
255 VALUES ( last_insert_rowid(), "appgroup_name", " Downloaded" ); |
278 VALUES ( ( SELECT MAX(ENTRY_ID) FROM CA_ENTRY ), "appgroup_name", "Downloaded" ); |
|
279 |
|
280 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE ) |
|
281 VALUES ( ( SELECT MAX(ENTRY_ID) FROM CA_ENTRY ), "title_name", "txt_applib_subtitle_downloads" ); |
256 |
282 |
257 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID ) |
283 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID ) |
258 VALUES ( 'CA_ENTRY', 'EN_TEXT', "txt_applib_dblist_downloaded",( SELECT DB_VALUE FROM CA_DB_PROPERTIES WHERE DB_PROPERTY = "QMfile" ), ( SELECT last_insert_rowid() ) ); |
284 VALUES ( 'CA_ENTRY', 'EN_TEXT', "txt_applib_dblist_downloads",( SELECT DB_VALUE FROM CA_DB_PROPERTIES WHERE DB_PROPERTY = "QMfile" ), ( SELECT MAX(ENTRY_ID) FROM CA_ENTRY ) ); |
|
285 |
|
286 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID ) |
|
287 VALUES ( 'CA_ATTRIBUTE', 'title_name', "txt_applib_subtitle_downloads",( SELECT DB_VALUE FROM CA_DB_PROPERTIES WHERE DB_PROPERTY = "QMfile" ), ( SELECT MAX(ENTRY_ID) FROM CA_ENTRY ) ); |
259 |
288 |
260 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
289 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
261 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections") , |
290 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections") , |
262 (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "collection::downloaded"), |
291 (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "collection::downloaded"), |
263 1 ); |
292 1 ); |
264 |
293 |
|
294 |
|
295 |
265 SELECT "------------------------------------" AS " "; |
296 SELECT "------------------------------------" AS " "; |
266 SELECT "castoragedb_create - END" AS " "; |
297 SELECT "castoragedb_create - END" AS " "; |
267 SELECT "------------------------------------" AS " "; |
298 SELECT "------------------------------------" AS " "; |
268 |
299 |