6 lines
392 B
MySQL
6 lines
392 B
MySQL
|
ALTER TABLE IF EXISTS `vn2008`.`account_detail` RENAME `vn`.`accountDetail`;
|
||
|
|
||
|
ALTER TABLE IF EXISTS `vn`.`accountDetail`
|
||
|
CHANGE COLUMN IF EXISTS `account_detail_id` `id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
CHANGE COLUMN IF EXISTS `account_detail_type_id` `accountDetailTypeFk` int(11) NOT NULL,
|
||
|
CHANGE COLUMN IF EXISTS `Id_Proveedores_account` `supplierAccountFk` mediumint(8) unsigned NOT NULL;
|