1
0

001_RegionStore.sql 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  1. CREATE TABLE [dbo].[prims](
  2. [UUID] [varchar](255) NOT NULL,
  3. [RegionUUID] [varchar](255) NULL,
  4. [ParentID] [int] NULL,
  5. [CreationDate] [int] NULL,
  6. [Name] [varchar](255) NULL,
  7. [SceneGroupID] [varchar](255) NULL,
  8. [Text] [varchar](255) NULL,
  9. [Description] [varchar](255) NULL,
  10. [SitName] [varchar](255) NULL,
  11. [TouchName] [varchar](255) NULL,
  12. [ObjectFlags] [int] NULL,
  13. [CreatorID] [varchar](255) NULL,
  14. [OwnerID] [varchar](255) NULL,
  15. [GroupID] [varchar](255) NULL,
  16. [LastOwnerID] [varchar](255) NULL,
  17. [OwnerMask] [int] NULL,
  18. [NextOwnerMask] [int] NULL,
  19. [GroupMask] [int] NULL,
  20. [EveryoneMask] [int] NULL,
  21. [BaseMask] [int] NULL,
  22. [PositionX] [float] NULL,
  23. [PositionY] [float] NULL,
  24. [PositionZ] [float] NULL,
  25. [GroupPositionX] [float] NULL,
  26. [GroupPositionY] [float] NULL,
  27. [GroupPositionZ] [float] NULL,
  28. [VelocityX] [float] NULL,
  29. [VelocityY] [float] NULL,
  30. [VelocityZ] [float] NULL,
  31. [AngularVelocityX] [float] NULL,
  32. [AngularVelocityY] [float] NULL,
  33. [AngularVelocityZ] [float] NULL,
  34. [AccelerationX] [float] NULL,
  35. [AccelerationY] [float] NULL,
  36. [AccelerationZ] [float] NULL,
  37. [RotationX] [float] NULL,
  38. [RotationY] [float] NULL,
  39. [RotationZ] [float] NULL,
  40. [RotationW] [float] NULL,
  41. [SitTargetOffsetX] [float] NULL,
  42. [SitTargetOffsetY] [float] NULL,
  43. [SitTargetOffsetZ] [float] NULL,
  44. [SitTargetOrientW] [float] NULL,
  45. [SitTargetOrientX] [float] NULL,
  46. [SitTargetOrientY] [float] NULL,
  47. [SitTargetOrientZ] [float] NULL,
  48. PRIMARY KEY CLUSTERED
  49. (
  50. [UUID] ASC
  51. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  52. ) ON [PRIMARY]
  53. CREATE TABLE [dbo].[primshapes](
  54. [UUID] [varchar](255) NOT NULL,
  55. [Shape] [int] NULL,
  56. [ScaleX] [float] NULL,
  57. [ScaleY] [float] NULL,
  58. [ScaleZ] [float] NULL,
  59. [PCode] [int] NULL,
  60. [PathBegin] [int] NULL,
  61. [PathEnd] [int] NULL,
  62. [PathScaleX] [int] NULL,
  63. [PathScaleY] [int] NULL,
  64. [PathShearX] [int] NULL,
  65. [PathShearY] [int] NULL,
  66. [PathSkew] [int] NULL,
  67. [PathCurve] [int] NULL,
  68. [PathRadiusOffset] [int] NULL,
  69. [PathRevolutions] [int] NULL,
  70. [PathTaperX] [int] NULL,
  71. [PathTaperY] [int] NULL,
  72. [PathTwist] [int] NULL,
  73. [PathTwistBegin] [int] NULL,
  74. [ProfileBegin] [int] NULL,
  75. [ProfileEnd] [int] NULL,
  76. [ProfileCurve] [int] NULL,
  77. [ProfileHollow] [int] NULL,
  78. [State] [int] NULL,
  79. [Texture] [image] NULL,
  80. [ExtraParams] [image] NULL,
  81. PRIMARY KEY CLUSTERED
  82. (
  83. [UUID] ASC
  84. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  85. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  86. CREATE TABLE [dbo].[primitems](
  87. [itemID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  88. [primID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  89. [assetID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  90. [parentFolderID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  91. [invType] [int] NULL,
  92. [assetType] [int] NULL,
  93. [name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  94. [description] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  95. [creationDate] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  96. [creatorID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  97. [ownerID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  98. [lastOwnerID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  99. [groupID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  100. [nextPermissions] [int] NULL,
  101. [currentPermissions] [int] NULL,
  102. [basePermissions] [int] NULL,
  103. [everyonePermissions] [int] NULL,
  104. [groupPermissions] [int] NULL,
  105. PRIMARY KEY CLUSTERED
  106. (
  107. [itemID] ASC
  108. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  109. ) ON [PRIMARY]
  110. CREATE TABLE [dbo].[terrain](
  111. [RegionUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  112. [Revision] [int] NULL,
  113. [Heightfield] [image] NULL
  114. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  115. CREATE TABLE [dbo].[land](
  116. [UUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  117. [RegionUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  118. [LocalLandID] [int] NULL,
  119. [Bitmap] [image] NULL,
  120. [Name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  121. [Description] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  122. [OwnerUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  123. [IsGroupOwned] [int] NULL,
  124. [Area] [int] NULL,
  125. [AuctionID] [int] NULL,
  126. [Category] [int] NULL,
  127. [ClaimDate] [int] NULL,
  128. [ClaimPrice] [int] NULL,
  129. [GroupUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  130. [SalePrice] [int] NULL,
  131. [LandStatus] [int] NULL,
  132. [LandFlags] [int] NULL,
  133. [LandingType] [int] NULL,
  134. [MediaAutoScale] [int] NULL,
  135. [MediaTextureUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  136. [MediaURL] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  137. [MusicURL] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  138. [PassHours] [float] NULL,
  139. [PassPrice] [int] NULL,
  140. [SnapshotUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  141. [UserLocationX] [float] NULL,
  142. [UserLocationY] [float] NULL,
  143. [UserLocationZ] [float] NULL,
  144. [UserLookAtX] [float] NULL,
  145. [UserLookAtY] [float] NULL,
  146. [UserLookAtZ] [float] NULL,
  147. PRIMARY KEY CLUSTERED
  148. (
  149. [UUID] ASC
  150. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  151. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  152. CREATE TABLE [dbo].[landaccesslist](
  153. [LandUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  154. [AccessUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  155. [Flags] [int] NULL
  156. ) ON [PRIMARY]