RegionStore.migrations 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844
  1. :VERSION 1 #---------------------
  2. BEGIN;
  3. CREATE TABLE `prims` (
  4. `UUID` varchar(255) NOT NULL,
  5. `RegionUUID` varchar(255) default NULL,
  6. `ParentID` int(11) default NULL,
  7. `CreationDate` int(11) default NULL,
  8. `Name` varchar(255) default NULL,
  9. `SceneGroupID` varchar(255) default NULL,
  10. `Text` varchar(255) default NULL,
  11. `Description` varchar(255) default NULL,
  12. `SitName` varchar(255) default NULL,
  13. `TouchName` varchar(255) default NULL,
  14. `ObjectFlags` int(11) default NULL,
  15. `CreatorID` varchar(255) default NULL,
  16. `OwnerID` varchar(255) default NULL,
  17. `GroupID` varchar(255) default NULL,
  18. `LastOwnerID` varchar(255) default NULL,
  19. `OwnerMask` int(11) default NULL,
  20. `NextOwnerMask` int(11) default NULL,
  21. `GroupMask` int(11) default NULL,
  22. `EveryoneMask` int(11) default NULL,
  23. `BaseMask` int(11) default NULL,
  24. `PositionX` float default NULL,
  25. `PositionY` float default NULL,
  26. `PositionZ` float default NULL,
  27. `GroupPositionX` float default NULL,
  28. `GroupPositionY` float default NULL,
  29. `GroupPositionZ` float default NULL,
  30. `VelocityX` float default NULL,
  31. `VelocityY` float default NULL,
  32. `VelocityZ` float default NULL,
  33. `AngularVelocityX` float default NULL,
  34. `AngularVelocityY` float default NULL,
  35. `AngularVelocityZ` float default NULL,
  36. `AccelerationX` float default NULL,
  37. `AccelerationY` float default NULL,
  38. `AccelerationZ` float default NULL,
  39. `RotationX` float default NULL,
  40. `RotationY` float default NULL,
  41. `RotationZ` float default NULL,
  42. `RotationW` float default NULL,
  43. `SitTargetOffsetX` float default NULL,
  44. `SitTargetOffsetY` float default NULL,
  45. `SitTargetOffsetZ` float default NULL,
  46. `SitTargetOrientW` float default NULL,
  47. `SitTargetOrientX` float default NULL,
  48. `SitTargetOrientY` float default NULL,
  49. `SitTargetOrientZ` float default NULL,
  50. PRIMARY KEY (`UUID`)
  51. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  52. CREATE TABLE `primshapes` (
  53. `UUID` varchar(255) NOT NULL,
  54. `Shape` int(11) default NULL,
  55. `ScaleX` float default NULL,
  56. `ScaleY` float default NULL,
  57. `ScaleZ` float default NULL,
  58. `PCode` int(11) default NULL,
  59. `PathBegin` int(11) default NULL,
  60. `PathEnd` int(11) default NULL,
  61. `PathScaleX` int(11) default NULL,
  62. `PathScaleY` int(11) default NULL,
  63. `PathShearX` int(11) default NULL,
  64. `PathShearY` int(11) default NULL,
  65. `PathSkew` int(11) default NULL,
  66. `PathCurve` int(11) default NULL,
  67. `PathRadiusOffset` int(11) default NULL,
  68. `PathRevolutions` int(11) default NULL,
  69. `PathTaperX` int(11) default NULL,
  70. `PathTaperY` int(11) default NULL,
  71. `PathTwist` int(11) default NULL,
  72. `PathTwistBegin` int(11) default NULL,
  73. `ProfileBegin` int(11) default NULL,
  74. `ProfileEnd` int(11) default NULL,
  75. `ProfileCurve` int(11) default NULL,
  76. `ProfileHollow` int(11) default NULL,
  77. `State` int(11) default NULL,
  78. `Texture` longblob,
  79. `ExtraParams` longblob,
  80. PRIMARY KEY (`UUID`)
  81. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  82. CREATE TABLE `primitems` (
  83. `itemID` varchar(255) NOT NULL,
  84. `primID` varchar(255) default NULL,
  85. `assetID` varchar(255) default NULL,
  86. `parentFolderID` varchar(255) default NULL,
  87. `invType` int(11) default NULL,
  88. `assetType` int(11) default NULL,
  89. `name` varchar(255) default NULL,
  90. `description` varchar(255) default NULL,
  91. `creationDate` bigint(20) default NULL,
  92. `creatorID` varchar(255) default NULL,
  93. `ownerID` varchar(255) default NULL,
  94. `lastOwnerID` varchar(255) default NULL,
  95. `groupID` varchar(255) default NULL,
  96. `nextPermissions` int(11) default NULL,
  97. `currentPermissions` int(11) default NULL,
  98. `basePermissions` int(11) default NULL,
  99. `everyonePermissions` int(11) default NULL,
  100. `groupPermissions` int(11) default NULL,
  101. PRIMARY KEY (`itemID`)
  102. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  103. CREATE TABLE `terrain` (
  104. `RegionUUID` varchar(255) default NULL,
  105. `Revision` int(11) default NULL,
  106. `Heightfield` longblob
  107. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  108. CREATE TABLE `land` (
  109. `UUID` varchar(255) NOT NULL,
  110. `RegionUUID` varchar(255) default NULL,
  111. `LocalLandID` int(11) default NULL,
  112. `Bitmap` longblob,
  113. `Name` varchar(255) default NULL,
  114. `Description` varchar(255) default NULL,
  115. `OwnerUUID` varchar(255) default NULL,
  116. `IsGroupOwned` int(11) default NULL,
  117. `Area` int(11) default NULL,
  118. `AuctionID` int(11) default NULL,
  119. `Category` int(11) default NULL,
  120. `ClaimDate` int(11) default NULL,
  121. `ClaimPrice` int(11) default NULL,
  122. `GroupUUID` varchar(255) default NULL,
  123. `SalePrice` int(11) default NULL,
  124. `LandStatus` int(11) default NULL,
  125. `LandFlags` int(11) default NULL,
  126. `LandingType` int(11) default NULL,
  127. `MediaAutoScale` int(11) default NULL,
  128. `MediaTextureUUID` varchar(255) default NULL,
  129. `MediaURL` varchar(255) default NULL,
  130. `MusicURL` varchar(255) default NULL,
  131. `PassHours` float default NULL,
  132. `PassPrice` int(11) default NULL,
  133. `SnapshotUUID` varchar(255) default NULL,
  134. `UserLocationX` float default NULL,
  135. `UserLocationY` float default NULL,
  136. `UserLocationZ` float default NULL,
  137. `UserLookAtX` float default NULL,
  138. `UserLookAtY` float default NULL,
  139. `UserLookAtZ` float default NULL,
  140. `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  141. PRIMARY KEY (`UUID`)
  142. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  143. CREATE TABLE `landaccesslist` (
  144. `LandUUID` varchar(255) default NULL,
  145. `AccessUUID` varchar(255) default NULL,
  146. `Flags` int(11) default NULL
  147. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  148. COMMIT;
  149. :VERSION 2 #---------------------
  150. BEGIN;
  151. CREATE index prims_regionuuid on prims(RegionUUID);
  152. CREATE index primitems_primid on primitems(primID);
  153. COMMIT;
  154. :VERSION 3 #---------------------
  155. BEGIN;
  156. CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
  157. COMMIT;
  158. :VERSION 4 #---------------------
  159. BEGIN;
  160. ALTER TABLE primitems add flags integer not null default 0;
  161. COMMIT;
  162. :VERSION 5 #---------------------
  163. BEGIN;
  164. create table regionsettings (
  165. regionUUID char(36) not null,
  166. block_terraform integer not null,
  167. block_fly integer not null,
  168. allow_damage integer not null,
  169. restrict_pushing integer not null,
  170. allow_land_resell integer not null,
  171. allow_land_join_divide integer not null,
  172. block_show_in_search integer not null,
  173. agent_limit integer not null,
  174. object_bonus float not null,
  175. maturity integer not null,
  176. disable_scripts integer not null,
  177. disable_collisions integer not null,
  178. disable_physics integer not null,
  179. terrain_texture_1 char(36) not null,
  180. terrain_texture_2 char(36) not null,
  181. terrain_texture_3 char(36) not null,
  182. terrain_texture_4 char(36) not null,
  183. elevation_1_nw float not null,
  184. elevation_2_nw float not null,
  185. elevation_1_ne float not null,
  186. elevation_2_ne float not null,
  187. elevation_1_se float not null,
  188. elevation_2_se float not null,
  189. elevation_1_sw float not null,
  190. elevation_2_sw float not null,
  191. water_height float not null,
  192. terrain_raise_limit float not null,
  193. terrain_lower_limit float not null,
  194. use_estate_sun integer not null,
  195. fixed_sun integer not null,
  196. sun_position float not null,
  197. covenant char(36),
  198. primary key(regionUUID)
  199. );
  200. COMMIT;
  201. :VERSION 6 #---------------------
  202. BEGIN;
  203. alter table landaccesslist ENGINE = InnoDB;
  204. alter table migrations ENGINE = InnoDB;
  205. alter table primitems ENGINE = InnoDB;
  206. alter table prims ENGINE = InnoDB;
  207. alter table primshapes ENGINE = InnoDB;
  208. alter table regionsettings ENGINE = InnoDB;
  209. alter table terrain ENGINE = InnoDB;
  210. COMMIT;
  211. :VERSION 7 #---------------------
  212. BEGIN;
  213. ALTER TABLE prims change UUID UUIDold varchar(255);
  214. ALTER TABLE prims change RegionUUID RegionUUIDold varchar(255);
  215. ALTER TABLE prims change CreatorID CreatorIDold varchar(255);
  216. ALTER TABLE prims change OwnerID OwnerIDold varchar(255);
  217. ALTER TABLE prims change GroupID GroupIDold varchar(255);
  218. ALTER TABLE prims change LastOwnerID LastOwnerIDold varchar(255);
  219. ALTER TABLE prims add UUID char(36);
  220. ALTER TABLE prims add RegionUUID char(36);
  221. ALTER TABLE prims add CreatorID char(36);
  222. ALTER TABLE prims add OwnerID char(36);
  223. ALTER TABLE prims add GroupID char(36);
  224. ALTER TABLE prims add LastOwnerID char(36);
  225. UPDATE prims set UUID = UUIDold, RegionUUID = RegionUUIDold, CreatorID = CreatorIDold, OwnerID = OwnerIDold, GroupID = GroupIDold, LastOwnerID = LastOwnerIDold;
  226. ALTER TABLE prims drop UUIDold;
  227. ALTER TABLE prims drop RegionUUIDold;
  228. ALTER TABLE prims drop CreatorIDold;
  229. ALTER TABLE prims drop OwnerIDold;
  230. ALTER TABLE prims drop GroupIDold;
  231. ALTER TABLE prims drop LastOwnerIDold;
  232. ALTER TABLE prims add constraint primary key(UUID);
  233. ALTER TABLE prims add index prims_regionuuid(RegionUUID);
  234. COMMIT;
  235. :VERSION 8 #---------------------
  236. BEGIN;
  237. ALTER TABLE primshapes change UUID UUIDold varchar(255);
  238. ALTER TABLE primshapes add UUID char(36);
  239. UPDATE primshapes set UUID = UUIDold;
  240. ALTER TABLE primshapes drop UUIDold;
  241. ALTER TABLE primshapes add constraint primary key(UUID);
  242. COMMIT;
  243. :VERSION 9 #---------------------
  244. BEGIN;
  245. ALTER TABLE primitems change itemID itemIDold varchar(255);
  246. ALTER TABLE primitems change primID primIDold varchar(255);
  247. ALTER TABLE primitems change assetID assetIDold varchar(255);
  248. ALTER TABLE primitems change parentFolderID parentFolderIDold varchar(255);
  249. ALTER TABLE primitems change creatorID creatorIDold varchar(255);
  250. ALTER TABLE primitems change ownerID ownerIDold varchar(255);
  251. ALTER TABLE primitems change groupID groupIDold varchar(255);
  252. ALTER TABLE primitems change lastOwnerID lastOwnerIDold varchar(255);
  253. ALTER TABLE primitems add itemID char(36);
  254. ALTER TABLE primitems add primID char(36);
  255. ALTER TABLE primitems add assetID char(36);
  256. ALTER TABLE primitems add parentFolderID char(36);
  257. ALTER TABLE primitems add creatorID char(36);
  258. ALTER TABLE primitems add ownerID char(36);
  259. ALTER TABLE primitems add groupID char(36);
  260. ALTER TABLE primitems add lastOwnerID char(36);
  261. UPDATE primitems set itemID = itemIDold, primID = primIDold, assetID = assetIDold, parentFolderID = parentFolderIDold, creatorID = creatorIDold, ownerID = ownerIDold, groupID = groupIDold, lastOwnerID = lastOwnerIDold;
  262. ALTER TABLE primitems drop itemIDold;
  263. ALTER TABLE primitems drop primIDold;
  264. ALTER TABLE primitems drop assetIDold;
  265. ALTER TABLE primitems drop parentFolderIDold;
  266. ALTER TABLE primitems drop creatorIDold;
  267. ALTER TABLE primitems drop ownerIDold;
  268. ALTER TABLE primitems drop groupIDold;
  269. ALTER TABLE primitems drop lastOwnerIDold;
  270. ALTER TABLE primitems add constraint primary key(itemID);
  271. ALTER TABLE primitems add index primitems_primid(primID);
  272. COMMIT;
  273. :VERSION 10 #---------------------
  274. # 1 "010_RegionStore.sql"
  275. # 1 "<built-in>"
  276. # 1 "<command line>"
  277. # 1 "010_RegionStore.sql"
  278. BEGIN;
  279. DELETE FROM regionsettings;
  280. COMMIT;
  281. :VERSION 11 #---------------------
  282. BEGIN;
  283. ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255);
  284. ALTER TABLE prims add SceneGroupID char(36);
  285. UPDATE prims set SceneGroupID = SceneGroupIDold;
  286. ALTER TABLE prims drop SceneGroupIDold;
  287. ALTER TABLE prims add index prims_scenegroupid(SceneGroupID);
  288. COMMIT;
  289. :VERSION 12 #---------------------
  290. BEGIN;
  291. ALTER TABLE prims add index prims_parentid(ParentID);
  292. COMMIT;
  293. :VERSION 13 #---------------------
  294. begin;
  295. drop table regionsettings;
  296. CREATE TABLE `regionsettings` (
  297. `regionUUID` char(36) NOT NULL,
  298. `block_terraform` int(11) NOT NULL,
  299. `block_fly` int(11) NOT NULL,
  300. `allow_damage` int(11) NOT NULL,
  301. `restrict_pushing` int(11) NOT NULL,
  302. `allow_land_resell` int(11) NOT NULL,
  303. `allow_land_join_divide` int(11) NOT NULL,
  304. `block_show_in_search` int(11) NOT NULL,
  305. `agent_limit` int(11) NOT NULL,
  306. `object_bonus` float NOT NULL,
  307. `maturity` int(11) NOT NULL,
  308. `disable_scripts` int(11) NOT NULL,
  309. `disable_collisions` int(11) NOT NULL,
  310. `disable_physics` int(11) NOT NULL,
  311. `terrain_texture_1` char(36) NOT NULL,
  312. `terrain_texture_2` char(36) NOT NULL,
  313. `terrain_texture_3` char(36) NOT NULL,
  314. `terrain_texture_4` char(36) NOT NULL,
  315. `elevation_1_nw` float NOT NULL,
  316. `elevation_2_nw` float NOT NULL,
  317. `elevation_1_ne` float NOT NULL,
  318. `elevation_2_ne` float NOT NULL,
  319. `elevation_1_se` float NOT NULL,
  320. `elevation_2_se` float NOT NULL,
  321. `elevation_1_sw` float NOT NULL,
  322. `elevation_2_sw` float NOT NULL,
  323. `water_height` float NOT NULL,
  324. `terrain_raise_limit` float NOT NULL,
  325. `terrain_lower_limit` float NOT NULL,
  326. `use_estate_sun` int(11) NOT NULL,
  327. `fixed_sun` int(11) NOT NULL,
  328. `sun_position` float NOT NULL,
  329. `covenant` char(36) default NULL,
  330. `Sandbox` tinyint(4) NOT NULL,
  331. PRIMARY KEY (`regionUUID`)
  332. ) ENGINE=InnoDB;
  333. commit;
  334. :VERSION 16 #---------------------
  335. BEGIN;
  336. ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0;
  337. ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0;
  338. ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0;
  339. ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0;
  340. ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0;
  341. ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000';
  342. ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0;
  343. ALTER TABLE prims ADD COLUMN TextureAnimation blob;
  344. ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0;
  345. ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0;
  346. ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0;
  347. ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0;
  348. ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0;
  349. ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0;
  350. ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0;
  351. ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0;
  352. ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0;
  353. ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0;
  354. ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0;
  355. ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0;
  356. ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0;
  357. ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10;
  358. ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0;
  359. COMMIT;
  360. :VERSION 17 #---------------------
  361. BEGIN;
  362. ALTER TABLE prims ADD COLUMN ColorR integer not null default 0;
  363. ALTER TABLE prims ADD COLUMN ColorG integer not null default 0;
  364. ALTER TABLE prims ADD COLUMN ColorB integer not null default 0;
  365. ALTER TABLE prims ADD COLUMN ColorA integer not null default 0;
  366. ALTER TABLE prims ADD COLUMN ParticleSystem blob;
  367. COMMIT;
  368. :VERSION 18 #---------------------
  369. begin;
  370. ALTER TABLE prims ADD COLUMN ClickAction tinyint NOT NULL default 0;
  371. commit;
  372. :VERSION 19 #---------------------
  373. begin;
  374. ALTER TABLE prims ADD COLUMN Material tinyint NOT NULL default 3;
  375. commit;
  376. :VERSION 20 #---------------------
  377. begin;
  378. ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0;
  379. ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0;
  380. commit;
  381. :VERSION 21 #---------------------
  382. begin;
  383. ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0;
  384. ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0;
  385. ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0;
  386. commit;
  387. :VERSION 22 #---------------------
  388. BEGIN;
  389. ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000';
  390. ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0;
  391. COMMIT;
  392. :VERSION 23 #---------------------
  393. BEGIN;
  394. ALTER TABLE prims ADD COLUMN LinkNumber integer not null default 0;
  395. COMMIT;
  396. :VERSION 24 #---------------------
  397. BEGIN;
  398. alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL;
  399. alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL;
  400. alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL;
  401. alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL;
  402. alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL;
  403. alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL;
  404. alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL;
  405. alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL;
  406. alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL;
  407. alter table regionsettings change column `water_height` `water_height` double NOT NULL;
  408. alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL;
  409. alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL;
  410. alter table regionsettings change column `sun_position` `sun_position` double NOT NULL;
  411. COMMIT;
  412. :VERSION 25 #---------------------
  413. BEGIN;
  414. alter table prims change column `PositionX` `PositionX` double default NULL;
  415. alter table prims change column `PositionY` `PositionY` double default NULL;
  416. alter table prims change column `PositionZ` `PositionZ` double default NULL;
  417. alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;
  418. alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;
  419. alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;
  420. alter table prims change column `VelocityX` `VelocityX` double default NULL;
  421. alter table prims change column `VelocityY` `VelocityY` double default NULL;
  422. alter table prims change column `VelocityZ` `VelocityZ` double default NULL;
  423. alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;
  424. alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;
  425. alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;
  426. alter table prims change column `AccelerationX` `AccelerationX` double default NULL;
  427. alter table prims change column `AccelerationY` `AccelerationY` double default NULL;
  428. alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;
  429. alter table prims change column `RotationX` `RotationX` double default NULL;
  430. alter table prims change column `RotationY` `RotationY` double default NULL;
  431. alter table prims change column `RotationZ` `RotationZ` double default NULL;
  432. alter table prims change column `RotationW` `RotationW` double default NULL;
  433. alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;
  434. alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;
  435. alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;
  436. alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;
  437. alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;
  438. alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;
  439. alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;
  440. alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';
  441. alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';
  442. alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';
  443. alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';
  444. alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';
  445. alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';
  446. alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';
  447. alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';
  448. alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';
  449. alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';
  450. alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';
  451. alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0';
  452. alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0';
  453. alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0';
  454. COMMIT;
  455. :VERSION 26 #---------------------
  456. begin;
  457. alter table prims change column `PositionX` `PositionX` double default NULL;
  458. alter table prims change column `PositionY` `PositionY` double default NULL;
  459. alter table prims change column `PositionZ` `PositionZ` double default NULL;
  460. alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;
  461. alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;
  462. alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;
  463. alter table prims change column `VelocityX` `VelocityX` double default NULL;
  464. alter table prims change column `VelocityY` `VelocityY` double default NULL;
  465. alter table prims change column `VelocityZ` `VelocityZ` double default NULL;
  466. alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;
  467. alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;
  468. alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;
  469. alter table prims change column `AccelerationX` `AccelerationX` double default NULL;
  470. alter table prims change column `AccelerationY` `AccelerationY` double default NULL;
  471. alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;
  472. alter table prims change column `RotationX` `RotationX` double default NULL;
  473. alter table prims change column `RotationY` `RotationY` double default NULL;
  474. alter table prims change column `RotationZ` `RotationZ` double default NULL;
  475. alter table prims change column `RotationW` `RotationW` double default NULL;
  476. alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;
  477. alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;
  478. alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;
  479. alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;
  480. alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;
  481. alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;
  482. alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;
  483. alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';
  484. alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';
  485. alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';
  486. alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';
  487. alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';
  488. alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';
  489. alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';
  490. alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';
  491. alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';
  492. alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';
  493. alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';
  494. commit;
  495. :VERSION 27 #---------------------
  496. BEGIN;
  497. ALTER TABLE prims DROP COLUMN ParentID;
  498. COMMIT;
  499. :VERSION 28 #---------------------
  500. BEGIN;
  501. update terrain
  502. set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))
  503. where RegionUUID not like '%-%';
  504. update landaccesslist
  505. set LandUUID = concat(substr(LandUUID, 1, 8), "-", substr(LandUUID, 9, 4), "-", substr(LandUUID, 13, 4), "-", substr(LandUUID, 17, 4), "-", substr(LandUUID, 21, 12))
  506. where LandUUID not like '%-%';
  507. update landaccesslist
  508. set AccessUUID = concat(substr(AccessUUID, 1, 8), "-", substr(AccessUUID, 9, 4), "-", substr(AccessUUID, 13, 4), "-", substr(AccessUUID, 17, 4), "-", substr(AccessUUID, 21, 12))
  509. where AccessUUID not like '%-%';
  510. update prims
  511. set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))
  512. where UUID not like '%-%';
  513. update prims
  514. set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))
  515. where RegionUUID not like '%-%';
  516. update prims
  517. set SceneGroupID = concat(substr(SceneGroupID, 1, 8), "-", substr(SceneGroupID, 9, 4), "-", substr(SceneGroupID, 13, 4), "-", substr(SceneGroupID, 17, 4), "-", substr(SceneGroupID, 21, 12))
  518. where SceneGroupID not like '%-%';
  519. update prims
  520. set CreatorID = concat(substr(CreatorID, 1, 8), "-", substr(CreatorID, 9, 4), "-", substr(CreatorID, 13, 4), "-", substr(CreatorID, 17, 4), "-", substr(CreatorID, 21, 12))
  521. where CreatorID not like '%-%';
  522. update prims
  523. set OwnerID = concat(substr(OwnerID, 1, 8), "-", substr(OwnerID, 9, 4), "-", substr(OwnerID, 13, 4), "-", substr(OwnerID, 17, 4), "-", substr(OwnerID, 21, 12))
  524. where OwnerID not like '%-%';
  525. update prims
  526. set GroupID = concat(substr(GroupID, 1, 8), "-", substr(GroupID, 9, 4), "-", substr(GroupID, 13, 4), "-", substr(GroupID, 17, 4), "-", substr(GroupID, 21, 12))
  527. where GroupID not like '%-%';
  528. update prims
  529. set LastOwnerID = concat(substr(LastOwnerID, 1, 8), "-", substr(LastOwnerID, 9, 4), "-", substr(LastOwnerID, 13, 4), "-", substr(LastOwnerID, 17, 4), "-", substr(LastOwnerID, 21, 12))
  530. where LastOwnerID not like '%-%';
  531. update primshapes
  532. set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))
  533. where UUID not like '%-%';
  534. update land
  535. set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12))
  536. where UUID not like '%-%';
  537. update land
  538. set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12))
  539. where RegionUUID not like '%-%';
  540. update land
  541. set OwnerUUID = concat(substr(OwnerUUID, 1, 8), "-", substr(OwnerUUID, 9, 4), "-", substr(OwnerUUID, 13, 4), "-", substr(OwnerUUID, 17, 4), "-", substr(OwnerUUID, 21, 12))
  542. where OwnerUUID not like '%-%';
  543. update land
  544. set GroupUUID = concat(substr(GroupUUID, 1, 8), "-", substr(GroupUUID, 9, 4), "-", substr(GroupUUID, 13, 4), "-", substr(GroupUUID, 17, 4), "-", substr(GroupUUID, 21, 12))
  545. where GroupUUID not like '%-%';
  546. update land
  547. set MediaTextureUUID = concat(substr(MediaTextureUUID, 1, 8), "-", substr(MediaTextureUUID, 9, 4), "-", substr(MediaTextureUUID, 13, 4), "-", substr(MediaTextureUUID, 17, 4), "-", substr(MediaTextureUUID, 21, 12))
  548. where MediaTextureUUID not like '%-%';
  549. update land
  550. set SnapshotUUID = concat(substr(SnapshotUUID, 1, 8), "-", substr(SnapshotUUID, 9, 4), "-", substr(SnapshotUUID, 13, 4), "-", substr(SnapshotUUID, 17, 4), "-", substr(SnapshotUUID, 21, 12))
  551. where SnapshotUUID not like '%-%';
  552. update land
  553. set AuthbuyerID = concat(substr(AuthbuyerID, 1, 8), "-", substr(AuthbuyerID, 9, 4), "-", substr(AuthbuyerID, 13, 4), "-", substr(AuthbuyerID, 17, 4), "-", substr(AuthbuyerID, 21, 12))
  554. where AuthbuyerID not like '%-%';
  555. COMMIT;
  556. :VERSION 29 #---------------------
  557. BEGIN;
  558. ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0;
  559. COMMIT;
  560. :VERSION 30 #---------------------
  561. BEGIN;
  562. ALTER TABLE regionsettings ADD COLUMN loaded_creation_date varchar(20) default NULL;
  563. ALTER TABLE regionsettings ADD COLUMN loaded_creation_time varchar(20) default NULL;
  564. ALTER TABLE regionsettings ADD COLUMN loaded_creation_id varchar(64) default NULL;
  565. COMMIT;
  566. :VERSION 31 #---------------------
  567. BEGIN;
  568. ALTER TABLE regionsettings DROP COLUMN loaded_creation_date;
  569. ALTER TABLE regionsettings DROP COLUMN loaded_creation_time;
  570. ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0;
  571. COMMIT;
  572. :VERSION 32
  573. BEGIN;
  574. CREATE TABLE `regionwindlight` (
  575. `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',
  576. `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000',
  577. `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000',
  578. `water_color_b` float(9,6) unsigned NOT NULL DEFAULT '64.000000',
  579. `water_fog_density_exponent` float(3,1) unsigned NOT NULL DEFAULT '4.0',
  580. `underwater_fog_modifier` float(3,2) unsigned NOT NULL DEFAULT '0.25',
  581. `reflection_wavelet_scale_1` float(3,1) unsigned NOT NULL DEFAULT '2.0',
  582. `reflection_wavelet_scale_2` float(3,1) unsigned NOT NULL DEFAULT '2.0',
  583. `reflection_wavelet_scale_3` float(3,1) unsigned NOT NULL DEFAULT '2.0',
  584. `fresnel_scale` float(3,2) unsigned NOT NULL DEFAULT '0.40',
  585. `fresnel_offset` float(3,2) unsigned NOT NULL DEFAULT '0.50',
  586. `refract_scale_above` float(3,2) unsigned NOT NULL DEFAULT '0.03',
  587. `refract_scale_below` float(3,2) unsigned NOT NULL DEFAULT '0.20',
  588. `blur_multiplier` float(4,3) unsigned NOT NULL DEFAULT '0.040',
  589. `big_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.05',
  590. `big_wave_direction_y` float(3,2) NOT NULL DEFAULT '-0.42',
  591. `little_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.11',
  592. `little_wave_direction_y` float(3,2) NOT NULL DEFAULT '-1.16',
  593. `normal_map_texture` varchar(36) NOT NULL DEFAULT '822ded49-9a6c-f61c-cb89-6df54f42cdf4',
  594. `horizon_r` float(3,2) unsigned NOT NULL DEFAULT '0.25',
  595. `horizon_g` float(3,2) unsigned NOT NULL DEFAULT '0.25',
  596. `horizon_b` float(3,2) unsigned NOT NULL DEFAULT '0.32',
  597. `horizon_i` float(3,2) unsigned NOT NULL DEFAULT '0.32',
  598. `haze_horizon` float(3,2) unsigned NOT NULL DEFAULT '0.19',
  599. `blue_density_r` float(3,2) unsigned NOT NULL DEFAULT '0.12',
  600. `blue_density_g` float(3,2) unsigned NOT NULL DEFAULT '0.22',
  601. `blue_density_b` float(3,2) unsigned NOT NULL DEFAULT '0.38',
  602. `blue_density_i` float(3,2) unsigned NOT NULL DEFAULT '0.38',
  603. `haze_density` float(3,2) unsigned NOT NULL DEFAULT '0.70',
  604. `density_multiplier` float(3,2) unsigned NOT NULL DEFAULT '0.18',
  605. `distance_multiplier` float(4,1) unsigned NOT NULL DEFAULT '0.8',
  606. `max_altitude` int(4) unsigned NOT NULL DEFAULT '1605',
  607. `sun_moon_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.24',
  608. `sun_moon_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.26',
  609. `sun_moon_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.30',
  610. `sun_moon_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.30',
  611. `sun_moon_position` float(4,3) unsigned NOT NULL DEFAULT '0.317',
  612. `ambient_r` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  613. `ambient_g` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  614. `ambient_b` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  615. `ambient_i` float(3,2) unsigned NOT NULL DEFAULT '0.35',
  616. `east_angle` float(3,2) unsigned NOT NULL DEFAULT '0.00',
  617. `sun_glow_focus` float(3,2) unsigned NOT NULL DEFAULT '0.10',
  618. `sun_glow_size` float(3,2) unsigned NOT NULL DEFAULT '1.75',
  619. `scene_gamma` float(4,2) unsigned NOT NULL DEFAULT '1.00',
  620. `star_brightness` float(3,2) unsigned NOT NULL DEFAULT '0.00',
  621. `cloud_color_r` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  622. `cloud_color_g` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  623. `cloud_color_b` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  624. `cloud_color_i` float(3,2) unsigned NOT NULL DEFAULT '0.41',
  625. `cloud_x` float(3,2) unsigned NOT NULL DEFAULT '1.00',
  626. `cloud_y` float(3,2) unsigned NOT NULL DEFAULT '0.53',
  627. `cloud_density` float(3,2) unsigned NOT NULL DEFAULT '1.00',
  628. `cloud_coverage` float(3,2) unsigned NOT NULL DEFAULT '0.27',
  629. `cloud_scale` float(3,2) unsigned NOT NULL DEFAULT '0.42',
  630. `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00',
  631. `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53',
  632. `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12',
  633. `cloud_scroll_x` float(3,2) unsigned NOT NULL DEFAULT '0.20',
  634. `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  635. `cloud_scroll_y` float(3,2) unsigned NOT NULL DEFAULT '0.01',
  636. `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  637. `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1',
  638. PRIMARY KEY (`region_id`)
  639. );
  640. :VERSION 33 #---------------------
  641. BEGIN;
  642. ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
  643. COMMIT;
  644. :VERSION 34 #---------------------
  645. BEGIN;
  646. ALTER TABLE `regionwindlight` CHANGE COLUMN `cloud_scroll_x` `cloud_scroll_x` FLOAT(4,2) NOT NULL DEFAULT '0.20' AFTER `cloud_detail_density`, CHANGE COLUMN `cloud_scroll_y` `cloud_scroll_y` FLOAT(4,2) NOT NULL DEFAULT '0.01' AFTER `cloud_scroll_x_lock`;
  647. COMMIT;
  648. :VERSION 35 #---------------------
  649. BEGIN;
  650. ALTER TABLE prims ADD COLUMN MediaURL varchar(255);
  651. ALTER TABLE primshapes ADD COLUMN Media TEXT;
  652. COMMIT;
  653. :VERSION 36 #---------------------
  654. BEGIN;
  655. ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none' ;
  656. ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT '';
  657. ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0';
  658. ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE;
  659. ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE;
  660. ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE;
  661. COMMIT;
  662. :VERSION 37 #---------------------
  663. BEGIN;
  664. ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';
  665. ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';
  666. COMMIT;
  667. :VERSION 38 #---------------------
  668. BEGIN;
  669. alter table land ENGINE = MyISAM;
  670. alter table landaccesslist ENGINE = MyISAM;
  671. alter table migrations ENGINE = MyISAM;
  672. alter table primitems ENGINE = MyISAM;
  673. alter table prims ENGINE = MyISAM;
  674. alter table primshapes ENGINE = MyISAM;
  675. alter table regionban ENGINE = MyISAM;
  676. alter table regionsettings ENGINE = MyISAM;
  677. alter table terrain ENGINE = MyISAM;
  678. COMMIT;