1 | -- |
---|
2 | -- PostgreSQL database dump |
---|
3 | -- |
---|
4 | |
---|
5 | -- Dumped from database version 9.1.9 |
---|
6 | -- Dumped by pg_dump version 9.1.9 |
---|
7 | -- Started on 2013-05-30 11:25:59 VET |
---|
8 | |
---|
9 | SET statement_timeout = 0; |
---|
10 | SET client_encoding = 'UTF8'; |
---|
11 | SET standard_conforming_strings = on; |
---|
12 | SET check_function_bodies = false; |
---|
13 | SET client_min_messages = warning; |
---|
14 | |
---|
15 | -- |
---|
16 | -- TOC entry 2167 (class 1262 OID 53454) |
---|
17 | -- Dependencies: 2166 |
---|
18 | -- Name: smid_etl; Type: COMMENT; Schema: -; Owner: administrador |
---|
19 | -- |
---|
20 | |
---|
21 | COMMENT ON DATABASE smid_etl IS 'Procesos ETL del SMID'; |
---|
22 | |
---|
23 | |
---|
24 | -- |
---|
25 | -- TOC entry 240 (class 3079 OID 11645) |
---|
26 | -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: |
---|
27 | -- |
---|
28 | |
---|
29 | CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; |
---|
30 | |
---|
31 | |
---|
32 | -- |
---|
33 | -- TOC entry 2170 (class 0 OID 0) |
---|
34 | -- Dependencies: 240 |
---|
35 | -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: |
---|
36 | -- |
---|
37 | |
---|
38 | COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; |
---|
39 | |
---|
40 | |
---|
41 | SET search_path = public, pg_catalog; |
---|
42 | |
---|
43 | SET default_tablespace = ''; |
---|
44 | |
---|
45 | SET default_with_oids = false; |
---|
46 | |
---|
47 | -- |
---|
48 | -- TOC entry 192 (class 1259 OID 53584) |
---|
49 | -- Dependencies: 5 |
---|
50 | -- Name: r_cluster; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
51 | -- |
---|
52 | |
---|
53 | CREATE TABLE r_cluster ( |
---|
54 | id_cluster bigint NOT NULL, |
---|
55 | name character varying(255), |
---|
56 | base_port character varying(255), |
---|
57 | sockets_buffer_size character varying(255), |
---|
58 | sockets_flush_interval character varying(255), |
---|
59 | sockets_compressed character(1), |
---|
60 | dynamic_cluster character(1) |
---|
61 | ); |
---|
62 | |
---|
63 | |
---|
64 | ALTER TABLE public.r_cluster OWNER TO administrador; |
---|
65 | |
---|
66 | -- |
---|
67 | -- TOC entry 191 (class 1259 OID 53582) |
---|
68 | -- Dependencies: 5 192 |
---|
69 | -- Name: r_cluster_id_cluster_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
70 | -- |
---|
71 | |
---|
72 | CREATE SEQUENCE r_cluster_id_cluster_seq |
---|
73 | START WITH 1 |
---|
74 | INCREMENT BY 1 |
---|
75 | NO MINVALUE |
---|
76 | NO MAXVALUE |
---|
77 | CACHE 1; |
---|
78 | |
---|
79 | |
---|
80 | ALTER TABLE public.r_cluster_id_cluster_seq OWNER TO administrador; |
---|
81 | |
---|
82 | -- |
---|
83 | -- TOC entry 2171 (class 0 OID 0) |
---|
84 | -- Dependencies: 191 |
---|
85 | -- Name: r_cluster_id_cluster_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
86 | -- |
---|
87 | |
---|
88 | ALTER SEQUENCE r_cluster_id_cluster_seq OWNED BY r_cluster.id_cluster; |
---|
89 | |
---|
90 | |
---|
91 | -- |
---|
92 | -- TOC entry 196 (class 1259 OID 53602) |
---|
93 | -- Dependencies: 5 |
---|
94 | -- Name: r_cluster_slave; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
95 | -- |
---|
96 | |
---|
97 | CREATE TABLE r_cluster_slave ( |
---|
98 | id_cluster_slave bigint NOT NULL, |
---|
99 | id_cluster integer, |
---|
100 | id_slave integer |
---|
101 | ); |
---|
102 | |
---|
103 | |
---|
104 | ALTER TABLE public.r_cluster_slave OWNER TO administrador; |
---|
105 | |
---|
106 | -- |
---|
107 | -- TOC entry 195 (class 1259 OID 53600) |
---|
108 | -- Dependencies: 5 196 |
---|
109 | -- Name: r_cluster_slave_id_cluster_slave_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
110 | -- |
---|
111 | |
---|
112 | CREATE SEQUENCE r_cluster_slave_id_cluster_slave_seq |
---|
113 | START WITH 1 |
---|
114 | INCREMENT BY 1 |
---|
115 | NO MINVALUE |
---|
116 | NO MAXVALUE |
---|
117 | CACHE 1; |
---|
118 | |
---|
119 | |
---|
120 | ALTER TABLE public.r_cluster_slave_id_cluster_slave_seq OWNER TO administrador; |
---|
121 | |
---|
122 | -- |
---|
123 | -- TOC entry 2172 (class 0 OID 0) |
---|
124 | -- Dependencies: 195 |
---|
125 | -- Name: r_cluster_slave_id_cluster_slave_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
126 | -- |
---|
127 | |
---|
128 | ALTER SEQUENCE r_cluster_slave_id_cluster_slave_seq OWNED BY r_cluster_slave.id_cluster_slave; |
---|
129 | |
---|
130 | |
---|
131 | -- |
---|
132 | -- TOC entry 205 (class 1259 OID 53629) |
---|
133 | -- Dependencies: 5 |
---|
134 | -- Name: r_condition; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
135 | -- |
---|
136 | |
---|
137 | CREATE TABLE r_condition ( |
---|
138 | id_condition bigint NOT NULL, |
---|
139 | id_condition_parent integer, |
---|
140 | negated character(1), |
---|
141 | operator character varying(255), |
---|
142 | left_name character varying(255), |
---|
143 | condition_function character varying(255), |
---|
144 | right_name character varying(255), |
---|
145 | id_value_right integer |
---|
146 | ); |
---|
147 | |
---|
148 | |
---|
149 | ALTER TABLE public.r_condition OWNER TO administrador; |
---|
150 | |
---|
151 | -- |
---|
152 | -- TOC entry 204 (class 1259 OID 53627) |
---|
153 | -- Dependencies: 5 205 |
---|
154 | -- Name: r_condition_id_condition_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
155 | -- |
---|
156 | |
---|
157 | CREATE SEQUENCE r_condition_id_condition_seq |
---|
158 | START WITH 1 |
---|
159 | INCREMENT BY 1 |
---|
160 | NO MINVALUE |
---|
161 | NO MAXVALUE |
---|
162 | CACHE 1; |
---|
163 | |
---|
164 | |
---|
165 | ALTER TABLE public.r_condition_id_condition_seq OWNER TO administrador; |
---|
166 | |
---|
167 | -- |
---|
168 | -- TOC entry 2173 (class 0 OID 0) |
---|
169 | -- Dependencies: 204 |
---|
170 | -- Name: r_condition_id_condition_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
171 | -- |
---|
172 | |
---|
173 | ALTER SEQUENCE r_condition_id_condition_seq OWNED BY r_condition.id_condition; |
---|
174 | |
---|
175 | |
---|
176 | -- |
---|
177 | -- TOC entry 172 (class 1259 OID 53499) |
---|
178 | -- Dependencies: 5 |
---|
179 | -- Name: r_database; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
180 | -- |
---|
181 | |
---|
182 | CREATE TABLE r_database ( |
---|
183 | id_database bigint NOT NULL, |
---|
184 | name character varying(255), |
---|
185 | id_database_type integer, |
---|
186 | id_database_contype integer, |
---|
187 | host_name character varying(255), |
---|
188 | database_name character varying(255), |
---|
189 | port integer, |
---|
190 | username character varying(255), |
---|
191 | password character varying(255), |
---|
192 | servername character varying(255), |
---|
193 | data_tbs character varying(255), |
---|
194 | index_tbs character varying(255) |
---|
195 | ); |
---|
196 | |
---|
197 | |
---|
198 | ALTER TABLE public.r_database OWNER TO administrador; |
---|
199 | |
---|
200 | -- |
---|
201 | -- TOC entry 174 (class 1259 OID 53508) |
---|
202 | -- Dependencies: 5 |
---|
203 | -- Name: r_database_attribute; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
204 | -- |
---|
205 | |
---|
206 | CREATE TABLE r_database_attribute ( |
---|
207 | id_database_attribute bigint NOT NULL, |
---|
208 | id_database integer, |
---|
209 | code character varying(255), |
---|
210 | value_str character varying(2000000) |
---|
211 | ); |
---|
212 | |
---|
213 | |
---|
214 | ALTER TABLE public.r_database_attribute OWNER TO administrador; |
---|
215 | |
---|
216 | -- |
---|
217 | -- TOC entry 173 (class 1259 OID 53506) |
---|
218 | -- Dependencies: 174 5 |
---|
219 | -- Name: r_database_attribute_id_database_attribute_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
220 | -- |
---|
221 | |
---|
222 | CREATE SEQUENCE r_database_attribute_id_database_attribute_seq |
---|
223 | START WITH 1 |
---|
224 | INCREMENT BY 1 |
---|
225 | NO MINVALUE |
---|
226 | NO MAXVALUE |
---|
227 | CACHE 1; |
---|
228 | |
---|
229 | |
---|
230 | ALTER TABLE public.r_database_attribute_id_database_attribute_seq OWNER TO administrador; |
---|
231 | |
---|
232 | -- |
---|
233 | -- TOC entry 2174 (class 0 OID 0) |
---|
234 | -- Dependencies: 173 |
---|
235 | -- Name: r_database_attribute_id_database_attribute_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
236 | -- |
---|
237 | |
---|
238 | ALTER SEQUENCE r_database_attribute_id_database_attribute_seq OWNED BY r_database_attribute.id_database_attribute; |
---|
239 | |
---|
240 | |
---|
241 | -- |
---|
242 | -- TOC entry 168 (class 1259 OID 53481) |
---|
243 | -- Dependencies: 5 |
---|
244 | -- Name: r_database_contype; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
245 | -- |
---|
246 | |
---|
247 | CREATE TABLE r_database_contype ( |
---|
248 | id_database_contype bigint NOT NULL, |
---|
249 | code character varying(255), |
---|
250 | description character varying(255) |
---|
251 | ); |
---|
252 | |
---|
253 | |
---|
254 | ALTER TABLE public.r_database_contype OWNER TO administrador; |
---|
255 | |
---|
256 | -- |
---|
257 | -- TOC entry 167 (class 1259 OID 53479) |
---|
258 | -- Dependencies: 168 5 |
---|
259 | -- Name: r_database_contype_id_database_contype_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
260 | -- |
---|
261 | |
---|
262 | CREATE SEQUENCE r_database_contype_id_database_contype_seq |
---|
263 | START WITH 1 |
---|
264 | INCREMENT BY 1 |
---|
265 | NO MINVALUE |
---|
266 | NO MAXVALUE |
---|
267 | CACHE 1; |
---|
268 | |
---|
269 | |
---|
270 | ALTER TABLE public.r_database_contype_id_database_contype_seq OWNER TO administrador; |
---|
271 | |
---|
272 | -- |
---|
273 | -- TOC entry 2175 (class 0 OID 0) |
---|
274 | -- Dependencies: 167 |
---|
275 | -- Name: r_database_contype_id_database_contype_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
276 | -- |
---|
277 | |
---|
278 | ALTER SEQUENCE r_database_contype_id_database_contype_seq OWNED BY r_database_contype.id_database_contype; |
---|
279 | |
---|
280 | |
---|
281 | -- |
---|
282 | -- TOC entry 171 (class 1259 OID 53497) |
---|
283 | -- Dependencies: 172 5 |
---|
284 | -- Name: r_database_id_database_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
285 | -- |
---|
286 | |
---|
287 | CREATE SEQUENCE r_database_id_database_seq |
---|
288 | START WITH 1 |
---|
289 | INCREMENT BY 1 |
---|
290 | NO MINVALUE |
---|
291 | NO MAXVALUE |
---|
292 | CACHE 1; |
---|
293 | |
---|
294 | |
---|
295 | ALTER TABLE public.r_database_id_database_seq OWNER TO administrador; |
---|
296 | |
---|
297 | -- |
---|
298 | -- TOC entry 2176 (class 0 OID 0) |
---|
299 | -- Dependencies: 171 |
---|
300 | -- Name: r_database_id_database_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
301 | -- |
---|
302 | |
---|
303 | ALTER SEQUENCE r_database_id_database_seq OWNED BY r_database.id_database; |
---|
304 | |
---|
305 | |
---|
306 | -- |
---|
307 | -- TOC entry 166 (class 1259 OID 53472) |
---|
308 | -- Dependencies: 5 |
---|
309 | -- Name: r_database_type; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
310 | -- |
---|
311 | |
---|
312 | CREATE TABLE r_database_type ( |
---|
313 | id_database_type bigint NOT NULL, |
---|
314 | code character varying(255), |
---|
315 | description character varying(255) |
---|
316 | ); |
---|
317 | |
---|
318 | |
---|
319 | ALTER TABLE public.r_database_type OWNER TO administrador; |
---|
320 | |
---|
321 | -- |
---|
322 | -- TOC entry 165 (class 1259 OID 53470) |
---|
323 | -- Dependencies: 166 5 |
---|
324 | -- Name: r_database_type_id_database_type_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
325 | -- |
---|
326 | |
---|
327 | CREATE SEQUENCE r_database_type_id_database_type_seq |
---|
328 | START WITH 1 |
---|
329 | INCREMENT BY 1 |
---|
330 | NO MINVALUE |
---|
331 | NO MAXVALUE |
---|
332 | CACHE 1; |
---|
333 | |
---|
334 | |
---|
335 | ALTER TABLE public.r_database_type_id_database_type_seq OWNER TO administrador; |
---|
336 | |
---|
337 | -- |
---|
338 | -- TOC entry 2177 (class 0 OID 0) |
---|
339 | -- Dependencies: 165 |
---|
340 | -- Name: r_database_type_id_database_type_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
341 | -- |
---|
342 | |
---|
343 | ALTER SEQUENCE r_database_type_id_database_type_seq OWNED BY r_database_type.id_database_type; |
---|
344 | |
---|
345 | |
---|
346 | -- |
---|
347 | -- TOC entry 184 (class 1259 OID 53554) |
---|
348 | -- Dependencies: 5 |
---|
349 | -- Name: r_dependency; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
350 | -- |
---|
351 | |
---|
352 | CREATE TABLE r_dependency ( |
---|
353 | id_dependency bigint NOT NULL, |
---|
354 | id_transformation integer, |
---|
355 | id_database integer, |
---|
356 | table_name character varying(255), |
---|
357 | field_name character varying(255) |
---|
358 | ); |
---|
359 | |
---|
360 | |
---|
361 | ALTER TABLE public.r_dependency OWNER TO administrador; |
---|
362 | |
---|
363 | -- |
---|
364 | -- TOC entry 183 (class 1259 OID 53552) |
---|
365 | -- Dependencies: 5 184 |
---|
366 | -- Name: r_dependency_id_dependency_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
367 | -- |
---|
368 | |
---|
369 | CREATE SEQUENCE r_dependency_id_dependency_seq |
---|
370 | START WITH 1 |
---|
371 | INCREMENT BY 1 |
---|
372 | NO MINVALUE |
---|
373 | NO MAXVALUE |
---|
374 | CACHE 1; |
---|
375 | |
---|
376 | |
---|
377 | ALTER TABLE public.r_dependency_id_dependency_seq OWNER TO administrador; |
---|
378 | |
---|
379 | -- |
---|
380 | -- TOC entry 2178 (class 0 OID 0) |
---|
381 | -- Dependencies: 183 |
---|
382 | -- Name: r_dependency_id_dependency_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
383 | -- |
---|
384 | |
---|
385 | ALTER SEQUENCE r_dependency_id_dependency_seq OWNED BY r_dependency.id_dependency; |
---|
386 | |
---|
387 | |
---|
388 | -- |
---|
389 | -- TOC entry 176 (class 1259 OID 53518) |
---|
390 | -- Dependencies: 5 |
---|
391 | -- Name: r_directory; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
392 | -- |
---|
393 | |
---|
394 | CREATE TABLE r_directory ( |
---|
395 | id_directory bigint NOT NULL, |
---|
396 | id_directory_parent integer, |
---|
397 | directory_name character varying(255) |
---|
398 | ); |
---|
399 | |
---|
400 | |
---|
401 | ALTER TABLE public.r_directory OWNER TO administrador; |
---|
402 | |
---|
403 | -- |
---|
404 | -- TOC entry 175 (class 1259 OID 53516) |
---|
405 | -- Dependencies: 5 176 |
---|
406 | -- Name: r_directory_id_directory_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
407 | -- |
---|
408 | |
---|
409 | CREATE SEQUENCE r_directory_id_directory_seq |
---|
410 | START WITH 1 |
---|
411 | INCREMENT BY 1 |
---|
412 | NO MINVALUE |
---|
413 | NO MAXVALUE |
---|
414 | CACHE 1; |
---|
415 | |
---|
416 | |
---|
417 | ALTER TABLE public.r_directory_id_directory_seq OWNER TO administrador; |
---|
418 | |
---|
419 | -- |
---|
420 | -- TOC entry 2179 (class 0 OID 0) |
---|
421 | -- Dependencies: 175 |
---|
422 | -- Name: r_directory_id_directory_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
423 | -- |
---|
424 | |
---|
425 | ALTER SEQUENCE r_directory_id_directory_seq OWNED BY r_directory.id_directory; |
---|
426 | |
---|
427 | |
---|
428 | -- |
---|
429 | -- TOC entry 221 (class 1259 OID 53701) |
---|
430 | -- Dependencies: 5 |
---|
431 | -- Name: r_job; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
432 | -- |
---|
433 | |
---|
434 | CREATE TABLE r_job ( |
---|
435 | id_job bigint NOT NULL, |
---|
436 | id_directory integer, |
---|
437 | name character varying(255), |
---|
438 | description character varying(2000000), |
---|
439 | extended_description character varying(2000000), |
---|
440 | job_version character varying(255), |
---|
441 | job_status integer, |
---|
442 | id_database_log integer, |
---|
443 | table_name_log character varying(255), |
---|
444 | created_user character varying(255), |
---|
445 | created_date timestamp without time zone, |
---|
446 | modified_user character varying(255), |
---|
447 | modified_date timestamp without time zone, |
---|
448 | use_batch_id character(1), |
---|
449 | pass_batch_id character(1), |
---|
450 | use_logfield character(1), |
---|
451 | shared_file character varying(255) |
---|
452 | ); |
---|
453 | |
---|
454 | |
---|
455 | ALTER TABLE public.r_job OWNER TO administrador; |
---|
456 | |
---|
457 | -- |
---|
458 | -- TOC entry 182 (class 1259 OID 53544) |
---|
459 | -- Dependencies: 5 |
---|
460 | -- Name: r_job_attribute; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
461 | -- |
---|
462 | |
---|
463 | CREATE TABLE r_job_attribute ( |
---|
464 | id_job_attribute bigint NOT NULL, |
---|
465 | id_job integer, |
---|
466 | nr integer, |
---|
467 | code character varying(255), |
---|
468 | value_num bigint, |
---|
469 | value_str character varying(2000000) |
---|
470 | ); |
---|
471 | |
---|
472 | |
---|
473 | ALTER TABLE public.r_job_attribute OWNER TO administrador; |
---|
474 | |
---|
475 | -- |
---|
476 | -- TOC entry 181 (class 1259 OID 53542) |
---|
477 | -- Dependencies: 182 5 |
---|
478 | -- Name: r_job_attribute_id_job_attribute_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
479 | -- |
---|
480 | |
---|
481 | CREATE SEQUENCE r_job_attribute_id_job_attribute_seq |
---|
482 | START WITH 1 |
---|
483 | INCREMENT BY 1 |
---|
484 | NO MINVALUE |
---|
485 | NO MAXVALUE |
---|
486 | CACHE 1; |
---|
487 | |
---|
488 | |
---|
489 | ALTER TABLE public.r_job_attribute_id_job_attribute_seq OWNER TO administrador; |
---|
490 | |
---|
491 | -- |
---|
492 | -- TOC entry 2180 (class 0 OID 0) |
---|
493 | -- Dependencies: 181 |
---|
494 | -- Name: r_job_attribute_id_job_attribute_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
495 | -- |
---|
496 | |
---|
497 | ALTER SEQUENCE r_job_attribute_id_job_attribute_seq OWNED BY r_job_attribute.id_job_attribute; |
---|
498 | |
---|
499 | |
---|
500 | -- |
---|
501 | -- TOC entry 232 (class 1259 OID 53749) |
---|
502 | -- Dependencies: 5 |
---|
503 | -- Name: r_job_hop; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
504 | -- |
---|
505 | |
---|
506 | CREATE TABLE r_job_hop ( |
---|
507 | id_job_hop bigint NOT NULL, |
---|
508 | id_job integer, |
---|
509 | id_jobentry_copy_from integer, |
---|
510 | id_jobentry_copy_to integer, |
---|
511 | enabled character(1), |
---|
512 | evaluation character(1), |
---|
513 | unconditional character(1) |
---|
514 | ); |
---|
515 | |
---|
516 | |
---|
517 | ALTER TABLE public.r_job_hop OWNER TO administrador; |
---|
518 | |
---|
519 | -- |
---|
520 | -- TOC entry 231 (class 1259 OID 53747) |
---|
521 | -- Dependencies: 232 5 |
---|
522 | -- Name: r_job_hop_id_job_hop_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
523 | -- |
---|
524 | |
---|
525 | CREATE SEQUENCE r_job_hop_id_job_hop_seq |
---|
526 | START WITH 1 |
---|
527 | INCREMENT BY 1 |
---|
528 | NO MINVALUE |
---|
529 | NO MAXVALUE |
---|
530 | CACHE 1; |
---|
531 | |
---|
532 | |
---|
533 | ALTER TABLE public.r_job_hop_id_job_hop_seq OWNER TO administrador; |
---|
534 | |
---|
535 | -- |
---|
536 | -- TOC entry 2181 (class 0 OID 0) |
---|
537 | -- Dependencies: 231 |
---|
538 | -- Name: r_job_hop_id_job_hop_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
539 | -- |
---|
540 | |
---|
541 | ALTER SEQUENCE r_job_hop_id_job_hop_seq OWNED BY r_job_hop.id_job_hop; |
---|
542 | |
---|
543 | |
---|
544 | -- |
---|
545 | -- TOC entry 220 (class 1259 OID 53699) |
---|
546 | -- Dependencies: 221 5 |
---|
547 | -- Name: r_job_id_job_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
548 | -- |
---|
549 | |
---|
550 | CREATE SEQUENCE r_job_id_job_seq |
---|
551 | START WITH 1 |
---|
552 | INCREMENT BY 1 |
---|
553 | NO MINVALUE |
---|
554 | NO MAXVALUE |
---|
555 | CACHE 1; |
---|
556 | |
---|
557 | |
---|
558 | ALTER TABLE public.r_job_id_job_seq OWNER TO administrador; |
---|
559 | |
---|
560 | -- |
---|
561 | -- TOC entry 2182 (class 0 OID 0) |
---|
562 | -- Dependencies: 220 |
---|
563 | -- Name: r_job_id_job_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
564 | -- |
---|
565 | |
---|
566 | ALTER SEQUENCE r_job_id_job_seq OWNED BY r_job.id_job; |
---|
567 | |
---|
568 | |
---|
569 | -- |
---|
570 | -- TOC entry 237 (class 1259 OID 53767) |
---|
571 | -- Dependencies: 5 |
---|
572 | -- Name: r_job_lock; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
573 | -- |
---|
574 | |
---|
575 | CREATE TABLE r_job_lock ( |
---|
576 | id_job_lock bigint NOT NULL, |
---|
577 | id_job integer, |
---|
578 | id_user integer, |
---|
579 | lock_message character varying(2000000), |
---|
580 | lock_date timestamp without time zone |
---|
581 | ); |
---|
582 | |
---|
583 | |
---|
584 | ALTER TABLE public.r_job_lock OWNER TO administrador; |
---|
585 | |
---|
586 | -- |
---|
587 | -- TOC entry 236 (class 1259 OID 53765) |
---|
588 | -- Dependencies: 5 237 |
---|
589 | -- Name: r_job_lock_id_job_lock_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
590 | -- |
---|
591 | |
---|
592 | CREATE SEQUENCE r_job_lock_id_job_lock_seq |
---|
593 | START WITH 1 |
---|
594 | INCREMENT BY 1 |
---|
595 | NO MINVALUE |
---|
596 | NO MAXVALUE |
---|
597 | CACHE 1; |
---|
598 | |
---|
599 | |
---|
600 | ALTER TABLE public.r_job_lock_id_job_lock_seq OWNER TO administrador; |
---|
601 | |
---|
602 | -- |
---|
603 | -- TOC entry 2183 (class 0 OID 0) |
---|
604 | -- Dependencies: 236 |
---|
605 | -- Name: r_job_lock_id_job_lock_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
606 | -- |
---|
607 | |
---|
608 | ALTER SEQUENCE r_job_lock_id_job_lock_seq OWNED BY r_job_lock.id_job_lock; |
---|
609 | |
---|
610 | |
---|
611 | -- |
---|
612 | -- TOC entry 233 (class 1259 OID 53753) |
---|
613 | -- Dependencies: 5 |
---|
614 | -- Name: r_job_note; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
615 | -- |
---|
616 | |
---|
617 | CREATE TABLE r_job_note ( |
---|
618 | id_job integer, |
---|
619 | id_note integer |
---|
620 | ); |
---|
621 | |
---|
622 | |
---|
623 | ALTER TABLE public.r_job_note OWNER TO administrador; |
---|
624 | |
---|
625 | -- |
---|
626 | -- TOC entry 226 (class 1259 OID 53724) |
---|
627 | -- Dependencies: 5 |
---|
628 | -- Name: r_jobentry; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
629 | -- |
---|
630 | |
---|
631 | CREATE TABLE r_jobentry ( |
---|
632 | id_jobentry bigint NOT NULL, |
---|
633 | id_job integer, |
---|
634 | id_jobentry_type integer, |
---|
635 | name character varying(255), |
---|
636 | description character varying(2000000) |
---|
637 | ); |
---|
638 | |
---|
639 | |
---|
640 | ALTER TABLE public.r_jobentry OWNER TO administrador; |
---|
641 | |
---|
642 | -- |
---|
643 | -- TOC entry 230 (class 1259 OID 53739) |
---|
644 | -- Dependencies: 5 |
---|
645 | -- Name: r_jobentry_attribute; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
646 | -- |
---|
647 | |
---|
648 | CREATE TABLE r_jobentry_attribute ( |
---|
649 | id_jobentry_attribute bigint NOT NULL, |
---|
650 | id_job integer, |
---|
651 | id_jobentry integer, |
---|
652 | nr integer, |
---|
653 | code character varying(255), |
---|
654 | value_num numeric(15,2), |
---|
655 | value_str character varying(2000000) |
---|
656 | ); |
---|
657 | |
---|
658 | |
---|
659 | ALTER TABLE public.r_jobentry_attribute OWNER TO administrador; |
---|
660 | |
---|
661 | -- |
---|
662 | -- TOC entry 229 (class 1259 OID 53737) |
---|
663 | -- Dependencies: 230 5 |
---|
664 | -- Name: r_jobentry_attribute_id_jobentry_attribute_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
665 | -- |
---|
666 | |
---|
667 | CREATE SEQUENCE r_jobentry_attribute_id_jobentry_attribute_seq |
---|
668 | START WITH 1 |
---|
669 | INCREMENT BY 1 |
---|
670 | NO MINVALUE |
---|
671 | NO MAXVALUE |
---|
672 | CACHE 1; |
---|
673 | |
---|
674 | |
---|
675 | ALTER TABLE public.r_jobentry_attribute_id_jobentry_attribute_seq OWNER TO administrador; |
---|
676 | |
---|
677 | -- |
---|
678 | -- TOC entry 2184 (class 0 OID 0) |
---|
679 | -- Dependencies: 229 |
---|
680 | -- Name: r_jobentry_attribute_id_jobentry_attribute_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
681 | -- |
---|
682 | |
---|
683 | ALTER SEQUENCE r_jobentry_attribute_id_jobentry_attribute_seq OWNED BY r_jobentry_attribute.id_jobentry_attribute; |
---|
684 | |
---|
685 | |
---|
686 | -- |
---|
687 | -- TOC entry 228 (class 1259 OID 53733) |
---|
688 | -- Dependencies: 5 |
---|
689 | -- Name: r_jobentry_copy; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
690 | -- |
---|
691 | |
---|
692 | CREATE TABLE r_jobentry_copy ( |
---|
693 | id_jobentry_copy bigint NOT NULL, |
---|
694 | id_jobentry integer, |
---|
695 | id_job integer, |
---|
696 | id_jobentry_type integer, |
---|
697 | nr smallint, |
---|
698 | gui_location_x integer, |
---|
699 | gui_location_y integer, |
---|
700 | gui_draw character(1), |
---|
701 | parallel character(1) |
---|
702 | ); |
---|
703 | |
---|
704 | |
---|
705 | ALTER TABLE public.r_jobentry_copy OWNER TO administrador; |
---|
706 | |
---|
707 | -- |
---|
708 | -- TOC entry 227 (class 1259 OID 53731) |
---|
709 | -- Dependencies: 5 228 |
---|
710 | -- Name: r_jobentry_copy_id_jobentry_copy_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
711 | -- |
---|
712 | |
---|
713 | CREATE SEQUENCE r_jobentry_copy_id_jobentry_copy_seq |
---|
714 | START WITH 1 |
---|
715 | INCREMENT BY 1 |
---|
716 | NO MINVALUE |
---|
717 | NO MAXVALUE |
---|
718 | CACHE 1; |
---|
719 | |
---|
720 | |
---|
721 | ALTER TABLE public.r_jobentry_copy_id_jobentry_copy_seq OWNER TO administrador; |
---|
722 | |
---|
723 | -- |
---|
724 | -- TOC entry 2185 (class 0 OID 0) |
---|
725 | -- Dependencies: 227 |
---|
726 | -- Name: r_jobentry_copy_id_jobentry_copy_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
727 | -- |
---|
728 | |
---|
729 | ALTER SEQUENCE r_jobentry_copy_id_jobentry_copy_seq OWNED BY r_jobentry_copy.id_jobentry_copy; |
---|
730 | |
---|
731 | |
---|
732 | -- |
---|
733 | -- TOC entry 222 (class 1259 OID 53708) |
---|
734 | -- Dependencies: 5 |
---|
735 | -- Name: r_jobentry_database; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
736 | -- |
---|
737 | |
---|
738 | CREATE TABLE r_jobentry_database ( |
---|
739 | id_job integer, |
---|
740 | id_jobentry integer, |
---|
741 | id_database integer |
---|
742 | ); |
---|
743 | |
---|
744 | |
---|
745 | ALTER TABLE public.r_jobentry_database OWNER TO administrador; |
---|
746 | |
---|
747 | -- |
---|
748 | -- TOC entry 225 (class 1259 OID 53722) |
---|
749 | -- Dependencies: 5 226 |
---|
750 | -- Name: r_jobentry_id_jobentry_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
751 | -- |
---|
752 | |
---|
753 | CREATE SEQUENCE r_jobentry_id_jobentry_seq |
---|
754 | START WITH 1 |
---|
755 | INCREMENT BY 1 |
---|
756 | NO MINVALUE |
---|
757 | NO MAXVALUE |
---|
758 | CACHE 1; |
---|
759 | |
---|
760 | |
---|
761 | ALTER TABLE public.r_jobentry_id_jobentry_seq OWNER TO administrador; |
---|
762 | |
---|
763 | -- |
---|
764 | -- TOC entry 2186 (class 0 OID 0) |
---|
765 | -- Dependencies: 225 |
---|
766 | -- Name: r_jobentry_id_jobentry_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
767 | -- |
---|
768 | |
---|
769 | ALTER SEQUENCE r_jobentry_id_jobentry_seq OWNED BY r_jobentry.id_jobentry; |
---|
770 | |
---|
771 | |
---|
772 | -- |
---|
773 | -- TOC entry 224 (class 1259 OID 53715) |
---|
774 | -- Dependencies: 5 |
---|
775 | -- Name: r_jobentry_type; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
776 | -- |
---|
777 | |
---|
778 | CREATE TABLE r_jobentry_type ( |
---|
779 | id_jobentry_type bigint NOT NULL, |
---|
780 | code character varying(255), |
---|
781 | description character varying(255) |
---|
782 | ); |
---|
783 | |
---|
784 | |
---|
785 | ALTER TABLE public.r_jobentry_type OWNER TO administrador; |
---|
786 | |
---|
787 | -- |
---|
788 | -- TOC entry 223 (class 1259 OID 53713) |
---|
789 | -- Dependencies: 224 5 |
---|
790 | -- Name: r_jobentry_type_id_jobentry_type_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
791 | -- |
---|
792 | |
---|
793 | CREATE SEQUENCE r_jobentry_type_id_jobentry_type_seq |
---|
794 | START WITH 1 |
---|
795 | INCREMENT BY 1 |
---|
796 | NO MINVALUE |
---|
797 | NO MAXVALUE |
---|
798 | CACHE 1; |
---|
799 | |
---|
800 | |
---|
801 | ALTER TABLE public.r_jobentry_type_id_jobentry_type_seq OWNER TO administrador; |
---|
802 | |
---|
803 | -- |
---|
804 | -- TOC entry 2187 (class 0 OID 0) |
---|
805 | -- Dependencies: 223 |
---|
806 | -- Name: r_jobentry_type_id_jobentry_type_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
807 | -- |
---|
808 | |
---|
809 | ALTER SEQUENCE r_jobentry_type_id_jobentry_type_seq OWNED BY r_jobentry_type.id_jobentry_type; |
---|
810 | |
---|
811 | |
---|
812 | -- |
---|
813 | -- TOC entry 219 (class 1259 OID 53692) |
---|
814 | -- Dependencies: 5 |
---|
815 | -- Name: r_log; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
816 | -- |
---|
817 | |
---|
818 | CREATE TABLE r_log ( |
---|
819 | id_log bigint NOT NULL, |
---|
820 | name character varying(255), |
---|
821 | id_loglevel integer, |
---|
822 | logtype character varying(255), |
---|
823 | filename character varying(255), |
---|
824 | fileextention character varying(255), |
---|
825 | add_date character(1), |
---|
826 | add_time character(1), |
---|
827 | id_database_log integer, |
---|
828 | table_name_log character varying(255) |
---|
829 | ); |
---|
830 | |
---|
831 | |
---|
832 | ALTER TABLE public.r_log OWNER TO administrador; |
---|
833 | |
---|
834 | -- |
---|
835 | -- TOC entry 218 (class 1259 OID 53690) |
---|
836 | -- Dependencies: 5 219 |
---|
837 | -- Name: r_log_id_log_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
838 | -- |
---|
839 | |
---|
840 | CREATE SEQUENCE r_log_id_log_seq |
---|
841 | START WITH 1 |
---|
842 | INCREMENT BY 1 |
---|
843 | NO MINVALUE |
---|
844 | NO MAXVALUE |
---|
845 | CACHE 1; |
---|
846 | |
---|
847 | |
---|
848 | ALTER TABLE public.r_log_id_log_seq OWNER TO administrador; |
---|
849 | |
---|
850 | -- |
---|
851 | -- TOC entry 2188 (class 0 OID 0) |
---|
852 | -- Dependencies: 218 |
---|
853 | -- Name: r_log_id_log_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
854 | -- |
---|
855 | |
---|
856 | ALTER SEQUENCE r_log_id_log_seq OWNED BY r_log.id_log; |
---|
857 | |
---|
858 | |
---|
859 | -- |
---|
860 | -- TOC entry 217 (class 1259 OID 53683) |
---|
861 | -- Dependencies: 5 |
---|
862 | -- Name: r_loglevel; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
863 | -- |
---|
864 | |
---|
865 | CREATE TABLE r_loglevel ( |
---|
866 | id_loglevel bigint NOT NULL, |
---|
867 | code character varying(255), |
---|
868 | description character varying(255) |
---|
869 | ); |
---|
870 | |
---|
871 | |
---|
872 | ALTER TABLE public.r_loglevel OWNER TO administrador; |
---|
873 | |
---|
874 | -- |
---|
875 | -- TOC entry 216 (class 1259 OID 53681) |
---|
876 | -- Dependencies: 5 217 |
---|
877 | -- Name: r_loglevel_id_loglevel_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
878 | -- |
---|
879 | |
---|
880 | CREATE SEQUENCE r_loglevel_id_loglevel_seq |
---|
881 | START WITH 1 |
---|
882 | INCREMENT BY 1 |
---|
883 | NO MINVALUE |
---|
884 | NO MAXVALUE |
---|
885 | CACHE 1; |
---|
886 | |
---|
887 | |
---|
888 | ALTER TABLE public.r_loglevel_id_loglevel_seq OWNER TO administrador; |
---|
889 | |
---|
890 | -- |
---|
891 | -- TOC entry 2189 (class 0 OID 0) |
---|
892 | -- Dependencies: 216 |
---|
893 | -- Name: r_loglevel_id_loglevel_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
894 | -- |
---|
895 | |
---|
896 | ALTER SEQUENCE r_loglevel_id_loglevel_seq OWNED BY r_loglevel.id_loglevel; |
---|
897 | |
---|
898 | |
---|
899 | -- |
---|
900 | -- TOC entry 170 (class 1259 OID 53490) |
---|
901 | -- Dependencies: 5 |
---|
902 | -- Name: r_note; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
903 | -- |
---|
904 | |
---|
905 | CREATE TABLE r_note ( |
---|
906 | id_note bigint NOT NULL, |
---|
907 | value_str character varying(2000000), |
---|
908 | gui_location_x integer, |
---|
909 | gui_location_y integer, |
---|
910 | gui_location_width integer, |
---|
911 | gui_location_height integer, |
---|
912 | font_name character varying(2000000), |
---|
913 | font_size integer, |
---|
914 | font_bold character(1), |
---|
915 | font_italic character(1), |
---|
916 | font_color_red integer, |
---|
917 | font_color_green integer, |
---|
918 | font_color_blue integer, |
---|
919 | font_back_ground_color_red integer, |
---|
920 | font_back_ground_color_green integer, |
---|
921 | font_back_ground_color_blue integer, |
---|
922 | font_border_color_red integer, |
---|
923 | font_border_color_green integer, |
---|
924 | font_border_color_blue integer, |
---|
925 | draw_shadow character(1) |
---|
926 | ); |
---|
927 | |
---|
928 | |
---|
929 | ALTER TABLE public.r_note OWNER TO administrador; |
---|
930 | |
---|
931 | -- |
---|
932 | -- TOC entry 169 (class 1259 OID 53488) |
---|
933 | -- Dependencies: 5 170 |
---|
934 | -- Name: r_note_id_note_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
935 | -- |
---|
936 | |
---|
937 | CREATE SEQUENCE r_note_id_note_seq |
---|
938 | START WITH 1 |
---|
939 | INCREMENT BY 1 |
---|
940 | NO MINVALUE |
---|
941 | NO MAXVALUE |
---|
942 | CACHE 1; |
---|
943 | |
---|
944 | |
---|
945 | ALTER TABLE public.r_note_id_note_seq OWNER TO administrador; |
---|
946 | |
---|
947 | -- |
---|
948 | -- TOC entry 2190 (class 0 OID 0) |
---|
949 | -- Dependencies: 169 |
---|
950 | -- Name: r_note_id_note_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
951 | -- |
---|
952 | |
---|
953 | ALTER SEQUENCE r_note_id_note_seq OWNED BY r_note.id_note; |
---|
954 | |
---|
955 | |
---|
956 | -- |
---|
957 | -- TOC entry 188 (class 1259 OID 53572) |
---|
958 | -- Dependencies: 5 |
---|
959 | -- Name: r_partition; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
960 | -- |
---|
961 | |
---|
962 | CREATE TABLE r_partition ( |
---|
963 | id_partition bigint NOT NULL, |
---|
964 | id_partition_schema integer, |
---|
965 | partition_id character varying(255) |
---|
966 | ); |
---|
967 | |
---|
968 | |
---|
969 | ALTER TABLE public.r_partition OWNER TO administrador; |
---|
970 | |
---|
971 | -- |
---|
972 | -- TOC entry 187 (class 1259 OID 53570) |
---|
973 | -- Dependencies: 5 188 |
---|
974 | -- Name: r_partition_id_partition_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
975 | -- |
---|
976 | |
---|
977 | CREATE SEQUENCE r_partition_id_partition_seq |
---|
978 | START WITH 1 |
---|
979 | INCREMENT BY 1 |
---|
980 | NO MINVALUE |
---|
981 | NO MAXVALUE |
---|
982 | CACHE 1; |
---|
983 | |
---|
984 | |
---|
985 | ALTER TABLE public.r_partition_id_partition_seq OWNER TO administrador; |
---|
986 | |
---|
987 | -- |
---|
988 | -- TOC entry 2191 (class 0 OID 0) |
---|
989 | -- Dependencies: 187 |
---|
990 | -- Name: r_partition_id_partition_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
991 | -- |
---|
992 | |
---|
993 | ALTER SEQUENCE r_partition_id_partition_seq OWNED BY r_partition.id_partition; |
---|
994 | |
---|
995 | |
---|
996 | -- |
---|
997 | -- TOC entry 186 (class 1259 OID 53563) |
---|
998 | -- Dependencies: 5 |
---|
999 | -- Name: r_partition_schema; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1000 | -- |
---|
1001 | |
---|
1002 | CREATE TABLE r_partition_schema ( |
---|
1003 | id_partition_schema bigint NOT NULL, |
---|
1004 | name character varying(255), |
---|
1005 | dynamic_definition character(1), |
---|
1006 | partitions_per_slave character varying(255) |
---|
1007 | ); |
---|
1008 | |
---|
1009 | |
---|
1010 | ALTER TABLE public.r_partition_schema OWNER TO administrador; |
---|
1011 | |
---|
1012 | -- |
---|
1013 | -- TOC entry 185 (class 1259 OID 53561) |
---|
1014 | -- Dependencies: 5 186 |
---|
1015 | -- Name: r_partition_schema_id_partition_schema_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1016 | -- |
---|
1017 | |
---|
1018 | CREATE SEQUENCE r_partition_schema_id_partition_schema_seq |
---|
1019 | START WITH 1 |
---|
1020 | INCREMENT BY 1 |
---|
1021 | NO MINVALUE |
---|
1022 | NO MAXVALUE |
---|
1023 | CACHE 1; |
---|
1024 | |
---|
1025 | |
---|
1026 | ALTER TABLE public.r_partition_schema_id_partition_schema_seq OWNER TO administrador; |
---|
1027 | |
---|
1028 | -- |
---|
1029 | -- TOC entry 2192 (class 0 OID 0) |
---|
1030 | -- Dependencies: 185 |
---|
1031 | -- Name: r_partition_schema_id_partition_schema_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1032 | -- |
---|
1033 | |
---|
1034 | ALTER SEQUENCE r_partition_schema_id_partition_schema_seq OWNED BY r_partition_schema.id_partition_schema; |
---|
1035 | |
---|
1036 | |
---|
1037 | -- |
---|
1038 | -- TOC entry 162 (class 1259 OID 53457) |
---|
1039 | -- Dependencies: 5 |
---|
1040 | -- Name: r_repository_log; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1041 | -- |
---|
1042 | |
---|
1043 | CREATE TABLE r_repository_log ( |
---|
1044 | id_repository_log bigint NOT NULL, |
---|
1045 | rep_version character varying(255), |
---|
1046 | log_date timestamp without time zone, |
---|
1047 | log_user character varying(255), |
---|
1048 | operation_desc character varying(2000000) |
---|
1049 | ); |
---|
1050 | |
---|
1051 | |
---|
1052 | ALTER TABLE public.r_repository_log OWNER TO administrador; |
---|
1053 | |
---|
1054 | -- |
---|
1055 | -- TOC entry 161 (class 1259 OID 53455) |
---|
1056 | -- Dependencies: 5 162 |
---|
1057 | -- Name: r_repository_log_id_repository_log_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1058 | -- |
---|
1059 | |
---|
1060 | CREATE SEQUENCE r_repository_log_id_repository_log_seq |
---|
1061 | START WITH 1 |
---|
1062 | INCREMENT BY 1 |
---|
1063 | NO MINVALUE |
---|
1064 | NO MAXVALUE |
---|
1065 | CACHE 1; |
---|
1066 | |
---|
1067 | |
---|
1068 | ALTER TABLE public.r_repository_log_id_repository_log_seq OWNER TO administrador; |
---|
1069 | |
---|
1070 | -- |
---|
1071 | -- TOC entry 2193 (class 0 OID 0) |
---|
1072 | -- Dependencies: 161 |
---|
1073 | -- Name: r_repository_log_id_repository_log_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1074 | -- |
---|
1075 | |
---|
1076 | ALTER SEQUENCE r_repository_log_id_repository_log_seq OWNED BY r_repository_log.id_repository_log; |
---|
1077 | |
---|
1078 | |
---|
1079 | -- |
---|
1080 | -- TOC entry 194 (class 1259 OID 53593) |
---|
1081 | -- Dependencies: 5 |
---|
1082 | -- Name: r_slave; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1083 | -- |
---|
1084 | |
---|
1085 | CREATE TABLE r_slave ( |
---|
1086 | id_slave bigint NOT NULL, |
---|
1087 | name character varying(255), |
---|
1088 | host_name character varying(255), |
---|
1089 | port character varying(255), |
---|
1090 | web_app_name character varying(255), |
---|
1091 | username character varying(255), |
---|
1092 | password character varying(255), |
---|
1093 | proxy_host_name character varying(255), |
---|
1094 | proxy_port character varying(255), |
---|
1095 | non_proxy_hosts character varying(255), |
---|
1096 | master character(1) |
---|
1097 | ); |
---|
1098 | |
---|
1099 | |
---|
1100 | ALTER TABLE public.r_slave OWNER TO administrador; |
---|
1101 | |
---|
1102 | -- |
---|
1103 | -- TOC entry 193 (class 1259 OID 53591) |
---|
1104 | -- Dependencies: 5 194 |
---|
1105 | -- Name: r_slave_id_slave_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1106 | -- |
---|
1107 | |
---|
1108 | CREATE SEQUENCE r_slave_id_slave_seq |
---|
1109 | START WITH 1 |
---|
1110 | INCREMENT BY 1 |
---|
1111 | NO MINVALUE |
---|
1112 | NO MAXVALUE |
---|
1113 | CACHE 1; |
---|
1114 | |
---|
1115 | |
---|
1116 | ALTER TABLE public.r_slave_id_slave_seq OWNER TO administrador; |
---|
1117 | |
---|
1118 | -- |
---|
1119 | -- TOC entry 2194 (class 0 OID 0) |
---|
1120 | -- Dependencies: 193 |
---|
1121 | -- Name: r_slave_id_slave_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1122 | -- |
---|
1123 | |
---|
1124 | ALTER SEQUENCE r_slave_id_slave_seq OWNED BY r_slave.id_slave; |
---|
1125 | |
---|
1126 | |
---|
1127 | -- |
---|
1128 | -- TOC entry 211 (class 1259 OID 53656) |
---|
1129 | -- Dependencies: 5 |
---|
1130 | -- Name: r_step; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1131 | -- |
---|
1132 | |
---|
1133 | CREATE TABLE r_step ( |
---|
1134 | id_step bigint NOT NULL, |
---|
1135 | id_transformation integer, |
---|
1136 | name character varying(255), |
---|
1137 | description character varying(2000000), |
---|
1138 | id_step_type integer, |
---|
1139 | distribute character(1), |
---|
1140 | copies smallint, |
---|
1141 | gui_location_x integer, |
---|
1142 | gui_location_y integer, |
---|
1143 | gui_draw character(1) |
---|
1144 | ); |
---|
1145 | |
---|
1146 | |
---|
1147 | ALTER TABLE public.r_step OWNER TO administrador; |
---|
1148 | |
---|
1149 | -- |
---|
1150 | -- TOC entry 213 (class 1259 OID 53665) |
---|
1151 | -- Dependencies: 5 |
---|
1152 | -- Name: r_step_attribute; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1153 | -- |
---|
1154 | |
---|
1155 | CREATE TABLE r_step_attribute ( |
---|
1156 | id_step_attribute bigint NOT NULL, |
---|
1157 | id_transformation integer, |
---|
1158 | id_step integer, |
---|
1159 | nr integer, |
---|
1160 | code character varying(255), |
---|
1161 | value_num bigint, |
---|
1162 | value_str character varying(2000000) |
---|
1163 | ); |
---|
1164 | |
---|
1165 | |
---|
1166 | ALTER TABLE public.r_step_attribute OWNER TO administrador; |
---|
1167 | |
---|
1168 | -- |
---|
1169 | -- TOC entry 212 (class 1259 OID 53663) |
---|
1170 | -- Dependencies: 213 5 |
---|
1171 | -- Name: r_step_attribute_id_step_attribute_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1172 | -- |
---|
1173 | |
---|
1174 | CREATE SEQUENCE r_step_attribute_id_step_attribute_seq |
---|
1175 | START WITH 1 |
---|
1176 | INCREMENT BY 1 |
---|
1177 | NO MINVALUE |
---|
1178 | NO MAXVALUE |
---|
1179 | CACHE 1; |
---|
1180 | |
---|
1181 | |
---|
1182 | ALTER TABLE public.r_step_attribute_id_step_attribute_seq OWNER TO administrador; |
---|
1183 | |
---|
1184 | -- |
---|
1185 | -- TOC entry 2195 (class 0 OID 0) |
---|
1186 | -- Dependencies: 212 |
---|
1187 | -- Name: r_step_attribute_id_step_attribute_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1188 | -- |
---|
1189 | |
---|
1190 | ALTER SEQUENCE r_step_attribute_id_step_attribute_seq OWNED BY r_step_attribute.id_step_attribute; |
---|
1191 | |
---|
1192 | |
---|
1193 | -- |
---|
1194 | -- TOC entry 214 (class 1259 OID 53673) |
---|
1195 | -- Dependencies: 5 |
---|
1196 | -- Name: r_step_database; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1197 | -- |
---|
1198 | |
---|
1199 | CREATE TABLE r_step_database ( |
---|
1200 | id_transformation integer, |
---|
1201 | id_step integer, |
---|
1202 | id_database integer |
---|
1203 | ); |
---|
1204 | |
---|
1205 | |
---|
1206 | ALTER TABLE public.r_step_database OWNER TO administrador; |
---|
1207 | |
---|
1208 | -- |
---|
1209 | -- TOC entry 210 (class 1259 OID 53654) |
---|
1210 | -- Dependencies: 211 5 |
---|
1211 | -- Name: r_step_id_step_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1212 | -- |
---|
1213 | |
---|
1214 | CREATE SEQUENCE r_step_id_step_seq |
---|
1215 | START WITH 1 |
---|
1216 | INCREMENT BY 1 |
---|
1217 | NO MINVALUE |
---|
1218 | NO MAXVALUE |
---|
1219 | CACHE 1; |
---|
1220 | |
---|
1221 | |
---|
1222 | ALTER TABLE public.r_step_id_step_seq OWNER TO administrador; |
---|
1223 | |
---|
1224 | -- |
---|
1225 | -- TOC entry 2196 (class 0 OID 0) |
---|
1226 | -- Dependencies: 210 |
---|
1227 | -- Name: r_step_id_step_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1228 | -- |
---|
1229 | |
---|
1230 | ALTER SEQUENCE r_step_id_step_seq OWNED BY r_step.id_step; |
---|
1231 | |
---|
1232 | |
---|
1233 | -- |
---|
1234 | -- TOC entry 209 (class 1259 OID 53647) |
---|
1235 | -- Dependencies: 5 |
---|
1236 | -- Name: r_step_type; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1237 | -- |
---|
1238 | |
---|
1239 | CREATE TABLE r_step_type ( |
---|
1240 | id_step_type bigint NOT NULL, |
---|
1241 | code character varying(255), |
---|
1242 | description character varying(255), |
---|
1243 | helptext character varying(255) |
---|
1244 | ); |
---|
1245 | |
---|
1246 | |
---|
1247 | ALTER TABLE public.r_step_type OWNER TO administrador; |
---|
1248 | |
---|
1249 | -- |
---|
1250 | -- TOC entry 208 (class 1259 OID 53645) |
---|
1251 | -- Dependencies: 209 5 |
---|
1252 | -- Name: r_step_type_id_step_type_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1253 | -- |
---|
1254 | |
---|
1255 | CREATE SEQUENCE r_step_type_id_step_type_seq |
---|
1256 | START WITH 1 |
---|
1257 | INCREMENT BY 1 |
---|
1258 | NO MINVALUE |
---|
1259 | NO MAXVALUE |
---|
1260 | CACHE 1; |
---|
1261 | |
---|
1262 | |
---|
1263 | ALTER TABLE public.r_step_type_id_step_type_seq OWNER TO administrador; |
---|
1264 | |
---|
1265 | -- |
---|
1266 | -- TOC entry 2197 (class 0 OID 0) |
---|
1267 | -- Dependencies: 208 |
---|
1268 | -- Name: r_step_type_id_step_type_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1269 | -- |
---|
1270 | |
---|
1271 | ALTER SEQUENCE r_step_type_id_step_type_seq OWNED BY r_step_type.id_step_type; |
---|
1272 | |
---|
1273 | |
---|
1274 | -- |
---|
1275 | -- TOC entry 180 (class 1259 OID 53534) |
---|
1276 | -- Dependencies: 5 |
---|
1277 | -- Name: r_trans_attribute; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1278 | -- |
---|
1279 | |
---|
1280 | CREATE TABLE r_trans_attribute ( |
---|
1281 | id_trans_attribute bigint NOT NULL, |
---|
1282 | id_transformation integer, |
---|
1283 | nr integer, |
---|
1284 | code character varying(255), |
---|
1285 | value_num bigint, |
---|
1286 | value_str character varying(2000000) |
---|
1287 | ); |
---|
1288 | |
---|
1289 | |
---|
1290 | ALTER TABLE public.r_trans_attribute OWNER TO administrador; |
---|
1291 | |
---|
1292 | -- |
---|
1293 | -- TOC entry 179 (class 1259 OID 53532) |
---|
1294 | -- Dependencies: 180 5 |
---|
1295 | -- Name: r_trans_attribute_id_trans_attribute_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1296 | -- |
---|
1297 | |
---|
1298 | CREATE SEQUENCE r_trans_attribute_id_trans_attribute_seq |
---|
1299 | START WITH 1 |
---|
1300 | INCREMENT BY 1 |
---|
1301 | NO MINVALUE |
---|
1302 | NO MAXVALUE |
---|
1303 | CACHE 1; |
---|
1304 | |
---|
1305 | |
---|
1306 | ALTER TABLE public.r_trans_attribute_id_trans_attribute_seq OWNER TO administrador; |
---|
1307 | |
---|
1308 | -- |
---|
1309 | -- TOC entry 2198 (class 0 OID 0) |
---|
1310 | -- Dependencies: 179 |
---|
1311 | -- Name: r_trans_attribute_id_trans_attribute_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1312 | -- |
---|
1313 | |
---|
1314 | ALTER SEQUENCE r_trans_attribute_id_trans_attribute_seq OWNED BY r_trans_attribute.id_trans_attribute; |
---|
1315 | |
---|
1316 | |
---|
1317 | -- |
---|
1318 | -- TOC entry 200 (class 1259 OID 53614) |
---|
1319 | -- Dependencies: 5 |
---|
1320 | -- Name: r_trans_cluster; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1321 | -- |
---|
1322 | |
---|
1323 | CREATE TABLE r_trans_cluster ( |
---|
1324 | id_trans_cluster bigint NOT NULL, |
---|
1325 | id_transformation integer, |
---|
1326 | id_cluster integer |
---|
1327 | ); |
---|
1328 | |
---|
1329 | |
---|
1330 | ALTER TABLE public.r_trans_cluster OWNER TO administrador; |
---|
1331 | |
---|
1332 | -- |
---|
1333 | -- TOC entry 199 (class 1259 OID 53612) |
---|
1334 | -- Dependencies: 200 5 |
---|
1335 | -- Name: r_trans_cluster_id_trans_cluster_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1336 | -- |
---|
1337 | |
---|
1338 | CREATE SEQUENCE r_trans_cluster_id_trans_cluster_seq |
---|
1339 | START WITH 1 |
---|
1340 | INCREMENT BY 1 |
---|
1341 | NO MINVALUE |
---|
1342 | NO MAXVALUE |
---|
1343 | CACHE 1; |
---|
1344 | |
---|
1345 | |
---|
1346 | ALTER TABLE public.r_trans_cluster_id_trans_cluster_seq OWNER TO administrador; |
---|
1347 | |
---|
1348 | -- |
---|
1349 | -- TOC entry 2199 (class 0 OID 0) |
---|
1350 | -- Dependencies: 199 |
---|
1351 | -- Name: r_trans_cluster_id_trans_cluster_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1352 | -- |
---|
1353 | |
---|
1354 | ALTER SEQUENCE r_trans_cluster_id_trans_cluster_seq OWNED BY r_trans_cluster.id_trans_cluster; |
---|
1355 | |
---|
1356 | |
---|
1357 | -- |
---|
1358 | -- TOC entry 202 (class 1259 OID 53620) |
---|
1359 | -- Dependencies: 5 |
---|
1360 | -- Name: r_trans_hop; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1361 | -- |
---|
1362 | |
---|
1363 | CREATE TABLE r_trans_hop ( |
---|
1364 | id_trans_hop bigint NOT NULL, |
---|
1365 | id_transformation integer, |
---|
1366 | id_step_from integer, |
---|
1367 | id_step_to integer, |
---|
1368 | enabled character(1) |
---|
1369 | ); |
---|
1370 | |
---|
1371 | |
---|
1372 | ALTER TABLE public.r_trans_hop OWNER TO administrador; |
---|
1373 | |
---|
1374 | -- |
---|
1375 | -- TOC entry 201 (class 1259 OID 53618) |
---|
1376 | -- Dependencies: 5 202 |
---|
1377 | -- Name: r_trans_hop_id_trans_hop_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1378 | -- |
---|
1379 | |
---|
1380 | CREATE SEQUENCE r_trans_hop_id_trans_hop_seq |
---|
1381 | START WITH 1 |
---|
1382 | INCREMENT BY 1 |
---|
1383 | NO MINVALUE |
---|
1384 | NO MAXVALUE |
---|
1385 | CACHE 1; |
---|
1386 | |
---|
1387 | |
---|
1388 | ALTER TABLE public.r_trans_hop_id_trans_hop_seq OWNER TO administrador; |
---|
1389 | |
---|
1390 | -- |
---|
1391 | -- TOC entry 2200 (class 0 OID 0) |
---|
1392 | -- Dependencies: 201 |
---|
1393 | -- Name: r_trans_hop_id_trans_hop_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1394 | -- |
---|
1395 | |
---|
1396 | ALTER SEQUENCE r_trans_hop_id_trans_hop_seq OWNED BY r_trans_hop.id_trans_hop; |
---|
1397 | |
---|
1398 | |
---|
1399 | -- |
---|
1400 | -- TOC entry 235 (class 1259 OID 53758) |
---|
1401 | -- Dependencies: 5 |
---|
1402 | -- Name: r_trans_lock; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1403 | -- |
---|
1404 | |
---|
1405 | CREATE TABLE r_trans_lock ( |
---|
1406 | id_trans_lock bigint NOT NULL, |
---|
1407 | id_transformation integer, |
---|
1408 | id_user integer, |
---|
1409 | lock_message character varying(2000000), |
---|
1410 | lock_date timestamp without time zone |
---|
1411 | ); |
---|
1412 | |
---|
1413 | |
---|
1414 | ALTER TABLE public.r_trans_lock OWNER TO administrador; |
---|
1415 | |
---|
1416 | -- |
---|
1417 | -- TOC entry 234 (class 1259 OID 53756) |
---|
1418 | -- Dependencies: 235 5 |
---|
1419 | -- Name: r_trans_lock_id_trans_lock_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1420 | -- |
---|
1421 | |
---|
1422 | CREATE SEQUENCE r_trans_lock_id_trans_lock_seq |
---|
1423 | START WITH 1 |
---|
1424 | INCREMENT BY 1 |
---|
1425 | NO MINVALUE |
---|
1426 | NO MAXVALUE |
---|
1427 | CACHE 1; |
---|
1428 | |
---|
1429 | |
---|
1430 | ALTER TABLE public.r_trans_lock_id_trans_lock_seq OWNER TO administrador; |
---|
1431 | |
---|
1432 | -- |
---|
1433 | -- TOC entry 2201 (class 0 OID 0) |
---|
1434 | -- Dependencies: 234 |
---|
1435 | -- Name: r_trans_lock_id_trans_lock_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1436 | -- |
---|
1437 | |
---|
1438 | ALTER SEQUENCE r_trans_lock_id_trans_lock_seq OWNED BY r_trans_lock.id_trans_lock; |
---|
1439 | |
---|
1440 | |
---|
1441 | -- |
---|
1442 | -- TOC entry 215 (class 1259 OID 53678) |
---|
1443 | -- Dependencies: 5 |
---|
1444 | -- Name: r_trans_note; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1445 | -- |
---|
1446 | |
---|
1447 | CREATE TABLE r_trans_note ( |
---|
1448 | id_transformation integer, |
---|
1449 | id_note integer |
---|
1450 | ); |
---|
1451 | |
---|
1452 | |
---|
1453 | ALTER TABLE public.r_trans_note OWNER TO administrador; |
---|
1454 | |
---|
1455 | -- |
---|
1456 | -- TOC entry 190 (class 1259 OID 53578) |
---|
1457 | -- Dependencies: 5 |
---|
1458 | -- Name: r_trans_partition_schema; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1459 | -- |
---|
1460 | |
---|
1461 | CREATE TABLE r_trans_partition_schema ( |
---|
1462 | id_trans_partition_schema bigint NOT NULL, |
---|
1463 | id_transformation integer, |
---|
1464 | id_partition_schema integer |
---|
1465 | ); |
---|
1466 | |
---|
1467 | |
---|
1468 | ALTER TABLE public.r_trans_partition_schema OWNER TO administrador; |
---|
1469 | |
---|
1470 | -- |
---|
1471 | -- TOC entry 189 (class 1259 OID 53576) |
---|
1472 | -- Dependencies: 5 190 |
---|
1473 | -- Name: r_trans_partition_schema_id_trans_partition_schema_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1474 | -- |
---|
1475 | |
---|
1476 | CREATE SEQUENCE r_trans_partition_schema_id_trans_partition_schema_seq |
---|
1477 | START WITH 1 |
---|
1478 | INCREMENT BY 1 |
---|
1479 | NO MINVALUE |
---|
1480 | NO MAXVALUE |
---|
1481 | CACHE 1; |
---|
1482 | |
---|
1483 | |
---|
1484 | ALTER TABLE public.r_trans_partition_schema_id_trans_partition_schema_seq OWNER TO administrador; |
---|
1485 | |
---|
1486 | -- |
---|
1487 | -- TOC entry 2202 (class 0 OID 0) |
---|
1488 | -- Dependencies: 189 |
---|
1489 | -- Name: r_trans_partition_schema_id_trans_partition_schema_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1490 | -- |
---|
1491 | |
---|
1492 | ALTER SEQUENCE r_trans_partition_schema_id_trans_partition_schema_seq OWNED BY r_trans_partition_schema.id_trans_partition_schema; |
---|
1493 | |
---|
1494 | |
---|
1495 | -- |
---|
1496 | -- TOC entry 198 (class 1259 OID 53608) |
---|
1497 | -- Dependencies: 5 |
---|
1498 | -- Name: r_trans_slave; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1499 | -- |
---|
1500 | |
---|
1501 | CREATE TABLE r_trans_slave ( |
---|
1502 | id_trans_slave bigint NOT NULL, |
---|
1503 | id_transformation integer, |
---|
1504 | id_slave integer |
---|
1505 | ); |
---|
1506 | |
---|
1507 | |
---|
1508 | ALTER TABLE public.r_trans_slave OWNER TO administrador; |
---|
1509 | |
---|
1510 | -- |
---|
1511 | -- TOC entry 197 (class 1259 OID 53606) |
---|
1512 | -- Dependencies: 5 198 |
---|
1513 | -- Name: r_trans_slave_id_trans_slave_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1514 | -- |
---|
1515 | |
---|
1516 | CREATE SEQUENCE r_trans_slave_id_trans_slave_seq |
---|
1517 | START WITH 1 |
---|
1518 | INCREMENT BY 1 |
---|
1519 | NO MINVALUE |
---|
1520 | NO MAXVALUE |
---|
1521 | CACHE 1; |
---|
1522 | |
---|
1523 | |
---|
1524 | ALTER TABLE public.r_trans_slave_id_trans_slave_seq OWNER TO administrador; |
---|
1525 | |
---|
1526 | -- |
---|
1527 | -- TOC entry 2203 (class 0 OID 0) |
---|
1528 | -- Dependencies: 197 |
---|
1529 | -- Name: r_trans_slave_id_trans_slave_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1530 | -- |
---|
1531 | |
---|
1532 | ALTER SEQUENCE r_trans_slave_id_trans_slave_seq OWNED BY r_trans_slave.id_trans_slave; |
---|
1533 | |
---|
1534 | |
---|
1535 | -- |
---|
1536 | -- TOC entry 203 (class 1259 OID 53624) |
---|
1537 | -- Dependencies: 5 |
---|
1538 | -- Name: r_trans_step_condition; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1539 | -- |
---|
1540 | |
---|
1541 | CREATE TABLE r_trans_step_condition ( |
---|
1542 | id_transformation integer, |
---|
1543 | id_step integer, |
---|
1544 | id_condition integer |
---|
1545 | ); |
---|
1546 | |
---|
1547 | |
---|
1548 | ALTER TABLE public.r_trans_step_condition OWNER TO administrador; |
---|
1549 | |
---|
1550 | -- |
---|
1551 | -- TOC entry 178 (class 1259 OID 53525) |
---|
1552 | -- Dependencies: 5 |
---|
1553 | -- Name: r_transformation; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1554 | -- |
---|
1555 | |
---|
1556 | CREATE TABLE r_transformation ( |
---|
1557 | id_transformation bigint NOT NULL, |
---|
1558 | id_directory integer, |
---|
1559 | name character varying(255), |
---|
1560 | description character varying(2000000), |
---|
1561 | extended_description character varying(2000000), |
---|
1562 | trans_version character varying(255), |
---|
1563 | trans_status integer, |
---|
1564 | id_step_read integer, |
---|
1565 | id_step_write integer, |
---|
1566 | id_step_input integer, |
---|
1567 | id_step_output integer, |
---|
1568 | id_step_update integer, |
---|
1569 | id_database_log integer, |
---|
1570 | table_name_log character varying(255), |
---|
1571 | use_batchid character(1), |
---|
1572 | use_logfield character(1), |
---|
1573 | id_database_maxdate integer, |
---|
1574 | table_name_maxdate character varying(255), |
---|
1575 | field_name_maxdate character varying(255), |
---|
1576 | offset_maxdate numeric(14,2), |
---|
1577 | diff_maxdate numeric(14,2), |
---|
1578 | created_user character varying(255), |
---|
1579 | created_date timestamp without time zone, |
---|
1580 | modified_user character varying(255), |
---|
1581 | modified_date timestamp without time zone, |
---|
1582 | size_rowset integer |
---|
1583 | ); |
---|
1584 | |
---|
1585 | |
---|
1586 | ALTER TABLE public.r_transformation OWNER TO administrador; |
---|
1587 | |
---|
1588 | -- |
---|
1589 | -- TOC entry 177 (class 1259 OID 53523) |
---|
1590 | -- Dependencies: 178 5 |
---|
1591 | -- Name: r_transformation_id_transformation_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1592 | -- |
---|
1593 | |
---|
1594 | CREATE SEQUENCE r_transformation_id_transformation_seq |
---|
1595 | START WITH 1 |
---|
1596 | INCREMENT BY 1 |
---|
1597 | NO MINVALUE |
---|
1598 | NO MAXVALUE |
---|
1599 | CACHE 1; |
---|
1600 | |
---|
1601 | |
---|
1602 | ALTER TABLE public.r_transformation_id_transformation_seq OWNER TO administrador; |
---|
1603 | |
---|
1604 | -- |
---|
1605 | -- TOC entry 2204 (class 0 OID 0) |
---|
1606 | -- Dependencies: 177 |
---|
1607 | -- Name: r_transformation_id_transformation_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1608 | -- |
---|
1609 | |
---|
1610 | ALTER SEQUENCE r_transformation_id_transformation_seq OWNED BY r_transformation.id_transformation; |
---|
1611 | |
---|
1612 | |
---|
1613 | -- |
---|
1614 | -- TOC entry 239 (class 1259 OID 53776) |
---|
1615 | -- Dependencies: 5 |
---|
1616 | -- Name: r_user; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1617 | -- |
---|
1618 | |
---|
1619 | CREATE TABLE r_user ( |
---|
1620 | id_user bigint NOT NULL, |
---|
1621 | login character varying(255), |
---|
1622 | password character varying(255), |
---|
1623 | name character varying(255), |
---|
1624 | description character varying(255), |
---|
1625 | enabled character(1) |
---|
1626 | ); |
---|
1627 | |
---|
1628 | |
---|
1629 | ALTER TABLE public.r_user OWNER TO administrador; |
---|
1630 | |
---|
1631 | -- |
---|
1632 | -- TOC entry 238 (class 1259 OID 53774) |
---|
1633 | -- Dependencies: 239 5 |
---|
1634 | -- Name: r_user_id_user_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1635 | -- |
---|
1636 | |
---|
1637 | CREATE SEQUENCE r_user_id_user_seq |
---|
1638 | START WITH 1 |
---|
1639 | INCREMENT BY 1 |
---|
1640 | NO MINVALUE |
---|
1641 | NO MAXVALUE |
---|
1642 | CACHE 1; |
---|
1643 | |
---|
1644 | |
---|
1645 | ALTER TABLE public.r_user_id_user_seq OWNER TO administrador; |
---|
1646 | |
---|
1647 | -- |
---|
1648 | -- TOC entry 2205 (class 0 OID 0) |
---|
1649 | -- Dependencies: 238 |
---|
1650 | -- Name: r_user_id_user_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1651 | -- |
---|
1652 | |
---|
1653 | ALTER SEQUENCE r_user_id_user_seq OWNED BY r_user.id_user; |
---|
1654 | |
---|
1655 | |
---|
1656 | -- |
---|
1657 | -- TOC entry 207 (class 1259 OID 53638) |
---|
1658 | -- Dependencies: 5 |
---|
1659 | -- Name: r_value; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1660 | -- |
---|
1661 | |
---|
1662 | CREATE TABLE r_value ( |
---|
1663 | id_value bigint NOT NULL, |
---|
1664 | name character varying(255), |
---|
1665 | value_type character varying(255), |
---|
1666 | value_str character varying(255), |
---|
1667 | is_null character(1) |
---|
1668 | ); |
---|
1669 | |
---|
1670 | |
---|
1671 | ALTER TABLE public.r_value OWNER TO administrador; |
---|
1672 | |
---|
1673 | -- |
---|
1674 | -- TOC entry 206 (class 1259 OID 53636) |
---|
1675 | -- Dependencies: 5 207 |
---|
1676 | -- Name: r_value_id_value_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1677 | -- |
---|
1678 | |
---|
1679 | CREATE SEQUENCE r_value_id_value_seq |
---|
1680 | START WITH 1 |
---|
1681 | INCREMENT BY 1 |
---|
1682 | NO MINVALUE |
---|
1683 | NO MAXVALUE |
---|
1684 | CACHE 1; |
---|
1685 | |
---|
1686 | |
---|
1687 | ALTER TABLE public.r_value_id_value_seq OWNER TO administrador; |
---|
1688 | |
---|
1689 | -- |
---|
1690 | -- TOC entry 2206 (class 0 OID 0) |
---|
1691 | -- Dependencies: 206 |
---|
1692 | -- Name: r_value_id_value_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1693 | -- |
---|
1694 | |
---|
1695 | ALTER SEQUENCE r_value_id_value_seq OWNED BY r_value.id_value; |
---|
1696 | |
---|
1697 | |
---|
1698 | -- |
---|
1699 | -- TOC entry 164 (class 1259 OID 53466) |
---|
1700 | -- Dependencies: 5 |
---|
1701 | -- Name: r_version; Type: TABLE; Schema: public; Owner: administrador; Tablespace: |
---|
1702 | -- |
---|
1703 | |
---|
1704 | CREATE TABLE r_version ( |
---|
1705 | id_version bigint NOT NULL, |
---|
1706 | major_version smallint, |
---|
1707 | minor_version smallint, |
---|
1708 | upgrade_date timestamp without time zone, |
---|
1709 | is_upgrade character(1) |
---|
1710 | ); |
---|
1711 | |
---|
1712 | |
---|
1713 | ALTER TABLE public.r_version OWNER TO administrador; |
---|
1714 | |
---|
1715 | -- |
---|
1716 | -- TOC entry 163 (class 1259 OID 53464) |
---|
1717 | -- Dependencies: 5 164 |
---|
1718 | -- Name: r_version_id_version_seq; Type: SEQUENCE; Schema: public; Owner: administrador |
---|
1719 | -- |
---|
1720 | |
---|
1721 | CREATE SEQUENCE r_version_id_version_seq |
---|
1722 | START WITH 1 |
---|
1723 | INCREMENT BY 1 |
---|
1724 | NO MINVALUE |
---|
1725 | NO MAXVALUE |
---|
1726 | CACHE 1; |
---|
1727 | |
---|
1728 | |
---|
1729 | ALTER TABLE public.r_version_id_version_seq OWNER TO administrador; |
---|
1730 | |
---|
1731 | -- |
---|
1732 | -- TOC entry 2207 (class 0 OID 0) |
---|
1733 | -- Dependencies: 163 |
---|
1734 | -- Name: r_version_id_version_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: administrador |
---|
1735 | -- |
---|
1736 | |
---|
1737 | ALTER SEQUENCE r_version_id_version_seq OWNED BY r_version.id_version; |
---|
1738 | |
---|
1739 | |
---|
1740 | -- |
---|
1741 | -- TOC entry 2130 (class 2604 OID 53587) |
---|
1742 | -- Dependencies: 192 191 192 |
---|
1743 | -- Name: id_cluster; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1744 | -- |
---|
1745 | |
---|
1746 | ALTER TABLE ONLY r_cluster ALTER COLUMN id_cluster SET DEFAULT nextval('r_cluster_id_cluster_seq'::regclass); |
---|
1747 | |
---|
1748 | |
---|
1749 | -- |
---|
1750 | -- TOC entry 2132 (class 2604 OID 53605) |
---|
1751 | -- Dependencies: 196 195 196 |
---|
1752 | -- Name: id_cluster_slave; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1753 | -- |
---|
1754 | |
---|
1755 | ALTER TABLE ONLY r_cluster_slave ALTER COLUMN id_cluster_slave SET DEFAULT nextval('r_cluster_slave_id_cluster_slave_seq'::regclass); |
---|
1756 | |
---|
1757 | |
---|
1758 | -- |
---|
1759 | -- TOC entry 2136 (class 2604 OID 53632) |
---|
1760 | -- Dependencies: 204 205 205 |
---|
1761 | -- Name: id_condition; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1762 | -- |
---|
1763 | |
---|
1764 | ALTER TABLE ONLY r_condition ALTER COLUMN id_condition SET DEFAULT nextval('r_condition_id_condition_seq'::regclass); |
---|
1765 | |
---|
1766 | |
---|
1767 | -- |
---|
1768 | -- TOC entry 2120 (class 2604 OID 53502) |
---|
1769 | -- Dependencies: 171 172 172 |
---|
1770 | -- Name: id_database; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1771 | -- |
---|
1772 | |
---|
1773 | ALTER TABLE ONLY r_database ALTER COLUMN id_database SET DEFAULT nextval('r_database_id_database_seq'::regclass); |
---|
1774 | |
---|
1775 | |
---|
1776 | -- |
---|
1777 | -- TOC entry 2121 (class 2604 OID 53511) |
---|
1778 | -- Dependencies: 174 173 174 |
---|
1779 | -- Name: id_database_attribute; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1780 | -- |
---|
1781 | |
---|
1782 | ALTER TABLE ONLY r_database_attribute ALTER COLUMN id_database_attribute SET DEFAULT nextval('r_database_attribute_id_database_attribute_seq'::regclass); |
---|
1783 | |
---|
1784 | |
---|
1785 | -- |
---|
1786 | -- TOC entry 2118 (class 2604 OID 53484) |
---|
1787 | -- Dependencies: 167 168 168 |
---|
1788 | -- Name: id_database_contype; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1789 | -- |
---|
1790 | |
---|
1791 | ALTER TABLE ONLY r_database_contype ALTER COLUMN id_database_contype SET DEFAULT nextval('r_database_contype_id_database_contype_seq'::regclass); |
---|
1792 | |
---|
1793 | |
---|
1794 | -- |
---|
1795 | -- TOC entry 2117 (class 2604 OID 53475) |
---|
1796 | -- Dependencies: 165 166 166 |
---|
1797 | -- Name: id_database_type; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1798 | -- |
---|
1799 | |
---|
1800 | ALTER TABLE ONLY r_database_type ALTER COLUMN id_database_type SET DEFAULT nextval('r_database_type_id_database_type_seq'::regclass); |
---|
1801 | |
---|
1802 | |
---|
1803 | -- |
---|
1804 | -- TOC entry 2126 (class 2604 OID 53557) |
---|
1805 | -- Dependencies: 183 184 184 |
---|
1806 | -- Name: id_dependency; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1807 | -- |
---|
1808 | |
---|
1809 | ALTER TABLE ONLY r_dependency ALTER COLUMN id_dependency SET DEFAULT nextval('r_dependency_id_dependency_seq'::regclass); |
---|
1810 | |
---|
1811 | |
---|
1812 | -- |
---|
1813 | -- TOC entry 2122 (class 2604 OID 53521) |
---|
1814 | -- Dependencies: 175 176 176 |
---|
1815 | -- Name: id_directory; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1816 | -- |
---|
1817 | |
---|
1818 | ALTER TABLE ONLY r_directory ALTER COLUMN id_directory SET DEFAULT nextval('r_directory_id_directory_seq'::regclass); |
---|
1819 | |
---|
1820 | |
---|
1821 | -- |
---|
1822 | -- TOC entry 2143 (class 2604 OID 53704) |
---|
1823 | -- Dependencies: 221 220 221 |
---|
1824 | -- Name: id_job; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1825 | -- |
---|
1826 | |
---|
1827 | ALTER TABLE ONLY r_job ALTER COLUMN id_job SET DEFAULT nextval('r_job_id_job_seq'::regclass); |
---|
1828 | |
---|
1829 | |
---|
1830 | -- |
---|
1831 | -- TOC entry 2125 (class 2604 OID 53547) |
---|
1832 | -- Dependencies: 182 181 182 |
---|
1833 | -- Name: id_job_attribute; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1834 | -- |
---|
1835 | |
---|
1836 | ALTER TABLE ONLY r_job_attribute ALTER COLUMN id_job_attribute SET DEFAULT nextval('r_job_attribute_id_job_attribute_seq'::regclass); |
---|
1837 | |
---|
1838 | |
---|
1839 | -- |
---|
1840 | -- TOC entry 2148 (class 2604 OID 53752) |
---|
1841 | -- Dependencies: 231 232 232 |
---|
1842 | -- Name: id_job_hop; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1843 | -- |
---|
1844 | |
---|
1845 | ALTER TABLE ONLY r_job_hop ALTER COLUMN id_job_hop SET DEFAULT nextval('r_job_hop_id_job_hop_seq'::regclass); |
---|
1846 | |
---|
1847 | |
---|
1848 | -- |
---|
1849 | -- TOC entry 2150 (class 2604 OID 53770) |
---|
1850 | -- Dependencies: 237 236 237 |
---|
1851 | -- Name: id_job_lock; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1852 | -- |
---|
1853 | |
---|
1854 | ALTER TABLE ONLY r_job_lock ALTER COLUMN id_job_lock SET DEFAULT nextval('r_job_lock_id_job_lock_seq'::regclass); |
---|
1855 | |
---|
1856 | |
---|
1857 | -- |
---|
1858 | -- TOC entry 2145 (class 2604 OID 53727) |
---|
1859 | -- Dependencies: 226 225 226 |
---|
1860 | -- Name: id_jobentry; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1861 | -- |
---|
1862 | |
---|
1863 | ALTER TABLE ONLY r_jobentry ALTER COLUMN id_jobentry SET DEFAULT nextval('r_jobentry_id_jobentry_seq'::regclass); |
---|
1864 | |
---|
1865 | |
---|
1866 | -- |
---|
1867 | -- TOC entry 2147 (class 2604 OID 53742) |
---|
1868 | -- Dependencies: 230 229 230 |
---|
1869 | -- Name: id_jobentry_attribute; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1870 | -- |
---|
1871 | |
---|
1872 | ALTER TABLE ONLY r_jobentry_attribute ALTER COLUMN id_jobentry_attribute SET DEFAULT nextval('r_jobentry_attribute_id_jobentry_attribute_seq'::regclass); |
---|
1873 | |
---|
1874 | |
---|
1875 | -- |
---|
1876 | -- TOC entry 2146 (class 2604 OID 53736) |
---|
1877 | -- Dependencies: 227 228 228 |
---|
1878 | -- Name: id_jobentry_copy; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1879 | -- |
---|
1880 | |
---|
1881 | ALTER TABLE ONLY r_jobentry_copy ALTER COLUMN id_jobentry_copy SET DEFAULT nextval('r_jobentry_copy_id_jobentry_copy_seq'::regclass); |
---|
1882 | |
---|
1883 | |
---|
1884 | -- |
---|
1885 | -- TOC entry 2144 (class 2604 OID 53718) |
---|
1886 | -- Dependencies: 224 223 224 |
---|
1887 | -- Name: id_jobentry_type; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1888 | -- |
---|
1889 | |
---|
1890 | ALTER TABLE ONLY r_jobentry_type ALTER COLUMN id_jobentry_type SET DEFAULT nextval('r_jobentry_type_id_jobentry_type_seq'::regclass); |
---|
1891 | |
---|
1892 | |
---|
1893 | -- |
---|
1894 | -- TOC entry 2142 (class 2604 OID 53695) |
---|
1895 | -- Dependencies: 219 218 219 |
---|
1896 | -- Name: id_log; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1897 | -- |
---|
1898 | |
---|
1899 | ALTER TABLE ONLY r_log ALTER COLUMN id_log SET DEFAULT nextval('r_log_id_log_seq'::regclass); |
---|
1900 | |
---|
1901 | |
---|
1902 | -- |
---|
1903 | -- TOC entry 2141 (class 2604 OID 53686) |
---|
1904 | -- Dependencies: 217 216 217 |
---|
1905 | -- Name: id_loglevel; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1906 | -- |
---|
1907 | |
---|
1908 | ALTER TABLE ONLY r_loglevel ALTER COLUMN id_loglevel SET DEFAULT nextval('r_loglevel_id_loglevel_seq'::regclass); |
---|
1909 | |
---|
1910 | |
---|
1911 | -- |
---|
1912 | -- TOC entry 2119 (class 2604 OID 53493) |
---|
1913 | -- Dependencies: 170 169 170 |
---|
1914 | -- Name: id_note; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1915 | -- |
---|
1916 | |
---|
1917 | ALTER TABLE ONLY r_note ALTER COLUMN id_note SET DEFAULT nextval('r_note_id_note_seq'::regclass); |
---|
1918 | |
---|
1919 | |
---|
1920 | -- |
---|
1921 | -- TOC entry 2128 (class 2604 OID 53575) |
---|
1922 | -- Dependencies: 188 187 188 |
---|
1923 | -- Name: id_partition; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1924 | -- |
---|
1925 | |
---|
1926 | ALTER TABLE ONLY r_partition ALTER COLUMN id_partition SET DEFAULT nextval('r_partition_id_partition_seq'::regclass); |
---|
1927 | |
---|
1928 | |
---|
1929 | -- |
---|
1930 | -- TOC entry 2127 (class 2604 OID 53566) |
---|
1931 | -- Dependencies: 186 185 186 |
---|
1932 | -- Name: id_partition_schema; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1933 | -- |
---|
1934 | |
---|
1935 | ALTER TABLE ONLY r_partition_schema ALTER COLUMN id_partition_schema SET DEFAULT nextval('r_partition_schema_id_partition_schema_seq'::regclass); |
---|
1936 | |
---|
1937 | |
---|
1938 | -- |
---|
1939 | -- TOC entry 2115 (class 2604 OID 53460) |
---|
1940 | -- Dependencies: 162 161 162 |
---|
1941 | -- Name: id_repository_log; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1942 | -- |
---|
1943 | |
---|
1944 | ALTER TABLE ONLY r_repository_log ALTER COLUMN id_repository_log SET DEFAULT nextval('r_repository_log_id_repository_log_seq'::regclass); |
---|
1945 | |
---|
1946 | |
---|
1947 | -- |
---|
1948 | -- TOC entry 2131 (class 2604 OID 53596) |
---|
1949 | -- Dependencies: 193 194 194 |
---|
1950 | -- Name: id_slave; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1951 | -- |
---|
1952 | |
---|
1953 | ALTER TABLE ONLY r_slave ALTER COLUMN id_slave SET DEFAULT nextval('r_slave_id_slave_seq'::regclass); |
---|
1954 | |
---|
1955 | |
---|
1956 | -- |
---|
1957 | -- TOC entry 2139 (class 2604 OID 53659) |
---|
1958 | -- Dependencies: 211 210 211 |
---|
1959 | -- Name: id_step; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1960 | -- |
---|
1961 | |
---|
1962 | ALTER TABLE ONLY r_step ALTER COLUMN id_step SET DEFAULT nextval('r_step_id_step_seq'::regclass); |
---|
1963 | |
---|
1964 | |
---|
1965 | -- |
---|
1966 | -- TOC entry 2140 (class 2604 OID 53668) |
---|
1967 | -- Dependencies: 212 213 213 |
---|
1968 | -- Name: id_step_attribute; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1969 | -- |
---|
1970 | |
---|
1971 | ALTER TABLE ONLY r_step_attribute ALTER COLUMN id_step_attribute SET DEFAULT nextval('r_step_attribute_id_step_attribute_seq'::regclass); |
---|
1972 | |
---|
1973 | |
---|
1974 | -- |
---|
1975 | -- TOC entry 2138 (class 2604 OID 53650) |
---|
1976 | -- Dependencies: 209 208 209 |
---|
1977 | -- Name: id_step_type; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1978 | -- |
---|
1979 | |
---|
1980 | ALTER TABLE ONLY r_step_type ALTER COLUMN id_step_type SET DEFAULT nextval('r_step_type_id_step_type_seq'::regclass); |
---|
1981 | |
---|
1982 | |
---|
1983 | -- |
---|
1984 | -- TOC entry 2124 (class 2604 OID 53537) |
---|
1985 | -- Dependencies: 179 180 180 |
---|
1986 | -- Name: id_trans_attribute; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1987 | -- |
---|
1988 | |
---|
1989 | ALTER TABLE ONLY r_trans_attribute ALTER COLUMN id_trans_attribute SET DEFAULT nextval('r_trans_attribute_id_trans_attribute_seq'::regclass); |
---|
1990 | |
---|
1991 | |
---|
1992 | -- |
---|
1993 | -- TOC entry 2134 (class 2604 OID 53617) |
---|
1994 | -- Dependencies: 200 199 200 |
---|
1995 | -- Name: id_trans_cluster; Type: DEFAULT; Schema: public; Owner: administrador |
---|
1996 | -- |
---|
1997 | |
---|
1998 | ALTER TABLE ONLY r_trans_cluster ALTER COLUMN id_trans_cluster SET DEFAULT nextval('r_trans_cluster_id_trans_cluster_seq'::regclass); |
---|
1999 | |
---|
2000 | |
---|
2001 | -- |
---|
2002 | -- TOC entry 2135 (class 2604 OID 53623) |
---|
2003 | -- Dependencies: 202 201 202 |
---|
2004 | -- Name: id_trans_hop; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2005 | -- |
---|
2006 | |
---|
2007 | ALTER TABLE ONLY r_trans_hop ALTER COLUMN id_trans_hop SET DEFAULT nextval('r_trans_hop_id_trans_hop_seq'::regclass); |
---|
2008 | |
---|
2009 | |
---|
2010 | -- |
---|
2011 | -- TOC entry 2149 (class 2604 OID 53761) |
---|
2012 | -- Dependencies: 234 235 235 |
---|
2013 | -- Name: id_trans_lock; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2014 | -- |
---|
2015 | |
---|
2016 | ALTER TABLE ONLY r_trans_lock ALTER COLUMN id_trans_lock SET DEFAULT nextval('r_trans_lock_id_trans_lock_seq'::regclass); |
---|
2017 | |
---|
2018 | |
---|
2019 | -- |
---|
2020 | -- TOC entry 2129 (class 2604 OID 53581) |
---|
2021 | -- Dependencies: 190 189 190 |
---|
2022 | -- Name: id_trans_partition_schema; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2023 | -- |
---|
2024 | |
---|
2025 | ALTER TABLE ONLY r_trans_partition_schema ALTER COLUMN id_trans_partition_schema SET DEFAULT nextval('r_trans_partition_schema_id_trans_partition_schema_seq'::regclass); |
---|
2026 | |
---|
2027 | |
---|
2028 | -- |
---|
2029 | -- TOC entry 2133 (class 2604 OID 53611) |
---|
2030 | -- Dependencies: 198 197 198 |
---|
2031 | -- Name: id_trans_slave; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2032 | -- |
---|
2033 | |
---|
2034 | ALTER TABLE ONLY r_trans_slave ALTER COLUMN id_trans_slave SET DEFAULT nextval('r_trans_slave_id_trans_slave_seq'::regclass); |
---|
2035 | |
---|
2036 | |
---|
2037 | -- |
---|
2038 | -- TOC entry 2123 (class 2604 OID 53528) |
---|
2039 | -- Dependencies: 178 177 178 |
---|
2040 | -- Name: id_transformation; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2041 | -- |
---|
2042 | |
---|
2043 | ALTER TABLE ONLY r_transformation ALTER COLUMN id_transformation SET DEFAULT nextval('r_transformation_id_transformation_seq'::regclass); |
---|
2044 | |
---|
2045 | |
---|
2046 | -- |
---|
2047 | -- TOC entry 2151 (class 2604 OID 53779) |
---|
2048 | -- Dependencies: 238 239 239 |
---|
2049 | -- Name: id_user; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2050 | -- |
---|
2051 | |
---|
2052 | ALTER TABLE ONLY r_user ALTER COLUMN id_user SET DEFAULT nextval('r_user_id_user_seq'::regclass); |
---|
2053 | |
---|
2054 | |
---|
2055 | -- |
---|
2056 | -- TOC entry 2137 (class 2604 OID 53641) |
---|
2057 | -- Dependencies: 207 206 207 |
---|
2058 | -- Name: id_value; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2059 | -- |
---|
2060 | |
---|
2061 | ALTER TABLE ONLY r_value ALTER COLUMN id_value SET DEFAULT nextval('r_value_id_value_seq'::regclass); |
---|
2062 | |
---|
2063 | |
---|
2064 | -- |
---|
2065 | -- TOC entry 2116 (class 2604 OID 53469) |
---|
2066 | -- Dependencies: 164 163 164 |
---|
2067 | -- Name: id_version; Type: DEFAULT; Schema: public; Owner: administrador |
---|
2068 | -- |
---|
2069 | |
---|
2070 | ALTER TABLE ONLY r_version ALTER COLUMN id_version SET DEFAULT nextval('r_version_id_version_seq'::regclass); |
---|
2071 | |
---|
2072 | |
---|
2073 | -- |
---|
2074 | -- TOC entry 2155 (class 1259 OID 53551) |
---|
2075 | -- Dependencies: 182 182 182 2163 |
---|
2076 | -- Name: idx_job_attribute_lookup; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2077 | -- |
---|
2078 | |
---|
2079 | CREATE UNIQUE INDEX idx_job_attribute_lookup ON r_job_attribute USING btree (id_job, code, nr); |
---|
2080 | |
---|
2081 | |
---|
2082 | -- |
---|
2083 | -- TOC entry 2152 (class 1259 OID 53515) |
---|
2084 | -- Dependencies: 174 174 2163 |
---|
2085 | -- Name: idx_r_database_attribute_ak; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2086 | -- |
---|
2087 | |
---|
2088 | CREATE UNIQUE INDEX idx_r_database_attribute_ak ON r_database_attribute USING btree (id_database, code); |
---|
2089 | |
---|
2090 | |
---|
2091 | -- |
---|
2092 | -- TOC entry 2153 (class 1259 OID 53522) |
---|
2093 | -- Dependencies: 176 176 2163 |
---|
2094 | -- Name: idx_r_directory_ak; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2095 | -- |
---|
2096 | |
---|
2097 | CREATE UNIQUE INDEX idx_r_directory_ak ON r_directory USING btree (id_directory_parent, directory_name); |
---|
2098 | |
---|
2099 | |
---|
2100 | -- |
---|
2101 | -- TOC entry 2161 (class 1259 OID 53746) |
---|
2102 | -- Dependencies: 230 230 230 2163 |
---|
2103 | -- Name: idx_r_jobentry_attribute_lookup; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2104 | -- |
---|
2105 | |
---|
2106 | CREATE UNIQUE INDEX idx_r_jobentry_attribute_lookup ON r_jobentry_attribute USING btree (id_jobentry_attribute, code, nr); |
---|
2107 | |
---|
2108 | |
---|
2109 | -- |
---|
2110 | -- TOC entry 2159 (class 1259 OID 53711) |
---|
2111 | -- Dependencies: 222 2163 |
---|
2112 | -- Name: idx_r_jobentry_database_lu1; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2113 | -- |
---|
2114 | |
---|
2115 | CREATE INDEX idx_r_jobentry_database_lu1 ON r_jobentry_database USING btree (id_job); |
---|
2116 | |
---|
2117 | |
---|
2118 | -- |
---|
2119 | -- TOC entry 2160 (class 1259 OID 53712) |
---|
2120 | -- Dependencies: 222 2163 |
---|
2121 | -- Name: idx_r_jobentry_database_lu2; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2122 | -- |
---|
2123 | |
---|
2124 | CREATE INDEX idx_r_jobentry_database_lu2 ON r_jobentry_database USING btree (id_database); |
---|
2125 | |
---|
2126 | |
---|
2127 | -- |
---|
2128 | -- TOC entry 2156 (class 1259 OID 53672) |
---|
2129 | -- Dependencies: 213 213 213 2163 |
---|
2130 | -- Name: idx_r_step_attribute_lookup; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2131 | -- |
---|
2132 | |
---|
2133 | CREATE UNIQUE INDEX idx_r_step_attribute_lookup ON r_step_attribute USING btree (id_step, code, nr); |
---|
2134 | |
---|
2135 | |
---|
2136 | -- |
---|
2137 | -- TOC entry 2157 (class 1259 OID 53676) |
---|
2138 | -- Dependencies: 214 2163 |
---|
2139 | -- Name: idx_r_step_database_lu1; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2140 | -- |
---|
2141 | |
---|
2142 | CREATE INDEX idx_r_step_database_lu1 ON r_step_database USING btree (id_transformation); |
---|
2143 | |
---|
2144 | |
---|
2145 | -- |
---|
2146 | -- TOC entry 2158 (class 1259 OID 53677) |
---|
2147 | -- Dependencies: 214 2163 |
---|
2148 | -- Name: idx_r_step_database_lu2; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2149 | -- |
---|
2150 | |
---|
2151 | CREATE INDEX idx_r_step_database_lu2 ON r_step_database USING btree (id_database); |
---|
2152 | |
---|
2153 | |
---|
2154 | -- |
---|
2155 | -- TOC entry 2154 (class 1259 OID 53541) |
---|
2156 | -- Dependencies: 180 180 180 2163 |
---|
2157 | -- Name: idx_trans_attribute_lookup; Type: INDEX; Schema: public; Owner: administrador; Tablespace: |
---|
2158 | -- |
---|
2159 | |
---|
2160 | CREATE UNIQUE INDEX idx_trans_attribute_lookup ON r_trans_attribute USING btree (id_transformation, code, nr); |
---|
2161 | |
---|
2162 | |
---|
2163 | -- |
---|
2164 | -- TOC entry 2169 (class 0 OID 0) |
---|
2165 | -- Dependencies: 5 |
---|
2166 | -- Name: public; Type: ACL; Schema: -; Owner: postgres |
---|
2167 | -- |
---|
2168 | |
---|
2169 | REVOKE ALL ON SCHEMA public FROM PUBLIC; |
---|
2170 | REVOKE ALL ON SCHEMA public FROM postgres; |
---|
2171 | GRANT ALL ON SCHEMA public TO postgres; |
---|
2172 | GRANT ALL ON SCHEMA public TO PUBLIC; |
---|
2173 | |
---|
2174 | |
---|
2175 | -- Completed on 2013-05-30 11:25:59 VET |
---|
2176 | |
---|
2177 | -- |
---|
2178 | -- PostgreSQL database dump complete |
---|
2179 | -- |
---|
2180 | |
---|