1 SELECT "------------------------------------" AS " "; |
1 SELECT "------------------------------------" AS " "; |
2 SELECT "castoragedb_variant - BEGIN" AS " "; |
2 SELECT "castoragedb_variant - BEGIN" AS " "; |
3 |
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 |
4 |
30 -- insert additional items |
5 -- insert additional items |
31 |
6 |
32 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, ICON) VALUES ( 'Office', "txt_applib_dblist_office", "qtg_large_applications_user"); |
7 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Office', "txt_applib_dblist_office", 'Office', "qtg_large_applications_user"); |
33 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
8 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
34 VALUES ("application", 'calendar', 268458241, 'Office' ); |
9 VALUES ("application", 'calendar', 268458241, 'Office' ); |
35 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
10 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
36 VALUES ("application", 'Phonebook', 537014009, 'Office' ); |
11 VALUES ("application", 'Phonebook', 537014009, 'Office' ); |
37 |
12 |
38 INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Multimedia', "qtg_large_applications_user" ); |
13 INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Multimedia', 'Multimedia' , "qtg_large_applications_user" ); |
39 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
14 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
40 VALUES ("application", 'Themes', 268458546, 'Multimedia' ); |
15 VALUES ("application", 'Themes', 268458546, 'Multimedia' ); |
41 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
16 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
42 VALUES ("application", 'Paint Cursor', 537001564, 'Multimedia' ); |
17 VALUES ("application", 'Paint Cursor', 537001564, 'Multimedia' ); |
43 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
18 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
44 VALUES ("application", 'Videoplayer', 537006590, 'Multimedia' ); |
19 VALUES ("application", 'Videoplayer', 537006590, 'Multimedia' ); |
45 |
20 |
46 INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Utils', "qtg_large_applications_user" ); |
21 INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Utils', 'Utils', "qtg_large_applications_user" ); |
47 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
22 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
48 VALUES ("application", 'ControlPanel', 537026521, 'Utils' ); |
23 VALUES ("application", 'ControlPanel', 537026521, 'Utils' ); |
49 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
24 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
50 VALUES ("application", 'Bluetooth', 268458321, 'Utils' ); |
25 VALUES ("application", 'Bluetooth', 268458321, 'Utils' ); |
51 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
26 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
52 VALUES ("application", 'SW update', 537001519, 'Utils' ); |
27 VALUES ("application", 'SW update', 537001519, 'Utils' ); |
53 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
28 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
54 VALUES ("application", 'eshell', 270498535, 'Utils' ); |
29 VALUES ("application", 'eshell', 270498535, 'Utils' ); |
55 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
30 INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) |
56 VALUES ("application", 'Conn. mgr.', 270501072, 'Utils' ); |
31 VALUES ("application", 'Conn. mgr.', 270501072, 'Utils' ); |
57 |
|
58 |
32 |
59 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, ICON) VALUES ( 'Games', "txt_applib_dblist_games", "qtg_large_applications_user" ); |
33 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Games', "txt_applib_dblist_games", 'Games',"qtg_large_applications_user" ); |
60 |
34 |
61 SELECT "castoragedb_variant - END" AS " "; |
35 SELECT "castoragedb_variant - END" AS " "; |
62 SELECT "------------------------------------" AS " "; |
36 SELECT "------------------------------------" AS " "; |
63 |
37 |