From 7a4c5b067de8d5904db6ef9425697f0d529b9147 Mon Sep 17 00:00:00 2001
From: Justin Clark-Casey (justincc)
Date: Wed, 26 Mar 2014 20:42:53 +0000
Subject: Add MSSQL EstateStore.migrations VERSION 10 transaction to add
 AllowLandMark, AllowParcelChanges and AllowSetHome columns to estate_settings
 table.

Taken from http://opensimulator.org/mantis/view.php?id=7074 by LuciusSirnah.  Thanks!
---
 OpenSim/Data/MSSQL/Resources/EstateStore.migrations | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'OpenSim/Data/MSSQL')

diff --git a/OpenSim/Data/MSSQL/Resources/EstateStore.migrations b/OpenSim/Data/MSSQL/Resources/EstateStore.migrations
index 64b2d2b..b5b1b18 100644
--- a/OpenSim/Data/MSSQL/Resources/EstateStore.migrations
+++ b/OpenSim/Data/MSSQL/Resources/EstateStore.migrations
@@ -331,4 +331,12 @@ ALTER TABLE dbo.estate_map ADD CONSTRAINT
 
 COMMIT
 
+:VERSION 10
 
+BEGIN transaction
+
+ALTER TABLE estate_settings ADD AllowLandmark tinyint NOT NULL default 1;
+ALTER TABLE estate_settings ADD AllowParcelChanges tinyint NOT NULL default 1;
+ALTER TABLE estate_settings ADD AllowSetHome tinyint NOT NULL default 1;
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1