portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vku...@apache.org
Subject svn commit: r708147 - /portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
Date Mon, 27 Oct 2008 11:44:53 GMT
Author: vkumar
Date: Mon Oct 27 04:44:52 2008
New Revision: 708147

URL: http://svn.apache.org/viewvc?rev=708147&view=rev
Log:
Adding trigger to mssql scripts

Modified:
    portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql

Modified: portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql?rev=708147&r1=708146&r2=708147&view=diff
==============================================================================
--- portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
(original)
+++ portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/jetspeed-portal-resources/src/main/resources/ddl/mssql/create-schema.sql
Mon Oct 27 04:44:52 2008
@@ -1370,6 +1370,15 @@
     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


Mime
View raw message