diff options
author | Diva Canto | 2010-05-20 20:24:50 -0700 |
---|---|---|
committer | Diva Canto | 2010-05-20 20:24:50 -0700 |
commit | 213e372253eb8a59f0afb627e11b0a5b6f6b088f (patch) | |
tree | 14fa5d7df3f94380d741f68241f98f5d3088b0c2 /OpenSim/Data/MySQL | |
parent | Removed sessionID from GridUserservice again. Removed parcel crossing detecti... (diff) | |
download | opensim-SC-213e372253eb8a59f0afb627e11b0a5b6f6b088f.zip opensim-SC-213e372253eb8a59f0afb627e11b0a5b6f6b088f.tar.gz opensim-SC-213e372253eb8a59f0afb627e11b0a5b6f6b088f.tar.bz2 opensim-SC-213e372253eb8a59f0afb627e11b0a5b6f6b088f.tar.xz |
Cleaned up MySql migrations a bit more, got rid of all old-form migration files. Restored Presence table to its taboo-breaking form.
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/007_AssetStore.sql | 5 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/033_RegionStore.sql | 3 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/GridUserStore.migrations (renamed from OpenSim/Data/MySQL/Resources/001_GridUserStore.sql) | 2 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Presence.migrations | 25 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 5 |
5 files changed, 8 insertions, 32 deletions
diff --git a/OpenSim/Data/MySQL/Resources/007_AssetStore.sql b/OpenSim/Data/MySQL/Resources/007_AssetStore.sql deleted file mode 100644 index f06121a..0000000 --- a/OpenSim/Data/MySQL/Resources/007_AssetStore.sql +++ /dev/null | |||
@@ -1,5 +0,0 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0; | ||
4 | |||
5 | COMMIT; | ||
diff --git a/OpenSim/Data/MySQL/Resources/033_RegionStore.sql b/OpenSim/Data/MySQL/Resources/033_RegionStore.sql deleted file mode 100644 index 2832b41..0000000 --- a/OpenSim/Data/MySQL/Resources/033_RegionStore.sql +++ /dev/null | |||
@@ -1,3 +0,0 @@ | |||
1 | BEGIN; | ||
2 | ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
3 | COMMIT; | ||
diff --git a/OpenSim/Data/MySQL/Resources/001_GridUserStore.sql b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations index ce4ab96..32b85ee 100644 --- a/OpenSim/Data/MySQL/Resources/001_GridUserStore.sql +++ b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations | |||
@@ -1,3 +1,5 @@ | |||
1 | :VERSION 1 # -------------------------- | ||
2 | |||
1 | BEGIN; | 3 | BEGIN; |
2 | 4 | ||
3 | CREATE TABLE `GridUser` ( | 5 | CREATE TABLE `GridUser` ( |
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 | ||
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index 3dab67e..baeeedd 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -801,6 +801,9 @@ BEGIN; | |||
801 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; | 801 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; |
802 | COMMIT; | 802 | COMMIT; |
803 | 803 | ||
804 | :VERSION 33 #--------------------- | ||
804 | 805 | ||
805 | 806 | BEGIN; | |
807 | ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
808 | COMMIT; | ||
806 | 809 | ||