Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
08/20/10 09:54:05 (12 years ago)
Author:
cneumuel
Message:

fixed invalid plugin-directory (#1159)

Location:
branches/3.3-HiveMigration/tools
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/3.3-HiveMigration/tools/cleanHiveDatabase.sql

    r4159 r4269  
    44DELETE FROM [HeuristicLab.Hive].[dbo].UptimeStatistics
    55DELETE FROM [HeuristicLab.Hive].[dbo].UptimeCalendar
    6 DELETE FROM [HeuristicLab.Hive].[dbo].ClientConfig
    7 DELETE FROM [HeuristicLab.Hive].[dbo].ClientGroup_Resource
     6DELETE FROM [HeuristicLab.Hive].[dbo].SlaveConfig
     7DELETE FROM [HeuristicLab.Hive].[dbo].SlaveGroup_Resource
    88DELETE FROM [HeuristicLab.Hive].[dbo].[Resource]
    99DELETE FROM [HeuristicLab.Hive].[dbo].Job
  • branches/3.3-HiveMigration/tools/prepareHiveDatabase.sql

    r4170 r4269  
    66ALTER TABLE dbo.AssignedResources ALTER COLUMN AssignedRessourcesId DROP ROWGUIDCOL;
    77ALTER TABLE dbo.Job ALTER COLUMN JobId DROP ROWGUIDCOL;
    8 ALTER TABLE dbo.ClientConfig ALTER COLUMN ClientConfigId DROP ROWGUIDCOL;
    9 ALTER TABLE dbo.ClientGroup_Resource ALTER COLUMN ClientGroup_RessourceId DROP ROWGUIDCOL;
     8ALTER TABLE dbo.SlaveConfig ALTER COLUMN SlaveConfigId DROP ROWGUIDCOL;
     9ALTER TABLE dbo.SlaveGroup_Resource ALTER COLUMN SlaveGroup_RessourceId DROP ROWGUIDCOL;
    1010ALTER TABLE dbo.PluginInfo ALTER COLUMN PluginId DROP ROWGUIDCOL;
    1111ALTER TABLE dbo.Project ALTER COLUMN ProjectId DROP ROWGUIDCOL;
     
    1717ALTER TABLE dbo.AssignedResources DROP CONSTRAINT [DF_AssignedResources_AssignedRessourcesId];
    1818ALTER TABLE dbo.Job DROP CONSTRAINT [DF_Job_JobId];
    19 ALTER TABLE dbo.ClientConfig DROP CONSTRAINT [DF_ClientConfig_ClientConfigId];
    20 ALTER TABLE dbo.ClientGroup_Resource DROP CONSTRAINT [DF_ClientGroup_ResourceClientGroup_RessourceId];
     19ALTER TABLE dbo.SlaveConfig DROP CONSTRAINT [DF_SlaveConfig_SlaveConfigId];
     20ALTER TABLE dbo.SlaveGroup_Resource DROP CONSTRAINT [DF_SlaveGroup_ResourceSlaveGroup_RessourceId];
    2121ALTER TABLE dbo.PluginInfo DROP CONSTRAINT [DF_PluginInfo_PluginId];
    2222ALTER TABLE dbo.Project DROP CONSTRAINT [DF_Project_ProjectId];
     
    3434ALTER TABLE dbo.Job WITH NOCHECK ADD CONSTRAINT [DF_Job_JobId] DEFAULT (newid()) FOR JobId;
    3535
    36 ALTER TABLE dbo.ClientConfig ALTER COLUMN ClientConfigId ADD ROWGUIDCOL;
    37 ALTER TABLE dbo.ClientConfig WITH NOCHECK ADD CONSTRAINT [DF_ClientConfig_ClientConfigId] DEFAULT (newid()) FOR ClientConfigId;
     36ALTER TABLE dbo.SlaveConfig ALTER COLUMN SlaveConfigId ADD ROWGUIDCOL;
     37ALTER TABLE dbo.SlaveConfig WITH NOCHECK ADD CONSTRAINT [DF_SlaveConfig_SlaveConfigId] DEFAULT (newid()) FOR SlaveConfigId;
    3838
    39 ALTER TABLE dbo.ClientGroup_Resource ALTER COLUMN ClientGroup_RessourceId ADD ROWGUIDCOL;
    40 ALTER TABLE dbo.ClientGroup_Resource WITH NOCHECK ADD CONSTRAINT [DF_ClientGroup_Resource_ClientGroup_RessourceId] DEFAULT (newid()) FOR ClientGroup_RessourceId;
     39ALTER TABLE dbo.SlaveGroup_Resource ALTER COLUMN SlaveGroup_RessourceId ADD ROWGUIDCOL;
     40ALTER TABLE dbo.SlaveGroup_Resource WITH NOCHECK ADD CONSTRAINT [DF_SlaveGroup_Resource_SlaveGroup_RessourceId] DEFAULT (newid()) FOR SlaveGroup_RessourceId;
    4141
    4242ALTER TABLE dbo.PluginInfo ALTER COLUMN PluginId ADD ROWGUIDCOL;
Note: See TracChangeset for help on using the changeset viewer.