Changeset 1973 for branches/2.1/doc-expressolivre
- Timestamp:
- 02/04/10 08:30:42 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.1/doc-expressolivre/debian/arqs-conf/workflow.dump
r1255 r1973 261 261 cargo_id integer, 262 262 nivel smallint, 263 funcionario_categoria_id integer 263 funcionario_categoria_id integer, 264 titulo character varying(30) 264 265 ); 265 266 … … 358 359 localidade_id integer NOT NULL, 359 360 centro_custo_id integer, 360 descricao character varying(50) NOT NULL 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) 361 369 ); 362 370 … … 401 409 descricao character varying(100) NOT NULL, 402 410 url_imagem character varying(200), 403 ativa character varying(1) NOT NULL 411 ativa character varying(1) NOT NULL, 412 sitio character varying(100) 404 413 ); 405 414 … … 436 445 437 446 -- 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 -- 438 504 -- Name: area_id; Type: DEFAULT; Schema: public; Owner: postgres 439 505 -- … … 696 762 ALTER TABLE ONLY area 697 763 ADD CONSTRAINT "$7" FOREIGN KEY (auxiliar_funcionario_id) REFERENCES funcionario(funcionario_id); 764 765 -- 766 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres 767 -- 768 769 ALTER TABLE ONLY telefone 770 ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id); 698 771 699 772 … … 920 993 921 994 -- 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 -- 922 1017 -- PostgreSQL database dump complete 923 1018 --
Note: See TracChangeset
for help on using the changeset viewer.