You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by vk...@apache.org on 2008/10/27 12:43:40 UTC
svn commit: r708146 -
/portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
Author: vkumar
Date: Mon Oct 27 04:43:39 2008
New Revision: 708146
URL: http://svn.apache.org/viewvc?rev=708146&view=rev
Log:
Adding trigger to mssql scripts
Modified:
portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
Modified: portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql?rev=708146&r1=708145&r2=708146&view=diff
==============================================================================
--- portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql (original)
+++ portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql Mon Oct 27 04:43:39 2008
@@ -1370,6 +1370,14 @@
PRIMARY KEY (COOKIE_ID, REMOTE_PRINCIPAL_ID)
);
+CREATE TRIGGER trig_folder ON FOLDER FOR DELETE AS DECLARE @FolderID INT SELECT @FolderID = (SELECT FOLDER_ID FROM Deleted) DELETE FROM FOLDER WHERE PARENT_ID = @FolderID;
+
+CREATE TRIGGER trig_folder_menu ON FOLDER_MENU FOR DELETE AS DECLARE @MenuID INT SELECT @MenuID = (SELECT MENU_ID FROM Deleted) DELETE FROM FOLDER_MENU WHERE PARENT_ID = @MenuID;
+
+CREATE TRIGGER trig_fragment ON FRAGMENT FOR DELETE AS DECLARE @FragID INT SELECT @FragID = (SELECT FRAGMENT_ID FROM Deleted) DELETE FROM FRAGMENT_ID WHERE PARENT_ID = @FragID;
+
+CREATE TRIGGER trig_page_menu ON PAGE_MENU FOR DELETE AS DECLARE @PageMenuID INT SELECT @PageMenuID = (SELECT MENU_ID FROM Deleted) DELETE FROM PAGE_MENU WHERE PARENT_ID = @PageMenuID;
+
ALTER TABLE FOLDER
ADD CONSTRAINT FK_FOLDER_1 FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID) ON DELETE NO ACTION;
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org