[platal.git] / upgrade / 0.9.17 / 03_xnetgrp.sql

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:
Commit	Line	Data
	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: