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