From dfeb9a0b5c07a85ec8aed591206468cee83ce637 Mon Sep 17 00:00:00 2001
From: AlexRa
Date: Thu, 6 May 2010 23:16:36 +0300
Subject: MS SQL migrations converted to the new format

---
 OpenSim/Data/MSSQL/Resources/006_RegionStore.sql | 36 ------------------------
 1 file changed, 36 deletions(-)
 delete mode 100644 OpenSim/Data/MSSQL/Resources/006_RegionStore.sql

(limited to 'OpenSim/Data/MSSQL/Resources/006_RegionStore.sql')

diff --git a/OpenSim/Data/MSSQL/Resources/006_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/006_RegionStore.sql
deleted file mode 100644
index 0419c0c..0000000
--- a/OpenSim/Data/MSSQL/Resources/006_RegionStore.sql
+++ /dev/null
@@ -1,36 +0,0 @@
-BEGIN TRANSACTION
-
-ALTER TABLE prims ADD PayPrice int not null default 0
-ALTER TABLE prims ADD PayButton1 int not null default 0
-ALTER TABLE prims ADD PayButton2 int not null default 0
-ALTER TABLE prims ADD PayButton3 int not null default 0
-ALTER TABLE prims ADD PayButton4 int not null default 0
-ALTER TABLE prims ADD LoopedSound varchar(36) not null default '00000000-0000-0000-0000-000000000000';
-ALTER TABLE prims ADD LoopedSoundGain float not null default 0.0;
-ALTER TABLE prims ADD TextureAnimation image
-ALTER TABLE prims ADD OmegaX float not null default 0.0
-ALTER TABLE prims ADD OmegaY float not null default 0.0
-ALTER TABLE prims ADD OmegaZ float not null default 0.0
-ALTER TABLE prims ADD CameraEyeOffsetX float not null default 0.0
-ALTER TABLE prims ADD CameraEyeOffsetY float not null default 0.0
-ALTER TABLE prims ADD CameraEyeOffsetZ float not null default 0.0
-ALTER TABLE prims ADD CameraAtOffsetX float not null default 0.0
-ALTER TABLE prims ADD CameraAtOffsetY float not null default 0.0
-ALTER TABLE prims ADD CameraAtOffsetZ float not null default 0.0
-ALTER TABLE prims ADD ForceMouselook tinyint not null default 0
-ALTER TABLE prims ADD ScriptAccessPin int not null default 0
-ALTER TABLE prims ADD AllowedDrop tinyint not null default 0
-ALTER TABLE prims ADD DieAtEdge tinyint not null default 0
-ALTER TABLE prims ADD SalePrice int not null default 10
-ALTER TABLE prims ADD SaleType tinyint not null default 0
-
-ALTER TABLE primitems add flags integer not null default 0
-
-ALTER TABLE land ADD AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'
-
-CREATE index prims_regionuuid on prims(RegionUUID)
-CREATE index prims_parentid on prims(ParentID)
-
-CREATE index primitems_primid on primitems(primID)
-
-COMMIT
-- 
cgit v1.1

