88 CREATE VIEW COLLECTION 

    88 CREATE VIEW COLLECTION 

    89   AS SELECT 

    89   AS SELECT 

    90     "" AS "COLLECTION_NAME",

    90     "" AS "COLLECTION_NAME",

    91     "" AS "COL_LOCNAME",

    91     "" AS "COL_LOCNAME",

    92     "" AS "COL_APP_GROUP_NAME", 

    92     "" AS "COL_APP_GROUP_NAME", 

    94     

    95     

    95 SELECT "  CREATE TRIGGER collection_insert" AS " ";

    96 SELECT "  CREATE TRIGGER collection_insert" AS " ";

    96 CREATE TRIGGER collection_insert INSTEAD OF INSERT ON COLLECTION 

    97 CREATE TRIGGER collection_insert INSTEAD OF INSERT ON COLLECTION 

    97 BEGIN  

    98 BEGIN  

    98   -- INSERT ICON

    99   -- INSERT ICON

   101   -- DELETE IF ICON IS NULL OR IF IT IS DUPLICATE

   102   -- DELETE IF ICON IS NULL OR IF IT IS DUPLICATE

   102   DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND 

   103   DELETE FROM CA_ICON WHERE ICON_ID = last_insert_rowid() AND 

   103       (IC_FILENAME IS NULL OR (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON AND ICON_ID <> last_insert_rowid()) IS NOT NULL);   

   104       (IC_FILENAME IS NULL OR (SELECT ICON_ID FROM CA_ICON WHERE IC_FILENAME = new.ICON AND ICON_ID <> last_insert_rowid()) IS NOT NULL);   

   104   -- INSERT ENTRY

   105   -- INSERT ENTRY

   105     INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_FLAGS, EN_ICON_ID ) 

   106     INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_FLAGS, EN_ICON_ID ) 

   107     -- LOCALIZATION 

   108     -- LOCALIZATION 

   108     INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID ) 

   109     INSERT INTO CA_LOCALIZATION_TEXT ( LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID ) 

   109     VALUES ( 'CA_ENTRY', 'EN_TEXT', new.COL_LOCNAME, ( SELECT last_insert_rowid() ) );

   110     VALUES ( 'CA_ENTRY', 'EN_TEXT', new.COL_LOCNAME, ( SELECT last_insert_rowid() ) );

   110     DELETE FROM CA_LOCALIZATION_TEXT WHERE LT_STRING_ID IS NULL AND LOC_TEXT_ID = last_insert_rowid() ;

   111     DELETE FROM CA_LOCALIZATION_TEXT WHERE LT_STRING_ID IS NULL AND LOC_TEXT_ID = last_insert_rowid() ;

   111     -- RELATION TO MAIN COLLECTION (ADD TO GROUP: )

   112     -- RELATION TO MAIN COLLECTION (ADD TO GROUP: )

   175     "" AS "ICON",

   176     "" AS "ICON",

   176     "" AS "PACKAGE_UID",

   177     "" AS "PACKAGE_UID",

   177     "" AS "LIBRARY",

   178     "" AS "LIBRARY",

   178     "" AS "LONG_NAME",

   179     "" AS "LONG_NAME",

   179     "" AS "URI",

   180     "" AS "URI",

   181 

   182 

   182 SELECT "  CREATE TRIGGER insert_widget_to_collection" AS " ";

   183 SELECT "  CREATE TRIGGER insert_widget_to_collection" AS " ";

   183 CREATE TRIGGER item_to_collection_insert_widget INSTEAD OF INSERT ON WIDGET_TO_COLLECTION WHEN new.ITEM_TYPE="widget"

   184 CREATE TRIGGER item_to_collection_insert_widget INSTEAD OF INSERT ON WIDGET_TO_COLLECTION WHEN new.ITEM_TYPE="widget"

   184 BEGIN

   185 BEGIN

   185   -- INSERT ICON

   186   -- INSERT ICON

   212 INSERT INTO CA_DB_PROPERTIES ( DB_PROPERTY, DB_VALUE ) 

   213 INSERT INTO CA_DB_PROPERTIES ( DB_PROPERTY, DB_VALUE ) 

   213 VALUES ( 'Version', '00001' );

   214 VALUES ( 'Version', '00001' );

   214 INSERT INTO CA_DB_PROPERTIES ( DB_PROPERTY, DB_VALUE ) 

   215 INSERT INTO CA_DB_PROPERTIES ( DB_PROPERTY, DB_VALUE ) 

   215 VALUES ( 'Language', '' );

   216 VALUES ( 'Language', '' );

   216 INSERT INTO CA_DB_PROPERTIES ( DB_PROPERTY, DB_VALUE ) 

   217 INSERT INTO CA_DB_PROPERTIES ( DB_PROPERTY, DB_VALUE ) 

   218 

   219 

   219 -- insert neccessary items

   220 -- insert neccessary items

   220 SELECT "INSERT menucollections ENTRY" AS " ";

   221 SELECT "INSERT menucollections ENTRY" AS " ";

   221 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_UID ) 

   222 INSERT INTO CA_ENTRY (EN_TEXT, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_UID ) 

   222 VALUES ( 'AllCollections', 2, "menucollections", NULL , NULL  );

   223 VALUES ( 'AllCollections', 2, "menucollections", NULL , NULL  );