Commit | Line | Data |
---|---|---|
ff95a302 FB |
1 | use groupex; |
2 | ||
3 | CREATE TABLE `announces_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`) | |
10 | ) CHARSET=utf8; | |
11 | ||
12 | alter table groupex.announces change column flags flags set('public', 'photo') not null; | |
13 | ||
14 | use x4dat; | |
15 | ||
16 | # vim:set syntax=mysql: |