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_FriendsStore.sql |  2 +-
 OpenSim/Data/MSSQL/Resources/001_UserAccount.sql  | 14 ++++++++++++++
 OpenSim/Data/MSSQL/Resources/002_FriendsStore.sql |  2 +-
 OpenSim/Data/MSSQL/Resources/003_UserAccount.sql  |  9 +++++++++
 OpenSim/Data/MSSQL/Resources/004_UserAccount.sql  |  7 +++++++
 5 files changed, 32 insertions(+), 2 deletions(-)
 create mode 100644 OpenSim/Data/MSSQL/Resources/001_UserAccount.sql
 create mode 100644 OpenSim/Data/MSSQL/Resources/003_UserAccount.sql
 create mode 100644 OpenSim/Data/MSSQL/Resources/004_UserAccount.sql

(limited to 'OpenSim/Data/MSSQL/Resources')

diff --git a/OpenSim/Data/MSSQL/Resources/001_FriendsStore.sql b/OpenSim/Data/MSSQL/Resources/001_FriendsStore.sql
index f6480f7..94d240b 100644
--- a/OpenSim/Data/MSSQL/Resources/001_FriendsStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/001_FriendsStore.sql
@@ -2,7 +2,7 @@ BEGIN TRANSACTION
 
 CREATE TABLE [Friends] (
 [PrincipalID] uniqueidentifier NOT NULL, 
-[FriendID] varchar(255) NOT NULL, 
+[Friend] varchar(255) NOT NULL, 
 [Flags] char(16) NOT NULL DEFAULT '0',
 [Offered] varchar(32) NOT NULL DEFAULT 0)
  ON [PRIMARY]
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]
diff --git a/OpenSim/Data/MSSQL/Resources/002_FriendsStore.sql b/OpenSim/Data/MSSQL/Resources/002_FriendsStore.sql
index 7762a26..e67d20e 100644
--- a/OpenSim/Data/MSSQL/Resources/002_FriendsStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/002_FriendsStore.sql
@@ -1,6 +1,6 @@
 BEGIN TRANSACTION
 
-INSERT INTO Friends (PrincipalID, FriendID, Flags, Offered) SELECT [ownerID], [friendID], [friendPerms], 0 FROM userfriends;
+INSERT INTO Friends (PrincipalID, Friend, Flags, Offered) SELECT [ownerID], [friendID], [friendPerms], 0 FROM userfriends;
 
 
 COMMIT
\ No newline at end of file
diff --git a/OpenSim/Data/MSSQL/Resources/003_UserAccount.sql b/OpenSim/Data/MSSQL/Resources/003_UserAccount.sql
new file mode 100644
index 0000000..da0395b
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/003_UserAccount.sql
@@ -0,0 +1,9 @@
+BEGIN TRANSACTION
+
+CREATE UNIQUE INDEX PrincipalID ON UserAccounts(PrincipalID);
+CREATE INDEX Email ON UserAccounts(Email);
+CREATE INDEX FirstName ON UserAccounts(FirstName);
+CREATE INDEX LastName ON UserAccounts(LastName);
+CREATE INDEX Name ON UserAccounts(FirstName,LastName);
+
+COMMIT
\ No newline at end of file
diff --git a/OpenSim/Data/MSSQL/Resources/004_UserAccount.sql b/OpenSim/Data/MSSQL/Resources/004_UserAccount.sql
new file mode 100644
index 0000000..a9a9021
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/004_UserAccount.sql
@@ -0,0 +1,7 @@
+BEGIN TRANSACTION
+
+ALTER TABLE UserAccounts ADD UserLevel integer NOT NULL DEFAULT 0;
+ALTER TABLE UserAccounts ADD UserFlags integer NOT NULL DEFAULT 0;
+ALTER TABLE UserAccounts ADD UserTitle varchar(64) NOT NULL DEFAULT '';
+
+COMMIT
\ No newline at end of file
-- 
cgit v1.1