1 |
dpavlin |
1.1 |
-- |
2 |
|
|
-- Selected TOC Entries: |
3 |
|
|
-- |
4 |
|
|
\connect - postgres |
5 |
|
|
-- |
6 |
|
|
-- TOC Entry ID 47 (OID 18720) |
7 |
|
|
-- |
8 |
|
|
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres |
9 |
|
|
-- |
10 |
|
|
|
11 |
|
|
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C'; |
12 |
|
|
|
13 |
|
|
-- |
14 |
|
|
-- TOC Entry ID 48 (OID 18721) |
15 |
|
|
-- |
16 |
|
|
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: |
17 |
|
|
-- |
18 |
|
|
|
19 |
|
|
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; |
20 |
|
|
|
21 |
|
|
\connect - dpavlin |
22 |
|
|
-- |
23 |
|
|
-- TOC Entry ID 2 (OID 158031) |
24 |
|
|
-- |
25 |
|
|
-- Name: news_id_seq Type: SEQUENCE Owner: dpavlin |
26 |
|
|
-- |
27 |
|
|
|
28 |
|
|
CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 51 ; |
29 |
|
|
|
30 |
|
|
-- |
31 |
|
|
-- TOC Entry ID 3 (OID 158050) |
32 |
|
|
-- |
33 |
|
|
-- Name: sections_id_seq Type: SEQUENCE Owner: dpavlin |
34 |
|
|
-- |
35 |
|
|
|
36 |
|
|
CREATE SEQUENCE "sections_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
37 |
|
|
|
38 |
|
|
-- |
39 |
|
|
-- TOC Entry ID 4 (OID 158069) |
40 |
|
|
-- |
41 |
|
|
-- Name: paragraphs_id_seq Type: SEQUENCE Owner: dpavlin |
42 |
|
|
-- |
43 |
|
|
|
44 |
|
|
CREATE SEQUENCE "paragraphs_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
45 |
|
|
|
46 |
|
|
-- |
47 |
|
|
-- TOC Entry ID 5 (OID 158088) |
48 |
|
|
-- |
49 |
|
|
-- Name: community_picseq Type: SEQUENCE Owner: dpavlin |
50 |
|
|
-- |
51 |
|
|
|
52 |
|
|
CREATE SEQUENCE "community_picseq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
53 |
|
|
|
54 |
|
|
-- |
55 |
|
|
-- TOC Entry ID 6 (OID 158107) |
56 |
|
|
-- |
57 |
|
|
-- Name: picseq Type: SEQUENCE Owner: dpavlin |
58 |
|
|
-- |
59 |
|
|
|
60 |
|
|
CREATE SEQUENCE "picseq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
61 |
|
|
|
62 |
|
|
-- |
63 |
|
|
-- TOC Entry ID 7 (OID 158126) |
64 |
|
|
-- |
65 |
|
|
-- Name: analysts_num_seq Type: SEQUENCE Owner: dpavlin |
66 |
|
|
-- |
67 |
|
|
|
68 |
|
|
CREATE SEQUENCE "analysts_num_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
69 |
|
|
|
70 |
|
|
-- |
71 |
|
|
-- TOC Entry ID 8 (OID 158145) |
72 |
|
|
-- |
73 |
|
|
-- Name: open_position_locations_id_seq Type: SEQUENCE Owner: dpavlin |
74 |
|
|
-- |
75 |
|
|
|
76 |
|
|
CREATE SEQUENCE "open_position_locations_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
77 |
|
|
|
78 |
|
|
-- |
79 |
|
|
-- TOC Entry ID 9 (OID 158164) |
80 |
|
|
-- |
81 |
|
|
-- Name: open_positions_num_seq Type: SEQUENCE Owner: dpavlin |
82 |
|
|
-- |
83 |
|
|
|
84 |
|
|
CREATE SEQUENCE "open_positions_num_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
85 |
|
|
|
86 |
|
|
-- |
87 |
|
|
-- TOC Entry ID 10 (OID 158183) |
88 |
|
|
-- |
89 |
|
|
-- Name: products Type: TABLE Owner: dpavlin |
90 |
|
|
-- |
91 |
|
|
|
92 |
|
|
CREATE TABLE "products" ( |
93 |
|
|
"brand" character varying(200), |
94 |
|
|
"form" character varying(200), |
95 |
|
|
"generic" character varying(200), |
96 |
|
|
"description" text, |
97 |
|
|
"type" character varying(4), |
98 |
|
|
"atc" text, |
99 |
|
|
"town" text, |
100 |
|
|
"smpc" integer, |
101 |
|
|
"have_smpc" boolean DEFAULT 'f', |
102 |
|
|
"tm" text, |
103 |
|
|
CONSTRAINT "products_brand" CHECK (((brand <> ''::"varchar") AND (brand NOTNULL))) |
104 |
|
|
); |
105 |
|
|
|
106 |
|
|
-- |
107 |
|
|
-- TOC Entry ID 11 (OID 158219) |
108 |
|
|
-- |
109 |
|
|
-- Name: menu Type: TABLE Owner: dpavlin |
110 |
|
|
-- |
111 |
|
|
|
112 |
|
|
CREATE TABLE "menu" ( |
113 |
|
|
"section" text, |
114 |
|
|
"item" text, |
115 |
|
|
"url" text, |
116 |
|
|
"file" text, |
117 |
|
|
"num" integer DEFAULT 0 |
118 |
|
|
); |
119 |
|
|
|
120 |
|
|
-- |
121 |
|
|
-- TOC Entry ID 12 (OID 158249) |
122 |
|
|
-- |
123 |
|
|
-- Name: worldwide Type: TABLE Owner: dpavlin |
124 |
|
|
-- |
125 |
|
|
|
126 |
|
|
CREATE TABLE "worldwide" ( |
127 |
|
|
"num" integer, |
128 |
|
|
"name" text, |
129 |
|
|
"type" text, |
130 |
|
|
"note" text, |
131 |
|
|
"street" text, |
132 |
|
|
"town" text, |
133 |
|
|
"country" text, |
134 |
|
|
"phone" text, |
135 |
|
|
"fax" text, |
136 |
|
|
"email" text, |
137 |
|
|
"website" text |
138 |
|
|
); |
139 |
|
|
|
140 |
|
|
-- |
141 |
|
|
-- TOC Entry ID 13 (OID 158324) |
142 |
|
|
-- |
143 |
|
|
-- Name: sections Type: TABLE Owner: dpavlin |
144 |
|
|
-- |
145 |
|
|
|
146 |
|
|
CREATE TABLE "sections" ( |
147 |
|
|
"id" integer DEFAULT nextval('sections_id_seq'::text) NOT NULL, |
148 |
|
|
"section" double precision, |
149 |
|
|
"title" text |
150 |
|
|
); |
151 |
|
|
|
152 |
|
|
-- |
153 |
|
|
-- TOC Entry ID 14 (OID 158352) |
154 |
|
|
-- |
155 |
|
|
-- Name: paragraphs Type: TABLE Owner: dpavlin |
156 |
|
|
-- |
157 |
|
|
|
158 |
|
|
CREATE TABLE "paragraphs" ( |
159 |
|
|
"id" integer DEFAULT nextval('paragraphs_id_seq'::text) NOT NULL, |
160 |
|
|
"smpc" integer NOT NULL, |
161 |
|
|
"section_id" integer NOT NULL, |
162 |
|
|
"html" boolean, |
163 |
|
|
"body" text |
164 |
|
|
); |
165 |
|
|
|
166 |
|
|
-- |
167 |
|
|
-- TOC Entry ID 15 (OID 158382) |
168 |
|
|
-- |
169 |
|
|
-- Name: emails Type: TABLE Owner: dpavlin |
170 |
|
|
-- |
171 |
|
|
|
172 |
|
|
CREATE TABLE "emails" ( |
173 |
|
|
"referer" text, |
174 |
|
|
"email" text |
175 |
|
|
); |
176 |
|
|
|
177 |
|
|
-- |
178 |
|
|
-- TOC Entry ID 16 (OID 158408) |
179 |
|
|
-- |
180 |
|
|
-- Name: history Type: TABLE Owner: dpavlin |
181 |
|
|
-- |
182 |
|
|
|
183 |
|
|
CREATE TABLE "history" ( |
184 |
|
|
"num" integer NOT NULL, |
185 |
|
|
"year" character varying(100), |
186 |
|
|
"description" text |
187 |
|
|
); |
188 |
|
|
|
189 |
|
|
-- |
190 |
|
|
-- TOC Entry ID 17 (OID 158435) |
191 |
|
|
-- |
192 |
|
|
-- Name: countries Type: TABLE Owner: dpavlin |
193 |
|
|
-- |
194 |
|
|
|
195 |
|
|
CREATE TABLE "countries" ( |
196 |
|
|
"iso" character varying(2), |
197 |
|
|
"name" text |
198 |
|
|
); |
199 |
|
|
|
200 |
|
|
-- |
201 |
|
|
-- TOC Entry ID 18 (OID 158461) |
202 |
|
|
-- |
203 |
|
|
-- Name: stocks Type: TABLE Owner: dpavlin |
204 |
|
|
-- |
205 |
|
|
|
206 |
|
|
CREATE TABLE "stocks" ( |
207 |
|
|
"date" timestamp with time zone, |
208 |
|
|
"type" character varying(10), |
209 |
|
|
"current" double precision, |
210 |
|
|
"change" double precision, |
211 |
|
|
"high" double precision, |
212 |
|
|
"low" double precision, |
213 |
|
|
"open" double precision, |
214 |
|
|
"insert_date" timestamp with time zone DEFAULT now() |
215 |
|
|
); |
216 |
|
|
|
217 |
|
|
-- |
218 |
|
|
-- TOC Entry ID 19 (OID 158479) |
219 |
|
|
-- |
220 |
|
|
-- Name: vet_type Type: TABLE Owner: dpavlin |
221 |
|
|
-- |
222 |
|
|
|
223 |
|
|
CREATE TABLE "vet_type" ( |
224 |
|
|
"type" character varying(2) NOT NULL, |
225 |
|
|
"description" text |
226 |
|
|
); |
227 |
|
|
|
228 |
|
|
-- |
229 |
|
|
-- TOC Entry ID 20 (OID 158505) |
230 |
|
|
-- |
231 |
|
|
-- Name: vet_animal Type: TABLE Owner: dpavlin |
232 |
|
|
-- |
233 |
|
|
|
234 |
|
|
CREATE TABLE "vet_animal" ( |
235 |
|
|
"animal" character varying(2) NOT NULL, |
236 |
|
|
"name" text |
237 |
|
|
); |
238 |
|
|
|
239 |
|
|
-- |
240 |
|
|
-- TOC Entry ID 21 (OID 158531) |
241 |
|
|
-- |
242 |
|
|
-- Name: vet_products Type: TABLE Owner: dpavlin |
243 |
|
|
-- |
244 |
|
|
|
245 |
|
|
CREATE TABLE "vet_products" ( |
246 |
|
|
"brand" text, |
247 |
|
|
"form" text, |
248 |
|
|
"composition" text, |
249 |
|
|
"description" text, |
250 |
|
|
"smpc" integer NOT NULL, |
251 |
|
|
"type" character varying(2) NOT NULL, |
252 |
|
|
"have_smpc" boolean, |
253 |
|
|
CONSTRAINT "vet_products_brand" CHECK (((brand <> ''::text) AND (brand NOTNULL))) |
254 |
|
|
); |
255 |
|
|
|
256 |
|
|
-- |
257 |
|
|
-- TOC Entry ID 22 (OID 158563) |
258 |
|
|
-- |
259 |
|
|
-- Name: vet_animal_product Type: TABLE Owner: dpavlin |
260 |
|
|
-- |
261 |
|
|
|
262 |
|
|
CREATE TABLE "vet_animal_product" ( |
263 |
|
|
"animal" character varying(2) NOT NULL, |
264 |
|
|
"smpc" integer NOT NULL |
265 |
|
|
); |
266 |
|
|
|
267 |
|
|
-- |
268 |
|
|
-- TOC Entry ID 23 (OID 158574) |
269 |
|
|
-- |
270 |
|
|
-- Name: wap_ua Type: TABLE Owner: dpavlin |
271 |
|
|
-- |
272 |
|
|
|
273 |
|
|
CREATE TABLE "wap_ua" ( |
274 |
|
|
"ua" text, |
275 |
|
|
"referer" text, |
276 |
|
|
"url" text, |
277 |
|
|
"accept" text, |
278 |
|
|
"date" timestamp with time zone DEFAULT now() |
279 |
|
|
); |
280 |
|
|
|
281 |
|
|
-- |
282 |
|
|
-- TOC Entry ID 24 (OID 158604) |
283 |
|
|
-- |
284 |
|
|
-- Name: prod_type Type: TABLE Owner: dpavlin |
285 |
|
|
-- |
286 |
|
|
|
287 |
|
|
CREATE TABLE "prod_type" ( |
288 |
|
|
"type" character varying(4) NOT NULL, |
289 |
|
|
"description" text |
290 |
|
|
); |
291 |
|
|
|
292 |
|
|
-- |
293 |
|
|
-- TOC Entry ID 25 (OID 158630) |
294 |
|
|
-- |
295 |
|
|
-- Name: analysts Type: TABLE Owner: dpavlin |
296 |
|
|
-- |
297 |
|
|
|
298 |
|
|
CREATE TABLE "analysts" ( |
299 |
|
|
"num" integer DEFAULT nextval('analysts_num_seq'::text) NOT NULL, |
300 |
|
|
"company" text, |
301 |
|
|
"analyst" text, |
302 |
|
|
"email" text |
303 |
|
|
); |
304 |
|
|
|
305 |
|
|
-- |
306 |
|
|
-- TOC Entry ID 26 (OID 158659) |
307 |
|
|
-- |
308 |
|
|
-- Name: stocks_order Type: TABLE Owner: dpavlin |
309 |
|
|
-- |
310 |
|
|
|
311 |
|
|
CREATE TABLE "stocks_order" ( |
312 |
|
|
"type" character varying(10) NOT NULL, |
313 |
|
|
"ordinal" integer NOT NULL |
314 |
|
|
); |
315 |
|
|
|
316 |
|
|
-- |
317 |
|
|
-- TOC Entry ID 27 (OID 158670) |
318 |
|
|
-- |
319 |
|
|
-- Name: open_position_locations Type: TABLE Owner: dpavlin |
320 |
|
|
-- |
321 |
|
|
|
322 |
|
|
CREATE TABLE "open_position_locations" ( |
323 |
|
|
"id" integer DEFAULT nextval('open_position_locations_id_seq'::text) NOT NULL, |
324 |
|
|
"location" character varying(250), |
325 |
|
|
"email" character varying(250) |
326 |
|
|
); |
327 |
|
|
|
328 |
|
|
-- |
329 |
|
|
-- TOC Entry ID 28 (OID 158683) |
330 |
|
|
-- |
331 |
|
|
-- Name: open_positions Type: TABLE Owner: dpavlin |
332 |
|
|
-- |
333 |
|
|
|
334 |
|
|
CREATE TABLE "open_positions" ( |
335 |
|
|
"num" integer DEFAULT nextval('open_positions_num_seq'::text) NOT NULL, |
336 |
|
|
"title" text, |
337 |
|
|
"job_code" text, |
338 |
|
|
"department" text, |
339 |
|
|
"location_id" integer, |
340 |
|
|
"description" text, |
341 |
|
|
"edu_req" text, |
342 |
|
|
"qual_req" text, |
343 |
|
|
"visible" boolean DEFAULT 'f', |
344 |
|
|
"expiration" date NOT NULL |
345 |
|
|
); |
346 |
|
|
|
347 |
|
|
-- |
348 |
|
|
-- TOC Entry ID 29 (OID 220605) |
349 |
|
|
-- |
350 |
|
|
-- Name: news Type: TABLE Owner: dpavlin |
351 |
|
|
-- |
352 |
|
|
|
353 |
|
|
CREATE TABLE "news" ( |
354 |
|
|
"id" integer DEFAULT nextval('news_id_seq'::text) NOT NULL, |
355 |
|
|
"title" text NOT NULL, |
356 |
|
|
"town_date" text, |
357 |
|
|
"body" text, |
358 |
|
|
"more" text, |
359 |
|
|
"pdf" text, |
360 |
|
|
"date" date, |
361 |
|
|
"type" character(1), |
362 |
|
|
"pic" character varying(20), |
363 |
|
|
"origpic" character varying(20), |
364 |
|
|
"visible" boolean DEFAULT 't', |
365 |
|
|
"priority" integer DEFAULT 0, |
366 |
|
|
CONSTRAINT "news_type" CHECK (((((((("type" = 'n'::bpchar) OR ("type" = 'c'::bpchar)) OR ("type" = 'e'::bpchar)) OR ("type" = 'r'::bpchar)) OR ("type" = 'i'::bpchar)) OR ("type" = 'a'::bpchar)) OR ("type" = 'p'::bpchar))) |
367 |
|
|
); |
368 |
|
|
|
369 |
|
|
-- |
370 |
|
|
-- TOC Entry ID 35 (OID 158183) |
371 |
|
|
-- |
372 |
|
|
-- Name: "ind_products_smpc" Type: INDEX Owner: dpavlin |
373 |
|
|
-- |
374 |
|
|
|
375 |
|
|
CREATE INDEX "ind_products_smpc" on "products" using btree ( "smpc" "int4_ops" ); |
376 |
|
|
|
377 |
|
|
-- |
378 |
|
|
-- TOC Entry ID 30 (OID 158324) |
379 |
|
|
-- |
380 |
|
|
-- Name: "ind_sections_section" Type: INDEX Owner: dpavlin |
381 |
|
|
-- |
382 |
|
|
|
383 |
|
|
CREATE INDEX "ind_sections_section" on "sections" using btree ( "section" "float8_ops" ); |
384 |
|
|
|
385 |
|
|
-- |
386 |
|
|
-- TOC Entry ID 33 (OID 158324) |
387 |
|
|
-- |
388 |
|
|
-- Name: "sections_id_key" Type: INDEX Owner: dpavlin |
389 |
|
|
-- |
390 |
|
|
|
391 |
|
|
CREATE UNIQUE INDEX "sections_id_key" on "sections" using btree ( "id" "int4_ops" ); |
392 |
|
|
|
393 |
|
|
-- |
394 |
|
|
-- TOC Entry ID 31 (OID 158352) |
395 |
|
|
-- |
396 |
|
|
-- Name: "ind_paragraphs_smpc" Type: INDEX Owner: dpavlin |
397 |
|
|
-- |
398 |
|
|
|
399 |
|
|
CREATE INDEX "ind_paragraphs_smpc" on "paragraphs" using btree ( "smpc" "int4_ops" ); |
400 |
|
|
|
401 |
|
|
-- |
402 |
|
|
-- TOC Entry ID 32 (OID 158352) |
403 |
|
|
-- |
404 |
|
|
-- Name: "ind_paragraphs_section_id" Type: INDEX Owner: dpavlin |
405 |
|
|
-- |
406 |
|
|
|
407 |
|
|
CREATE INDEX "ind_paragraphs_section_id" on "paragraphs" using btree ( "section_id" "int4_ops" ); |
408 |
|
|
|
409 |
|
|
-- |
410 |
|
|
-- TOC Entry ID 34 (OID 158352) |
411 |
|
|
-- |
412 |
|
|
-- Name: "paragraphs_id_key" Type: INDEX Owner: dpavlin |
413 |
|
|
-- |
414 |
|
|
|
415 |
|
|
CREATE UNIQUE INDEX "paragraphs_id_key" on "paragraphs" using btree ( "id" "int4_ops" ); |
416 |
|
|
|
417 |
|
|
-- |
418 |
|
|
-- TOC Entry ID 36 (OID 158408) |
419 |
|
|
-- |
420 |
|
|
-- Name: "ind_history_num" Type: INDEX Owner: dpavlin |
421 |
|
|
-- |
422 |
|
|
|
423 |
|
|
CREATE INDEX "ind_history_num" on "history" using btree ( "num" "int4_ops" ); |
424 |
|
|
|
425 |
|
|
-- |
426 |
|
|
-- TOC Entry ID 37 (OID 158435) |
427 |
|
|
-- |
428 |
|
|
-- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin |
429 |
|
|
-- |
430 |
|
|
|
431 |
|
|
CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" ); |
432 |
|
|
|
433 |
|
|
-- |
434 |
|
|
-- TOC Entry ID 38 (OID 158461) |
435 |
|
|
-- |
436 |
|
|
-- Name: "ind_stocks_type" Type: INDEX Owner: dpavlin |
437 |
|
|
-- |
438 |
|
|
|
439 |
|
|
CREATE INDEX "ind_stocks_type" on "stocks" using btree ( "type" "varchar_ops" ); |
440 |
|
|
|
441 |
|
|
-- |
442 |
|
|
-- TOC Entry ID 39 (OID 158461) |
443 |
|
|
-- |
444 |
|
|
-- Name: "ind_stocks_date" Type: INDEX Owner: dpavlin |
445 |
|
|
-- |
446 |
|
|
|
447 |
|
|
CREATE INDEX "ind_stocks_date" on "stocks" using btree ( "date" "timestamp_ops" ); |
448 |
|
|
|
449 |
|
|
-- |
450 |
|
|
-- TOC Entry ID 40 (OID 158479) |
451 |
|
|
-- |
452 |
|
|
-- Name: "ind_vet_type_type" Type: INDEX Owner: dpavlin |
453 |
|
|
-- |
454 |
|
|
|
455 |
|
|
CREATE UNIQUE INDEX "ind_vet_type_type" on "vet_type" using btree ( "type" "varchar_ops" ); |
456 |
|
|
|
457 |
|
|
-- |
458 |
|
|
-- TOC Entry ID 41 (OID 158505) |
459 |
|
|
-- |
460 |
|
|
-- Name: "ind_vet_animal_animal" Type: INDEX Owner: dpavlin |
461 |
|
|
-- |
462 |
|
|
|
463 |
|
|
CREATE UNIQUE INDEX "ind_vet_animal_animal" on "vet_animal" using btree ( "animal" "varchar_ops" ); |
464 |
|
|
|
465 |
|
|
-- |
466 |
|
|
-- TOC Entry ID 42 (OID 158630) |
467 |
|
|
-- |
468 |
|
|
-- Name: "analysts_num_key" Type: INDEX Owner: dpavlin |
469 |
|
|
-- |
470 |
|
|
|
471 |
|
|
CREATE UNIQUE INDEX "analysts_num_key" on "analysts" using btree ( "num" "int4_ops" ); |
472 |
|
|
|
473 |
|
|
-- |
474 |
|
|
-- TOC Entry ID 43 (OID 158659) |
475 |
|
|
-- |
476 |
|
|
-- Name: "ind_stocks_order_type" Type: INDEX Owner: dpavlin |
477 |
|
|
-- |
478 |
|
|
|
479 |
|
|
CREATE INDEX "ind_stocks_order_type" on "stocks_order" using btree ( "type" "varchar_ops" ); |
480 |
|
|
|
481 |
|
|
-- |
482 |
|
|
-- TOC Entry ID 44 (OID 158659) |
483 |
|
|
-- |
484 |
|
|
-- Name: "ind_stocks_order_ordinal" Type: INDEX Owner: dpavlin |
485 |
|
|
-- |
486 |
|
|
|
487 |
|
|
CREATE INDEX "ind_stocks_order_ordinal" on "stocks_order" using btree ( "ordinal" "int4_ops" ); |
488 |
|
|
|
489 |
|
|
-- |
490 |
|
|
-- TOC Entry ID 45 (OID 158670) |
491 |
|
|
-- |
492 |
|
|
-- Name: "open_position_locations_id_key" Type: INDEX Owner: dpavlin |
493 |
|
|
-- |
494 |
|
|
|
495 |
|
|
CREATE UNIQUE INDEX "open_position_locations_id_key" on "open_position_locations" using btree ( "id" "int4_ops" ); |
496 |
|
|
|
497 |
|
|
-- |
498 |
|
|
-- TOC Entry ID 46 (OID 158683) |
499 |
|
|
-- |
500 |
|
|
-- Name: "open_positions_num_key" Type: INDEX Owner: dpavlin |
501 |
|
|
-- |
502 |
|
|
|
503 |
|
|
CREATE UNIQUE INDEX "open_positions_num_key" on "open_positions" using btree ( "num" "int4_ops" ); |
504 |
|
|
|