[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.4.beta1.mysql.tpl

{* file to handle db changes in 4.4.beta1 during upgrade *}
-- CRM-13314 Added States for Uruguay
INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(NULL, 1229, "FL", "Florida"),
(NULL, 1229, "RN", "Rio Negro"),
(NULL, 1229, "SJ", "San Jose");

ALTER TABLE civicrm_email
MODIFY email VARCHAR(254);
Commit	Line	Data
	1	{* file to handle db changes in 4.4.beta1 during upgrade *}
	2	-- CRM-13314 Added States for Uruguay
	3	INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
	4	(NULL, 1229, "FL", "Florida"),
	5	(NULL, 1229, "RN", "Rio Negro"),
	6	(NULL, 1229, "SJ", "San Jose");
	7
	8	ALTER TABLE civicrm_email
	9	MODIFY email VARCHAR(254);