From 3ee599b900e1d7ecb03b975c04d4e389010c42a7 Mon Sep 17 00:00:00 2001
From: Melanie Thielker
Date: Wed, 17 Jun 2009 14:54:25 +0000
Subject: Add the missing resource files for MSSQL Mantis #3800

---
 OpenSim/Data/MSSQL/Resources/021_RegionStore.sql | 10 ++++++++++
 OpenSim/Data/MSSQL/Resources/022_RegionStore.sql | 14 ++++++++++++++
 2 files changed, 24 insertions(+)
 create mode 100644 OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
 create mode 100644 OpenSim/Data/MSSQL/Resources/022_RegionStore.sql

(limited to 'OpenSim/Data/MSSQL/Resources')

diff --git a/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
new file mode 100644
index 0000000..1734e90
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
@@ -0,0 +1,10 @@
+BEGIN TRANSACTION
+
+ALTER TABLE prims ADD PassTouches bit not null default 0
+
+COMMIT
+BEGIN TRANSACTION
+
+ALTER TABLE prims ADD PassTouches bit not null default 0
+
+COMMIT
diff --git a/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql
new file mode 100644
index 0000000..b5c555d
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql
@@ -0,0 +1,14 @@
+BEGIN TRANSACTION
+
+ALTER TABLE regionsettings ADD loaded_creation_date varchar(20) 
+ALTER TABLE regionsettings ADD loaded_creation_time varchar(20) 
+ALTER TABLE regionsettings ADD loaded_creation_id varchar(64) 
+
+COMMIT
+BEGIN TRANSACTION
+
+ALTER TABLE regionsettings ADD loaded_creation_date varchar(20) 
+ALTER TABLE regionsettings ADD loaded_creation_time varchar(20) 
+ALTER TABLE regionsettings ADD loaded_creation_id varchar(64) 
+
+COMMIT
-- 
cgit v1.1