CREATE TABLE IF NOT EXISTS `sync_category_account` (                    
 `id` int(10) NOT NULL AUTO_INCREMENT,                   
 `category_id` int(10) DEFAULT NULL,                     
 `sell_account_number` varchar(50) DEFAULT NULL,            
 `type_con` enum('resto','retail') DEFAULT NULL,         
 PRIMARY KEY (`id`)                                      
) ENGINE=INNODB DEFAULT CHARSET=latin1;

ALTER TABLE `sync_account_to_jurnal`
ADD `number_akun` varchar(90) DEFAULT NULL
AFTER `nama_akun`;