From 281955949910eb257b5f7e42e54535ba7812418e Mon Sep 17 00:00:00 2001
From: Melanie Thielker
Date: Sun, 14 Sep 2008 13:23:02 +0000
Subject: Mantis #2124 Thank you, RuudL, for a patch that brings MSSQL up to
 the same implementation level as MySQL.

---
 OpenSim/Data/MSSQL/Resources/004_RegionStore.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(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
index 4e64901..15b39a7 100644
--- a/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql
@@ -1,6 +1,6 @@
 BEGIN TRANSACTION
 
-CREATE TABLE dbo.Tmp_primitems
+CREATE TABLE Tmp_primitems
 	(
 	itemID varchar(36) NOT NULL,
 	primID varchar(36) NULL,
@@ -22,15 +22,15 @@ CREATE TABLE dbo.Tmp_primitems
 	groupPermissions int NULL
 	)  ON [PRIMARY]
 
-IF EXISTS(SELECT * FROM dbo.primitems)
-	 EXEC('INSERT INTO dbo.Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions)
+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 dbo.primitems
+DROP TABLE primitems
 
-EXECUTE sp_rename N'dbo.Tmp_primitems', N'primitems', 'OBJECT' 
+EXECUTE sp_rename N'Tmp_primitems', N'primitems', 'OBJECT' 
 
-ALTER TABLE dbo.primitems ADD CONSTRAINT
+ALTER TABLE primitems ADD CONSTRAINT
 	PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED 
 	(
 	itemID
-- 
cgit v1.1

