CREATE TABLE IF NOT EXISTS `plugin_fileleech_access_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `username` varchar(255) COLLATE utf8_bin NOT NULL,
  `password` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ;

CREATE TABLE IF NOT EXISTS `plugin_fileleech_download` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `file_url` text COLLATE utf8_bin NOT NULL,
  `filesize` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) DEFAULT NULL,
  `user_ip_address` varchar(15) COLLATE utf8_bin NOT NULL,
  `date_download` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `site_id` (`site_id`,`user_id`),
  KEY `filesize` (`filesize`),
  KEY `user_id` (`user_id`),
  KEY `date_download` (`date_download`),
  KEY `user_ip_address` (`user_ip_address`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ;

CREATE TABLE IF NOT EXISTS `plugin_fileleech_site` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) COLLATE utf8_bin NOT NULL,
  `site_url` varchar(255) COLLATE utf8_bin NOT NULL,
  `min_account_type` varchar(10) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=73 ;

INSERT INTO `plugin_fileleech_site` (`id`, `site_name`, `site_url`, `min_account_type`) VALUES
(1, '115.com', '115.com', 'paid'),
(3, '2Shared', '2shared.com', 'free'),
(4, '4Shared', '4shared.com', 'free'),
(7, 'Bayfiles', 'bayfiles.com', 'paid'),
(8, 'Bayimg', 'bayimg.com', 'none'),
(9, 'Bitshare', 'bitshare.com', 'paid'),
(10, 'Chomikuj', 'chomikuj.pl', 'paid'),
(11, 'Cramit.in', 'cramit.in', 'paid'),
(12, 'Crocko.com', 'crocko.com', 'paid'),
(13, 'Data.hu', 'data.hu', 'free'),
(14, 'DepositFiles', 'depositfiles.com', 'paid'),
(18, 'Euroshare.eu', 'euroshare.eu', 'free'),
(20, 'Extabit', 'extabit.com', 'paid'),
(21, 'Filebin', 'filebin.ca', 'none'),
(22, 'FileCloud.io', 'filecloud.io', 'paid'),
(23, 'FileFactory', 'filefactory.com', 'paid'),
(26, 'FilePost', 'filepost.com', 'paid'),
(27, 'FilePup.net', 'filepup.net', 'paid'),
(29, 'FlashX.tv', 'flashx.tv', 'none'),
(30, 'FreakShare', 'freakshare.com', 'free'),
(31, 'Fshare.vn', 'fshare.vn', 'paid'),
(32, 'GameFront', 'gamefront.com', 'none'),
(33, 'Ge.tt', 'ge.tt', 'none'),
(34, 'Gfile.ru', 'gfile.ru', 'none'),
(36, 'HDStream', 'httphdstream.to', 'paid'),
(37, 'HipFile', 'hipfile.com', 'none'),
(40, 'LetitBit', 'letitbit.net', 'paid'),
(41, 'Mediafire', 'mediafire.com', 'free'),
(46, 'MyVdrive', 'myvdrive.com', 'paid'),
(47, 'Nakido', 'nakido.com', 'none'),
(48, 'Netload.in', 'netload.in', 'paid'),
(49, 'NowDownload', 'nowdownload.co', 'none'),
(50, 'OBOOM', 'oboom.com', 'paid'),
(53, 'RapidGator', 'rapidgator.net', 'paid'),
(54, 'Rapidshare', 'rapidshare.com', 'paid'),
(55, 'RGhost', 'rghost.net', 'none'),
(56, 'RyuShare', 'ryushare.com', 'paid'),
(57, 'Sendspace', 'sendspace.com', 'paid'),
(58, 'Sharebeast', 'sharebeast.com', 'none'),
(59, 'Share-Online', 'share-online.biz', 'paid'),
(60, 'Solidfiles', 'solidfiles.com', 'paid'),
(62, 'TurboBit.net', 'turbobit.net', 'paid'),
(63, 'Ultramegabit.com', 'ultramegabit.com', 'paid'),
(64, 'Uploadable', 'uploadable.ch', 'paid'),
(65, 'Uploaded.net', 'uploaded.net', 'paid'),
(66, 'UploadHero', 'uploadhero.com', 'free'),
(67, 'Uploading.com', 'uploading.com', 'none'),
(68, 'Upstore', 'upstore.net', 'free'),
(69, 'UpToBox', 'uptobox.com', 'paid'),
(71, 'Zalil', 'zalil.ru', 'none');