diff options
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/005_RegionStore.sql')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/005_RegionStore.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/005_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/005_RegionStore.sql index 74e9d85..eb0862c 100644 --- a/OpenSim/Data/MSSQL/Resources/005_RegionStore.sql +++ b/OpenSim/Data/MSSQL/Resources/005_RegionStore.sql | |||
@@ -1,6 +1,6 @@ | |||
1 | BEGIN TRANSACTION | 1 | BEGIN TRANSACTION |
2 | 2 | ||
3 | CREATE TABLE dbo.Tmp_primshapes | 3 | CREATE TABLE Tmp_primshapes |
4 | ( | 4 | ( |
5 | UUID varchar(36) NOT NULL, | 5 | UUID varchar(36) NOT NULL, |
6 | Shape int NULL, | 6 | Shape int NULL, |
@@ -32,18 +32,18 @@ CREATE TABLE dbo.Tmp_primshapes | |||
32 | ) ON [PRIMARY] | 32 | ) ON [PRIMARY] |
33 | TEXTIMAGE_ON [PRIMARY] | 33 | TEXTIMAGE_ON [PRIMARY] |
34 | 34 | ||
35 | IF EXISTS(SELECT * FROM dbo.primshapes) | 35 | IF EXISTS(SELECT * FROM primshapes) |
36 | EXEC('INSERT INTO dbo.Tmp_primshapes (UUID, Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams) | 36 | EXEC('INSERT INTO Tmp_primshapes (UUID, Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams) |
37 | SELECT CONVERT(varchar(36), UUID), Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams FROM dbo.primshapes WITH (HOLDLOCK TABLOCKX)') | 37 | SELECT CONVERT(varchar(36), UUID), Shape, ScaleX, ScaleY, ScaleZ, PCode, PathBegin, PathEnd, PathScaleX, PathScaleY, PathShearX, PathShearY, PathSkew, PathCurve, PathRadiusOffset, PathRevolutions, PathTaperX, PathTaperY, PathTwist, PathTwistBegin, ProfileBegin, ProfileEnd, ProfileCurve, ProfileHollow, State, Texture, ExtraParams FROM primshapes WITH (HOLDLOCK TABLOCKX)') |
38 | 38 | ||
39 | DROP TABLE dbo.primshapes | 39 | DROP TABLE primshapes |
40 | 40 | ||
41 | EXECUTE sp_rename N'dbo.Tmp_primshapes', N'primshapes', 'OBJECT' | 41 | EXECUTE sp_rename N'Tmp_primshapes', N'primshapes', 'OBJECT' |
42 | 42 | ||
43 | ALTER TABLE dbo.primshapes ADD CONSTRAINT | 43 | ALTER TABLE primshapes ADD CONSTRAINT |
44 | PK__primshapes__0880433F PRIMARY KEY CLUSTERED | 44 | PK__primshapes__0880433F PRIMARY KEY CLUSTERED |
45 | ( | 45 | ( |
46 | UUID | 46 | UUID |
47 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | 47 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
48 | 48 | ||
49 | COMMIT \ No newline at end of file | 49 | COMMIT |