From c1352350004064a1722c2aeaaff313c4cc51181a Mon Sep 17 00:00:00 2001
From: unknown
Date: Sun, 7 Mar 2010 23:20:23 +0000
Subject: MSSQL tweaks for latest ROBUST - friends handling fixed, GridUserData
 placeholder added.

Signed-off-by: Melanie <melanie@t-data.com>
---
 OpenSim/Data/MSSQL/Resources/001_UserAccount.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 OpenSim/Data/MSSQL/Resources/001_UserAccount.sql

(limited to 'OpenSim/Data/MSSQL/Resources/001_UserAccount.sql')

diff --git a/OpenSim/Data/MSSQL/Resources/001_UserAccount.sql b/OpenSim/Data/MSSQL/Resources/001_UserAccount.sql
new file mode 100644
index 0000000..3dbf8a4
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/001_UserAccount.sql
@@ -0,0 +1,14 @@
+CREATE TABLE [UserAccounts] (
+  [PrincipalID] uniqueidentifier NOT NULL,
+  [ScopeID] uniqueidentifier NOT NULL,
+  [FirstName] [varchar](64) NOT NULL,
+  [LastName] [varchar](64) NOT NULL,
+  [Email] [varchar](64) NULL,
+  [ServiceURLs] [text] NULL,
+  [Created] [int] default NULL,
+  
+  PRIMARY KEY CLUSTERED
+(
+	[PrincipalID] ASC
+)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
+) ON [PRIMARY]
-- 
cgit v1.1

