contentstorage/castorage/data/castoragedb_variant.sql
changeset 94 dbb8300717f7
parent 93 82b66994846c
child 106 e78d6e055a5b
equal deleted inserted replaced
93:82b66994846c 94:dbb8300717f7
     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, FLAGS) VALUES ( 'Office',  "txt_applib_dblist_office", 'Office', "qtg_large_applications_user", 4 );
     7 INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME, ICON_FILENAME, FLAGS) VALUES ( 'Favorites', 'Favorites', "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,  'Favorites' );
    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", 'Camera', 270501242,  'Favorites' );
       
    12   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    13   VALUES ("application", 'Contacts', 537014009,  'Favorites' );
       
    14   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    15   VALUES ("application", 'Email', 537023930,  'Favorites' );
       
    16   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    17   VALUES ("application", 'FM Radio', 270530934,  'Favorites' );
       
    18   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    19   VALUES ("application", 'Internet', 222222222,  'Favorites' );
       
    20   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    21   VALUES ("application", 'Maps', 222222222,  'Favorites' );
       
    22   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    23   VALUES ("application", 'Messaging', 537001593,  'Favorites' );
       
    24   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    25   VALUES ("application", 'Music', 270564450,  'Favorites' );
       
    26   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    27   VALUES ("application", 'Photos (camera)', 536913858,  'Favorites' );
       
    28   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    29   VALUES ("application", 'Settings', 268458220,  'Favorites' );
       
    30   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    31   VALUES ("application", 'Videos (video camera)', 222222222,  'Favorites' );
    12 
    32 
    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) 
       
    15   VALUES ("application", 'Themes', 268458546,  'Multimedia' );
       
    16   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 
       
    17   VALUES ("application", 'Paint Cursor', 537001564,  'Multimedia' ); 
       
    18   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 
       
    19   VALUES ("application", 'Videoplayer', 537006590,  'Multimedia' );
       
    20 
       
    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) 
       
    23   VALUES ("application", 'ControlPanel', 537026521,  'Utils' );
       
    24   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 
       
    25   VALUES ("application", 'Bluetooth', 268458321,  'Utils' );
       
    26   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 
       
    27   VALUES ("application", 'SW update', 537001519,  'Utils' );
       
    28   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 
       
    29   VALUES ("application", 'eshell', 270498535,  'Utils' );
       
    30   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ITEM_DEST, COLLECTION_NAME) 
       
    31   VALUES ("application", 'Conn. mgr.', 270501072,  'Utils' );
       
    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", 4 );
       
    34 
    33 
    35 SELECT "castoragedb_variant - END" AS " ";
    34 SELECT "castoragedb_variant - END" AS " ";
    36 SELECT "------------------------------------" AS " ";
    35 SELECT "------------------------------------" AS " ";
    37 
    36