| 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: |