11 lines
579 B
MySQL
11 lines
579 B
MySQL
|
ALTER TABLE IF EXISTS `vn2008`.`Saldos_Prevision` RENAME `vn`.`forecastedBalance`;
|
||
|
|
|
||
|
|
ALTER TABLE IF EXISTS `vn`.`forecastedBalance`
|
||
|
|
CHANGE COLUMN IF EXISTS `Saldos_Prevision_id` `id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
CHANGE COLUMN IF EXISTS `Descripcion` `description` varchar(45) DEFAULT NULL,
|
||
|
|
CHANGE COLUMN IF EXISTS `Importe` `amount` double NOT NULL DEFAULT 0,
|
||
|
|
CHANGE COLUMN IF EXISTS `Fecha` `dated` date NOT NULL,
|
||
|
|
CHANGE COLUMN IF EXISTS `Id_Banco` `accountingFk` int(11) DEFAULT NULL,
|
||
|
|
CHANGE COLUMN IF EXISTS `empresa_id` `companyFk` int(10) unsigned NOT NULL DEFAULT 442;
|
||
|
|
|