upgrade/0.10.1/02_axletter.sql

   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