diff options
| author | Melanie | 2009-12-28 23:45:15 +0000 |
|---|---|---|
| committer | Melanie | 2009-12-28 23:45:15 +0000 |
| commit | c4f5ac970cc2c43c6a833416d9df918d3c869152 (patch) | |
| tree | 57cffb232076aa11ea9e75b0be670a9c7c5f84eb /OpenSim/Data/MySQL/Resources/002_Presence.sql | |
| parent | Adding new fields and home location methid to presence. Adding cleanup (diff) | |
| download | opensim-SC-c4f5ac970cc2c43c6a833416d9df918d3c869152.zip opensim-SC-c4f5ac970cc2c43c6a833416d9df918d3c869152.tar.gz opensim-SC-c4f5ac970cc2c43c6a833416d9df918d3c869152.tar.bz2 opensim-SC-c4f5ac970cc2c43c6a833416d9df918d3c869152.tar.xz | |
Add a migration to add the 3 new fields
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/002_Presence.sql')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/002_Presence.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/002_Presence.sql b/OpenSim/Data/MySQL/Resources/002_Presence.sql new file mode 100644 index 0000000..e65f105 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/002_Presence.sql | |||
| @@ -0,0 +1,7 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | ALTER TABLE Presence ADD COLUMN `HomeRegionID` CHAR(36) NOT NULL; | ||
| 4 | ALTER TABLE Presence ADD COLUMN `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>'; | ||
| 5 | ALTER TABLE Presence ADD COLUMN `HomeLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>'; | ||
| 6 | |||
| 7 | COMMIT; | ||