[platal.git] / upgrade / 0.10.1 / 02_axletter.sql

DROP TABLE IF EXISTS axletter_subsets;

CREATE TABLE IF NOT EXISTS axletter_subsets (
    letter_id INT(11) UNSIGNED NOT NULL,
    uid INT(11) NOT NULL,
    email VARCHAR(255) NOT NULL
)

ALTER TABLE axletter ADD subset smallint(1) NOT NULL DEFAULT 0 AFTER promo_max

-- vim:set syntax=mysql:
Commit	Line	Data
4a08dc73	1	DROP TABLE IF EXISTS axletter_subsets;
2a3f4f57	2
4a08dc73	3	CREATE TABLE IF NOT EXISTS axletter_subsets (
2a3f4f57	4	letter_id INT(11) UNSIGNED NOT NULL,
4a08dc73	5	uid INT(11) NOT NULL,
2a3f4f57 RB	6	email VARCHAR(255) NOT NULL
	7	)
	8
	9	ALTER TABLE axletter ADD subset smallint(1) NOT NULL DEFAULT 0 AFTER promo_max
	10
	11	-- vim:set syntax=mysql:
	12