CREATE DATABASE IF NOT EXISTS `moopolice` DEFAULT CHARACTER SET utf8;

CREATE USER 'MooPolice' IDENTIFIED BY '';

GRANT ALL ON MooPolice.* TO 'MooPolice';

CREATE TABLE IF NOT EXISTS `moopolice`.`torrent_data` (

  `id` int(10) unsigned NOT NULL auto_increment,
  `priority` int(10) unsigned NOT NULL default '1',
  `status` int(10) unsigned NOT NULL default '0',
  `destination` text NOT NULL,
  `finished` tinyint(1) NOT NULL default '0',
  `upload_limit` int(11) NOT NULL default '-1',
  `download_limit` int(11) NOT NULL default '-1',
  `seeding_mode` int(10) unsigned NOT NULL default '0',
  `seeding_ratio` float NOT NULL default '2',

  `peer_ratio` float NOT NULL default '0',
  `seeding_time` int(10) unsigned NOT NULL default '3600000',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `show_state` tinyint(1) NOT NULL default '0',
  `bitcomet_udp_protocol` tinyint(1) NOT NULL default '0',
  `info_hash` varchar(45) NOT NULL default '',
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `name` varchar(2048) default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `moopolice`.`trackers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `torrent_data_id` int(10) unsigned NOT NULL default '0',

  `tracker_url` varchar(255) NOT NULL default '',
  `tier` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `moopolice`.`resume_data` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `torrent_data_id` int(10) unsigned NOT NULL default '0',
  `resume_data` longblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `moopolice`.`piece_selection` (

  `id` int(10) unsigned NOT NULL auto_increment,
  `torrent_data_id` int(10) unsigned NOT NULL default '0',
  `piece_map` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `moopolice`.`nodes` (

  `id` int(10) unsigned NOT NULL auto_increment,

  `torrent_data_id` int(10) unsigned default '0',
  `ip` varchar(20) NOT NULL default '',
  `port` int(10) unsigned default '0',
  `last_seen` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `moopolice`.`ip_filter` (

  `id` int(10) unsigned NOT NULL auto_increment,
  `ip_start` varchar(20) default NULL,
  `ip_end` varchar(20) default NULL,
  `flags` int(10) unsigned NOT NULL default '128',

  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `moopolice`.`auto_destinations` (

  `id` int(10) unsigned NOT NULL auto_increment,
  `key_words` varchar(255) NOT NULL default 'avi,mkv,ogm',

  `destination` text NOT NULL,
  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `moopolice`.`unfinished_torrents` (

  `torrent_data_id` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`torrent_data_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='to speed up the startup';