RegionStore.migrations 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552
  1. :VERSION 51 #---------------------
  2. BEGIN;
  3. CREATE TABLE IF NOT EXISTS `prims` (
  4. `CreationDate` int(11) DEFAULT NULL,
  5. `Name` varchar(255) DEFAULT NULL,
  6. `Text` varchar(255) DEFAULT NULL,
  7. `Description` varchar(255) DEFAULT NULL,
  8. `SitName` varchar(255) DEFAULT NULL,
  9. `TouchName` varchar(255) DEFAULT NULL,
  10. `ObjectFlags` int(11) DEFAULT NULL,
  11. `OwnerMask` int(11) DEFAULT NULL,
  12. `NextOwnerMask` int(11) DEFAULT NULL,
  13. `GroupMask` int(11) DEFAULT NULL,
  14. `EveryoneMask` int(11) DEFAULT NULL,
  15. `BaseMask` int(11) DEFAULT NULL,
  16. `PositionX` double DEFAULT NULL,
  17. `PositionY` double DEFAULT NULL,
  18. `PositionZ` double DEFAULT NULL,
  19. `GroupPositionX` double DEFAULT NULL,
  20. `GroupPositionY` double DEFAULT NULL,
  21. `GroupPositionZ` double DEFAULT NULL,
  22. `VelocityX` double DEFAULT NULL,
  23. `VelocityY` double DEFAULT NULL,
  24. `VelocityZ` double DEFAULT NULL,
  25. `AngularVelocityX` double DEFAULT NULL,
  26. `AngularVelocityY` double DEFAULT NULL,
  27. `AngularVelocityZ` double DEFAULT NULL,
  28. `AccelerationX` double DEFAULT NULL,
  29. `AccelerationY` double DEFAULT NULL,
  30. `AccelerationZ` double DEFAULT NULL,
  31. `RotationX` double DEFAULT NULL,
  32. `RotationY` double DEFAULT NULL,
  33. `RotationZ` double DEFAULT NULL,
  34. `RotationW` double DEFAULT NULL,
  35. `SitTargetOffsetX` double DEFAULT NULL,
  36. `SitTargetOffsetY` double DEFAULT NULL,
  37. `SitTargetOffsetZ` double DEFAULT NULL,
  38. `SitTargetOrientW` double DEFAULT NULL,
  39. `SitTargetOrientX` double DEFAULT NULL,
  40. `SitTargetOrientY` double DEFAULT NULL,
  41. `SitTargetOrientZ` double DEFAULT NULL,
  42. `UUID` char(36) NOT NULL DEFAULT '',
  43. `RegionUUID` char(36) DEFAULT NULL,
  44. `CreatorID` varchar(255) NOT NULL DEFAULT '',
  45. `OwnerID` char(36) DEFAULT NULL,
  46. `GroupID` char(36) DEFAULT NULL,
  47. `LastOwnerID` char(36) DEFAULT NULL,
  48. `SceneGroupID` char(36) DEFAULT NULL,
  49. `PayPrice` int(11) NOT NULL DEFAULT '0',
  50. `PayButton1` int(11) NOT NULL DEFAULT '0',
  51. `PayButton2` int(11) NOT NULL DEFAULT '0',
  52. `PayButton3` int(11) NOT NULL DEFAULT '0',
  53. `PayButton4` int(11) NOT NULL DEFAULT '0',
  54. `LoopedSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  55. `LoopedSoundGain` double NOT NULL DEFAULT '0',
  56. `TextureAnimation` blob,
  57. `OmegaX` double NOT NULL DEFAULT '0',
  58. `OmegaY` double NOT NULL DEFAULT '0',
  59. `OmegaZ` double NOT NULL DEFAULT '0',
  60. `CameraEyeOffsetX` double NOT NULL DEFAULT '0',
  61. `CameraEyeOffsetY` double NOT NULL DEFAULT '0',
  62. `CameraEyeOffsetZ` double NOT NULL DEFAULT '0',
  63. `CameraAtOffsetX` double NOT NULL DEFAULT '0',
  64. `CameraAtOffsetY` double NOT NULL DEFAULT '0',
  65. `CameraAtOffsetZ` double NOT NULL DEFAULT '0',
  66. `ForceMouselook` tinyint(4) NOT NULL DEFAULT '0',
  67. `ScriptAccessPin` int(11) NOT NULL DEFAULT '0',
  68. `AllowedDrop` tinyint(4) NOT NULL DEFAULT '0',
  69. `DieAtEdge` tinyint(4) NOT NULL DEFAULT '0',
  70. `SalePrice` int(11) NOT NULL DEFAULT '10',
  71. `SaleType` tinyint(4) NOT NULL DEFAULT '0',
  72. `ColorR` int(11) NOT NULL DEFAULT '0',
  73. `ColorG` int(11) NOT NULL DEFAULT '0',
  74. `ColorB` int(11) NOT NULL DEFAULT '0',
  75. `ColorA` int(11) NOT NULL DEFAULT '0',
  76. `ParticleSystem` blob,
  77. `ClickAction` tinyint(4) NOT NULL DEFAULT '0',
  78. `Material` tinyint(4) NOT NULL DEFAULT '3',
  79. `CollisionSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  80. `CollisionSoundVolume` double NOT NULL DEFAULT '0',
  81. `LinkNumber` int(11) NOT NULL DEFAULT '0',
  82. `PassTouches` tinyint(4) NOT NULL DEFAULT '0',
  83. `MediaURL` varchar(255) DEFAULT NULL,
  84. `DynAttrs` text,
  85. `PhysicsShapeType` tinyint(4) NOT NULL DEFAULT '0',
  86. `Density` double NOT NULL DEFAULT '1000',
  87. `GravityModifier` double NOT NULL DEFAULT '1',
  88. `Friction` double NOT NULL DEFAULT '0.6',
  89. `Restitution` double NOT NULL DEFAULT '0.5',
  90. `KeyframeMotion` blob,
  91. `AttachedPosX` double DEFAULT '0',
  92. `AttachedPosY` double DEFAULT '0',
  93. `AttachedPosZ` double DEFAULT '0',
  94. PRIMARY KEY (`UUID`),
  95. KEY `prims_regionuuid` (`RegionUUID`),
  96. KEY `prims_scenegroupid` (`SceneGroupID`)
  97. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  98. CREATE TABLE IF NOT EXISTS `primshapes` (
  99. `Shape` int(11) DEFAULT NULL,
  100. `ScaleX` double NOT NULL DEFAULT '0',
  101. `ScaleY` double NOT NULL DEFAULT '0',
  102. `ScaleZ` double NOT NULL DEFAULT '0',
  103. `PCode` int(11) DEFAULT NULL,
  104. `PathBegin` int(11) DEFAULT NULL,
  105. `PathEnd` int(11) DEFAULT NULL,
  106. `PathScaleX` int(11) DEFAULT NULL,
  107. `PathScaleY` int(11) DEFAULT NULL,
  108. `PathShearX` int(11) DEFAULT NULL,
  109. `PathShearY` int(11) DEFAULT NULL,
  110. `PathSkew` int(11) DEFAULT NULL,
  111. `PathCurve` int(11) DEFAULT NULL,
  112. `PathRadiusOffset` int(11) DEFAULT NULL,
  113. `PathRevolutions` int(11) DEFAULT NULL,
  114. `PathTaperX` int(11) DEFAULT NULL,
  115. `PathTaperY` int(11) DEFAULT NULL,
  116. `PathTwist` int(11) DEFAULT NULL,
  117. `PathTwistBegin` int(11) DEFAULT NULL,
  118. `ProfileBegin` int(11) DEFAULT NULL,
  119. `ProfileEnd` int(11) DEFAULT NULL,
  120. `ProfileCurve` int(11) DEFAULT NULL,
  121. `ProfileHollow` int(11) DEFAULT NULL,
  122. `State` int(11) DEFAULT NULL,
  123. `Texture` longblob,
  124. `ExtraParams` longblob,
  125. `UUID` char(36) NOT NULL DEFAULT '',
  126. `Media` text,
  127. `LastAttachPoint` int(4) NOT NULL DEFAULT '0',
  128. PRIMARY KEY (`UUID`)
  129. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  130. CREATE TABLE IF NOT EXISTS `primitems` (
  131. `invType` int(11) DEFAULT NULL,
  132. `assetType` int(11) DEFAULT NULL,
  133. `name` varchar(255) DEFAULT NULL,
  134. `description` varchar(255) DEFAULT NULL,
  135. `creationDate` bigint(20) DEFAULT NULL,
  136. `nextPermissions` int(11) DEFAULT NULL,
  137. `currentPermissions` int(11) DEFAULT NULL,
  138. `basePermissions` int(11) DEFAULT NULL,
  139. `everyonePermissions` int(11) DEFAULT NULL,
  140. `groupPermissions` int(11) DEFAULT NULL,
  141. `flags` int(11) NOT NULL DEFAULT '0',
  142. `itemID` char(36) NOT NULL DEFAULT '',
  143. `primID` char(36) DEFAULT NULL,
  144. `assetID` char(36) DEFAULT NULL,
  145. `parentFolderID` char(36) DEFAULT NULL,
  146. `CreatorID` varchar(255) NOT NULL DEFAULT '',
  147. `ownerID` char(36) DEFAULT NULL,
  148. `groupID` char(36) DEFAULT NULL,
  149. `lastOwnerID` char(36) DEFAULT NULL,
  150. PRIMARY KEY (`itemID`),
  151. KEY `primitems_primid` (`primID`)
  152. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  153. CREATE TABLE IF NOT EXISTS `terrain` (
  154. `RegionUUID` varchar(255) DEFAULT NULL,
  155. `Revision` int(11) DEFAULT NULL,
  156. `Heightfield` longblob
  157. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  158. CREATE TABLE IF NOT EXISTS `land` (
  159. `UUID` varchar(255) NOT NULL,
  160. `RegionUUID` varchar(255) DEFAULT NULL,
  161. `LocalLandID` int(11) DEFAULT NULL,
  162. `Bitmap` longblob,
  163. `Name` varchar(255) DEFAULT NULL,
  164. `Description` varchar(255) DEFAULT NULL,
  165. `OwnerUUID` varchar(255) DEFAULT NULL,
  166. `IsGroupOwned` int(11) DEFAULT NULL,
  167. `Area` int(11) DEFAULT NULL,
  168. `AuctionID` int(11) DEFAULT NULL,
  169. `Category` int(11) DEFAULT NULL,
  170. `ClaimDate` int(11) DEFAULT NULL,
  171. `ClaimPrice` int(11) DEFAULT NULL,
  172. `GroupUUID` varchar(255) DEFAULT NULL,
  173. `SalePrice` int(11) DEFAULT NULL,
  174. `LandStatus` int(11) DEFAULT NULL,
  175. `LandFlags` int(10) unsigned DEFAULT NULL,
  176. `LandingType` int(11) DEFAULT NULL,
  177. `MediaAutoScale` int(11) DEFAULT NULL,
  178. `MediaTextureUUID` varchar(255) DEFAULT NULL,
  179. `MediaURL` varchar(255) DEFAULT NULL,
  180. `MusicURL` varchar(255) DEFAULT NULL,
  181. `PassHours` float DEFAULT NULL,
  182. `PassPrice` int(11) DEFAULT NULL,
  183. `SnapshotUUID` varchar(255) DEFAULT NULL,
  184. `UserLocationX` float DEFAULT NULL,
  185. `UserLocationY` float DEFAULT NULL,
  186. `UserLocationZ` float DEFAULT NULL,
  187. `UserLookAtX` float DEFAULT NULL,
  188. `UserLookAtY` float DEFAULT NULL,
  189. `UserLookAtZ` float DEFAULT NULL,
  190. `AuthbuyerID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  191. `OtherCleanTime` int(11) NOT NULL DEFAULT '0',
  192. `Dwell` int(11) NOT NULL DEFAULT '0',
  193. `MediaType` varchar(32) NOT NULL DEFAULT 'none/none',
  194. `MediaDescription` varchar(255) NOT NULL DEFAULT '',
  195. `MediaSize` varchar(16) NOT NULL DEFAULT '0,0',
  196. `MediaLoop` tinyint(1) NOT NULL DEFAULT '0',
  197. `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0',
  198. `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0',
  199. PRIMARY KEY (`UUID`)
  200. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  201. CREATE TABLE IF NOT EXISTS `landaccesslist` (
  202. `LandUUID` varchar(255) DEFAULT NULL,
  203. `AccessUUID` varchar(255) DEFAULT NULL,
  204. `Flags` int(11) DEFAULT NULL,
  205. `Expires` int(11) NOT NULL DEFAULT '0'
  206. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  207. CREATE TABLE IF NOT EXISTS `regionban` (
  208. `regionUUID` varchar(36) NOT NULL,
  209. `bannedUUID` varchar(36) NOT NULL,
  210. `bannedIp` varchar(16) NOT NULL,
  211. `bannedIpHostMask` varchar(16) NOT NULL
  212. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  213. CREATE TABLE IF NOT EXISTS `regionsettings` (
  214. `regionUUID` char(36) NOT NULL,
  215. `block_terraform` int(11) NOT NULL,
  216. `block_fly` int(11) NOT NULL,
  217. `allow_damage` int(11) NOT NULL,
  218. `restrict_pushing` int(11) NOT NULL,
  219. `allow_land_resell` int(11) NOT NULL,
  220. `allow_land_join_divide` int(11) NOT NULL,
  221. `block_show_in_search` int(11) NOT NULL,
  222. `agent_limit` int(11) NOT NULL,
  223. `object_bonus` double NOT NULL,
  224. `maturity` int(11) NOT NULL,
  225. `disable_scripts` int(11) NOT NULL,
  226. `disable_collisions` int(11) NOT NULL,
  227. `disable_physics` int(11) NOT NULL,
  228. `terrain_texture_1` char(36) NOT NULL,
  229. `terrain_texture_2` char(36) NOT NULL,
  230. `terrain_texture_3` char(36) NOT NULL,
  231. `terrain_texture_4` char(36) NOT NULL,
  232. `elevation_1_nw` double NOT NULL,
  233. `elevation_2_nw` double NOT NULL,
  234. `elevation_1_ne` double NOT NULL,
  235. `elevation_2_ne` double NOT NULL,
  236. `elevation_1_se` double NOT NULL,
  237. `elevation_2_se` double NOT NULL,
  238. `elevation_1_sw` double NOT NULL,
  239. `elevation_2_sw` double NOT NULL,
  240. `water_height` double NOT NULL,
  241. `terrain_raise_limit` double NOT NULL,
  242. `terrain_lower_limit` double NOT NULL,
  243. `use_estate_sun` int(11) NOT NULL,
  244. `fixed_sun` int(11) NOT NULL,
  245. `sun_position` double NOT NULL,
  246. `covenant` char(36) DEFAULT NULL,
  247. `Sandbox` tinyint(4) NOT NULL,
  248. `sunvectorx` double NOT NULL DEFAULT '0',
  249. `sunvectory` double NOT NULL DEFAULT '0',
  250. `sunvectorz` double NOT NULL DEFAULT '0',
  251. `loaded_creation_id` varchar(64) DEFAULT NULL,
  252. `loaded_creation_datetime` int(10) unsigned NOT NULL DEFAULT '0',
  253. `map_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  254. `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  255. `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  256. `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0',
  257. PRIMARY KEY (`regionUUID`)
  258. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  259. CREATE TABLE IF NOT EXISTS `regionwindlight` (
  260. `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',
  261. `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000',
  262. `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000',
  263. `water_color_b` float(9,6) unsigned NOT NULL DEFAULT '64.000000',
  264. `water_fog_density_exponent` float(3,1) unsigned NOT NULL DEFAULT '4.0',
  265. `underwater_fog_modifier` float(3,2) unsigned NOT NULL DEFAULT '0.25',
  266. `reflection_wavelet_scale_1` float(3,1) unsigned NOT NULL DEFAULT '2.0',
  267. `reflection_wavelet_scale_2` float(3,1) unsigned NOT NULL DEFAULT '2.0',
  268. `reflection_wavelet_scale_3` float(3,1) unsigned NOT NULL DEFAULT '2.0',
  269. `fresnel_scale` float(3,2) unsigned NOT NULL DEFAULT '0.40',
  270. `fresnel_offset` float(3,2) unsigned NOT NULL DEFAULT '0.50',
  271. `refract_scale_above` float(3,2) unsigned NOT NULL DEFAULT '0.03',
  272. `refract_scale_below` float(3,2) unsigned NOT NULL DEFAULT '0.20',
  273. `blur_multiplier` float(4,3) unsigned NOT NULL DEFAULT '0.040',
  274. `big_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.05',
  275. `big_wave_direction_y` float(3,2) NOT NULL DEFAULT '-0.42',
  276. `little_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.11',
  277. `little_wave_direction_y` float(3,2) NOT NULL DEFAULT '-1.16',
  278. `normal_map_texture` varchar(36) NOT NULL DEFAULT '822ded49-9a6c-f61c-cb89-6df54f42cdf4',
  279. `horizon_r` float(3,2) unsigned NOT NULL DEFAULT '0.25',
  280. `horizon_g` float(3,2) unsigned NOT NULL DEFAULT '0.25',
  281. `horizon_b` float(3,2) unsigned NOT NULL DEFAULT '0.32',
  282. `horizon_i` float(3,2) unsigned NOT NULL DEFAULT '0.32',
  283. `haze_horizon` float(3,2) unsigned NOT NULL DEFAULT '0.19',
  284. `blue_density_r` float(3,2) unsigned NOT NULL DEFAULT '0.12',
  285. `blue_density_g` float(3,2) unsigned NOT NULL DEFAULT '0.22',
  286. `blue_density_b` float(3,2) unsigned NOT NULL DEFAULT '0.38',
  287. `blue_density_i` float(3,2) unsigned NOT NULL DEFAULT '0.38',
  288. `haze_density` float(3,2) unsigned NOT NULL DEFAULT '0.70',
  289. `density_multiplier` float(3,2) unsigned NOT NULL DEFAULT '0.18',
  290. `distance_multiplier` float(4,1) unsigned NOT NULL DEFAULT '0.8',
  291. `max_altitude` int(4) unsigned NOT NULL DEFAULT '1605',
  292. `sun_moon_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.24',
  293. `sun_moon_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.26',
  294. `sun_moon_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.30',
  295. `sun_moon_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.30',
  296. `sun_moon_position` float(4,3) unsigned NOT NULL DEFAULT '0.317',
  297. `ambient_r` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  298. `ambient_g` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  299. `ambient_b` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  300. `ambient_i` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  301. `east_angle` float(3,2) unsigned NOT NULL DEFAULT '0.00',
  302. `sun_glow_focus` float(3,2) unsigned NOT NULL DEFAULT '0.10',
  303. `sun_glow_size` float(3,2) unsigned NOT NULL DEFAULT '1.75',
  304. `scene_gamma` float(4,2) unsigned NOT NULL DEFAULT '1.00',
  305. `star_brightness` float(3,2) unsigned NOT NULL DEFAULT '0.00',
  306. `cloud_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  307. `cloud_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  308. `cloud_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  309. `cloud_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  310. `cloud_x` float(3,2) unsigned NOT NULL DEFAULT '1.00',
  311. `cloud_y` float(3,2) unsigned NOT NULL DEFAULT '0.53',
  312. `cloud_density` float(3,2) unsigned NOT NULL DEFAULT '1.00',
  313. `cloud_coverage` float(3,2) unsigned NOT NULL DEFAULT '0.27',
  314. `cloud_scale` float(3,2) unsigned NOT NULL DEFAULT '0.42',
  315. `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00',
  316. `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53',
  317. `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12',
  318. `cloud_scroll_x` float(4,2) NOT NULL DEFAULT '0.20',
  319. `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  320. `cloud_scroll_y` float(4,2) NOT NULL DEFAULT '0.01',
  321. `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  322. `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1',
  323. PRIMARY KEY (`region_id`)
  324. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  325. CREATE TABLE IF NOT EXISTS `spawn_points` (
  326. `RegionID` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  327. `Yaw` float NOT NULL,
  328. `Pitch` float NOT NULL,
  329. `Distance` float NOT NULL,
  330. KEY `RegionID` (`RegionID`)
  331. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  332. CREATE TABLE IF NOT EXISTS `regionenvironment` (
  333. `region_id` varchar(36) NOT NULL,
  334. `llsd_settings` text NOT NULL,
  335. PRIMARY KEY (`region_id`)
  336. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  337. CREATE TABLE IF NOT EXISTS `regionextra` (
  338. `RegionID` char(36) NOT NULL,
  339. `Name` varchar(32) NOT NULL,
  340. `value` text,
  341. PRIMARY KEY (`RegionID`,`Name`)
  342. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  343. COMMIT;
  344. :VERSION 52 #---- avination fields
  345. BEGIN;
  346. ALTER TABLE `prims` ADD COLUMN `PassCollisions` tinyint(4) NOT NULL default '0';
  347. ALTER TABLE `prims` ADD COLUMN `Vehicle` TEXT default NULL;
  348. ALTER TABLE `regionsettings` ADD COLUMN `block_search` tinyint(4) NOT NULL default '0';
  349. ALTER TABLE `regionsettings` ADD COLUMN `casino` tinyint(4) NOT NULL default '0';
  350. ALTER TABLE `land` ADD COLUMN `SeeAVs` tinyint(4) NOT NULL default '1';
  351. ALTER TABLE `land` ADD COLUMN `AnyAVSounds` tinyint(4) NOT NULL default '1';
  352. ALTER TABLE `land` ADD COLUMN `GroupAVSounds` tinyint(4) NOT NULL default '1';
  353. COMMIT;
  354. :VERSION 53 #---- STATUS ROTATION axis locks
  355. BEGIN;
  356. ALTER TABLE `prims` ADD COLUMN `RotationAxisLocks` tinyint(4) NOT NULL default '0';
  357. COMMIT;
  358. :VERSION 54 #----- add baked terrain store
  359. BEGIN;
  360. CREATE TABLE IF NOT EXISTS `bakedterrain` (
  361. `RegionUUID` varchar(255) DEFAULT NULL,
  362. `Revision` int(11) DEFAULT NULL,
  363. `Heightfield` longblob
  364. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  365. COMMIT;
  366. :VERSION 55 #----- Increase float precision for windlight needed by scripts
  367. BEGIN;
  368. ALTER TABLE `regionwindlight`
  369. MODIFY `water_fog_density_exponent` float(9,7) unsigned NOT NULL DEFAULT '4.0',
  370. MODIFY `underwater_fog_modifier` float(9,8) unsigned NOT NULL DEFAULT '0.25',
  371. MODIFY `reflection_wavelet_scale_1` float(9,7) unsigned NOT NULL DEFAULT '2.0',
  372. MODIFY `reflection_wavelet_scale_2` float(9,7) unsigned NOT NULL DEFAULT '2.0',
  373. MODIFY `reflection_wavelet_scale_3` float(9,7) unsigned NOT NULL DEFAULT '2.0',
  374. MODIFY `fresnel_scale` float(9,8) unsigned NOT NULL DEFAULT '0.40',
  375. MODIFY `fresnel_offset` float(9,8) unsigned NOT NULL DEFAULT '0.50',
  376. MODIFY `refract_scale_above` float(9,8) unsigned NOT NULL DEFAULT '0.03',
  377. MODIFY `refract_scale_below` float(9,8) unsigned NOT NULL DEFAULT '0.20',
  378. MODIFY `blur_multiplier` float(9,8) unsigned NOT NULL DEFAULT '0.040',
  379. MODIFY `big_wave_direction_x` float(9,8) NOT NULL DEFAULT '1.05',
  380. MODIFY `big_wave_direction_y` float(9,8) NOT NULL DEFAULT '-0.42',
  381. MODIFY `little_wave_direction_x` float(9,8) NOT NULL DEFAULT '1.11',
  382. MODIFY `little_wave_direction_y` float(9,8) NOT NULL DEFAULT '-1.16',
  383. MODIFY `horizon_r` float(9,8) unsigned NOT NULL DEFAULT '0.25',
  384. MODIFY `horizon_g` float(9,8) unsigned NOT NULL DEFAULT '0.25',
  385. MODIFY `horizon_b` float(9,8) unsigned NOT NULL DEFAULT '0.32',
  386. MODIFY `horizon_i` float(9,8) unsigned NOT NULL DEFAULT '0.32',
  387. MODIFY `haze_horizon` float(9,8) unsigned NOT NULL DEFAULT '0.19',
  388. MODIFY `blue_density_r` float(9,8) unsigned NOT NULL DEFAULT '0.12',
  389. MODIFY `blue_density_g` float(9,8) unsigned NOT NULL DEFAULT '0.22',
  390. MODIFY `blue_density_b` float(9,8) unsigned NOT NULL DEFAULT '0.38',
  391. MODIFY `blue_density_i` float(9,8) unsigned NOT NULL DEFAULT '0.38',
  392. MODIFY `haze_density` float(9,8) unsigned NOT NULL DEFAULT '0.70',
  393. MODIFY `density_multiplier` float(9,8) unsigned NOT NULL DEFAULT '0.18',
  394. MODIFY `distance_multiplier` float(9,6) unsigned NOT NULL DEFAULT '0.8',
  395. MODIFY `sun_moon_color_r` float(9,8) unsigned NOT NULL DEFAULT '0.24',
  396. MODIFY `sun_moon_color_g` float(9,8) unsigned NOT NULL DEFAULT '0.26',
  397. MODIFY `sun_moon_color_b` float(9,8) unsigned NOT NULL DEFAULT '0.30',
  398. MODIFY `sun_moon_color_i` float(9,8) unsigned NOT NULL DEFAULT '0.30',
  399. MODIFY `sun_moon_position` float(9,8) unsigned NOT NULL DEFAULT '0.317',
  400. MODIFY `ambient_r` float(9,8) unsigned NOT NULL DEFAULT '0.35',
  401. MODIFY `ambient_g` float(9,8) unsigned NOT NULL DEFAULT '0.35',
  402. MODIFY `ambient_b` float(9,8) unsigned NOT NULL DEFAULT '0.35',
  403. MODIFY `ambient_i` float(9,8) unsigned NOT NULL DEFAULT '0.35',
  404. MODIFY `east_angle` float(9,8) unsigned NOT NULL DEFAULT '0.00',
  405. MODIFY `sun_glow_focus` float(9,8) unsigned NOT NULL DEFAULT '0.10',
  406. MODIFY `sun_glow_size` float(9,8) unsigned NOT NULL DEFAULT '1.75',
  407. MODIFY `scene_gamma` float(9,7) unsigned NOT NULL DEFAULT '1.00',
  408. MODIFY `star_brightness` float(9,8) unsigned NOT NULL DEFAULT '0.00',
  409. MODIFY `cloud_color_r` float(9,8) unsigned NOT NULL DEFAULT '0.41',
  410. MODIFY `cloud_color_g` float(9,8) unsigned NOT NULL DEFAULT '0.41',
  411. MODIFY `cloud_color_b` float(9,8) unsigned NOT NULL DEFAULT '0.41',
  412. MODIFY `cloud_color_i` float(9,8) unsigned NOT NULL DEFAULT '0.41',
  413. MODIFY `cloud_x` float(9,8) unsigned NOT NULL DEFAULT '1.00',
  414. MODIFY `cloud_y` float(9,8) unsigned NOT NULL DEFAULT '0.53',
  415. MODIFY `cloud_density` float(9,8) unsigned NOT NULL DEFAULT '1.00',
  416. MODIFY `cloud_coverage` float(9,8) unsigned NOT NULL DEFAULT '0.27',
  417. MODIFY `cloud_scale` float(9,8) unsigned NOT NULL DEFAULT '0.42',
  418. MODIFY `cloud_detail_x` float(9,8) unsigned NOT NULL DEFAULT '1.00',
  419. MODIFY `cloud_detail_y` float(9,8) unsigned NOT NULL DEFAULT '0.53',
  420. MODIFY `cloud_detail_density` float(9,8) unsigned NOT NULL DEFAULT '0.12',
  421. MODIFY `cloud_scroll_x` float(9,7) NOT NULL DEFAULT '0.20',
  422. MODIFY `cloud_scroll_y` float(9,7) NOT NULL DEFAULT '0.01';
  423. COMMIT;
  424. :VERSION 56 #----- Add RezzerID field in table prims
  425. BEGIN;
  426. ALTER TABLE `prims` ADD COLUMN `RezzerID` char(36) DEFAULT NULL;
  427. COMMIT;
  428. :VERSION 57 #----- Add physics inertia data
  429. BEGIN;
  430. ALTER TABLE `prims` ADD COLUMN `PhysInertia` TEXT default NULL;
  431. COMMIT;
  432. :VERSION 58 #----- Add sop animations
  433. BEGIN;
  434. ALTER TABLE `prims` ADD COLUMN `sopanims` blob default NULL;
  435. COMMIT;
  436. :VERSION 59 #----- Add standtarget and sit range
  437. BEGIN;
  438. ALTER TABLE `prims`
  439. ADD COLUMN `standtargetx` float DEFAULT '0.0',
  440. ADD COLUMN `standtargety` float DEFAULT '0.0',
  441. ADD COLUMN `standtargetz` float DEFAULT '0.0',
  442. ADD COLUMN `sitactrange` float DEFAULT '0.0';
  443. COMMIT;
  444. :VERSION 60 #----- don't store float on double
  445. BEGIN;
  446. ALTER TABLE `prims`
  447. MODIFY `PositionX` float DEFAULT '0.0',
  448. MODIFY `PositionY` float DEFAULT '0.0',
  449. MODIFY `PositionZ` float DEFAULT '0.0',
  450. MODIFY `GroupPositionX` float DEFAULT '0.0',
  451. MODIFY `GroupPositionY` float DEFAULT '0.0',
  452. MODIFY `GroupPositionZ` float DEFAULT '0.0',
  453. MODIFY `VelocityX` float DEFAULT '0.0',
  454. MODIFY `VelocityY` float DEFAULT '0.0',
  455. MODIFY `VelocityZ` float DEFAULT '0.0',
  456. MODIFY `AngularVelocityX` float DEFAULT '0.0',
  457. MODIFY `AngularVelocityY` float DEFAULT '0.0',
  458. MODIFY `AngularVelocityZ` float DEFAULT '0.0',
  459. MODIFY `AccelerationX` float DEFAULT '0.0',
  460. MODIFY `AccelerationY` float DEFAULT '0.0',
  461. MODIFY `AccelerationZ` float DEFAULT '0.0',
  462. MODIFY `RotationX` float DEFAULT '0.0',
  463. MODIFY `RotationY` float DEFAULT '0.0',
  464. MODIFY `RotationZ` float DEFAULT '0.0',
  465. MODIFY `RotationW` float DEFAULT '0.0',
  466. MODIFY `SitTargetOffsetX` float DEFAULT '0.0',
  467. MODIFY `SitTargetOffsetY` float DEFAULT '0.0',
  468. MODIFY `SitTargetOffsetZ` float DEFAULT '0.0',
  469. MODIFY `SitTargetOrientX` float DEFAULT '0.0',
  470. MODIFY `SitTargetOrientY` float DEFAULT '0.0',
  471. MODIFY `SitTargetOrientZ` float DEFAULT '0.0',
  472. MODIFY `SitTargetOrientW` float DEFAULT '0.0',
  473. MODIFY `OmegaX` float DEFAULT '0.0',
  474. MODIFY `OmegaY` float DEFAULT '0.0',
  475. MODIFY `OmegaZ` float DEFAULT '0.0',
  476. MODIFY `CameraEyeOffsetX` float DEFAULT '0.0',
  477. MODIFY `CameraEyeOffsetY` float DEFAULT '0.0',
  478. MODIFY `CameraEyeOffsetZ` float DEFAULT '0.0',
  479. MODIFY `CameraAtOffsetX` float DEFAULT '0.0',
  480. MODIFY `CameraAtOffsetY` float DEFAULT '0.0',
  481. MODIFY `CameraAtOffsetZ` float DEFAULT '0.0',
  482. MODIFY `Density` float DEFAULT '1000.0',
  483. MODIFY `GravityModifier` float DEFAULT '1.0',
  484. MODIFY `Friction` float DEFAULT '0.6',
  485. MODIFY `Restitution` float DEFAULT '0.5',
  486. MODIFY `AttachedPosX` float DEFAULT '0',
  487. MODIFY `AttachedPosY` float DEFAULT '0',
  488. MODIFY `AttachedPosZ` float DEFAULT '0',
  489. MODIFY `LoopedSoundGain` float DEFAULT '0';
  490. COMMIT;
  491. :VERSION 61 #----- Add pseudo CRC and region cache id
  492. BEGIN;
  493. ALTER TABLE `prims` ADD COLUMN `pseudocrc` int DEFAULT '0';
  494. ALTER TABLE `regionsettings` ADD COLUMN `cacheID` char(36) DEFAULT NULL;
  495. COMMIT;
  496. :VERSION 62 #----- increase size of environment settings
  497. BEGIN;
  498. ALTER TABLE `regionenvironment` MODIFY `llsd_settings` MEDIUMTEXT;
  499. COMMIT;
  500. :VERSION 63 #----- parcel environment store
  501. BEGIN;
  502. ALTER TABLE `land` ADD COLUMN `environment` MEDIUMTEXT default NULL;
  503. COMMIT;