7 lines
405 B
MySQL
7 lines
405 B
MySQL
|
ALTER TABLE IF EXISTS `vn2008`.`Remesas` RENAME `vn`.`remittance`;
|
||
|
|
||
|
ALTER TABLE IF EXISTS `vn`.`remittance`
|
||
|
CHANGE COLUMN IF EXISTS `Id_Remesa` `id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
CHANGE COLUMN IF EXISTS `Fecha Remesa` `dated` datetime DEFAULT NULL,
|
||
|
CHANGE COLUMN IF EXISTS `Banco` `accountingFk` int(11) DEFAULT 0,
|
||
|
CHANGE COLUMN IF EXISTS `empresa_id` `companyFk` int(10) unsigned NOT NULL DEFAULT 442;
|