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 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE )  

    11 VALUES ( last_insert_rowid(), "appgroup_name", "Menu" );

    12 

    13 SELECT "INSERT menucollections ENTRY" AS " ";

    14 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_UID ) 

    15 VALUES ( 'AllCollections', 2, "menucollections", NULL , NULL  );

    16 

    17 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE )  

    18 VALUES ( last_insert_rowid(), "appgroup_name", "AllCollections" );

    19 

    20 SELECT "." AS " ";

    21 INSERT INTO CA_ICON (IC_FILENAME) 

    22 VALUES ( 'c:\data\Images\kqticaicons\google1.png');

    23 

    24 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_UID, EN_FLAGS ) 

    25 VALUES ( 'Application Library', 2, "applicationlibrary", ( SELECT last_insert_rowid() ), NULL, 8 );

    26 

    27 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE )  

    28 VALUES ( last_insert_rowid(), "appgroup_name", " Application Library" );

    29 

    30 SELECT "------------------------------------" AS " ";

    31 SELECT "INSERT Downloaded collection ENTRY" AS " ";

    32 INSERT INTO CA_ICON (IC_FILENAME) 

    33 VALUES ( "qtg_large_applications_download");

    34 

    35 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID,  EN_FLAGS ) 

    36 VALUES ( 'Downloaded', 2, "collection::downloaded", last_insert_rowid() , 8 );

    37 

    38 INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE )  

    39 VALUES ( last_insert_rowid(), "appgroup_name", " Downloaded" );

    40 

    41 INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID ) 

    42 VALUES ( 'CA_ENTRY', 'EN_TEXT', "txt_applib_dblist_downloaded", ( SELECT last_insert_rowid() ) );

    43 

    44 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) 

    45 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "menucollections") , 

    46           (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TYPE_NAME = "collection::downloaded"), 

    47           1 ); 

    48 

    49 -- insert additional items

    50 

    51 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, ICON) VALUES ( 'Office',  "txt_applib_dblist_office", "qtg_large_applications_user");

    52   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    53   VALUES ("application", 'calendar', 268458241,  'Office' );

    54   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    55   VALUES ("application", 'Phonebook', 537014009,  'Office' );

    56 

    57 INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Multimedia', "qtg_large_applications_user" );  

    58   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    59   VALUES ("application", 'Themes', 268458546,  'Multimedia' );

    60   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    61   VALUES ("application", 'Paint Cursor', 537001564,  'Multimedia' ); 

    62   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    63   VALUES ("application", 'Videoplayer', 537006590,  'Multimedia' );

    64 

    65 INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Utils', "qtg_large_applications_user" );  

    66   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    67   VALUES ("application", 'ControlPanel', 537026521,  'Utils' );

    68   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    69   VALUES ("application", 'Bluetooth', 268458321,  'Utils' );

    70   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    71   VALUES ("application", 'SW update', 537001519,  'Utils' );

    72   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    73   VALUES ("application", 'eshell', 270498535,  'Utils' );

    74   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 

    75   VALUES ("application", 'Conn. mgr.', 270501072,  'Utils' );

    76 

    77   

    78 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, ICON) VALUES ( 'Games', "txt_applib_dblist_games", "qtg_large_applications_user" );

    79 

    80 SELECT "castoragedb_variant - END" AS " ";

    81 SELECT "------------------------------------" AS " ";

    82