upgrade/0.9.17/03_xnetgrp.sql

   1 use groupex;
   2
   3 alter table asso change column flags flags set('wiki_desc', 'notif_unsub') not null;
   4
   5 create table membres_sub_requests (
   6   asso_id smallint(5) unsigned not null,
   7   uid int(11) not null,
   8   ts timestamp not null default NOW(),
   9   reason text default null,
  10
  11   primary key sub (asso_id, uid)
  12 ) charset=utf8;
  13
  14 use x4dat;
  15
  16 # vim:set syntax=mysql: