contentstorage/castorage/data/castoragedb_variant.sql
changeset 73 4bc7b118b3df
parent 66 32469d7d46ff
child 80 397d00875918
equal deleted inserted replaced
66:32469d7d46ff 73:4bc7b118b3df
     2 SELECT "castoragedb_variant - BEGIN" AS " ";
     2 SELECT "castoragedb_variant - BEGIN" AS " ";
     3 
     3 
     4 
     4 
     5 -- insert additional items
     5 -- insert additional items
     6 
     6 
     7 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Office',  "txt_applib_dblist_office", 'Office', "qtg_large_applications_user");
     7 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, COL_APP_GROUP_NAME ,ICON, FLAGS) VALUES ( 'Office',  "txt_applib_dblist_office", 'Office', "qtg_large_applications_user", 4 );
     8   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) 
     9   VALUES ("application", 'calendar', 268458241,  'Office' );
     9   VALUES ("application", 'calendar', 268458241,  'Office' );
    10   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) 
    11   VALUES ("application", 'Phonebook', 537014009,  'Office' );
    11   VALUES ("application", 'Phonebook', 537014009,  'Office' );
    12 
    12 
    13 INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Multimedia', 'Multimedia' , "qtg_large_applications_user" );  
    13 INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME ,ICON, FLAGS) VALUES ( 'Multimedia', 'Multimedia' , "qtg_large_applications_user", 4 );  
    14   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) 
    15   VALUES ("application", 'Themes', 268458546,  'Multimedia' );
    15   VALUES ("application", 'Themes', 268458546,  'Multimedia' );
    16   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) 
    17   VALUES ("application", 'Paint Cursor', 537001564,  'Multimedia' ); 
    17   VALUES ("application", 'Paint Cursor', 537001564,  'Multimedia' ); 
    18   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) 
    19   VALUES ("application", 'Videoplayer', 537006590,  'Multimedia' );
    19   VALUES ("application", 'Videoplayer', 537006590,  'Multimedia' );
    20 
    20 
    21 INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Utils', 'Utils', "qtg_large_applications_user" );  
    21 INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME ,ICON, FLAGS) VALUES ( 'Utils', 'Utils', "qtg_large_applications_user", 4 );  
    22   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) 
    23   VALUES ("application", 'ControlPanel', 537026521,  'Utils' );
    23   VALUES ("application", 'ControlPanel', 537026521,  'Utils' );
    24   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) 
    25   VALUES ("application", 'Bluetooth', 268458321,  'Utils' );
    25   VALUES ("application", 'Bluetooth', 268458321,  'Utils' );
    26   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) 
    28   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) 
    29   VALUES ("application", 'eshell', 270498535,  'Utils' );
    29   VALUES ("application", 'eshell', 270498535,  'Utils' );
    30   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) 
    31   VALUES ("application", 'Conn. mgr.', 270501072,  'Utils' );
    31   VALUES ("application", 'Conn. mgr.', 270501072,  'Utils' );
    32   
    32   
    33 INSERT INTO COLLECTION (COLLECTION_NAME, COL_LOCNAME, COL_APP_GROUP_NAME ,ICON) VALUES ( 'Games', "txt_applib_dblist_games", '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", 4 );
    34 
    34 
    35 SELECT "castoragedb_variant - END" AS " ";
    35 SELECT "castoragedb_variant - END" AS " ";
    36 SELECT "------------------------------------" AS " ";
    36 SELECT "------------------------------------" AS " ";
    37 
    37