diff options
author | Justin Clark-Casey (justincc) | 2010-06-04 18:45:12 +0100 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2010-06-04 18:46:58 +0100 |
commit | 86f2339b6e236e291bac743face1f0f1c574fc05 (patch) | |
tree | 38af5488f9b8c09ee9c2ee8f6152f27a30c79206 /OpenSim/Data | |
parent | add sqlite database back to database tests (diff) | |
download | opensim-SC_OLD-86f2339b6e236e291bac743face1f0f1c574fc05.zip opensim-SC_OLD-86f2339b6e236e291bac743face1f0f1c574fc05.tar.gz opensim-SC_OLD-86f2339b6e236e291bac743face1f0f1c574fc05.tar.bz2 opensim-SC_OLD-86f2339b6e236e291bac743face1f0f1c574fc05.tar.xz |
remove estate stuff in sqlite region migrations since this also exists in estate migrations, change Sandbox to sandbox in sqlite region migrations
re-enabling the sqlite data tests revealed these errors!
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/RegionStore.migrations | 55 |
1 files changed, 1 insertions, 54 deletions
diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations index c2de1af..c461bf0 100644 --- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations +++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations | |||
@@ -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 | ||