X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.17%2F03_xnetgrp.sql;h=bf012cfc40b5c1288a593ff7b4b7b1c7d472b198;hb=4f35a3ca07b72943c53395ffc7ea49d493031940;hp=7f250484ae84a5e0816f247c4d8612290f852d04;hpb=fa9493fed672b90d29dae080498c99ee26729460;p=platal.git

diff --git a/upgrade/0.9.17/03_xnetgrp.sql b/upgrade/0.9.17/03_xnetgrp.sql
index 7f25048..bf012cf 100644
--- a/upgrade/0.9.17/03_xnetgrp.sql
+++ b/upgrade/0.9.17/03_xnetgrp.sql
@@ -2,6 +2,15 @@ use groupex;
 
 alter table asso change column flags flags set('wiki_desc', 'notif_unsub') not null;
 
+create table membres_sub_requests (
+  asso_id smallint(5) unsigned not null,
+  uid int(11) not null,
+  ts timestamp not null default NOW(),
+  reason text default null,
+
+  primary key sub (asso_id, uid)
+) charset=utf8;
+
 use x4dat;
 
 # vim:set syntax=mysql: