Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 536 | blopes | 1 | /*========tur===================================================*/ |
| 2 | /* DBMS name: PostgreSQL 8 */ |
||
| 3 | /* Criado em: 14/11/2024 */ |
||
| 4 | /* Autor: Bruno Lopes Peixoto */ |
||
| 5 | /*==============================================================*/ |
||
| 6 | |||
| 7 | SET search_path = sc_sec; |
||
| 8 | |||
| 9 | ALTER TABLE sec_imposto_icms ALTER COLUMN cod_origem TYPE CHAR(1); |
||
| 10 | ALTER TABLE sec_imposto_icms ALTER COLUMN cod_modbc TYPE CHAR(1); |
||
| 11 | ALTER TABLE sec_imposto_icms ALTER COLUMN cod_modbcst TYPE CHAR(1); |
||
| 12 | |||
| 13 | ALTER TABLE sec_nota_fiscal ADD COLUMN cod_st VARCHAR(2) NULL; |
||
| 14 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_bc NUMERIC(10,2) NULL; |
||
| 15 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_pfcp NUMERIC(10,2) NULL; |
||
| 16 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_vfcp NUMERIC(10,2) NULL; |
||
| 17 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_picms NUMERIC(10,2) NULL; |
||
| 18 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_icms NUMERIC(10,2) NULL; |
||
| 19 | ALTER TABLE sec_nota_fiscal ADD COLUMN cod_sosn VARCHAR(5) NULL; |
||
| 20 | |||
| 21 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_bcfcpst NUMERIC(10,2) NULL; |
||
| 22 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_pfcpst NUMERIC(10,2) NULL; |
||
| 23 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_fcpst NUMERIC(10,2) NULL; |
||
| 24 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_pcredsn NUMERIC(10,2) NULL; |
||
| 25 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_credsn NUMERIC(10,2) NULL; |
||
| 26 | ALTER TABLE sec_nota_fiscal ADD COLUMN val_predbcst NUMERIC(10,2) NULL; |
||
| 27 | |||
| 28 | ALTER TABLE sec_imposto_icms ADD COLUMN xml_imposto TEXT NULL; |
||
| 29 | ALTER TABLE sec_nota_fiscal DROP COLUMN xml_imposto; |
||
| 30 | |||
| 31 | SET search_path = public; |