ALTER TABLE sync_to_jurnal ADD type_con ENUM('retail','resto');
ALTER TABLE sync_config ADD type_con ENUM('retail','resto');
ALTER TABLE sync_account_to_jurnal ADD type_con ENUM('retail','resto');
ALTER TABLE `sync_account_to_jurnal`
	ALTER `type_con` DROP DEFAULT;
ALTER TABLE `sync_account_to_jurnal`
	CHANGE COLUMN `type_con` `type_con` ENUM('retail','resto') NOT NULL AFTER `nama_akun`,
	DROP PRIMARY KEY,
	ADD PRIMARY KEY (`payment_fpkey`, `type_con`);


UPDATE sync_account_to_jurnal SET type_con = 'resto' WHERE type_con IS NULL;
UPDATE sync_config SET type_con = 'resto' WHERE type_con IS NULL;
UPDATE sync_to_jurnal SET type_con = 'resto' WHERE type_con IS NULL;