DROP TABLE IF EXISTS `pre`;
CREATE TABLE IF NOT EXISTS `pre` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT 'identifier',
  `section` char(15) collate utf8_bin NOT NULL default 'UNKNOWN' COMMENT 'section',
  `name` char(255) collate utf8_bin NOT NULL COMMENT 'name',
  `grp` char(32) collate utf8_bin default NULL COMMENT 'group',
  `pretime` int(10) unsigned NOT NULL default '0' COMMENT 'unix timestamp',
  `nuketime` int(10) unsigned NOT NULL default '0' COMMENT 'unix timestamp',
  `nukereason` char(255) collate utf8_bin default NULL COMMENT 'nuke reason',
  `files` smallint(3) unsigned NOT NULL default '0' COMMENT 'number of files',
  `size` int(10) unsigned NOT NULL default '0' COMMENT 'total size in kbytes',
  `genre` char(32) collate utf8_bin default NULL COMMENT 'genre',
  `nfo` tinyint(1) unsigned default '0' COMMENT 'indicates if there are nfos for this release (0 = no / 1 = yes)',
  `sfv` tinyint(1) unsigned NOT NULL default '0' COMMENT 'indicates if there are sfvs for this release (0 = no / 1 = yes)',
  `sample` tinyint(1) unsigned NOT NULL default '0' COMMENT 'indicates if there are samples for this release (0 = no / 1 = yes)',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `release_unique` (`name`),
  KEY `section_idx` (`section`),
  KEY `grp_idx` (`grp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS `nfo`;
CREATE TABLE IF NOT EXISTS `nfo` (
  `id` mediumint(8) unsigned NOT NULL,
  `preid` mediumint(8) unsigned NOT NULL,
  `filename` char(255) collate utf8_bin NOT NULL,
  `filecontent` mediumtext collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS `sample`;
CREATE TABLE IF NOT EXISTS `sample` (
  `id` mediumint(8) unsigned NOT NULL,
  `preid` mediumint(8) unsigned NOT NULL,
  `filename` char(255) collate utf8_bin NOT NULL,
  `filecontent` mediumtext collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS `sfv`;
CREATE TABLE IF NOT EXISTS `sfv` (
  `id` mediumint(8) unsigned NOT NULL,
  `preid` mediumint(8) unsigned NOT NULL,
  `filename` char(255) collate utf8_bin NOT NULL,
  `filecontent` mediumtext collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;