diff options
author | AlexRa | 2010-05-01 17:43:10 +0300 |
---|---|---|
committer | AlexRa | 2010-05-18 22:16:06 +0300 |
commit | e4419c34c30e1cf6529ced125f0c05aed24644a4 (patch) | |
tree | b54d5aff69c63fefc27dea2b938c1838974d77ac /OpenSim/Data/MySQL/Resources/001_Presence.sql | |
parent | Added MySqlMigrations.cs (supports stored proc/funcs) (diff) | |
download | opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.zip opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.gz opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.bz2 opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.xz |
Converted MySQL migration history to the new format
Replaced all NNN_StoreName.sql migration resources with a more
readable, single-file-per-store
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/001_Presence.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_Presence.sql b/OpenSim/Data/MySQL/Resources/001_Presence.sql deleted file mode 100644 index 84fa057..0000000 --- a/OpenSim/Data/MySQL/Resources/001_Presence.sql +++ /dev/null | |||
@@ -1,13 +0,0 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | CREATE TABLE `Presence` ( | ||
4 | `UserID` VARCHAR(255) NOT NULL, | ||
5 | `RegionID` CHAR(36) NOT NULL, | ||
6 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
7 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' | ||
8 | ) ENGINE=InnoDB; | ||
9 | |||
10 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); | ||
11 | CREATE INDEX UserID ON Presence(UserID); | ||
12 | |||
13 | COMMIT; | ||