contentstorage/castorage/data/castoragedb_create.sql
changeset 119 50e220be30d1
parent 107 b34d53f6acdf
child 125 26079c1bb561
--- a/contentstorage/castorage/data/castoragedb_create.sql	Mon Sep 13 13:26:33 2010 +0300
+++ b/contentstorage/castorage/data/castoragedb_create.sql	Mon Sep 20 10:22:22 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;