CREATE TABLE [WP_PREFIX]photocontest_admin (
	contest_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	post_id bigint unsigned NOT NULL,
	start_date datetime NOT NULL,
	end_date datetime NOT NULL,
	upload_date datetime NOT NULL,
	contest_path varchar(255) NOT NULL,
	contest_name varchar(255),
	intro_text text,
	num_photo int unsigned default 0,
	max_photos int unsigned default 1,
	UNIQUE KEY start_date (start_date,end_date,contest_path),
	PRIMARY KEY  (contest_id)
);

CREATE TABLE [WP_PREFIX]photocontest (
	contest_id int(10) unsigned default NULL,
	wp_uid bigint(20) unsigned default NULL,
	img_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	img_path varchar(255) NOT NULL,
	img_name varchar(255) default NULL,
	img_title varchar(500) default NULL,
	img_comment text,
	sum_votes int unsigned default '0',
	img_view_count bigint(20) unsigned default '0',
	insert_time datetime default NULL,
	visibile tinyint default 1,
	UNIQUE KEY contest_id (contest_id,wp_uid,img_id),
	PRIMARY KEY  img_id (img_id)
);

CREATE TABLE [WP_PREFIX]photocontest_votes (
	img_id bigint(20) unsigned NOT NULL,
	voter_id varchar(36) NOT NULL,
	vote_time timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
	vote smallint unsigned CHECK (vote <= 10 and vote >= 0),
	captcha_text varchar(5) NOT NULL,
	voter_email varchar(255) NOT NULL,
	UNIQUE KEY img_id (img_id, voter_id)
);