salix/db/versions/10835-brownCarnation/05-Proveedores_gestdoc.sql

5 lines
254 B
MySQL
Raw Permalink Normal View History

ALTER TABLE IF EXISTS `vn2008`.`Proveedores_gestdoc` RENAME `vn`.`supplierDms`;
ALTER TABLE IF EXISTS `vn`.`supplierDms`
CHANGE COLUMN IF EXISTS `Id_Proveedor` `supplierFk` int(11) NOT NULL,
CHANGE COLUMN IF EXISTS `gestdoc_id` `dmsFk` int(11) NOT NULL;