upgrade/0.9.16/05_xnet_announce_photo.sql

   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: