03_evenements.sql

   1 alter table evenements change flags flags set('valide', 'archive', 'important') not null;
   2 alter table evenements add post_id smallint(4) unsigned default NULL;
   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
  12 use groupex;
  13 alter table announces add post_id smallint(4) unsigned default NULL;
  14 use x4dat;
  15
  16 # vim:set syntax=mysql: