opensim-development – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 eva 1 :VERSION 1
2  
3 BEGIN TRANSACTION;
4  
5 CREATE TABLE estate_managers(
6 "EstateID" int NOT NULL Primary Key,
7 uuid varchar(36) NOT NULL
8 );
9  
10 CREATE TABLE estate_groups(
11 "EstateID" int NOT NULL,
12 uuid varchar(36) NOT NULL
13 );
14  
15  
16 CREATE TABLE estate_users(
17 "EstateID" int NOT NULL,
18 uuid varchar(36) NOT NULL
19 );
20  
21  
22 CREATE TABLE estateban(
23 "EstateID" int NOT NULL,
24 "bannedUUID" varchar(36) NOT NULL,
25 "bannedIp" varchar(16) NOT NULL,
26 "bannedIpHostMask" varchar(16) NOT NULL,
27 "bannedNameMask" varchar(64) NULL DEFAULT NULL
28 );
29  
30 Create Sequence estate_settings_id increment by 100 start with 100;
31  
32 CREATE TABLE estate_settings(
33 "EstateID" integer DEFAULT nextval('estate_settings_id') NOT NULL,
34 "EstateName" varchar(64) NULL DEFAULT (NULL),
35 "AbuseEmailToEstateOwner" boolean NOT NULL,
36 "DenyAnonymous" boolean NOT NULL,
37 "ResetHomeOnTeleport" boolean NOT NULL,
38 "FixedSun" boolean NOT NULL,
39 "DenyTransacted" boolean NOT NULL,
40 "BlockDwell" boolean NOT NULL,
41 "DenyIdentified" boolean NOT NULL,
42 "AllowVoice" boolean NOT NULL,
43 "UseGlobalTime" boolean NOT NULL,
44 "PricePerMeter" int NOT NULL,
45 "TaxFree" boolean NOT NULL,
46 "AllowDirectTeleport" boolean NOT NULL,
47 "RedirectGridX" int NOT NULL,
48 "RedirectGridY" int NOT NULL,
49 "ParentEstateID" int NOT NULL,
50 "SunPosition" double precision NOT NULL,
51 "EstateSkipScripts" boolean NOT NULL,
52 "BillableFactor" double precision NOT NULL,
53 "PublicAccess" boolean NOT NULL,
54 "AbuseEmail" varchar(255) NOT NULL,
55 "EstateOwner" varchar(36) NOT NULL,
56 "DenyMinors" boolean NOT NULL
57 );
58  
59  
60 CREATE TABLE estate_map(
61 "RegionID" varchar(36) NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
62 "EstateID" int NOT NULL
63 );
64  
65 COMMIT;
66  
67 :VERSION 2
68  
69 BEGIN TRANSACTION;
70  
71 CREATE INDEX IX_estate_managers ON estate_managers
72 (
73 "EstateID"
74 );
75  
76  
77 CREATE INDEX IX_estate_groups ON estate_groups
78 (
79 "EstateID"
80 );
81  
82  
83 CREATE INDEX IX_estate_users ON estate_users
84 (
85 "EstateID"
86 );
87  
88 COMMIT;
89  
90 :VERSION 3
91  
92 BEGIN TRANSACTION;
93  
94 CREATE TABLE Tmp_estateban
95 (
96 "EstateID" int NOT NULL,
97 "bannedUUID" varchar(36) NOT NULL,
98 "bannedIp" varchar(16) NULL,
99 "bannedIpHostMask" varchar(16) NULL,
100 "bannedNameMask" varchar(64) NULL
101 );
102  
103 INSERT INTO Tmp_estateban ("EstateID", "bannedUUID", "bannedIp", "bannedIpHostMask", "bannedNameMask")
104 SELECT "EstateID", "bannedUUID", "bannedIp", "bannedIpHostMask", "bannedNameMask" FROM estateban;
105  
106 DROP TABLE estateban;
107  
108 Alter table Tmp_estateban
109 rename to estateban;
110  
111 CREATE INDEX IX_estateban ON estateban
112 (
113 "EstateID"
114 );
115  
116 COMMIT;
117  
118  
119 :VERSION 4
120  
121 BEGIN TRANSACTION;
122  
123 CREATE TABLE Tmp_estate_managers
124 (
125 "EstateID" int NOT NULL,
126 uuid uuid NOT NULL
127 );
128  
129 INSERT INTO Tmp_estate_managers ("EstateID", uuid)
130 SELECT "EstateID", cast(uuid as uuid) FROM estate_managers;
131  
132 DROP TABLE estate_managers;
133  
134 Alter table Tmp_estate_managers
135 rename to estate_managers;
136  
137 CREATE INDEX IX_estate_managers ON estate_managers
138 (
139 "EstateID"
140 );
141  
142 COMMIT;
143  
144  
145 :VERSION 5
146  
147 BEGIN TRANSACTION;
148  
149 CREATE TABLE Tmp_estate_groups
150 (
151 "EstateID" int NOT NULL,
152 uuid uuid NOT NULL
153 ) ;
154  
155 INSERT INTO Tmp_estate_groups ("EstateID", uuid)
156 SELECT "EstateID", cast(uuid as uuid) FROM estate_groups;
157  
158 DROP TABLE estate_groups;
159  
160 Alter table Tmp_estate_groups
161 rename to estate_groups;
162  
163 CREATE INDEX IX_estate_groups ON estate_groups
164 (
165 "EstateID"
166 );
167  
168 COMMIT;
169  
170  
171 :VERSION 6
172  
173 BEGIN TRANSACTION;
174  
175 CREATE TABLE Tmp_estate_users
176 (
177 "EstateID" int NOT NULL,
178 uuid uuid NOT NULL
179 );
180  
181 INSERT INTO Tmp_estate_users ("EstateID", uuid)
182 SELECT "EstateID", cast(uuid as uuid) FROM estate_users ;
183  
184 DROP TABLE estate_users;
185  
186 Alter table Tmp_estate_users
187 rename to estate_users;
188  
189 CREATE INDEX IX_estate_users ON estate_users
190 (
191 "EstateID"
192 );
193  
194 COMMIT;
195  
196  
197 :VERSION 7
198  
199 BEGIN TRANSACTION;
200  
201 CREATE TABLE Tmp_estateban
202 (
203 "EstateID" int NOT NULL,
204 "bannedUUID" uuid NOT NULL,
205 "bannedIp" varchar(16) NULL,
206 "bannedIpHostMask" varchar(16) NULL,
207 "bannedNameMask" varchar(64) NULL
208 );
209  
210 INSERT INTO Tmp_estateban ("EstateID", "bannedUUID", "bannedIp", "bannedIpHostMask", "bannedNameMask")
211 SELECT "EstateID", cast("bannedUUID" as uuid), "bannedIp", "bannedIpHostMask", "bannedNameMask" FROM estateban ;
212  
213 DROP TABLE estateban;
214  
215 Alter table Tmp_estateban
216 rename to estateban;
217  
218 CREATE INDEX IX_estateban ON estateban
219 (
220 "EstateID"
221 );
222  
223 COMMIT;
224  
225  
226 :VERSION 8
227  
228 BEGIN TRANSACTION;
229  
230 CREATE TABLE Tmp_estate_settings
231 (
232 "EstateID" integer default nextval('estate_settings_id') NOT NULL,
233 "EstateName" varchar(64) NULL DEFAULT (NULL),
234 "AbuseEmailToEstateOwner" boolean NOT NULL,
235 "DenyAnonymous" boolean NOT NULL,
236 "ResetHomeOnTeleport" boolean NOT NULL,
237 "FixedSun" boolean NOT NULL,
238 "DenyTransacted" boolean NOT NULL,
239 "BlockDwell" boolean NOT NULL,
240 "DenyIdentified" boolean NOT NULL,
241 "AllowVoice" boolean NOT NULL,
242 "UseGlobalTime" boolean NOT NULL,
243 "PricePerMeter" int NOT NULL,
244 "TaxFree" boolean NOT NULL,
245 "AllowDirectTeleport" boolean NOT NULL,
246 "RedirectGridX" int NOT NULL,
247 "RedirectGridY" int NOT NULL,
248 "ParentEstateID" int NOT NULL,
249 "SunPosition" double precision NOT NULL,
250 "EstateSkipScripts" boolean NOT NULL,
251 "BillableFactor" double precision NOT NULL,
252 "PublicAccess" boolean NOT NULL,
253 "AbuseEmail" varchar(255) NOT NULL,
254 "EstateOwner" uuid NOT NULL,
255 "DenyMinors" boolean NOT NULL
256 );
257  
258 INSERT INTO Tmp_estate_settings ("EstateID", "EstateName", "AbuseEmailToEstateOwner", "DenyAnonymous", "ResetHomeOnTeleport", "FixedSun", "DenyTransacted", "BlockDwell", "DenyIdentified", "AllowVoice", "UseGlobalTime", "PricePerMeter", "TaxFree", "AllowDirectTeleport", "RedirectGridX", "RedirectGridY", "ParentEstateID", "SunPosition", "EstateSkipScripts", "BillableFactor", "PublicAccess", "AbuseEmail", "EstateOwner", "DenyMinors")
259 SELECT "EstateID", "EstateName", "AbuseEmailToEstateOwner", "DenyAnonymous", "ResetHomeOnTeleport", "FixedSun", "DenyTransacted", "BlockDwell", "DenyIdentified", "AllowVoice", "UseGlobalTime", "PricePerMeter", "TaxFree", "AllowDirectTeleport", "RedirectGridX", "RedirectGridY", "ParentEstateID", "SunPosition", "EstateSkipScripts", "BillableFactor", "PublicAccess", "AbuseEmail", cast("EstateOwner" as uuid), "DenyMinors" FROM estate_settings ;
260  
261 DROP TABLE estate_settings;
262  
263  
264 Alter table Tmp_estate_settings
265 rename to estate_settings;
266  
267  
268 Create index on estate_settings (lower("EstateName"));
269  
270 COMMIT;
271  
272  
273 :VERSION 9
274  
275 BEGIN TRANSACTION;
276  
277 CREATE TABLE Tmp_estate_map
278 (
279 "RegionID" uuid NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
280 "EstateID" int NOT NULL
281 );
282  
283 INSERT INTO Tmp_estate_map ("RegionID", "EstateID")
284 SELECT cast("RegionID" as uuid), "EstateID" FROM estate_map ;
285  
286 DROP TABLE estate_map;
287  
288 Alter table Tmp_estate_map
289 rename to estate_map;
290  
291 COMMIT;
292  
293 :VERSION 10
294  
295 BEGIN TRANSACTION;
296 ALTER TABLE estate_settings ADD COLUMN "AllowLandmark" boolean NOT NULL default true;
297 ALTER TABLE estate_settings ADD COLUMN "AllowParcelChanges" boolean NOT NULL default true;
298 ALTER TABLE estate_settings ADD COLUMN "AllowSetHome" boolean NOT NULL default true;
299 COMMIT;
300  
301 :VERSION 11
302  
303 Begin transaction;
304  
305  
306 Commit;
307