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',
12 alter table groupex.announces change
column flags flags
set('public', 'photo') not null;
16 # vim
:set syntax
=mysql
: