From 5ddba2a3a780bdfd02a7a99e00edd87d191b16d3 Mon Sep 17 00:00:00 2001
From: Charles Krinke
Date: Sun, 28 Sep 2008 22:07:05 +0000
Subject: Mantis#2291. Thank you kindly, StrawberryFride for a patch that
 solves: User server won't start up for a MSSQL grid migrating from a
 significantly older version to current version due to duplication in three of
 the migrations code files. Patch included takes out the duplicated code from
 the three files so a smooth update should happen on start up.

---
 OpenSim/Data/MSSQL/Resources/003_UserStore.sql | 15 ---------------
 1 file changed, 15 deletions(-)

(limited to 'OpenSim/Data/MSSQL/Resources/003_UserStore.sql')

diff --git a/OpenSim/Data/MSSQL/Resources/003_UserStore.sql b/OpenSim/Data/MSSQL/Resources/003_UserStore.sql
index c2821e6..cb507c9 100644
--- a/OpenSim/Data/MSSQL/Resources/003_UserStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/003_UserStore.sql
@@ -13,18 +13,3 @@ CREATE NONCLUSTERED INDEX IX_avatarattachments ON dbo.avatarattachments
 
 
 COMMIT
-BEGIN TRANSACTION
-
-CREATE TABLE [avatarattachments] (
-	[UUID] varchar(36) NOT NULL
-	, [attachpoint] int NOT NULL
-	, [item] varchar(36) NOT NULL
-	, [asset] varchar(36) NOT NULL)
-
-CREATE NONCLUSTERED INDEX IX_avatarattachments ON dbo.avatarattachments
-	(
-	UUID
-	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-
-
-COMMIT
-- 
cgit v1.1

