-- DROP TABLE public.log_for_fornecedor; CREATE TABLE public.log_for_fornecedor ( log_sequencia integer NOT NULL, log_terminal_ip character varying(15) NOT NULL, log_usuario integer NOT NULL, log_formulario character varying(100) NOT NULL, log_data date NOT NULL, log_hora time without time zone NOT NULL, log_observacao character varying(200) NOT NULL, log_tipo_operacao integer NOT NULL, ant_filial integer NOT NULL, ant_codigo integer NOT NULL, ant_nome character varying(100) NOT NULL, ant_fantasia character varying(100) NOT NULL, ant_endereco character varying(100) NOT NULL, ant_numero integer NOT NULL, ant_bairro character varying(80) NOT NULL, ant_complemento character varying(50) NOT NULL, ant_uf character varying(2) NOT NULL, ant_cidade character varying(50) NOT NULL, ant_pais character varying(50) NOT NULL, ant_cx_postal character varying(12) NOT NULL, ant_rg character varying(12) NOT NULL, ant_data_cadastro date NOT NULL, ant_data_alteracao date NOT NULL, ant_contato1 character varying(50) NOT NULL, ant_ddd1 integer NOT NULL, ant_telefone1 numeric(15,0) NOT NULL, ant_contato2 character varying(50) NOT NULL, ant_ddd2 integer NOT NULL, ant_telefone2 numeric(15,0) NOT NULL, ant_contato3 character varying(50) NOT NULL, ant_ddd3 integer NOT NULL, ant_telefone3 numeric(15,0) NOT NULL, ant_ddd_fax integer NOT NULL, ant_fax numeric(15,0) NOT NULL, ant_situacao character varying(1) NOT NULL, ant_comprar character varying(1) NOT NULL, ant_liberado_venda character varying(1) NOT NULL, ant_micro_empresa character varying(1) NOT NULL, ant_substituto_trib character varying(1) NOT NULL, ant_tem_inscricao_municipal character varying(1) NOT NULL, ant_tipo_fornecedor character varying(1) NOT NULL, ant_banco integer NOT NULL, ant_conta character varying(15) NOT NULL, ant_motivo_nao_compra character varying(50) NOT NULL, ant_tipo_pgto integer NOT NULL, ant_desc_financ_padrao numeric(18,6) NOT NULL, ant_perc_custo numeric(10,6) NOT NULL, ant_margem_lucro numeric(18,6) NOT NULL, ant_ramo_atividade integer NOT NULL, ant_conta_contabil numeric(14,0) NOT NULL, ant_centro_custo integer NOT NULL, ant_email character varying(100) NOT NULL, ant_site character varying(100) NOT NULL, ant_cpf character varying(14) NOT NULL, ant_cnpj character varying(16) NOT NULL, ant_agencia character varying(10) NOT NULL, ant_cep character varying(8) NOT NULL, ant_ie character varying(20) NOT NULL, ant_im character varying(20) NOT NULL, ant_banco1 integer NOT NULL, ant_agencia1 character varying(10) NOT NULL, ant_conta1 character varying(15) NOT NULL, ant_email_1 character varying(100) NOT NULL, ant_email_2 character varying(100) NOT NULL, ant_email_3 character varying(100) NOT NULL, ant_observacao character varying(600) NOT NULL, ant_banco2 integer NOT NULL, ant_agencia2 character varying(10) NOT NULL, ant_conta2 character varying(15) NOT NULL, ant_banco3 integer NOT NULL, ant_agencia3 character varying(10) NOT NULL, ant_conta3 character varying(15) NOT NULL, ant_favorecido character varying(100) NOT NULL, ant_favorecido_1 character varying(100) NOT NULL, ant_favorecido_2 character varying(100) NOT NULL, ant_favorecido_3 character varying(100) NOT NULL, ant_ddd_celular_1 integer NOT NULL, ant_ddd_celular_2 integer NOT NULL, ant_ddd_celular_3 integer NOT NULL, ant_celular_1 numeric(15,0) NOT NULL, ant_celular_2 numeric(15,0) NOT NULL, ant_celular_3 numeric(15,0) NOT NULL, ant_tipo_contato_1 character varying(30) NOT NULL, ant_tipo_contato_2 character varying(30) NOT NULL, ant_tipo_contato_3 character varying(30) NOT NULL, ant_prazo_entrega_dias integer NOT NULL, ant_direito_credito_pis_cofins character varying(1) NOT NULL, ant_inside_pis character varying(1) NOT NULL, ant_inside_cofins character varying(1) NOT NULL, ant_inside_csll character varying(1) NOT NULL, ant_vlr_min_fat numeric(18,6) NOT NULL, ant_percentual_iss numeric(18,6) NOT NULL, ant_percentual_ir numeric(18,6) NOT NULL, ant_percentual_inss numeric(18,6) NOT NULL, ant_percentual_gnre numeric(18,6) NOT NULL, ant_nit character varying(50) NOT NULL, atu_filial integer NOT NULL, atu_codigo integer NOT NULL, atu_nome character varying(100) NOT NULL, atu_fantasia character varying(100) NOT NULL, atu_endereco character varying(100) NOT NULL, atu_numero integer NOT NULL, atu_bairro character varying(80) NOT NULL, atu_complemento character varying(50) NOT NULL, atu_uf character varying(2) NOT NULL, atu_cidade character varying(50) NOT NULL, atu_pais character varying(50) NOT NULL, atu_cx_postal character varying(12) NOT NULL, atu_rg character varying(12) NOT NULL, atu_data_cadastro date NOT NULL, atu_data_alteracao date NOT NULL, atu_contato1 character varying(50) NOT NULL, atu_ddd1 integer NOT NULL, atu_telefone1 numeric(15,0) NOT NULL, atu_contato2 character varying(50) NOT NULL, atu_ddd2 integer NOT NULL, atu_telefone2 numeric(15,0) NOT NULL, atu_contato3 character varying(50) NOT NULL, atu_ddd3 integer NOT NULL, atu_telefone3 numeric(15,0) NOT NULL, atu_ddd_fax integer NOT NULL, atu_fax numeric(15,0) NOT NULL, atu_situacao character varying(1) NOT NULL, atu_comprar character varying(1) NOT NULL, atu_liberado_venda character varying(1) NOT NULL, atu_micro_empresa character varying(1) NOT NULL, atu_substituto_trib character varying(1) NOT NULL, atu_tem_inscricao_municipal character varying(1) NOT NULL, atu_tipo_fornecedor character varying(1) NOT NULL, atu_banco integer NOT NULL, atu_conta character varying(15) NOT NULL, atu_motivo_nao_compra character varying(50) NOT NULL, atu_tipo_pgto integer NOT NULL, atu_desc_financ_padrao numeric(18,6) NOT NULL, atu_perc_custo numeric(10,6) NOT NULL, atu_margem_lucro numeric(18,6) NOT NULL, atu_ramo_atividade integer NOT NULL, atu_conta_contabil numeric(14,0) NOT NULL, atu_centro_custo integer NOT NULL, atu_email character varying(100) NOT NULL, atu_site character varying(100) NOT NULL, atu_cpf character varying(14) NOT NULL, atu_cnpj character varying(16) NOT NULL, atu_agencia character varying(10) NOT NULL, atu_cep character varying(8) NOT NULL, atu_ie character varying(20) NOT NULL, atu_im character varying(20) NOT NULL, atu_banco1 integer NOT NULL, atu_agencia1 character varying(10) NOT NULL, atu_conta1 character varying(15) NOT NULL, atu_email_1 character varying(100) NOT NULL, atu_email_2 character varying(100) NOT NULL, atu_email_3 character varying(100) NOT NULL, atu_observacao character varying(600) NOT NULL, atu_banco2 integer NOT NULL, atu_agencia2 character varying(10) NOT NULL, atu_conta2 character varying(15) NOT NULL, atu_banco3 integer NOT NULL, atu_agencia3 character varying(10) NOT NULL, atu_conta3 character varying(15) NOT NULL, atu_favorecido character varying(100) NOT NULL, atu_favorecido_1 character varying(100) NOT NULL, atu_favorecido_2 character varying(100) NOT NULL, atu_favorecido_3 character varying(100) NOT NULL, atu_ddd_celular_1 integer NOT NULL, atu_ddd_celular_2 integer NOT NULL, atu_ddd_celular_3 integer NOT NULL, atu_celular_1 numeric(15,0) NOT NULL, atu_celular_2 numeric(15,0) NOT NULL, atu_celular_3 numeric(15,0) NOT NULL, atu_tipo_contato_1 character varying(30) NOT NULL, atu_tipo_contato_2 character varying(30) NOT NULL, atu_tipo_contato_3 character varying(30) NOT NULL, atu_prazo_entrega_dias integer NOT NULL, atu_direito_credito_pis_cofins character varying(1) NOT NULL, atu_inside_pis character varying(1) NOT NULL, atu_inside_cofins character varying(1) NOT NULL, atu_inside_csll character varying(1) NOT NULL, atu_vlr_min_fat numeric(18,6) NOT NULL, atu_percentual_iss numeric(18,6) NOT NULL, atu_percentual_ir numeric(18,6) NOT NULL, atu_percentual_inss numeric(18,6) NOT NULL, atu_percentual_gnre numeric(18,6) NOT NULL, atu_nit character varying(50) NOT NULL, CONSTRAINT pk_log_for_fornecedor PRIMARY KEY (log_sequencia) ) WITH ( OIDS = FALSE ) TABLESPACE pg_default; ALTER TABLE public.log_for_fornecedor OWNER to postgres; -- SEQUENCE: public.seq_log_for_fornecedor -- DROP SEQUENCE public.seq_log_for_fornecedor; CREATE SEQUENCE public.seq_log_for_fornecedor INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9999999999 CACHE 1; ALTER SEQUENCE public.seq_log_for_fornecedor OWNER TO postgres; COMMENT ON SEQUENCE public.seq_log_for_fornecedor IS 'Sequence do log do cadastro de fornecedor'; INSERT INTO log_tipo_operacao (codigo, descricao) VALUES (32, 'Alteracao de fornecedor');