aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/002_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/002_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 '')
-rw-r--r--OpenSim/Data/MSSQL/Resources/002_UserStore.sql9
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 '';
7ALTER TABLE users ADD partner varchar(36) not null default '00000000-0000-0000-0000-000000000000'; 7ALTER TABLE users ADD partner varchar(36) not null default '00000000-0000-0000-0000-000000000000';
8 8
9COMMIT 9COMMIT
10BEGIN TRANSACTION
11
12ALTER TABLE users ADD homeRegionID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
13ALTER TABLE users ADD userFlags int NOT NULL default 0;
14ALTER TABLE users ADD godLevel int NOT NULL default 0;
15ALTER TABLE users ADD customType varchar(32) not null default '';
16ALTER TABLE users ADD partner varchar(36) not null default '00000000-0000-0000-0000-000000000000';
17
18COMMIT