Changeset 1972 for branches/2.0/doc-expressolivre

Timestamp:

02/04/10 08:22:34 (14 years ago)

Author:

viani

Message:

Ticket #899 - Atualizando dump do banco workflow com atualizações do organograma.

File:

• branches/2.0/doc-expressolivre/debian/arqs-conf/workflow.dump (modified) (6 diffs)

branches/2.0/doc-expressolivre/debian/arqs-conf/workflow.dump

@@ -261 +261 @@
     cargo_id integer,
     nivel smallint,
-    funcionario_categoria_id integer
+    funcionario_categoria_id integer,
+    titulo character varying(30)
 );
 
@@ -358 +359 @@
     localidade_id integer NOT NULL,
     centro_custo_id integer,
-    descricao character varying(50) NOT NULL
+    descricao character varying(50) NOT NULL,
+    empresa character varying(100),
+    endereco character varying(100),
+    complemento character varying(50),
+    cep character varying(9),
+    bairro character varying(30),
+    cidade character varying(50),
+    uf character varying(2)
 );
 
@@ -401 +409 @@
     descricao character varying(100) NOT NULL,
     url_imagem character varying(200),
-    ativa character varying(1) NOT NULL
+    ativa character varying(1) NOT NULL,
+    sitio character varying(100)
 );
 
@@ -436 +445 @@
 
 --
+-- Name: telefone; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE TABLE telefone (
+    telefone_id integer NOT NULL,
+    descricao character varying(50) NOT NULL,
+    numero character varying(50) NOT NULL,
+    organizacao_id integer NOT NULL
+);
+
+
+ALTER TABLE public.telefone OWNER TO postgres;
+
+--
+-- Name: telefone_telefone_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE telefone_telefone_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.telefone_telefone_id_seq OWNER TO postgres;
+
+--
+-- Name: telefone_telefone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
+--
+
+ALTER SEQUENCE telefone_telefone_id_seq OWNED BY telefone.telefone_id;
+
+
+--
+-- Name: telefone_telefone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
+--
+
+SELECT pg_catalog.setval('telefone_telefone_id_seq', 1, false);
+
+
+--
+-- Name: telefone_id; Type: DEFAULT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE telefone ALTER COLUMN telefone_id SET DEFAULT nextval('telefone_telefone_id_seq'::regclass);
+
+
+--
+-- Name: telefone_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
+--
+
+ALTER TABLE ONLY telefone
+    ADD CONSTRAINT telefone_pkey PRIMARY KEY (telefone_id);
+
+
+--
 -- Name: area_id; Type: DEFAULT; Schema: public; Owner: postgres
 --
@@ -696 +762 @@
 ALTER TABLE ONLY area
     ADD CONSTRAINT "$7" FOREIGN KEY (auxiliar_funcionario_id) REFERENCES funcionario(funcionario_id);
+
+--
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY telefone
+    ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id);
 
 
@@ -920 +993 @@
 
 --
+-- Name: telefone; Type: ACL; Schema: public; Owner: postgres
+--
+
+REVOKE ALL ON TABLE telefone FROM PUBLIC;
+REVOKE ALL ON TABLE telefone FROM postgres;
+GRANT ALL ON TABLE telefone TO postgres;
+GRANT ALL ON TABLE telefone TO admin_workflow;
+GRANT SELECT ON TABLE telefone TO PUBLIC;
+
+
+--
+-- Name: telefone_telefone_id_seq; Type: ACL; Schema: public; Owner: postgres
+--
+
+REVOKE ALL ON SEQUENCE telefone_telefone_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE telefone_telefone_id_seq FROM postgres;
+GRANT ALL ON SEQUENCE telefone_telefone_id_seq TO postgres;
+GRANT ALL ON SEQUENCE telefone_telefone_id_seq TO admin_workflow;
+GRANT SELECT ON SEQUENCE telefone_telefone_id_seq TO PUBLIC;
+
+
+--
 -- PostgreSQL database dump complete
 --