1
0

005_RegionStore.sql 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. BEGIN TRANSACTION
  2. CREATE TABLE Tmp_primshapes
  3. (
  4. UUID varchar(36) NOT NULL,
  5. Shape int NULL,
  6. ScaleX float(53) NULL,
  7. ScaleY float(53) NULL,
  8. ScaleZ float(53) NULL,
  9. PCode int NULL,
  10. PathBegin int NULL,
  11. PathEnd int NULL,
  12. PathScaleX int NULL,
  13. PathScaleY int NULL,
  14. PathShearX int NULL,
  15. PathShearY int NULL,
  16. PathSkew int NULL,
  17. PathCurve int NULL,
  18. PathRadiusOffset int NULL,
  19. PathRevolutions int NULL,
  20. PathTaperX int NULL,
  21. PathTaperY int NULL,
  22. PathTwist int NULL,
  23. PathTwistBegin int NULL,
  24. ProfileBegin int NULL,
  25. ProfileEnd int NULL,
  26. ProfileCurve int NULL,
  27. ProfileHollow int NULL,
  28. State int NULL,
  29. Texture image NULL,
  30. ExtraParams image NULL
  31. ) ON [PRIMARY]
  32. TEXTIMAGE_ON [PRIMARY]
  33. IF EXISTS(SELECT * FROM primshapes)
  34. 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)
  35. 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)')
  36. DROP TABLE primshapes
  37. EXECUTE sp_rename N'Tmp_primshapes', N'primshapes', 'OBJECT'
  38. ALTER TABLE primshapes ADD CONSTRAINT
  39. PK__primshapes__0880433F PRIMARY KEY CLUSTERED
  40. (
  41. UUID
  42. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  43. COMMIT