--- 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;