ALTER TABLE `tm_promo`
CHANGE COLUMN `id` `KodeCabang`  varchar(50) NOT NULL FIRST ,
MODIFY COLUMN `ItemBrg`  varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `DateEnd`,
ADD COLUMN `LimitPromo`  int(10) NULL AFTER `Max`,
ADD COLUMN `ClaimPromo`  int(10) NULL AFTER `LimitPromo`,
ADD COLUMN `UuidPromo`  char(36) NOT NULL AFTER `Aktif`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`KodeCabang`, `JenisPromo`, `ItemBrg`, `UuidPromo`);

SELECT * FROM tm_promo;