diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/Presence.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Presence.migrations | 25 |
1 files changed, 2 insertions, 23 deletions
diff --git a/OpenSim/Data/MySQL/Resources/Presence.migrations b/OpenSim/Data/MySQL/Resources/Presence.migrations index d513024..91f7de5 100644 --- a/OpenSim/Data/MySQL/Resources/Presence.migrations +++ b/OpenSim/Data/MySQL/Resources/Presence.migrations | |||
@@ -4,32 +4,11 @@ BEGIN; | |||
4 | 4 | ||
5 | CREATE TABLE `Presence` ( | 5 | CREATE TABLE `Presence` ( |
6 | `UserID` VARCHAR(255) NOT NULL, | 6 | `UserID` VARCHAR(255) NOT NULL, |
7 | `RegionID` CHAR(36) NOT NULL, | 7 | `RegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
8 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 8 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
9 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 9 | `SecureSessionID` CHAR(36) 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 | ) ENGINE=InnoDB; | 10 | ) ENGINE=InnoDB; |
16 | 11 | ||
17 | COMMIT; | ||
18 | |||
19 | :VERSION 2 # -------------------------- | ||
20 | |||
21 | BEGIN; | ||
22 | |||
23 | ALTER TABLE Presence ADD COLUMN `HomeRegionID` CHAR(36) NOT NULL; | ||
24 | ALTER TABLE Presence ADD COLUMN `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>'; | ||
25 | ALTER TABLE Presence ADD COLUMN `HomeLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>'; | ||
26 | |||
27 | COMMIT; | ||
28 | |||
29 | :VERSION 3 # -------------------------- | ||
30 | |||
31 | BEGIN; | ||
32 | |||
33 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); | 12 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); |
34 | CREATE INDEX UserID ON Presence(UserID); | 13 | CREATE INDEX UserID ON Presence(UserID); |
35 | 14 | ||