[1255] | 1 | -- |
---|
| 2 | -- PostgreSQL database dump |
---|
| 3 | -- |
---|
| 4 | |
---|
| 5 | SET client_encoding = 'LATIN1'; |
---|
| 6 | SET standard_conforming_strings = off; |
---|
| 7 | SET check_function_bodies = false; |
---|
| 8 | SET client_min_messages = warning; |
---|
| 9 | SET escape_string_warning = off; |
---|
| 10 | |
---|
| 11 | -- |
---|
| 12 | -- Name: workflow; Type: DATABASE; Schema: -; Owner: postgres |
---|
| 13 | -- |
---|
| 14 | |
---|
| 15 | CREATE DATABASE workflow WITH TEMPLATE = template0 ENCODING = 'LATIN1'; |
---|
| 16 | |
---|
| 17 | |
---|
| 18 | ALTER DATABASE workflow OWNER TO postgres; |
---|
| 19 | |
---|
| 20 | CREATE USER admin_workflow WITH PASSWORD 'admin_workflow' NOCREATEDB NOCREATEUSER VALID UNTIL 'infinity'; |
---|
| 21 | CREATE GROUP workflow; |
---|
| 22 | ALTER GROUP workflow ADD USER admin_workflow; |
---|
| 23 | GRANT workflow TO admin_workflow; |
---|
| 24 | CREATE USER admin_cds WITH PASSWORD 'admin_cds' NOCREATEDB NOCREATEUSER VALID UNTIL 'infinity'; |
---|
| 25 | ALTER GROUP workflow ADD USER admin_cds; |
---|
| 26 | GRANT workflow TO admin_cds; |
---|
| 27 | |
---|
| 28 | \connect workflow |
---|
| 29 | |
---|
| 30 | SET client_encoding = 'LATIN1'; |
---|
| 31 | SET standard_conforming_strings = off; |
---|
| 32 | SET check_function_bodies = false; |
---|
| 33 | SET client_min_messages = warning; |
---|
| 34 | SET escape_string_warning = off; |
---|
| 35 | |
---|
| 36 | -- |
---|
| 37 | -- Name: cds; Type: SCHEMA; Schema: -; Owner: admin_cds |
---|
| 38 | -- |
---|
| 39 | |
---|
| 40 | CREATE SCHEMA cds; |
---|
| 41 | |
---|
| 42 | |
---|
| 43 | ALTER SCHEMA cds OWNER TO admin_cds; |
---|
| 44 | |
---|
| 45 | SET search_path = cds, pg_catalog; |
---|
| 46 | |
---|
| 47 | SET default_tablespace = ''; |
---|
| 48 | |
---|
| 49 | SET default_with_oids = false; |
---|
| 50 | |
---|
| 51 | -- |
---|
| 52 | -- Name: cdcollection; Type: TABLE; Schema: cds; Owner: admin_cds; Tablespace: |
---|
| 53 | -- |
---|
| 54 | |
---|
| 55 | CREATE TABLE cdcollection ( |
---|
| 56 | cdid integer NOT NULL, |
---|
| 57 | title character varying(200), |
---|
| 58 | status character varying(40), |
---|
| 59 | usuario character varying(200) |
---|
| 60 | ); |
---|
| 61 | |
---|
| 62 | |
---|
| 63 | ALTER TABLE cds.cdcollection OWNER TO admin_cds; |
---|
| 64 | |
---|
| 65 | -- |
---|
| 66 | -- Name: TABLE cdcollection; Type: COMMENT; Schema: cds; Owner: admin_cds |
---|
| 67 | -- |
---|
| 68 | |
---|
| 69 | COMMENT ON TABLE cdcollection IS 'Exemplo de Empréstimo de CDs'; |
---|
| 70 | |
---|
| 71 | |
---|
| 72 | SET search_path = public, pg_catalog; |
---|
| 73 | |
---|
| 74 | -- |
---|
| 75 | -- Name: area; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 76 | -- |
---|
| 77 | |
---|
| 78 | CREATE TABLE area ( |
---|
| 79 | organizacao_id integer NOT NULL, |
---|
| 80 | area_id integer NOT NULL, |
---|
| 81 | area_status_id integer NOT NULL, |
---|
| 82 | areasup_organizacao_id integer, |
---|
| 83 | superior_area_id integer, |
---|
| 84 | centro_custo_id integer, |
---|
| 85 | titular_funcionario_id integer, |
---|
| 86 | substituto_funcionario_id integer, |
---|
| 87 | sigla character varying(20) NOT NULL, |
---|
| 88 | descricao character varying(100) NOT NULL, |
---|
| 89 | ativa character varying(1) NOT NULL, |
---|
| 90 | auxiliar_funcionario_id integer |
---|
| 91 | ); |
---|
| 92 | |
---|
| 93 | |
---|
| 94 | ALTER TABLE public.area OWNER TO postgres; |
---|
| 95 | |
---|
| 96 | -- |
---|
| 97 | -- Name: area_area_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 98 | -- |
---|
| 99 | |
---|
| 100 | CREATE SEQUENCE area_area_id_seq |
---|
| 101 | START WITH 1 |
---|
| 102 | INCREMENT BY 1 |
---|
| 103 | NO MAXVALUE |
---|
| 104 | NO MINVALUE |
---|
| 105 | CACHE 1; |
---|
| 106 | |
---|
| 107 | |
---|
| 108 | ALTER TABLE public.area_area_id_seq OWNER TO postgres; |
---|
| 109 | |
---|
| 110 | -- |
---|
| 111 | -- Name: area_area_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 112 | -- |
---|
| 113 | |
---|
| 114 | ALTER SEQUENCE area_area_id_seq OWNED BY area.area_id; |
---|
| 115 | |
---|
| 116 | |
---|
| 117 | -- |
---|
| 118 | -- Name: area_area_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 119 | -- |
---|
| 120 | |
---|
| 121 | SELECT pg_catalog.setval('area_area_id_seq', 1, false); |
---|
| 122 | |
---|
| 123 | |
---|
| 124 | -- |
---|
| 125 | -- Name: area_status; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 126 | -- |
---|
| 127 | |
---|
| 128 | CREATE TABLE area_status ( |
---|
| 129 | area_status_id integer NOT NULL, |
---|
| 130 | organizacao_id integer NOT NULL, |
---|
| 131 | descricao character varying(50) NOT NULL, |
---|
| 132 | nivel integer NOT NULL |
---|
| 133 | ); |
---|
| 134 | |
---|
| 135 | |
---|
| 136 | ALTER TABLE public.area_status OWNER TO postgres; |
---|
| 137 | |
---|
| 138 | -- |
---|
| 139 | -- Name: area_status_area_status_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 140 | -- |
---|
| 141 | |
---|
| 142 | CREATE SEQUENCE area_status_area_status_id_seq |
---|
| 143 | START WITH 1 |
---|
| 144 | INCREMENT BY 1 |
---|
| 145 | NO MAXVALUE |
---|
| 146 | NO MINVALUE |
---|
| 147 | CACHE 1; |
---|
| 148 | |
---|
| 149 | |
---|
| 150 | ALTER TABLE public.area_status_area_status_id_seq OWNER TO postgres; |
---|
| 151 | |
---|
| 152 | -- |
---|
| 153 | -- Name: area_status_area_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 154 | -- |
---|
| 155 | |
---|
| 156 | ALTER SEQUENCE area_status_area_status_id_seq OWNED BY area_status.area_status_id; |
---|
| 157 | |
---|
| 158 | |
---|
| 159 | -- |
---|
| 160 | -- Name: area_status_area_status_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 161 | -- |
---|
| 162 | |
---|
| 163 | SELECT pg_catalog.setval('area_status_area_status_id_seq', 1, false); |
---|
| 164 | |
---|
| 165 | |
---|
| 166 | -- |
---|
| 167 | -- Name: cargo; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 168 | -- |
---|
| 169 | |
---|
| 170 | CREATE TABLE cargo ( |
---|
| 171 | cargo_id integer NOT NULL, |
---|
| 172 | descricao character varying(150), |
---|
| 173 | organizacao_id integer |
---|
| 174 | ); |
---|
| 175 | |
---|
| 176 | |
---|
| 177 | ALTER TABLE public.cargo OWNER TO postgres; |
---|
| 178 | |
---|
| 179 | -- |
---|
| 180 | -- Name: cargo_cargo_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 181 | -- |
---|
| 182 | |
---|
| 183 | CREATE SEQUENCE cargo_cargo_id_seq |
---|
| 184 | START WITH 1 |
---|
| 185 | INCREMENT BY 1 |
---|
| 186 | NO MAXVALUE |
---|
| 187 | NO MINVALUE |
---|
| 188 | CACHE 1; |
---|
| 189 | |
---|
| 190 | |
---|
| 191 | ALTER TABLE public.cargo_cargo_id_seq OWNER TO postgres; |
---|
| 192 | |
---|
| 193 | -- |
---|
| 194 | -- Name: cargo_cargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 195 | -- |
---|
| 196 | |
---|
| 197 | ALTER SEQUENCE cargo_cargo_id_seq OWNED BY cargo.cargo_id; |
---|
| 198 | |
---|
| 199 | |
---|
| 200 | -- |
---|
| 201 | -- Name: cargo_cargo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 202 | -- |
---|
| 203 | |
---|
| 204 | SELECT pg_catalog.setval('cargo_cargo_id_seq', 1, false); |
---|
| 205 | |
---|
| 206 | |
---|
| 207 | -- |
---|
| 208 | -- Name: centro_custo; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 209 | -- |
---|
| 210 | |
---|
| 211 | CREATE TABLE centro_custo ( |
---|
| 212 | organizacao_id integer NOT NULL, |
---|
| 213 | centro_custo_id integer NOT NULL, |
---|
| 214 | nm_centro_custo integer NOT NULL, |
---|
| 215 | grupo character varying(30), |
---|
| 216 | descricao character varying(100) NOT NULL |
---|
| 217 | ); |
---|
| 218 | |
---|
| 219 | |
---|
| 220 | ALTER TABLE public.centro_custo OWNER TO postgres; |
---|
| 221 | |
---|
| 222 | -- |
---|
| 223 | -- Name: centro_custo_centro_custo_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 224 | -- |
---|
| 225 | |
---|
| 226 | CREATE SEQUENCE centro_custo_centro_custo_id_seq |
---|
| 227 | START WITH 1 |
---|
| 228 | INCREMENT BY 1 |
---|
| 229 | NO MAXVALUE |
---|
| 230 | NO MINVALUE |
---|
| 231 | CACHE 1; |
---|
| 232 | |
---|
| 233 | |
---|
| 234 | ALTER TABLE public.centro_custo_centro_custo_id_seq OWNER TO postgres; |
---|
| 235 | |
---|
| 236 | -- |
---|
| 237 | -- Name: centro_custo_centro_custo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 238 | -- |
---|
| 239 | |
---|
| 240 | ALTER SEQUENCE centro_custo_centro_custo_id_seq OWNED BY centro_custo.centro_custo_id; |
---|
| 241 | |
---|
| 242 | |
---|
| 243 | -- |
---|
| 244 | -- Name: centro_custo_centro_custo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 245 | -- |
---|
| 246 | |
---|
| 247 | SELECT pg_catalog.setval('centro_custo_centro_custo_id_seq', 1, false); |
---|
| 248 | |
---|
| 249 | |
---|
| 250 | -- |
---|
| 251 | -- Name: funcionario; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 252 | -- |
---|
| 253 | |
---|
| 254 | CREATE TABLE funcionario ( |
---|
| 255 | funcionario_id integer NOT NULL, |
---|
| 256 | area_id integer NOT NULL, |
---|
| 257 | localidade_id integer NOT NULL, |
---|
| 258 | centro_custo_id integer, |
---|
| 259 | organizacao_id integer NOT NULL, |
---|
| 260 | funcionario_status_id integer NOT NULL, |
---|
| 261 | cargo_id integer, |
---|
| 262 | nivel smallint, |
---|
[1979] | 263 | funcionario_categoria_id integer, |
---|
| 264 | titulo character varying(30) |
---|
[1255] | 265 | ); |
---|
| 266 | |
---|
| 267 | |
---|
| 268 | ALTER TABLE public.funcionario OWNER TO postgres; |
---|
| 269 | |
---|
| 270 | -- |
---|
| 271 | -- Name: funcionario_categoria; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 272 | -- |
---|
| 273 | |
---|
| 274 | CREATE TABLE funcionario_categoria ( |
---|
| 275 | funcionario_categoria_id integer NOT NULL, |
---|
| 276 | descricao character varying(150), |
---|
| 277 | organizacao_id integer |
---|
| 278 | ); |
---|
| 279 | |
---|
| 280 | |
---|
| 281 | ALTER TABLE public.funcionario_categoria OWNER TO postgres; |
---|
| 282 | |
---|
| 283 | -- |
---|
| 284 | -- Name: funcionario_categoria_funcionario_categoria_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 285 | -- |
---|
| 286 | |
---|
| 287 | CREATE SEQUENCE funcionario_categoria_funcionario_categoria_id_seq |
---|
| 288 | START WITH 1 |
---|
| 289 | INCREMENT BY 1 |
---|
| 290 | NO MAXVALUE |
---|
| 291 | NO MINVALUE |
---|
| 292 | CACHE 1; |
---|
| 293 | |
---|
| 294 | |
---|
| 295 | ALTER TABLE public.funcionario_categoria_funcionario_categoria_id_seq OWNER TO postgres; |
---|
| 296 | |
---|
| 297 | -- |
---|
| 298 | -- Name: funcionario_categoria_funcionario_categoria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 299 | -- |
---|
| 300 | |
---|
| 301 | ALTER SEQUENCE funcionario_categoria_funcionario_categoria_id_seq OWNED BY funcionario_categoria.funcionario_categoria_id; |
---|
| 302 | |
---|
| 303 | |
---|
| 304 | -- |
---|
| 305 | -- Name: funcionario_categoria_funcionario_categoria_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 306 | -- |
---|
| 307 | |
---|
| 308 | SELECT pg_catalog.setval('funcionario_categoria_funcionario_categoria_id_seq', 1, false); |
---|
| 309 | |
---|
| 310 | |
---|
| 311 | -- |
---|
| 312 | -- Name: funcionario_status; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 313 | -- |
---|
| 314 | |
---|
| 315 | CREATE TABLE funcionario_status ( |
---|
| 316 | funcionario_status_id integer NOT NULL, |
---|
| 317 | descricao character varying(50) NOT NULL, |
---|
| 318 | exibir character varying(1) NOT NULL, |
---|
| 319 | organizacao_id integer NOT NULL |
---|
| 320 | ); |
---|
| 321 | |
---|
| 322 | |
---|
| 323 | ALTER TABLE public.funcionario_status OWNER TO postgres; |
---|
| 324 | |
---|
| 325 | -- |
---|
| 326 | -- Name: funcionario_status_funcionario_status_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 327 | -- |
---|
| 328 | |
---|
| 329 | CREATE SEQUENCE funcionario_status_funcionario_status_id_seq |
---|
| 330 | START WITH 1 |
---|
| 331 | INCREMENT BY 1 |
---|
| 332 | NO MAXVALUE |
---|
| 333 | NO MINVALUE |
---|
| 334 | CACHE 1; |
---|
| 335 | |
---|
| 336 | |
---|
| 337 | ALTER TABLE public.funcionario_status_funcionario_status_id_seq OWNER TO postgres; |
---|
| 338 | |
---|
| 339 | -- |
---|
| 340 | -- Name: funcionario_status_funcionario_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 341 | -- |
---|
| 342 | |
---|
| 343 | ALTER SEQUENCE funcionario_status_funcionario_status_id_seq OWNED BY funcionario_status.funcionario_status_id; |
---|
| 344 | |
---|
| 345 | |
---|
| 346 | -- |
---|
| 347 | -- Name: funcionario_status_funcionario_status_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 348 | -- |
---|
| 349 | |
---|
| 350 | SELECT pg_catalog.setval('funcionario_status_funcionario_status_id_seq', 1, false); |
---|
| 351 | |
---|
| 352 | |
---|
| 353 | -- |
---|
| 354 | -- Name: localidade; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 355 | -- |
---|
| 356 | |
---|
| 357 | CREATE TABLE localidade ( |
---|
| 358 | organizacao_id integer NOT NULL, |
---|
| 359 | localidade_id integer NOT NULL, |
---|
| 360 | centro_custo_id integer, |
---|
[1979] | 361 | descricao character varying(50) NOT NULL, |
---|
| 362 | empresa character varying(100), |
---|
| 363 | endereco character varying(100), |
---|
| 364 | complemento character varying(50), |
---|
| 365 | cep character varying(9), |
---|
| 366 | bairro character varying(30), |
---|
| 367 | cidade character varying(50), |
---|
| 368 | uf character varying(2) |
---|
[1255] | 369 | ); |
---|
| 370 | |
---|
| 371 | |
---|
| 372 | ALTER TABLE public.localidade OWNER TO postgres; |
---|
| 373 | |
---|
| 374 | -- |
---|
| 375 | -- Name: localidade_localidade_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 376 | -- |
---|
| 377 | |
---|
| 378 | CREATE SEQUENCE localidade_localidade_id_seq |
---|
| 379 | START WITH 1 |
---|
| 380 | INCREMENT BY 1 |
---|
| 381 | NO MAXVALUE |
---|
| 382 | NO MINVALUE |
---|
| 383 | CACHE 1; |
---|
| 384 | |
---|
| 385 | |
---|
| 386 | ALTER TABLE public.localidade_localidade_id_seq OWNER TO postgres; |
---|
| 387 | |
---|
| 388 | -- |
---|
| 389 | -- Name: localidade_localidade_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 390 | -- |
---|
| 391 | |
---|
| 392 | ALTER SEQUENCE localidade_localidade_id_seq OWNED BY localidade.localidade_id; |
---|
| 393 | |
---|
| 394 | |
---|
| 395 | -- |
---|
| 396 | -- Name: localidade_localidade_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 397 | -- |
---|
| 398 | |
---|
| 399 | SELECT pg_catalog.setval('localidade_localidade_id_seq', 1, false); |
---|
| 400 | |
---|
| 401 | |
---|
| 402 | -- |
---|
| 403 | -- Name: organizacao; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 404 | -- |
---|
| 405 | |
---|
| 406 | CREATE TABLE organizacao ( |
---|
| 407 | organizacao_id integer NOT NULL, |
---|
| 408 | nome character varying(20) NOT NULL, |
---|
| 409 | descricao character varying(100) NOT NULL, |
---|
| 410 | url_imagem character varying(200), |
---|
[1979] | 411 | ativa character varying(1) NOT NULL, |
---|
| 412 | sitio character varying(100) |
---|
[1255] | 413 | ); |
---|
| 414 | |
---|
| 415 | |
---|
| 416 | ALTER TABLE public.organizacao OWNER TO postgres; |
---|
| 417 | |
---|
| 418 | -- |
---|
| 419 | -- Name: organizacao_organizacao_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 420 | -- |
---|
| 421 | |
---|
| 422 | CREATE SEQUENCE organizacao_organizacao_id_seq |
---|
| 423 | START WITH 1 |
---|
| 424 | INCREMENT BY 1 |
---|
| 425 | NO MAXVALUE |
---|
| 426 | NO MINVALUE |
---|
| 427 | CACHE 1; |
---|
| 428 | |
---|
| 429 | |
---|
| 430 | ALTER TABLE public.organizacao_organizacao_id_seq OWNER TO postgres; |
---|
| 431 | |
---|
| 432 | -- |
---|
| 433 | -- Name: organizacao_organizacao_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 434 | -- |
---|
| 435 | |
---|
| 436 | ALTER SEQUENCE organizacao_organizacao_id_seq OWNED BY organizacao.organizacao_id; |
---|
| 437 | |
---|
| 438 | |
---|
| 439 | -- |
---|
| 440 | -- Name: organizacao_organizacao_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 441 | -- |
---|
| 442 | |
---|
| 443 | SELECT pg_catalog.setval('organizacao_organizacao_id_seq', 1, false); |
---|
| 444 | |
---|
| 445 | |
---|
| 446 | -- |
---|
[1979] | 447 | -- Name: telefone; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
---|
| 448 | -- |
---|
| 449 | |
---|
| 450 | CREATE TABLE telefone ( |
---|
| 451 | telefone_id integer NOT NULL, |
---|
| 452 | descricao character varying(50) NOT NULL, |
---|
| 453 | numero character varying(50) NOT NULL, |
---|
| 454 | organizacao_id integer NOT NULL |
---|
| 455 | ); |
---|
| 456 | |
---|
| 457 | |
---|
| 458 | ALTER TABLE public.telefone OWNER TO postgres; |
---|
| 459 | |
---|
| 460 | -- |
---|
| 461 | -- Name: telefone_telefone_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
---|
| 462 | -- |
---|
| 463 | |
---|
| 464 | CREATE SEQUENCE telefone_telefone_id_seq |
---|
| 465 | START WITH 1 |
---|
| 466 | INCREMENT BY 1 |
---|
| 467 | NO MAXVALUE |
---|
| 468 | NO MINVALUE |
---|
| 469 | CACHE 1; |
---|
| 470 | |
---|
| 471 | |
---|
| 472 | ALTER TABLE public.telefone_telefone_id_seq OWNER TO postgres; |
---|
| 473 | |
---|
| 474 | -- |
---|
| 475 | -- Name: telefone_telefone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
---|
| 476 | -- |
---|
| 477 | |
---|
| 478 | ALTER SEQUENCE telefone_telefone_id_seq OWNED BY telefone.telefone_id; |
---|
| 479 | |
---|
| 480 | |
---|
| 481 | -- |
---|
| 482 | -- Name: telefone_telefone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres |
---|
| 483 | -- |
---|
| 484 | |
---|
| 485 | SELECT pg_catalog.setval('telefone_telefone_id_seq', 1, false); |
---|
| 486 | |
---|
| 487 | |
---|
| 488 | -- |
---|
| 489 | -- Name: telefone_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 490 | -- |
---|
| 491 | |
---|
| 492 | ALTER TABLE telefone ALTER COLUMN telefone_id SET DEFAULT nextval('telefone_telefone_id_seq'::regclass); |
---|
| 493 | |
---|
| 494 | |
---|
| 495 | -- |
---|
| 496 | -- Name: telefone_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 497 | -- |
---|
| 498 | |
---|
| 499 | ALTER TABLE ONLY telefone |
---|
| 500 | ADD CONSTRAINT telefone_pkey PRIMARY KEY (telefone_id); |
---|
| 501 | |
---|
| 502 | |
---|
| 503 | -- |
---|
[1255] | 504 | -- Name: area_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 505 | -- |
---|
| 506 | |
---|
| 507 | ALTER TABLE area ALTER COLUMN area_id SET DEFAULT nextval('area_area_id_seq'::regclass); |
---|
| 508 | |
---|
| 509 | |
---|
| 510 | -- |
---|
| 511 | -- Name: area_status_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 512 | -- |
---|
| 513 | |
---|
| 514 | ALTER TABLE area_status ALTER COLUMN area_status_id SET DEFAULT nextval('area_status_area_status_id_seq'::regclass); |
---|
| 515 | |
---|
| 516 | |
---|
| 517 | -- |
---|
| 518 | -- Name: cargo_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 519 | -- |
---|
| 520 | |
---|
| 521 | ALTER TABLE cargo ALTER COLUMN cargo_id SET DEFAULT nextval('cargo_cargo_id_seq'::regclass); |
---|
| 522 | |
---|
| 523 | |
---|
| 524 | -- |
---|
| 525 | -- Name: centro_custo_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 526 | -- |
---|
| 527 | |
---|
| 528 | ALTER TABLE centro_custo ALTER COLUMN centro_custo_id SET DEFAULT nextval('centro_custo_centro_custo_id_seq'::regclass); |
---|
| 529 | |
---|
| 530 | |
---|
| 531 | -- |
---|
| 532 | -- Name: funcionario_categoria_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 533 | -- |
---|
| 534 | |
---|
| 535 | ALTER TABLE funcionario_categoria ALTER COLUMN funcionario_categoria_id SET DEFAULT nextval('funcionario_categoria_funcionario_categoria_id_seq'::regclass); |
---|
| 536 | |
---|
| 537 | |
---|
| 538 | -- |
---|
| 539 | -- Name: funcionario_status_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 540 | -- |
---|
| 541 | |
---|
| 542 | ALTER TABLE funcionario_status ALTER COLUMN funcionario_status_id SET DEFAULT nextval('funcionario_status_funcionario_status_id_seq'::regclass); |
---|
| 543 | |
---|
| 544 | |
---|
| 545 | -- |
---|
| 546 | -- Name: localidade_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 547 | -- |
---|
| 548 | |
---|
| 549 | ALTER TABLE localidade ALTER COLUMN localidade_id SET DEFAULT nextval('localidade_localidade_id_seq'::regclass); |
---|
| 550 | |
---|
| 551 | |
---|
| 552 | -- |
---|
| 553 | -- Name: organizacao_id; Type: DEFAULT; Schema: public; Owner: postgres |
---|
| 554 | -- |
---|
| 555 | |
---|
| 556 | ALTER TABLE organizacao ALTER COLUMN organizacao_id SET DEFAULT nextval('organizacao_organizacao_id_seq'::regclass); |
---|
| 557 | |
---|
| 558 | |
---|
| 559 | SET search_path = cds, pg_catalog; |
---|
| 560 | |
---|
| 561 | -- |
---|
| 562 | -- Data for Name: cdcollection; Type: TABLE DATA; Schema: cds; Owner: admin_cds |
---|
| 563 | -- |
---|
| 564 | |
---|
| 565 | INSERT INTO cdcollection VALUES (1, 'Compact Disc 1', 'disponivel', NULL); |
---|
| 566 | INSERT INTO cdcollection VALUES (2, 'Compact Disc 2', 'disponivel', NULL); |
---|
| 567 | INSERT INTO cdcollection VALUES (3, 'Compact Disc 3', 'disponivel', NULL); |
---|
| 568 | |
---|
| 569 | |
---|
| 570 | SET search_path = cds, pg_catalog; |
---|
| 571 | |
---|
| 572 | -- |
---|
| 573 | -- Name: cdcollection_pkey; Type: CONSTRAINT; Schema: cds; Owner: admin_cds; Tablespace: |
---|
| 574 | -- |
---|
| 575 | |
---|
| 576 | ALTER TABLE ONLY cdcollection |
---|
| 577 | ADD CONSTRAINT cdcollection_pkey PRIMARY KEY (cdid); |
---|
| 578 | |
---|
| 579 | |
---|
| 580 | SET search_path = public, pg_catalog; |
---|
| 581 | |
---|
| 582 | -- |
---|
| 583 | -- Name: area_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 584 | -- |
---|
| 585 | |
---|
| 586 | ALTER TABLE ONLY area |
---|
| 587 | ADD CONSTRAINT area_pkey PRIMARY KEY (organizacao_id, area_id); |
---|
| 588 | |
---|
| 589 | |
---|
| 590 | -- |
---|
| 591 | -- Name: areastatus_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 592 | -- |
---|
| 593 | |
---|
| 594 | ALTER TABLE ONLY area_status |
---|
| 595 | ADD CONSTRAINT areastatus_pkey PRIMARY KEY (area_status_id, organizacao_id); |
---|
| 596 | |
---|
| 597 | |
---|
| 598 | -- |
---|
| 599 | -- Name: centrocusto_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 600 | -- |
---|
| 601 | |
---|
| 602 | ALTER TABLE ONLY centro_custo |
---|
| 603 | ADD CONSTRAINT centrocusto_pkey PRIMARY KEY (organizacao_id, centro_custo_id); |
---|
| 604 | |
---|
| 605 | |
---|
| 606 | -- |
---|
| 607 | -- Name: funcionario_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 608 | -- |
---|
| 609 | |
---|
| 610 | ALTER TABLE ONLY funcionario |
---|
| 611 | ADD CONSTRAINT funcionario_pkey PRIMARY KEY (funcionario_id); |
---|
| 612 | |
---|
| 613 | |
---|
| 614 | -- |
---|
| 615 | -- Name: funcionario_status_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 616 | -- |
---|
| 617 | |
---|
| 618 | ALTER TABLE ONLY funcionario_status |
---|
| 619 | ADD CONSTRAINT funcionario_status_pkey PRIMARY KEY (funcionario_status_id); |
---|
| 620 | |
---|
| 621 | |
---|
| 622 | -- |
---|
| 623 | -- Name: localidade_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 624 | -- |
---|
| 625 | |
---|
| 626 | ALTER TABLE ONLY localidade |
---|
| 627 | ADD CONSTRAINT localidade_pkey PRIMARY KEY (organizacao_id, localidade_id); |
---|
| 628 | |
---|
| 629 | |
---|
| 630 | -- |
---|
| 631 | -- Name: organizacao_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
---|
| 632 | -- |
---|
| 633 | |
---|
| 634 | ALTER TABLE ONLY organizacao |
---|
| 635 | ADD CONSTRAINT organizacao_pkey PRIMARY KEY (organizacao_id); |
---|
| 636 | |
---|
| 637 | |
---|
| 638 | -- |
---|
| 639 | -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 640 | -- |
---|
| 641 | |
---|
| 642 | ALTER TABLE ONLY funcionario_status |
---|
| 643 | ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id); |
---|
| 644 | |
---|
| 645 | |
---|
| 646 | -- |
---|
| 647 | -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 648 | -- |
---|
| 649 | |
---|
| 650 | ALTER TABLE ONLY area_status |
---|
| 651 | ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id); |
---|
| 652 | |
---|
| 653 | |
---|
| 654 | -- |
---|
| 655 | -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 656 | -- |
---|
| 657 | |
---|
| 658 | ALTER TABLE ONLY centro_custo |
---|
| 659 | ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id); |
---|
| 660 | |
---|
| 661 | |
---|
| 662 | -- |
---|
| 663 | -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 664 | -- |
---|
| 665 | |
---|
| 666 | ALTER TABLE ONLY localidade |
---|
| 667 | ADD CONSTRAINT "$1" FOREIGN KEY (centro_custo_id, organizacao_id) REFERENCES centro_custo(centro_custo_id, organizacao_id); |
---|
| 668 | |
---|
| 669 | |
---|
| 670 | -- |
---|
| 671 | -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 672 | -- |
---|
| 673 | |
---|
| 674 | ALTER TABLE ONLY funcionario |
---|
| 675 | ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id, centro_custo_id) REFERENCES centro_custo(organizacao_id, centro_custo_id); |
---|
| 676 | |
---|
| 677 | |
---|
| 678 | -- |
---|
| 679 | -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 680 | -- |
---|
| 681 | |
---|
| 682 | ALTER TABLE ONLY area |
---|
| 683 | ADD CONSTRAINT "$1" FOREIGN KEY (superior_area_id, areasup_organizacao_id) REFERENCES area(area_id, organizacao_id); |
---|
| 684 | |
---|
| 685 | |
---|
| 686 | -- |
---|
| 687 | -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 688 | -- |
---|
| 689 | |
---|
| 690 | ALTER TABLE ONLY localidade |
---|
| 691 | ADD CONSTRAINT "$2" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id); |
---|
| 692 | |
---|
| 693 | |
---|
| 694 | -- |
---|
| 695 | -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 696 | -- |
---|
| 697 | |
---|
| 698 | ALTER TABLE ONLY funcionario |
---|
| 699 | ADD CONSTRAINT "$2" FOREIGN KEY (organizacao_id, localidade_id) REFERENCES localidade(organizacao_id, localidade_id); |
---|
| 700 | |
---|
| 701 | |
---|
| 702 | -- |
---|
| 703 | -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 704 | -- |
---|
| 705 | |
---|
| 706 | ALTER TABLE ONLY area |
---|
| 707 | ADD CONSTRAINT "$2" FOREIGN KEY (centro_custo_id, organizacao_id) REFERENCES centro_custo(centro_custo_id, organizacao_id); |
---|
| 708 | |
---|
| 709 | |
---|
| 710 | -- |
---|
| 711 | -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 712 | -- |
---|
| 713 | |
---|
| 714 | ALTER TABLE ONLY funcionario |
---|
| 715 | ADD CONSTRAINT "$3" FOREIGN KEY (organizacao_id, area_id) REFERENCES area(organizacao_id, area_id); |
---|
| 716 | |
---|
| 717 | |
---|
| 718 | -- |
---|
| 719 | -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 720 | -- |
---|
| 721 | |
---|
| 722 | ALTER TABLE ONLY area |
---|
| 723 | ADD CONSTRAINT "$3" FOREIGN KEY (titular_funcionario_id) REFERENCES funcionario(funcionario_id); |
---|
| 724 | |
---|
| 725 | |
---|
| 726 | -- |
---|
| 727 | -- Name: $4; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 728 | -- |
---|
| 729 | |
---|
| 730 | ALTER TABLE ONLY funcionario |
---|
| 731 | ADD CONSTRAINT "$4" FOREIGN KEY (funcionario_status_id) REFERENCES funcionario_status(funcionario_status_id); |
---|
| 732 | |
---|
| 733 | |
---|
| 734 | -- |
---|
| 735 | -- Name: $4; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 736 | -- |
---|
| 737 | |
---|
| 738 | ALTER TABLE ONLY area |
---|
| 739 | ADD CONSTRAINT "$4" FOREIGN KEY (substituto_funcionario_id) REFERENCES funcionario(funcionario_id); |
---|
| 740 | |
---|
| 741 | |
---|
| 742 | -- |
---|
| 743 | -- Name: $5; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 744 | -- |
---|
| 745 | |
---|
| 746 | ALTER TABLE ONLY area |
---|
| 747 | ADD CONSTRAINT "$5" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id); |
---|
| 748 | |
---|
| 749 | |
---|
| 750 | -- |
---|
| 751 | -- Name: $6; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 752 | -- |
---|
| 753 | |
---|
| 754 | ALTER TABLE ONLY area |
---|
| 755 | ADD CONSTRAINT "$6" FOREIGN KEY (area_status_id, organizacao_id) REFERENCES area_status(area_status_id, organizacao_id); |
---|
| 756 | |
---|
| 757 | |
---|
| 758 | -- |
---|
| 759 | -- Name: $7; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 760 | -- |
---|
| 761 | |
---|
| 762 | ALTER TABLE ONLY area |
---|
| 763 | ADD CONSTRAINT "$7" FOREIGN KEY (auxiliar_funcionario_id) REFERENCES funcionario(funcionario_id); |
---|
| 764 | |
---|
[1979] | 765 | -- |
---|
| 766 | -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
---|
| 767 | -- |
---|
[1255] | 768 | |
---|
[1979] | 769 | ALTER TABLE ONLY telefone |
---|
| 770 | ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id); |
---|
| 771 | |
---|
| 772 | |
---|
[1255] | 773 | -- |
---|
| 774 | -- Name: cds; Type: ACL; Schema: -; Owner: admin_cds |
---|
| 775 | -- |
---|
| 776 | |
---|
| 777 | REVOKE ALL ON SCHEMA cds FROM PUBLIC; |
---|
| 778 | REVOKE ALL ON SCHEMA cds FROM admin_cds; |
---|
| 779 | GRANT ALL ON SCHEMA cds TO admin_cds; |
---|
| 780 | GRANT ALL ON SCHEMA cds TO postgres; |
---|
| 781 | |
---|
| 782 | |
---|
| 783 | -- |
---|
| 784 | -- Name: public; Type: ACL; Schema: -; Owner: postgres |
---|
| 785 | -- |
---|
| 786 | |
---|
| 787 | REVOKE ALL ON SCHEMA public FROM PUBLIC; |
---|
| 788 | REVOKE ALL ON SCHEMA public FROM postgres; |
---|
| 789 | GRANT ALL ON SCHEMA public TO postgres; |
---|
| 790 | GRANT ALL ON SCHEMA public TO PUBLIC; |
---|
| 791 | |
---|
| 792 | |
---|
| 793 | SET search_path = cds, pg_catalog; |
---|
| 794 | |
---|
| 795 | -- |
---|
| 796 | -- Name: cdcollection; Type: ACL; Schema: cds; Owner: admin_cds |
---|
| 797 | -- |
---|
| 798 | |
---|
| 799 | REVOKE ALL ON TABLE cdcollection FROM PUBLIC; |
---|
| 800 | REVOKE ALL ON TABLE cdcollection FROM admin_cds; |
---|
| 801 | GRANT ALL ON TABLE cdcollection TO admin_cds; |
---|
| 802 | GRANT ALL ON TABLE cdcollection TO postgres WITH GRANT OPTION; |
---|
| 803 | |
---|
| 804 | |
---|
| 805 | SET search_path = public, pg_catalog; |
---|
| 806 | |
---|
| 807 | -- |
---|
| 808 | -- Name: area; Type: ACL; Schema: public; Owner: postgres |
---|
| 809 | -- |
---|
| 810 | |
---|
| 811 | REVOKE ALL ON TABLE area FROM PUBLIC; |
---|
| 812 | REVOKE ALL ON TABLE area FROM postgres; |
---|
| 813 | GRANT ALL ON TABLE area TO postgres; |
---|
| 814 | GRANT ALL ON TABLE area TO admin_workflow; |
---|
| 815 | GRANT SELECT ON TABLE area TO PUBLIC; |
---|
| 816 | |
---|
| 817 | |
---|
| 818 | -- |
---|
| 819 | -- Name: area_area_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 820 | -- |
---|
| 821 | |
---|
| 822 | REVOKE ALL ON SEQUENCE area_area_id_seq FROM PUBLIC; |
---|
| 823 | REVOKE ALL ON SEQUENCE area_area_id_seq FROM postgres; |
---|
| 824 | GRANT ALL ON SEQUENCE area_area_id_seq TO postgres; |
---|
| 825 | GRANT ALL ON SEQUENCE area_area_id_seq TO admin_workflow; |
---|
| 826 | GRANT SELECT ON SEQUENCE area_area_id_seq TO PUBLIC; |
---|
| 827 | |
---|
| 828 | |
---|
| 829 | -- |
---|
| 830 | -- Name: area_status; Type: ACL; Schema: public; Owner: postgres |
---|
| 831 | -- |
---|
| 832 | |
---|
| 833 | REVOKE ALL ON TABLE area_status FROM PUBLIC; |
---|
| 834 | REVOKE ALL ON TABLE area_status FROM postgres; |
---|
| 835 | GRANT ALL ON TABLE area_status TO postgres; |
---|
| 836 | GRANT ALL ON TABLE area_status TO admin_workflow; |
---|
| 837 | GRANT SELECT ON TABLE area_status TO PUBLIC; |
---|
| 838 | |
---|
| 839 | |
---|
| 840 | -- |
---|
| 841 | -- Name: area_status_area_status_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 842 | -- |
---|
| 843 | |
---|
| 844 | REVOKE ALL ON SEQUENCE area_status_area_status_id_seq FROM PUBLIC; |
---|
| 845 | REVOKE ALL ON SEQUENCE area_status_area_status_id_seq FROM postgres; |
---|
| 846 | GRANT ALL ON SEQUENCE area_status_area_status_id_seq TO postgres; |
---|
| 847 | GRANT ALL ON SEQUENCE area_status_area_status_id_seq TO admin_workflow; |
---|
| 848 | GRANT SELECT ON SEQUENCE area_status_area_status_id_seq TO PUBLIC; |
---|
| 849 | |
---|
| 850 | |
---|
| 851 | -- |
---|
| 852 | -- Name: cargo; Type: ACL; Schema: public; Owner: postgres |
---|
| 853 | -- |
---|
| 854 | |
---|
| 855 | REVOKE ALL ON TABLE cargo FROM PUBLIC; |
---|
| 856 | REVOKE ALL ON TABLE cargo FROM postgres; |
---|
| 857 | GRANT ALL ON TABLE cargo TO postgres; |
---|
| 858 | GRANT ALL ON TABLE cargo TO admin_workflow; |
---|
| 859 | GRANT SELECT ON TABLE cargo TO PUBLIC; |
---|
| 860 | |
---|
| 861 | |
---|
| 862 | -- |
---|
| 863 | -- Name: cargo_cargo_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 864 | -- |
---|
| 865 | |
---|
| 866 | REVOKE ALL ON SEQUENCE cargo_cargo_id_seq FROM PUBLIC; |
---|
| 867 | REVOKE ALL ON SEQUENCE cargo_cargo_id_seq FROM postgres; |
---|
| 868 | GRANT ALL ON SEQUENCE cargo_cargo_id_seq TO postgres; |
---|
| 869 | GRANT ALL ON SEQUENCE cargo_cargo_id_seq TO admin_workflow; |
---|
| 870 | GRANT SELECT ON SEQUENCE cargo_cargo_id_seq TO PUBLIC; |
---|
| 871 | |
---|
| 872 | |
---|
| 873 | -- |
---|
| 874 | -- Name: centro_custo; Type: ACL; Schema: public; Owner: postgres |
---|
| 875 | -- |
---|
| 876 | |
---|
| 877 | REVOKE ALL ON TABLE centro_custo FROM PUBLIC; |
---|
| 878 | REVOKE ALL ON TABLE centro_custo FROM postgres; |
---|
| 879 | GRANT ALL ON TABLE centro_custo TO postgres; |
---|
| 880 | GRANT ALL ON TABLE centro_custo TO admin_workflow; |
---|
| 881 | GRANT SELECT ON TABLE centro_custo TO PUBLIC; |
---|
| 882 | |
---|
| 883 | |
---|
| 884 | -- |
---|
| 885 | -- Name: centro_custo_centro_custo_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 886 | -- |
---|
| 887 | |
---|
| 888 | REVOKE ALL ON SEQUENCE centro_custo_centro_custo_id_seq FROM PUBLIC; |
---|
| 889 | REVOKE ALL ON SEQUENCE centro_custo_centro_custo_id_seq FROM postgres; |
---|
| 890 | GRANT ALL ON SEQUENCE centro_custo_centro_custo_id_seq TO postgres; |
---|
| 891 | GRANT ALL ON SEQUENCE centro_custo_centro_custo_id_seq TO admin_workflow; |
---|
| 892 | GRANT SELECT ON SEQUENCE centro_custo_centro_custo_id_seq TO PUBLIC; |
---|
| 893 | |
---|
| 894 | |
---|
| 895 | -- |
---|
| 896 | -- Name: funcionario; Type: ACL; Schema: public; Owner: postgres |
---|
| 897 | -- |
---|
| 898 | |
---|
| 899 | REVOKE ALL ON TABLE funcionario FROM PUBLIC; |
---|
| 900 | REVOKE ALL ON TABLE funcionario FROM postgres; |
---|
| 901 | GRANT ALL ON TABLE funcionario TO postgres; |
---|
| 902 | GRANT ALL ON TABLE funcionario TO admin_workflow; |
---|
| 903 | GRANT SELECT ON TABLE funcionario TO PUBLIC; |
---|
| 904 | |
---|
| 905 | |
---|
| 906 | -- |
---|
| 907 | -- Name: funcionario_categoria; Type: ACL; Schema: public; Owner: postgres |
---|
| 908 | -- |
---|
| 909 | |
---|
| 910 | REVOKE ALL ON TABLE funcionario_categoria FROM PUBLIC; |
---|
| 911 | REVOKE ALL ON TABLE funcionario_categoria FROM postgres; |
---|
| 912 | GRANT ALL ON TABLE funcionario_categoria TO postgres; |
---|
| 913 | GRANT ALL ON TABLE funcionario_categoria TO admin_workflow; |
---|
| 914 | GRANT SELECT ON TABLE funcionario_categoria TO PUBLIC; |
---|
| 915 | |
---|
| 916 | |
---|
| 917 | -- |
---|
| 918 | -- Name: funcionario_categoria_funcionario_categoria_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 919 | -- |
---|
| 920 | |
---|
| 921 | REVOKE ALL ON SEQUENCE funcionario_categoria_funcionario_categoria_id_seq FROM PUBLIC; |
---|
| 922 | REVOKE ALL ON SEQUENCE funcionario_categoria_funcionario_categoria_id_seq FROM postgres; |
---|
| 923 | GRANT ALL ON SEQUENCE funcionario_categoria_funcionario_categoria_id_seq TO postgres; |
---|
| 924 | GRANT ALL ON SEQUENCE funcionario_categoria_funcionario_categoria_id_seq TO admin_workflow; |
---|
| 925 | GRANT SELECT ON SEQUENCE funcionario_categoria_funcionario_categoria_id_seq TO PUBLIC; |
---|
| 926 | |
---|
| 927 | |
---|
| 928 | -- |
---|
| 929 | -- Name: funcionario_status; Type: ACL; Schema: public; Owner: postgres |
---|
| 930 | -- |
---|
| 931 | |
---|
| 932 | REVOKE ALL ON TABLE funcionario_status FROM PUBLIC; |
---|
| 933 | REVOKE ALL ON TABLE funcionario_status FROM postgres; |
---|
| 934 | GRANT ALL ON TABLE funcionario_status TO postgres; |
---|
| 935 | GRANT ALL ON TABLE funcionario_status TO admin_workflow; |
---|
| 936 | GRANT SELECT ON TABLE funcionario_status TO PUBLIC; |
---|
| 937 | |
---|
| 938 | |
---|
| 939 | -- |
---|
| 940 | -- Name: funcionario_status_funcionario_status_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 941 | -- |
---|
| 942 | |
---|
| 943 | REVOKE ALL ON SEQUENCE funcionario_status_funcionario_status_id_seq FROM PUBLIC; |
---|
| 944 | REVOKE ALL ON SEQUENCE funcionario_status_funcionario_status_id_seq FROM postgres; |
---|
| 945 | GRANT ALL ON SEQUENCE funcionario_status_funcionario_status_id_seq TO postgres; |
---|
| 946 | GRANT ALL ON SEQUENCE funcionario_status_funcionario_status_id_seq TO admin_workflow; |
---|
| 947 | GRANT SELECT ON SEQUENCE funcionario_status_funcionario_status_id_seq TO PUBLIC; |
---|
| 948 | |
---|
| 949 | |
---|
| 950 | -- |
---|
| 951 | -- Name: localidade; Type: ACL; Schema: public; Owner: postgres |
---|
| 952 | -- |
---|
| 953 | |
---|
| 954 | REVOKE ALL ON TABLE localidade FROM PUBLIC; |
---|
| 955 | REVOKE ALL ON TABLE localidade FROM postgres; |
---|
| 956 | GRANT ALL ON TABLE localidade TO postgres; |
---|
| 957 | GRANT ALL ON TABLE localidade TO admin_workflow; |
---|
| 958 | GRANT SELECT ON TABLE localidade TO PUBLIC; |
---|
| 959 | |
---|
| 960 | |
---|
| 961 | -- |
---|
| 962 | -- Name: localidade_localidade_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 963 | -- |
---|
| 964 | |
---|
| 965 | REVOKE ALL ON SEQUENCE localidade_localidade_id_seq FROM PUBLIC; |
---|
| 966 | REVOKE ALL ON SEQUENCE localidade_localidade_id_seq FROM postgres; |
---|
| 967 | GRANT ALL ON SEQUENCE localidade_localidade_id_seq TO postgres; |
---|
| 968 | GRANT ALL ON SEQUENCE localidade_localidade_id_seq TO admin_workflow; |
---|
| 969 | GRANT SELECT ON SEQUENCE localidade_localidade_id_seq TO PUBLIC; |
---|
| 970 | |
---|
| 971 | |
---|
| 972 | -- |
---|
| 973 | -- Name: organizacao; Type: ACL; Schema: public; Owner: postgres |
---|
| 974 | -- |
---|
| 975 | |
---|
| 976 | REVOKE ALL ON TABLE organizacao FROM PUBLIC; |
---|
| 977 | REVOKE ALL ON TABLE organizacao FROM postgres; |
---|
| 978 | GRANT ALL ON TABLE organizacao TO postgres; |
---|
| 979 | GRANT ALL ON TABLE organizacao TO admin_workflow; |
---|
| 980 | GRANT SELECT ON TABLE organizacao TO PUBLIC; |
---|
| 981 | |
---|
| 982 | |
---|
| 983 | -- |
---|
| 984 | -- Name: organizacao_organizacao_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 985 | -- |
---|
| 986 | |
---|
| 987 | REVOKE ALL ON SEQUENCE organizacao_organizacao_id_seq FROM PUBLIC; |
---|
| 988 | REVOKE ALL ON SEQUENCE organizacao_organizacao_id_seq FROM postgres; |
---|
| 989 | GRANT ALL ON SEQUENCE organizacao_organizacao_id_seq TO postgres; |
---|
| 990 | GRANT ALL ON SEQUENCE organizacao_organizacao_id_seq TO admin_workflow; |
---|
| 991 | GRANT SELECT ON SEQUENCE organizacao_organizacao_id_seq TO PUBLIC; |
---|
| 992 | |
---|
| 993 | |
---|
| 994 | -- |
---|
[1979] | 995 | -- Name: telefone; Type: ACL; Schema: public; Owner: postgres |
---|
| 996 | -- |
---|
| 997 | |
---|
| 998 | REVOKE ALL ON TABLE telefone FROM PUBLIC; |
---|
| 999 | REVOKE ALL ON TABLE telefone FROM postgres; |
---|
| 1000 | GRANT ALL ON TABLE telefone TO postgres; |
---|
| 1001 | GRANT ALL ON TABLE telefone TO admin_workflow; |
---|
| 1002 | GRANT SELECT ON TABLE telefone TO PUBLIC; |
---|
| 1003 | |
---|
| 1004 | |
---|
| 1005 | -- |
---|
| 1006 | -- Name: telefone_telefone_id_seq; Type: ACL; Schema: public; Owner: postgres |
---|
| 1007 | -- |
---|
| 1008 | |
---|
| 1009 | REVOKE ALL ON SEQUENCE telefone_telefone_id_seq FROM PUBLIC; |
---|
| 1010 | REVOKE ALL ON SEQUENCE telefone_telefone_id_seq FROM postgres; |
---|
| 1011 | GRANT ALL ON SEQUENCE telefone_telefone_id_seq TO postgres; |
---|
| 1012 | GRANT ALL ON SEQUENCE telefone_telefone_id_seq TO admin_workflow; |
---|
| 1013 | GRANT SELECT ON SEQUENCE telefone_telefone_id_seq TO PUBLIC; |
---|
| 1014 | |
---|
| 1015 | |
---|
| 1016 | -- |
---|
[1255] | 1017 | -- PostgreSQL database dump complete |
---|
| 1018 | -- |
---|
| 1019 | |
---|