salix/db/versions/10835-brownCarnation/13-account_detail.sql

6 lines
392 B
SQL

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;