clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 1 | :VERSION 6 |
2 | |||
3 | BEGIN TRANSACTION; |
||
4 | |||
5 | CREATE TABLE estate_groups ( |
||
6 | EstateID int(10) NOT NULL, |
||
7 | uuid char(36) NOT NULL |
||
8 | ); |
||
9 | |||
10 | CREATE TABLE estate_managers ( |
||
11 | EstateID int(10) NOT NULL, |
||
12 | uuid char(36) NOT NULL |
||
13 | ); |
||
14 | |||
15 | CREATE TABLE estate_map ( |
||
16 | RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
||
17 | EstateID int(11) NOT NULL |
||
18 | ); |
||
19 | |||
20 | CREATE TABLE estate_settings ( |
||
21 | EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
||
22 | EstateName varchar(64) default NULL, |
||
23 | AbuseEmailToEstateOwner tinyint(4) NOT NULL, |
||
24 | DenyAnonymous tinyint(4) NOT NULL, |
||
25 | ResetHomeOnTeleport tinyint(4) NOT NULL, |
||
26 | FixedSun tinyint(4) NOT NULL, |
||
27 | DenyTransacted tinyint(4) NOT NULL, |
||
28 | BlockDwell tinyint(4) NOT NULL, |
||
29 | DenyIdentified tinyint(4) NOT NULL, |
||
30 | AllowVoice tinyint(4) NOT NULL, |
||
31 | UseGlobalTime tinyint(4) NOT NULL, |
||
32 | PricePerMeter int(11) NOT NULL, |
||
33 | TaxFree tinyint(4) NOT NULL, |
||
34 | AllowDirectTeleport tinyint(4) NOT NULL, |
||
35 | RedirectGridX int(11) NOT NULL, |
||
36 | RedirectGridY int(11) NOT NULL, |
||
37 | ParentEstateID int(10) NOT NULL, |
||
38 | SunPosition double NOT NULL, |
||
39 | EstateSkipScripts tinyint(4) NOT NULL, |
||
40 | BillableFactor float NOT NULL, |
||
41 | PublicAccess tinyint(4) NOT NULL |
||
42 | ); |
||
43 | |||
44 | insert into estate_settings ( |
||
45 | EstateID,EstateName,AbuseEmailToEstateOwner,DenyAnonymous,ResetHomeOnTeleport,FixedSun,DenyTransacted,BlockDwell,DenyIdentified,AllowVoice,UseGlobalTime,PricePerMeter,TaxFree,AllowDirectTeleport,RedirectGridX,RedirectGridY,ParentEstateID,SunPosition,PublicAccess,EstateSkipScripts,BillableFactor) |
||
46 | values ( 99, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); |
||
47 | delete from estate_settings; |
||
48 | |||
49 | CREATE TABLE estate_users ( |
||
50 | EstateID int(10) NOT NULL, |
||
51 | uuid char(36) NOT NULL |
||
52 | ); |
||
53 | |||
54 | CREATE TABLE estateban ( |
||
55 | EstateID int(10) NOT NULL, |
||
56 | bannedUUID varchar(36) NOT NULL, |
||
57 | bannedIp varchar(16) NOT NULL, |
||
58 | bannedIpHostMask varchar(16) NOT NULL, |
||
59 | bannedNameMask varchar(64) default NULL |
||
60 | ); |
||
61 | |||
62 | 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 | |||
69 | COMMIT; |
||
70 | |||
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 |