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

2 files changed, 0 insertions, 12 deletions

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