aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources
diff options
context:
space:
mode:
authorMelanie2009-12-28 23:45:15 +0000
committerMelanie2009-12-28 23:45:15 +0000
commitc4f5ac970cc2c43c6a833416d9df918d3c869152 (patch)
tree57cffb232076aa11ea9e75b0be670a9c7c5f84eb /OpenSim/Data/MySQL/Resources
parentAdding new fields and home location methid to presence. Adding cleanup (diff)
downloadopensim-SC_OLD-c4f5ac970cc2c43c6a833416d9df918d3c869152.zip
opensim-SC_OLD-c4f5ac970cc2c43c6a833416d9df918d3c869152.tar.gz
opensim-SC_OLD-c4f5ac970cc2c43c6a833416d9df918d3c869152.tar.bz2
opensim-SC_OLD-c4f5ac970cc2c43c6a833416d9df918d3c869152.tar.xz
Add a migration to add the 3 new fields
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r--OpenSim/Data/MySQL/Resources/002_Presence.sql7
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 @@
1BEGIN;
2
3ALTER TABLE Presence ADD COLUMN `HomeRegionID` CHAR(36) NOT NULL;
4ALTER TABLE Presence ADD COLUMN `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>';
5ALTER TABLE Presence ADD COLUMN `HomeLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>';
6
7COMMIT;