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

DROP TABLE IF EXISTS axletter_subset;

CREATE TABLE IF NOT EXISTS axletter_subset (
    letter_id INT(11) UNSIGNED NOT NULL,
    user_id 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
2a3f4f57 RB	1	DROP TABLE IF EXISTS axletter_subset;
	2
	3	CREATE TABLE IF NOT EXISTS axletter_subset (
	4	letter_id INT(11) UNSIGNED NOT NULL,
	5	user_id INT(11) NOT NULL,
	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