contentstorage/castorage/data/castoragedb_variant.sql
changeset 107 b34d53f6acdf
parent 106 e78d6e055a5b
child 112 dbfb5e38438b
equal deleted inserted replaced
106:e78d6e055a5b 107:b34d53f6acdf
     1 SELECT "------------------------------------" AS " ";
       
     2 SELECT "castoragedb_variant - BEGIN" AS " ";
       
     3 
       
     4 
       
     5 -- insert additional items
       
     6 
       
     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) 
       
     9   VALUES ("application", 'calendar', 268458241,  'Favorites' );
       
    10   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
       
    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', 222222223,  '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)', 222222224,  'Favorites' );
       
    32 
       
    33 
       
    34 SELECT "castoragedb_variant - END" AS " ";
       
    35 SELECT "------------------------------------" AS " ";
       
    36