From 464c3c709102954e502a5d3868bac615c73c64b4 Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Mon, 29 Sep 2008 20:26:34 +0000
Subject: * Add missing mssql migration files from
 http://opensimulator.org/mantis/view.php?id=2295 * Sorry about that

---
 OpenSim/Data/MSSQL/Resources/007_RegionStore.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 OpenSim/Data/MSSQL/Resources/007_RegionStore.sql

(limited to 'OpenSim/Data/MSSQL/Resources/007_RegionStore.sql')

diff --git a/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql
new file mode 100644
index 0000000..684f937
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql
@@ -0,0 +1,10 @@
+BEGIN TRANSACTION
+
+ALTER TABLE prims ADD ColorR int not null default 0;
+ALTER TABLE prims ADD ColorG int not null default 0;
+ALTER TABLE prims ADD ColorB int not null default 0;
+ALTER TABLE prims ADD ColorA int not null default 0;
+ALTER TABLE prims ADD ParticleSystem IMAGE;
+ALTER TABLE prims ADD ClickAction tinyint NOT NULL default 0;
+
+COMMIT
-- 
cgit v1.1