|
1 SELECT "------------------------------------" AS " "; |
|
2 SELECT "castoragedb_variant - BEGIN" AS " "; |
|
3 |
|
4 -- insert neccessary items |
|
5 SELECT "INSERT GROUPS" AS " "; |
|
6 SELECT "." AS " "; |
|
7 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_UID ) |
|
8 VALUES ( 'Menu', 2, "folder", NULL , NULL ); |
|
9 |
|
10 SELECT "INSERT menucollections ENTRY" AS " "; |
|
11 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_UID ) |
|
12 VALUES ( 'AllCollections', 2, "menucollections", NULL , NULL ); |
|
13 |
|
14 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_UID, EN_FLAGS ) |
|
15 VALUES ( 'Application Library', 2, "applicationlibrary", NULL, NULL, 8 ); |
|
16 |
|
17 SELECT "------------------------------------" AS " "; |
|
18 SELECT "INSERT Downloaded collection ENTRY" AS " "; |
|
19 INSERT INTO CA_ICON (IC_FILENAME) |
|
20 VALUES ( "qtg_large_applications_download"); |
|
21 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_FLAGS ) |
|
22 VALUES ( 'Downloaded', 2, "collection::downloaded", last_insert_rowid() , 8 ); |
|
23 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID ) |
|
24 VALUES ( 'CA_ENTRY', 'EN_TEXT', "txt_applib_dblist_downloaded", ( SELECT last_insert_rowid() ) ); |
|
25 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
|
26 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections") , |
|
27 (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "collection::downloaded"), |
|
28 1 ); |
|
29 |
|
30 -- insert additional items |
|
31 |
|
32 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, ICON) VALUES ( 'Office', "txt_applib_dblist_office", "qtg_large_applications_user"); |
|
33 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
34 VALUES ("application", 'calendar', 268458241, 'Office' ); |
|
35 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
36 VALUES ("application", 'Phonebook', 537014009, 'Office' ); |
|
37 |
|
38 INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Multimedia', "qtg_large_applications_user" ); |
|
39 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
40 VALUES ("application", 'Themes', 268458546, 'Multimedia' ); |
|
41 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
42 VALUES ("application", 'Paint Cursor', 537001564, 'Multimedia' ); |
|
43 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
44 VALUES ("application", 'Videoplayer', 537006590, 'Multimedia' ); |
|
45 |
|
46 INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Utils', "qtg_large_applications_user" ); |
|
47 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
48 VALUES ("application", 'ControlPanel', 537026521, 'Utils' ); |
|
49 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
50 VALUES ("application", 'Bluetooth', 268458321, 'Utils' ); |
|
51 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
52 VALUES ("application", 'SW update', 537001519, 'Utils' ); |
|
53 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
54 VALUES ("application", 'eshell', 270498535, 'Utils' ); |
|
55 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
|
56 VALUES ("application", 'Conn. mgr.', 270501072, 'Utils' ); |
|
57 |
|
58 |
|
59 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, ICON) VALUES ( 'Games', "txt_applib_dblist_games", "qtg_large_applications_user" ); |
|
60 |
|
61 SELECT "castoragedb_variant - END" AS " "; |
|
62 SELECT "------------------------------------" AS " "; |
|
63 |