contentstorage/castorage/data/castoragedb_create.sql
changeset 98 d2f833ab7940
parent 94 dbb8300717f7
child 106 e78d6e055a5b
--- a/contentstorage/castorage/data/castoragedb_create.sql	Tue Jun 01 11:30:17 2010 +0300
+++ b/contentstorage/castorage/data/castoragedb_create.sql	Fri Jun 11 16:13:51 2010 +0300
@@ -193,7 +193,6 @@
     "" AS "ICON_SKIN_ID",
     "" AS "PACKAGE_UID",
     "" AS "LIBRARY",
-    "" AS "LONG_NAME",
     "" AS "URI",
     "" AS "COLLECTION_NAME";
 
@@ -216,8 +215,6 @@
   INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE )  
   VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"widget:library",new.LIBRARY);
   INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE )  
-  VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"long_name",new.LONG_NAME);
-  INSERT OR IGNORE INTO CA_ATTRIBUTE (AT_ENTRY_ID, AT_NAME, AT_VALUE )  
   VALUES ( ( SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.ITEM_NAME ) ,"widget:uri",new.URI);
   -- RELATION TO MAIN COLLECTION (ADD TO GROUP: )
   INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION)