[platal.git] / upgrade / 1.1.0 / 13_best_domain.sql

ALTER TABLE accounts ADD COLUMN best_domain SMALLINT(3) UNSIGNED DEFAULT NULL;
ALTER TABLE accounts ADD FOREIGN KEY (best_domain) REFERENCES email_virtual_domains (id) ON DELETE CASCADE ON UPDATE CASCADE;

-- vim:set syntax=mysql:
Commit	Line	Data
9f3f87bc SJ	1	ALTER TABLE accounts ADD COLUMN best_domain SMALLINT(3) UNSIGNED DEFAULT NULL;
	2	ALTER TABLE accounts ADD FOREIGN KEY (best_domain) REFERENCES email_virtual_domains (id) ON DELETE CASCADE ON UPDATE CASCADE;
	3
	4	-- vim:set syntax=mysql: