diff options
author | Charles Krinke | 2008-09-28 22:07:05 +0000 |
---|---|---|
committer | Charles Krinke | 2008-09-28 22:07:05 +0000 |
commit | 5ddba2a3a780bdfd02a7a99e00edd87d191b16d3 (patch) | |
tree | 3a0c2f6c6c27adf14ba13b549384bb600c4c30b2 /OpenSim/Data/MSSQL/Resources/003_UserStore.sql | |
parent | Mantis#296. Thank you kindly, Idb for a patch that resolves: (diff) | |
download | opensim-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 '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/003_UserStore.sql | 15 |
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 | ||
15 | COMMIT | 15 | COMMIT |
16 | BEGIN TRANSACTION | ||
17 | |||
18 | CREATE 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 | |||
24 | CREATE 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 | |||
30 | COMMIT | ||