aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL
diff options
context:
space:
mode:
authorDiva Canto2011-05-07 14:56:59 -0700
committerDiva Canto2011-05-07 14:56:59 -0700
commit72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6 (patch)
treefd9f0487302f96d57742dfde8b12f69c05d61ecb /OpenSim/Data/MSSQL
parentAdd module with "appearance show" command. (diff)
downloadopensim-SC_OLD-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.zip
opensim-SC_OLD-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.tar.gz
opensim-SC_OLD-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.tar.bz2
opensim-SC_OLD-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.tar.xz
Mantis #5470 -- add forgotten MSSQL's GridUserStore. Thank you MrMonkE
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r--OpenSim/Data/MSSQL/Resources/GridUserStore.migrations19
1 files changed, 19 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/GridUserStore.migrations b/OpenSim/Data/MSSQL/Resources/GridUserStore.migrations
new file mode 100644
index 0000000..7a7cecd
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/GridUserStore.migrations
@@ -0,0 +1,19 @@
1:VERSION 1 # --------------------------
2
3BEGIN TRANSACTION
4
5CREATE TABLE "GridUser" (
6 "UserID" VARCHAR(255) NOT NULL,
7 "HomeRegionID" CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
8 "HomePosition" CHAR(64) NOT NULL DEFAULT '<0,0,0>',
9 "HomeLookAt" CHAR(64) NOT NULL DEFAULT '<0,0,0>',
10 "LastRegionID" CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
11 "LastPosition" CHAR(64) NOT NULL DEFAULT '<0,0,0>',
12 "LastLookAt" CHAR(64) NOT NULL DEFAULT '<0,0,0>',
13 "Online" CHAR(5) NOT NULL DEFAULT 'false',
14 "Login" CHAR(16) NOT NULL DEFAULT '0',
15 "Logout" CHAR(16) NOT NULL DEFAULT '0',
16 PRIMARY KEY ("UserID")
17)
18
19COMMIT