diff -r 0b3699f6c654 -r e36b2f4799c0 contentstorage/castorage/data/castoragedb_create.sql --- 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;