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/017_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/017_RegionStore.sql | 56 |
1 files changed, 0 insertions, 56 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/017_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/017_RegionStore.sql deleted file mode 100644 index 3d3dbc0..0000000 --- a/OpenSim/Data/MSSQL/Resources/017_RegionStore.sql +++ /dev/null | |||
@@ -1,56 +0,0 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | CREATE TABLE dbo.Tmp_land | ||
4 | ( | ||
5 | UUID uniqueidentifier NOT NULL, | ||
6 | RegionUUID uniqueidentifier NULL, | ||
7 | LocalLandID int NULL, | ||
8 | Bitmap image NULL, | ||
9 | Name varchar(255) NULL, | ||
10 | Description varchar(255) NULL, | ||
11 | OwnerUUID uniqueidentifier NULL, | ||
12 | IsGroupOwned int NULL, | ||
13 | Area int NULL, | ||
14 | AuctionID int NULL, | ||
15 | Category int NULL, | ||
16 | ClaimDate int NULL, | ||
17 | ClaimPrice int NULL, | ||
18 | GroupUUID uniqueidentifier NULL, | ||
19 | SalePrice int NULL, | ||
20 | LandStatus int NULL, | ||
21 | LandFlags int NULL, | ||
22 | LandingType int NULL, | ||
23 | MediaAutoScale int NULL, | ||
24 | MediaTextureUUID uniqueidentifier NULL, | ||
25 | MediaURL varchar(255) NULL, | ||
26 | MusicURL varchar(255) NULL, | ||
27 | PassHours float(53) NULL, | ||
28 | PassPrice int NULL, | ||
29 | SnapshotUUID uniqueidentifier NULL, | ||
30 | UserLocationX float(53) NULL, | ||
31 | UserLocationY float(53) NULL, | ||
32 | UserLocationZ float(53) NULL, | ||
33 | UserLookAtX float(53) NULL, | ||
34 | UserLookAtY float(53) NULL, | ||
35 | UserLookAtZ float(53) NULL, | ||
36 | AuthbuyerID uniqueidentifier NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'), | ||
37 | OtherCleanTime int NOT NULL DEFAULT ((0)), | ||
38 | Dwell int NOT NULL DEFAULT ((0)) | ||
39 | ) ON [PRIMARY] | ||
40 | TEXTIMAGE_ON [PRIMARY] | ||
41 | |||
42 | IF EXISTS(SELECT * FROM dbo.land) | ||
43 | EXEC('INSERT INTO dbo.Tmp_land (UUID, RegionUUID, LocalLandID, Bitmap, Name, Description, OwnerUUID, IsGroupOwned, Area, AuctionID, Category, ClaimDate, ClaimPrice, GroupUUID, SalePrice, LandStatus, LandFlags, LandingType, MediaAutoScale, MediaTextureUUID, MediaURL, MusicURL, PassHours, PassPrice, SnapshotUUID, UserLocationX, UserLocationY, UserLocationZ, UserLookAtX, UserLookAtY, UserLookAtZ, AuthbuyerID, OtherCleanTime, Dwell) | ||
44 | SELECT CONVERT(uniqueidentifier, UUID), CONVERT(uniqueidentifier, RegionUUID), LocalLandID, Bitmap, Name, Description, CONVERT(uniqueidentifier, OwnerUUID), IsGroupOwned, Area, AuctionID, Category, ClaimDate, ClaimPrice, CONVERT(uniqueidentifier, GroupUUID), SalePrice, LandStatus, LandFlags, LandingType, MediaAutoScale, CONVERT(uniqueidentifier, MediaTextureUUID), MediaURL, MusicURL, PassHours, PassPrice, CONVERT(uniqueidentifier, SnapshotUUID), UserLocationX, UserLocationY, UserLocationZ, UserLookAtX, UserLookAtY, UserLookAtZ, CONVERT(uniqueidentifier, AuthbuyerID), OtherCleanTime, Dwell FROM dbo.land WITH (HOLDLOCK TABLOCKX)') | ||
45 | |||
46 | DROP TABLE dbo.land | ||
47 | |||
48 | EXECUTE sp_rename N'dbo.Tmp_land', N'land', 'OBJECT' | ||
49 | |||
50 | ALTER TABLE dbo.land ADD CONSTRAINT | ||
51 | PK__land__65A475E71BFD2C07 PRIMARY KEY CLUSTERED | ||
52 | ( | ||
53 | UUID | ||
54 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
55 | |||
56 | COMMIT | ||