- Timestamp:
- 12/13/11 17:01:09 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
r6983 r7185 232 232 GO 233 233 234 235 ALTER TRIGGER [dbo].[tr_StatisticsDeleteCascade] ON [dbo].[Statistics] INSTEAD OF DELETE AS 236 BEGIN 237 DELETE SlaveStatistics FROM deleted, SlaveStatistics WHERE deleted.StatisticsId = SlaveStatistics.StatisticsId 238 -- should also remove UserStatistics here 239 DELETE [Statistics] FROM deleted, [Statistics] WHERE deleted.StatisticsId = [Statistics].StatisticsId 240 END 241 GO 242 243 234 244 -- ============================================================ 235 245 -- Description: Create indices to speed up execution of queries
Note: See TracChangeset
for help on using the changeset viewer.