1 | --
|
---|
2 | -- PostgreSQL database dump
|
---|
3 | --
|
---|
4 |
|
---|
5 | SET statement_timeout = 0;
|
---|
6 | SET client_encoding = 'UTF8';
|
---|
7 | SET standard_conforming_strings = off;
|
---|
8 | SET check_function_bodies = false;
|
---|
9 | SET client_min_messages = warning;
|
---|
10 | SET escape_string_warning = off;
|
---|
11 |
|
---|
12 | --
|
---|
13 | -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
|
---|
14 | --
|
---|
15 |
|
---|
16 | CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
|
---|
17 |
|
---|
18 |
|
---|
19 | SET search_path = public, pg_catalog;
|
---|
20 |
|
---|
21 | --
|
---|
22 | -- Name: gbtreekey16; Type: SHELL TYPE; Schema: public; Owner: -
|
---|
23 | --
|
---|
24 |
|
---|
25 | CREATE TYPE gbtreekey16;
|
---|
26 |
|
---|
27 |
|
---|
28 | --
|
---|
29 | -- Name: gbtreekey16_in(cstring); Type: FUNCTION; Schema: public; Owner: -
|
---|
30 | --
|
---|
31 |
|
---|
32 | CREATE FUNCTION gbtreekey16_in(cstring) RETURNS gbtreekey16
|
---|
33 | LANGUAGE c IMMUTABLE STRICT
|
---|
34 | AS '$libdir/btree_gist', 'gbtreekey_in';
|
---|
35 |
|
---|
36 |
|
---|
37 | --
|
---|
38 | -- Name: gbtreekey16_out(gbtreekey16); Type: FUNCTION; Schema: public; Owner: -
|
---|
39 | --
|
---|
40 |
|
---|
41 | CREATE FUNCTION gbtreekey16_out(gbtreekey16) RETURNS cstring
|
---|
42 | LANGUAGE c IMMUTABLE STRICT
|
---|
43 | AS '$libdir/btree_gist', 'gbtreekey_out';
|
---|
44 |
|
---|
45 |
|
---|
46 | --
|
---|
47 | -- Name: gbtreekey16; Type: TYPE; Schema: public; Owner: -
|
---|
48 | --
|
---|
49 |
|
---|
50 | CREATE TYPE gbtreekey16 (
|
---|
51 | INTERNALLENGTH = 16,
|
---|
52 | INPUT = gbtreekey16_in,
|
---|
53 | OUTPUT = gbtreekey16_out,
|
---|
54 | ALIGNMENT = int4,
|
---|
55 | STORAGE = plain
|
---|
56 | );
|
---|
57 |
|
---|
58 |
|
---|
59 | --
|
---|
60 | -- Name: gbtreekey32; Type: SHELL TYPE; Schema: public; Owner: -
|
---|
61 | --
|
---|
62 |
|
---|
63 | CREATE TYPE gbtreekey32;
|
---|
64 |
|
---|
65 |
|
---|
66 | --
|
---|
67 | -- Name: gbtreekey32_in(cstring); Type: FUNCTION; Schema: public; Owner: -
|
---|
68 | --
|
---|
69 |
|
---|
70 | CREATE FUNCTION gbtreekey32_in(cstring) RETURNS gbtreekey32
|
---|
71 | LANGUAGE c IMMUTABLE STRICT
|
---|
72 | AS '$libdir/btree_gist', 'gbtreekey_in';
|
---|
73 |
|
---|
74 |
|
---|
75 | --
|
---|
76 | -- Name: gbtreekey32_out(gbtreekey32); Type: FUNCTION; Schema: public; Owner: -
|
---|
77 | --
|
---|
78 |
|
---|
79 | CREATE FUNCTION gbtreekey32_out(gbtreekey32) RETURNS cstring
|
---|
80 | LANGUAGE c IMMUTABLE STRICT
|
---|
81 | AS '$libdir/btree_gist', 'gbtreekey_out';
|
---|
82 |
|
---|
83 |
|
---|
84 | --
|
---|
85 | -- Name: gbtreekey32; Type: TYPE; Schema: public; Owner: -
|
---|
86 | --
|
---|
87 |
|
---|
88 | CREATE TYPE gbtreekey32 (
|
---|
89 | INTERNALLENGTH = 32,
|
---|
90 | INPUT = gbtreekey32_in,
|
---|
91 | OUTPUT = gbtreekey32_out,
|
---|
92 | ALIGNMENT = int4,
|
---|
93 | STORAGE = plain
|
---|
94 | );
|
---|
95 |
|
---|
96 |
|
---|
97 | --
|
---|
98 | -- Name: gbtreekey4; Type: SHELL TYPE; Schema: public; Owner: -
|
---|
99 | --
|
---|
100 |
|
---|
101 | CREATE TYPE gbtreekey4;
|
---|
102 |
|
---|
103 |
|
---|
104 | --
|
---|
105 | -- Name: gbtreekey4_in(cstring); Type: FUNCTION; Schema: public; Owner: -
|
---|
106 | --
|
---|
107 |
|
---|
108 | CREATE FUNCTION gbtreekey4_in(cstring) RETURNS gbtreekey4
|
---|
109 | LANGUAGE c IMMUTABLE STRICT
|
---|
110 | AS '$libdir/btree_gist', 'gbtreekey_in';
|
---|
111 |
|
---|
112 |
|
---|
113 | --
|
---|
114 | -- Name: gbtreekey4_out(gbtreekey4); Type: FUNCTION; Schema: public; Owner: -
|
---|
115 | --
|
---|
116 |
|
---|
117 | CREATE FUNCTION gbtreekey4_out(gbtreekey4) RETURNS cstring
|
---|
118 | LANGUAGE c IMMUTABLE STRICT
|
---|
119 | AS '$libdir/btree_gist', 'gbtreekey_out';
|
---|
120 |
|
---|
121 |
|
---|
122 | --
|
---|
123 | -- Name: gbtreekey4; Type: TYPE; Schema: public; Owner: -
|
---|
124 | --
|
---|
125 |
|
---|
126 | CREATE TYPE gbtreekey4 (
|
---|
127 | INTERNALLENGTH = 4,
|
---|
128 | INPUT = gbtreekey4_in,
|
---|
129 | OUTPUT = gbtreekey4_out,
|
---|
130 | ALIGNMENT = int4,
|
---|
131 | STORAGE = plain
|
---|
132 | );
|
---|
133 |
|
---|
134 |
|
---|
135 | --
|
---|
136 | -- Name: gbtreekey8; Type: SHELL TYPE; Schema: public; Owner: -
|
---|
137 | --
|
---|
138 |
|
---|
139 | CREATE TYPE gbtreekey8;
|
---|
140 |
|
---|
141 |
|
---|
142 | --
|
---|
143 | -- Name: gbtreekey8_in(cstring); Type: FUNCTION; Schema: public; Owner: -
|
---|
144 | --
|
---|
145 |
|
---|
146 | CREATE FUNCTION gbtreekey8_in(cstring) RETURNS gbtreekey8
|
---|
147 | LANGUAGE c IMMUTABLE STRICT
|
---|
148 | AS '$libdir/btree_gist', 'gbtreekey_in';
|
---|
149 |
|
---|
150 |
|
---|
151 | --
|
---|
152 | -- Name: gbtreekey8_out(gbtreekey8); Type: FUNCTION; Schema: public; Owner: -
|
---|
153 | --
|
---|
154 |
|
---|
155 | CREATE FUNCTION gbtreekey8_out(gbtreekey8) RETURNS cstring
|
---|
156 | LANGUAGE c IMMUTABLE STRICT
|
---|
157 | AS '$libdir/btree_gist', 'gbtreekey_out';
|
---|
158 |
|
---|
159 |
|
---|
160 | --
|
---|
161 | -- Name: gbtreekey8; Type: TYPE; Schema: public; Owner: -
|
---|
162 | --
|
---|
163 |
|
---|
164 | CREATE TYPE gbtreekey8 (
|
---|
165 | INTERNALLENGTH = 8,
|
---|
166 | INPUT = gbtreekey8_in,
|
---|
167 | OUTPUT = gbtreekey8_out,
|
---|
168 | ALIGNMENT = int4,
|
---|
169 | STORAGE = plain
|
---|
170 | );
|
---|
171 |
|
---|
172 |
|
---|
173 | --
|
---|
174 | -- Name: gbtreekey_var; Type: SHELL TYPE; Schema: public; Owner: -
|
---|
175 | --
|
---|
176 |
|
---|
177 | CREATE TYPE gbtreekey_var;
|
---|
178 |
|
---|
179 |
|
---|
180 | --
|
---|
181 | -- Name: gbtreekey_var_in(cstring); Type: FUNCTION; Schema: public; Owner: -
|
---|
182 | --
|
---|
183 |
|
---|
184 | CREATE FUNCTION gbtreekey_var_in(cstring) RETURNS gbtreekey_var
|
---|
185 | LANGUAGE c IMMUTABLE STRICT
|
---|
186 | AS '$libdir/btree_gist', 'gbtreekey_in';
|
---|
187 |
|
---|
188 |
|
---|
189 | --
|
---|
190 | -- Name: gbtreekey_var_out(gbtreekey_var); Type: FUNCTION; Schema: public; Owner: -
|
---|
191 | --
|
---|
192 |
|
---|
193 | CREATE FUNCTION gbtreekey_var_out(gbtreekey_var) RETURNS cstring
|
---|
194 | LANGUAGE c IMMUTABLE STRICT
|
---|
195 | AS '$libdir/btree_gist', 'gbtreekey_out';
|
---|
196 |
|
---|
197 |
|
---|
198 | --
|
---|
199 | -- Name: gbtreekey_var; Type: TYPE; Schema: public; Owner: -
|
---|
200 | --
|
---|
201 |
|
---|
202 | CREATE TYPE gbtreekey_var (
|
---|
203 | INTERNALLENGTH = variable,
|
---|
204 | INPUT = gbtreekey_var_in,
|
---|
205 | OUTPUT = gbtreekey_var_out,
|
---|
206 | ALIGNMENT = int4,
|
---|
207 | STORAGE = extended
|
---|
208 | );
|
---|
209 |
|
---|
210 |
|
---|
211 | --
|
---|
212 | -- Name: gpx_visibility_enum; Type: TYPE; Schema: public; Owner: -
|
---|
213 | --
|
---|
214 |
|
---|
215 | CREATE TYPE gpx_visibility_enum AS ENUM (
|
---|
216 | 'private',
|
---|
217 | 'public',
|
---|
218 | 'trackable',
|
---|
219 | 'identifiable'
|
---|
220 | );
|
---|
221 |
|
---|
222 |
|
---|
223 | --
|
---|
224 | -- Name: nwr_enum; Type: TYPE; Schema: public; Owner: -
|
---|
225 | --
|
---|
226 |
|
---|
227 | CREATE TYPE nwr_enum AS ENUM (
|
---|
228 | 'Node',
|
---|
229 | 'Way',
|
---|
230 | 'Relation'
|
---|
231 | );
|
---|
232 |
|
---|
233 |
|
---|
234 | --
|
---|
235 | -- Name: user_role_enum; Type: TYPE; Schema: public; Owner: -
|
---|
236 | --
|
---|
237 |
|
---|
238 | CREATE TYPE user_role_enum AS ENUM (
|
---|
239 | 'administrator',
|
---|
240 | 'moderator'
|
---|
241 | );
|
---|
242 |
|
---|
243 |
|
---|
244 | --
|
---|
245 | -- Name: user_status_enum; Type: TYPE; Schema: public; Owner: -
|
---|
246 | --
|
---|
247 |
|
---|
248 | CREATE TYPE user_status_enum AS ENUM (
|
---|
249 | 'pending',
|
---|
250 | 'active',
|
---|
251 | 'confirmed',
|
---|
252 | 'suspended',
|
---|
253 | 'deleted'
|
---|
254 | );
|
---|
255 |
|
---|
256 |
|
---|
257 | --
|
---|
258 | -- Name: gbt_bit_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
259 | --
|
---|
260 |
|
---|
261 | CREATE FUNCTION gbt_bit_compress(internal) RETURNS internal
|
---|
262 | LANGUAGE c IMMUTABLE STRICT
|
---|
263 | AS '$libdir/btree_gist', 'gbt_bit_compress';
|
---|
264 |
|
---|
265 |
|
---|
266 | --
|
---|
267 | -- Name: gbt_bit_consistent(internal, bit, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
268 | --
|
---|
269 |
|
---|
270 | CREATE FUNCTION gbt_bit_consistent(internal, bit, smallint, oid, internal) RETURNS boolean
|
---|
271 | LANGUAGE c IMMUTABLE STRICT
|
---|
272 | AS '$libdir/btree_gist', 'gbt_bit_consistent';
|
---|
273 |
|
---|
274 |
|
---|
275 | --
|
---|
276 | -- Name: gbt_bit_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
277 | --
|
---|
278 |
|
---|
279 | CREATE FUNCTION gbt_bit_penalty(internal, internal, internal) RETURNS internal
|
---|
280 | LANGUAGE c IMMUTABLE STRICT
|
---|
281 | AS '$libdir/btree_gist', 'gbt_bit_penalty';
|
---|
282 |
|
---|
283 |
|
---|
284 | --
|
---|
285 | -- Name: gbt_bit_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
286 | --
|
---|
287 |
|
---|
288 | CREATE FUNCTION gbt_bit_picksplit(internal, internal) RETURNS internal
|
---|
289 | LANGUAGE c IMMUTABLE STRICT
|
---|
290 | AS '$libdir/btree_gist', 'gbt_bit_picksplit';
|
---|
291 |
|
---|
292 |
|
---|
293 | --
|
---|
294 | -- Name: gbt_bit_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
295 | --
|
---|
296 |
|
---|
297 | CREATE FUNCTION gbt_bit_same(internal, internal, internal) RETURNS internal
|
---|
298 | LANGUAGE c IMMUTABLE STRICT
|
---|
299 | AS '$libdir/btree_gist', 'gbt_bit_same';
|
---|
300 |
|
---|
301 |
|
---|
302 | --
|
---|
303 | -- Name: gbt_bit_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
304 | --
|
---|
305 |
|
---|
306 | CREATE FUNCTION gbt_bit_union(bytea, internal) RETURNS gbtreekey_var
|
---|
307 | LANGUAGE c IMMUTABLE STRICT
|
---|
308 | AS '$libdir/btree_gist', 'gbt_bit_union';
|
---|
309 |
|
---|
310 |
|
---|
311 | --
|
---|
312 | -- Name: gbt_bpchar_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
313 | --
|
---|
314 |
|
---|
315 | CREATE FUNCTION gbt_bpchar_compress(internal) RETURNS internal
|
---|
316 | LANGUAGE c IMMUTABLE STRICT
|
---|
317 | AS '$libdir/btree_gist', 'gbt_bpchar_compress';
|
---|
318 |
|
---|
319 |
|
---|
320 | --
|
---|
321 | -- Name: gbt_bpchar_consistent(internal, character, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
322 | --
|
---|
323 |
|
---|
324 | CREATE FUNCTION gbt_bpchar_consistent(internal, character, smallint, oid, internal) RETURNS boolean
|
---|
325 | LANGUAGE c IMMUTABLE STRICT
|
---|
326 | AS '$libdir/btree_gist', 'gbt_bpchar_consistent';
|
---|
327 |
|
---|
328 |
|
---|
329 | --
|
---|
330 | -- Name: gbt_bytea_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
331 | --
|
---|
332 |
|
---|
333 | CREATE FUNCTION gbt_bytea_compress(internal) RETURNS internal
|
---|
334 | LANGUAGE c IMMUTABLE STRICT
|
---|
335 | AS '$libdir/btree_gist', 'gbt_bytea_compress';
|
---|
336 |
|
---|
337 |
|
---|
338 | --
|
---|
339 | -- Name: gbt_bytea_consistent(internal, bytea, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
340 | --
|
---|
341 |
|
---|
342 | CREATE FUNCTION gbt_bytea_consistent(internal, bytea, smallint, oid, internal) RETURNS boolean
|
---|
343 | LANGUAGE c IMMUTABLE STRICT
|
---|
344 | AS '$libdir/btree_gist', 'gbt_bytea_consistent';
|
---|
345 |
|
---|
346 |
|
---|
347 | --
|
---|
348 | -- Name: gbt_bytea_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
349 | --
|
---|
350 |
|
---|
351 | CREATE FUNCTION gbt_bytea_penalty(internal, internal, internal) RETURNS internal
|
---|
352 | LANGUAGE c IMMUTABLE STRICT
|
---|
353 | AS '$libdir/btree_gist', 'gbt_bytea_penalty';
|
---|
354 |
|
---|
355 |
|
---|
356 | --
|
---|
357 | -- Name: gbt_bytea_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
358 | --
|
---|
359 |
|
---|
360 | CREATE FUNCTION gbt_bytea_picksplit(internal, internal) RETURNS internal
|
---|
361 | LANGUAGE c IMMUTABLE STRICT
|
---|
362 | AS '$libdir/btree_gist', 'gbt_bytea_picksplit';
|
---|
363 |
|
---|
364 |
|
---|
365 | --
|
---|
366 | -- Name: gbt_bytea_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
367 | --
|
---|
368 |
|
---|
369 | CREATE FUNCTION gbt_bytea_same(internal, internal, internal) RETURNS internal
|
---|
370 | LANGUAGE c IMMUTABLE STRICT
|
---|
371 | AS '$libdir/btree_gist', 'gbt_bytea_same';
|
---|
372 |
|
---|
373 |
|
---|
374 | --
|
---|
375 | -- Name: gbt_bytea_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
376 | --
|
---|
377 |
|
---|
378 | CREATE FUNCTION gbt_bytea_union(bytea, internal) RETURNS gbtreekey_var
|
---|
379 | LANGUAGE c IMMUTABLE STRICT
|
---|
380 | AS '$libdir/btree_gist', 'gbt_bytea_union';
|
---|
381 |
|
---|
382 |
|
---|
383 | --
|
---|
384 | -- Name: gbt_cash_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
385 | --
|
---|
386 |
|
---|
387 | CREATE FUNCTION gbt_cash_compress(internal) RETURNS internal
|
---|
388 | LANGUAGE c IMMUTABLE STRICT
|
---|
389 | AS '$libdir/btree_gist', 'gbt_cash_compress';
|
---|
390 |
|
---|
391 |
|
---|
392 | --
|
---|
393 | -- Name: gbt_cash_consistent(internal, money, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
394 | --
|
---|
395 |
|
---|
396 | CREATE FUNCTION gbt_cash_consistent(internal, money, smallint, oid, internal) RETURNS boolean
|
---|
397 | LANGUAGE c IMMUTABLE STRICT
|
---|
398 | AS '$libdir/btree_gist', 'gbt_cash_consistent';
|
---|
399 |
|
---|
400 |
|
---|
401 | --
|
---|
402 | -- Name: gbt_cash_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
403 | --
|
---|
404 |
|
---|
405 | CREATE FUNCTION gbt_cash_penalty(internal, internal, internal) RETURNS internal
|
---|
406 | LANGUAGE c IMMUTABLE STRICT
|
---|
407 | AS '$libdir/btree_gist', 'gbt_cash_penalty';
|
---|
408 |
|
---|
409 |
|
---|
410 | --
|
---|
411 | -- Name: gbt_cash_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
412 | --
|
---|
413 |
|
---|
414 | CREATE FUNCTION gbt_cash_picksplit(internal, internal) RETURNS internal
|
---|
415 | LANGUAGE c IMMUTABLE STRICT
|
---|
416 | AS '$libdir/btree_gist', 'gbt_cash_picksplit';
|
---|
417 |
|
---|
418 |
|
---|
419 | --
|
---|
420 | -- Name: gbt_cash_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
421 | --
|
---|
422 |
|
---|
423 | CREATE FUNCTION gbt_cash_same(internal, internal, internal) RETURNS internal
|
---|
424 | LANGUAGE c IMMUTABLE STRICT
|
---|
425 | AS '$libdir/btree_gist', 'gbt_cash_same';
|
---|
426 |
|
---|
427 |
|
---|
428 | --
|
---|
429 | -- Name: gbt_cash_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
430 | --
|
---|
431 |
|
---|
432 | CREATE FUNCTION gbt_cash_union(bytea, internal) RETURNS gbtreekey8
|
---|
433 | LANGUAGE c IMMUTABLE STRICT
|
---|
434 | AS '$libdir/btree_gist', 'gbt_cash_union';
|
---|
435 |
|
---|
436 |
|
---|
437 | --
|
---|
438 | -- Name: gbt_date_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
439 | --
|
---|
440 |
|
---|
441 | CREATE FUNCTION gbt_date_compress(internal) RETURNS internal
|
---|
442 | LANGUAGE c IMMUTABLE STRICT
|
---|
443 | AS '$libdir/btree_gist', 'gbt_date_compress';
|
---|
444 |
|
---|
445 |
|
---|
446 | --
|
---|
447 | -- Name: gbt_date_consistent(internal, date, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
448 | --
|
---|
449 |
|
---|
450 | CREATE FUNCTION gbt_date_consistent(internal, date, smallint, oid, internal) RETURNS boolean
|
---|
451 | LANGUAGE c IMMUTABLE STRICT
|
---|
452 | AS '$libdir/btree_gist', 'gbt_date_consistent';
|
---|
453 |
|
---|
454 |
|
---|
455 | --
|
---|
456 | -- Name: gbt_date_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
457 | --
|
---|
458 |
|
---|
459 | CREATE FUNCTION gbt_date_penalty(internal, internal, internal) RETURNS internal
|
---|
460 | LANGUAGE c IMMUTABLE STRICT
|
---|
461 | AS '$libdir/btree_gist', 'gbt_date_penalty';
|
---|
462 |
|
---|
463 |
|
---|
464 | --
|
---|
465 | -- Name: gbt_date_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
466 | --
|
---|
467 |
|
---|
468 | CREATE FUNCTION gbt_date_picksplit(internal, internal) RETURNS internal
|
---|
469 | LANGUAGE c IMMUTABLE STRICT
|
---|
470 | AS '$libdir/btree_gist', 'gbt_date_picksplit';
|
---|
471 |
|
---|
472 |
|
---|
473 | --
|
---|
474 | -- Name: gbt_date_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
475 | --
|
---|
476 |
|
---|
477 | CREATE FUNCTION gbt_date_same(internal, internal, internal) RETURNS internal
|
---|
478 | LANGUAGE c IMMUTABLE STRICT
|
---|
479 | AS '$libdir/btree_gist', 'gbt_date_same';
|
---|
480 |
|
---|
481 |
|
---|
482 | --
|
---|
483 | -- Name: gbt_date_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
484 | --
|
---|
485 |
|
---|
486 | CREATE FUNCTION gbt_date_union(bytea, internal) RETURNS gbtreekey8
|
---|
487 | LANGUAGE c IMMUTABLE STRICT
|
---|
488 | AS '$libdir/btree_gist', 'gbt_date_union';
|
---|
489 |
|
---|
490 |
|
---|
491 | --
|
---|
492 | -- Name: gbt_decompress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
493 | --
|
---|
494 |
|
---|
495 | CREATE FUNCTION gbt_decompress(internal) RETURNS internal
|
---|
496 | LANGUAGE c IMMUTABLE STRICT
|
---|
497 | AS '$libdir/btree_gist', 'gbt_decompress';
|
---|
498 |
|
---|
499 |
|
---|
500 | --
|
---|
501 | -- Name: gbt_float4_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
502 | --
|
---|
503 |
|
---|
504 | CREATE FUNCTION gbt_float4_compress(internal) RETURNS internal
|
---|
505 | LANGUAGE c IMMUTABLE STRICT
|
---|
506 | AS '$libdir/btree_gist', 'gbt_float4_compress';
|
---|
507 |
|
---|
508 |
|
---|
509 | --
|
---|
510 | -- Name: gbt_float4_consistent(internal, real, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
511 | --
|
---|
512 |
|
---|
513 | CREATE FUNCTION gbt_float4_consistent(internal, real, smallint, oid, internal) RETURNS boolean
|
---|
514 | LANGUAGE c IMMUTABLE STRICT
|
---|
515 | AS '$libdir/btree_gist', 'gbt_float4_consistent';
|
---|
516 |
|
---|
517 |
|
---|
518 | --
|
---|
519 | -- Name: gbt_float4_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
520 | --
|
---|
521 |
|
---|
522 | CREATE FUNCTION gbt_float4_penalty(internal, internal, internal) RETURNS internal
|
---|
523 | LANGUAGE c IMMUTABLE STRICT
|
---|
524 | AS '$libdir/btree_gist', 'gbt_float4_penalty';
|
---|
525 |
|
---|
526 |
|
---|
527 | --
|
---|
528 | -- Name: gbt_float4_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
529 | --
|
---|
530 |
|
---|
531 | CREATE FUNCTION gbt_float4_picksplit(internal, internal) RETURNS internal
|
---|
532 | LANGUAGE c IMMUTABLE STRICT
|
---|
533 | AS '$libdir/btree_gist', 'gbt_float4_picksplit';
|
---|
534 |
|
---|
535 |
|
---|
536 | --
|
---|
537 | -- Name: gbt_float4_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
538 | --
|
---|
539 |
|
---|
540 | CREATE FUNCTION gbt_float4_same(internal, internal, internal) RETURNS internal
|
---|
541 | LANGUAGE c IMMUTABLE STRICT
|
---|
542 | AS '$libdir/btree_gist', 'gbt_float4_same';
|
---|
543 |
|
---|
544 |
|
---|
545 | --
|
---|
546 | -- Name: gbt_float4_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
547 | --
|
---|
548 |
|
---|
549 | CREATE FUNCTION gbt_float4_union(bytea, internal) RETURNS gbtreekey8
|
---|
550 | LANGUAGE c IMMUTABLE STRICT
|
---|
551 | AS '$libdir/btree_gist', 'gbt_float4_union';
|
---|
552 |
|
---|
553 |
|
---|
554 | --
|
---|
555 | -- Name: gbt_float8_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
556 | --
|
---|
557 |
|
---|
558 | CREATE FUNCTION gbt_float8_compress(internal) RETURNS internal
|
---|
559 | LANGUAGE c IMMUTABLE STRICT
|
---|
560 | AS '$libdir/btree_gist', 'gbt_float8_compress';
|
---|
561 |
|
---|
562 |
|
---|
563 | --
|
---|
564 | -- Name: gbt_float8_consistent(internal, double precision, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
565 | --
|
---|
566 |
|
---|
567 | CREATE FUNCTION gbt_float8_consistent(internal, double precision, smallint, oid, internal) RETURNS boolean
|
---|
568 | LANGUAGE c IMMUTABLE STRICT
|
---|
569 | AS '$libdir/btree_gist', 'gbt_float8_consistent';
|
---|
570 |
|
---|
571 |
|
---|
572 | --
|
---|
573 | -- Name: gbt_float8_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
574 | --
|
---|
575 |
|
---|
576 | CREATE FUNCTION gbt_float8_penalty(internal, internal, internal) RETURNS internal
|
---|
577 | LANGUAGE c IMMUTABLE STRICT
|
---|
578 | AS '$libdir/btree_gist', 'gbt_float8_penalty';
|
---|
579 |
|
---|
580 |
|
---|
581 | --
|
---|
582 | -- Name: gbt_float8_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
583 | --
|
---|
584 |
|
---|
585 | CREATE FUNCTION gbt_float8_picksplit(internal, internal) RETURNS internal
|
---|
586 | LANGUAGE c IMMUTABLE STRICT
|
---|
587 | AS '$libdir/btree_gist', 'gbt_float8_picksplit';
|
---|
588 |
|
---|
589 |
|
---|
590 | --
|
---|
591 | -- Name: gbt_float8_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
592 | --
|
---|
593 |
|
---|
594 | CREATE FUNCTION gbt_float8_same(internal, internal, internal) RETURNS internal
|
---|
595 | LANGUAGE c IMMUTABLE STRICT
|
---|
596 | AS '$libdir/btree_gist', 'gbt_float8_same';
|
---|
597 |
|
---|
598 |
|
---|
599 | --
|
---|
600 | -- Name: gbt_float8_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
601 | --
|
---|
602 |
|
---|
603 | CREATE FUNCTION gbt_float8_union(bytea, internal) RETURNS gbtreekey16
|
---|
604 | LANGUAGE c IMMUTABLE STRICT
|
---|
605 | AS '$libdir/btree_gist', 'gbt_float8_union';
|
---|
606 |
|
---|
607 |
|
---|
608 | --
|
---|
609 | -- Name: gbt_inet_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
610 | --
|
---|
611 |
|
---|
612 | CREATE FUNCTION gbt_inet_compress(internal) RETURNS internal
|
---|
613 | LANGUAGE c IMMUTABLE STRICT
|
---|
614 | AS '$libdir/btree_gist', 'gbt_inet_compress';
|
---|
615 |
|
---|
616 |
|
---|
617 | --
|
---|
618 | -- Name: gbt_inet_consistent(internal, inet, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
619 | --
|
---|
620 |
|
---|
621 | CREATE FUNCTION gbt_inet_consistent(internal, inet, smallint, oid, internal) RETURNS boolean
|
---|
622 | LANGUAGE c IMMUTABLE STRICT
|
---|
623 | AS '$libdir/btree_gist', 'gbt_inet_consistent';
|
---|
624 |
|
---|
625 |
|
---|
626 | --
|
---|
627 | -- Name: gbt_inet_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
628 | --
|
---|
629 |
|
---|
630 | CREATE FUNCTION gbt_inet_penalty(internal, internal, internal) RETURNS internal
|
---|
631 | LANGUAGE c IMMUTABLE STRICT
|
---|
632 | AS '$libdir/btree_gist', 'gbt_inet_penalty';
|
---|
633 |
|
---|
634 |
|
---|
635 | --
|
---|
636 | -- Name: gbt_inet_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
637 | --
|
---|
638 |
|
---|
639 | CREATE FUNCTION gbt_inet_picksplit(internal, internal) RETURNS internal
|
---|
640 | LANGUAGE c IMMUTABLE STRICT
|
---|
641 | AS '$libdir/btree_gist', 'gbt_inet_picksplit';
|
---|
642 |
|
---|
643 |
|
---|
644 | --
|
---|
645 | -- Name: gbt_inet_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
646 | --
|
---|
647 |
|
---|
648 | CREATE FUNCTION gbt_inet_same(internal, internal, internal) RETURNS internal
|
---|
649 | LANGUAGE c IMMUTABLE STRICT
|
---|
650 | AS '$libdir/btree_gist', 'gbt_inet_same';
|
---|
651 |
|
---|
652 |
|
---|
653 | --
|
---|
654 | -- Name: gbt_inet_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
655 | --
|
---|
656 |
|
---|
657 | CREATE FUNCTION gbt_inet_union(bytea, internal) RETURNS gbtreekey16
|
---|
658 | LANGUAGE c IMMUTABLE STRICT
|
---|
659 | AS '$libdir/btree_gist', 'gbt_inet_union';
|
---|
660 |
|
---|
661 |
|
---|
662 | --
|
---|
663 | -- Name: gbt_int2_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
664 | --
|
---|
665 |
|
---|
666 | CREATE FUNCTION gbt_int2_compress(internal) RETURNS internal
|
---|
667 | LANGUAGE c IMMUTABLE STRICT
|
---|
668 | AS '$libdir/btree_gist', 'gbt_int2_compress';
|
---|
669 |
|
---|
670 |
|
---|
671 | --
|
---|
672 | -- Name: gbt_int2_consistent(internal, smallint, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
673 | --
|
---|
674 |
|
---|
675 | CREATE FUNCTION gbt_int2_consistent(internal, smallint, smallint, oid, internal) RETURNS boolean
|
---|
676 | LANGUAGE c IMMUTABLE STRICT
|
---|
677 | AS '$libdir/btree_gist', 'gbt_int2_consistent';
|
---|
678 |
|
---|
679 |
|
---|
680 | --
|
---|
681 | -- Name: gbt_int2_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
682 | --
|
---|
683 |
|
---|
684 | CREATE FUNCTION gbt_int2_penalty(internal, internal, internal) RETURNS internal
|
---|
685 | LANGUAGE c IMMUTABLE STRICT
|
---|
686 | AS '$libdir/btree_gist', 'gbt_int2_penalty';
|
---|
687 |
|
---|
688 |
|
---|
689 | --
|
---|
690 | -- Name: gbt_int2_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
691 | --
|
---|
692 |
|
---|
693 | CREATE FUNCTION gbt_int2_picksplit(internal, internal) RETURNS internal
|
---|
694 | LANGUAGE c IMMUTABLE STRICT
|
---|
695 | AS '$libdir/btree_gist', 'gbt_int2_picksplit';
|
---|
696 |
|
---|
697 |
|
---|
698 | --
|
---|
699 | -- Name: gbt_int2_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
700 | --
|
---|
701 |
|
---|
702 | CREATE FUNCTION gbt_int2_same(internal, internal, internal) RETURNS internal
|
---|
703 | LANGUAGE c IMMUTABLE STRICT
|
---|
704 | AS '$libdir/btree_gist', 'gbt_int2_same';
|
---|
705 |
|
---|
706 |
|
---|
707 | --
|
---|
708 | -- Name: gbt_int2_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
709 | --
|
---|
710 |
|
---|
711 | CREATE FUNCTION gbt_int2_union(bytea, internal) RETURNS gbtreekey4
|
---|
712 | LANGUAGE c IMMUTABLE STRICT
|
---|
713 | AS '$libdir/btree_gist', 'gbt_int2_union';
|
---|
714 |
|
---|
715 |
|
---|
716 | --
|
---|
717 | -- Name: gbt_int4_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
718 | --
|
---|
719 |
|
---|
720 | CREATE FUNCTION gbt_int4_compress(internal) RETURNS internal
|
---|
721 | LANGUAGE c IMMUTABLE STRICT
|
---|
722 | AS '$libdir/btree_gist', 'gbt_int4_compress';
|
---|
723 |
|
---|
724 |
|
---|
725 | --
|
---|
726 | -- Name: gbt_int4_consistent(internal, integer, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
727 | --
|
---|
728 |
|
---|
729 | CREATE FUNCTION gbt_int4_consistent(internal, integer, smallint, oid, internal) RETURNS boolean
|
---|
730 | LANGUAGE c IMMUTABLE STRICT
|
---|
731 | AS '$libdir/btree_gist', 'gbt_int4_consistent';
|
---|
732 |
|
---|
733 |
|
---|
734 | --
|
---|
735 | -- Name: gbt_int4_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
736 | --
|
---|
737 |
|
---|
738 | CREATE FUNCTION gbt_int4_penalty(internal, internal, internal) RETURNS internal
|
---|
739 | LANGUAGE c IMMUTABLE STRICT
|
---|
740 | AS '$libdir/btree_gist', 'gbt_int4_penalty';
|
---|
741 |
|
---|
742 |
|
---|
743 | --
|
---|
744 | -- Name: gbt_int4_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
745 | --
|
---|
746 |
|
---|
747 | CREATE FUNCTION gbt_int4_picksplit(internal, internal) RETURNS internal
|
---|
748 | LANGUAGE c IMMUTABLE STRICT
|
---|
749 | AS '$libdir/btree_gist', 'gbt_int4_picksplit';
|
---|
750 |
|
---|
751 |
|
---|
752 | --
|
---|
753 | -- Name: gbt_int4_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
754 | --
|
---|
755 |
|
---|
756 | CREATE FUNCTION gbt_int4_same(internal, internal, internal) RETURNS internal
|
---|
757 | LANGUAGE c IMMUTABLE STRICT
|
---|
758 | AS '$libdir/btree_gist', 'gbt_int4_same';
|
---|
759 |
|
---|
760 |
|
---|
761 | --
|
---|
762 | -- Name: gbt_int4_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
763 | --
|
---|
764 |
|
---|
765 | CREATE FUNCTION gbt_int4_union(bytea, internal) RETURNS gbtreekey8
|
---|
766 | LANGUAGE c IMMUTABLE STRICT
|
---|
767 | AS '$libdir/btree_gist', 'gbt_int4_union';
|
---|
768 |
|
---|
769 |
|
---|
770 | --
|
---|
771 | -- Name: gbt_int8_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
772 | --
|
---|
773 |
|
---|
774 | CREATE FUNCTION gbt_int8_compress(internal) RETURNS internal
|
---|
775 | LANGUAGE c IMMUTABLE STRICT
|
---|
776 | AS '$libdir/btree_gist', 'gbt_int8_compress';
|
---|
777 |
|
---|
778 |
|
---|
779 | --
|
---|
780 | -- Name: gbt_int8_consistent(internal, bigint, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
781 | --
|
---|
782 |
|
---|
783 | CREATE FUNCTION gbt_int8_consistent(internal, bigint, smallint, oid, internal) RETURNS boolean
|
---|
784 | LANGUAGE c IMMUTABLE STRICT
|
---|
785 | AS '$libdir/btree_gist', 'gbt_int8_consistent';
|
---|
786 |
|
---|
787 |
|
---|
788 | --
|
---|
789 | -- Name: gbt_int8_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
790 | --
|
---|
791 |
|
---|
792 | CREATE FUNCTION gbt_int8_penalty(internal, internal, internal) RETURNS internal
|
---|
793 | LANGUAGE c IMMUTABLE STRICT
|
---|
794 | AS '$libdir/btree_gist', 'gbt_int8_penalty';
|
---|
795 |
|
---|
796 |
|
---|
797 | --
|
---|
798 | -- Name: gbt_int8_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
799 | --
|
---|
800 |
|
---|
801 | CREATE FUNCTION gbt_int8_picksplit(internal, internal) RETURNS internal
|
---|
802 | LANGUAGE c IMMUTABLE STRICT
|
---|
803 | AS '$libdir/btree_gist', 'gbt_int8_picksplit';
|
---|
804 |
|
---|
805 |
|
---|
806 | --
|
---|
807 | -- Name: gbt_int8_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
808 | --
|
---|
809 |
|
---|
810 | CREATE FUNCTION gbt_int8_same(internal, internal, internal) RETURNS internal
|
---|
811 | LANGUAGE c IMMUTABLE STRICT
|
---|
812 | AS '$libdir/btree_gist', 'gbt_int8_same';
|
---|
813 |
|
---|
814 |
|
---|
815 | --
|
---|
816 | -- Name: gbt_int8_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
817 | --
|
---|
818 |
|
---|
819 | CREATE FUNCTION gbt_int8_union(bytea, internal) RETURNS gbtreekey16
|
---|
820 | LANGUAGE c IMMUTABLE STRICT
|
---|
821 | AS '$libdir/btree_gist', 'gbt_int8_union';
|
---|
822 |
|
---|
823 |
|
---|
824 | --
|
---|
825 | -- Name: gbt_intv_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
826 | --
|
---|
827 |
|
---|
828 | CREATE FUNCTION gbt_intv_compress(internal) RETURNS internal
|
---|
829 | LANGUAGE c IMMUTABLE STRICT
|
---|
830 | AS '$libdir/btree_gist', 'gbt_intv_compress';
|
---|
831 |
|
---|
832 |
|
---|
833 | --
|
---|
834 | -- Name: gbt_intv_consistent(internal, interval, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
835 | --
|
---|
836 |
|
---|
837 | CREATE FUNCTION gbt_intv_consistent(internal, interval, smallint, oid, internal) RETURNS boolean
|
---|
838 | LANGUAGE c IMMUTABLE STRICT
|
---|
839 | AS '$libdir/btree_gist', 'gbt_intv_consistent';
|
---|
840 |
|
---|
841 |
|
---|
842 | --
|
---|
843 | -- Name: gbt_intv_decompress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
844 | --
|
---|
845 |
|
---|
846 | CREATE FUNCTION gbt_intv_decompress(internal) RETURNS internal
|
---|
847 | LANGUAGE c IMMUTABLE STRICT
|
---|
848 | AS '$libdir/btree_gist', 'gbt_intv_decompress';
|
---|
849 |
|
---|
850 |
|
---|
851 | --
|
---|
852 | -- Name: gbt_intv_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
853 | --
|
---|
854 |
|
---|
855 | CREATE FUNCTION gbt_intv_penalty(internal, internal, internal) RETURNS internal
|
---|
856 | LANGUAGE c IMMUTABLE STRICT
|
---|
857 | AS '$libdir/btree_gist', 'gbt_intv_penalty';
|
---|
858 |
|
---|
859 |
|
---|
860 | --
|
---|
861 | -- Name: gbt_intv_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
862 | --
|
---|
863 |
|
---|
864 | CREATE FUNCTION gbt_intv_picksplit(internal, internal) RETURNS internal
|
---|
865 | LANGUAGE c IMMUTABLE STRICT
|
---|
866 | AS '$libdir/btree_gist', 'gbt_intv_picksplit';
|
---|
867 |
|
---|
868 |
|
---|
869 | --
|
---|
870 | -- Name: gbt_intv_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
871 | --
|
---|
872 |
|
---|
873 | CREATE FUNCTION gbt_intv_same(internal, internal, internal) RETURNS internal
|
---|
874 | LANGUAGE c IMMUTABLE STRICT
|
---|
875 | AS '$libdir/btree_gist', 'gbt_intv_same';
|
---|
876 |
|
---|
877 |
|
---|
878 | --
|
---|
879 | -- Name: gbt_intv_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
880 | --
|
---|
881 |
|
---|
882 | CREATE FUNCTION gbt_intv_union(bytea, internal) RETURNS gbtreekey32
|
---|
883 | LANGUAGE c IMMUTABLE STRICT
|
---|
884 | AS '$libdir/btree_gist', 'gbt_intv_union';
|
---|
885 |
|
---|
886 |
|
---|
887 | --
|
---|
888 | -- Name: gbt_macad_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
889 | --
|
---|
890 |
|
---|
891 | CREATE FUNCTION gbt_macad_compress(internal) RETURNS internal
|
---|
892 | LANGUAGE c IMMUTABLE STRICT
|
---|
893 | AS '$libdir/btree_gist', 'gbt_macad_compress';
|
---|
894 |
|
---|
895 |
|
---|
896 | --
|
---|
897 | -- Name: gbt_macad_consistent(internal, macaddr, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
898 | --
|
---|
899 |
|
---|
900 | CREATE FUNCTION gbt_macad_consistent(internal, macaddr, smallint, oid, internal) RETURNS boolean
|
---|
901 | LANGUAGE c IMMUTABLE STRICT
|
---|
902 | AS '$libdir/btree_gist', 'gbt_macad_consistent';
|
---|
903 |
|
---|
904 |
|
---|
905 | --
|
---|
906 | -- Name: gbt_macad_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
907 | --
|
---|
908 |
|
---|
909 | CREATE FUNCTION gbt_macad_penalty(internal, internal, internal) RETURNS internal
|
---|
910 | LANGUAGE c IMMUTABLE STRICT
|
---|
911 | AS '$libdir/btree_gist', 'gbt_macad_penalty';
|
---|
912 |
|
---|
913 |
|
---|
914 | --
|
---|
915 | -- Name: gbt_macad_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
916 | --
|
---|
917 |
|
---|
918 | CREATE FUNCTION gbt_macad_picksplit(internal, internal) RETURNS internal
|
---|
919 | LANGUAGE c IMMUTABLE STRICT
|
---|
920 | AS '$libdir/btree_gist', 'gbt_macad_picksplit';
|
---|
921 |
|
---|
922 |
|
---|
923 | --
|
---|
924 | -- Name: gbt_macad_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
925 | --
|
---|
926 |
|
---|
927 | CREATE FUNCTION gbt_macad_same(internal, internal, internal) RETURNS internal
|
---|
928 | LANGUAGE c IMMUTABLE STRICT
|
---|
929 | AS '$libdir/btree_gist', 'gbt_macad_same';
|
---|
930 |
|
---|
931 |
|
---|
932 | --
|
---|
933 | -- Name: gbt_macad_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
934 | --
|
---|
935 |
|
---|
936 | CREATE FUNCTION gbt_macad_union(bytea, internal) RETURNS gbtreekey16
|
---|
937 | LANGUAGE c IMMUTABLE STRICT
|
---|
938 | AS '$libdir/btree_gist', 'gbt_macad_union';
|
---|
939 |
|
---|
940 |
|
---|
941 | --
|
---|
942 | -- Name: gbt_numeric_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
943 | --
|
---|
944 |
|
---|
945 | CREATE FUNCTION gbt_numeric_compress(internal) RETURNS internal
|
---|
946 | LANGUAGE c IMMUTABLE STRICT
|
---|
947 | AS '$libdir/btree_gist', 'gbt_numeric_compress';
|
---|
948 |
|
---|
949 |
|
---|
950 | --
|
---|
951 | -- Name: gbt_numeric_consistent(internal, numeric, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
952 | --
|
---|
953 |
|
---|
954 | CREATE FUNCTION gbt_numeric_consistent(internal, numeric, smallint, oid, internal) RETURNS boolean
|
---|
955 | LANGUAGE c IMMUTABLE STRICT
|
---|
956 | AS '$libdir/btree_gist', 'gbt_numeric_consistent';
|
---|
957 |
|
---|
958 |
|
---|
959 | --
|
---|
960 | -- Name: gbt_numeric_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
961 | --
|
---|
962 |
|
---|
963 | CREATE FUNCTION gbt_numeric_penalty(internal, internal, internal) RETURNS internal
|
---|
964 | LANGUAGE c IMMUTABLE STRICT
|
---|
965 | AS '$libdir/btree_gist', 'gbt_numeric_penalty';
|
---|
966 |
|
---|
967 |
|
---|
968 | --
|
---|
969 | -- Name: gbt_numeric_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
970 | --
|
---|
971 |
|
---|
972 | CREATE FUNCTION gbt_numeric_picksplit(internal, internal) RETURNS internal
|
---|
973 | LANGUAGE c IMMUTABLE STRICT
|
---|
974 | AS '$libdir/btree_gist', 'gbt_numeric_picksplit';
|
---|
975 |
|
---|
976 |
|
---|
977 | --
|
---|
978 | -- Name: gbt_numeric_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
979 | --
|
---|
980 |
|
---|
981 | CREATE FUNCTION gbt_numeric_same(internal, internal, internal) RETURNS internal
|
---|
982 | LANGUAGE c IMMUTABLE STRICT
|
---|
983 | AS '$libdir/btree_gist', 'gbt_numeric_same';
|
---|
984 |
|
---|
985 |
|
---|
986 | --
|
---|
987 | -- Name: gbt_numeric_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
988 | --
|
---|
989 |
|
---|
990 | CREATE FUNCTION gbt_numeric_union(bytea, internal) RETURNS gbtreekey_var
|
---|
991 | LANGUAGE c IMMUTABLE STRICT
|
---|
992 | AS '$libdir/btree_gist', 'gbt_numeric_union';
|
---|
993 |
|
---|
994 |
|
---|
995 | --
|
---|
996 | -- Name: gbt_oid_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
997 | --
|
---|
998 |
|
---|
999 | CREATE FUNCTION gbt_oid_compress(internal) RETURNS internal
|
---|
1000 | LANGUAGE c IMMUTABLE STRICT
|
---|
1001 | AS '$libdir/btree_gist', 'gbt_oid_compress';
|
---|
1002 |
|
---|
1003 |
|
---|
1004 | --
|
---|
1005 | -- Name: gbt_oid_consistent(internal, oid, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1006 | --
|
---|
1007 |
|
---|
1008 | CREATE FUNCTION gbt_oid_consistent(internal, oid, smallint, oid, internal) RETURNS boolean
|
---|
1009 | LANGUAGE c IMMUTABLE STRICT
|
---|
1010 | AS '$libdir/btree_gist', 'gbt_oid_consistent';
|
---|
1011 |
|
---|
1012 |
|
---|
1013 | --
|
---|
1014 | -- Name: gbt_oid_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1015 | --
|
---|
1016 |
|
---|
1017 | CREATE FUNCTION gbt_oid_penalty(internal, internal, internal) RETURNS internal
|
---|
1018 | LANGUAGE c IMMUTABLE STRICT
|
---|
1019 | AS '$libdir/btree_gist', 'gbt_oid_penalty';
|
---|
1020 |
|
---|
1021 |
|
---|
1022 | --
|
---|
1023 | -- Name: gbt_oid_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1024 | --
|
---|
1025 |
|
---|
1026 | CREATE FUNCTION gbt_oid_picksplit(internal, internal) RETURNS internal
|
---|
1027 | LANGUAGE c IMMUTABLE STRICT
|
---|
1028 | AS '$libdir/btree_gist', 'gbt_oid_picksplit';
|
---|
1029 |
|
---|
1030 |
|
---|
1031 | --
|
---|
1032 | -- Name: gbt_oid_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1033 | --
|
---|
1034 |
|
---|
1035 | CREATE FUNCTION gbt_oid_same(internal, internal, internal) RETURNS internal
|
---|
1036 | LANGUAGE c IMMUTABLE STRICT
|
---|
1037 | AS '$libdir/btree_gist', 'gbt_oid_same';
|
---|
1038 |
|
---|
1039 |
|
---|
1040 | --
|
---|
1041 | -- Name: gbt_oid_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1042 | --
|
---|
1043 |
|
---|
1044 | CREATE FUNCTION gbt_oid_union(bytea, internal) RETURNS gbtreekey8
|
---|
1045 | LANGUAGE c IMMUTABLE STRICT
|
---|
1046 | AS '$libdir/btree_gist', 'gbt_oid_union';
|
---|
1047 |
|
---|
1048 |
|
---|
1049 | --
|
---|
1050 | -- Name: gbt_text_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1051 | --
|
---|
1052 |
|
---|
1053 | CREATE FUNCTION gbt_text_compress(internal) RETURNS internal
|
---|
1054 | LANGUAGE c IMMUTABLE STRICT
|
---|
1055 | AS '$libdir/btree_gist', 'gbt_text_compress';
|
---|
1056 |
|
---|
1057 |
|
---|
1058 | --
|
---|
1059 | -- Name: gbt_text_consistent(internal, text, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1060 | --
|
---|
1061 |
|
---|
1062 | CREATE FUNCTION gbt_text_consistent(internal, text, smallint, oid, internal) RETURNS boolean
|
---|
1063 | LANGUAGE c IMMUTABLE STRICT
|
---|
1064 | AS '$libdir/btree_gist', 'gbt_text_consistent';
|
---|
1065 |
|
---|
1066 |
|
---|
1067 | --
|
---|
1068 | -- Name: gbt_text_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1069 | --
|
---|
1070 |
|
---|
1071 | CREATE FUNCTION gbt_text_penalty(internal, internal, internal) RETURNS internal
|
---|
1072 | LANGUAGE c IMMUTABLE STRICT
|
---|
1073 | AS '$libdir/btree_gist', 'gbt_text_penalty';
|
---|
1074 |
|
---|
1075 |
|
---|
1076 | --
|
---|
1077 | -- Name: gbt_text_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1078 | --
|
---|
1079 |
|
---|
1080 | CREATE FUNCTION gbt_text_picksplit(internal, internal) RETURNS internal
|
---|
1081 | LANGUAGE c IMMUTABLE STRICT
|
---|
1082 | AS '$libdir/btree_gist', 'gbt_text_picksplit';
|
---|
1083 |
|
---|
1084 |
|
---|
1085 | --
|
---|
1086 | -- Name: gbt_text_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1087 | --
|
---|
1088 |
|
---|
1089 | CREATE FUNCTION gbt_text_same(internal, internal, internal) RETURNS internal
|
---|
1090 | LANGUAGE c IMMUTABLE STRICT
|
---|
1091 | AS '$libdir/btree_gist', 'gbt_text_same';
|
---|
1092 |
|
---|
1093 |
|
---|
1094 | --
|
---|
1095 | -- Name: gbt_text_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1096 | --
|
---|
1097 |
|
---|
1098 | CREATE FUNCTION gbt_text_union(bytea, internal) RETURNS gbtreekey_var
|
---|
1099 | LANGUAGE c IMMUTABLE STRICT
|
---|
1100 | AS '$libdir/btree_gist', 'gbt_text_union';
|
---|
1101 |
|
---|
1102 |
|
---|
1103 | --
|
---|
1104 | -- Name: gbt_time_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1105 | --
|
---|
1106 |
|
---|
1107 | CREATE FUNCTION gbt_time_compress(internal) RETURNS internal
|
---|
1108 | LANGUAGE c IMMUTABLE STRICT
|
---|
1109 | AS '$libdir/btree_gist', 'gbt_time_compress';
|
---|
1110 |
|
---|
1111 |
|
---|
1112 | --
|
---|
1113 | -- Name: gbt_time_consistent(internal, time without time zone, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1114 | --
|
---|
1115 |
|
---|
1116 | CREATE FUNCTION gbt_time_consistent(internal, time without time zone, smallint, oid, internal) RETURNS boolean
|
---|
1117 | LANGUAGE c IMMUTABLE STRICT
|
---|
1118 | AS '$libdir/btree_gist', 'gbt_time_consistent';
|
---|
1119 |
|
---|
1120 |
|
---|
1121 | --
|
---|
1122 | -- Name: gbt_time_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1123 | --
|
---|
1124 |
|
---|
1125 | CREATE FUNCTION gbt_time_penalty(internal, internal, internal) RETURNS internal
|
---|
1126 | LANGUAGE c IMMUTABLE STRICT
|
---|
1127 | AS '$libdir/btree_gist', 'gbt_time_penalty';
|
---|
1128 |
|
---|
1129 |
|
---|
1130 | --
|
---|
1131 | -- Name: gbt_time_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1132 | --
|
---|
1133 |
|
---|
1134 | CREATE FUNCTION gbt_time_picksplit(internal, internal) RETURNS internal
|
---|
1135 | LANGUAGE c IMMUTABLE STRICT
|
---|
1136 | AS '$libdir/btree_gist', 'gbt_time_picksplit';
|
---|
1137 |
|
---|
1138 |
|
---|
1139 | --
|
---|
1140 | -- Name: gbt_time_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1141 | --
|
---|
1142 |
|
---|
1143 | CREATE FUNCTION gbt_time_same(internal, internal, internal) RETURNS internal
|
---|
1144 | LANGUAGE c IMMUTABLE STRICT
|
---|
1145 | AS '$libdir/btree_gist', 'gbt_time_same';
|
---|
1146 |
|
---|
1147 |
|
---|
1148 | --
|
---|
1149 | -- Name: gbt_time_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1150 | --
|
---|
1151 |
|
---|
1152 | CREATE FUNCTION gbt_time_union(bytea, internal) RETURNS gbtreekey16
|
---|
1153 | LANGUAGE c IMMUTABLE STRICT
|
---|
1154 | AS '$libdir/btree_gist', 'gbt_time_union';
|
---|
1155 |
|
---|
1156 |
|
---|
1157 | --
|
---|
1158 | -- Name: gbt_timetz_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1159 | --
|
---|
1160 |
|
---|
1161 | CREATE FUNCTION gbt_timetz_compress(internal) RETURNS internal
|
---|
1162 | LANGUAGE c IMMUTABLE STRICT
|
---|
1163 | AS '$libdir/btree_gist', 'gbt_timetz_compress';
|
---|
1164 |
|
---|
1165 |
|
---|
1166 | --
|
---|
1167 | -- Name: gbt_timetz_consistent(internal, time with time zone, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1168 | --
|
---|
1169 |
|
---|
1170 | CREATE FUNCTION gbt_timetz_consistent(internal, time with time zone, smallint, oid, internal) RETURNS boolean
|
---|
1171 | LANGUAGE c IMMUTABLE STRICT
|
---|
1172 | AS '$libdir/btree_gist', 'gbt_timetz_consistent';
|
---|
1173 |
|
---|
1174 |
|
---|
1175 | --
|
---|
1176 | -- Name: gbt_ts_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1177 | --
|
---|
1178 |
|
---|
1179 | CREATE FUNCTION gbt_ts_compress(internal) RETURNS internal
|
---|
1180 | LANGUAGE c IMMUTABLE STRICT
|
---|
1181 | AS '$libdir/btree_gist', 'gbt_ts_compress';
|
---|
1182 |
|
---|
1183 |
|
---|
1184 | --
|
---|
1185 | -- Name: gbt_ts_consistent(internal, timestamp without time zone, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1186 | --
|
---|
1187 |
|
---|
1188 | CREATE FUNCTION gbt_ts_consistent(internal, timestamp without time zone, smallint, oid, internal) RETURNS boolean
|
---|
1189 | LANGUAGE c IMMUTABLE STRICT
|
---|
1190 | AS '$libdir/btree_gist', 'gbt_ts_consistent';
|
---|
1191 |
|
---|
1192 |
|
---|
1193 | --
|
---|
1194 | -- Name: gbt_ts_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1195 | --
|
---|
1196 |
|
---|
1197 | CREATE FUNCTION gbt_ts_penalty(internal, internal, internal) RETURNS internal
|
---|
1198 | LANGUAGE c IMMUTABLE STRICT
|
---|
1199 | AS '$libdir/btree_gist', 'gbt_ts_penalty';
|
---|
1200 |
|
---|
1201 |
|
---|
1202 | --
|
---|
1203 | -- Name: gbt_ts_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1204 | --
|
---|
1205 |
|
---|
1206 | CREATE FUNCTION gbt_ts_picksplit(internal, internal) RETURNS internal
|
---|
1207 | LANGUAGE c IMMUTABLE STRICT
|
---|
1208 | AS '$libdir/btree_gist', 'gbt_ts_picksplit';
|
---|
1209 |
|
---|
1210 |
|
---|
1211 | --
|
---|
1212 | -- Name: gbt_ts_same(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1213 | --
|
---|
1214 |
|
---|
1215 | CREATE FUNCTION gbt_ts_same(internal, internal, internal) RETURNS internal
|
---|
1216 | LANGUAGE c IMMUTABLE STRICT
|
---|
1217 | AS '$libdir/btree_gist', 'gbt_ts_same';
|
---|
1218 |
|
---|
1219 |
|
---|
1220 | --
|
---|
1221 | -- Name: gbt_ts_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1222 | --
|
---|
1223 |
|
---|
1224 | CREATE FUNCTION gbt_ts_union(bytea, internal) RETURNS gbtreekey16
|
---|
1225 | LANGUAGE c IMMUTABLE STRICT
|
---|
1226 | AS '$libdir/btree_gist', 'gbt_ts_union';
|
---|
1227 |
|
---|
1228 |
|
---|
1229 | --
|
---|
1230 | -- Name: gbt_tstz_compress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1231 | --
|
---|
1232 |
|
---|
1233 | CREATE FUNCTION gbt_tstz_compress(internal) RETURNS internal
|
---|
1234 | LANGUAGE c IMMUTABLE STRICT
|
---|
1235 | AS '$libdir/btree_gist', 'gbt_tstz_compress';
|
---|
1236 |
|
---|
1237 |
|
---|
1238 | --
|
---|
1239 | -- Name: gbt_tstz_consistent(internal, timestamp with time zone, smallint, oid, internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1240 | --
|
---|
1241 |
|
---|
1242 | CREATE FUNCTION gbt_tstz_consistent(internal, timestamp with time zone, smallint, oid, internal) RETURNS boolean
|
---|
1243 | LANGUAGE c IMMUTABLE STRICT
|
---|
1244 | AS '$libdir/btree_gist', 'gbt_tstz_consistent';
|
---|
1245 |
|
---|
1246 |
|
---|
1247 | --
|
---|
1248 | -- Name: gbt_var_decompress(internal); Type: FUNCTION; Schema: public; Owner: -
|
---|
1249 | --
|
---|
1250 |
|
---|
1251 | CREATE FUNCTION gbt_var_decompress(internal) RETURNS internal
|
---|
1252 | LANGUAGE c IMMUTABLE STRICT
|
---|
1253 | AS '$libdir/btree_gist', 'gbt_var_decompress';
|
---|
1254 |
|
---|
1255 |
|
---|
1256 | --
|
---|
1257 | -- Name: maptile_for_point(bigint, bigint, integer); Type: FUNCTION; Schema: public; Owner: -
|
---|
1258 | --
|
---|
1259 |
|
---|
1260 | CREATE FUNCTION maptile_for_point(bigint, bigint, integer) RETURNS integer
|
---|
1261 | LANGUAGE c STRICT
|
---|
1262 | AS '/path/to/libpgosm.so', 'maptile_for_point';
|
---|
1263 |
|
---|
1264 |
|
---|
1265 | --
|
---|
1266 | -- Name: tile_for_point(integer, integer); Type: FUNCTION; Schema: public; Owner: -
|
---|
1267 | --
|
---|
1268 |
|
---|
1269 | CREATE FUNCTION tile_for_point(integer, integer) RETURNS bigint
|
---|
1270 | LANGUAGE c STRICT
|
---|
1271 | AS '/path/to/libpgosm.so', 'tile_for_point';
|
---|
1272 |
|
---|
1273 |
|
---|
1274 | --
|
---|
1275 | -- Name: xid_to_int4(xid); Type: FUNCTION; Schema: public; Owner: -
|
---|
1276 | --
|
---|
1277 |
|
---|
1278 | CREATE FUNCTION xid_to_int4(xid) RETURNS integer
|
---|
1279 | LANGUAGE c IMMUTABLE STRICT
|
---|
1280 | AS '/path/to/libpgosm.so', 'xid_to_int4';
|
---|
1281 |
|
---|
1282 |
|
---|
1283 | --
|
---|
1284 | -- Name: gist_bit_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1285 | --
|
---|
1286 |
|
---|
1287 | CREATE OPERATOR FAMILY gist_bit_ops USING gist;
|
---|
1288 |
|
---|
1289 |
|
---|
1290 | --
|
---|
1291 | -- Name: gist_bit_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1292 | --
|
---|
1293 |
|
---|
1294 | CREATE OPERATOR CLASS gist_bit_ops
|
---|
1295 | DEFAULT FOR TYPE bit USING gist AS
|
---|
1296 | STORAGE gbtreekey_var ,
|
---|
1297 | OPERATOR 1 <(bit,bit) ,
|
---|
1298 | OPERATOR 2 <=(bit,bit) ,
|
---|
1299 | OPERATOR 3 =(bit,bit) ,
|
---|
1300 | OPERATOR 4 >=(bit,bit) ,
|
---|
1301 | OPERATOR 5 >(bit,bit) ,
|
---|
1302 | FUNCTION 1 gbt_bit_consistent(internal,bit,smallint,oid,internal) ,
|
---|
1303 | FUNCTION 2 gbt_bit_union(bytea,internal) ,
|
---|
1304 | FUNCTION 3 gbt_bit_compress(internal) ,
|
---|
1305 | FUNCTION 4 gbt_var_decompress(internal) ,
|
---|
1306 | FUNCTION 5 gbt_bit_penalty(internal,internal,internal) ,
|
---|
1307 | FUNCTION 6 gbt_bit_picksplit(internal,internal) ,
|
---|
1308 | FUNCTION 7 gbt_bit_same(internal,internal,internal);
|
---|
1309 |
|
---|
1310 |
|
---|
1311 | --
|
---|
1312 | -- Name: gist_bpchar_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1313 | --
|
---|
1314 |
|
---|
1315 | CREATE OPERATOR FAMILY gist_bpchar_ops USING gist;
|
---|
1316 |
|
---|
1317 |
|
---|
1318 | --
|
---|
1319 | -- Name: gist_bpchar_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1320 | --
|
---|
1321 |
|
---|
1322 | CREATE OPERATOR CLASS gist_bpchar_ops
|
---|
1323 | DEFAULT FOR TYPE character USING gist AS
|
---|
1324 | STORAGE gbtreekey_var ,
|
---|
1325 | OPERATOR 1 <(character,character) ,
|
---|
1326 | OPERATOR 2 <=(character,character) ,
|
---|
1327 | OPERATOR 3 =(character,character) ,
|
---|
1328 | OPERATOR 4 >=(character,character) ,
|
---|
1329 | OPERATOR 5 >(character,character) ,
|
---|
1330 | FUNCTION 1 gbt_bpchar_consistent(internal,character,smallint,oid,internal) ,
|
---|
1331 | FUNCTION 2 gbt_text_union(bytea,internal) ,
|
---|
1332 | FUNCTION 3 gbt_bpchar_compress(internal) ,
|
---|
1333 | FUNCTION 4 gbt_var_decompress(internal) ,
|
---|
1334 | FUNCTION 5 gbt_text_penalty(internal,internal,internal) ,
|
---|
1335 | FUNCTION 6 gbt_text_picksplit(internal,internal) ,
|
---|
1336 | FUNCTION 7 gbt_text_same(internal,internal,internal);
|
---|
1337 |
|
---|
1338 |
|
---|
1339 | --
|
---|
1340 | -- Name: gist_bytea_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1341 | --
|
---|
1342 |
|
---|
1343 | CREATE OPERATOR FAMILY gist_bytea_ops USING gist;
|
---|
1344 |
|
---|
1345 |
|
---|
1346 | --
|
---|
1347 | -- Name: gist_bytea_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1348 | --
|
---|
1349 |
|
---|
1350 | CREATE OPERATOR CLASS gist_bytea_ops
|
---|
1351 | DEFAULT FOR TYPE bytea USING gist AS
|
---|
1352 | STORAGE gbtreekey_var ,
|
---|
1353 | OPERATOR 1 <(bytea,bytea) ,
|
---|
1354 | OPERATOR 2 <=(bytea,bytea) ,
|
---|
1355 | OPERATOR 3 =(bytea,bytea) ,
|
---|
1356 | OPERATOR 4 >=(bytea,bytea) ,
|
---|
1357 | OPERATOR 5 >(bytea,bytea) ,
|
---|
1358 | FUNCTION 1 gbt_bytea_consistent(internal,bytea,smallint,oid,internal) ,
|
---|
1359 | FUNCTION 2 gbt_bytea_union(bytea,internal) ,
|
---|
1360 | FUNCTION 3 gbt_bytea_compress(internal) ,
|
---|
1361 | FUNCTION 4 gbt_var_decompress(internal) ,
|
---|
1362 | FUNCTION 5 gbt_bytea_penalty(internal,internal,internal) ,
|
---|
1363 | FUNCTION 6 gbt_bytea_picksplit(internal,internal) ,
|
---|
1364 | FUNCTION 7 gbt_bytea_same(internal,internal,internal);
|
---|
1365 |
|
---|
1366 |
|
---|
1367 | --
|
---|
1368 | -- Name: gist_cash_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1369 | --
|
---|
1370 |
|
---|
1371 | CREATE OPERATOR FAMILY gist_cash_ops USING gist;
|
---|
1372 |
|
---|
1373 |
|
---|
1374 | --
|
---|
1375 | -- Name: gist_cash_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1376 | --
|
---|
1377 |
|
---|
1378 | CREATE OPERATOR CLASS gist_cash_ops
|
---|
1379 | DEFAULT FOR TYPE money USING gist AS
|
---|
1380 | STORAGE gbtreekey16 ,
|
---|
1381 | OPERATOR 1 <(money,money) ,
|
---|
1382 | OPERATOR 2 <=(money,money) ,
|
---|
1383 | OPERATOR 3 =(money,money) ,
|
---|
1384 | OPERATOR 4 >=(money,money) ,
|
---|
1385 | OPERATOR 5 >(money,money) ,
|
---|
1386 | FUNCTION 1 gbt_cash_consistent(internal,money,smallint,oid,internal) ,
|
---|
1387 | FUNCTION 2 gbt_cash_union(bytea,internal) ,
|
---|
1388 | FUNCTION 3 gbt_cash_compress(internal) ,
|
---|
1389 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1390 | FUNCTION 5 gbt_cash_penalty(internal,internal,internal) ,
|
---|
1391 | FUNCTION 6 gbt_cash_picksplit(internal,internal) ,
|
---|
1392 | FUNCTION 7 gbt_cash_same(internal,internal,internal);
|
---|
1393 |
|
---|
1394 |
|
---|
1395 | --
|
---|
1396 | -- Name: gist_cidr_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1397 | --
|
---|
1398 |
|
---|
1399 | CREATE OPERATOR FAMILY gist_cidr_ops USING gist;
|
---|
1400 |
|
---|
1401 |
|
---|
1402 | --
|
---|
1403 | -- Name: gist_cidr_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1404 | --
|
---|
1405 |
|
---|
1406 | CREATE OPERATOR CLASS gist_cidr_ops
|
---|
1407 | DEFAULT FOR TYPE cidr USING gist AS
|
---|
1408 | STORAGE gbtreekey16 ,
|
---|
1409 | OPERATOR 1 <(inet,inet) ,
|
---|
1410 | OPERATOR 2 <=(inet,inet) ,
|
---|
1411 | OPERATOR 3 =(inet,inet) ,
|
---|
1412 | OPERATOR 4 >=(inet,inet) ,
|
---|
1413 | OPERATOR 5 >(inet,inet) ,
|
---|
1414 | FUNCTION 1 gbt_inet_consistent(internal,inet,smallint,oid,internal) ,
|
---|
1415 | FUNCTION 2 gbt_inet_union(bytea,internal) ,
|
---|
1416 | FUNCTION 3 gbt_inet_compress(internal) ,
|
---|
1417 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1418 | FUNCTION 5 gbt_inet_penalty(internal,internal,internal) ,
|
---|
1419 | FUNCTION 6 gbt_inet_picksplit(internal,internal) ,
|
---|
1420 | FUNCTION 7 gbt_inet_same(internal,internal,internal);
|
---|
1421 |
|
---|
1422 |
|
---|
1423 | --
|
---|
1424 | -- Name: gist_date_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1425 | --
|
---|
1426 |
|
---|
1427 | CREATE OPERATOR FAMILY gist_date_ops USING gist;
|
---|
1428 |
|
---|
1429 |
|
---|
1430 | --
|
---|
1431 | -- Name: gist_date_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1432 | --
|
---|
1433 |
|
---|
1434 | CREATE OPERATOR CLASS gist_date_ops
|
---|
1435 | DEFAULT FOR TYPE date USING gist AS
|
---|
1436 | STORAGE gbtreekey8 ,
|
---|
1437 | OPERATOR 1 <(date,date) ,
|
---|
1438 | OPERATOR 2 <=(date,date) ,
|
---|
1439 | OPERATOR 3 =(date,date) ,
|
---|
1440 | OPERATOR 4 >=(date,date) ,
|
---|
1441 | OPERATOR 5 >(date,date) ,
|
---|
1442 | FUNCTION 1 gbt_date_consistent(internal,date,smallint,oid,internal) ,
|
---|
1443 | FUNCTION 2 gbt_date_union(bytea,internal) ,
|
---|
1444 | FUNCTION 3 gbt_date_compress(internal) ,
|
---|
1445 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1446 | FUNCTION 5 gbt_date_penalty(internal,internal,internal) ,
|
---|
1447 | FUNCTION 6 gbt_date_picksplit(internal,internal) ,
|
---|
1448 | FUNCTION 7 gbt_date_same(internal,internal,internal);
|
---|
1449 |
|
---|
1450 |
|
---|
1451 | --
|
---|
1452 | -- Name: gist_float4_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1453 | --
|
---|
1454 |
|
---|
1455 | CREATE OPERATOR FAMILY gist_float4_ops USING gist;
|
---|
1456 |
|
---|
1457 |
|
---|
1458 | --
|
---|
1459 | -- Name: gist_float4_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1460 | --
|
---|
1461 |
|
---|
1462 | CREATE OPERATOR CLASS gist_float4_ops
|
---|
1463 | DEFAULT FOR TYPE real USING gist AS
|
---|
1464 | STORAGE gbtreekey8 ,
|
---|
1465 | OPERATOR 1 <(real,real) ,
|
---|
1466 | OPERATOR 2 <=(real,real) ,
|
---|
1467 | OPERATOR 3 =(real,real) ,
|
---|
1468 | OPERATOR 4 >=(real,real) ,
|
---|
1469 | OPERATOR 5 >(real,real) ,
|
---|
1470 | FUNCTION 1 gbt_float4_consistent(internal,real,smallint,oid,internal) ,
|
---|
1471 | FUNCTION 2 gbt_float4_union(bytea,internal) ,
|
---|
1472 | FUNCTION 3 gbt_float4_compress(internal) ,
|
---|
1473 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1474 | FUNCTION 5 gbt_float4_penalty(internal,internal,internal) ,
|
---|
1475 | FUNCTION 6 gbt_float4_picksplit(internal,internal) ,
|
---|
1476 | FUNCTION 7 gbt_float4_same(internal,internal,internal);
|
---|
1477 |
|
---|
1478 |
|
---|
1479 | --
|
---|
1480 | -- Name: gist_float8_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1481 | --
|
---|
1482 |
|
---|
1483 | CREATE OPERATOR FAMILY gist_float8_ops USING gist;
|
---|
1484 |
|
---|
1485 |
|
---|
1486 | --
|
---|
1487 | -- Name: gist_float8_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1488 | --
|
---|
1489 |
|
---|
1490 | CREATE OPERATOR CLASS gist_float8_ops
|
---|
1491 | DEFAULT FOR TYPE double precision USING gist AS
|
---|
1492 | STORAGE gbtreekey16 ,
|
---|
1493 | OPERATOR 1 <(double precision,double precision) ,
|
---|
1494 | OPERATOR 2 <=(double precision,double precision) ,
|
---|
1495 | OPERATOR 3 =(double precision,double precision) ,
|
---|
1496 | OPERATOR 4 >=(double precision,double precision) ,
|
---|
1497 | OPERATOR 5 >(double precision,double precision) ,
|
---|
1498 | FUNCTION 1 gbt_float8_consistent(internal,double precision,smallint,oid,internal) ,
|
---|
1499 | FUNCTION 2 gbt_float8_union(bytea,internal) ,
|
---|
1500 | FUNCTION 3 gbt_float8_compress(internal) ,
|
---|
1501 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1502 | FUNCTION 5 gbt_float8_penalty(internal,internal,internal) ,
|
---|
1503 | FUNCTION 6 gbt_float8_picksplit(internal,internal) ,
|
---|
1504 | FUNCTION 7 gbt_float8_same(internal,internal,internal);
|
---|
1505 |
|
---|
1506 |
|
---|
1507 | --
|
---|
1508 | -- Name: gist_inet_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1509 | --
|
---|
1510 |
|
---|
1511 | CREATE OPERATOR FAMILY gist_inet_ops USING gist;
|
---|
1512 |
|
---|
1513 |
|
---|
1514 | --
|
---|
1515 | -- Name: gist_inet_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1516 | --
|
---|
1517 |
|
---|
1518 | CREATE OPERATOR CLASS gist_inet_ops
|
---|
1519 | DEFAULT FOR TYPE inet USING gist AS
|
---|
1520 | STORAGE gbtreekey16 ,
|
---|
1521 | OPERATOR 1 <(inet,inet) ,
|
---|
1522 | OPERATOR 2 <=(inet,inet) ,
|
---|
1523 | OPERATOR 3 =(inet,inet) ,
|
---|
1524 | OPERATOR 4 >=(inet,inet) ,
|
---|
1525 | OPERATOR 5 >(inet,inet) ,
|
---|
1526 | FUNCTION 1 gbt_inet_consistent(internal,inet,smallint,oid,internal) ,
|
---|
1527 | FUNCTION 2 gbt_inet_union(bytea,internal) ,
|
---|
1528 | FUNCTION 3 gbt_inet_compress(internal) ,
|
---|
1529 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1530 | FUNCTION 5 gbt_inet_penalty(internal,internal,internal) ,
|
---|
1531 | FUNCTION 6 gbt_inet_picksplit(internal,internal) ,
|
---|
1532 | FUNCTION 7 gbt_inet_same(internal,internal,internal);
|
---|
1533 |
|
---|
1534 |
|
---|
1535 | --
|
---|
1536 | -- Name: gist_int2_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1537 | --
|
---|
1538 |
|
---|
1539 | CREATE OPERATOR FAMILY gist_int2_ops USING gist;
|
---|
1540 |
|
---|
1541 |
|
---|
1542 | --
|
---|
1543 | -- Name: gist_int2_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1544 | --
|
---|
1545 |
|
---|
1546 | CREATE OPERATOR CLASS gist_int2_ops
|
---|
1547 | DEFAULT FOR TYPE smallint USING gist AS
|
---|
1548 | STORAGE gbtreekey4 ,
|
---|
1549 | OPERATOR 1 <(smallint,smallint) ,
|
---|
1550 | OPERATOR 2 <=(smallint,smallint) ,
|
---|
1551 | OPERATOR 3 =(smallint,smallint) ,
|
---|
1552 | OPERATOR 4 >=(smallint,smallint) ,
|
---|
1553 | OPERATOR 5 >(smallint,smallint) ,
|
---|
1554 | FUNCTION 1 gbt_int2_consistent(internal,smallint,smallint,oid,internal) ,
|
---|
1555 | FUNCTION 2 gbt_int2_union(bytea,internal) ,
|
---|
1556 | FUNCTION 3 gbt_int2_compress(internal) ,
|
---|
1557 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1558 | FUNCTION 5 gbt_int2_penalty(internal,internal,internal) ,
|
---|
1559 | FUNCTION 6 gbt_int2_picksplit(internal,internal) ,
|
---|
1560 | FUNCTION 7 gbt_int2_same(internal,internal,internal);
|
---|
1561 |
|
---|
1562 |
|
---|
1563 | --
|
---|
1564 | -- Name: gist_int4_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1565 | --
|
---|
1566 |
|
---|
1567 | CREATE OPERATOR FAMILY gist_int4_ops USING gist;
|
---|
1568 |
|
---|
1569 |
|
---|
1570 | --
|
---|
1571 | -- Name: gist_int4_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1572 | --
|
---|
1573 |
|
---|
1574 | CREATE OPERATOR CLASS gist_int4_ops
|
---|
1575 | DEFAULT FOR TYPE integer USING gist AS
|
---|
1576 | STORAGE gbtreekey8 ,
|
---|
1577 | OPERATOR 1 <(integer,integer) ,
|
---|
1578 | OPERATOR 2 <=(integer,integer) ,
|
---|
1579 | OPERATOR 3 =(integer,integer) ,
|
---|
1580 | OPERATOR 4 >=(integer,integer) ,
|
---|
1581 | OPERATOR 5 >(integer,integer) ,
|
---|
1582 | FUNCTION 1 gbt_int4_consistent(internal,integer,smallint,oid,internal) ,
|
---|
1583 | FUNCTION 2 gbt_int4_union(bytea,internal) ,
|
---|
1584 | FUNCTION 3 gbt_int4_compress(internal) ,
|
---|
1585 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1586 | FUNCTION 5 gbt_int4_penalty(internal,internal,internal) ,
|
---|
1587 | FUNCTION 6 gbt_int4_picksplit(internal,internal) ,
|
---|
1588 | FUNCTION 7 gbt_int4_same(internal,internal,internal);
|
---|
1589 |
|
---|
1590 |
|
---|
1591 | --
|
---|
1592 | -- Name: gist_int8_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1593 | --
|
---|
1594 |
|
---|
1595 | CREATE OPERATOR FAMILY gist_int8_ops USING gist;
|
---|
1596 |
|
---|
1597 |
|
---|
1598 | --
|
---|
1599 | -- Name: gist_int8_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1600 | --
|
---|
1601 |
|
---|
1602 | CREATE OPERATOR CLASS gist_int8_ops
|
---|
1603 | DEFAULT FOR TYPE bigint USING gist AS
|
---|
1604 | STORAGE gbtreekey16 ,
|
---|
1605 | OPERATOR 1 <(bigint,bigint) ,
|
---|
1606 | OPERATOR 2 <=(bigint,bigint) ,
|
---|
1607 | OPERATOR 3 =(bigint,bigint) ,
|
---|
1608 | OPERATOR 4 >=(bigint,bigint) ,
|
---|
1609 | OPERATOR 5 >(bigint,bigint) ,
|
---|
1610 | FUNCTION 1 gbt_int8_consistent(internal,bigint,smallint,oid,internal) ,
|
---|
1611 | FUNCTION 2 gbt_int8_union(bytea,internal) ,
|
---|
1612 | FUNCTION 3 gbt_int8_compress(internal) ,
|
---|
1613 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1614 | FUNCTION 5 gbt_int8_penalty(internal,internal,internal) ,
|
---|
1615 | FUNCTION 6 gbt_int8_picksplit(internal,internal) ,
|
---|
1616 | FUNCTION 7 gbt_int8_same(internal,internal,internal);
|
---|
1617 |
|
---|
1618 |
|
---|
1619 | --
|
---|
1620 | -- Name: gist_interval_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1621 | --
|
---|
1622 |
|
---|
1623 | CREATE OPERATOR FAMILY gist_interval_ops USING gist;
|
---|
1624 |
|
---|
1625 |
|
---|
1626 | --
|
---|
1627 | -- Name: gist_interval_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1628 | --
|
---|
1629 |
|
---|
1630 | CREATE OPERATOR CLASS gist_interval_ops
|
---|
1631 | DEFAULT FOR TYPE interval USING gist AS
|
---|
1632 | STORAGE gbtreekey32 ,
|
---|
1633 | OPERATOR 1 <(interval,interval) ,
|
---|
1634 | OPERATOR 2 <=(interval,interval) ,
|
---|
1635 | OPERATOR 3 =(interval,interval) ,
|
---|
1636 | OPERATOR 4 >=(interval,interval) ,
|
---|
1637 | OPERATOR 5 >(interval,interval) ,
|
---|
1638 | FUNCTION 1 gbt_intv_consistent(internal,interval,smallint,oid,internal) ,
|
---|
1639 | FUNCTION 2 gbt_intv_union(bytea,internal) ,
|
---|
1640 | FUNCTION 3 gbt_intv_compress(internal) ,
|
---|
1641 | FUNCTION 4 gbt_intv_decompress(internal) ,
|
---|
1642 | FUNCTION 5 gbt_intv_penalty(internal,internal,internal) ,
|
---|
1643 | FUNCTION 6 gbt_intv_picksplit(internal,internal) ,
|
---|
1644 | FUNCTION 7 gbt_intv_same(internal,internal,internal);
|
---|
1645 |
|
---|
1646 |
|
---|
1647 | --
|
---|
1648 | -- Name: gist_macaddr_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1649 | --
|
---|
1650 |
|
---|
1651 | CREATE OPERATOR FAMILY gist_macaddr_ops USING gist;
|
---|
1652 |
|
---|
1653 |
|
---|
1654 | --
|
---|
1655 | -- Name: gist_macaddr_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1656 | --
|
---|
1657 |
|
---|
1658 | CREATE OPERATOR CLASS gist_macaddr_ops
|
---|
1659 | DEFAULT FOR TYPE macaddr USING gist AS
|
---|
1660 | STORAGE gbtreekey16 ,
|
---|
1661 | OPERATOR 1 <(macaddr,macaddr) ,
|
---|
1662 | OPERATOR 2 <=(macaddr,macaddr) ,
|
---|
1663 | OPERATOR 3 =(macaddr,macaddr) ,
|
---|
1664 | OPERATOR 4 >=(macaddr,macaddr) ,
|
---|
1665 | OPERATOR 5 >(macaddr,macaddr) ,
|
---|
1666 | FUNCTION 1 gbt_macad_consistent(internal,macaddr,smallint,oid,internal) ,
|
---|
1667 | FUNCTION 2 gbt_macad_union(bytea,internal) ,
|
---|
1668 | FUNCTION 3 gbt_macad_compress(internal) ,
|
---|
1669 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1670 | FUNCTION 5 gbt_macad_penalty(internal,internal,internal) ,
|
---|
1671 | FUNCTION 6 gbt_macad_picksplit(internal,internal) ,
|
---|
1672 | FUNCTION 7 gbt_macad_same(internal,internal,internal);
|
---|
1673 |
|
---|
1674 |
|
---|
1675 | --
|
---|
1676 | -- Name: gist_numeric_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1677 | --
|
---|
1678 |
|
---|
1679 | CREATE OPERATOR FAMILY gist_numeric_ops USING gist;
|
---|
1680 |
|
---|
1681 |
|
---|
1682 | --
|
---|
1683 | -- Name: gist_numeric_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1684 | --
|
---|
1685 |
|
---|
1686 | CREATE OPERATOR CLASS gist_numeric_ops
|
---|
1687 | DEFAULT FOR TYPE numeric USING gist AS
|
---|
1688 | STORAGE gbtreekey_var ,
|
---|
1689 | OPERATOR 1 <(numeric,numeric) ,
|
---|
1690 | OPERATOR 2 <=(numeric,numeric) ,
|
---|
1691 | OPERATOR 3 =(numeric,numeric) ,
|
---|
1692 | OPERATOR 4 >=(numeric,numeric) ,
|
---|
1693 | OPERATOR 5 >(numeric,numeric) ,
|
---|
1694 | FUNCTION 1 gbt_numeric_consistent(internal,numeric,smallint,oid,internal) ,
|
---|
1695 | FUNCTION 2 gbt_numeric_union(bytea,internal) ,
|
---|
1696 | FUNCTION 3 gbt_numeric_compress(internal) ,
|
---|
1697 | FUNCTION 4 gbt_var_decompress(internal) ,
|
---|
1698 | FUNCTION 5 gbt_numeric_penalty(internal,internal,internal) ,
|
---|
1699 | FUNCTION 6 gbt_numeric_picksplit(internal,internal) ,
|
---|
1700 | FUNCTION 7 gbt_numeric_same(internal,internal,internal);
|
---|
1701 |
|
---|
1702 |
|
---|
1703 | --
|
---|
1704 | -- Name: gist_oid_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1705 | --
|
---|
1706 |
|
---|
1707 | CREATE OPERATOR FAMILY gist_oid_ops USING gist;
|
---|
1708 |
|
---|
1709 |
|
---|
1710 | --
|
---|
1711 | -- Name: gist_oid_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1712 | --
|
---|
1713 |
|
---|
1714 | CREATE OPERATOR CLASS gist_oid_ops
|
---|
1715 | DEFAULT FOR TYPE oid USING gist AS
|
---|
1716 | STORAGE gbtreekey8 ,
|
---|
1717 | OPERATOR 1 <(oid,oid) ,
|
---|
1718 | OPERATOR 2 <=(oid,oid) ,
|
---|
1719 | OPERATOR 3 =(oid,oid) ,
|
---|
1720 | OPERATOR 4 >=(oid,oid) ,
|
---|
1721 | OPERATOR 5 >(oid,oid) ,
|
---|
1722 | FUNCTION 1 gbt_oid_consistent(internal,oid,smallint,oid,internal) ,
|
---|
1723 | FUNCTION 2 gbt_oid_union(bytea,internal) ,
|
---|
1724 | FUNCTION 3 gbt_oid_compress(internal) ,
|
---|
1725 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1726 | FUNCTION 5 gbt_oid_penalty(internal,internal,internal) ,
|
---|
1727 | FUNCTION 6 gbt_oid_picksplit(internal,internal) ,
|
---|
1728 | FUNCTION 7 gbt_oid_same(internal,internal,internal);
|
---|
1729 |
|
---|
1730 |
|
---|
1731 | --
|
---|
1732 | -- Name: gist_text_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1733 | --
|
---|
1734 |
|
---|
1735 | CREATE OPERATOR FAMILY gist_text_ops USING gist;
|
---|
1736 |
|
---|
1737 |
|
---|
1738 | --
|
---|
1739 | -- Name: gist_text_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1740 | --
|
---|
1741 |
|
---|
1742 | CREATE OPERATOR CLASS gist_text_ops
|
---|
1743 | DEFAULT FOR TYPE text USING gist AS
|
---|
1744 | STORAGE gbtreekey_var ,
|
---|
1745 | OPERATOR 1 <(text,text) ,
|
---|
1746 | OPERATOR 2 <=(text,text) ,
|
---|
1747 | OPERATOR 3 =(text,text) ,
|
---|
1748 | OPERATOR 4 >=(text,text) ,
|
---|
1749 | OPERATOR 5 >(text,text) ,
|
---|
1750 | FUNCTION 1 gbt_text_consistent(internal,text,smallint,oid,internal) ,
|
---|
1751 | FUNCTION 2 gbt_text_union(bytea,internal) ,
|
---|
1752 | FUNCTION 3 gbt_text_compress(internal) ,
|
---|
1753 | FUNCTION 4 gbt_var_decompress(internal) ,
|
---|
1754 | FUNCTION 5 gbt_text_penalty(internal,internal,internal) ,
|
---|
1755 | FUNCTION 6 gbt_text_picksplit(internal,internal) ,
|
---|
1756 | FUNCTION 7 gbt_text_same(internal,internal,internal);
|
---|
1757 |
|
---|
1758 |
|
---|
1759 | --
|
---|
1760 | -- Name: gist_time_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1761 | --
|
---|
1762 |
|
---|
1763 | CREATE OPERATOR FAMILY gist_time_ops USING gist;
|
---|
1764 |
|
---|
1765 |
|
---|
1766 | --
|
---|
1767 | -- Name: gist_time_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1768 | --
|
---|
1769 |
|
---|
1770 | CREATE OPERATOR CLASS gist_time_ops
|
---|
1771 | DEFAULT FOR TYPE time without time zone USING gist AS
|
---|
1772 | STORAGE gbtreekey16 ,
|
---|
1773 | OPERATOR 1 <(time without time zone,time without time zone) ,
|
---|
1774 | OPERATOR 2 <=(time without time zone,time without time zone) ,
|
---|
1775 | OPERATOR 3 =(time without time zone,time without time zone) ,
|
---|
1776 | OPERATOR 4 >=(time without time zone,time without time zone) ,
|
---|
1777 | OPERATOR 5 >(time without time zone,time without time zone) ,
|
---|
1778 | FUNCTION 1 gbt_time_consistent(internal,time without time zone,smallint,oid,internal) ,
|
---|
1779 | FUNCTION 2 gbt_time_union(bytea,internal) ,
|
---|
1780 | FUNCTION 3 gbt_time_compress(internal) ,
|
---|
1781 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1782 | FUNCTION 5 gbt_time_penalty(internal,internal,internal) ,
|
---|
1783 | FUNCTION 6 gbt_time_picksplit(internal,internal) ,
|
---|
1784 | FUNCTION 7 gbt_time_same(internal,internal,internal);
|
---|
1785 |
|
---|
1786 |
|
---|
1787 | --
|
---|
1788 | -- Name: gist_timestamp_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1789 | --
|
---|
1790 |
|
---|
1791 | CREATE OPERATOR FAMILY gist_timestamp_ops USING gist;
|
---|
1792 |
|
---|
1793 |
|
---|
1794 | --
|
---|
1795 | -- Name: gist_timestamp_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1796 | --
|
---|
1797 |
|
---|
1798 | CREATE OPERATOR CLASS gist_timestamp_ops
|
---|
1799 | DEFAULT FOR TYPE timestamp without time zone USING gist AS
|
---|
1800 | STORAGE gbtreekey16 ,
|
---|
1801 | OPERATOR 1 <(timestamp without time zone,timestamp without time zone) ,
|
---|
1802 | OPERATOR 2 <=(timestamp without time zone,timestamp without time zone) ,
|
---|
1803 | OPERATOR 3 =(timestamp without time zone,timestamp without time zone) ,
|
---|
1804 | OPERATOR 4 >=(timestamp without time zone,timestamp without time zone) ,
|
---|
1805 | OPERATOR 5 >(timestamp without time zone,timestamp without time zone) ,
|
---|
1806 | FUNCTION 1 gbt_ts_consistent(internal,timestamp without time zone,smallint,oid,internal) ,
|
---|
1807 | FUNCTION 2 gbt_ts_union(bytea,internal) ,
|
---|
1808 | FUNCTION 3 gbt_ts_compress(internal) ,
|
---|
1809 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1810 | FUNCTION 5 gbt_ts_penalty(internal,internal,internal) ,
|
---|
1811 | FUNCTION 6 gbt_ts_picksplit(internal,internal) ,
|
---|
1812 | FUNCTION 7 gbt_ts_same(internal,internal,internal);
|
---|
1813 |
|
---|
1814 |
|
---|
1815 | --
|
---|
1816 | -- Name: gist_timestamptz_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1817 | --
|
---|
1818 |
|
---|
1819 | CREATE OPERATOR FAMILY gist_timestamptz_ops USING gist;
|
---|
1820 |
|
---|
1821 |
|
---|
1822 | --
|
---|
1823 | -- Name: gist_timestamptz_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1824 | --
|
---|
1825 |
|
---|
1826 | CREATE OPERATOR CLASS gist_timestamptz_ops
|
---|
1827 | DEFAULT FOR TYPE timestamp with time zone USING gist AS
|
---|
1828 | STORAGE gbtreekey16 ,
|
---|
1829 | OPERATOR 1 <(timestamp with time zone,timestamp with time zone) ,
|
---|
1830 | OPERATOR 2 <=(timestamp with time zone,timestamp with time zone) ,
|
---|
1831 | OPERATOR 3 =(timestamp with time zone,timestamp with time zone) ,
|
---|
1832 | OPERATOR 4 >=(timestamp with time zone,timestamp with time zone) ,
|
---|
1833 | OPERATOR 5 >(timestamp with time zone,timestamp with time zone) ,
|
---|
1834 | FUNCTION 1 gbt_tstz_consistent(internal,timestamp with time zone,smallint,oid,internal) ,
|
---|
1835 | FUNCTION 2 gbt_ts_union(bytea,internal) ,
|
---|
1836 | FUNCTION 3 gbt_tstz_compress(internal) ,
|
---|
1837 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1838 | FUNCTION 5 gbt_ts_penalty(internal,internal,internal) ,
|
---|
1839 | FUNCTION 6 gbt_ts_picksplit(internal,internal) ,
|
---|
1840 | FUNCTION 7 gbt_ts_same(internal,internal,internal);
|
---|
1841 |
|
---|
1842 |
|
---|
1843 | --
|
---|
1844 | -- Name: gist_timetz_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1845 | --
|
---|
1846 |
|
---|
1847 | CREATE OPERATOR FAMILY gist_timetz_ops USING gist;
|
---|
1848 |
|
---|
1849 |
|
---|
1850 | --
|
---|
1851 | -- Name: gist_timetz_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1852 | --
|
---|
1853 |
|
---|
1854 | CREATE OPERATOR CLASS gist_timetz_ops
|
---|
1855 | DEFAULT FOR TYPE time with time zone USING gist AS
|
---|
1856 | STORAGE gbtreekey16 ,
|
---|
1857 | OPERATOR 1 <(time with time zone,time with time zone) ,
|
---|
1858 | OPERATOR 2 <=(time with time zone,time with time zone) ,
|
---|
1859 | OPERATOR 3 =(time with time zone,time with time zone) ,
|
---|
1860 | OPERATOR 4 >=(time with time zone,time with time zone) ,
|
---|
1861 | OPERATOR 5 >(time with time zone,time with time zone) ,
|
---|
1862 | FUNCTION 1 gbt_timetz_consistent(internal,time with time zone,smallint,oid,internal) ,
|
---|
1863 | FUNCTION 2 gbt_time_union(bytea,internal) ,
|
---|
1864 | FUNCTION 3 gbt_timetz_compress(internal) ,
|
---|
1865 | FUNCTION 4 gbt_decompress(internal) ,
|
---|
1866 | FUNCTION 5 gbt_time_penalty(internal,internal,internal) ,
|
---|
1867 | FUNCTION 6 gbt_time_picksplit(internal,internal) ,
|
---|
1868 | FUNCTION 7 gbt_time_same(internal,internal,internal);
|
---|
1869 |
|
---|
1870 |
|
---|
1871 | --
|
---|
1872 | -- Name: gist_vbit_ops; Type: OPERATOR FAMILY; Schema: public; Owner: -
|
---|
1873 | --
|
---|
1874 |
|
---|
1875 | CREATE OPERATOR FAMILY gist_vbit_ops USING gist;
|
---|
1876 |
|
---|
1877 |
|
---|
1878 | --
|
---|
1879 | -- Name: gist_vbit_ops; Type: OPERATOR CLASS; Schema: public; Owner: -
|
---|
1880 | --
|
---|
1881 |
|
---|
1882 | CREATE OPERATOR CLASS gist_vbit_ops
|
---|
1883 | DEFAULT FOR TYPE bit varying USING gist AS
|
---|
1884 | STORAGE gbtreekey_var ,
|
---|
1885 | OPERATOR 1 <(bit varying,bit varying) ,
|
---|
1886 | OPERATOR 2 <=(bit varying,bit varying) ,
|
---|
1887 | OPERATOR 3 =(bit varying,bit varying) ,
|
---|
1888 | OPERATOR 4 >=(bit varying,bit varying) ,
|
---|
1889 | OPERATOR 5 >(bit varying,bit varying) ,
|
---|
1890 | FUNCTION 1 gbt_bit_consistent(internal,bit,smallint,oid,internal) ,
|
---|
1891 | FUNCTION 2 gbt_bit_union(bytea,internal) ,
|
---|
1892 | FUNCTION 3 gbt_bit_compress(internal) ,
|
---|
1893 | FUNCTION 4 gbt_var_decompress(internal) ,
|
---|
1894 | FUNCTION 5 gbt_bit_penalty(internal,internal,internal) ,
|
---|
1895 | FUNCTION 6 gbt_bit_picksplit(internal,internal) ,
|
---|
1896 | FUNCTION 7 gbt_bit_same(internal,internal,internal);
|
---|
1897 |
|
---|
1898 |
|
---|
1899 | SET default_tablespace = '';
|
---|
1900 |
|
---|
1901 | SET default_with_oids = false;
|
---|
1902 |
|
---|
1903 | --
|
---|
1904 | -- Name: acls; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
1905 | --
|
---|
1906 |
|
---|
1907 | CREATE TABLE acls (
|
---|
1908 | id integer NOT NULL,
|
---|
1909 | address inet NOT NULL,
|
---|
1910 | netmask inet NOT NULL,
|
---|
1911 | k character varying(255) NOT NULL,
|
---|
1912 | v character varying(255)
|
---|
1913 | );
|
---|
1914 |
|
---|
1915 |
|
---|
1916 | --
|
---|
1917 | -- Name: acls_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
1918 | --
|
---|
1919 |
|
---|
1920 | CREATE SEQUENCE acls_id_seq
|
---|
1921 | START WITH 1
|
---|
1922 | INCREMENT BY 1
|
---|
1923 | NO MINVALUE
|
---|
1924 | NO MAXVALUE
|
---|
1925 | CACHE 1;
|
---|
1926 |
|
---|
1927 |
|
---|
1928 | --
|
---|
1929 | -- Name: acls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
1930 | --
|
---|
1931 |
|
---|
1932 | ALTER SEQUENCE acls_id_seq OWNED BY acls.id;
|
---|
1933 |
|
---|
1934 |
|
---|
1935 | --
|
---|
1936 | -- Name: changeset_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
1937 | --
|
---|
1938 |
|
---|
1939 | CREATE TABLE changeset_tags (
|
---|
1940 | changeset_id bigint NOT NULL,
|
---|
1941 | k character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
1942 | v character varying(255) DEFAULT ''::character varying NOT NULL
|
---|
1943 | );
|
---|
1944 |
|
---|
1945 |
|
---|
1946 | --
|
---|
1947 | -- Name: changesets; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
1948 | --
|
---|
1949 |
|
---|
1950 | CREATE TABLE changesets (
|
---|
1951 | id bigint NOT NULL,
|
---|
1952 | user_id bigint NOT NULL,
|
---|
1953 | created_at timestamp without time zone NOT NULL,
|
---|
1954 | min_lat integer,
|
---|
1955 | max_lat integer,
|
---|
1956 | min_lon integer,
|
---|
1957 | max_lon integer,
|
---|
1958 | closed_at timestamp without time zone NOT NULL,
|
---|
1959 | num_changes integer DEFAULT 0 NOT NULL
|
---|
1960 | );
|
---|
1961 |
|
---|
1962 |
|
---|
1963 | --
|
---|
1964 | -- Name: changesets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
1965 | --
|
---|
1966 |
|
---|
1967 | CREATE SEQUENCE changesets_id_seq
|
---|
1968 | START WITH 1
|
---|
1969 | INCREMENT BY 1
|
---|
1970 | NO MINVALUE
|
---|
1971 | NO MAXVALUE
|
---|
1972 | CACHE 1;
|
---|
1973 |
|
---|
1974 |
|
---|
1975 | --
|
---|
1976 | -- Name: changesets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
1977 | --
|
---|
1978 |
|
---|
1979 | ALTER SEQUENCE changesets_id_seq OWNED BY changesets.id;
|
---|
1980 |
|
---|
1981 |
|
---|
1982 | --
|
---|
1983 | -- Name: client_applications; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
1984 | --
|
---|
1985 |
|
---|
1986 | CREATE TABLE client_applications (
|
---|
1987 | id integer NOT NULL,
|
---|
1988 | name character varying(255),
|
---|
1989 | url character varying(255),
|
---|
1990 | support_url character varying(255),
|
---|
1991 | callback_url character varying(255),
|
---|
1992 | key character varying(50),
|
---|
1993 | secret character varying(50),
|
---|
1994 | user_id integer,
|
---|
1995 | created_at timestamp without time zone,
|
---|
1996 | updated_at timestamp without time zone,
|
---|
1997 | allow_read_prefs boolean DEFAULT false NOT NULL,
|
---|
1998 | allow_write_prefs boolean DEFAULT false NOT NULL,
|
---|
1999 | allow_write_diary boolean DEFAULT false NOT NULL,
|
---|
2000 | allow_write_api boolean DEFAULT false NOT NULL,
|
---|
2001 | allow_read_gpx boolean DEFAULT false NOT NULL,
|
---|
2002 | allow_write_gpx boolean DEFAULT false NOT NULL
|
---|
2003 | );
|
---|
2004 |
|
---|
2005 |
|
---|
2006 | --
|
---|
2007 | -- Name: client_applications_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2008 | --
|
---|
2009 |
|
---|
2010 | CREATE SEQUENCE client_applications_id_seq
|
---|
2011 | START WITH 1
|
---|
2012 | INCREMENT BY 1
|
---|
2013 | NO MINVALUE
|
---|
2014 | NO MAXVALUE
|
---|
2015 | CACHE 1;
|
---|
2016 |
|
---|
2017 |
|
---|
2018 | --
|
---|
2019 | -- Name: client_applications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2020 | --
|
---|
2021 |
|
---|
2022 | ALTER SEQUENCE client_applications_id_seq OWNED BY client_applications.id;
|
---|
2023 |
|
---|
2024 |
|
---|
2025 | --
|
---|
2026 | -- Name: countries; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2027 | --
|
---|
2028 |
|
---|
2029 | CREATE TABLE countries (
|
---|
2030 | id integer NOT NULL,
|
---|
2031 | code character varying(2) NOT NULL,
|
---|
2032 | min_lat double precision NOT NULL,
|
---|
2033 | max_lat double precision NOT NULL,
|
---|
2034 | min_lon double precision NOT NULL,
|
---|
2035 | max_lon double precision NOT NULL
|
---|
2036 | );
|
---|
2037 |
|
---|
2038 |
|
---|
2039 | --
|
---|
2040 | -- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2041 | --
|
---|
2042 |
|
---|
2043 | CREATE SEQUENCE countries_id_seq
|
---|
2044 | START WITH 1
|
---|
2045 | INCREMENT BY 1
|
---|
2046 | NO MINVALUE
|
---|
2047 | NO MAXVALUE
|
---|
2048 | CACHE 1;
|
---|
2049 |
|
---|
2050 |
|
---|
2051 | --
|
---|
2052 | -- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2053 | --
|
---|
2054 |
|
---|
2055 | ALTER SEQUENCE countries_id_seq OWNED BY countries.id;
|
---|
2056 |
|
---|
2057 |
|
---|
2058 | --
|
---|
2059 | -- Name: current_node_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2060 | --
|
---|
2061 |
|
---|
2062 | CREATE TABLE current_node_tags (
|
---|
2063 | node_id bigint NOT NULL,
|
---|
2064 | k character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2065 | v character varying(255) DEFAULT ''::character varying NOT NULL
|
---|
2066 | );
|
---|
2067 |
|
---|
2068 |
|
---|
2069 | --
|
---|
2070 | -- Name: current_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2071 | --
|
---|
2072 |
|
---|
2073 | CREATE TABLE current_nodes (
|
---|
2074 | id bigint NOT NULL,
|
---|
2075 | latitude integer NOT NULL,
|
---|
2076 | longitude integer NOT NULL,
|
---|
2077 | changeset_id bigint NOT NULL,
|
---|
2078 | visible boolean NOT NULL,
|
---|
2079 | "timestamp" timestamp without time zone NOT NULL,
|
---|
2080 | tile bigint NOT NULL,
|
---|
2081 | version bigint NOT NULL
|
---|
2082 | );
|
---|
2083 |
|
---|
2084 |
|
---|
2085 | --
|
---|
2086 | -- Name: current_nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2087 | --
|
---|
2088 |
|
---|
2089 | CREATE SEQUENCE current_nodes_id_seq
|
---|
2090 | START WITH 1
|
---|
2091 | INCREMENT BY 1
|
---|
2092 | NO MINVALUE
|
---|
2093 | NO MAXVALUE
|
---|
2094 | CACHE 1;
|
---|
2095 |
|
---|
2096 |
|
---|
2097 | --
|
---|
2098 | -- Name: current_nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2099 | --
|
---|
2100 |
|
---|
2101 | ALTER SEQUENCE current_nodes_id_seq OWNED BY current_nodes.id;
|
---|
2102 |
|
---|
2103 |
|
---|
2104 | --
|
---|
2105 | -- Name: current_relation_members; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2106 | --
|
---|
2107 |
|
---|
2108 | CREATE TABLE current_relation_members (
|
---|
2109 | relation_id bigint NOT NULL,
|
---|
2110 | member_type nwr_enum NOT NULL,
|
---|
2111 | member_id bigint NOT NULL,
|
---|
2112 | member_role character varying(255) NOT NULL,
|
---|
2113 | sequence_id integer DEFAULT 0 NOT NULL
|
---|
2114 | );
|
---|
2115 |
|
---|
2116 |
|
---|
2117 | --
|
---|
2118 | -- Name: current_relation_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2119 | --
|
---|
2120 |
|
---|
2121 | CREATE TABLE current_relation_tags (
|
---|
2122 | relation_id bigint NOT NULL,
|
---|
2123 | k character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2124 | v character varying(255) DEFAULT ''::character varying NOT NULL
|
---|
2125 | );
|
---|
2126 |
|
---|
2127 |
|
---|
2128 | --
|
---|
2129 | -- Name: current_relations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2130 | --
|
---|
2131 |
|
---|
2132 | CREATE TABLE current_relations (
|
---|
2133 | id bigint NOT NULL,
|
---|
2134 | changeset_id bigint NOT NULL,
|
---|
2135 | "timestamp" timestamp without time zone NOT NULL,
|
---|
2136 | visible boolean NOT NULL,
|
---|
2137 | version bigint NOT NULL
|
---|
2138 | );
|
---|
2139 |
|
---|
2140 |
|
---|
2141 | --
|
---|
2142 | -- Name: current_relations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2143 | --
|
---|
2144 |
|
---|
2145 | CREATE SEQUENCE current_relations_id_seq
|
---|
2146 | START WITH 1
|
---|
2147 | INCREMENT BY 1
|
---|
2148 | NO MINVALUE
|
---|
2149 | NO MAXVALUE
|
---|
2150 | CACHE 1;
|
---|
2151 |
|
---|
2152 |
|
---|
2153 | --
|
---|
2154 | -- Name: current_relations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2155 | --
|
---|
2156 |
|
---|
2157 | ALTER SEQUENCE current_relations_id_seq OWNED BY current_relations.id;
|
---|
2158 |
|
---|
2159 |
|
---|
2160 | --
|
---|
2161 | -- Name: current_way_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2162 | --
|
---|
2163 |
|
---|
2164 | CREATE TABLE current_way_nodes (
|
---|
2165 | way_id bigint NOT NULL,
|
---|
2166 | node_id bigint NOT NULL,
|
---|
2167 | sequence_id bigint NOT NULL
|
---|
2168 | );
|
---|
2169 |
|
---|
2170 |
|
---|
2171 | --
|
---|
2172 | -- Name: current_way_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2173 | --
|
---|
2174 |
|
---|
2175 | CREATE TABLE current_way_tags (
|
---|
2176 | way_id bigint NOT NULL,
|
---|
2177 | k character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2178 | v character varying(255) DEFAULT ''::character varying NOT NULL
|
---|
2179 | );
|
---|
2180 |
|
---|
2181 |
|
---|
2182 | --
|
---|
2183 | -- Name: current_ways; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2184 | --
|
---|
2185 |
|
---|
2186 | CREATE TABLE current_ways (
|
---|
2187 | id bigint NOT NULL,
|
---|
2188 | changeset_id bigint NOT NULL,
|
---|
2189 | "timestamp" timestamp without time zone NOT NULL,
|
---|
2190 | visible boolean NOT NULL,
|
---|
2191 | version bigint NOT NULL
|
---|
2192 | );
|
---|
2193 |
|
---|
2194 |
|
---|
2195 | --
|
---|
2196 | -- Name: current_ways_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2197 | --
|
---|
2198 |
|
---|
2199 | CREATE SEQUENCE current_ways_id_seq
|
---|
2200 | START WITH 1
|
---|
2201 | INCREMENT BY 1
|
---|
2202 | NO MINVALUE
|
---|
2203 | NO MAXVALUE
|
---|
2204 | CACHE 1;
|
---|
2205 |
|
---|
2206 |
|
---|
2207 | --
|
---|
2208 | -- Name: current_ways_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2209 | --
|
---|
2210 |
|
---|
2211 | ALTER SEQUENCE current_ways_id_seq OWNED BY current_ways.id;
|
---|
2212 |
|
---|
2213 |
|
---|
2214 | --
|
---|
2215 | -- Name: diary_comments; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2216 | --
|
---|
2217 |
|
---|
2218 | CREATE TABLE diary_comments (
|
---|
2219 | id bigint NOT NULL,
|
---|
2220 | diary_entry_id bigint NOT NULL,
|
---|
2221 | user_id bigint NOT NULL,
|
---|
2222 | body text NOT NULL,
|
---|
2223 | created_at timestamp without time zone NOT NULL,
|
---|
2224 | updated_at timestamp without time zone NOT NULL,
|
---|
2225 | visible boolean DEFAULT true NOT NULL
|
---|
2226 | );
|
---|
2227 |
|
---|
2228 |
|
---|
2229 | --
|
---|
2230 | -- Name: diary_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2231 | --
|
---|
2232 |
|
---|
2233 | CREATE SEQUENCE diary_comments_id_seq
|
---|
2234 | START WITH 1
|
---|
2235 | INCREMENT BY 1
|
---|
2236 | NO MINVALUE
|
---|
2237 | NO MAXVALUE
|
---|
2238 | CACHE 1;
|
---|
2239 |
|
---|
2240 |
|
---|
2241 | --
|
---|
2242 | -- Name: diary_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2243 | --
|
---|
2244 |
|
---|
2245 | ALTER SEQUENCE diary_comments_id_seq OWNED BY diary_comments.id;
|
---|
2246 |
|
---|
2247 |
|
---|
2248 | --
|
---|
2249 | -- Name: diary_entries; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2250 | --
|
---|
2251 |
|
---|
2252 | CREATE TABLE diary_entries (
|
---|
2253 | id bigint NOT NULL,
|
---|
2254 | user_id bigint NOT NULL,
|
---|
2255 | title character varying(255) NOT NULL,
|
---|
2256 | body text NOT NULL,
|
---|
2257 | created_at timestamp without time zone NOT NULL,
|
---|
2258 | updated_at timestamp without time zone NOT NULL,
|
---|
2259 | latitude double precision,
|
---|
2260 | longitude double precision,
|
---|
2261 | language_code character varying(255) DEFAULT 'en'::character varying NOT NULL,
|
---|
2262 | visible boolean DEFAULT true NOT NULL
|
---|
2263 | );
|
---|
2264 |
|
---|
2265 |
|
---|
2266 | --
|
---|
2267 | -- Name: diary_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2268 | --
|
---|
2269 |
|
---|
2270 | CREATE SEQUENCE diary_entries_id_seq
|
---|
2271 | START WITH 1
|
---|
2272 | INCREMENT BY 1
|
---|
2273 | NO MINVALUE
|
---|
2274 | NO MAXVALUE
|
---|
2275 | CACHE 1;
|
---|
2276 |
|
---|
2277 |
|
---|
2278 | --
|
---|
2279 | -- Name: diary_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2280 | --
|
---|
2281 |
|
---|
2282 | ALTER SEQUENCE diary_entries_id_seq OWNED BY diary_entries.id;
|
---|
2283 |
|
---|
2284 |
|
---|
2285 | --
|
---|
2286 | -- Name: friends; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2287 | --
|
---|
2288 |
|
---|
2289 | CREATE TABLE friends (
|
---|
2290 | id bigint NOT NULL,
|
---|
2291 | user_id bigint NOT NULL,
|
---|
2292 | friend_user_id bigint NOT NULL
|
---|
2293 | );
|
---|
2294 |
|
---|
2295 |
|
---|
2296 | --
|
---|
2297 | -- Name: friends_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2298 | --
|
---|
2299 |
|
---|
2300 | CREATE SEQUENCE friends_id_seq
|
---|
2301 | START WITH 1
|
---|
2302 | INCREMENT BY 1
|
---|
2303 | NO MINVALUE
|
---|
2304 | NO MAXVALUE
|
---|
2305 | CACHE 1;
|
---|
2306 |
|
---|
2307 |
|
---|
2308 | --
|
---|
2309 | -- Name: friends_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2310 | --
|
---|
2311 |
|
---|
2312 | ALTER SEQUENCE friends_id_seq OWNED BY friends.id;
|
---|
2313 |
|
---|
2314 |
|
---|
2315 | --
|
---|
2316 | -- Name: gps_points; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2317 | --
|
---|
2318 |
|
---|
2319 | CREATE TABLE gps_points (
|
---|
2320 | altitude double precision,
|
---|
2321 | trackid integer NOT NULL,
|
---|
2322 | latitude integer NOT NULL,
|
---|
2323 | longitude integer NOT NULL,
|
---|
2324 | gpx_id bigint NOT NULL,
|
---|
2325 | "timestamp" timestamp without time zone,
|
---|
2326 | tile bigint
|
---|
2327 | );
|
---|
2328 |
|
---|
2329 |
|
---|
2330 | --
|
---|
2331 | -- Name: gpx_file_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2332 | --
|
---|
2333 |
|
---|
2334 | CREATE TABLE gpx_file_tags (
|
---|
2335 | gpx_id bigint DEFAULT 0 NOT NULL,
|
---|
2336 | tag character varying(255) NOT NULL,
|
---|
2337 | id bigint NOT NULL
|
---|
2338 | );
|
---|
2339 |
|
---|
2340 |
|
---|
2341 | --
|
---|
2342 | -- Name: gpx_file_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2343 | --
|
---|
2344 |
|
---|
2345 | CREATE SEQUENCE gpx_file_tags_id_seq
|
---|
2346 | START WITH 1
|
---|
2347 | INCREMENT BY 1
|
---|
2348 | NO MINVALUE
|
---|
2349 | NO MAXVALUE
|
---|
2350 | CACHE 1;
|
---|
2351 |
|
---|
2352 |
|
---|
2353 | --
|
---|
2354 | -- Name: gpx_file_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2355 | --
|
---|
2356 |
|
---|
2357 | ALTER SEQUENCE gpx_file_tags_id_seq OWNED BY gpx_file_tags.id;
|
---|
2358 |
|
---|
2359 |
|
---|
2360 | --
|
---|
2361 | -- Name: gpx_files; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2362 | --
|
---|
2363 |
|
---|
2364 | CREATE TABLE gpx_files (
|
---|
2365 | id bigint NOT NULL,
|
---|
2366 | user_id bigint NOT NULL,
|
---|
2367 | visible boolean DEFAULT true NOT NULL,
|
---|
2368 | name character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2369 | size bigint,
|
---|
2370 | latitude double precision,
|
---|
2371 | longitude double precision,
|
---|
2372 | "timestamp" timestamp without time zone NOT NULL,
|
---|
2373 | description character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2374 | inserted boolean NOT NULL,
|
---|
2375 | visibility gpx_visibility_enum DEFAULT 'public'::gpx_visibility_enum NOT NULL
|
---|
2376 | );
|
---|
2377 |
|
---|
2378 |
|
---|
2379 | --
|
---|
2380 | -- Name: gpx_files_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2381 | --
|
---|
2382 |
|
---|
2383 | CREATE SEQUENCE gpx_files_id_seq
|
---|
2384 | START WITH 1
|
---|
2385 | INCREMENT BY 1
|
---|
2386 | NO MINVALUE
|
---|
2387 | NO MAXVALUE
|
---|
2388 | CACHE 1;
|
---|
2389 |
|
---|
2390 |
|
---|
2391 | --
|
---|
2392 | -- Name: gpx_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2393 | --
|
---|
2394 |
|
---|
2395 | ALTER SEQUENCE gpx_files_id_seq OWNED BY gpx_files.id;
|
---|
2396 |
|
---|
2397 |
|
---|
2398 | --
|
---|
2399 | -- Name: languages; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2400 | --
|
---|
2401 |
|
---|
2402 | CREATE TABLE languages (
|
---|
2403 | code character varying(255) NOT NULL,
|
---|
2404 | english_name character varying(255) NOT NULL,
|
---|
2405 | native_name character varying(255)
|
---|
2406 | );
|
---|
2407 |
|
---|
2408 |
|
---|
2409 | --
|
---|
2410 | -- Name: messages; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2411 | --
|
---|
2412 |
|
---|
2413 | CREATE TABLE messages (
|
---|
2414 | id bigint NOT NULL,
|
---|
2415 | from_user_id bigint NOT NULL,
|
---|
2416 | title character varying(255) NOT NULL,
|
---|
2417 | body text NOT NULL,
|
---|
2418 | sent_on timestamp without time zone NOT NULL,
|
---|
2419 | message_read boolean DEFAULT false NOT NULL,
|
---|
2420 | to_user_id bigint NOT NULL,
|
---|
2421 | to_user_visible boolean DEFAULT true NOT NULL,
|
---|
2422 | from_user_visible boolean DEFAULT true NOT NULL
|
---|
2423 | );
|
---|
2424 |
|
---|
2425 |
|
---|
2426 | --
|
---|
2427 | -- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2428 | --
|
---|
2429 |
|
---|
2430 | CREATE SEQUENCE messages_id_seq
|
---|
2431 | START WITH 1
|
---|
2432 | INCREMENT BY 1
|
---|
2433 | NO MINVALUE
|
---|
2434 | NO MAXVALUE
|
---|
2435 | CACHE 1;
|
---|
2436 |
|
---|
2437 |
|
---|
2438 | --
|
---|
2439 | -- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2440 | --
|
---|
2441 |
|
---|
2442 | ALTER SEQUENCE messages_id_seq OWNED BY messages.id;
|
---|
2443 |
|
---|
2444 |
|
---|
2445 | --
|
---|
2446 | -- Name: node_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2447 | --
|
---|
2448 |
|
---|
2449 | CREATE TABLE node_tags (
|
---|
2450 | node_id bigint NOT NULL,
|
---|
2451 | version bigint NOT NULL,
|
---|
2452 | k character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2453 | v character varying(255) DEFAULT ''::character varying NOT NULL
|
---|
2454 | );
|
---|
2455 |
|
---|
2456 |
|
---|
2457 | --
|
---|
2458 | -- Name: nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2459 | --
|
---|
2460 |
|
---|
2461 | CREATE TABLE nodes (
|
---|
2462 | node_id bigint NOT NULL,
|
---|
2463 | latitude integer NOT NULL,
|
---|
2464 | longitude integer NOT NULL,
|
---|
2465 | changeset_id bigint NOT NULL,
|
---|
2466 | visible boolean NOT NULL,
|
---|
2467 | "timestamp" timestamp without time zone NOT NULL,
|
---|
2468 | tile bigint NOT NULL,
|
---|
2469 | version bigint NOT NULL,
|
---|
2470 | redaction_id integer
|
---|
2471 | );
|
---|
2472 |
|
---|
2473 |
|
---|
2474 | --
|
---|
2475 | -- Name: oauth_nonces; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2476 | --
|
---|
2477 |
|
---|
2478 | CREATE TABLE oauth_nonces (
|
---|
2479 | id integer NOT NULL,
|
---|
2480 | nonce character varying(255),
|
---|
2481 | "timestamp" integer,
|
---|
2482 | created_at timestamp without time zone,
|
---|
2483 | updated_at timestamp without time zone
|
---|
2484 | );
|
---|
2485 |
|
---|
2486 |
|
---|
2487 | --
|
---|
2488 | -- Name: oauth_nonces_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2489 | --
|
---|
2490 |
|
---|
2491 | CREATE SEQUENCE oauth_nonces_id_seq
|
---|
2492 | START WITH 1
|
---|
2493 | INCREMENT BY 1
|
---|
2494 | NO MINVALUE
|
---|
2495 | NO MAXVALUE
|
---|
2496 | CACHE 1;
|
---|
2497 |
|
---|
2498 |
|
---|
2499 | --
|
---|
2500 | -- Name: oauth_nonces_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2501 | --
|
---|
2502 |
|
---|
2503 | ALTER SEQUENCE oauth_nonces_id_seq OWNED BY oauth_nonces.id;
|
---|
2504 |
|
---|
2505 |
|
---|
2506 | --
|
---|
2507 | -- Name: oauth_tokens; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2508 | --
|
---|
2509 |
|
---|
2510 | CREATE TABLE oauth_tokens (
|
---|
2511 | id integer NOT NULL,
|
---|
2512 | user_id integer,
|
---|
2513 | type character varying(20),
|
---|
2514 | client_application_id integer,
|
---|
2515 | token character varying(50),
|
---|
2516 | secret character varying(50),
|
---|
2517 | authorized_at timestamp without time zone,
|
---|
2518 | invalidated_at timestamp without time zone,
|
---|
2519 | created_at timestamp without time zone,
|
---|
2520 | updated_at timestamp without time zone,
|
---|
2521 | allow_read_prefs boolean DEFAULT false NOT NULL,
|
---|
2522 | allow_write_prefs boolean DEFAULT false NOT NULL,
|
---|
2523 | allow_write_diary boolean DEFAULT false NOT NULL,
|
---|
2524 | allow_write_api boolean DEFAULT false NOT NULL,
|
---|
2525 | allow_read_gpx boolean DEFAULT false NOT NULL,
|
---|
2526 | allow_write_gpx boolean DEFAULT false NOT NULL,
|
---|
2527 | callback_url character varying(255),
|
---|
2528 | verifier character varying(20)
|
---|
2529 | );
|
---|
2530 |
|
---|
2531 |
|
---|
2532 | --
|
---|
2533 | -- Name: oauth_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2534 | --
|
---|
2535 |
|
---|
2536 | CREATE SEQUENCE oauth_tokens_id_seq
|
---|
2537 | START WITH 1
|
---|
2538 | INCREMENT BY 1
|
---|
2539 | NO MINVALUE
|
---|
2540 | NO MAXVALUE
|
---|
2541 | CACHE 1;
|
---|
2542 |
|
---|
2543 |
|
---|
2544 | --
|
---|
2545 | -- Name: oauth_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2546 | --
|
---|
2547 |
|
---|
2548 | ALTER SEQUENCE oauth_tokens_id_seq OWNED BY oauth_tokens.id;
|
---|
2549 |
|
---|
2550 |
|
---|
2551 | --
|
---|
2552 | -- Name: relation_members; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2553 | --
|
---|
2554 |
|
---|
2555 | CREATE TABLE relation_members (
|
---|
2556 | relation_id bigint DEFAULT 0 NOT NULL,
|
---|
2557 | member_type nwr_enum NOT NULL,
|
---|
2558 | member_id bigint NOT NULL,
|
---|
2559 | member_role character varying(255) NOT NULL,
|
---|
2560 | version bigint DEFAULT 0 NOT NULL,
|
---|
2561 | sequence_id integer DEFAULT 0 NOT NULL
|
---|
2562 | );
|
---|
2563 |
|
---|
2564 |
|
---|
2565 | --
|
---|
2566 | -- Name: relation_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2567 | --
|
---|
2568 |
|
---|
2569 | CREATE TABLE relation_tags (
|
---|
2570 | relation_id bigint DEFAULT 0 NOT NULL,
|
---|
2571 | k character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2572 | v character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2573 | version bigint NOT NULL
|
---|
2574 | );
|
---|
2575 |
|
---|
2576 |
|
---|
2577 | --
|
---|
2578 | -- Name: relations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2579 | --
|
---|
2580 |
|
---|
2581 | CREATE TABLE relations (
|
---|
2582 | relation_id bigint DEFAULT 0 NOT NULL,
|
---|
2583 | changeset_id bigint NOT NULL,
|
---|
2584 | "timestamp" timestamp without time zone NOT NULL,
|
---|
2585 | version bigint NOT NULL,
|
---|
2586 | visible boolean DEFAULT true NOT NULL,
|
---|
2587 | redaction_id integer
|
---|
2588 | );
|
---|
2589 |
|
---|
2590 |
|
---|
2591 | --
|
---|
2592 | -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2593 | --
|
---|
2594 |
|
---|
2595 | CREATE TABLE schema_migrations (
|
---|
2596 | version character varying(255) NOT NULL
|
---|
2597 | );
|
---|
2598 |
|
---|
2599 |
|
---|
2600 | --
|
---|
2601 | -- Name: sessions; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2602 | --
|
---|
2603 |
|
---|
2604 | CREATE TABLE sessions (
|
---|
2605 | id integer NOT NULL,
|
---|
2606 | session_id character varying(255),
|
---|
2607 | data text,
|
---|
2608 | created_at timestamp without time zone,
|
---|
2609 | updated_at timestamp without time zone
|
---|
2610 | );
|
---|
2611 |
|
---|
2612 |
|
---|
2613 | --
|
---|
2614 | -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2615 | --
|
---|
2616 |
|
---|
2617 | CREATE SEQUENCE sessions_id_seq
|
---|
2618 | START WITH 1
|
---|
2619 | INCREMENT BY 1
|
---|
2620 | NO MINVALUE
|
---|
2621 | NO MAXVALUE
|
---|
2622 | CACHE 1;
|
---|
2623 |
|
---|
2624 |
|
---|
2625 | --
|
---|
2626 | -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2627 | --
|
---|
2628 |
|
---|
2629 | ALTER SEQUENCE sessions_id_seq OWNED BY sessions.id;
|
---|
2630 |
|
---|
2631 |
|
---|
2632 | --
|
---|
2633 | -- Name: user_blocks; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2634 | --
|
---|
2635 |
|
---|
2636 | CREATE TABLE user_blocks (
|
---|
2637 | id integer NOT NULL,
|
---|
2638 | user_id bigint NOT NULL,
|
---|
2639 | creator_id bigint NOT NULL,
|
---|
2640 | reason text NOT NULL,
|
---|
2641 | ends_at timestamp without time zone NOT NULL,
|
---|
2642 | needs_view boolean DEFAULT false NOT NULL,
|
---|
2643 | revoker_id bigint,
|
---|
2644 | created_at timestamp without time zone,
|
---|
2645 | updated_at timestamp without time zone
|
---|
2646 | );
|
---|
2647 |
|
---|
2648 |
|
---|
2649 | --
|
---|
2650 | -- Name: user_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2651 | --
|
---|
2652 |
|
---|
2653 | CREATE SEQUENCE user_blocks_id_seq
|
---|
2654 | START WITH 1
|
---|
2655 | INCREMENT BY 1
|
---|
2656 | NO MINVALUE
|
---|
2657 | NO MAXVALUE
|
---|
2658 | CACHE 1;
|
---|
2659 |
|
---|
2660 |
|
---|
2661 | --
|
---|
2662 | -- Name: user_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2663 | --
|
---|
2664 |
|
---|
2665 | ALTER SEQUENCE user_blocks_id_seq OWNED BY user_blocks.id;
|
---|
2666 |
|
---|
2667 |
|
---|
2668 | --
|
---|
2669 | -- Name: user_preferences; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2670 | --
|
---|
2671 |
|
---|
2672 | CREATE TABLE user_preferences (
|
---|
2673 | user_id bigint NOT NULL,
|
---|
2674 | k character varying(255) NOT NULL,
|
---|
2675 | v character varying(255) NOT NULL
|
---|
2676 | );
|
---|
2677 |
|
---|
2678 |
|
---|
2679 | --
|
---|
2680 | -- Name: user_roles; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2681 | --
|
---|
2682 |
|
---|
2683 | CREATE TABLE user_roles (
|
---|
2684 | id integer NOT NULL,
|
---|
2685 | user_id bigint NOT NULL,
|
---|
2686 | created_at timestamp without time zone,
|
---|
2687 | updated_at timestamp without time zone,
|
---|
2688 | role user_role_enum NOT NULL,
|
---|
2689 | granter_id bigint NOT NULL
|
---|
2690 | );
|
---|
2691 |
|
---|
2692 |
|
---|
2693 | --
|
---|
2694 | -- Name: user_roles_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2695 | --
|
---|
2696 |
|
---|
2697 | CREATE SEQUENCE user_roles_id_seq
|
---|
2698 | START WITH 1
|
---|
2699 | INCREMENT BY 1
|
---|
2700 | NO MINVALUE
|
---|
2701 | NO MAXVALUE
|
---|
2702 | CACHE 1;
|
---|
2703 |
|
---|
2704 |
|
---|
2705 | --
|
---|
2706 | -- Name: user_roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2707 | --
|
---|
2708 |
|
---|
2709 | ALTER SEQUENCE user_roles_id_seq OWNED BY user_roles.id;
|
---|
2710 |
|
---|
2711 |
|
---|
2712 | --
|
---|
2713 | -- Name: user_tokens; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2714 | --
|
---|
2715 |
|
---|
2716 | CREATE TABLE user_tokens (
|
---|
2717 | id bigint NOT NULL,
|
---|
2718 | user_id bigint NOT NULL,
|
---|
2719 | token character varying(255) NOT NULL,
|
---|
2720 | expiry timestamp without time zone NOT NULL,
|
---|
2721 | referer text
|
---|
2722 | );
|
---|
2723 |
|
---|
2724 |
|
---|
2725 | --
|
---|
2726 | -- Name: user_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2727 | --
|
---|
2728 |
|
---|
2729 | CREATE SEQUENCE user_tokens_id_seq
|
---|
2730 | START WITH 1
|
---|
2731 | INCREMENT BY 1
|
---|
2732 | NO MINVALUE
|
---|
2733 | NO MAXVALUE
|
---|
2734 | CACHE 1;
|
---|
2735 |
|
---|
2736 |
|
---|
2737 | --
|
---|
2738 | -- Name: user_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2739 | --
|
---|
2740 |
|
---|
2741 | ALTER SEQUENCE user_tokens_id_seq OWNED BY user_tokens.id;
|
---|
2742 |
|
---|
2743 |
|
---|
2744 | --
|
---|
2745 | -- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2746 | --
|
---|
2747 |
|
---|
2748 | CREATE TABLE users (
|
---|
2749 | email character varying(255) NOT NULL,
|
---|
2750 | id bigint NOT NULL,
|
---|
2751 | pass_crypt character varying(255) NOT NULL,
|
---|
2752 | creation_time timestamp without time zone NOT NULL,
|
---|
2753 | display_name character varying(255) DEFAULT ''::character varying NOT NULL,
|
---|
2754 | data_public boolean DEFAULT false NOT NULL,
|
---|
2755 | description text DEFAULT ''::text NOT NULL,
|
---|
2756 | home_lat double precision,
|
---|
2757 | home_lon double precision,
|
---|
2758 | home_zoom smallint DEFAULT 3,
|
---|
2759 | nearby integer DEFAULT 50,
|
---|
2760 | pass_salt character varying(255),
|
---|
2761 | image text,
|
---|
2762 | email_valid boolean DEFAULT false NOT NULL,
|
---|
2763 | new_email character varying(255),
|
---|
2764 | creation_ip character varying(255),
|
---|
2765 | languages character varying(255),
|
---|
2766 | status user_status_enum DEFAULT 'pending'::user_status_enum NOT NULL,
|
---|
2767 | terms_agreed timestamp without time zone,
|
---|
2768 | consider_pd boolean DEFAULT false NOT NULL,
|
---|
2769 | preferred_editor character varying(255),
|
---|
2770 | terms_seen boolean DEFAULT false NOT NULL,
|
---|
2771 | openid_url character varying(255)
|
---|
2772 | );
|
---|
2773 |
|
---|
2774 |
|
---|
2775 | --
|
---|
2776 | -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
---|
2777 | --
|
---|
2778 |
|
---|
2779 | CREATE SEQUENCE users_id_seq
|
---|
2780 | START WITH 1
|
---|
2781 | INCREMENT BY 1
|
---|
2782 | NO MINVALUE
|
---|
2783 | NO MAXVALUE
|
---|
2784 | CACHE 1;
|
---|
2785 |
|
---|
2786 |
|
---|
2787 | --
|
---|
2788 | -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
---|
2789 | --
|
---|
2790 |
|
---|
2791 | ALTER SEQUENCE users_id_seq OWNED BY users.id;
|
---|
2792 |
|
---|
2793 |
|
---|
2794 | --
|
---|
2795 | -- Name: way_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2796 | --
|
---|
2797 |
|
---|
2798 | CREATE TABLE way_nodes (
|
---|
2799 | way_id bigint NOT NULL,
|
---|
2800 | node_id bigint NOT NULL,
|
---|
2801 | version bigint NOT NULL,
|
---|
2802 | sequence_id bigint NOT NULL
|
---|
2803 | );
|
---|
2804 |
|
---|
2805 |
|
---|
2806 | --
|
---|
2807 | -- Name: way_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2808 | --
|
---|
2809 |
|
---|
2810 | CREATE TABLE way_tags (
|
---|
2811 | way_id bigint DEFAULT 0 NOT NULL,
|
---|
2812 | k character varying(255) NOT NULL,
|
---|
2813 | v character varying(255) NOT NULL,
|
---|
2814 | version bigint NOT NULL
|
---|
2815 | );
|
---|
2816 |
|
---|
2817 |
|
---|
2818 | --
|
---|
2819 | -- Name: ways; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
---|
2820 | --
|
---|
2821 |
|
---|
2822 | CREATE TABLE ways (
|
---|
2823 | way_id bigint DEFAULT 0 NOT NULL,
|
---|
2824 | changeset_id bigint NOT NULL,
|
---|
2825 | "timestamp" timestamp without time zone NOT NULL,
|
---|
2826 | version bigint NOT NULL,
|
---|
2827 | visible boolean DEFAULT true NOT NULL,
|
---|
2828 | redaction_id integer
|
---|
2829 | );
|
---|
2830 |
|
---|
2831 |
|
---|
2832 | --
|
---|
2833 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2834 | --
|
---|
2835 |
|
---|
2836 | ALTER TABLE acls ALTER COLUMN id SET DEFAULT nextval('acls_id_seq'::regclass);
|
---|
2837 |
|
---|
2838 |
|
---|
2839 | --
|
---|
2840 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2841 | --
|
---|
2842 |
|
---|
2843 | ALTER TABLE changesets ALTER COLUMN id SET DEFAULT nextval('changesets_id_seq'::regclass);
|
---|
2844 |
|
---|
2845 |
|
---|
2846 | --
|
---|
2847 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2848 | --
|
---|
2849 |
|
---|
2850 | ALTER TABLE client_applications ALTER COLUMN id SET DEFAULT nextval('client_applications_id_seq'::regclass);
|
---|
2851 |
|
---|
2852 |
|
---|
2853 | --
|
---|
2854 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2855 | --
|
---|
2856 |
|
---|
2857 | ALTER TABLE countries ALTER COLUMN id SET DEFAULT nextval('countries_id_seq'::regclass);
|
---|
2858 |
|
---|
2859 |
|
---|
2860 | --
|
---|
2861 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2862 | --
|
---|
2863 |
|
---|
2864 | ALTER TABLE current_nodes ALTER COLUMN id SET DEFAULT nextval('current_nodes_id_seq'::regclass);
|
---|
2865 |
|
---|
2866 |
|
---|
2867 | --
|
---|
2868 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2869 | --
|
---|
2870 |
|
---|
2871 | ALTER TABLE current_relations ALTER COLUMN id SET DEFAULT nextval('current_relations_id_seq'::regclass);
|
---|
2872 |
|
---|
2873 |
|
---|
2874 | --
|
---|
2875 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2876 | --
|
---|
2877 |
|
---|
2878 | ALTER TABLE current_ways ALTER COLUMN id SET DEFAULT nextval('current_ways_id_seq'::regclass);
|
---|
2879 |
|
---|
2880 |
|
---|
2881 | --
|
---|
2882 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2883 | --
|
---|
2884 |
|
---|
2885 | ALTER TABLE diary_comments ALTER COLUMN id SET DEFAULT nextval('diary_comments_id_seq'::regclass);
|
---|
2886 |
|
---|
2887 |
|
---|
2888 | --
|
---|
2889 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2890 | --
|
---|
2891 |
|
---|
2892 | ALTER TABLE diary_entries ALTER COLUMN id SET DEFAULT nextval('diary_entries_id_seq'::regclass);
|
---|
2893 |
|
---|
2894 |
|
---|
2895 | --
|
---|
2896 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2897 | --
|
---|
2898 |
|
---|
2899 | ALTER TABLE friends ALTER COLUMN id SET DEFAULT nextval('friends_id_seq'::regclass);
|
---|
2900 |
|
---|
2901 |
|
---|
2902 | --
|
---|
2903 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2904 | --
|
---|
2905 |
|
---|
2906 | ALTER TABLE gpx_file_tags ALTER COLUMN id SET DEFAULT nextval('gpx_file_tags_id_seq'::regclass);
|
---|
2907 |
|
---|
2908 |
|
---|
2909 | --
|
---|
2910 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2911 | --
|
---|
2912 |
|
---|
2913 | ALTER TABLE gpx_files ALTER COLUMN id SET DEFAULT nextval('gpx_files_id_seq'::regclass);
|
---|
2914 |
|
---|
2915 |
|
---|
2916 | --
|
---|
2917 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2918 | --
|
---|
2919 |
|
---|
2920 | ALTER TABLE messages ALTER COLUMN id SET DEFAULT nextval('messages_id_seq'::regclass);
|
---|
2921 |
|
---|
2922 |
|
---|
2923 | --
|
---|
2924 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2925 | --
|
---|
2926 |
|
---|
2927 | ALTER TABLE oauth_nonces ALTER COLUMN id SET DEFAULT nextval('oauth_nonces_id_seq'::regclass);
|
---|
2928 |
|
---|
2929 |
|
---|
2930 | --
|
---|
2931 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2932 | --
|
---|
2933 |
|
---|
2934 | ALTER TABLE oauth_tokens ALTER COLUMN id SET DEFAULT nextval('oauth_tokens_id_seq'::regclass);
|
---|
2935 |
|
---|
2936 |
|
---|
2937 | --
|
---|
2938 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2939 | --
|
---|
2940 |
|
---|
2941 | ALTER TABLE sessions ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
|
---|
2942 |
|
---|
2943 |
|
---|
2944 | --
|
---|
2945 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2946 | --
|
---|
2947 |
|
---|
2948 | ALTER TABLE user_blocks ALTER COLUMN id SET DEFAULT nextval('user_blocks_id_seq'::regclass);
|
---|
2949 |
|
---|
2950 |
|
---|
2951 | --
|
---|
2952 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2953 | --
|
---|
2954 |
|
---|
2955 | ALTER TABLE user_roles ALTER COLUMN id SET DEFAULT nextval('user_roles_id_seq'::regclass);
|
---|
2956 |
|
---|
2957 |
|
---|
2958 | --
|
---|
2959 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2960 | --
|
---|
2961 |
|
---|
2962 | ALTER TABLE user_tokens ALTER COLUMN id SET DEFAULT nextval('user_tokens_id_seq'::regclass);
|
---|
2963 |
|
---|
2964 |
|
---|
2965 | --
|
---|
2966 | -- Name: id; Type: DEFAULT; Schema: public; Owner: -
|
---|
2967 | --
|
---|
2968 |
|
---|
2969 | ALTER TABLE users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
|
---|
2970 |
|
---|
2971 |
|
---|
2972 | --
|
---|
2973 | -- Name: acls_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
2974 | --
|
---|
2975 |
|
---|
2976 | ALTER TABLE ONLY acls
|
---|
2977 | ADD CONSTRAINT acls_pkey PRIMARY KEY (id);
|
---|
2978 |
|
---|
2979 |
|
---|
2980 | --
|
---|
2981 | -- Name: changesets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
2982 | --
|
---|
2983 |
|
---|
2984 | ALTER TABLE ONLY changesets
|
---|
2985 | ADD CONSTRAINT changesets_pkey PRIMARY KEY (id);
|
---|
2986 |
|
---|
2987 |
|
---|
2988 | --
|
---|
2989 | -- Name: client_applications_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
2990 | --
|
---|
2991 |
|
---|
2992 | ALTER TABLE ONLY client_applications
|
---|
2993 | ADD CONSTRAINT client_applications_pkey PRIMARY KEY (id);
|
---|
2994 |
|
---|
2995 |
|
---|
2996 | --
|
---|
2997 | -- Name: countries_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
2998 | --
|
---|
2999 |
|
---|
3000 | ALTER TABLE ONLY countries
|
---|
3001 | ADD CONSTRAINT countries_pkey PRIMARY KEY (id);
|
---|
3002 |
|
---|
3003 |
|
---|
3004 | --
|
---|
3005 | -- Name: current_node_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3006 | --
|
---|
3007 |
|
---|
3008 | ALTER TABLE ONLY current_node_tags
|
---|
3009 | ADD CONSTRAINT current_node_tags_pkey PRIMARY KEY (node_id, k);
|
---|
3010 |
|
---|
3011 |
|
---|
3012 | --
|
---|
3013 | -- Name: current_nodes_pkey1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3014 | --
|
---|
3015 |
|
---|
3016 | ALTER TABLE ONLY current_nodes
|
---|
3017 | ADD CONSTRAINT current_nodes_pkey1 PRIMARY KEY (id);
|
---|
3018 |
|
---|
3019 |
|
---|
3020 | --
|
---|
3021 | -- Name: current_relation_members_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3022 | --
|
---|
3023 |
|
---|
3024 | ALTER TABLE ONLY current_relation_members
|
---|
3025 | ADD CONSTRAINT current_relation_members_pkey PRIMARY KEY (relation_id, member_type, member_id, member_role, sequence_id);
|
---|
3026 |
|
---|
3027 |
|
---|
3028 | --
|
---|
3029 | -- Name: current_relation_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3030 | --
|
---|
3031 |
|
---|
3032 | ALTER TABLE ONLY current_relation_tags
|
---|
3033 | ADD CONSTRAINT current_relation_tags_pkey PRIMARY KEY (relation_id, k);
|
---|
3034 |
|
---|
3035 |
|
---|
3036 | --
|
---|
3037 | -- Name: current_relations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3038 | --
|
---|
3039 |
|
---|
3040 | ALTER TABLE ONLY current_relations
|
---|
3041 | ADD CONSTRAINT current_relations_pkey PRIMARY KEY (id);
|
---|
3042 |
|
---|
3043 |
|
---|
3044 | --
|
---|
3045 | -- Name: current_way_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3046 | --
|
---|
3047 |
|
---|
3048 | ALTER TABLE ONLY current_way_nodes
|
---|
3049 | ADD CONSTRAINT current_way_nodes_pkey PRIMARY KEY (way_id, sequence_id);
|
---|
3050 |
|
---|
3051 |
|
---|
3052 | --
|
---|
3053 | -- Name: current_way_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3054 | --
|
---|
3055 |
|
---|
3056 | ALTER TABLE ONLY current_way_tags
|
---|
3057 | ADD CONSTRAINT current_way_tags_pkey PRIMARY KEY (way_id, k);
|
---|
3058 |
|
---|
3059 |
|
---|
3060 | --
|
---|
3061 | -- Name: current_ways_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3062 | --
|
---|
3063 |
|
---|
3064 | ALTER TABLE ONLY current_ways
|
---|
3065 | ADD CONSTRAINT current_ways_pkey PRIMARY KEY (id);
|
---|
3066 |
|
---|
3067 |
|
---|
3068 | --
|
---|
3069 | -- Name: diary_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3070 | --
|
---|
3071 |
|
---|
3072 | ALTER TABLE ONLY diary_comments
|
---|
3073 | ADD CONSTRAINT diary_comments_pkey PRIMARY KEY (id);
|
---|
3074 |
|
---|
3075 |
|
---|
3076 | --
|
---|
3077 | -- Name: diary_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3078 | --
|
---|
3079 |
|
---|
3080 | ALTER TABLE ONLY diary_entries
|
---|
3081 | ADD CONSTRAINT diary_entries_pkey PRIMARY KEY (id);
|
---|
3082 |
|
---|
3083 |
|
---|
3084 | --
|
---|
3085 | -- Name: friends_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3086 | --
|
---|
3087 |
|
---|
3088 | ALTER TABLE ONLY friends
|
---|
3089 | ADD CONSTRAINT friends_pkey PRIMARY KEY (id);
|
---|
3090 |
|
---|
3091 |
|
---|
3092 | --
|
---|
3093 | -- Name: gpx_file_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3094 | --
|
---|
3095 |
|
---|
3096 | ALTER TABLE ONLY gpx_file_tags
|
---|
3097 | ADD CONSTRAINT gpx_file_tags_pkey PRIMARY KEY (id);
|
---|
3098 |
|
---|
3099 |
|
---|
3100 | --
|
---|
3101 | -- Name: gpx_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3102 | --
|
---|
3103 |
|
---|
3104 | ALTER TABLE ONLY gpx_files
|
---|
3105 | ADD CONSTRAINT gpx_files_pkey PRIMARY KEY (id);
|
---|
3106 |
|
---|
3107 |
|
---|
3108 | --
|
---|
3109 | -- Name: languages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3110 | --
|
---|
3111 |
|
---|
3112 | ALTER TABLE ONLY languages
|
---|
3113 | ADD CONSTRAINT languages_pkey PRIMARY KEY (code);
|
---|
3114 |
|
---|
3115 |
|
---|
3116 | --
|
---|
3117 | -- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3118 | --
|
---|
3119 |
|
---|
3120 | ALTER TABLE ONLY messages
|
---|
3121 | ADD CONSTRAINT messages_pkey PRIMARY KEY (id);
|
---|
3122 |
|
---|
3123 |
|
---|
3124 | --
|
---|
3125 | -- Name: node_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3126 | --
|
---|
3127 |
|
---|
3128 | ALTER TABLE ONLY node_tags
|
---|
3129 | ADD CONSTRAINT node_tags_pkey PRIMARY KEY (node_id, version, k);
|
---|
3130 |
|
---|
3131 |
|
---|
3132 | --
|
---|
3133 | -- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3134 | --
|
---|
3135 |
|
---|
3136 | ALTER TABLE ONLY nodes
|
---|
3137 | ADD CONSTRAINT nodes_pkey PRIMARY KEY (node_id, version);
|
---|
3138 |
|
---|
3139 |
|
---|
3140 | --
|
---|
3141 | -- Name: oauth_nonces_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3142 | --
|
---|
3143 |
|
---|
3144 | ALTER TABLE ONLY oauth_nonces
|
---|
3145 | ADD CONSTRAINT oauth_nonces_pkey PRIMARY KEY (id);
|
---|
3146 |
|
---|
3147 |
|
---|
3148 | --
|
---|
3149 | -- Name: oauth_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3150 | --
|
---|
3151 |
|
---|
3152 | ALTER TABLE ONLY oauth_tokens
|
---|
3153 | ADD CONSTRAINT oauth_tokens_pkey PRIMARY KEY (id);
|
---|
3154 |
|
---|
3155 |
|
---|
3156 | --
|
---|
3157 | -- Name: relation_members_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3158 | --
|
---|
3159 |
|
---|
3160 | ALTER TABLE ONLY relation_members
|
---|
3161 | ADD CONSTRAINT relation_members_pkey PRIMARY KEY (relation_id, version, member_type, member_id, member_role, sequence_id);
|
---|
3162 |
|
---|
3163 |
|
---|
3164 | --
|
---|
3165 | -- Name: relation_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3166 | --
|
---|
3167 |
|
---|
3168 | ALTER TABLE ONLY relation_tags
|
---|
3169 | ADD CONSTRAINT relation_tags_pkey PRIMARY KEY (relation_id, version, k);
|
---|
3170 |
|
---|
3171 |
|
---|
3172 | --
|
---|
3173 | -- Name: relations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3174 | --
|
---|
3175 |
|
---|
3176 | ALTER TABLE ONLY relations
|
---|
3177 | ADD CONSTRAINT relations_pkey PRIMARY KEY (relation_id, version);
|
---|
3178 |
|
---|
3179 |
|
---|
3180 | --
|
---|
3181 | -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3182 | --
|
---|
3183 |
|
---|
3184 | ALTER TABLE ONLY sessions
|
---|
3185 | ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);
|
---|
3186 |
|
---|
3187 |
|
---|
3188 | --
|
---|
3189 | -- Name: user_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3190 | --
|
---|
3191 |
|
---|
3192 | ALTER TABLE ONLY user_blocks
|
---|
3193 | ADD CONSTRAINT user_blocks_pkey PRIMARY KEY (id);
|
---|
3194 |
|
---|
3195 |
|
---|
3196 | --
|
---|
3197 | -- Name: user_preferences_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3198 | --
|
---|
3199 |
|
---|
3200 | ALTER TABLE ONLY user_preferences
|
---|
3201 | ADD CONSTRAINT user_preferences_pkey PRIMARY KEY (user_id, k);
|
---|
3202 |
|
---|
3203 |
|
---|
3204 | --
|
---|
3205 | -- Name: user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3206 | --
|
---|
3207 |
|
---|
3208 | ALTER TABLE ONLY user_roles
|
---|
3209 | ADD CONSTRAINT user_roles_pkey PRIMARY KEY (id);
|
---|
3210 |
|
---|
3211 |
|
---|
3212 | --
|
---|
3213 | -- Name: user_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3214 | --
|
---|
3215 |
|
---|
3216 | ALTER TABLE ONLY user_tokens
|
---|
3217 | ADD CONSTRAINT user_tokens_pkey PRIMARY KEY (id);
|
---|
3218 |
|
---|
3219 |
|
---|
3220 | --
|
---|
3221 | -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3222 | --
|
---|
3223 |
|
---|
3224 | ALTER TABLE ONLY users
|
---|
3225 | ADD CONSTRAINT users_pkey PRIMARY KEY (id);
|
---|
3226 |
|
---|
3227 |
|
---|
3228 | --
|
---|
3229 | -- Name: way_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3230 | --
|
---|
3231 |
|
---|
3232 | ALTER TABLE ONLY way_nodes
|
---|
3233 | ADD CONSTRAINT way_nodes_pkey PRIMARY KEY (way_id, version, sequence_id);
|
---|
3234 |
|
---|
3235 |
|
---|
3236 | --
|
---|
3237 | -- Name: way_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3238 | --
|
---|
3239 |
|
---|
3240 | ALTER TABLE ONLY way_tags
|
---|
3241 | ADD CONSTRAINT way_tags_pkey PRIMARY KEY (way_id, version, k);
|
---|
3242 |
|
---|
3243 |
|
---|
3244 | --
|
---|
3245 | -- Name: ways_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
---|
3246 | --
|
---|
3247 |
|
---|
3248 | ALTER TABLE ONLY ways
|
---|
3249 | ADD CONSTRAINT ways_pkey PRIMARY KEY (way_id, version);
|
---|
3250 |
|
---|
3251 |
|
---|
3252 | --
|
---|
3253 | -- Name: acls_k_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3254 | --
|
---|
3255 |
|
---|
3256 | CREATE INDEX acls_k_idx ON acls USING btree (k);
|
---|
3257 |
|
---|
3258 |
|
---|
3259 | --
|
---|
3260 | -- Name: changeset_tags_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3261 | --
|
---|
3262 |
|
---|
3263 | CREATE INDEX changeset_tags_id_idx ON changeset_tags USING btree (changeset_id);
|
---|
3264 |
|
---|
3265 |
|
---|
3266 | --
|
---|
3267 | -- Name: changesets_bbox_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3268 | --
|
---|
3269 |
|
---|
3270 | CREATE INDEX changesets_bbox_idx ON changesets USING gist (min_lat, max_lat, min_lon, max_lon);
|
---|
3271 |
|
---|
3272 |
|
---|
3273 | --
|
---|
3274 | -- Name: changesets_closed_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3275 | --
|
---|
3276 |
|
---|
3277 | CREATE INDEX changesets_closed_at_idx ON changesets USING btree (closed_at);
|
---|
3278 |
|
---|
3279 |
|
---|
3280 | --
|
---|
3281 | -- Name: changesets_created_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3282 | --
|
---|
3283 |
|
---|
3284 | CREATE INDEX changesets_created_at_idx ON changesets USING btree (created_at);
|
---|
3285 |
|
---|
3286 |
|
---|
3287 | --
|
---|
3288 | -- Name: changesets_user_id_created_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3289 | --
|
---|
3290 |
|
---|
3291 | CREATE INDEX changesets_user_id_created_at_idx ON changesets USING btree (user_id, created_at);
|
---|
3292 |
|
---|
3293 |
|
---|
3294 | --
|
---|
3295 | -- Name: changesets_user_id_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3296 | --
|
---|
3297 |
|
---|
3298 | CREATE INDEX changesets_user_id_id_idx ON changesets USING btree (user_id, id);
|
---|
3299 |
|
---|
3300 |
|
---|
3301 | --
|
---|
3302 | -- Name: countries_code_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3303 | --
|
---|
3304 |
|
---|
3305 | CREATE UNIQUE INDEX countries_code_idx ON countries USING btree (code);
|
---|
3306 |
|
---|
3307 |
|
---|
3308 | --
|
---|
3309 | -- Name: current_nodes_tile_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3310 | --
|
---|
3311 |
|
---|
3312 | CREATE INDEX current_nodes_tile_idx ON current_nodes USING btree (tile);
|
---|
3313 |
|
---|
3314 |
|
---|
3315 | --
|
---|
3316 | -- Name: current_nodes_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3317 | --
|
---|
3318 |
|
---|
3319 | CREATE INDEX current_nodes_timestamp_idx ON current_nodes USING btree ("timestamp");
|
---|
3320 |
|
---|
3321 |
|
---|
3322 | --
|
---|
3323 | -- Name: current_relation_members_member_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3324 | --
|
---|
3325 |
|
---|
3326 | CREATE INDEX current_relation_members_member_idx ON current_relation_members USING btree (member_type, member_id);
|
---|
3327 |
|
---|
3328 |
|
---|
3329 | --
|
---|
3330 | -- Name: current_relation_tags_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3331 | --
|
---|
3332 |
|
---|
3333 | CREATE INDEX current_relation_tags_id_idx ON current_relation_tags USING btree (relation_id);
|
---|
3334 |
|
---|
3335 |
|
---|
3336 | --
|
---|
3337 | -- Name: current_relation_tags_v_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3338 | --
|
---|
3339 |
|
---|
3340 | CREATE INDEX current_relation_tags_v_idx ON current_relation_tags USING btree (v);
|
---|
3341 |
|
---|
3342 |
|
---|
3343 | --
|
---|
3344 | -- Name: current_relations_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3345 | --
|
---|
3346 |
|
---|
3347 | CREATE INDEX current_relations_timestamp_idx ON current_relations USING btree ("timestamp");
|
---|
3348 |
|
---|
3349 |
|
---|
3350 | --
|
---|
3351 | -- Name: current_way_nodes_node_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3352 | --
|
---|
3353 |
|
---|
3354 | CREATE INDEX current_way_nodes_node_idx ON current_way_nodes USING btree (node_id);
|
---|
3355 |
|
---|
3356 |
|
---|
3357 | --
|
---|
3358 | -- Name: current_way_tags_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3359 | --
|
---|
3360 |
|
---|
3361 | CREATE INDEX current_way_tags_id_idx ON current_way_tags USING btree (way_id);
|
---|
3362 |
|
---|
3363 |
|
---|
3364 | --
|
---|
3365 | -- Name: current_way_tags_v_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3366 | --
|
---|
3367 |
|
---|
3368 | CREATE INDEX current_way_tags_v_idx ON current_way_tags USING btree (v);
|
---|
3369 |
|
---|
3370 |
|
---|
3371 | --
|
---|
3372 | -- Name: current_ways_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3373 | --
|
---|
3374 |
|
---|
3375 | CREATE INDEX current_ways_timestamp_idx ON current_ways USING btree ("timestamp");
|
---|
3376 |
|
---|
3377 |
|
---|
3378 | --
|
---|
3379 | -- Name: diary_comment_user_id_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3380 | --
|
---|
3381 |
|
---|
3382 | CREATE INDEX diary_comment_user_id_created_at_index ON diary_comments USING btree (user_id, created_at);
|
---|
3383 |
|
---|
3384 |
|
---|
3385 | --
|
---|
3386 | -- Name: diary_comments_entry_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3387 | --
|
---|
3388 |
|
---|
3389 | CREATE UNIQUE INDEX diary_comments_entry_id_idx ON diary_comments USING btree (diary_entry_id, id);
|
---|
3390 |
|
---|
3391 |
|
---|
3392 | --
|
---|
3393 | -- Name: diary_entry_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3394 | --
|
---|
3395 |
|
---|
3396 | CREATE INDEX diary_entry_created_at_index ON diary_entries USING btree (created_at);
|
---|
3397 |
|
---|
3398 |
|
---|
3399 | --
|
---|
3400 | -- Name: diary_entry_language_code_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3401 | --
|
---|
3402 |
|
---|
3403 | CREATE INDEX diary_entry_language_code_created_at_index ON diary_entries USING btree (language_code, created_at);
|
---|
3404 |
|
---|
3405 |
|
---|
3406 | --
|
---|
3407 | -- Name: diary_entry_user_id_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3408 | --
|
---|
3409 |
|
---|
3410 | CREATE INDEX diary_entry_user_id_created_at_index ON diary_entries USING btree (user_id, created_at);
|
---|
3411 |
|
---|
3412 |
|
---|
3413 | --
|
---|
3414 | -- Name: friends_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3415 | --
|
---|
3416 |
|
---|
3417 | CREATE INDEX friends_user_id_idx ON friends USING btree (user_id);
|
---|
3418 |
|
---|
3419 |
|
---|
3420 | --
|
---|
3421 | -- Name: gpx_file_tags_gpxid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3422 | --
|
---|
3423 |
|
---|
3424 | CREATE INDEX gpx_file_tags_gpxid_idx ON gpx_file_tags USING btree (gpx_id);
|
---|
3425 |
|
---|
3426 |
|
---|
3427 | --
|
---|
3428 | -- Name: gpx_file_tags_tag_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3429 | --
|
---|
3430 |
|
---|
3431 | CREATE INDEX gpx_file_tags_tag_idx ON gpx_file_tags USING btree (tag);
|
---|
3432 |
|
---|
3433 |
|
---|
3434 | --
|
---|
3435 | -- Name: gpx_files_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3436 | --
|
---|
3437 |
|
---|
3438 | CREATE INDEX gpx_files_timestamp_idx ON gpx_files USING btree ("timestamp");
|
---|
3439 |
|
---|
3440 |
|
---|
3441 | --
|
---|
3442 | -- Name: gpx_files_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3443 | --
|
---|
3444 |
|
---|
3445 | CREATE INDEX gpx_files_user_id_idx ON gpx_files USING btree (user_id);
|
---|
3446 |
|
---|
3447 |
|
---|
3448 | --
|
---|
3449 | -- Name: gpx_files_visible_visibility_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3450 | --
|
---|
3451 |
|
---|
3452 | CREATE INDEX gpx_files_visible_visibility_idx ON gpx_files USING btree (visible, visibility);
|
---|
3453 |
|
---|
3454 |
|
---|
3455 | --
|
---|
3456 | -- Name: index_client_applications_on_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3457 | --
|
---|
3458 |
|
---|
3459 | CREATE UNIQUE INDEX index_client_applications_on_key ON client_applications USING btree (key);
|
---|
3460 |
|
---|
3461 |
|
---|
3462 | --
|
---|
3463 | -- Name: index_oauth_nonces_on_nonce_and_timestamp; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3464 | --
|
---|
3465 |
|
---|
3466 | CREATE UNIQUE INDEX index_oauth_nonces_on_nonce_and_timestamp ON oauth_nonces USING btree (nonce, "timestamp");
|
---|
3467 |
|
---|
3468 |
|
---|
3469 | --
|
---|
3470 | -- Name: index_oauth_tokens_on_token; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3471 | --
|
---|
3472 |
|
---|
3473 | CREATE UNIQUE INDEX index_oauth_tokens_on_token ON oauth_tokens USING btree (token);
|
---|
3474 |
|
---|
3475 |
|
---|
3476 | --
|
---|
3477 | -- Name: index_user_blocks_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3478 | --
|
---|
3479 |
|
---|
3480 | CREATE INDEX index_user_blocks_on_user_id ON user_blocks USING btree (user_id);
|
---|
3481 |
|
---|
3482 |
|
---|
3483 | --
|
---|
3484 | -- Name: messages_from_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3485 | --
|
---|
3486 |
|
---|
3487 | CREATE INDEX messages_from_user_id_idx ON messages USING btree (from_user_id);
|
---|
3488 |
|
---|
3489 |
|
---|
3490 | --
|
---|
3491 | -- Name: messages_to_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3492 | --
|
---|
3493 |
|
---|
3494 | CREATE INDEX messages_to_user_id_idx ON messages USING btree (to_user_id);
|
---|
3495 |
|
---|
3496 |
|
---|
3497 | --
|
---|
3498 | -- Name: nodes_changeset_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3499 | --
|
---|
3500 |
|
---|
3501 | CREATE INDEX nodes_changeset_id_idx ON nodes USING btree (changeset_id);
|
---|
3502 |
|
---|
3503 |
|
---|
3504 | --
|
---|
3505 | -- Name: nodes_tile_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3506 | --
|
---|
3507 |
|
---|
3508 | CREATE INDEX nodes_tile_idx ON nodes USING btree (tile);
|
---|
3509 |
|
---|
3510 |
|
---|
3511 | --
|
---|
3512 | -- Name: nodes_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3513 | --
|
---|
3514 |
|
---|
3515 | CREATE INDEX nodes_timestamp_idx ON nodes USING btree ("timestamp");
|
---|
3516 |
|
---|
3517 |
|
---|
3518 | --
|
---|
3519 | -- Name: nodes_uid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3520 | --
|
---|
3521 |
|
---|
3522 | CREATE INDEX nodes_uid_idx ON nodes USING btree (node_id);
|
---|
3523 |
|
---|
3524 |
|
---|
3525 | --
|
---|
3526 | -- Name: points_gpxid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3527 | --
|
---|
3528 |
|
---|
3529 | CREATE INDEX points_gpxid_idx ON gps_points USING btree (gpx_id);
|
---|
3530 |
|
---|
3531 |
|
---|
3532 | --
|
---|
3533 | -- Name: points_tile_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3534 | --
|
---|
3535 |
|
---|
3536 | CREATE INDEX points_tile_idx ON gps_points USING btree (tile);
|
---|
3537 |
|
---|
3538 |
|
---|
3539 | --
|
---|
3540 | -- Name: relation_members_member_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3541 | --
|
---|
3542 |
|
---|
3543 | CREATE INDEX relation_members_member_idx ON relation_members USING btree (member_type, member_id);
|
---|
3544 |
|
---|
3545 |
|
---|
3546 | --
|
---|
3547 | -- Name: relation_tags_id_version_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3548 | --
|
---|
3549 |
|
---|
3550 | CREATE INDEX relation_tags_id_version_idx ON relation_tags USING btree (relation_id, version);
|
---|
3551 |
|
---|
3552 |
|
---|
3553 | --
|
---|
3554 | -- Name: relations_changeset_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3555 | --
|
---|
3556 |
|
---|
3557 | CREATE INDEX relations_changeset_id_idx ON relations USING btree (changeset_id);
|
---|
3558 |
|
---|
3559 |
|
---|
3560 | --
|
---|
3561 | -- Name: relations_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3562 | --
|
---|
3563 |
|
---|
3564 | CREATE INDEX relations_timestamp_idx ON relations USING btree ("timestamp");
|
---|
3565 |
|
---|
3566 |
|
---|
3567 | --
|
---|
3568 | -- Name: sessions_session_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3569 | --
|
---|
3570 |
|
---|
3571 | CREATE UNIQUE INDEX sessions_session_id_idx ON sessions USING btree (session_id);
|
---|
3572 |
|
---|
3573 |
|
---|
3574 | --
|
---|
3575 | -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3576 | --
|
---|
3577 |
|
---|
3578 | CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
|
---|
3579 |
|
---|
3580 |
|
---|
3581 | --
|
---|
3582 | -- Name: user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3583 | --
|
---|
3584 |
|
---|
3585 | CREATE INDEX user_id_idx ON friends USING btree (friend_user_id);
|
---|
3586 |
|
---|
3587 |
|
---|
3588 | --
|
---|
3589 | -- Name: user_openid_url_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3590 | --
|
---|
3591 |
|
---|
3592 | CREATE UNIQUE INDEX user_openid_url_idx ON users USING btree (openid_url);
|
---|
3593 |
|
---|
3594 |
|
---|
3595 | --
|
---|
3596 | -- Name: user_roles_id_role_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3597 | --
|
---|
3598 |
|
---|
3599 | CREATE UNIQUE INDEX user_roles_id_role_unique ON user_roles USING btree (user_id, role);
|
---|
3600 |
|
---|
3601 |
|
---|
3602 | --
|
---|
3603 | -- Name: user_tokens_token_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3604 | --
|
---|
3605 |
|
---|
3606 | CREATE UNIQUE INDEX user_tokens_token_idx ON user_tokens USING btree (token);
|
---|
3607 |
|
---|
3608 |
|
---|
3609 | --
|
---|
3610 | -- Name: user_tokens_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3611 | --
|
---|
3612 |
|
---|
3613 | CREATE INDEX user_tokens_user_id_idx ON user_tokens USING btree (user_id);
|
---|
3614 |
|
---|
3615 |
|
---|
3616 | --
|
---|
3617 | -- Name: users_display_name_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3618 | --
|
---|
3619 |
|
---|
3620 | CREATE UNIQUE INDEX users_display_name_idx ON users USING btree (display_name);
|
---|
3621 |
|
---|
3622 |
|
---|
3623 | --
|
---|
3624 | -- Name: users_email_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3625 | --
|
---|
3626 |
|
---|
3627 | CREATE UNIQUE INDEX users_email_idx ON users USING btree (email);
|
---|
3628 |
|
---|
3629 |
|
---|
3630 | --
|
---|
3631 | -- Name: way_nodes_node_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3632 | --
|
---|
3633 |
|
---|
3634 | CREATE INDEX way_nodes_node_idx ON way_nodes USING btree (node_id);
|
---|
3635 |
|
---|
3636 |
|
---|
3637 | --
|
---|
3638 | -- Name: way_tags_id_version_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3639 | --
|
---|
3640 |
|
---|
3641 | CREATE INDEX way_tags_id_version_idx ON way_tags USING btree (way_id, version);
|
---|
3642 |
|
---|
3643 |
|
---|
3644 | --
|
---|
3645 | -- Name: ways_changeset_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3646 | --
|
---|
3647 |
|
---|
3648 | CREATE INDEX ways_changeset_id_idx ON ways USING btree (changeset_id);
|
---|
3649 |
|
---|
3650 |
|
---|
3651 | --
|
---|
3652 | -- Name: ways_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
---|
3653 | --
|
---|
3654 |
|
---|
3655 | CREATE INDEX ways_timestamp_idx ON ways USING btree ("timestamp");
|
---|
3656 |
|
---|
3657 |
|
---|
3658 | --
|
---|
3659 | -- Name: changeset_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3660 | --
|
---|
3661 |
|
---|
3662 | ALTER TABLE ONLY changeset_tags
|
---|
3663 | ADD CONSTRAINT changeset_tags_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
|
---|
3664 |
|
---|
3665 |
|
---|
3666 | --
|
---|
3667 | -- Name: changesets_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3668 | --
|
---|
3669 |
|
---|
3670 | ALTER TABLE ONLY changesets
|
---|
3671 | ADD CONSTRAINT changesets_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3672 |
|
---|
3673 |
|
---|
3674 | --
|
---|
3675 | -- Name: client_applications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3676 | --
|
---|
3677 |
|
---|
3678 | ALTER TABLE ONLY client_applications
|
---|
3679 | ADD CONSTRAINT client_applications_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3680 |
|
---|
3681 |
|
---|
3682 | --
|
---|
3683 | -- Name: current_node_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3684 | --
|
---|
3685 |
|
---|
3686 | ALTER TABLE ONLY current_node_tags
|
---|
3687 | ADD CONSTRAINT current_node_tags_id_fkey FOREIGN KEY (node_id) REFERENCES current_nodes(id);
|
---|
3688 |
|
---|
3689 |
|
---|
3690 | --
|
---|
3691 | -- Name: current_nodes_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3692 | --
|
---|
3693 |
|
---|
3694 | ALTER TABLE ONLY current_nodes
|
---|
3695 | ADD CONSTRAINT current_nodes_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
|
---|
3696 |
|
---|
3697 |
|
---|
3698 | --
|
---|
3699 | -- Name: current_relation_members_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3700 | --
|
---|
3701 |
|
---|
3702 | ALTER TABLE ONLY current_relation_members
|
---|
3703 | ADD CONSTRAINT current_relation_members_id_fkey FOREIGN KEY (relation_id) REFERENCES current_relations(id);
|
---|
3704 |
|
---|
3705 |
|
---|
3706 | --
|
---|
3707 | -- Name: current_relation_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3708 | --
|
---|
3709 |
|
---|
3710 | ALTER TABLE ONLY current_relation_tags
|
---|
3711 | ADD CONSTRAINT current_relation_tags_id_fkey FOREIGN KEY (relation_id) REFERENCES current_relations(id);
|
---|
3712 |
|
---|
3713 |
|
---|
3714 | --
|
---|
3715 | -- Name: current_relations_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3716 | --
|
---|
3717 |
|
---|
3718 | ALTER TABLE ONLY current_relations
|
---|
3719 | ADD CONSTRAINT current_relations_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
|
---|
3720 |
|
---|
3721 |
|
---|
3722 | --
|
---|
3723 | -- Name: current_way_nodes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3724 | --
|
---|
3725 |
|
---|
3726 | ALTER TABLE ONLY current_way_nodes
|
---|
3727 | ADD CONSTRAINT current_way_nodes_id_fkey FOREIGN KEY (way_id) REFERENCES current_ways(id);
|
---|
3728 |
|
---|
3729 |
|
---|
3730 | --
|
---|
3731 | -- Name: current_way_nodes_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3732 | --
|
---|
3733 |
|
---|
3734 | ALTER TABLE ONLY current_way_nodes
|
---|
3735 | ADD CONSTRAINT current_way_nodes_node_id_fkey FOREIGN KEY (node_id) REFERENCES current_nodes(id);
|
---|
3736 |
|
---|
3737 |
|
---|
3738 | --
|
---|
3739 | -- Name: current_way_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3740 | --
|
---|
3741 |
|
---|
3742 | ALTER TABLE ONLY current_way_tags
|
---|
3743 | ADD CONSTRAINT current_way_tags_id_fkey FOREIGN KEY (way_id) REFERENCES current_ways(id);
|
---|
3744 |
|
---|
3745 |
|
---|
3746 | --
|
---|
3747 | -- Name: current_ways_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3748 | --
|
---|
3749 |
|
---|
3750 | ALTER TABLE ONLY current_ways
|
---|
3751 | ADD CONSTRAINT current_ways_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
|
---|
3752 |
|
---|
3753 |
|
---|
3754 | --
|
---|
3755 | -- Name: diary_comments_diary_entry_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3756 | --
|
---|
3757 |
|
---|
3758 | ALTER TABLE ONLY diary_comments
|
---|
3759 | ADD CONSTRAINT diary_comments_diary_entry_id_fkey FOREIGN KEY (diary_entry_id) REFERENCES diary_entries(id);
|
---|
3760 |
|
---|
3761 |
|
---|
3762 | --
|
---|
3763 | -- Name: diary_comments_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3764 | --
|
---|
3765 |
|
---|
3766 | ALTER TABLE ONLY diary_comments
|
---|
3767 | ADD CONSTRAINT diary_comments_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3768 |
|
---|
3769 |
|
---|
3770 | --
|
---|
3771 | -- Name: diary_entries_language_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3772 | --
|
---|
3773 |
|
---|
3774 | ALTER TABLE ONLY diary_entries
|
---|
3775 | ADD CONSTRAINT diary_entries_language_code_fkey FOREIGN KEY (language_code) REFERENCES languages(code);
|
---|
3776 |
|
---|
3777 |
|
---|
3778 | --
|
---|
3779 | -- Name: diary_entries_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3780 | --
|
---|
3781 |
|
---|
3782 | ALTER TABLE ONLY diary_entries
|
---|
3783 | ADD CONSTRAINT diary_entries_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3784 |
|
---|
3785 |
|
---|
3786 | --
|
---|
3787 | -- Name: friends_friend_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3788 | --
|
---|
3789 |
|
---|
3790 | ALTER TABLE ONLY friends
|
---|
3791 | ADD CONSTRAINT friends_friend_user_id_fkey FOREIGN KEY (friend_user_id) REFERENCES users(id);
|
---|
3792 |
|
---|
3793 |
|
---|
3794 | --
|
---|
3795 | -- Name: friends_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3796 | --
|
---|
3797 |
|
---|
3798 | ALTER TABLE ONLY friends
|
---|
3799 | ADD CONSTRAINT friends_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3800 |
|
---|
3801 |
|
---|
3802 | --
|
---|
3803 | -- Name: gps_points_gpx_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3804 | --
|
---|
3805 |
|
---|
3806 | ALTER TABLE ONLY gps_points
|
---|
3807 | ADD CONSTRAINT gps_points_gpx_id_fkey FOREIGN KEY (gpx_id) REFERENCES gpx_files(id);
|
---|
3808 |
|
---|
3809 |
|
---|
3810 | --
|
---|
3811 | -- Name: gpx_file_tags_gpx_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3812 | --
|
---|
3813 |
|
---|
3814 | ALTER TABLE ONLY gpx_file_tags
|
---|
3815 | ADD CONSTRAINT gpx_file_tags_gpx_id_fkey FOREIGN KEY (gpx_id) REFERENCES gpx_files(id);
|
---|
3816 |
|
---|
3817 |
|
---|
3818 | --
|
---|
3819 | -- Name: gpx_files_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3820 | --
|
---|
3821 |
|
---|
3822 | ALTER TABLE ONLY gpx_files
|
---|
3823 | ADD CONSTRAINT gpx_files_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3824 |
|
---|
3825 |
|
---|
3826 | --
|
---|
3827 | -- Name: messages_from_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3828 | --
|
---|
3829 |
|
---|
3830 | ALTER TABLE ONLY messages
|
---|
3831 | ADD CONSTRAINT messages_from_user_id_fkey FOREIGN KEY (from_user_id) REFERENCES users(id);
|
---|
3832 |
|
---|
3833 |
|
---|
3834 | --
|
---|
3835 | -- Name: messages_to_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3836 | --
|
---|
3837 |
|
---|
3838 | ALTER TABLE ONLY messages
|
---|
3839 | ADD CONSTRAINT messages_to_user_id_fkey FOREIGN KEY (to_user_id) REFERENCES users(id);
|
---|
3840 |
|
---|
3841 |
|
---|
3842 | --
|
---|
3843 | -- Name: node_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3844 | --
|
---|
3845 |
|
---|
3846 | ALTER TABLE ONLY node_tags
|
---|
3847 | ADD CONSTRAINT node_tags_id_fkey FOREIGN KEY (node_id, version) REFERENCES nodes(node_id, version);
|
---|
3848 |
|
---|
3849 |
|
---|
3850 | --
|
---|
3851 | -- Name: nodes_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3852 | --
|
---|
3853 |
|
---|
3854 | ALTER TABLE ONLY nodes
|
---|
3855 | ADD CONSTRAINT nodes_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
|
---|
3856 |
|
---|
3857 |
|
---|
3858 | --
|
---|
3859 | -- Name: oauth_tokens_client_application_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3860 | --
|
---|
3861 |
|
---|
3862 | ALTER TABLE ONLY oauth_tokens
|
---|
3863 | ADD CONSTRAINT oauth_tokens_client_application_id_fkey FOREIGN KEY (client_application_id) REFERENCES client_applications(id);
|
---|
3864 |
|
---|
3865 |
|
---|
3866 | --
|
---|
3867 | -- Name: oauth_tokens_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3868 | --
|
---|
3869 |
|
---|
3870 | ALTER TABLE ONLY oauth_tokens
|
---|
3871 | ADD CONSTRAINT oauth_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3872 |
|
---|
3873 |
|
---|
3874 | --
|
---|
3875 | -- Name: relation_members_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3876 | --
|
---|
3877 |
|
---|
3878 | ALTER TABLE ONLY relation_members
|
---|
3879 | ADD CONSTRAINT relation_members_id_fkey FOREIGN KEY (relation_id, version) REFERENCES relations(relation_id, version);
|
---|
3880 |
|
---|
3881 |
|
---|
3882 | --
|
---|
3883 | -- Name: relation_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3884 | --
|
---|
3885 |
|
---|
3886 | ALTER TABLE ONLY relation_tags
|
---|
3887 | ADD CONSTRAINT relation_tags_id_fkey FOREIGN KEY (relation_id, version) REFERENCES relations(relation_id, version);
|
---|
3888 |
|
---|
3889 |
|
---|
3890 | --
|
---|
3891 | -- Name: relations_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3892 | --
|
---|
3893 |
|
---|
3894 | ALTER TABLE ONLY relations
|
---|
3895 | ADD CONSTRAINT relations_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
|
---|
3896 |
|
---|
3897 |
|
---|
3898 | --
|
---|
3899 | -- Name: user_blocks_moderator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3900 | --
|
---|
3901 |
|
---|
3902 | ALTER TABLE ONLY user_blocks
|
---|
3903 | ADD CONSTRAINT user_blocks_moderator_id_fkey FOREIGN KEY (creator_id) REFERENCES users(id);
|
---|
3904 |
|
---|
3905 |
|
---|
3906 | --
|
---|
3907 | -- Name: user_blocks_revoker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3908 | --
|
---|
3909 |
|
---|
3910 | ALTER TABLE ONLY user_blocks
|
---|
3911 | ADD CONSTRAINT user_blocks_revoker_id_fkey FOREIGN KEY (revoker_id) REFERENCES users(id);
|
---|
3912 |
|
---|
3913 |
|
---|
3914 | --
|
---|
3915 | -- Name: user_blocks_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3916 | --
|
---|
3917 |
|
---|
3918 | ALTER TABLE ONLY user_blocks
|
---|
3919 | ADD CONSTRAINT user_blocks_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3920 |
|
---|
3921 |
|
---|
3922 | --
|
---|
3923 | -- Name: user_preferences_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3924 | --
|
---|
3925 |
|
---|
3926 | ALTER TABLE ONLY user_preferences
|
---|
3927 | ADD CONSTRAINT user_preferences_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3928 |
|
---|
3929 |
|
---|
3930 | --
|
---|
3931 | -- Name: user_roles_granter_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3932 | --
|
---|
3933 |
|
---|
3934 | ALTER TABLE ONLY user_roles
|
---|
3935 | ADD CONSTRAINT user_roles_granter_id_fkey FOREIGN KEY (granter_id) REFERENCES users(id);
|
---|
3936 |
|
---|
3937 |
|
---|
3938 | --
|
---|
3939 | -- Name: user_roles_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3940 | --
|
---|
3941 |
|
---|
3942 | ALTER TABLE ONLY user_roles
|
---|
3943 | ADD CONSTRAINT user_roles_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3944 |
|
---|
3945 |
|
---|
3946 | --
|
---|
3947 | -- Name: user_tokens_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3948 | --
|
---|
3949 |
|
---|
3950 | ALTER TABLE ONLY user_tokens
|
---|
3951 | ADD CONSTRAINT user_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
|
---|
3952 |
|
---|
3953 |
|
---|
3954 | --
|
---|
3955 | -- Name: way_nodes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3956 | --
|
---|
3957 |
|
---|
3958 | ALTER TABLE ONLY way_nodes
|
---|
3959 | ADD CONSTRAINT way_nodes_id_fkey FOREIGN KEY (way_id, version) REFERENCES ways(way_id, version);
|
---|
3960 |
|
---|
3961 |
|
---|
3962 | --
|
---|
3963 | -- Name: way_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3964 | --
|
---|
3965 |
|
---|
3966 | ALTER TABLE ONLY way_tags
|
---|
3967 | ADD CONSTRAINT way_tags_id_fkey FOREIGN KEY (way_id, version) REFERENCES ways(way_id, version);
|
---|
3968 |
|
---|
3969 |
|
---|
3970 | --
|
---|
3971 | -- Name: ways_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
---|
3972 | --
|
---|
3973 |
|
---|
3974 | ALTER TABLE ONLY ways
|
---|
3975 | ADD CONSTRAINT ways_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
|
---|
3976 |
|
---|
3977 |
|
---|
3978 | --
|
---|
3979 | -- PostgreSQL database dump complete
|
---|
3980 | --
|
---|
3981 |
|
---|
3982 | INSERT INTO schema_migrations (version) VALUES ('1');
|
---|
3983 |
|
---|
3984 | INSERT INTO schema_migrations (version) VALUES ('2');
|
---|
3985 |
|
---|
3986 | INSERT INTO schema_migrations (version) VALUES ('3');
|
---|
3987 |
|
---|
3988 | INSERT INTO schema_migrations (version) VALUES ('4');
|
---|
3989 |
|
---|
3990 | INSERT INTO schema_migrations (version) VALUES ('5');
|
---|
3991 |
|
---|
3992 | INSERT INTO schema_migrations (version) VALUES ('6');
|
---|
3993 |
|
---|
3994 | INSERT INTO schema_migrations (version) VALUES ('7');
|
---|
3995 |
|
---|
3996 | INSERT INTO schema_migrations (version) VALUES ('8');
|
---|
3997 |
|
---|
3998 | INSERT INTO schema_migrations (version) VALUES ('9');
|
---|
3999 |
|
---|
4000 | INSERT INTO schema_migrations (version) VALUES ('10');
|
---|
4001 |
|
---|
4002 | INSERT INTO schema_migrations (version) VALUES ('11');
|
---|
4003 |
|
---|
4004 | INSERT INTO schema_migrations (version) VALUES ('12');
|
---|
4005 |
|
---|
4006 | INSERT INTO schema_migrations (version) VALUES ('13');
|
---|
4007 |
|
---|
4008 | INSERT INTO schema_migrations (version) VALUES ('14');
|
---|
4009 |
|
---|
4010 | INSERT INTO schema_migrations (version) VALUES ('15');
|
---|
4011 |
|
---|
4012 | INSERT INTO schema_migrations (version) VALUES ('16');
|
---|
4013 |
|
---|
4014 | INSERT INTO schema_migrations (version) VALUES ('17');
|
---|
4015 |
|
---|
4016 | INSERT INTO schema_migrations (version) VALUES ('18');
|
---|
4017 |
|
---|
4018 | INSERT INTO schema_migrations (version) VALUES ('19');
|
---|
4019 |
|
---|
4020 | INSERT INTO schema_migrations (version) VALUES ('20');
|
---|
4021 |
|
---|
4022 | INSERT INTO schema_migrations (version) VALUES ('21');
|
---|
4023 |
|
---|
4024 | INSERT INTO schema_migrations (version) VALUES ('22');
|
---|
4025 |
|
---|
4026 | INSERT INTO schema_migrations (version) VALUES ('23');
|
---|
4027 |
|
---|
4028 | INSERT INTO schema_migrations (version) VALUES ('24');
|
---|
4029 |
|
---|
4030 | INSERT INTO schema_migrations (version) VALUES ('25');
|
---|
4031 |
|
---|
4032 | INSERT INTO schema_migrations (version) VALUES ('26');
|
---|
4033 |
|
---|
4034 | INSERT INTO schema_migrations (version) VALUES ('27');
|
---|
4035 |
|
---|
4036 | INSERT INTO schema_migrations (version) VALUES ('28');
|
---|
4037 |
|
---|
4038 | INSERT INTO schema_migrations (version) VALUES ('29');
|
---|
4039 |
|
---|
4040 | INSERT INTO schema_migrations (version) VALUES ('30');
|
---|
4041 |
|
---|
4042 | INSERT INTO schema_migrations (version) VALUES ('31');
|
---|
4043 |
|
---|
4044 | INSERT INTO schema_migrations (version) VALUES ('32');
|
---|
4045 |
|
---|
4046 | INSERT INTO schema_migrations (version) VALUES ('33');
|
---|
4047 |
|
---|
4048 | INSERT INTO schema_migrations (version) VALUES ('34');
|
---|
4049 |
|
---|
4050 | INSERT INTO schema_migrations (version) VALUES ('35');
|
---|
4051 |
|
---|
4052 | INSERT INTO schema_migrations (version) VALUES ('36');
|
---|
4053 |
|
---|
4054 | INSERT INTO schema_migrations (version) VALUES ('37');
|
---|
4055 |
|
---|
4056 | INSERT INTO schema_migrations (version) VALUES ('38');
|
---|
4057 |
|
---|
4058 | INSERT INTO schema_migrations (version) VALUES ('39');
|
---|
4059 |
|
---|
4060 | INSERT INTO schema_migrations (version) VALUES ('40');
|
---|
4061 |
|
---|
4062 | INSERT INTO schema_migrations (version) VALUES ('41');
|
---|
4063 |
|
---|
4064 | INSERT INTO schema_migrations (version) VALUES ('42');
|
---|
4065 |
|
---|
4066 | INSERT INTO schema_migrations (version) VALUES ('43');
|
---|
4067 |
|
---|
4068 | INSERT INTO schema_migrations (version) VALUES ('44');
|
---|
4069 |
|
---|
4070 | INSERT INTO schema_migrations (version) VALUES ('45');
|
---|
4071 |
|
---|
4072 | INSERT INTO schema_migrations (version) VALUES ('46');
|
---|
4073 |
|
---|
4074 | INSERT INTO schema_migrations (version) VALUES ('47');
|
---|
4075 |
|
---|
4076 | INSERT INTO schema_migrations (version) VALUES ('48');
|
---|
4077 |
|
---|
4078 | INSERT INTO schema_migrations (version) VALUES ('49');
|
---|
4079 |
|
---|
4080 | INSERT INTO schema_migrations (version) VALUES ('50');
|
---|
4081 |
|
---|
4082 | INSERT INTO schema_migrations (version) VALUES ('51');
|
---|
4083 |
|
---|
4084 | INSERT INTO schema_migrations (version) VALUES ('52');
|
---|
4085 |
|
---|
4086 | INSERT INTO schema_migrations (version) VALUES ('20100513171259');
|
---|
4087 |
|
---|
4088 | INSERT INTO schema_migrations (version) VALUES ('20100910084426');
|
---|
4089 |
|
---|
4090 | INSERT INTO schema_migrations (version) VALUES ('20101114011429');
|
---|
4091 |
|
---|
4092 | INSERT INTO schema_migrations (version) VALUES ('20110322001319');
|
---|
4093 |
|
---|
4094 | INSERT INTO schema_migrations (version) VALUES ('20100516124737');
|
---|
4095 |
|
---|
4096 | INSERT INTO schema_migrations (version) VALUES ('20110925112722'); |
---|