contentstorage/castorage/tsrc/t_castorage/data/castoragedb_variant_test.sql
changeset 117 c63ee96dbe5f
equal deleted inserted replaced
115:3ab5c078b490 117:c63ee96dbe5f
       
     1 -- ONLY IF YOU SURE THAT WANT DEFAULT CONTENT
       
     2 .read castoragedb_variant.sql
       
     3 
       
     4 SELECT "castoragedb_variant test - BEGIN" AS " ";
       
     5 
       
     6 
       
     7 SELECT "." AS " ";
       
     8 INSERT INTO CA_ICON (IC_FILENAME) 
       
     9 VALUES ( 'z:\resource\apps\wsficons.mif');
       
    10 
       
    11 SELECT "." AS " ";
       
    12 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_UID, EN_ICON_ID )  
       
    13 VALUES ( 'RealPlayer', 1, "application", 268458558 , 4  );
       
    14 
       
    15 SELECT "." AS " ";
       
    16 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_UID, EN_ICON_ID )  
       
    17 VALUES ( 'Videos & TV', 1, "application", 537006586 , 4  );
       
    18 
       
    19 
       
    20 -- insert collection
       
    21 INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Favorites', "qtg_large_applications_user" );
       
    22 
       
    23 -- insert example urls
       
    24   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ICON,ITEM_DEST, COLLECTION_NAME) 
       
    25   VALUES ("url", 'Facebook', 'c:\data\Images\kqticaicons\facebook.png', "http://www.facebook.com/",  'Favorites' );
       
    26   INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ICON,ITEM_DEST, COLLECTION_NAME) 
       
    27   VALUES ("url", 'Google', 'c:\data\Images\kqticaicons\google.png', "http://www.google.com/",  'Favorites' );
       
    28 
       
    29 -- insert example widgets
       
    30   INSERT INTO WIDGET_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ICON, PACKAGE_UID, LIBRARY, URI, COLLECTION_NAME) 
       
    31   VALUES ("widget", 'aClock', 'Z:\private\20022F35\import\widgetregistry\20022F6C\tclock.png',  '20022f43', 'Z:\private\20022F35\import\widgetregistry\20022F43\hsclockwidgetprovider.dll', 'homescreen.nokia.com/widget/clock', 'Office' ); 
       
    32   
       
    33 
       
    34 
       
    35 SELECT "castoragedb_variant test - END" AS " ";