diff options
author | Diva Canto | 2016-02-21 09:00:59 -0800 |
---|---|---|
committer | Diva Canto | 2016-02-21 09:10:00 -0800 |
commit | ee24b2516545f57db5926aa69eb11b397fc599bb (patch) | |
tree | ead13634aee5bb6bcc5abee2773e213597ae764a /OpenSim/Data/SQLite/Resources/EstateStore.migrations | |
parent | MySQL migrations: fix one last migration that had been left behind (diff) | |
download | opensim-SC-ee24b2516545f57db5926aa69eb11b397fc599bb.zip opensim-SC-ee24b2516545f57db5926aa69eb11b397fc599bb.tar.gz opensim-SC-ee24b2516545f57db5926aa69eb11b397fc599bb.tar.bz2 opensim-SC-ee24b2516545f57db5926aa69eb11b397fc599bb.tar.xz |
Flatten migrations for sqlite
Conflicts:
OpenSim/Data/SQLite/Resources/RegionStore.migrations
(Resolved)
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/EstateStore.migrations | 68 |
1 files changed, 20 insertions, 48 deletions
diff --git a/OpenSim/Data/SQLite/Resources/EstateStore.migrations b/OpenSim/Data/SQLite/Resources/EstateStore.migrations index 0aec49b..37fa1d9 100644 --- a/OpenSim/Data/SQLite/Resources/EstateStore.migrations +++ b/OpenSim/Data/SQLite/Resources/EstateStore.migrations | |||
@@ -1,23 +1,27 @@ | |||
1 | :VERSION 6 | 1 | :VERSION 10 |
2 | 2 | ||
3 | BEGIN TRANSACTION; | 3 | BEGIN TRANSACTION; |
4 | 4 | ||
5 | CREATE TABLE estate_groups ( | 5 | CREATE TABLE IF NOT EXISTS estate_groups ( |
6 | EstateID int(10) NOT NULL, | 6 | EstateID int(10) NOT NULL, |
7 | uuid char(36) NOT NULL | 7 | uuid char(36) NOT NULL |
8 | ); | 8 | ); |
9 | CREATE INDEX estate_groups_estate_id on estate_groups(EstateID); | ||
9 | 10 | ||
10 | CREATE TABLE estate_managers ( | 11 | CREATE TABLE IF NOT EXISTS estate_managers ( |
11 | EstateID int(10) NOT NULL, | 12 | EstateID int(10) NOT NULL, |
12 | uuid char(36) NOT NULL | 13 | uuid char(36) NOT NULL |
13 | ); | 14 | ); |
15 | CREATE INDEX estate_managers_estate_id on estate_managers(EstateID); | ||
14 | 16 | ||
15 | CREATE TABLE estate_map ( | 17 | CREATE TABLE IF NOT EXISTS estate_map ( |
16 | RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 18 | RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
17 | EstateID int(11) NOT NULL | 19 | EstateID int(11) NOT NULL |
18 | ); | 20 | ); |
21 | CREATE INDEX estate_map_estate_id on estate_map(EstateID); | ||
22 | CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID); | ||
19 | 23 | ||
20 | CREATE TABLE estate_settings ( | 24 | CREATE TABLE IF NOT EXISTS estate_settings ( |
21 | EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, | 25 | EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
22 | EstateName varchar(64) default NULL, | 26 | EstateName varchar(64) default NULL, |
23 | AbuseEmailToEstateOwner tinyint(4) NOT NULL, | 27 | AbuseEmailToEstateOwner tinyint(4) NOT NULL, |
@@ -38,60 +42,28 @@ CREATE TABLE estate_settings ( | |||
38 | SunPosition double NOT NULL, | 42 | SunPosition double NOT NULL, |
39 | EstateSkipScripts tinyint(4) NOT NULL, | 43 | EstateSkipScripts tinyint(4) NOT NULL, |
40 | BillableFactor float NOT NULL, | 44 | BillableFactor float NOT NULL, |
41 | PublicAccess tinyint(4) NOT NULL | 45 | PublicAccess tinyint(4) NOT NULL, |
42 | ); | 46 | AbuseEmail varchar(255) not null default '', |
43 | 47 | EstateOwner varchar(36) not null default '', | |
44 | insert into estate_settings ( | 48 | DenyMinors tinyint not null default 0, |
45 | EstateID,EstateName,AbuseEmailToEstateOwner,DenyAnonymous,ResetHomeOnTeleport,FixedSun,DenyTransacted,BlockDwell,DenyIdentified,AllowVoice,UseGlobalTime,PricePerMeter,TaxFree,AllowDirectTeleport,RedirectGridX,RedirectGridY,ParentEstateID,SunPosition,PublicAccess,EstateSkipScripts,BillableFactor) | 49 | AllowLandmark tinyint not null default '1', |
46 | values ( 99, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); | 50 | AllowParcelChanges tinyint not null default '1', |
47 | delete from estate_settings; | 51 | AllowSetHome tinyint not null default '1'); |
48 | 52 | ||
49 | CREATE TABLE estate_users ( | 53 | CREATE TABLE IF NOT EXISTS estate_users ( |
50 | EstateID int(10) NOT NULL, | 54 | EstateID int(10) NOT NULL, |
51 | uuid char(36) NOT NULL | 55 | uuid char(36) NOT NULL |
52 | ); | 56 | ); |
57 | CREATE INDEX estate_users_estate_id on estate_users(EstateID); | ||
53 | 58 | ||
54 | CREATE TABLE estateban ( | 59 | CREATE TABLE IF NOT EXISTS estateban ( |
55 | EstateID int(10) NOT NULL, | 60 | EstateID int(10) NOT NULL, |
56 | bannedUUID varchar(36) NOT NULL, | 61 | bannedUUID varchar(36) NOT NULL, |
57 | bannedIp varchar(16) NOT NULL, | 62 | bannedIp varchar(16) NOT NULL, |
58 | bannedIpHostMask varchar(16) NOT NULL, | 63 | bannedIpHostMask varchar(16) NOT NULL, |
59 | bannedNameMask varchar(64) default NULL | 64 | bannedNameMask varchar(64) default NULL |
60 | ); | 65 | ); |
61 | |||
62 | CREATE INDEX estate_ban_estate_id on estateban(EstateID); | 66 | CREATE INDEX estate_ban_estate_id on estateban(EstateID); |
63 | CREATE INDEX estate_groups_estate_id on estate_groups(EstateID); | ||
64 | CREATE INDEX estate_managers_estate_id on estate_managers(EstateID); | ||
65 | CREATE INDEX estate_map_estate_id on estate_map(EstateID); | ||
66 | CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID); | ||
67 | CREATE INDEX estate_users_estate_id on estate_users(EstateID); | ||
68 | 67 | ||
69 | COMMIT; | 68 | COMMIT; |
70 | 69 | ||
71 | |||
72 | :VERSION 7 | ||
73 | |||
74 | begin; | ||
75 | |||
76 | alter table estate_settings add column AbuseEmail varchar(255) not null default ''; | ||
77 | |||
78 | alter table estate_settings add column EstateOwner varchar(36) not null default ''; | ||
79 | |||
80 | commit; | ||
81 | |||
82 | :VERSION 8 | ||
83 | |||
84 | begin; | ||
85 | |||
86 | alter table estate_settings add column DenyMinors tinyint not null default 0; | ||
87 | |||
88 | commit; | ||
89 | |||
90 | :VERSION 9 | ||
91 | |||
92 | begin; | ||
93 | alter table estate_settings add column AllowLandmark tinyint not null default '1'; | ||
94 | alter table estate_settings add column AllowParcelChanges tinyint not null default '1'; | ||
95 | alter table estate_settings add column AllowSetHome tinyint not null default '1'; | ||
96 | commit; | ||
97 | |||