From 020f38774fbe8e0f53b0cb28ab49b378b9dcd325 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/004_RegionStore.sql | 40 ------------------------
 1 file changed, 40 deletions(-)
 delete mode 100644 OpenSim/Data/MSSQL/Resources/004_RegionStore.sql

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

diff --git a/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql
deleted file mode 100644
index 15b39a7..0000000
--- a/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql
+++ /dev/null
@@ -1,40 +0,0 @@
-BEGIN TRANSACTION
-
-CREATE TABLE Tmp_primitems
-	(
-	itemID varchar(36) NOT NULL,
-	primID varchar(36) NULL,
-	assetID varchar(36) NULL,
-	parentFolderID varchar(36) NULL,
-	invType int NULL,
-	assetType int NULL,
-	name varchar(255) NULL,
-	description varchar(255) NULL,
-	creationDate varchar(255) NULL,
-	creatorID varchar(36) NULL,
-	ownerID varchar(36) NULL,
-	lastOwnerID varchar(36) NULL,
-	groupID varchar(36) NULL,
-	nextPermissions int NULL,
-	currentPermissions int NULL,
-	basePermissions int NULL,
-	everyonePermissions int NULL,
-	groupPermissions int NULL
-	)  ON [PRIMARY]
-
-IF EXISTS(SELECT * FROM primitems)
-	 EXEC('INSERT INTO Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions)
-		SELECT CONVERT(varchar(36), itemID), CONVERT(varchar(36), primID), CONVERT(varchar(36), assetID), CONVERT(varchar(36), parentFolderID), invType, assetType, name, description, creationDate, CONVERT(varchar(36), creatorID), CONVERT(varchar(36), ownerID), CONVERT(varchar(36), lastOwnerID), CONVERT(varchar(36), groupID), nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions')
-
-DROP TABLE primitems
-
-EXECUTE sp_rename N'Tmp_primitems', N'primitems', 'OBJECT' 
-
-ALTER TABLE primitems ADD CONSTRAINT
-	PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED 
-	(
-	itemID
-	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-
-
-COMMIT
-- 
cgit v1.1

