contentstorage/castorage/data/castoragedb_create.sql
changeset 124 e36b2f4799c0
parent 109 e0aa398e6810
--- a/contentstorage/castorage/data/castoragedb_create.sql	Fri Sep 17 08:32:18 2010 +0300
+++ b/contentstorage/castorage/data/castoragedb_create.sql	Mon Oct 04 00:38:31 2010 +0300
@@ -179,6 +179,10 @@
   VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME) , 
           (SELECT ENTRY_ID FROM CA_ENTRY WHERE (EN_TEXT = new.ITEM_NAME AND EN_TYPE_NAME = new.ITEM_TYPE )),
           (SELECT IFNULL(MAX(GE_POSITION)+1, 1) FROM CA_GROUP_ENTRY WHERE GE_GROUP_ID = (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME)) );
+  -- UPDATE FLAGS IN A COLLECTION TO WHICH THE URL IS INSERTED
+  UPDATE CA_ENTRY
+        SET EN_FLAGS=EN_FLAGS|8
+        WHERE EN_TEXT=new.COLLECTION_NAME;
 END;