contentstorage/castorage/data/castoragedb_variant.sql
author hgs
Fri, 23 Jul 2010 14:03:00 +0300
changeset 106 e78d6e055a5b
parent 94 dbb8300717f7
permissions -rw-r--r--
201029
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
88
hgs
parents:
diff changeset
     1
SELECT "------------------------------------" AS " ";
hgs
parents:
diff changeset
     2
SELECT "castoragedb_variant - BEGIN" AS " ";
hgs
parents:
diff changeset
     3
hgs
parents:
diff changeset
     4
hgs
parents:
diff changeset
     5
-- insert additional items
hgs
parents:
diff changeset
     6
94
hgs
parents: 93
diff changeset
     7
INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME, ICON_FILENAME, FLAGS) VALUES ( 'Favorites', 'Favorites', "qtg_large_applications_user", 4 );
hgs
parents: 93
diff changeset
     8
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
     9
  VALUES ("application", 'calendar', 268458241,  'Favorites' );
hgs
parents: 93
diff changeset
    10
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    11
  VALUES ("application", 'Camera', 270501242,  'Favorites' );
hgs
parents: 93
diff changeset
    12
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    13
  VALUES ("application", 'Contacts', 537014009,  'Favorites' );
hgs
parents: 93
diff changeset
    14
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    15
  VALUES ("application", 'Email', 537023930,  'Favorites' );
hgs
parents: 93
diff changeset
    16
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    17
  VALUES ("application", 'FM Radio', 270530934,  'Favorites' );
hgs
parents: 93
diff changeset
    18
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    19
  VALUES ("application", 'Internet', 222222222,  'Favorites' );
hgs
parents: 93
diff changeset
    20
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
106
hgs
parents: 94
diff changeset
    21
  VALUES ("application", 'Maps', 222222223,  'Favorites' );
94
hgs
parents: 93
diff changeset
    22
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    23
  VALUES ("application", 'Messaging', 537001593,  'Favorites' );
hgs
parents: 93
diff changeset
    24
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    25
  VALUES ("application", 'Music', 270564450,  'Favorites' );
hgs
parents: 93
diff changeset
    26
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    27
  VALUES ("application", 'Photos (camera)', 536913858,  'Favorites' );
hgs
parents: 93
diff changeset
    28
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
hgs
parents: 93
diff changeset
    29
  VALUES ("application", 'Settings', 268458220,  'Favorites' );
hgs
parents: 93
diff changeset
    30
  INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
106
hgs
parents: 94
diff changeset
    31
  VALUES ("application", 'Videos (video camera)', 222222224,  'Favorites' );
88
hgs
parents:
diff changeset
    32
hgs
parents:
diff changeset
    33
hgs
parents:
diff changeset
    34
SELECT "castoragedb_variant - END" AS " ";
hgs
parents:
diff changeset
    35
SELECT "------------------------------------" AS " ";
hgs
parents:
diff changeset
    36