-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 22, 2005 at 06:22 PM
-- Server version: 4.0.16
-- PHP Version: 4.3.5
-- 
-- Database: `mininova`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `banned`
-- 

CREATE TABLE `banned` (
  `id` int(1) NOT NULL auto_increment,
  `ip` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `banned`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `id_category` int(10) unsigned NOT NULL default '0',
  `kleurcode` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10010101 ;

-- 
-- Dumping data for table `categories`
-- 

INSERT INTO `categories` VALUES (4, 'Movies', 4, 0);
INSERT INTO `categories` VALUES (5, 'Music', 5, 0);
INSERT INTO `categories` VALUES (7, 'Enhancements', 7, 0);
INSERT INTO `categories` VALUES (3, 'Games', 3, 0);
INSERT INTO `categories` VALUES (8, 'Apps', 8, 0);
INSERT INTO `categories` VALUES (6, 'Misc.', 6, 0);
INSERT INTO `categories` VALUES (2, 'Books', 2, 0);
INSERT INTO `categories` VALUES (1, 'Anime', 1, 0);
INSERT INTO `categories` VALUES (11, 'Cracks', 11, 0);
INSERT INTO `categories` VALUES (10, 'Porn', 10, 0);
INSERT INTO `categories` VALUES (9, 'Series', 9, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `subcategories`
-- 

CREATE TABLE `subcategories` (
  `id` int(10) NOT NULL auto_increment,
  `id_category` int(10) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=156 ;

-- 
-- Dumping data for table `subcategories`
-- 

INSERT INTO `subcategories` VALUES (3, 1, 'Cardcaptor Sakura');
INSERT INTO `subcategories` VALUES (2, 1, 'Big O');
INSERT INTO `subcategories` VALUES (1, 1, 'Battle Programer Shirase');
INSERT INTO `subcategories` VALUES (4, 1, 'Chobits');
INSERT INTO `subcategories` VALUES (5, 1, 'Comics');
INSERT INTO `subcategories` VALUES (6, 1, 'Dragon ball');
INSERT INTO `subcategories` VALUES (7, 1, 'Dragonball GT');
INSERT INTO `subcategories` VALUES (8, 1, 'Dragonball Z');
INSERT INTO `subcategories` VALUES (9, 1, 'Flame of Recca');
INSERT INTO `subcategories` VALUES (10, 1, 'Full Metal Alchemist');
INSERT INTO `subcategories` VALUES (11, 1, 'Ghost In The Shell SAC');
INSERT INTO `subcategories` VALUES (12, 1, 'Gundam');
INSERT INTO `subcategories` VALUES (13, 1, 'Hunter X Hunter');
INSERT INTO `subcategories` VALUES (14, 1, 'Inu Yasha');
INSERT INTO `subcategories` VALUES (15, 1, 'Konkiki No Gash Bell');
INSERT INTO `subcategories` VALUES (16, 1, 'Last Exile');
INSERT INTO `subcategories` VALUES (17, 1, 'Naruto');
INSERT INTO `subcategories` VALUES (18, 1, 'Onegai Twins');
INSERT INTO `subcategories` VALUES (19, 1, 'Other');
INSERT INTO `subcategories` VALUES (20, 1, 'PlanetES');
INSERT INTO `subcategories` VALUES (21, 1, 'Prince of Tennis');
INSERT INTO `subcategories` VALUES (22, 1, 'Ranma 1/2');
INSERT INTO `subcategories` VALUES (23, 1, 'Ruroni Kenshin');
INSERT INTO `subcategories` VALUES (24, 1, 'Samurai Champloo');
INSERT INTO `subcategories` VALUES (25, 1, 'Scrapped Princess');
INSERT INTO `subcategories` VALUES (26, 1, 'Stellvia of the Universe');
INSERT INTO `subcategories` VALUES (27, 2, 'Audio books');
INSERT INTO `subcategories` VALUES (28, 2, 'Ebooks');
INSERT INTO `subcategories` VALUES (29, 3, 'Dreamcast');
INSERT INTO `subcategories` VALUES (30, 3, 'Game fixes/patches');
INSERT INTO `subcategories` VALUES (31, 3, 'GameCube');
INSERT INTO `subcategories` VALUES (32, 3, 'Linux');
INSERT INTO `subcategories` VALUES (33, 3, 'Mac');
INSERT INTO `subcategories` VALUES (34, 3, 'Other platforms');
INSERT INTO `subcategories` VALUES (35, 3, 'Palm, PocketPC & IPAQ');
INSERT INTO `subcategories` VALUES (36, 3, 'PS 2');
INSERT INTO `subcategories` VALUES (37, 3, 'PS X');
INSERT INTO `subcategories` VALUES (38, 3, 'ROMS / Retro');
INSERT INTO `subcategories` VALUES (39, 3, 'Sega Saturn');
INSERT INTO `subcategories` VALUES (40, 3, 'Video Demonstrations');
INSERT INTO `subcategories` VALUES (41, 3, 'Windows');
INSERT INTO `subcategories` VALUES (42, 3, 'XBox');
INSERT INTO `subcategories` VALUES (43, 4, 'Action');
INSERT INTO `subcategories` VALUES (44, 4, 'Adventure');
INSERT INTO `subcategories` VALUES (45, 4, 'Animation');
INSERT INTO `subcategories` VALUES (46, 4, 'Asian');
INSERT INTO `subcategories` VALUES (47, 4, 'Automotive/Cars');
INSERT INTO `subcategories` VALUES (48, 4, 'Comedy');
INSERT INTO `subcategories` VALUES (49, 4, 'Concerts');
INSERT INTO `subcategories` VALUES (50, 4, 'Documentary');
INSERT INTO `subcategories` VALUES (51, 4, 'Drama');
INSERT INTO `subcategories` VALUES (52, 4, 'DVD / Film Extras');
INSERT INTO `subcategories` VALUES (53, 4, 'Family');
INSERT INTO `subcategories` VALUES (54, 4, 'Fantasy');
INSERT INTO `subcategories` VALUES (55, 4, 'Gore Flicks');
INSERT INTO `subcategories` VALUES (56, 4, 'Horror');
INSERT INTO `subcategories` VALUES (57, 4, 'Kids');
INSERT INTO `subcategories` VALUES (58, 4, 'KVCD');
INSERT INTO `subcategories` VALUES (59, 4, 'Martial Arts');
INSERT INTO `subcategories` VALUES (60, 4, 'Mystery');
INSERT INTO `subcategories` VALUES (61, 4, 'Other');
INSERT INTO `subcategories` VALUES (62, 4, 'Romance');
INSERT INTO `subcategories` VALUES (63, 4, 'Samples / Trailers');
INSERT INTO `subcategories` VALUES (64, 4, 'Sci-Fi');
INSERT INTO `subcategories` VALUES (65, 4, 'Sports related');
INSERT INTO `subcategories` VALUES (66, 4, 'Thriller');
INSERT INTO `subcategories` VALUES (67, 5, 'Alternative');
INSERT INTO `subcategories` VALUES (68, 5, 'Asian');
INSERT INTO `subcategories` VALUES (69, 5, 'Blues');
INSERT INTO `subcategories` VALUES (70, 5, 'Christian');
INSERT INTO `subcategories` VALUES (71, 5, 'Classic');
INSERT INTO `subcategories` VALUES (72, 5, 'Country / Western');
INSERT INTO `subcategories` VALUES (73, 5, 'Drum N Bass');
INSERT INTO `subcategories` VALUES (74, 5, 'Electronic');
INSERT INTO `subcategories` VALUES (75, 5, 'Game Music');
INSERT INTO `subcategories` VALUES (76, 5, 'Hardcore');
INSERT INTO `subcategories` VALUES (77, 5, 'HardHouse/Old School Radio Mix');
INSERT INTO `subcategories` VALUES (78, 5, 'Hip Hop');
INSERT INTO `subcategories` VALUES (79, 5, 'Industrial');
INSERT INTO `subcategories` VALUES (80, 5, 'Jazz');
INSERT INTO `subcategories` VALUES (81, 5, 'Karaoke');
INSERT INTO `subcategories` VALUES (82, 5, 'Metal');
INSERT INTO `subcategories` VALUES (83, 5, 'Other');
INSERT INTO `subcategories` VALUES (84, 5, 'Pop');
INSERT INTO `subcategories` VALUES (85, 5, 'Punk');
INSERT INTO `subcategories` VALUES (86, 5, 'R&B');
INSERT INTO `subcategories` VALUES (87, 5, 'Rap');
INSERT INTO `subcategories` VALUES (88, 5, 'Reggae');
INSERT INTO `subcategories` VALUES (89, 5, 'Rock');
INSERT INTO `subcategories` VALUES (90, 5, 'Soundtracks');
INSERT INTO `subcategories` VALUES (91, 5, 'Trance / House / Dance');
INSERT INTO `subcategories` VALUES (92, 5, 'Unsigned/Amateur');
INSERT INTO `subcategories` VALUES (93, 5, 'Video clips');
INSERT INTO `subcategories` VALUES (94, 6, 'Articles');
INSERT INTO `subcategories` VALUES (95, 6, 'Comics');
INSERT INTO `subcategories` VALUES (96, 6, 'Flash/Shockwave');
INSERT INTO `subcategories` VALUES (97, 6, 'Funny clips');
INSERT INTO `subcategories` VALUES (98, 6, 'Manuals');
INSERT INTO `subcategories` VALUES (99, 6, 'Other');
INSERT INTO `subcategories` VALUES (100, 6, 'Religion');
INSERT INTO `subcategories` VALUES (101, 7, 'Other');
INSERT INTO `subcategories` VALUES (102, 7, 'Wallpapers');
INSERT INTO `subcategories` VALUES (103, 8, 'Linux');
INSERT INTO `subcategories` VALUES (104, 8, 'Mac');
INSERT INTO `subcategories` VALUES (105, 8, 'Other operating systems');
INSERT INTO `subcategories` VALUES (106, 8, 'Palm, PocketPC & IPAQ');
INSERT INTO `subcategories` VALUES (107, 8, 'Windows - CD/DVD Tools');
INSERT INTO `subcategories` VALUES (108, 8, 'Windows - Other');
INSERT INTO `subcategories` VALUES (109, 8, 'Windows - Photo Editing');
INSERT INTO `subcategories` VALUES (110, 8, 'Windows - Security');
INSERT INTO `subcategories` VALUES (111, 8, 'Windows - Sound Editing');
INSERT INTO `subcategories` VALUES (112, 8, 'Windows - Video Apps');
INSERT INTO `subcategories` VALUES (113, 9, '24');
INSERT INTO `subcategories` VALUES (114, 9, 'Alias');
INSERT INTO `subcategories` VALUES (115, 9, 'Buffy');
INSERT INTO `subcategories` VALUES (116, 9, 'Call For Help');
INSERT INTO `subcategories` VALUES (117, 9, 'Carnivale');
INSERT INTO `subcategories` VALUES (118, 9, 'Charmed');
INSERT INTO `subcategories` VALUES (119, 9, 'Cold Case');
INSERT INTO `subcategories` VALUES (120, 9, 'Comitted');
INSERT INTO `subcategories` VALUES (121, 9, 'CSI');
INSERT INTO `subcategories` VALUES (122, 9, 'Discovery Channel');
INSERT INTO `subcategories` VALUES (123, 9, 'Friends');
INSERT INTO `subcategories` VALUES (124, 9, 'Huff');
INSERT INTO `subcategories` VALUES (125, 9, 'JAG');
INSERT INTO `subcategories` VALUES (126, 9, 'Joey');
INSERT INTO `subcategories` VALUES (127, 9, 'Las Vegas');
INSERT INTO `subcategories` VALUES (128, 9, 'Law And Order');
INSERT INTO `subcategories` VALUES (129, 9, 'Lost');
INSERT INTO `subcategories` VALUES (130, 9, 'NCIS');
INSERT INTO `subcategories` VALUES (131, 9, 'Other');
INSERT INTO `subcategories` VALUES (132, 9, 'ReGenesis');
INSERT INTO `subcategories` VALUES (133, 9, 'Scrubs');
INSERT INTO `subcategories` VALUES (134, 9, 'Second Time Around');
INSERT INTO `subcategories` VALUES (135, 9, 'Smallville');
INSERT INTO `subcategories` VALUES (136, 9, 'Sports Illustrated');
INSERT INTO `subcategories` VALUES (137, 9, 'Star-Trek Enterprise');
INSERT INTO `subcategories` VALUES (138, 9, 'Star-Trek The Next Generation');
INSERT INTO `subcategories` VALUES (139, 9, 'Stargate Atlantis');
INSERT INTO `subcategories` VALUES (140, 9, 'StarGate SG1');
INSERT INTO `subcategories` VALUES (141, 9, 'That 70s Show');
INSERT INTO `subcategories` VALUES (142, 9, 'The Daily Show');
INSERT INTO `subcategories` VALUES (143, 9, 'The Lost World');
INSERT INTO `subcategories` VALUES (144, 9, 'The O.C.');
INSERT INTO `subcategories` VALUES (145, 9, 'The Simpsons');
INSERT INTO `subcategories` VALUES (146, 9, 'The West Wing');
INSERT INTO `subcategories` VALUES (147, 9, 'Unscripted');
INSERT INTO `subcategories` VALUES (148, 9, 'Veronica Mars');
INSERT INTO `subcategories` VALUES (149, 9, 'Will And Grace');
INSERT INTO `subcategories` VALUES (150, 9, 'WWE');
INSERT INTO `subcategories` VALUES (151, 10, 'Real');
INSERT INTO `subcategories` VALUES (152, 10, 'Hentai');
INSERT INTO `subcategories` VALUES (153, 11, 'Apps');
INSERT INTO `subcategories` VALUES (154, 11, 'Games');
INSERT INTO `subcategories` VALUES (155, 11, 'Other');

-- --------------------------------------------------------

-- 
-- Table structure for table `torrents`
-- 

CREATE TABLE `torrents` (
  `id` int(1) NOT NULL auto_increment,
  `name` int(10) NOT NULL default '0',
  `seeds` int(10) NOT NULL default '0',
  `peers` int(10) NOT NULL default '0',
  `size` int(10) NOT NULL default '0',
  `info` int(10) NOT NULL default '0',
  `time_added` int(10) NOT NULL default '0',
  `id_tracker` int(10) NOT NULL default '0',
  `id_subcategory` int(10) NOT NULL default '0',
  `downloaded` int(100) NOT NULL default '0',
  `hash` int(100) NOT NULL default '0',
  `filename` int(100) NOT NULL default '0',
  `time_lastscrape` int(100) NOT NULL default '0',
  `ip` varchar(255) NOT NULL default '0',
  `torrent_id` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `torrents`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `total_downloads`
-- 

CREATE TABLE `total_downloads` (
  `id` int(1) NOT NULL auto_increment,
  `count` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `total_downloads`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `trackers`
-- 

CREATE TABLE `trackers` (
  `id` int(1) NOT NULL auto_increment,
  `registered` int(10) NOT NULL default '0',
  `scrape` int(100) NOT NULL default '0',
  `ip` varchar(225) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `trackers`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `uploads`
-- 

CREATE TABLE `uploads` (
  `id` int(100) NOT NULL default '0',
  `ip` varchar(255) NOT NULL default '',
  `torrent_id` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `uploads`
-- 

