diff -r 3ab5c078b490 -r c63ee96dbe5f contentstorage/castorage/tsrc/t_castorage/data/castoragedb_variant_test.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/contentstorage/castorage/tsrc/t_castorage/data/castoragedb_variant_test.sql Thu Sep 16 12:11:40 2010 +0100 @@ -0,0 +1,35 @@ +-- ONLY IF YOU SURE THAT WANT DEFAULT CONTENT +.read castoragedb_variant.sql + +SELECT "castoragedb_variant test - BEGIN" AS " "; + + +SELECT "." AS " "; +INSERT INTO CA_ICON (IC_FILENAME) +VALUES ( 'z:\resource\apps\wsficons.mif'); + +SELECT "." AS " "; +INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_UID, EN_ICON_ID ) +VALUES ( 'RealPlayer', 1, "application", 268458558 , 4 ); + +SELECT "." AS " "; +INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_UID, EN_ICON_ID ) +VALUES ( 'Videos & TV', 1, "application", 537006586 , 4 ); + + +-- insert collection +INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Favorites', "qtg_large_applications_user" ); + +-- insert example urls + INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ICON,ITEM_DEST, COLLECTION_NAME) + VALUES ("url", 'Facebook', 'c:\data\Images\kqticaicons\facebook.png', "http://www.facebook.com/", 'Favorites' ); + INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ICON,ITEM_DEST, COLLECTION_NAME) + VALUES ("url", 'Google', 'c:\data\Images\kqticaicons\google.png', "http://www.google.com/", 'Favorites' ); + +-- insert example widgets + INSERT INTO WIDGET_TO_COLLECTION (ITEM_TYPE,ITEM_NAME,ICON, PACKAGE_UID, LIBRARY, URI, COLLECTION_NAME) + 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' ); + + + +SELECT "castoragedb_variant test - END" AS " "; \ No newline at end of file