From c4f5ac970cc2c43c6a833416d9df918d3c869152 Mon Sep 17 00:00:00 2001
From: Melanie
Date: Mon, 28 Dec 2009 23:45:15 +0000
Subject: Add a migration to add the 3 new fields

---
 OpenSim/Data/MySQL/Resources/002_Presence.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/002_Presence.sql

(limited to 'OpenSim/Data/MySQL/Resources/002_Presence.sql')

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 @@
+BEGIN;
+
+ALTER TABLE Presence ADD COLUMN `HomeRegionID` CHAR(36) NOT NULL;
+ALTER TABLE Presence ADD COLUMN `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>';
+ALTER TABLE Presence ADD COLUMN `HomeLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>';
+
+COMMIT;
-- 
cgit v1.1