Changeset 7814 for trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts

Timestamp:

05/14/12 17:32:21 (13 years ago)

Author:

jkarder

Message:

#1722: fixed trigger creation in Prepare Hive Database.sql

File:

• trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql (modified) (1 diff)

trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

@@ -233 +233 @@
 
 
-ALTER TRIGGER [dbo].[tr_StatisticsDeleteCascade] ON [dbo].[Statistics] INSTEAD OF DELETE AS 
+CREATE TRIGGER [dbo].[tr_StatisticsDeleteCascade] ON [dbo].[Statistics] INSTEAD OF DELETE AS 
 BEGIN
   DELETE SlaveStatistics FROM deleted, SlaveStatistics WHERE deleted.StatisticsId = SlaveStatistics.StatisticsId