[platal.git] / upgrade / 1.1.12 / 04_profile_addresses_rename_ax-mail_to_dn-best-mail.sql

-- Rename ax_mail flag to dn_best_mail

ALTER TABLE profile_addresses MODIFY COLUMN flags SET('current', 'temporary', 'secondary', 'mail', 'cedex', 'deliveryIssue', 'ax_mail', 'dn_best_mail') DEFAULT NULL;

UPDATE profile_addresses SET flags=REPLACE(flags, 'ax_mail', 'dn_best_mail') WHERE FIND_IN_SET('ax_mail', flags);

ALTER TABLE profile_addresses MODIFY COLUMN flags SET('current', 'temporary', 'secondary', 'mail', 'cedex', 'deliveryIssue', 'dn_best_mail') DEFAULT NULL;

-- vim:set syntax=mysql:
Commit	Line	Data
8a1f4fbf NI	1	-- Rename ax_mail flag to dn_best_mail
	2
	3	ALTER TABLE profile_addresses MODIFY COLUMN flags SET('current', 'temporary', 'secondary', 'mail', 'cedex', 'deliveryIssue', 'ax_mail', 'dn_best_mail') DEFAULT NULL;
	4
	5	UPDATE profile_addresses SET flags=REPLACE(flags, 'ax_mail', 'dn_best_mail') WHERE FIND_IN_SET('ax_mail', flags);
	6
	7	ALTER TABLE profile_addresses MODIFY COLUMN flags SET('current', 'temporary', 'secondary', 'mail', 'cedex', 'deliveryIssue', 'dn_best_mail') DEFAULT NULL;
	8
	9	-- vim:set syntax=mysql: