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