From 2755f6b891011682924abee5e5f60b27e77e3453 Mon Sep 17 00:00:00 2001
From: MW
Date: Thu, 18 Jun 2009 20:18:47 +0000
Subject: Applied patch from Mantis #3817, which fixes a error when using
 MSSQL. I don't use MSSQL so couldn't test this myself. But there was
 certainly duplicated instructions in these files...which this patch fixes.
 Thanks Grumly57

---
 OpenSim/Data/MSSQL/Resources/021_RegionStore.sql | 5 -----
 OpenSim/Data/MSSQL/Resources/022_RegionStore.sql | 7 -------
 2 files changed, 12 deletions(-)

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
index 1734e90..ac59182 100644
--- a/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
@@ -3,8 +3,3 @@
 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
index b5c555d..421e8d3 100644
--- a/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql
@@ -5,10 +5,3 @@ 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