Subversion Repositories Integrator Subversion

/*========tur===================================================*/
/* DBMS name:     PostgreSQL 8                                  */
/* Criado em:     14/11/2024                                        */
/* Autor: Bruno Lopes Peixoto                                       */
/*==============================================================*/

SET search_path = sc_sec;

ALTER TABLE sec_imposto_icms ALTER COLUMN cod_origem TYPE CHAR(1);
ALTER TABLE sec_imposto_icms ALTER COLUMN cod_modbc TYPE CHAR(1);
ALTER TABLE sec_imposto_icms ALTER COLUMN cod_modbcst TYPE CHAR(1);

ALTER TABLE sec_nota_fiscal ADD COLUMN cod_st VARCHAR(2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_bc NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_pfcp NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_vfcp NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_picms NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_icms NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN cod_sosn VARCHAR(5) NULL;

ALTER TABLE sec_nota_fiscal ADD COLUMN val_bcfcpst NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_pfcpst NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_fcpst NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_pcredsn NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_credsn NUMERIC(10,2) NULL;
ALTER TABLE sec_nota_fiscal ADD COLUMN val_predbcst NUMERIC(10,2) NULL;

ALTER TABLE sec_imposto_icms ADD COLUMN xml_imposto TEXT NULL;
ALTER TABLE sec_nota_fiscal DROP COLUMN xml_imposto;

SET search_path = public;