diff options
author | AlexRa | 2010-05-06 23:16:36 +0300 |
---|---|---|
committer | AlexRa | 2010-05-18 22:16:13 +0300 |
commit | 020f38774fbe8e0f53b0cb28ab49b378b9dcd325 (patch) | |
tree | 5d936d6450d580cf24e133047df7ff8d759de557 /OpenSim/Data/MSSQL/Resources/004_RegionStore.sql | |
parent | Migrations for SQLite converted to new format (diff) | |
download | opensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.zip opensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.gz opensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.bz2 opensim-SC_OLD-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.xz |
MS SQL migrations converted to the new format
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/004_RegionStore.sql | 40 |
1 files changed, 0 insertions, 40 deletions
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 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | CREATE TABLE Tmp_primitems | ||
4 | ( | ||
5 | itemID varchar(36) NOT NULL, | ||
6 | primID varchar(36) NULL, | ||
7 | assetID varchar(36) NULL, | ||
8 | parentFolderID varchar(36) NULL, | ||
9 | invType int NULL, | ||
10 | assetType int NULL, | ||
11 | name varchar(255) NULL, | ||
12 | description varchar(255) NULL, | ||
13 | creationDate varchar(255) NULL, | ||
14 | creatorID varchar(36) NULL, | ||
15 | ownerID varchar(36) NULL, | ||
16 | lastOwnerID varchar(36) NULL, | ||
17 | groupID varchar(36) NULL, | ||
18 | nextPermissions int NULL, | ||
19 | currentPermissions int NULL, | ||
20 | basePermissions int NULL, | ||
21 | everyonePermissions int NULL, | ||
22 | groupPermissions int NULL | ||
23 | ) ON [PRIMARY] | ||
24 | |||
25 | IF EXISTS(SELECT * FROM primitems) | ||
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') | ||
28 | |||
29 | DROP TABLE primitems | ||
30 | |||
31 | EXECUTE sp_rename N'Tmp_primitems', N'primitems', 'OBJECT' | ||
32 | |||
33 | ALTER TABLE primitems ADD CONSTRAINT | ||
34 | PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED | ||
35 | ( | ||
36 | itemID | ||
37 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
38 | |||
39 | |||
40 | COMMIT | ||