ALTER TABLE `sps_membership`   
	ADD COLUMN `serial_key` VARCHAR(255) NULL AFTER `card_type`;

ALTER TABLE `sps_membership_log`   
	ADD COLUMN `serial_key` VARCHAR(255) NULL AFTER `card_type`;


ALTER TABLE `sps_membership`
	ADD CONSTRAINT UC_sps_membership UNIQUE (card_no_prefix, card_no, serial_key, deleted_at);