diff options
author | onefang | 2019-05-19 21:24:15 +1000 |
---|---|---|
committer | onefang | 2019-05-19 21:24:15 +1000 |
commit | 5e4d6cab00cb29cd088ab7b62ab13aff103b64cb (patch) | |
tree | a9fbc62df9eb2d1d9ba2698d8552eae71eca20d8 /OpenSim/Data/MySQL/Resources/RegionStore.migrations | |
parent | Add a build script. (diff) | |
download | opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.zip opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.gz opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.bz2 opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.xz |
Dump OpenSim 0.9.0.1 into it's own branch.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 1183 |
1 files changed, 351 insertions, 832 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index 834d249..0577392 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -1,354 +1,226 @@ | |||
1 | 1 | ||
2 | :VERSION 1 #--------------------- | 2 | :VERSION 51 #--------------------- |
3 | 3 | ||
4 | BEGIN; | 4 | BEGIN; |
5 | 5 | ||
6 | CREATE TABLE `prims` ( | 6 | CREATE TABLE IF NOT EXISTS `prims` ( |
7 | `UUID` varchar(255) NOT NULL, | 7 | `CreationDate` int(11) DEFAULT NULL, |
8 | `RegionUUID` varchar(255) default NULL, | 8 | `Name` varchar(255) DEFAULT NULL, |
9 | `ParentID` int(11) default NULL, | 9 | `Text` varchar(255) DEFAULT NULL, |
10 | `CreationDate` int(11) default NULL, | 10 | `Description` varchar(255) DEFAULT NULL, |
11 | `Name` varchar(255) default NULL, | 11 | `SitName` varchar(255) DEFAULT NULL, |
12 | `SceneGroupID` varchar(255) default NULL, | 12 | `TouchName` varchar(255) DEFAULT NULL, |
13 | `Text` varchar(255) default NULL, | 13 | `ObjectFlags` int(11) DEFAULT NULL, |
14 | `Description` varchar(255) default NULL, | 14 | `OwnerMask` int(11) DEFAULT NULL, |
15 | `SitName` varchar(255) default NULL, | 15 | `NextOwnerMask` int(11) DEFAULT NULL, |
16 | `TouchName` varchar(255) default NULL, | 16 | `GroupMask` int(11) DEFAULT NULL, |
17 | `ObjectFlags` int(11) default NULL, | 17 | `EveryoneMask` int(11) DEFAULT NULL, |
18 | `CreatorID` varchar(255) default NULL, | 18 | `BaseMask` int(11) DEFAULT NULL, |
19 | `OwnerID` varchar(255) default NULL, | 19 | `PositionX` double DEFAULT NULL, |
20 | `GroupID` varchar(255) default NULL, | 20 | `PositionY` double DEFAULT NULL, |
21 | `LastOwnerID` varchar(255) default NULL, | 21 | `PositionZ` double DEFAULT NULL, |
22 | `OwnerMask` int(11) default NULL, | 22 | `GroupPositionX` double DEFAULT NULL, |
23 | `NextOwnerMask` int(11) default NULL, | 23 | `GroupPositionY` double DEFAULT NULL, |
24 | `GroupMask` int(11) default NULL, | 24 | `GroupPositionZ` double DEFAULT NULL, |
25 | `EveryoneMask` int(11) default NULL, | 25 | `VelocityX` double DEFAULT NULL, |
26 | `BaseMask` int(11) default NULL, | 26 | `VelocityY` double DEFAULT NULL, |
27 | `PositionX` float default NULL, | 27 | `VelocityZ` double DEFAULT NULL, |
28 | `PositionY` float default NULL, | 28 | `AngularVelocityX` double DEFAULT NULL, |
29 | `PositionZ` float default NULL, | 29 | `AngularVelocityY` double DEFAULT NULL, |
30 | `GroupPositionX` float default NULL, | 30 | `AngularVelocityZ` double DEFAULT NULL, |
31 | `GroupPositionY` float default NULL, | 31 | `AccelerationX` double DEFAULT NULL, |
32 | `GroupPositionZ` float default NULL, | 32 | `AccelerationY` double DEFAULT NULL, |
33 | `VelocityX` float default NULL, | 33 | `AccelerationZ` double DEFAULT NULL, |
34 | `VelocityY` float default NULL, | 34 | `RotationX` double DEFAULT NULL, |
35 | `VelocityZ` float default NULL, | 35 | `RotationY` double DEFAULT NULL, |
36 | `AngularVelocityX` float default NULL, | 36 | `RotationZ` double DEFAULT NULL, |
37 | `AngularVelocityY` float default NULL, | 37 | `RotationW` double DEFAULT NULL, |
38 | `AngularVelocityZ` float default NULL, | 38 | `SitTargetOffsetX` double DEFAULT NULL, |
39 | `AccelerationX` float default NULL, | 39 | `SitTargetOffsetY` double DEFAULT NULL, |
40 | `AccelerationY` float default NULL, | 40 | `SitTargetOffsetZ` double DEFAULT NULL, |
41 | `AccelerationZ` float default NULL, | 41 | `SitTargetOrientW` double DEFAULT NULL, |
42 | `RotationX` float default NULL, | 42 | `SitTargetOrientX` double DEFAULT NULL, |
43 | `RotationY` float default NULL, | 43 | `SitTargetOrientY` double DEFAULT NULL, |
44 | `RotationZ` float default NULL, | 44 | `SitTargetOrientZ` double DEFAULT NULL, |
45 | `RotationW` float default NULL, | 45 | `UUID` char(36) NOT NULL DEFAULT '', |
46 | `SitTargetOffsetX` float default NULL, | 46 | `RegionUUID` char(36) DEFAULT NULL, |
47 | `SitTargetOffsetY` float default NULL, | 47 | `CreatorID` varchar(255) NOT NULL DEFAULT '', |
48 | `SitTargetOffsetZ` float default NULL, | 48 | `OwnerID` char(36) DEFAULT NULL, |
49 | `SitTargetOrientW` float default NULL, | 49 | `GroupID` char(36) DEFAULT NULL, |
50 | `SitTargetOrientX` float default NULL, | 50 | `LastOwnerID` char(36) DEFAULT NULL, |
51 | `SitTargetOrientY` float default NULL, | 51 | `SceneGroupID` char(36) DEFAULT NULL, |
52 | `SitTargetOrientZ` float default NULL, | 52 | `PayPrice` int(11) NOT NULL DEFAULT '0', |
53 | PRIMARY KEY (`UUID`) | 53 | `PayButton1` int(11) NOT NULL DEFAULT '0', |
54 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 54 | `PayButton2` int(11) NOT NULL DEFAULT '0', |
55 | 55 | `PayButton3` int(11) NOT NULL DEFAULT '0', | |
56 | CREATE TABLE `primshapes` ( | 56 | `PayButton4` int(11) NOT NULL DEFAULT '0', |
57 | `UUID` varchar(255) NOT NULL, | 57 | `LoopedSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
58 | `Shape` int(11) default NULL, | 58 | `LoopedSoundGain` double NOT NULL DEFAULT '0', |
59 | `ScaleX` float default NULL, | 59 | `TextureAnimation` blob, |
60 | `ScaleY` float default NULL, | 60 | `OmegaX` double NOT NULL DEFAULT '0', |
61 | `ScaleZ` float default NULL, | 61 | `OmegaY` double NOT NULL DEFAULT '0', |
62 | `PCode` int(11) default NULL, | 62 | `OmegaZ` double NOT NULL DEFAULT '0', |
63 | `PathBegin` int(11) default NULL, | 63 | `CameraEyeOffsetX` double NOT NULL DEFAULT '0', |
64 | `PathEnd` int(11) default NULL, | 64 | `CameraEyeOffsetY` double NOT NULL DEFAULT '0', |
65 | `PathScaleX` int(11) default NULL, | 65 | `CameraEyeOffsetZ` double NOT NULL DEFAULT '0', |
66 | `PathScaleY` int(11) default NULL, | 66 | `CameraAtOffsetX` double NOT NULL DEFAULT '0', |
67 | `PathShearX` int(11) default NULL, | 67 | `CameraAtOffsetY` double NOT NULL DEFAULT '0', |
68 | `PathShearY` int(11) default NULL, | 68 | `CameraAtOffsetZ` double NOT NULL DEFAULT '0', |
69 | `PathSkew` int(11) default NULL, | 69 | `ForceMouselook` tinyint(4) NOT NULL DEFAULT '0', |
70 | `PathCurve` int(11) default NULL, | 70 | `ScriptAccessPin` int(11) NOT NULL DEFAULT '0', |
71 | `PathRadiusOffset` int(11) default NULL, | 71 | `AllowedDrop` tinyint(4) NOT NULL DEFAULT '0', |
72 | `PathRevolutions` int(11) default NULL, | 72 | `DieAtEdge` tinyint(4) NOT NULL DEFAULT '0', |
73 | `PathTaperX` int(11) default NULL, | 73 | `SalePrice` int(11) NOT NULL DEFAULT '10', |
74 | `PathTaperY` int(11) default NULL, | 74 | `SaleType` tinyint(4) NOT NULL DEFAULT '0', |
75 | `PathTwist` int(11) default NULL, | 75 | `ColorR` int(11) NOT NULL DEFAULT '0', |
76 | `PathTwistBegin` int(11) default NULL, | 76 | `ColorG` int(11) NOT NULL DEFAULT '0', |
77 | `ProfileBegin` int(11) default NULL, | 77 | `ColorB` int(11) NOT NULL DEFAULT '0', |
78 | `ProfileEnd` int(11) default NULL, | 78 | `ColorA` int(11) NOT NULL DEFAULT '0', |
79 | `ProfileCurve` int(11) default NULL, | 79 | `ParticleSystem` blob, |
80 | `ProfileHollow` int(11) default NULL, | 80 | `ClickAction` tinyint(4) NOT NULL DEFAULT '0', |
81 | `State` int(11) default NULL, | 81 | `Material` tinyint(4) NOT NULL DEFAULT '3', |
82 | `CollisionSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
83 | `CollisionSoundVolume` double NOT NULL DEFAULT '0', | ||
84 | `LinkNumber` int(11) NOT NULL DEFAULT '0', | ||
85 | `PassTouches` tinyint(4) NOT NULL DEFAULT '0', | ||
86 | `MediaURL` varchar(255) DEFAULT NULL, | ||
87 | `DynAttrs` text, | ||
88 | `PhysicsShapeType` tinyint(4) NOT NULL DEFAULT '0', | ||
89 | `Density` double NOT NULL DEFAULT '1000', | ||
90 | `GravityModifier` double NOT NULL DEFAULT '1', | ||
91 | `Friction` double NOT NULL DEFAULT '0.6', | ||
92 | `Restitution` double NOT NULL DEFAULT '0.5', | ||
93 | `KeyframeMotion` blob, | ||
94 | `AttachedPosX` double DEFAULT '0', | ||
95 | `AttachedPosY` double DEFAULT '0', | ||
96 | `AttachedPosZ` double DEFAULT '0', | ||
97 | PRIMARY KEY (`UUID`), | ||
98 | KEY `prims_regionuuid` (`RegionUUID`), | ||
99 | KEY `prims_scenegroupid` (`SceneGroupID`) | ||
100 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
101 | |||
102 | CREATE TABLE IF NOT EXISTS `primshapes` ( | ||
103 | `Shape` int(11) DEFAULT NULL, | ||
104 | `ScaleX` double NOT NULL DEFAULT '0', | ||
105 | `ScaleY` double NOT NULL DEFAULT '0', | ||
106 | `ScaleZ` double NOT NULL DEFAULT '0', | ||
107 | `PCode` int(11) DEFAULT NULL, | ||
108 | `PathBegin` int(11) DEFAULT NULL, | ||
109 | `PathEnd` int(11) DEFAULT NULL, | ||
110 | `PathScaleX` int(11) DEFAULT NULL, | ||
111 | `PathScaleY` int(11) DEFAULT NULL, | ||
112 | `PathShearX` int(11) DEFAULT NULL, | ||
113 | `PathShearY` int(11) DEFAULT NULL, | ||
114 | `PathSkew` int(11) DEFAULT NULL, | ||
115 | `PathCurve` int(11) DEFAULT NULL, | ||
116 | `PathRadiusOffset` int(11) DEFAULT NULL, | ||
117 | `PathRevolutions` int(11) DEFAULT NULL, | ||
118 | `PathTaperX` int(11) DEFAULT NULL, | ||
119 | `PathTaperY` int(11) DEFAULT NULL, | ||
120 | `PathTwist` int(11) DEFAULT NULL, | ||
121 | `PathTwistBegin` int(11) DEFAULT NULL, | ||
122 | `ProfileBegin` int(11) DEFAULT NULL, | ||
123 | `ProfileEnd` int(11) DEFAULT NULL, | ||
124 | `ProfileCurve` int(11) DEFAULT NULL, | ||
125 | `ProfileHollow` int(11) DEFAULT NULL, | ||
126 | `State` int(11) DEFAULT NULL, | ||
82 | `Texture` longblob, | 127 | `Texture` longblob, |
83 | `ExtraParams` longblob, | 128 | `ExtraParams` longblob, |
84 | PRIMARY KEY (`UUID`) | 129 | `UUID` char(36) NOT NULL DEFAULT '', |
85 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 130 | `Media` text, |
86 | 131 | `LastAttachPoint` int(4) NOT NULL DEFAULT '0', | |
87 | CREATE TABLE `primitems` ( | 132 | PRIMARY KEY (`UUID`) |
88 | `itemID` varchar(255) NOT NULL, | 133 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
89 | `primID` varchar(255) default NULL, | 134 | |
90 | `assetID` varchar(255) default NULL, | 135 | CREATE TABLE IF NOT EXISTS `primitems` ( |
91 | `parentFolderID` varchar(255) default NULL, | 136 | `invType` int(11) DEFAULT NULL, |
92 | `invType` int(11) default NULL, | 137 | `assetType` int(11) DEFAULT NULL, |
93 | `assetType` int(11) default NULL, | 138 | `name` varchar(255) DEFAULT NULL, |
94 | `name` varchar(255) default NULL, | 139 | `description` varchar(255) DEFAULT NULL, |
95 | `description` varchar(255) default NULL, | 140 | `creationDate` bigint(20) DEFAULT NULL, |
96 | `creationDate` bigint(20) default NULL, | 141 | `nextPermissions` int(11) DEFAULT NULL, |
97 | `creatorID` varchar(255) default NULL, | 142 | `currentPermissions` int(11) DEFAULT NULL, |
98 | `ownerID` varchar(255) default NULL, | 143 | `basePermissions` int(11) DEFAULT NULL, |
99 | `lastOwnerID` varchar(255) default NULL, | 144 | `everyonePermissions` int(11) DEFAULT NULL, |
100 | `groupID` varchar(255) default NULL, | 145 | `groupPermissions` int(11) DEFAULT NULL, |
101 | `nextPermissions` int(11) default NULL, | 146 | `flags` int(11) NOT NULL DEFAULT '0', |
102 | `currentPermissions` int(11) default NULL, | 147 | `itemID` char(36) NOT NULL DEFAULT '', |
103 | `basePermissions` int(11) default NULL, | 148 | `primID` char(36) DEFAULT NULL, |
104 | `everyonePermissions` int(11) default NULL, | 149 | `assetID` char(36) DEFAULT NULL, |
105 | `groupPermissions` int(11) default NULL, | 150 | `parentFolderID` char(36) DEFAULT NULL, |
106 | PRIMARY KEY (`itemID`) | 151 | `CreatorID` varchar(255) NOT NULL DEFAULT '', |
107 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 152 | `ownerID` char(36) DEFAULT NULL, |
108 | 153 | `groupID` char(36) DEFAULT NULL, | |
109 | CREATE TABLE `terrain` ( | 154 | `lastOwnerID` char(36) DEFAULT NULL, |
110 | `RegionUUID` varchar(255) default NULL, | 155 | PRIMARY KEY (`itemID`), |
111 | `Revision` int(11) default NULL, | 156 | KEY `primitems_primid` (`primID`) |
157 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
158 | |||
159 | CREATE TABLE IF NOT EXISTS `terrain` ( | ||
160 | `RegionUUID` varchar(255) DEFAULT NULL, | ||
161 | `Revision` int(11) DEFAULT NULL, | ||
112 | `Heightfield` longblob | 162 | `Heightfield` longblob |
113 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 163 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
114 | 164 | ||
115 | CREATE TABLE `land` ( | 165 | CREATE TABLE IF NOT EXISTS `land` ( |
116 | `UUID` varchar(255) NOT NULL, | 166 | `UUID` varchar(255) NOT NULL, |
117 | `RegionUUID` varchar(255) default NULL, | 167 | `RegionUUID` varchar(255) DEFAULT NULL, |
118 | `LocalLandID` int(11) default NULL, | 168 | `LocalLandID` int(11) DEFAULT NULL, |
119 | `Bitmap` longblob, | 169 | `Bitmap` longblob, |
120 | `Name` varchar(255) default NULL, | 170 | `Name` varchar(255) DEFAULT NULL, |
121 | `Description` varchar(255) default NULL, | 171 | `Description` varchar(255) DEFAULT NULL, |
122 | `OwnerUUID` varchar(255) default NULL, | 172 | `OwnerUUID` varchar(255) DEFAULT NULL, |
123 | `IsGroupOwned` int(11) default NULL, | 173 | `IsGroupOwned` int(11) DEFAULT NULL, |
124 | `Area` int(11) default NULL, | 174 | `Area` int(11) DEFAULT NULL, |
125 | `AuctionID` int(11) default NULL, | 175 | `AuctionID` int(11) DEFAULT NULL, |
126 | `Category` int(11) default NULL, | 176 | `Category` int(11) DEFAULT NULL, |
127 | `ClaimDate` int(11) default NULL, | 177 | `ClaimDate` int(11) DEFAULT NULL, |
128 | `ClaimPrice` int(11) default NULL, | 178 | `ClaimPrice` int(11) DEFAULT NULL, |
129 | `GroupUUID` varchar(255) default NULL, | 179 | `GroupUUID` varchar(255) DEFAULT NULL, |
130 | `SalePrice` int(11) default NULL, | 180 | `SalePrice` int(11) DEFAULT NULL, |
131 | `LandStatus` int(11) default NULL, | 181 | `LandStatus` int(11) DEFAULT NULL, |
132 | `LandFlags` int(11) default NULL, | 182 | `LandFlags` int(10) unsigned DEFAULT NULL, |
133 | `LandingType` int(11) default NULL, | 183 | `LandingType` int(11) DEFAULT NULL, |
134 | `MediaAutoScale` int(11) default NULL, | 184 | `MediaAutoScale` int(11) DEFAULT NULL, |
135 | `MediaTextureUUID` varchar(255) default NULL, | 185 | `MediaTextureUUID` varchar(255) DEFAULT NULL, |
136 | `MediaURL` varchar(255) default NULL, | 186 | `MediaURL` varchar(255) DEFAULT NULL, |
137 | `MusicURL` varchar(255) default NULL, | 187 | `MusicURL` varchar(255) DEFAULT NULL, |
138 | `PassHours` float default NULL, | 188 | `PassHours` float DEFAULT NULL, |
139 | `PassPrice` int(11) default NULL, | 189 | `PassPrice` int(11) DEFAULT NULL, |
140 | `SnapshotUUID` varchar(255) default NULL, | 190 | `SnapshotUUID` varchar(255) DEFAULT NULL, |
141 | `UserLocationX` float default NULL, | 191 | `UserLocationX` float DEFAULT NULL, |
142 | `UserLocationY` float default NULL, | 192 | `UserLocationY` float DEFAULT NULL, |
143 | `UserLocationZ` float default NULL, | 193 | `UserLocationZ` float DEFAULT NULL, |
144 | `UserLookAtX` float default NULL, | 194 | `UserLookAtX` float DEFAULT NULL, |
145 | `UserLookAtY` float default NULL, | 195 | `UserLookAtY` float DEFAULT NULL, |
146 | `UserLookAtZ` float default NULL, | 196 | `UserLookAtZ` float DEFAULT NULL, |
147 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 197 | `AuthbuyerID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
148 | PRIMARY KEY (`UUID`) | 198 | `OtherCleanTime` int(11) NOT NULL DEFAULT '0', |
149 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 199 | `Dwell` int(11) NOT NULL DEFAULT '0', |
150 | 200 | `MediaType` varchar(32) NOT NULL DEFAULT 'none/none', | |
151 | CREATE TABLE `landaccesslist` ( | 201 | `MediaDescription` varchar(255) NOT NULL DEFAULT '', |
152 | `LandUUID` varchar(255) default NULL, | 202 | `MediaSize` varchar(16) NOT NULL DEFAULT '0,0', |
153 | `AccessUUID` varchar(255) default NULL, | 203 | `MediaLoop` tinyint(1) NOT NULL DEFAULT '0', |
154 | `Flags` int(11) default NULL | 204 | `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0', |
155 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 205 | `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0', |
156 | 206 | PRIMARY KEY (`UUID`) | |
157 | COMMIT; | 207 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
158 | 208 | ||
159 | :VERSION 2 #--------------------- | 209 | CREATE TABLE IF NOT EXISTS `landaccesslist` ( |
160 | 210 | `LandUUID` varchar(255) DEFAULT NULL, | |
161 | BEGIN; | 211 | `AccessUUID` varchar(255) DEFAULT NULL, |
162 | 212 | `Flags` int(11) DEFAULT NULL, | |
163 | CREATE index prims_regionuuid on prims(RegionUUID); | 213 | `Expires` int(11) NOT NULL DEFAULT '0' |
164 | CREATE index primitems_primid on primitems(primID); | 214 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
165 | 215 | ||
166 | COMMIT; | 216 | CREATE TABLE IF NOT EXISTS `regionban` ( |
167 | 217 | `regionUUID` varchar(36) NOT NULL, | |
168 | :VERSION 3 #--------------------- | 218 | `bannedUUID` varchar(36) NOT NULL, |
169 | 219 | `bannedIp` varchar(16) NOT NULL, | |
170 | BEGIN; | 220 | `bannedIpHostMask` varchar(16) NOT NULL |
171 | CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | 221 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
172 | COMMIT; | 222 | |
173 | 223 | CREATE TABLE IF NOT EXISTS `regionsettings` ( | |
174 | :VERSION 4 #--------------------- | ||
175 | |||
176 | BEGIN; | ||
177 | |||
178 | ALTER TABLE primitems add flags integer not null default 0; | ||
179 | |||
180 | COMMIT; | ||
181 | |||
182 | :VERSION 5 #--------------------- | ||
183 | BEGIN; | ||
184 | |||
185 | create table regionsettings ( | ||
186 | regionUUID char(36) not null, | ||
187 | block_terraform integer not null, | ||
188 | block_fly integer not null, | ||
189 | allow_damage integer not null, | ||
190 | restrict_pushing integer not null, | ||
191 | allow_land_resell integer not null, | ||
192 | allow_land_join_divide integer not null, | ||
193 | block_show_in_search integer not null, | ||
194 | agent_limit integer not null, | ||
195 | object_bonus float not null, | ||
196 | maturity integer not null, | ||
197 | disable_scripts integer not null, | ||
198 | disable_collisions integer not null, | ||
199 | disable_physics integer not null, | ||
200 | terrain_texture_1 char(36) not null, | ||
201 | terrain_texture_2 char(36) not null, | ||
202 | terrain_texture_3 char(36) not null, | ||
203 | terrain_texture_4 char(36) not null, | ||
204 | elevation_1_nw float not null, | ||
205 | elevation_2_nw float not null, | ||
206 | elevation_1_ne float not null, | ||
207 | elevation_2_ne float not null, | ||
208 | elevation_1_se float not null, | ||
209 | elevation_2_se float not null, | ||
210 | elevation_1_sw float not null, | ||
211 | elevation_2_sw float not null, | ||
212 | water_height float not null, | ||
213 | terrain_raise_limit float not null, | ||
214 | terrain_lower_limit float not null, | ||
215 | use_estate_sun integer not null, | ||
216 | fixed_sun integer not null, | ||
217 | sun_position float not null, | ||
218 | covenant char(36), | ||
219 | primary key(regionUUID) | ||
220 | ); | ||
221 | |||
222 | COMMIT; | ||
223 | |||
224 | |||
225 | :VERSION 6 #--------------------- | ||
226 | |||
227 | BEGIN; | ||
228 | |||
229 | alter table landaccesslist ENGINE = MyISAM; | ||
230 | alter table migrations ENGINE = MyISAM; | ||
231 | alter table primitems ENGINE = MyISAM; | ||
232 | alter table prims ENGINE = MyISAM; | ||
233 | alter table primshapes ENGINE = MyISAM; | ||
234 | alter table regionsettings ENGINE = MyISAM; | ||
235 | alter table terrain ENGINE = MyISAM; | ||
236 | |||
237 | COMMIT; | ||
238 | |||
239 | :VERSION 7 #--------------------- | ||
240 | |||
241 | BEGIN; | ||
242 | |||
243 | ALTER TABLE prims change UUID UUIDold varchar(255); | ||
244 | ALTER TABLE prims change RegionUUID RegionUUIDold varchar(255); | ||
245 | ALTER TABLE prims change CreatorID CreatorIDold varchar(255); | ||
246 | ALTER TABLE prims change OwnerID OwnerIDold varchar(255); | ||
247 | ALTER TABLE prims change GroupID GroupIDold varchar(255); | ||
248 | ALTER TABLE prims change LastOwnerID LastOwnerIDold varchar(255); | ||
249 | ALTER TABLE prims add UUID char(36); | ||
250 | ALTER TABLE prims add RegionUUID char(36); | ||
251 | ALTER TABLE prims add CreatorID char(36); | ||
252 | ALTER TABLE prims add OwnerID char(36); | ||
253 | ALTER TABLE prims add GroupID char(36); | ||
254 | ALTER TABLE prims add LastOwnerID char(36); | ||
255 | UPDATE prims set UUID = UUIDold, RegionUUID = RegionUUIDold, CreatorID = CreatorIDold, OwnerID = OwnerIDold, GroupID = GroupIDold, LastOwnerID = LastOwnerIDold; | ||
256 | ALTER TABLE prims drop UUIDold; | ||
257 | ALTER TABLE prims drop RegionUUIDold; | ||
258 | ALTER TABLE prims drop CreatorIDold; | ||
259 | ALTER TABLE prims drop OwnerIDold; | ||
260 | ALTER TABLE prims drop GroupIDold; | ||
261 | ALTER TABLE prims drop LastOwnerIDold; | ||
262 | ALTER TABLE prims add constraint primary key(UUID); | ||
263 | ALTER TABLE prims add index prims_regionuuid(RegionUUID); | ||
264 | |||
265 | COMMIT; | ||
266 | |||
267 | :VERSION 8 #--------------------- | ||
268 | |||
269 | BEGIN; | ||
270 | |||
271 | ALTER TABLE primshapes change UUID UUIDold varchar(255); | ||
272 | ALTER TABLE primshapes add UUID char(36); | ||
273 | UPDATE primshapes set UUID = UUIDold; | ||
274 | ALTER TABLE primshapes drop UUIDold; | ||
275 | ALTER TABLE primshapes add constraint primary key(UUID); | ||
276 | |||
277 | COMMIT; | ||
278 | |||
279 | :VERSION 9 #--------------------- | ||
280 | |||
281 | BEGIN; | ||
282 | |||
283 | ALTER TABLE primitems change itemID itemIDold varchar(255); | ||
284 | ALTER TABLE primitems change primID primIDold varchar(255); | ||
285 | ALTER TABLE primitems change assetID assetIDold varchar(255); | ||
286 | ALTER TABLE primitems change parentFolderID parentFolderIDold varchar(255); | ||
287 | ALTER TABLE primitems change creatorID creatorIDold varchar(255); | ||
288 | ALTER TABLE primitems change ownerID ownerIDold varchar(255); | ||
289 | ALTER TABLE primitems change groupID groupIDold varchar(255); | ||
290 | ALTER TABLE primitems change lastOwnerID lastOwnerIDold varchar(255); | ||
291 | ALTER TABLE primitems add itemID char(36); | ||
292 | ALTER TABLE primitems add primID char(36); | ||
293 | ALTER TABLE primitems add assetID char(36); | ||
294 | ALTER TABLE primitems add parentFolderID char(36); | ||
295 | ALTER TABLE primitems add creatorID char(36); | ||
296 | ALTER TABLE primitems add ownerID char(36); | ||
297 | ALTER TABLE primitems add groupID char(36); | ||
298 | ALTER TABLE primitems add lastOwnerID char(36); | ||
299 | UPDATE primitems set itemID = itemIDold, primID = primIDold, assetID = assetIDold, parentFolderID = parentFolderIDold, creatorID = creatorIDold, ownerID = ownerIDold, groupID = groupIDold, lastOwnerID = lastOwnerIDold; | ||
300 | ALTER TABLE primitems drop itemIDold; | ||
301 | ALTER TABLE primitems drop primIDold; | ||
302 | ALTER TABLE primitems drop assetIDold; | ||
303 | ALTER TABLE primitems drop parentFolderIDold; | ||
304 | ALTER TABLE primitems drop creatorIDold; | ||
305 | ALTER TABLE primitems drop ownerIDold; | ||
306 | ALTER TABLE primitems drop groupIDold; | ||
307 | ALTER TABLE primitems drop lastOwnerIDold; | ||
308 | ALTER TABLE primitems add constraint primary key(itemID); | ||
309 | ALTER TABLE primitems add index primitems_primid(primID); | ||
310 | |||
311 | COMMIT; | ||
312 | |||
313 | :VERSION 10 #--------------------- | ||
314 | |||
315 | # 1 "010_RegionStore.sql" | ||
316 | # 1 "<built-in>" | ||
317 | # 1 "<command line>" | ||
318 | # 1 "010_RegionStore.sql" | ||
319 | BEGIN; | ||
320 | |||
321 | DELETE FROM regionsettings; | ||
322 | |||
323 | COMMIT; | ||
324 | |||
325 | |||
326 | :VERSION 11 #--------------------- | ||
327 | |||
328 | BEGIN; | ||
329 | |||
330 | ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255); | ||
331 | ALTER TABLE prims add SceneGroupID char(36); | ||
332 | UPDATE prims set SceneGroupID = SceneGroupIDold; | ||
333 | ALTER TABLE prims drop SceneGroupIDold; | ||
334 | ALTER TABLE prims add index prims_scenegroupid(SceneGroupID); | ||
335 | |||
336 | COMMIT; | ||
337 | |||
338 | :VERSION 12 #--------------------- | ||
339 | |||
340 | BEGIN; | ||
341 | |||
342 | ALTER TABLE prims add index prims_parentid(ParentID); | ||
343 | |||
344 | COMMIT; | ||
345 | |||
346 | :VERSION 13 #--------------------- | ||
347 | begin; | ||
348 | |||
349 | drop table regionsettings; | ||
350 | |||
351 | CREATE TABLE `regionsettings` ( | ||
352 | `regionUUID` char(36) NOT NULL, | 224 | `regionUUID` char(36) NOT NULL, |
353 | `block_terraform` int(11) NOT NULL, | 225 | `block_terraform` int(11) NOT NULL, |
354 | `block_fly` int(11) NOT NULL, | 226 | `block_fly` int(11) NOT NULL, |
@@ -358,7 +230,7 @@ CREATE TABLE `regionsettings` ( | |||
358 | `allow_land_join_divide` int(11) NOT NULL, | 230 | `allow_land_join_divide` int(11) NOT NULL, |
359 | `block_show_in_search` int(11) NOT NULL, | 231 | `block_show_in_search` int(11) NOT NULL, |
360 | `agent_limit` int(11) NOT NULL, | 232 | `agent_limit` int(11) NOT NULL, |
361 | `object_bonus` float NOT NULL, | 233 | `object_bonus` double NOT NULL, |
362 | `maturity` int(11) NOT NULL, | 234 | `maturity` int(11) NOT NULL, |
363 | `disable_scripts` int(11) NOT NULL, | 235 | `disable_scripts` int(11) NOT NULL, |
364 | `disable_collisions` int(11) NOT NULL, | 236 | `disable_collisions` int(11) NOT NULL, |
@@ -367,360 +239,35 @@ CREATE TABLE `regionsettings` ( | |||
367 | `terrain_texture_2` char(36) NOT NULL, | 239 | `terrain_texture_2` char(36) NOT NULL, |
368 | `terrain_texture_3` char(36) NOT NULL, | 240 | `terrain_texture_3` char(36) NOT NULL, |
369 | `terrain_texture_4` char(36) NOT NULL, | 241 | `terrain_texture_4` char(36) NOT NULL, |
370 | `elevation_1_nw` float NOT NULL, | 242 | `elevation_1_nw` double NOT NULL, |
371 | `elevation_2_nw` float NOT NULL, | 243 | `elevation_2_nw` double NOT NULL, |
372 | `elevation_1_ne` float NOT NULL, | 244 | `elevation_1_ne` double NOT NULL, |
373 | `elevation_2_ne` float NOT NULL, | 245 | `elevation_2_ne` double NOT NULL, |
374 | `elevation_1_se` float NOT NULL, | 246 | `elevation_1_se` double NOT NULL, |
375 | `elevation_2_se` float NOT NULL, | 247 | `elevation_2_se` double NOT NULL, |
376 | `elevation_1_sw` float NOT NULL, | 248 | `elevation_1_sw` double NOT NULL, |
377 | `elevation_2_sw` float NOT NULL, | 249 | `elevation_2_sw` double NOT NULL, |
378 | `water_height` float NOT NULL, | 250 | `water_height` double NOT NULL, |
379 | `terrain_raise_limit` float NOT NULL, | 251 | `terrain_raise_limit` double NOT NULL, |
380 | `terrain_lower_limit` float NOT NULL, | 252 | `terrain_lower_limit` double NOT NULL, |
381 | `use_estate_sun` int(11) NOT NULL, | 253 | `use_estate_sun` int(11) NOT NULL, |
382 | `fixed_sun` int(11) NOT NULL, | 254 | `fixed_sun` int(11) NOT NULL, |
383 | `sun_position` float NOT NULL, | 255 | `sun_position` double NOT NULL, |
384 | `covenant` char(36) default NULL, | 256 | `covenant` char(36) DEFAULT NULL, |
385 | `Sandbox` tinyint(4) NOT NULL, | 257 | `Sandbox` tinyint(4) NOT NULL, |
386 | PRIMARY KEY (`regionUUID`) | 258 | `sunvectorx` double NOT NULL DEFAULT '0', |
387 | ) ENGINE=MyISAM; | 259 | `sunvectory` double NOT NULL DEFAULT '0', |
388 | 260 | `sunvectorz` double NOT NULL DEFAULT '0', | |
389 | commit; | 261 | `loaded_creation_id` varchar(64) DEFAULT NULL, |
390 | 262 | `loaded_creation_datetime` int(10) unsigned NOT NULL DEFAULT '0', | |
391 | :VERSION 16 #--------------------- | 263 | `map_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
392 | 264 | `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | |
393 | BEGIN; | 265 | `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
394 | 266 | `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0', | |
395 | ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0; | 267 | PRIMARY KEY (`regionUUID`) |
396 | ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0; | 268 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
397 | ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0; | 269 | |
398 | ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0; | 270 | CREATE TABLE IF NOT EXISTS `regionwindlight` ( |
399 | ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0; | ||
400 | ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
401 | ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0; | ||
402 | ALTER TABLE prims ADD COLUMN TextureAnimation blob; | ||
403 | ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0; | ||
404 | ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0; | ||
405 | ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0; | ||
406 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0; | ||
407 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0; | ||
408 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0; | ||
409 | ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0; | ||
410 | ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0; | ||
411 | ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0; | ||
412 | ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0; | ||
413 | ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0; | ||
414 | ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0; | ||
415 | ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0; | ||
416 | ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10; | ||
417 | ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0; | ||
418 | |||
419 | COMMIT; | ||
420 | |||
421 | |||
422 | :VERSION 17 #--------------------- | ||
423 | |||
424 | BEGIN; | ||
425 | |||
426 | ALTER TABLE prims ADD COLUMN ColorR integer not null default 0; | ||
427 | ALTER TABLE prims ADD COLUMN ColorG integer not null default 0; | ||
428 | ALTER TABLE prims ADD COLUMN ColorB integer not null default 0; | ||
429 | ALTER TABLE prims ADD COLUMN ColorA integer not null default 0; | ||
430 | ALTER TABLE prims ADD COLUMN ParticleSystem blob; | ||
431 | |||
432 | COMMIT; | ||
433 | |||
434 | |||
435 | :VERSION 18 #--------------------- | ||
436 | |||
437 | begin; | ||
438 | |||
439 | ALTER TABLE prims ADD COLUMN ClickAction tinyint NOT NULL default 0; | ||
440 | |||
441 | commit; | ||
442 | |||
443 | :VERSION 19 #--------------------- | ||
444 | |||
445 | begin; | ||
446 | |||
447 | ALTER TABLE prims ADD COLUMN Material tinyint NOT NULL default 3; | ||
448 | |||
449 | commit; | ||
450 | |||
451 | |||
452 | :VERSION 20 #--------------------- | ||
453 | |||
454 | begin; | ||
455 | |||
456 | ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0; | ||
457 | ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0; | ||
458 | |||
459 | commit; | ||
460 | |||
461 | :VERSION 21 #--------------------- | ||
462 | |||
463 | begin; | ||
464 | |||
465 | ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0; | ||
466 | ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0; | ||
467 | ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0; | ||
468 | |||
469 | commit; | ||
470 | |||
471 | |||
472 | :VERSION 22 #--------------------- | ||
473 | |||
474 | BEGIN; | ||
475 | |||
476 | ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
477 | ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0; | ||
478 | |||
479 | COMMIT; | ||
480 | |||
481 | :VERSION 23 #--------------------- | ||
482 | |||
483 | BEGIN; | ||
484 | |||
485 | ALTER TABLE prims ADD COLUMN LinkNumber integer not null default 0; | ||
486 | |||
487 | COMMIT; | ||
488 | |||
489 | :VERSION 24 #--------------------- | ||
490 | |||
491 | BEGIN; | ||
492 | |||
493 | alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL; | ||
494 | alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL; | ||
495 | alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL; | ||
496 | alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL; | ||
497 | alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL; | ||
498 | alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL; | ||
499 | alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL; | ||
500 | alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL; | ||
501 | alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL; | ||
502 | alter table regionsettings change column `water_height` `water_height` double NOT NULL; | ||
503 | alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL; | ||
504 | alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL; | ||
505 | alter table regionsettings change column `sun_position` `sun_position` double NOT NULL; | ||
506 | |||
507 | COMMIT; | ||
508 | |||
509 | |||
510 | :VERSION 25 #--------------------- | ||
511 | |||
512 | BEGIN; | ||
513 | |||
514 | alter table prims change column `PositionX` `PositionX` double default NULL; | ||
515 | alter table prims change column `PositionY` `PositionY` double default NULL; | ||
516 | alter table prims change column `PositionZ` `PositionZ` double default NULL; | ||
517 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; | ||
518 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; | ||
519 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; | ||
520 | alter table prims change column `VelocityX` `VelocityX` double default NULL; | ||
521 | alter table prims change column `VelocityY` `VelocityY` double default NULL; | ||
522 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; | ||
523 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; | ||
524 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; | ||
525 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; | ||
526 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; | ||
527 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; | ||
528 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; | ||
529 | alter table prims change column `RotationX` `RotationX` double default NULL; | ||
530 | alter table prims change column `RotationY` `RotationY` double default NULL; | ||
531 | alter table prims change column `RotationZ` `RotationZ` double default NULL; | ||
532 | alter table prims change column `RotationW` `RotationW` double default NULL; | ||
533 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; | ||
534 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; | ||
535 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; | ||
536 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; | ||
537 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; | ||
538 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; | ||
539 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; | ||
540 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; | ||
541 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; | ||
542 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; | ||
543 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; | ||
544 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; | ||
545 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; | ||
546 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; | ||
547 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; | ||
548 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; | ||
549 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; | ||
550 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; | ||
551 | |||
552 | alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0'; | ||
553 | alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0'; | ||
554 | alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0'; | ||
555 | |||
556 | COMMIT; | ||
557 | |||
558 | :VERSION 26 #--------------------- | ||
559 | |||
560 | begin; | ||
561 | |||
562 | alter table prims change column `PositionX` `PositionX` double default NULL; | ||
563 | alter table prims change column `PositionY` `PositionY` double default NULL; | ||
564 | alter table prims change column `PositionZ` `PositionZ` double default NULL; | ||
565 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; | ||
566 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; | ||
567 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; | ||
568 | alter table prims change column `VelocityX` `VelocityX` double default NULL; | ||
569 | alter table prims change column `VelocityY` `VelocityY` double default NULL; | ||
570 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; | ||
571 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; | ||
572 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; | ||
573 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; | ||
574 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; | ||
575 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; | ||
576 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; | ||
577 | alter table prims change column `RotationX` `RotationX` double default NULL; | ||
578 | alter table prims change column `RotationY` `RotationY` double default NULL; | ||
579 | alter table prims change column `RotationZ` `RotationZ` double default NULL; | ||
580 | alter table prims change column `RotationW` `RotationW` double default NULL; | ||
581 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; | ||
582 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; | ||
583 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; | ||
584 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; | ||
585 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; | ||
586 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; | ||
587 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; | ||
588 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; | ||
589 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; | ||
590 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; | ||
591 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; | ||
592 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; | ||
593 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; | ||
594 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; | ||
595 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; | ||
596 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; | ||
597 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; | ||
598 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; | ||
599 | |||
600 | commit; | ||
601 | |||
602 | :VERSION 27 #--------------------- | ||
603 | |||
604 | BEGIN; | ||
605 | |||
606 | ALTER TABLE prims DROP COLUMN ParentID; | ||
607 | |||
608 | COMMIT; | ||
609 | |||
610 | :VERSION 28 #--------------------- | ||
611 | |||
612 | BEGIN; | ||
613 | |||
614 | update terrain | ||
615 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
616 | where RegionUUID not like '%-%'; | ||
617 | |||
618 | |||
619 | update landaccesslist | ||
620 | set LandUUID = concat(substr(LandUUID, 1, 8), "-", substr(LandUUID, 9, 4), "-", substr(LandUUID, 13, 4), "-", substr(LandUUID, 17, 4), "-", substr(LandUUID, 21, 12)) | ||
621 | where LandUUID not like '%-%'; | ||
622 | |||
623 | update landaccesslist | ||
624 | set AccessUUID = concat(substr(AccessUUID, 1, 8), "-", substr(AccessUUID, 9, 4), "-", substr(AccessUUID, 13, 4), "-", substr(AccessUUID, 17, 4), "-", substr(AccessUUID, 21, 12)) | ||
625 | where AccessUUID not like '%-%'; | ||
626 | |||
627 | |||
628 | update prims | ||
629 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
630 | where UUID not like '%-%'; | ||
631 | |||
632 | update prims | ||
633 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
634 | where RegionUUID not like '%-%'; | ||
635 | |||
636 | update prims | ||
637 | set SceneGroupID = concat(substr(SceneGroupID, 1, 8), "-", substr(SceneGroupID, 9, 4), "-", substr(SceneGroupID, 13, 4), "-", substr(SceneGroupID, 17, 4), "-", substr(SceneGroupID, 21, 12)) | ||
638 | where SceneGroupID not like '%-%'; | ||
639 | |||
640 | update prims | ||
641 | set CreatorID = concat(substr(CreatorID, 1, 8), "-", substr(CreatorID, 9, 4), "-", substr(CreatorID, 13, 4), "-", substr(CreatorID, 17, 4), "-", substr(CreatorID, 21, 12)) | ||
642 | where CreatorID not like '%-%'; | ||
643 | |||
644 | update prims | ||
645 | set OwnerID = concat(substr(OwnerID, 1, 8), "-", substr(OwnerID, 9, 4), "-", substr(OwnerID, 13, 4), "-", substr(OwnerID, 17, 4), "-", substr(OwnerID, 21, 12)) | ||
646 | where OwnerID not like '%-%'; | ||
647 | |||
648 | update prims | ||
649 | set GroupID = concat(substr(GroupID, 1, 8), "-", substr(GroupID, 9, 4), "-", substr(GroupID, 13, 4), "-", substr(GroupID, 17, 4), "-", substr(GroupID, 21, 12)) | ||
650 | where GroupID not like '%-%'; | ||
651 | |||
652 | update prims | ||
653 | set LastOwnerID = concat(substr(LastOwnerID, 1, 8), "-", substr(LastOwnerID, 9, 4), "-", substr(LastOwnerID, 13, 4), "-", substr(LastOwnerID, 17, 4), "-", substr(LastOwnerID, 21, 12)) | ||
654 | where LastOwnerID not like '%-%'; | ||
655 | |||
656 | |||
657 | update primshapes | ||
658 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
659 | where UUID not like '%-%'; | ||
660 | |||
661 | |||
662 | update land | ||
663 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
664 | where UUID not like '%-%'; | ||
665 | |||
666 | update land | ||
667 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
668 | where RegionUUID not like '%-%'; | ||
669 | |||
670 | update land | ||
671 | set OwnerUUID = concat(substr(OwnerUUID, 1, 8), "-", substr(OwnerUUID, 9, 4), "-", substr(OwnerUUID, 13, 4), "-", substr(OwnerUUID, 17, 4), "-", substr(OwnerUUID, 21, 12)) | ||
672 | where OwnerUUID not like '%-%'; | ||
673 | |||
674 | update land | ||
675 | set GroupUUID = concat(substr(GroupUUID, 1, 8), "-", substr(GroupUUID, 9, 4), "-", substr(GroupUUID, 13, 4), "-", substr(GroupUUID, 17, 4), "-", substr(GroupUUID, 21, 12)) | ||
676 | where GroupUUID not like '%-%'; | ||
677 | |||
678 | update land | ||
679 | set MediaTextureUUID = concat(substr(MediaTextureUUID, 1, 8), "-", substr(MediaTextureUUID, 9, 4), "-", substr(MediaTextureUUID, 13, 4), "-", substr(MediaTextureUUID, 17, 4), "-", substr(MediaTextureUUID, 21, 12)) | ||
680 | where MediaTextureUUID not like '%-%'; | ||
681 | |||
682 | update land | ||
683 | set SnapshotUUID = concat(substr(SnapshotUUID, 1, 8), "-", substr(SnapshotUUID, 9, 4), "-", substr(SnapshotUUID, 13, 4), "-", substr(SnapshotUUID, 17, 4), "-", substr(SnapshotUUID, 21, 12)) | ||
684 | where SnapshotUUID not like '%-%'; | ||
685 | |||
686 | update land | ||
687 | set AuthbuyerID = concat(substr(AuthbuyerID, 1, 8), "-", substr(AuthbuyerID, 9, 4), "-", substr(AuthbuyerID, 13, 4), "-", substr(AuthbuyerID, 17, 4), "-", substr(AuthbuyerID, 21, 12)) | ||
688 | where AuthbuyerID not like '%-%'; | ||
689 | |||
690 | COMMIT; | ||
691 | |||
692 | :VERSION 29 #--------------------- | ||
693 | |||
694 | BEGIN; | ||
695 | |||
696 | ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0; | ||
697 | |||
698 | COMMIT; | ||
699 | |||
700 | :VERSION 30 #--------------------- | ||
701 | |||
702 | BEGIN; | ||
703 | |||
704 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_date varchar(20) default NULL; | ||
705 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_time varchar(20) default NULL; | ||
706 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_id varchar(64) default NULL; | ||
707 | |||
708 | COMMIT; | ||
709 | |||
710 | :VERSION 31 #--------------------- | ||
711 | |||
712 | BEGIN; | ||
713 | |||
714 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_date; | ||
715 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_time; | ||
716 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0; | ||
717 | |||
718 | COMMIT; | ||
719 | |||
720 | :VERSION 32 | ||
721 | |||
722 | BEGIN; | ||
723 | CREATE TABLE `regionwindlight` ( | ||
724 | `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', | 271 | `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', |
725 | `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000', | 272 | `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000', |
726 | `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000', | 273 | `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000', |
@@ -779,172 +326,144 @@ CREATE TABLE `regionwindlight` ( | |||
779 | `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00', | 326 | `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00', |
780 | `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53', | 327 | `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53', |
781 | `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12', | 328 | `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12', |
782 | `cloud_scroll_x` float(3,2) unsigned NOT NULL DEFAULT '0.20', | 329 | `cloud_scroll_x` float(4,2) NOT NULL DEFAULT '0.20', |
783 | `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', | 330 | `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', |
784 | `cloud_scroll_y` float(3,2) unsigned NOT NULL DEFAULT '0.01', | 331 | `cloud_scroll_y` float(4,2) NOT NULL DEFAULT '0.01', |
785 | `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', | 332 | `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', |
786 | `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1', | 333 | `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1', |
787 | PRIMARY KEY (`region_id`) | 334 | PRIMARY KEY (`region_id`) |
788 | ); | 335 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
789 | |||
790 | |||
791 | :VERSION 33 #--------------------- | ||
792 | |||
793 | BEGIN; | ||
794 | ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
795 | COMMIT; | ||
796 | |||
797 | :VERSION 34 #--------------------- | ||
798 | |||
799 | BEGIN; | ||
800 | 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`; | ||
801 | COMMIT; | ||
802 | 336 | ||
803 | :VERSION 35 #--------------------- | ||
804 | |||
805 | BEGIN; | ||
806 | ALTER TABLE prims ADD COLUMN MediaURL varchar(255); | ||
807 | ALTER TABLE primshapes ADD COLUMN Media TEXT; | ||
808 | COMMIT; | ||
809 | |||
810 | :VERSION 36 #--------------------- | ||
811 | |||
812 | BEGIN; | ||
813 | ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none' ; | ||
814 | ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT ''; | ||
815 | ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0'; | ||
816 | ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; | ||
817 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; | ||
818 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; | ||
819 | COMMIT; | ||
820 | |||
821 | :VERSION 37 #--------------------- | ||
822 | |||
823 | BEGIN; | ||
824 | |||
825 | ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; | ||
826 | ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; | ||
827 | |||
828 | COMMIT; | ||
829 | |||
830 | :VERSION 38 #--------------------- | ||
831 | |||
832 | BEGIN; | ||
833 | |||
834 | alter table land ENGINE = MyISAM; | ||
835 | alter table landaccesslist ENGINE = MyISAM; | ||
836 | alter table migrations ENGINE = MyISAM; | ||
837 | alter table primitems ENGINE = MyISAM; | ||
838 | alter table prims ENGINE = MyISAM; | ||
839 | alter table primshapes ENGINE = MyISAM; | ||
840 | alter table regionban ENGINE = MyISAM; | ||
841 | alter table regionsettings ENGINE = MyISAM; | ||
842 | alter table terrain ENGINE = MyISAM; | ||
843 | |||
844 | COMMIT; | ||
845 | |||
846 | :VERSION 39 #--------------- Telehub support | ||
847 | |||
848 | BEGIN; | ||
849 | CREATE TABLE IF NOT EXISTS `spawn_points` ( | 337 | CREATE TABLE IF NOT EXISTS `spawn_points` ( |
850 | `RegionID` varchar(36) COLLATE utf8_unicode_ci NOT NULL, | 338 | `RegionID` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
851 | `Yaw` float NOT NULL, | 339 | `Yaw` float NOT NULL, |
852 | `Pitch` float NOT NULL, | 340 | `Pitch` float NOT NULL, |
853 | `Distance` float NOT NULL, | 341 | `Distance` float NOT NULL, |
854 | KEY `RegionID` (`RegionID`) | 342 | KEY `RegionID` (`RegionID`) |
855 | ) ENGINE=MyISAM; | 343 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
856 | |||
857 | ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; | ||
858 | COMMIT; | ||
859 | |||
860 | :VERSION 40 #---------------- Parcels for sale | ||
861 | |||
862 | BEGIN; | ||
863 | ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
864 | COMMIT; | ||
865 | |||
866 | :VERSION 41 #---------------- Timed bans/access | ||
867 | |||
868 | BEGIN; | ||
869 | ALTER TABLE `landaccesslist` ADD COLUMN `Expires` INTEGER NOT NULL DEFAULT 0; | ||
870 | COMMIT; | ||
871 | 344 | ||
872 | :VERSION 42 #--------------------- Region Covenant changed time | 345 | CREATE TABLE IF NOT EXISTS `regionenvironment` ( |
873 | |||
874 | BEGIN; | ||
875 | ALTER TABLE regionsettings ADD COLUMN covenant_datetime int unsigned NOT NULL DEFAULT '0'; | ||
876 | COMMIT; | ||
877 | |||
878 | :VERSION 43 #--------------------- | ||
879 | |||
880 | BEGIN; | ||
881 | |||
882 | ALTER TABLE `regionsettings` MODIFY COLUMN `TelehubObject` VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
883 | |||
884 | COMMIT; | ||
885 | |||
886 | :VERSION 44 #--------------------- Environment Settings | ||
887 | |||
888 | BEGIN; | ||
889 | |||
890 | CREATE TABLE `regionenvironment` ( | ||
891 | `region_id` varchar(36) NOT NULL, | 346 | `region_id` varchar(36) NOT NULL, |
892 | `llsd_settings` TEXT NOT NULL, | 347 | `llsd_settings` text NOT NULL, |
893 | PRIMARY KEY (`region_id`) | 348 | PRIMARY KEY (`region_id`) |
894 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 349 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
895 | |||
896 | COMMIT; | ||
897 | 350 | ||
898 | :VERSION 45 | 351 | CREATE TABLE IF NOT EXISTS `regionextra` ( |
899 | 352 | `RegionID` char(36) NOT NULL, | |
900 | BEGIN; | 353 | `Name` varchar(32) NOT NULL, |
901 | 354 | `value` text, | |
902 | CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`)); | 355 | PRIMARY KEY (`RegionID`,`Name`) |
356 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
903 | 357 | ||
904 | COMMIT; | 358 | COMMIT; |
905 | 359 | ||
906 | :VERSION 46 #---------------- Dynamic attributes | 360 | :VERSION 52 #---- avination fields |
907 | 361 | ||
908 | BEGIN; | 362 | BEGIN; |
909 | 363 | ||
910 | ALTER TABLE prims ADD COLUMN DynAttrs TEXT; | 364 | ALTER TABLE `prims` ADD COLUMN `PassCollisions` tinyint(4) NOT NULL default '0'; |
365 | ALTER TABLE `prims` ADD COLUMN `Vehicle` TEXT default NULL; | ||
366 | ALTER TABLE `regionsettings` ADD COLUMN `block_search` tinyint(4) NOT NULL default '0'; | ||
367 | ALTER TABLE `regionsettings` ADD COLUMN `casino` tinyint(4) NOT NULL default '0'; | ||
368 | ALTER TABLE `land` ADD COLUMN `SeeAVs` tinyint(4) NOT NULL default '1'; | ||
369 | ALTER TABLE `land` ADD COLUMN `AnyAVSounds` tinyint(4) NOT NULL default '1'; | ||
370 | ALTER TABLE `land` ADD COLUMN `GroupAVSounds` tinyint(4) NOT NULL default '1'; | ||
911 | 371 | ||
912 | COMMIT; | 372 | COMMIT; |
913 | 373 | ||
914 | :VERSION 47 #---------------- Extra physics params | 374 | :VERSION 53 #---- STATUS ROTATION axis locks |
915 | 375 | ||
916 | BEGIN; | 376 | BEGIN; |
917 | 377 | ||
918 | ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; | 378 | ALTER TABLE `prims` ADD COLUMN `RotationAxisLocks` tinyint(4) NOT NULL default '0'; |
919 | ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000'; | ||
920 | ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1'; | ||
921 | ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6'; | ||
922 | ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5'; | ||
923 | 379 | ||
924 | COMMIT; | 380 | COMMIT; |
925 | 381 | ||
926 | :VERSION 48 #---------------- Keyframes | 382 | :VERSION 54 #----- add baked terrain store |
927 | 383 | ||
928 | BEGIN; | 384 | BEGIN; |
929 | 385 | ||
930 | ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob; | 386 | CREATE TABLE IF NOT EXISTS `bakedterrain` ( |
931 | 387 | `RegionUUID` varchar(255) DEFAULT NULL, | |
932 | COMMIT; | 388 | `Revision` int(11) DEFAULT NULL, |
933 | 389 | `Heightfield` longblob | |
934 | :VERSION 49 #--------------------- Save attachment info | 390 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
935 | 391 | ||
936 | BEGIN; | 392 | COMMIT; |
937 | ALTER TABLE prims ADD COLUMN AttachedPosX double default 0; | 393 | |
938 | ALTER TABLE prims ADD COLUMN AttachedPosY double default 0; | 394 | :VERSION 55 #----- Increase float precision for windlight needed by scripts |
939 | ALTER TABLE prims ADD COLUMN AttachedPosZ double default 0; | 395 | |
940 | ALTER TABLE primshapes ADD COLUMN LastAttachPoint int(4) not null default '0'; | 396 | BEGIN; |
941 | COMMIT; | 397 | |
942 | 398 | ALTER TABLE `regionwindlight` | |
943 | :VERSION 50 #---- Change LandFlags to unsigned | 399 | |
944 | 400 | MODIFY `water_fog_density_exponent` float(9,7) unsigned NOT NULL DEFAULT '4.0', | |
945 | BEGIN; | 401 | MODIFY `underwater_fog_modifier` float(9,8) unsigned NOT NULL DEFAULT '0.25', |
946 | 402 | MODIFY `reflection_wavelet_scale_1` float(9,7) unsigned NOT NULL DEFAULT '2.0', | |
947 | ALTER TABLE land CHANGE COLUMN LandFlags LandFlags int unsigned default null; | 403 | MODIFY `reflection_wavelet_scale_2` float(9,7) unsigned NOT NULL DEFAULT '2.0', |
948 | 404 | MODIFY `reflection_wavelet_scale_3` float(9,7) unsigned NOT NULL DEFAULT '2.0', | |
405 | MODIFY `fresnel_scale` float(9,8) unsigned NOT NULL DEFAULT '0.40', | ||
406 | MODIFY `fresnel_offset` float(9,8) unsigned NOT NULL DEFAULT '0.50', | ||
407 | MODIFY `refract_scale_above` float(9,8) unsigned NOT NULL DEFAULT '0.03', | ||
408 | MODIFY `refract_scale_below` float(9,8) unsigned NOT NULL DEFAULT '0.20', | ||
409 | MODIFY `blur_multiplier` float(9,8) unsigned NOT NULL DEFAULT '0.040', | ||
410 | MODIFY `big_wave_direction_x` float(9,8) NOT NULL DEFAULT '1.05', | ||
411 | MODIFY `big_wave_direction_y` float(9,8) NOT NULL DEFAULT '-0.42', | ||
412 | MODIFY `little_wave_direction_x` float(9,8) NOT NULL DEFAULT '1.11', | ||
413 | MODIFY `little_wave_direction_y` float(9,8) NOT NULL DEFAULT '-1.16', | ||
414 | MODIFY `horizon_r` float(9,8) unsigned NOT NULL DEFAULT '0.25', | ||
415 | MODIFY `horizon_g` float(9,8) unsigned NOT NULL DEFAULT '0.25', | ||
416 | MODIFY `horizon_b` float(9,8) unsigned NOT NULL DEFAULT '0.32', | ||
417 | MODIFY `horizon_i` float(9,8) unsigned NOT NULL DEFAULT '0.32', | ||
418 | MODIFY `haze_horizon` float(9,8) unsigned NOT NULL DEFAULT '0.19', | ||
419 | MODIFY `blue_density_r` float(9,8) unsigned NOT NULL DEFAULT '0.12', | ||
420 | MODIFY `blue_density_g` float(9,8) unsigned NOT NULL DEFAULT '0.22', | ||
421 | MODIFY `blue_density_b` float(9,8) unsigned NOT NULL DEFAULT '0.38', | ||
422 | MODIFY `blue_density_i` float(9,8) unsigned NOT NULL DEFAULT '0.38', | ||
423 | MODIFY `haze_density` float(9,8) unsigned NOT NULL DEFAULT '0.70', | ||
424 | MODIFY `density_multiplier` float(9,8) unsigned NOT NULL DEFAULT '0.18', | ||
425 | MODIFY `distance_multiplier` float(9,6) unsigned NOT NULL DEFAULT '0.8', | ||
426 | MODIFY `sun_moon_color_r` float(9,8) unsigned NOT NULL DEFAULT '0.24', | ||
427 | MODIFY `sun_moon_color_g` float(9,8) unsigned NOT NULL DEFAULT '0.26', | ||
428 | MODIFY `sun_moon_color_b` float(9,8) unsigned NOT NULL DEFAULT '0.30', | ||
429 | MODIFY `sun_moon_color_i` float(9,8) unsigned NOT NULL DEFAULT '0.30', | ||
430 | MODIFY `sun_moon_position` float(9,8) unsigned NOT NULL DEFAULT '0.317', | ||
431 | MODIFY `ambient_r` float(9,8) unsigned NOT NULL DEFAULT '0.35', | ||
432 | MODIFY `ambient_g` float(9,8) unsigned NOT NULL DEFAULT '0.35', | ||
433 | MODIFY `ambient_b` float(9,8) unsigned NOT NULL DEFAULT '0.35', | ||
434 | MODIFY `ambient_i` float(9,8) unsigned NOT NULL DEFAULT '0.35', | ||
435 | MODIFY `east_angle` float(9,8) unsigned NOT NULL DEFAULT '0.00', | ||
436 | MODIFY `sun_glow_focus` float(9,8) unsigned NOT NULL DEFAULT '0.10', | ||
437 | MODIFY `sun_glow_size` float(9,8) unsigned NOT NULL DEFAULT '1.75', | ||
438 | MODIFY `scene_gamma` float(9,7) unsigned NOT NULL DEFAULT '1.00', | ||
439 | MODIFY `star_brightness` float(9,8) unsigned NOT NULL DEFAULT '0.00', | ||
440 | MODIFY `cloud_color_r` float(9,8) unsigned NOT NULL DEFAULT '0.41', | ||
441 | MODIFY `cloud_color_g` float(9,8) unsigned NOT NULL DEFAULT '0.41', | ||
442 | MODIFY `cloud_color_b` float(9,8) unsigned NOT NULL DEFAULT '0.41', | ||
443 | MODIFY `cloud_color_i` float(9,8) unsigned NOT NULL DEFAULT '0.41', | ||
444 | MODIFY `cloud_x` float(9,8) unsigned NOT NULL DEFAULT '1.00', | ||
445 | MODIFY `cloud_y` float(9,8) unsigned NOT NULL DEFAULT '0.53', | ||
446 | MODIFY `cloud_density` float(9,8) unsigned NOT NULL DEFAULT '1.00', | ||
447 | MODIFY `cloud_coverage` float(9,8) unsigned NOT NULL DEFAULT '0.27', | ||
448 | MODIFY `cloud_scale` float(9,8) unsigned NOT NULL DEFAULT '0.42', | ||
449 | MODIFY `cloud_detail_x` float(9,8) unsigned NOT NULL DEFAULT '1.00', | ||
450 | MODIFY `cloud_detail_y` float(9,8) unsigned NOT NULL DEFAULT '0.53', | ||
451 | MODIFY `cloud_detail_density` float(9,8) unsigned NOT NULL DEFAULT '0.12', | ||
452 | MODIFY `cloud_scroll_x` float(9,7) NOT NULL DEFAULT '0.20', | ||
453 | MODIFY `cloud_scroll_y` float(9,7) NOT NULL DEFAULT '0.01'; | ||
454 | |||
455 | COMMIT; | ||
456 | |||
457 | :VERSION 56 #----- Add RezzerID field in table prims | ||
458 | |||
459 | BEGIN; | ||
460 | |||
461 | ALTER TABLE `prims` ADD COLUMN `RezzerID` char(36) DEFAULT NULL; | ||
462 | |||
463 | COMMIT; | ||
464 | |||
465 | :VERSION 57 #----- Add physics inertia data | ||
466 | |||
467 | BEGIN; | ||
468 | ALTER TABLE `prims` ADD COLUMN `PhysInertia` TEXT default NULL; | ||
949 | COMMIT; | 469 | COMMIT; |
950 | |||