- Timestamp:
- 05/08/13 14:43:44 (11 years ago)
- Location:
- branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql
r9123 r9469 88 88 ) 89 89 CREATE TABLE [dbo].[TaskData]( 90 [TaskId] UniqueIdentifier NOT NULL,91 [Data] VarBinary(MAX) NOT NULL,90 [TaskId] UniqueIdentifier RowGuidCol NOT NULL, 91 [Data] VarBinary(MAX) Filestream NOT NULL, 92 92 [LastUpdate] DateTime NOT NULL, 93 93 CONSTRAINT [PK_dbo.TaskData] PRIMARY KEY ([TaskId]) 94 94 ) 95 95 CREATE TABLE [dbo].[PluginData]( 96 [PluginDataId] UniqueIdentifier NOT NULL,96 [PluginDataId] UniqueIdentifier RowGuidCol NOT NULL, 97 97 [PluginId] UniqueIdentifier NOT NULL, 98 [Data] VarBinary(MAX) NOT NULL,98 [Data] VarBinary(MAX) FileStream NOT NULL, 99 99 [FileName] VarChar(MAX) NOT NULL, 100 100 CONSTRAINT [PK_dbo.PluginData] PRIMARY KEY ([PluginDataId]) -
branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql
r7916 r9469 41 41 ALTER TABLE dbo.Plugin WITH NOCHECK ADD CONSTRAINT [DF_Plugin_PluginId] DEFAULT (NEWSEQUENTIALID()) FOR PluginId; 42 42 43 ALTER TABLE dbo.PluginData ALTER COLUMN PluginDataId ADD ROWGUIDCOL;44 43 ALTER TABLE dbo.PluginData WITH NOCHECK ADD CONSTRAINT [DF_PluginData_PluginDataId] DEFAULT (NEWSEQUENTIALID()) FOR PluginDataId; 45 44
Note: See TracChangeset
for help on using the changeset viewer.