diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Presence.migrations (renamed from OpenSim/Data/MySQL/Resources/001_Presence.sql) | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_Presence.sql b/OpenSim/Data/MySQL/Resources/Presence.migrations index 84fa057..91f7de5 100644 --- a/OpenSim/Data/MySQL/Resources/001_Presence.sql +++ b/OpenSim/Data/MySQL/Resources/Presence.migrations | |||
@@ -1,8 +1,10 @@ | |||
1 | :VERSION 1 # -------------------------- | ||
2 | |||
1 | BEGIN; | 3 | BEGIN; |
2 | 4 | ||
3 | CREATE TABLE `Presence` ( | 5 | CREATE TABLE `Presence` ( |
4 | `UserID` VARCHAR(255) NOT NULL, | 6 | `UserID` VARCHAR(255) NOT NULL, |
5 | `RegionID` CHAR(36) NOT NULL, | 7 | `RegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
6 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 8 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
7 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' | 9 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' |
8 | ) ENGINE=InnoDB; | 10 | ) ENGINE=InnoDB; |