[platal.git] / upgrade / 0.9.16 / 05_xnet_announce_photo.sql

use groupex;

CREATE TABLE `announces_photo` (
  `eid` smallint(4) unsigned NOT NULL,
  `attachmime` enum('jpeg','png','gif') NOT NULL default 'jpeg',
  `attach` blob NOT NULL,
  `x` smallint(5) unsigned NOT NULL default '0',
  `y` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`eid`)
) CHARSET=utf8;

alter table groupex.announces change column flags flags set('public', 'photo') not null;

use x4dat;

# vim:set syntax=mysql:
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: