9 lines
437 B
MySQL
9 lines
437 B
MySQL
|
ALTER TABLE IF EXISTS `vn2008`.`Splits` RENAME `vn`.`split`;
|
||
|
|
|
||
|
|
ALTER TABLE IF EXISTS `vn`.`split`
|
||
|
|
CHANGE COLUMN IF EXISTS `Id_Split` `id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
CHANGE COLUMN IF EXISTS `Id_Ticket` `ticketFk` int(11) DEFAULT NULL,
|
||
|
|
CHANGE COLUMN IF EXISTS `Id_Entrada` `entryFk` int(11) DEFAULT NULL,
|
||
|
|
CHANGE COLUMN IF EXISTS `Fecha` `dated` datetime DEFAULT NULL,
|
||
|
|
CHANGE COLUMN IF EXISTS `Notas` `note` varchar(255) DEFAULT NULL;
|