X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.17%2F03_xnetgrp.sql;h=bf012cfc40b5c1288a593ff7b4b7b1c7d472b198;hb=06f4daf9ceb56712582d81330896848a1a262894;hp=7f250484ae84a5e0816f247c4d8612290f852d04;hpb=359f9ca3126ce7a3d16836bbe5c37329ba211b05;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: