Add the missing resource files for MSSQL

Mantis #3800

2 files changed, 24 insertions, 0 deletions

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