salix/db/versions/.archive/10458-orangePalmetto/00-firstScript.sql

18 lines
429 B
MySQL
Raw Permalink Normal View History

-- Place your SQL code here
ALTER TABLE `vn`.`XDiario`
DROP COLUMN `BASEIMPO`,
DROP COLUMN `DOCUMENTO`,
DROP COLUMN `DEPARTA`,
DROP COLUMN `ESTADO`,
DROP COLUMN `NCASADO`,
DROP COLUMN `TCASADO`,
DROP COLUMN `TRANS`,
DROP COLUMN `PTAHABER`,
DROP COLUMN `SUCURSAL`,
DROP COLUMN `PTADEBE`,
DROP COLUMN `CODDIVISA`,
DROP COLUMN `IMPAUXME`,
DROP COLUMN `NOCONV`,
DROP COLUMN `NUMEROINV`,
DROP COLUMN `TIPOFAC`,
DROP COLUMN `TIPOIVA`;