CREATE TABLE promo_category
(
	id int(11) NOT NULL AUTO_INCREMENT,
	category_name varchar DEFAULT NULL,
	PRIMARY KEY (id)
	);

INSERT INTO promo_category (category_name)
VALUES ('corporate-membership'), ('promo'), ('starter-month'), ('trial');

ALTER TABLE promotion_msa
ADD promo_category_id smallint(11);

UPDATE promotion_msa
SET promo_category_id = CASE
	WHEN id <= 38 THEN 4
	WHEN id = 165 THEN 4
	WHEN id BETWEEN 165 AND 654 THEN 2
	WHEN id BETWEEN 661 AND 663 THEN 4
	WHEN id BETWEEN 665 AND 697 THEN 2
	WHEN id BETWEEN 669 AND 795 THEN 4
	WHEN id BETWEEN 796 AND 801 THEN 2
	WHEN id = 848 THEN 4
	WHEN id BETWEEN 972 AND 1077 THEN 2
	WHEN id = 1081 THEN 4
	WHEN id = 1082 THEN 1
	WHEN id BETWEEN 1083 AND 1111 THEN 3
	WHEN id BETWEEN 1213 AND 1261 THEN 1
	WHEN id BETWEEN 1262 AND 1290 THEN 4
	ELSE NULL
	END;