equal
deleted
inserted
replaced
177 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
177 -- RELATION TO MAIN COLLECTION (ADD TO GROUP: ) |
178 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
178 INSERT INTO CA_GROUP_ENTRY (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) |
179 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME) , |
179 VALUES ( (SELECT ENTRY_ID FROM CA_ENTRY WHERE EN_TEXT = new.COLLECTION_NAME) , |
180 (SELECT ENTRY_ID FROM CA_ENTRY WHERE (EN_TEXT = new.ITEM_NAME AND EN_TYPE_NAME = new.ITEM_TYPE )), |
180 (SELECT ENTRY_ID FROM CA_ENTRY WHERE (EN_TEXT = new.ITEM_NAME AND EN_TYPE_NAME = new.ITEM_TYPE )), |
181 (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)) ); |
181 (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)) ); |
|
182 -- UPDATE FLAGS IN A COLLECTION TO WHICH THE URL IS INSERTED |
|
183 UPDATE CA_ENTRY |
|
184 SET EN_FLAGS=EN_FLAGS|8 |
|
185 WHERE EN_TEXT=new.COLLECTION_NAME; |
182 END; |
186 END; |
183 |
187 |
184 |
188 |
185 -- CREATE VIEW WIDGET _TO_COLLECTION |
189 -- CREATE VIEW WIDGET _TO_COLLECTION |
186 SELECT "------------------------------------" AS " "; |
190 SELECT "------------------------------------" AS " "; |