aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/Presence.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-06 23:16:36 +0300
committerAlexRa2010-05-18 22:16:13 +0300
commit020f38774fbe8e0f53b0cb28ab49b378b9dcd325 (patch)
tree5d936d6450d580cf24e133047df7ff8d759de557 /OpenSim/Data/MSSQL/Resources/Presence.migrations
parentMigrations for SQLite converted to new format (diff)
downloadopensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.zip
opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.gz
opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.bz2
opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.xz
MS SQL migrations converted to the new format
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/Presence.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/Presence.migrations30
1 files changed, 30 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/Presence.migrations b/OpenSim/Data/MSSQL/Resources/Presence.migrations
new file mode 100644
index 0000000..35f78e1
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/Presence.migrations
@@ -0,0 +1,30 @@
1:VERSION 1
2
3BEGIN TRANSACTION
4
5CREATE TABLE [Presence] (
6[UserID] varchar(255) NOT NULL,
7[RegionID] uniqueidentifier NOT NULL,
8[SessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
9[SecureSessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
10[Online] char(5) NOT NULL DEFAULT 'false',
11[Login] char(16) NOT NULL DEFAULT '0',
12[Logout] char(16) NOT NULL DEFAULT '0',
13[Position] char(64) NOT NULL DEFAULT '<0,0,0>',
14[LookAt] char(64) NOT NULL DEFAULT '<0,0,0>',
15[HomeRegionID] uniqueidentifier NOT NULL,
16[HomePosition] CHAR(64) NOT NULL DEFAULT '<0,0,0>',
17[HomeLookAt] CHAR(64) NOT NULL DEFAULT '<0,0,0>',
18)
19 ON [PRIMARY]
20
21COMMIT
22
23:VERSION 2
24
25BEGIN TRANSACTION
26
27CREATE UNIQUE INDEX SessionID ON Presence(SessionID);
28CREATE INDEX UserID ON Presence(UserID);
29
30COMMIT \ No newline at end of file