diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/004_RegionStore.sql | 12 |
1 files changed, 6 insertions, 6 deletions
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 @@ | |||
1 | BEGIN TRANSACTION | 1 | BEGIN TRANSACTION |
2 | 2 | ||
3 | CREATE TABLE dbo.Tmp_primitems | 3 | CREATE TABLE Tmp_primitems |
4 | ( | 4 | ( |
5 | itemID varchar(36) NOT NULL, | 5 | itemID varchar(36) NOT NULL, |
6 | primID varchar(36) NULL, | 6 | primID varchar(36) NULL, |
@@ -22,15 +22,15 @@ CREATE TABLE dbo.Tmp_primitems | |||
22 | groupPermissions int NULL | 22 | groupPermissions int NULL |
23 | ) ON [PRIMARY] | 23 | ) ON [PRIMARY] |
24 | 24 | ||
25 | IF EXISTS(SELECT * FROM dbo.primitems) | 25 | IF EXISTS(SELECT * FROM primitems) |
26 | EXEC('INSERT INTO dbo.Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions) | 26 | EXEC('INSERT INTO Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions) |
27 | 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') | 27 | 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') |
28 | 28 | ||
29 | DROP TABLE dbo.primitems | 29 | DROP TABLE primitems |
30 | 30 | ||
31 | EXECUTE sp_rename N'dbo.Tmp_primitems', N'primitems', 'OBJECT' | 31 | EXECUTE sp_rename N'Tmp_primitems', N'primitems', 'OBJECT' |
32 | 32 | ||
33 | ALTER TABLE dbo.primitems ADD CONSTRAINT | 33 | ALTER TABLE primitems ADD CONSTRAINT |
34 | PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED | 34 | PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED |
35 | ( | 35 | ( |
36 | itemID | 36 | itemID |