Changeset 6820 for branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Initialize ClientManagement.sql

Timestamp:

09/22/11 13:06:02 (13 years ago)

Author:

ascheibe

Message:

#1648 some minor fixes in the dto's, database and sql scripts

File:

• branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Initialize ClientManagement.sql (modified) (5 diffs)

branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Initialize ClientManagement.sql

@@ -2 +2 @@
 GO
 
-/****** Object:  Table [dbo].[Resource]    Script Date: 09/19/2011 13:24:05 ******/
+/****** Object:  Table [dbo].[Resource]    Script Date: 09/22/2011 12:53:30 ******/
 SET ANSI_NULLS ON
 GO
@@ -15 +15 @@
   [Type] [nvarchar](max) NOT NULL,
   [ProcessorType] [nvarchar](max) NULL,
-  [NumberOfCores] [int](max) NULL,
+  [NumberOfCores] [int] NULL,
   [IPAddress] [nvarchar](max) NULL,
-  [MemorySize] [int](max) NULL,
+  [MemorySize] [int] NULL,
   [OperatingSystem] [nvarchar](max) NULL,
   [Country] [nvarchar](max) NULL,
   [HeuristicLabVersion] [nvarchar](max) NULL,
+  [ClientType] [nvarchar](max) NULL,
  CONSTRAINT [PK_Resource] PRIMARY KEY CLUSTERED 
 (
@@ -28 +29 @@
 
 GO
-
-/****** Object:  Table [dbo].[ResourceResourceGroup]    Script Date: 09/19/2011 13:24:08 ******/
+/****** Object:  Table [dbo].[ResourceResourceGroup]    Script Date: 09/22/2011 12:53:47 ******/
 SET ANSI_NULLS ON
 GO
@@ -60 +60 @@
 
 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceId]
-GO
 
-/****** Object:  Table [dbo].[ClientLog]    Script Date: 09/19/2011 13:24:11 ******/
+/****** Object:  Table [dbo].[ClientLog]    Script Date: 09/22/2011 12:54:07 ******/
 SET ANSI_NULLS ON
 GO
@@ -90 +89 @@
 GO
 
+/****** Object:  Table [dbo].[User]    Script Date: 09/22/2011 12:54:23 ******/
+SET ANSI_NULLS ON
+GO
 
+SET QUOTED_IDENTIFIER ON
+GO
 
+CREATE TABLE [dbo].[User](
+  [Id] [uniqueidentifier] NOT NULL,
+  [FullName] [nvarchar](max) NULL,
+ CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
+(
+  [Id] ASC
+)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
+) ON [PRIMARY]
 
+GO
 
+/****** Object:  Table [dbo].[UserGroup]    Script Date: 09/22/2011 12:54:35 ******/
+SET ANSI_NULLS ON
+GO
 
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[UserGroup](
+  [Id] [uniqueidentifier] NOT NULL,
+  [Name] [nvarchar](max) NOT NULL,
+  [ParentUserGroup] [uniqueidentifier] NULL,
+ CONSTRAINT [PK_UserGroup] PRIMARY KEY CLUSTERED 
+(
+  [Id] ASC
+)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+GO
+
+/****** Object:  Table [dbo].[UserUserGroup]    Script Date: 09/22/2011 12:54:52 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[UserUserGroup](
+  [UserId] [uniqueidentifier] NOT NULL,
+  [UserGroupId] [uniqueidentifier] NOT NULL,
+ CONSTRAINT [PK_UserUserGroup] PRIMARY KEY CLUSTERED 
+(
+  [UserId] ASC,
+  [UserGroupId] ASC
+)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+GO
+
+ALTER TABLE [dbo].[UserUserGroup]  WITH CHECK ADD  CONSTRAINT [FK_UserUserGroup_User] FOREIGN KEY([UserId])
+REFERENCES [dbo].[User] ([Id])
+GO
+
+ALTER TABLE [dbo].[UserUserGroup] CHECK CONSTRAINT [FK_UserUserGroup_User]
+GO
+
+ALTER TABLE [dbo].[UserUserGroup]  WITH CHECK ADD  CONSTRAINT [FK_UserUserGroup_UserGroup] FOREIGN KEY([UserGroupId])
+REFERENCES [dbo].[UserGroup] ([Id])
+GO
+
+ALTER TABLE [dbo].[UserUserGroup] CHECK CONSTRAINT [FK_UserUserGroup_UserGroup]
+GO