[platal.git] / upgrade / 0.9.14 / 03_evenements.sql

alter table evenements change flags flags set('valide', 'archive', 'important') not null;
alter table evenements add post_id smallint(4) unsigned default NULL;
create table evenements_photo (
    eid smallint(4) unsigned not null,
    attachmime enum('jpeg', 'png', 'gif') not null default 'jpeg',
    attach blob not null,
    x smallint(5) unsigned not null default 0,
    y smallint(5) unsigned not null default 0,
    primary key eid (eid)
) charset=utf8;

use groupex;
alter table announces add post_id smallint(4) unsigned default NULL;
use x4dat;

# vim:set syntax=mysql:
Commit	Line	Data
02838718	1	alter table evenements change flags flags set('valide', 'archive', 'important') not null;
b2bffbe6	2	alter table evenements add post_id smallint(4) unsigned default NULL;
02838718	3	create table evenements_photo (
	4	eid smallint(4) unsigned not null,
	5	attachmime enum('jpeg', 'png', 'gif') not null default 'jpeg',
	6	attach blob not null,
	7	x smallint(5) unsigned not null default 0,
	8	y smallint(5) unsigned not null default 0,
	9	primary key eid (eid)
	10	) charset=utf8;
	11
e219710a	12	use groupex;
	13	alter table announces add post_id smallint(4) unsigned default NULL;
	14	use x4dat;
	15
02838718	16	# vim:set syntax=mysql: