88
|
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 |
-- insert collection
|
93
|
8 |
INSERT INTO COLLECTION (COLLECTION_NAME, ICON) VALUES ( 'Test Apps', "qtg_large_applications_user" );
|
88
|
9 |
|
|
10 |
-- insert example urls
|
93
|
11 |
INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ICON, ITEM_DEST, COLLECTION_NAME)
|
|
12 |
VALUES ("url", 'Facebook', 'c:\data\Images\kqticaicons\facebook.png', "http://www.facebook.com/", 'Test Apps' );
|
|
13 |
INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ICON,ITEM_DEST, COLLECTION_NAME)
|
|
14 |
VALUES ("url", 'Google', 'c:\data\Images\kqticaicons\google.png', "http://www.google.com/", 'Test Apps' );
|
88
|
15 |
|
|
16 |
-- insert example widgets
|
93
|
17 |
INSERT INTO WIDGET_TO_COLLECTION (ITEM_TYPE, ITEM_NAME,ICON, PACKAGE_UID, LIBRARY, LONG_NAME, URI, COLLECTION_NAME)
|
|
18 |
VALUES ("widget", 'Clock', 'Z:\private\20022F35\import\widgetregistry\20022F6C\tclock.png', '20022f6c', 'Z:\private\20022F35\import\widgetregistry\20022F6C\hsclockwidgetplugin', 'Clock', 'hsclockwidgetplugin', 'Test Apps' );
|
88
|
19 |
|
|
20 |
|
|
21 |
SELECT "castoragedb_variant test - END" AS " "; |