- Timestamp:
- 05/29/12 14:04:59 (13 years ago)
- Location:
- trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts
- Files:
-
- 2 edited
-
Initialize Hive Database.sql (modified) (2 diffs)
-
Prepare Hive Database.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql
r7857 r7916 42 42 [HbInterval] int NOT NULL, 43 43 [IsDisposable] Bit, 44 [OwnerUserId] UniqueIdentifier, 44 45 CONSTRAINT [PK_dbo.Resource] PRIMARY KEY ([ResourceId]) 46 ) 47 CREATE TABLE [dbo].[ResourcePermission]( 48 [ResourceId] UniqueIdentifier NOT NULL, 49 [GrantedUserId] UniqueIdentifier NOT NULL, 50 [GrantedByUserId] UniqueIdentifier NOT NULL, 51 CONSTRAINT [PK_dbo.ResourcePermission] PRIMARY KEY ([ResourceId], [GrantedUserId]) 45 52 ) 46 53 CREATE TABLE [dbo].[Task]( … … 156 163 ALTER TABLE [dbo].[Resource] 157 164 ADD CONSTRAINT [Resource_Resource] FOREIGN KEY ([ParentResourceId]) REFERENCES [dbo].[Resource]([ResourceId]) 165 ALTER TABLE [dbo].[ResourcePermission] 166 ADD CONSTRAINT [Resource_ResourcePermission] FOREIGN KEY ([ResourceId]) REFERENCES [dbo].[Resource]([ResourceId]) 158 167 ALTER TABLE [dbo].[Task] 159 168 ADD CONSTRAINT [Task_Task] FOREIGN KEY ([ParentTaskId]) REFERENCES [dbo].[Task]([TaskId]) -
trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
r7814 r7916 83 83 ALTER TABLE [dbo].[JobPermission] WITH CHECK ADD CONSTRAINT [Job_JobPermission] FOREIGN KEY([JobId]) 84 84 REFERENCES [dbo].[Job] ([JobId]) 85 ON UPDATE CASCADE 86 ON DELETE CASCADE 87 GO 88 89 ALTER TABLE [dbo].[ResourcePermission] DROP CONSTRAINT [Resource_ResourcePermission] 90 ALTER TABLE [dbo].[ResourcePermission] WITH CHECK ADD CONSTRAINT [Resource_ResourcePermission] FOREIGN KEY([ResourceId]) 91 REFERENCES [dbo].[Resource] ([ResourceId]) 85 92 ON UPDATE CASCADE 86 93 ON DELETE CASCADE
Note: See TracChangeset
for help on using the changeset viewer.
