X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=upgrade%2F0.10.1%2F02_axletter.sql;h=524200e05ba3a790877a5e5b1e97fe7a6579f077;hb=c76545c351fae4e2298624ff9ee5bf854dc5a5b6;hp=a460fed4debe6dc07418674ac73ac7f6c3d8fa2a;hpb=4a08dc738828b2d7d4137f67b0f45f73b0ae89f1;p=platal.git

diff --git a/upgrade/0.10.1/02_axletter.sql b/upgrade/0.10.1/02_axletter.sql
index a460fed..524200e 100644
--- a/upgrade/0.10.1/02_axletter.sql
+++ b/upgrade/0.10.1/02_axletter.sql
@@ -1,12 +1,3 @@
-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
+ALTER TABLE axletter ADD subset TEXT NULL DEFAULT NULL AFTER promo_max;
 
 -- vim:set syntax=mysql:
-