|
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 " "; |