diff options
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/RegionStore.migrations | 57 |
1 files changed, 2 insertions, 55 deletions
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations index c47a85d..c461bf0 100644 --- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations +++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations | |||
@@ -1,4 +1,4 @@ | |||
1 | :VERSION 1 | 1 | :VERSION 1 |
2 | 2 | ||
3 | BEGIN TRANSACTION; | 3 | BEGIN TRANSACTION; |
4 | 4 | ||
@@ -219,59 +219,6 @@ COMMIT; | |||
219 | 219 | ||
220 | BEGIN TRANSACTION; | 220 | BEGIN TRANSACTION; |
221 | 221 | ||
222 | CREATE TABLE estate_groups ( | ||
223 | EstateID int(10) NOT NULL, | ||
224 | uuid char(36) NOT NULL | ||
225 | ); | ||
226 | |||
227 | CREATE TABLE estate_managers ( | ||
228 | EstateID int(10) NOT NULL, | ||
229 | uuid char(36) NOT NULL | ||
230 | ); | ||
231 | |||
232 | CREATE TABLE estate_map ( | ||
233 | RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
234 | EstateID int(11) NOT NULL | ||
235 | ); | ||
236 | |||
237 | CREATE TABLE estate_settings ( | ||
238 | EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, | ||
239 | EstateName varchar(64) default NULL, | ||
240 | AbuseEmailToEstateOwner tinyint(4) NOT NULL, | ||
241 | DenyAnonymous tinyint(4) NOT NULL, | ||
242 | ResetHomeOnTeleport tinyint(4) NOT NULL, | ||
243 | FixedSun tinyint(4) NOT NULL, | ||
244 | DenyTransacted tinyint(4) NOT NULL, | ||
245 | BlockDwell tinyint(4) NOT NULL, | ||
246 | DenyIdentified tinyint(4) NOT NULL, | ||
247 | AllowVoice tinyint(4) NOT NULL, | ||
248 | UseGlobalTime tinyint(4) NOT NULL, | ||
249 | PricePerMeter int(11) NOT NULL, | ||
250 | TaxFree tinyint(4) NOT NULL, | ||
251 | AllowDirectTeleport tinyint(4) NOT NULL, | ||
252 | RedirectGridX int(11) NOT NULL, | ||
253 | RedirectGridY int(11) NOT NULL, | ||
254 | ParentEstateID int(10) NOT NULL, | ||
255 | SunPosition double NOT NULL, | ||
256 | EstateSkipScripts tinyint(4) NOT NULL, | ||
257 | BillableFactor float NOT NULL, | ||
258 | PublicAccess tinyint(4) NOT NULL | ||
259 | ); | ||
260 | insert into estate_settings (EstateID,EstateName,AbuseEmailToEstateOwner,DenyAnonymous,ResetHomeOnTeleport,FixedSun,DenyTransacted,BlockDwell,DenyIdentified,AllowVoice,UseGlobalTime,PricePerMeter,TaxFree,AllowDirectTeleport,RedirectGridX,RedirectGridY,ParentEstateID,SunPosition,PublicAccess,EstateSkipScripts,BillableFactor) values ( 99, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); | ||
261 | delete from estate_settings; | ||
262 | CREATE TABLE estate_users ( | ||
263 | EstateID int(10) NOT NULL, | ||
264 | uuid char(36) NOT NULL | ||
265 | ); | ||
266 | |||
267 | CREATE TABLE estateban ( | ||
268 | EstateID int(10) NOT NULL, | ||
269 | bannedUUID varchar(36) NOT NULL, | ||
270 | bannedIp varchar(16) NOT NULL, | ||
271 | bannedIpHostMask varchar(16) NOT NULL, | ||
272 | bannedNameMask varchar(64) default NULL | ||
273 | ); | ||
274 | |||
275 | drop table regionsettings; | 222 | drop table regionsettings; |
276 | CREATE TABLE regionsettings ( | 223 | CREATE TABLE regionsettings ( |
277 | regionUUID char(36) NOT NULL, | 224 | regionUUID char(36) NOT NULL, |
@@ -307,7 +254,7 @@ CREATE TABLE regionsettings ( | |||
307 | fixed_sun int(11) NOT NULL, | 254 | fixed_sun int(11) NOT NULL, |
308 | sun_position float NOT NULL, | 255 | sun_position float NOT NULL, |
309 | covenant char(36) default NULL, | 256 | covenant char(36) default NULL, |
310 | Sandbox tinyint(4) NOT NULL, | 257 | sandbox tinyint(4) NOT NULL, |
311 | PRIMARY KEY (regionUUID) | 258 | PRIMARY KEY (regionUUID) |
312 | ); | 259 | ); |
313 | 260 | ||