&alter table epaprc add column coduni_prc6 char(2) &alter table nfcoidi add column ndi char(10) &alter table nfcoidi add column ddesemb date &alter table natoper add column ctacre_epa char(13) &alter table natoper add column ctadeb_epa char(13) &alter table nferef add column nfp_cuf char(2) &alter table editfmo add column cor integer &alter table epapro add column ordtouc integer &alter table gendid add column vlrpadrao char(100) &alter table nfvei add column pfcp_orig numeric(5,2) &alter table nferef add column alias_ori char(3) &alter table nferef add column refnfe char(44) &alter table nferef add column chave_ori integer &alter table nferef add column emp_cod char(2) &alter table nferef add column tpdoc char(2) &alter table nferef add column tpnf char(2) &alter table nferef add column necf char(3) &alter table nferef add column ncoo char(6) &alter table nferef add column nfp_cuf char(4) &alter table nferef add column nfp_cgc char(14) &alter table nferef add column nfp_ie char(14) &alter table nferef add column nfp_mod char(2) &alter table nferef add column nfp_serie char(3) &alter table nferef add column nfp_nnf char(6) &alter table genemp add column schema char(5) &alter table plamov add column cancelada boolean &alter table nfven add column nvol char(6) &alter table cliente add column idfid char(60) &alter table epapro add column descanp char(100) &alter table epaprc add column coduni_prc char(2) &alter table epaprc add column coduni_prc1 char(2) &alter table comsta add column per_ruralpj numeric(5,2) &alter table placta add column codestru char(20) &alter table epaprc add column coduni_prc2 char(2) &alter table epaprc add column coduni_prc3 char(2) &alter table epaprc add column coduni_prc4 char(2) &alter table epaprc add column coduni_prc5 char(2) &alter table nfcoidi add column chave integer &alter table nfcoidi add column codpro char(13) &alter table nfcoidi add column xlocdesemb char(60) &alter table nfcoidi add column ddi date &alter table nfcoidi add column ufdesemb char(2) &alter table nfcoidi add column emp_cod char(2) &alter table nfcoidi add column chave_nco integer &alter table nfcoidi add column serie char(3) &alter table nfcoidi add column vafrmm numeric(13,2) &alter table nfcoidi add column cnpj char(14) &alter table nfcoidi add column id serial &alter table nfcoidi add column cexportador char(60) &alter table nfcoidi add column nronf char(6) &alter table nfcoidi add column tpviatransp char(2) &alter table nfcoidi add column tpintermedio char(1) &alter table nfcoidi add column ufterceiro char(2) &alter table nfvei add column pfcpst numeric(5,2) &alter table nfcoi add column pfcpst numeric(5,2) &alter table cliente add column per_entra numeric(6,2) &alter table nfvei add column pfcp numeric(5,2) &alter table epapro add column comb_pglp numeric(7,4) &alter table nfcoiadi add column id serial &alter table nfcoiadi add column chave integer &alter table nfcoiadi add column nadicao char(10) &alter table nfcoiadi add column nseqadic integer &alter table nfcoiadi add column cfabricante char(60) &alter table nfcoiadi add column vdescdi numeric(15,2) &alter table nfcoiadi add column emp_cod char(2) &alter table nfcoiadi add column chave_nco integer &alter table nfcoiadi add column nronf char(6) &alter table nfcoiadi add column serie char(3) &alter table nfcoiadi add column ndraw char(12) &alter table nfvei add column vbcfcpst numeric(13,2) &alter table nfcoi add column vbcfcpst numeric(13,2) &alter table nfcoi add column vbcfcp numeric(13,2) &alter table nfvei add column vbcfcp numeric(13,2) &alter table nfcoi add column vfcpst numeric(13,2) &alter table nfvei add column vfcpst numeric(13,2) &alter table epapro add column comb_pgnn numeric(7,4) &alter table logerr add column errormsg text &alter table epapro add column comb_vpart numeric(13,2) &alter table epapro add column comb_pgni numeric(7,4) &alter table nfcoi add column vfcp numeric(13,2) &alter table nfvei add column vfcp numeric(13,2) &alter table nfcoi add column pfcp numeric(5,2) &alter table cliente add column limite_mes numeric(10,2) &alter table natoper add column ctacre_cof char(13) &alter table natoper add column ctadeb_pis char(13) &alter table natoper add column ctacre_pis char(13) &alter table natoper add column ctadeb_cof char(13) &alter table epapro add column colecao char(20) &alter table nfesta add column previs boolean &alter table nfven add column indpres char(1) &alter table nfcom add column indpres char(1) &alter table genpes add column ordem integer default 0 &alter table genpes add column descricao char(60) &alter table nfvei add column indpres char(1) &alter table nfvei add column indpres char(1) &alter table nfcom add column codobsf char(2) &alter table nfven add column codobsf char(2) &alter table nfven add column indpres char(1) &alter table nfcom add column indpres char(1) &alter table gensen add column idbarra char(20) &alter table nfcoi add column b_fcp_subret numeric(13,2) &alter table nfcoi add column fcp_subret numeric(13,2) &alter table gensen add column id SERIAL &alter table nfvei add column idnci_ret numeric(10) &alter table genacs add column id serial &alter table nfcoi add column xitem integer &alter table nfvei add column xitem integer &alter table nfcoi add column icm_subp numeric(13,2) &alter table nfcoi add column desct numeric(12,2) &alter table nfvei add column icm_subp numeric(13,2) &alter table genreldv add column cprivado integer default 0 &alter table natoper add column codreldv char(6) &alter table nfcoi add column per_icmsubret numeric(5,2) &alter table nfcoi add column per_icmst numeric(5,2) &alter table genacs add column script_iniccontrol text &alter table nfvei add column pcredsn numeric(5,2) &alter table nfvei add column vcredicmssn numeric(13,2) &alter table fissta add column pcredsn numeric(5,2) &alter table fornec add column lct_nco boolean &alter table nfven add column indfinal char(1) &alter table nfcom add column indfinal char(1) &ALTER TABLE genpes ADD COLUMN ordem INTEGER &ALTER TABLE epapro ADD COLUMN per_fcp numeric(5,2) &alter table epapro add column cbenef char(15) &alter table epapro add column motdeson char(2) &alter table fornec add column regimecrt char(1) &alter table fornec add column indiedest char(1) &alter table carmov add column bufferret text &alter table nfven add column iddest char(1) &alter table nfcom add column iddest char(1) &alter table nfvei add column desp_ite numeric(12,2) &alter table nfven add column indfinal char(1) &alter table nfcom add column indfinal char(1) &alter table nfvei add column seguro_ite numeric(12,2) &alter table epaprc add column valor_stret numeric(12,2) &alter table genarq add column condicao_similar char(60) &alter table epapronat add column per_fcp numeric(5,2) &alter table regfis add column per_fcp numeric(5,2) &alter table nferef add column nfp_cuf char(2) &alter table epapronat add column per_reduz numeric(8,4) &alter table editfmo add column histor_proc char(50) &ALTER TABLE cnvcad ADD COLUMN cor INTEGER &alter table cliente add column datasufra date &alter table nfvei add column per_icmsubret numeric(5,2) &alter table natoper add column codnatref char(60) &alter table nfcoi add column xitem integer &alter table nfvei add column xitem integer &alter table nfcoi add column desp_ite numeric(12,2) &alter table nfcoi add column frete_ite numeric(12,2) &alter table nfcoi add column seguro_ite numeric(12,2) &alter table nfven add column codtpf char(2) &alter table nfcom add column codtpf char(2) &alter table pedvei add column per_reduz numeric(8,4) &alter table nfvei add column cbenef char(15) &alter table nfcoi add column cbenef char(15) &alter table epaprc add column marg_liq numeric(6,2) &alter table nfven add column codclasse char(4) &alter table nfvei add column frete_ite numeric(12,2) &alter table nfvei add column motdeson char(2) &alter table nfcoi add column motdeson char(2) &alter table pedvei add column coddep char(2) &alter table pedvei add column cst_icms char(4) &alter table grupo add column epaneg boolean &alter table cliente add column uf_cli char(2) &alter table fissta add column per_simples numeric(6,2) &alter table epaprc add column marg_ger numeric(6,2) &alter table fatsta add column nattrans_st char(4) &alter table fatsta add column nattrans char(4) &alter table epapronat add column per_reduzpf numeric(8,4) &alter table regfis add column per_reduz numeric(8,4) &alter table pednci add column lote char(10) &alter table regfis add column per_reduzpf numeric(8,4) &alter table moedas add column cor integer &alter table epapro add column lote_tam boolean default false &alter table nfcoi add column lote char(10) &alter table nfcoi add column volume char(7) &alter table engpro add column coddep char(2) &alter table nfvei add column volume char(7) &alter table pedvei add column volume char(7) &alter table movdoci add column volume char(7) &alter table nfcoi add column coduni_trib char(2) &alter table nfcoi add column qtde_trib numeric(10,4) &alter table nfvei add column qtde_trib numeric(10,4) &alter table nfvei add column coduni_trib char(2) &alter table nfcoi add column xitem integer &alter table nfvei add column xitem integer &alter table epapro add column xitem integer &alter table nfvei add column lote char(10) &alter table pedvei add column lote char(10) &alter table movdoci add column lote char(10) &alter table epamov add column lote char(10) &alter table epamov add column volume char(7) &alter table pednci add column volume char(7) &alter table nfcoi add column data_venc date &alter table nfvei add column data_venc date &alter table pedvei add column data_venc date &alter table nfven add column valor_pix numeric(10,2) &alter table natoper add column codnatdev char(4) &alter table nfcoi add column per_dif numeric(5,2) &alter table natoper add column per_dif numeric(5,2) &CREATE TABLE public.tabgen(id SERIAL,chave CHAR(20),codigo CHAR(20),sis_cod CHAR(3),descricao CHAR(100),emp_cod CHAR(2),chave_u CHAR(23),CONSTRAINT tabgen_pkey PRIMARY KEY(id))WITH (oids = false) &alter table nfven add column pix_txid char(40) &CREATE TABLE public.tpednci ( id SERIAL, tty CHAR(2), codpro CHAR(13), qtde NUMERIC(7,2), login CHAR(10), emp_cod CHAR(2), coduni CHAR(2) ) WITH (oids = false); &alter table pixsta add column conspag BOOLEAN DEFAULT FALSE &alter table nfcesta add column qrlat boolean default true &alter table epapro add column per_741f numeric(7,2) &alter table epapro add column per_741e numeric(7,2) &alter table epapro add column per_741m numeric(7,2) &alter table nfvei add column per_dif numeric(5,2) &alter table nfcom add column evtcnf integer &alter table pixsta add column p_urlaut char(100) &alter table pixsta add column p_tipo char(1) &alter table pixsta add column cmd_i text &alter table nfcom add column evtcnf integer &alter table nfven add column intermed char(6) &alter table epaprc add column promhr_i char(5) &alter table epaprc add column promhr_f char(5) &alter table nferef add column nfp_datac date &create table nfearma(id serial,alias_ori char(3),id_ori integer,chave_ori integer,tparma char(1),nserie char(15),ncano char(15),descr char(254),emp_cod char(2)) &create table nferetrib(id serial,alias_ori char(3),chave_ori integer,vretpis numeric(15,2),vretcofins numeric(15,2),vretcsll numeric(15,2),vbcirrf numeric(15,2),virrf numeric(15,2),vbcretprev numeric(15,2),vretprev numeric(15,2),emp_cod char(2)) &alter table bcobco add column codcta char(13) &alter table pedven add column entrada_vlr numeric(12,2) &alter table pedven add column entrada_dt date &alter table pedven add column chave_pla char(10) &CREATE TABLE public.pixsta (id SERIAL, rcb_chave CHAR(30), rcb_nome CHAR(30), rcb_cidade CHAR(30), rcb_cep CHAR(30), p_url CHAR(100), p_cliid TEXT, p_clisect TEXT, p_clicert TEXT, p_clicerts CHAR(100), emp_cod CHAR(2), tppix INTEGER DEFAULT 1,conspag BOOLEAN DEFAULT FALSE,cmd_i text,p_tipo char(1),p_urlaut char(100)) &CREATE TABLE public.regfis(id SERIAL,clas_fisc CHAR(10),codtri_o CHAR(1),codnatin CHAR(4),uf CHAR(2),emp_cod CHAR(2),codnatex CHAR(4),persta NUMERIC(5,2),codnatinpf CHAR(4),codnatexpf CHAR(4), persta_redst1 NUMERIC(6,4), persta_redst2 NUMERIC(6,4), perstasn NUMERIC(5,2), cst_icmsinpf CHAR(4), cst_icmsin CHAR(4), cst_icmsexpf CHAR(4), cst_icmsex CHAR(4), per_icmin NUMERIC(5,2), per_icmex NUMERIC(5,2), cst_pisin CHAR(2), cst_pisinpf CHAR(2), cst_pisex CHAR(2), cst_pisexpf CHAR(2), cst_cofin CHAR(2), cst_cofinpf CHAR(2), cst_cofex CHAR(2), cst_cofexpf CHAR(2), cst_ipiin CHAR(2), cst_ipiinpf CHAR(2), cst_ipiex CHAR(2), cst_ipiexpf CHAR(2), codrfi CHAR(6) NOT NULL,cor INTEGER,nome CHAR(50),ent_sai CHAR(1),per_fcp NUMERIC(5,2),per_reduz NUMERIC(8,4)) &ALTER TABLE sabor ADD COLUMN per_lucro NUMERIC(6,2) &ALTER TABLE public.regfis ADD COLUMN per_icmexpf NUMERIC(5,2) &alter table nfvei add column obs text &ALTER TABLE public.regfis ADD COLUMN per_dif NUMERIC(5,2) &ALTER TABLE public.regfis ADD COLUMN per_reduzpf NUMERIC(8,4) &ALTER TABLE public.regfis ADD COLUMN per_icminpf NUMERIC(5,2) &ALTER TABLE public.regfis ADD COLUMN codtxtin CHAR(2) &ALTER TABLE public.regfis ADD COLUMN codtxtinpf CHAR(2) &ALTER TABLE public.regfis ADD COLUMN codtxtex CHAR(2) &ALTER TABLE public.regfis ADD COLUMN codtxtexpf CHAR(2) &ALTER TABLE public.regfis ADD COLUMN per_difpf NUMERIC(5,2) &alter table epapro add column obs_nfce text &CREATE TABLE PUBLIC.reports(id serial,emp_cod char(2),nome char(20),frx text,frt text,txt text,datac date,horac char(10),dataa date,horaa char(10),cmdi text,cmdf text) &ALTER TABLE tpednci ADD COLUMN coddep CHAR(2) &ALTER TABLE gensta ADD COLUMN versao_sage char(10) &ALTER TABLE reports ADD COLUMN cmdf text &ALTER TABLE reports ADD COLUMN cmdi text &alter table epapro add column nometmax integer &alter table epapro add column nometmin integer &alter table epapro add column obs_nfce text &DROP TABLE epalot;CREATE TABLE epalot(data_venc DATE,lote CHAR(20),chave_u CHAR(23),emp_cod CHAR(2),qtde_s NUMERIC(10,4),id SERIAL,codpro CHAR(13),qtde_e NUMERIC(10,4),qtde NUMERIC(10,4),dfab DATE DEFAULT current_date,obs TEXT,coddep char(2)); &alter table genini add column foi integer;update genini set script=replace(script,'http://187.4.39.126/downloads/avisos/index.htm','http://downloads.genesysinf.com.br/downloads/avisos/') &alter table epapro add column coduni_vent char(2) &alter table pixsta add column codbco char(3) &alter table bcobco add column codcli char(6) &ALTER TABLE regfis add column codativ CHAR(1) &CREATE TABLE tabbenef (id serial,codpro char(13),clas_fisc char(10),cst_icms char(2),cbenef char(15),emp_cod char(2)) &ALTER TABLE comsta ADD COLUMN codrel_eng INTEGER DEFAULT 0 &ALTER TABLE editfmo ADD COLUMN per_reduz NUMERIC(8,2) &ALTER TABLE editfmo ADD COLUMN per_icm NUMERIC(5,2) &alter table editfmo add column obs text &ALTER TABLE editfmo ADD COLUMN per_reduz NUMERIC(8,2) &ALTER TABLE epapro ADD COLUMN lota CHAR(3) &ALTER TABLE editfmo ADD COLUMN per_icm NUMERIC(5,2) &ALTER TABLE nfvei ADD COLUMN idnci_dev INTEGER &ALTER TABLE nfcoi ADD COLUMN idnvi_dev INTEGER &alter table nfven add column vfcpst_t numeric(12,2) &alter table nfcom add column vfcpst_t numeric(12,2) &CREATE TABLE public.dfereceb ( id SERIAL, emp_cod CHAR(2), emit_cgc CHAR(20), emit_ie CHAR(20), emit_xnome CHAR(200), vnf NUMERIC(12,2), chnfe CHAR(44), demi DATE, tpevento CHAR(10), xevento CHAR(100), schema CHAR(20), hemi CHAR(10), dhsis TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now()) &ALTER TABLE public.dfereceb ADD COLUMN hemi CHAR(10) &ALTER TABLE public.dfereceb ADD COLUMN dhsis TIMESTAMP DEFAULT current_timestamp &alter table epafal add column codrep char(6) &ALTER TABLE genacs ADD COLUMN nome_child CHAR(20) &ALTER TABLE editfmo ADD COLUMN ind_est CHAR(1) &ALTER TABLE editfmo ADD COLUMN codfor CHAR(6) &ALTER TABLE dfereceb ADD COLUMN nsu INTEGER &ALTER TABLE epalot ADD COLUMN coddep CHAR(2) &ALTER TABLE epavol ADD COLUMN coddep CHAR(2) &CREATE TABLE epalot(data_venc DATE,lote CHAR(20),chave_u CHAR(23),emp_cod CHAR(2),qtde_s NUMERIC(10,4),id SERIAL,codpro CHAR(13),qtde_e NUMERIC(10,4),qtde NUMERIC(10,4),dfab DATE DEFAULT current_date,obs TEXT,coddep char(2)); &CREATE TABLE epavol ( volume CHAR(7) NOT NULL, chave_u CHAR(23), emp_cod CHAR(2), qtde_s NUMERIC(10,4), id SERIAL, codpro CHAR(13) NOT NULL, qtde_e NUMERIC(10,4), qtde NUMERIC(10,4), coddep CHAR(2), CONSTRAINT epavol_idx PRIMARY KEY(codpro, volume)) &alter table epapro add column temlote boolean &alter table epapro add column lote_tam boolean &ALTER TABLE nfesta ALTER COLUMN eml_smtp TYPE CHAR(200); ALTER TABLE nfesta ALTER COLUMN eml_email TYPE CHAR(200); ALTER TABLE nfesta ALTER COLUMN eml_login TYPE CHAR(200); ALTER TABLE nfcesta ALTER COLUMN eml_smtp TYPE CHAR(200); ALTER TABLE nfcesta ALTER COLUMN eml_email TYPE CHAR(200); ALTER TABLE nfcesta ALTER COLUMN eml_login TYPE CHAR(200); ALTER TABLE nfesta ADD COLUMN flag BOOLEAN; &ALTER TABLE regfis ADD COLUMN tpdoc CHAR(2) &ALTER TABLE textos ADD COLUMN cod_aj CHAR(10) &alter table centroc add column flag boolean default false &alter table epaprc add column custo_ind_nac numeric(12,4) &ALTER TABLE epapro ADD COLUMN csosn CHAR(4) &ALTER TABLE epapro ADD COLUMN cstrn char(4) &alter table cliente add column codcli_cob char(6) &ALTER TABLE pedven DROP COLUMN km; &alter table grupo add column grade_roupa char(50) &CREATE TABLE defpag (id SERIAL,alias_ori CHAR(3),chave_ori INTEGER,codmoe CHAR(3),valor NUMERIC(12,2),chave_pla INTEGER,descpag CHAR(30),jsondados TEXT) &ALTER TABLE comsta ADD COLUMN per_senar numeric(5,2) DEFAULT 0.00 &ALTER TABLE comsta ADD COLUMN per_rat numeric(5,2) DEFAULT 0.00 &ALTER TABLE pedvei ADD COLUMN b_ipi_tri numeric(12,2) &alter table pedven add column chave_pag integer &alter table epaprc add column prom_regra char(5) &alter table editfmo add column lote char(10) &alter table editfmo add column volume char(7) &alter table editfmo add column data_venc date &CREATE TABLE nferastro ( id SERIAL, alias_ori CHAR(3), id_ori INTEGER, chave_ori INTEGER, nlote CHAR(20), qlote NUMERIC(12,3), dfab DATE, dval DATE, emp_cod CHAR(2), codpro CHAR(13)) &ALTER TABLE ptssta ADD COLUMN ativo BOOLEAN &CREATE TABLE public.ptssta ( formula TEXT, datain DATE, valor_ponto NUMERIC(15,5), pontos_min NUMERIC(15,5), diasvalidade INTEGER, valor_mult NUMERIC(15,5), ativo BOOLEAN) &ALTER TABLE genreldv ADD COLUMN def_alias CHAR(3) &ALTER TABLE movdoci ADD COLUMN datafin_p DATE &ALTER TABLE movdoc ADD COLUMN data_ent date &ALTER TABLE movdoci ADD COLUMN dataini_p DATE &ALTER TABLE pedven ADD COLUMN frota CHAR(10); &ALTER TABLE movdoc ADD COLUMN codccu CHAR(2); &ALTER TABLE orcven ADD COLUMN total_serv NUMERIC(12,2); &ALTER TABLE pedven ADD COLUMN km CHAR(7); &alter table epapro add column per_dif numeric(5,2) &ALTER TABLE reports ADD COLUMN lbx TEXT &ALTER TABLE reports ADD COLUMN lbt TEXT &alter table empmoi add column lote char(10) &alter table empmoi add column volume char(7) &alter table genarq add column fieldslook text &alter table empmoi add column data_venc date &CREATE TABLE movdoc ( nromvd CHAR(6) NOT NULL, codcli CHAR(6), nome CHAR(50), datac DATE, total_mvd NUMERIC(12,2) DEFAULT 0, chave_u CHAR(23), cor NUMERIC(10,0), notas TEXT, emp_cod CHAR(2), serie CHAR(3), codfor CHAR(6), codmov CHAR(2), nrorom CHAR(9), obs TEXT, codnat CHAR(4), f_peso_faz NUMERIC(10,3), f_peso_frig NUMERIC(10,3), f_peso_quente NUMERIC(10,3), f_peso_frio NUMERIC(10,3), nrorom2 CHAR(9), nrorom3 CHAR(9), nrorom4 CHAR(9), nrorom5 CHAR(9), data_ent DATE, data_enc DATE,CONSTRAINT movdoc_pkey PRIMARY KEY(nromvd)) WITH (oids = true); &ALTER TABLE nfesta ALTER COLUMN eml_senha TYPE VARCHAR(255); ALTER TABLE nfcesta ALTER COLUMN eml_senha TYPE VARCHAR(255); &ALTER TABLE nfesta ALTER COLUMN eml_senha TYPE VARCHAR(255); ALTER TABLE nfcesta ALTER COLUMN eml_senha TYPE VARCHAR(255); &ALTER TABLE repres ADD COLUMN situacao CHAR(1);ALTER TABLE epapro ALTER COLUMN adremicms TYPE numeric(7,4);ALTER TABLE nfvei ALTER COLUMN adremicms TYPE numeric(7,4); &ALTER TABLE epapro ADD COLUMN localrep_moto char(20) &ALTER TABLE epapro ADD COLUMN conces_moto char(15) &ALTER TABLE epapro ADD COLUMN situacao_moto char(15) &ALTER TABLE epapro ADD COLUMN dt_envio_moto DATE &ALTER TABLE epapro ADD COLUMN repres_moto CHAR(15) &ALTER TABLE epapro ADD COLUMN vei_prop_codcid CHAR(4) &ALTER TABLE epapro ADD COLUMN vei_prop_end CHAR(70) &ALTER TABLE epapro ADD COLUMN vei_prop_cgc CHAR(14) &ALTER TABLE epapro ADD COLUMN vei_prop_nome CHAR(70) &ALTER TABLE nfcesta ALTER COLUMN eml_login TYPE VARCHAR(50); &ALTER TABLE nfesta ALTER COLUMN eml_login TYPE VARCHAR(100); &alter table epapro add column pbio numeric(7,4) &alter table cartoes add column cnpj_ins char(14) &alter table nfvei add column adremicms numeric(7,4) &alter table epapro add column adremicms numeric(7,4) &alter table cartoes alter column tipo type char(2) &CREATE TABLE ncinvi ( id_nci INTEGER, id_nvi INTEGER, qtde_sai NUMERIC(10,4), emp_cod CHAR(2), datac DATE) ; &ALTER TABLE clipts ADD COLUMN cgc CHAR(14); &ALTER TABLE ptssta ADD COLUMN reais_pontos NUMERIC(10,2); &CREATE TABLE movdoci ( nromvd CHAR(6), codpro CHAR(13), nome CHAR(50), qtde NUMERIC(10,3) DEFAULT 0, valor NUMERIC(12,3) DEFAULT 0, obs CHAR(50), coduni CHAR(2), coddep CHAR(2), emp_cod CHAR(2), id SERIAL, codmov CHAR(2), pecas NUMERIC(10,2), pesoliq NUMERIC(10,2), lote CHAR(10), volume CHAR(7), data_venc DATE, dataini_p DATE, datafin_p DATE, CONSTRAINT movdoci_pkey PRIMARY KEY(id), CONSTRAINT codddep_empmoi FOREIGN KEY (coddep) REFERENCES public.deposi(coddep) ON DELETE RESTRICT ON UPDATE CASCADE NOT DEFERRABLE, CONSTRAINT codpro_empmoi FOREIGN KEY (codpro) REFERENCES public.epapro(codpro) ON DELETE RESTRICT ON UPDATE CASCADE NOT DEFERRABLE, CONSTRAINT coduni_empmoi FOREIGN KEY (coduni) REFERENCES public.unidad(coduni) ON DELETE RESTRICT ON UPDATE CASCADE NOT DEFERRABLE ) WITH (oids = true); COMMENT ON COLUMN public.movdoci.pecas IS 'especifico para frigoestancia'; COMMENT ON COLUMN public.movdoci.pesoliq IS 'especifico para frigoestancia'; ALTER TABLE public.movdoci OWNER TO postgres; &ALTER TABLE sabor ADD COLUMN cor INTEGER; &CREATE TABLE public.nfcesta ( arquivo VARCHAR(60), vlay VARCHAR(10), vemis VARCHAR(10), vdanfe VARCHAR(1), codlay VARCHAR(10), grupoz TEXT, contig BOOLEAN, idkeysis CHAR(100), diraut CHAR(100), printdef BOOLEAN, nrocopia NUMERIC(1,0), tpemis NUMERIC(1,0), finalid NUMERIC(1,0), impres NUMERIC(1,0), ambiente NUMERIC(1,0), proxy_end CHAR(80), proxy_usu CHAR(30), proxy_sen CHAR(30), proxy_aut BOOLEAN, idkeyemp CHAR(50), eml_smtp CHAR(200), eml_email CHAR(200), eml_login CHAR(200), eml_senha VARCHAR(255), eml_porta CHAR(10), eml_ssl BOOLEAN, id INTEGER, local CHAR(30), manifest BOOLEAN, indpres CHAR(1), tokenid CHAR(10), token CHAR(50), contig_d DATE, contig_h CHAR(5), contig_mot CHAR(100), contig_tp CHAR(1), contig_aut BOOLEAN, danfe_simp BOOLEAN DEFAULT false, indzip BOOLEAN, indsinc BOOLEAN, dir_req CHAR(100), dir_resp CHAR(100), ftp_end CHAR(100), ftp_user CHAR(60), ftp_senha CHAR(60), ftp_dir CHAR(60), ftp_envia BOOLEAN DEFAULT false, marca_impr CHAR(2), ctg_envaut BOOLEAN, dircentral CHAR(100), qrlat BOOLEAN DEFAULT true) &alter table epapro add column vai_pos boolean default false &alter table empmov add column hora_venc char(5) &ALTER TABLE empmov ADD COLUMN aux char(1);ALTER TABLE empmov ALTER COLUMN nroemm TYPE char(9);ALTER TABLE empmoi ALTER COLUMN nroemm TYPE char(9); &alter table caxsta add column nro_caixa numeric(2) &CREATE TABLE caxpedp(nrodoc CHAR(6),preco_uni NUMERIC(7,3),litros NUMERIC(7,3),valor NUMERIC(10,3),datac DATE,bico CHAR(2),codpro CHAR(13),hora CHAR(4),contador NUMERIC(12,3),nro_caixa NUMERIC(2,0), datadia DATE,nseq CHAR(4),valor_ind NUMERIC(10,3),ja_mov BOOLEAN,status CHAR(1),codrep CHAR(2),codcli CHAR(6),nome CHAR(30),cgc CHAR(14),insc_est CHAR(12),endereco CHAR(30),cor NUMERIC(10,0),idfid CHAR(16),id SERIAL,transf BOOLEAN,hash CHAR(100)) &ALTER TABLE caxpedp ADD COLUMN hash char(100) &ALTER TABLE empmov ADD COLUMN nrodoc CHAR(6) &ALTER TABLE epapro ADD COLUMN origcomb TEXT &ALTER TABLE plamov ADD COLUMN id SERIAL &ALTER TABLE fatsta ADD COLUMN sernfce CHAR(3) &ALTER TABLE caxsta ADD COLUMN nro_caixa NUMERIC(2,0); &ALTER TABLE forpro ALTER COLUMN codpro_for TYPE CHAR(50)