diff options
author | Diva Canto | 2011-05-07 14:56:59 -0700 |
---|---|---|
committer | Diva Canto | 2011-05-07 14:56:59 -0700 |
commit | 72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6 (patch) | |
tree | fd9f0487302f96d57742dfde8b12f69c05d61ecb | |
parent | Add module with "appearance show" command. (diff) | |
download | opensim-SC-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.zip opensim-SC-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.tar.gz opensim-SC-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.tar.bz2 opensim-SC-72fb0d5b9301d9315a65f7e0c2d88c013e6e73e6.tar.xz |
Mantis #5470 -- add forgotten MSSQL's GridUserStore. Thank you MrMonkE
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/GridUserStore.migrations | 19 |
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 | |||
3 | BEGIN TRANSACTION | ||
4 | |||
5 | CREATE 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 | |||
19 | COMMIT | ||