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/002_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/002_UserStore.sql | 9 |
1 files changed, 0 insertions, 9 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/002_UserStore.sql b/OpenSim/Data/MSSQL/Resources/002_UserStore.sql index a3b5868..402eddf 100644 --- a/OpenSim/Data/MSSQL/Resources/002_UserStore.sql +++ b/OpenSim/Data/MSSQL/Resources/002_UserStore.sql | |||
@@ -7,12 +7,3 @@ ALTER TABLE users ADD customType varchar(32) not null default ''; | |||
7 | ALTER TABLE users ADD partner varchar(36) not null default '00000000-0000-0000-0000-000000000000'; | 7 | ALTER TABLE users ADD partner varchar(36) not null default '00000000-0000-0000-0000-000000000000'; |
8 | 8 | ||
9 | COMMIT | 9 | COMMIT |
10 | BEGIN TRANSACTION | ||
11 | |||
12 | ALTER TABLE users ADD homeRegionID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; | ||
13 | ALTER TABLE users ADD userFlags int NOT NULL default 0; | ||
14 | ALTER TABLE users ADD godLevel int NOT NULL default 0; | ||
15 | ALTER TABLE users ADD customType varchar(32) not null default ''; | ||
16 | ALTER TABLE users ADD partner varchar(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
17 | |||
18 | COMMIT | ||