Changeset 3971 for branches

Timestamp:

06/28/10 19:06:43 (14 years ago)

Author:

bfarka

Message:

creating unique index for username, email and rolename (#1062)

Location:

branches/HeuristicLab.Services.Authentication Prototype

Files:

• Persistence/DatabaseUtil.cs (modified) (2 diffs)
• Service/Services (added)
• Service/Services/Administration (added)
• Service/Services/Administration/AuthorizationManagementService.cs (added)
• Service/Services/Administration/IAuthorizationManagementService.cs (added)

branches/HeuristicLab.Services.Authentication Prototype/Persistence/DatabaseUtil.cs

@@ -1 +1 @@
 using System;
 using System.Diagnostics;
+using System.Data.Common;
 
 namespace Persistence {
@@ -45 +46 @@
       Console.WriteLine("Creating new database...");
       db.CreateDatabase();
+      
+      DbCommand command = db.Connection.CreateCommand();
+      command.CommandText = "CREATE UNIQUE NONCLUSTERED INDEX [IDXRoleName] ON [dbo].[HeuristicLabRole](  [roleName] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]";
+      command.ExecuteNonQuery();
+
+      command.CommandText = "CREATE UNIQUE NONCLUSTERED INDEX [IDXUserName] ON [dbo].[HeuristicLabUser](  [UserName] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]";
+      command.ExecuteNonQuery();
+      command.CommandText = "CREATE UNIQUE NONCLUSTERED INDEX [IDXUserEmail] ON [dbo].[HeuristicLabUser](   [Email] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]";
+      command.ExecuteNonQuery();
       Console.WriteLine("Created new database!");
     }