aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/003_UserStore.sql
diff options
context:
space:
mode:
authorCharles Krinke2008-09-28 22:07:05 +0000
committerCharles Krinke2008-09-28 22:07:05 +0000
commit5ddba2a3a780bdfd02a7a99e00edd87d191b16d3 (patch)
tree3a0c2f6c6c27adf14ba13b549384bb600c4c30b2 /OpenSim/Data/MSSQL/Resources/003_UserStore.sql
parentMantis#296. Thank you kindly, Idb for a patch that resolves: (diff)
downloadopensim-SC_OLD-5ddba2a3a780bdfd02a7a99e00edd87d191b16d3.zip
opensim-SC_OLD-5ddba2a3a780bdfd02a7a99e00edd87d191b16d3.tar.gz
opensim-SC_OLD-5ddba2a3a780bdfd02a7a99e00edd87d191b16d3.tar.bz2
opensim-SC_OLD-5ddba2a3a780bdfd02a7a99e00edd87d191b16d3.tar.xz
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.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/003_UserStore.sql')
-rw-r--r--OpenSim/Data/MSSQL/Resources/003_UserStore.sql15
1 files changed, 0 insertions, 15 deletions
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
13 13
14 14
15COMMIT 15COMMIT
16BEGIN TRANSACTION
17
18CREATE TABLE [avatarattachments] (
19 [UUID] varchar(36) NOT NULL
20 , [attachpoint] int NOT NULL
21 , [item] varchar(36) NOT NULL
22 , [asset] varchar(36) NOT NULL)
23
24CREATE NONCLUSTERED INDEX IX_avatarattachments ON dbo.avatarattachments
25 (
26 UUID
27 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
28
29
30COMMIT