

-- 
-- Tabellenstruktur für Tabelle `accounts`
-- 

CREATE TABLE `accounts` (
  `userid` int(10) NOT NULL default '0',
  `chash` varchar(32) binary NOT NULL default '',
  `lastaccess` datetime NOT NULL default '0000-00-00 00:00:00',
  `username` varchar(64) binary NOT NULL default '',
  `email` varchar(128) binary NOT NULL default '',
  `baduser` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`userid`,`chash`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `accounts`
-- 

INSERT INTO `accounts` VALUES (3953, 0x6438626432623532393061623331643462373638316633326635333430333962, '2008-06-17 19:10:09', 0x646a62726f636b656e, 0x646a62726f636b656e407765622e6465, 0);
INSERT INTO `accounts` VALUES (3955, 0x3264636435363362396263376432306462626237343532616230623961356538, '2008-06-15 20:05:18', 0x74657374, 0x676767, 0);

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

-- 
-- Tabellenstruktur für Tabelle `agents`
-- 

CREATE TABLE `agents` (
  `agent_id` int(10) unsigned NOT NULL auto_increment,
  `agent_name` varchar(255) binary NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  `ins_date` int(10) unsigned NOT NULL default '0',
  `aktiv` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`agent_id`),
  UNIQUE KEY `agent_name` (`agent_name`)
) TYPE=MyISAM AUTO_INCREMENT=580 AUTO_INCREMENT=580 ;

-- 
-- Daten für Tabelle `agents`
-- 

INSERT INTO `agents` VALUES (579, 0x75546f7272656e742f31353030, 12, 1213613740, 1);

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

-- 
-- Tabellenstruktur für Tabelle `announcedelay`
-- 

CREATE TABLE `announcedelay` (
  `peer_id` varchar(20) binary NOT NULL default '',
  `first` int(10) unsigned NOT NULL default '0',
  `second` int(10) unsigned NOT NULL default '0',
  `quantity` bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `announcedelay`
-- 

INSERT INTO `announcedelay` VALUES (0x2d5554313530302dc2b5c28124c3a5142231c3b9680341c2aa, 1213720533, 1213721734, 0);

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

-- 
-- Tabellenstruktur für Tabelle `announcement`
-- 

CREATE TABLE `announcement` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `body` text NOT NULL,
  `title` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `added` (`added`)
) TYPE=MyISAM AUTO_INCREMENT=61 AUTO_INCREMENT=61 ;

-- 
-- Daten für Tabelle `announcement`
-- 

INSERT INTO `announcement` VALUES (56, 3953, '2008-06-14 19:52:13', 0x72727272, 0x74657374);
INSERT INTO `announcement` VALUES (58, 3953, '2008-06-14 20:20:09', 0x72727272, 0x74657374);
INSERT INTO `announcement` VALUES (59, 3953, '2008-06-14 21:11:30', 0x72727272, 0x74657374);
INSERT INTO `announcement` VALUES (60, 3957, '2008-06-15 19:11:49', 0x5769722042656772c3bc7373656e20457563682048696572207465737420746573742074657374, 0x4865727a6c6963682057696c6c6b6f6d6d656e);

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

-- 
-- Tabellenstruktur für Tabelle `antiddos`
-- 

CREATE TABLE `antiddos` (
  `ips` char(255) NOT NULL default '',
  `load` int(2) default '0',
  KEY `ips` (`ips`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `antiddos`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `avps`
-- 

CREATE TABLE `avps` (
  `arg` varchar(20) binary NOT NULL default '',
  `value_s` text NOT NULL,
  `value_i` int(11) NOT NULL default '0',
  `value_u` int(10) unsigned NOT NULL default '0',
  `value_d` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`arg`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `avps`
-- 

INSERT INTO `avps` VALUES (0x6c617374636c65616e74696d65, '', 0, 1213724722, '0000-00-00 00:00:00');
INSERT INTO `avps` VALUES (0x6c6173743234, '', 7, 1213556352, '0000-00-00 00:00:00');

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

-- 
-- Tabellenstruktur für Tabelle `ban`
-- 

CREATE TABLE `ban` (
  `id` mediumint(8) NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `addedby` int(10) unsigned NOT NULL default '0',
  `comment` varchar(255) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  `userid` varchar(255) NOT NULL default '',
  `hash` varchar(255) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `ban`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `bans`
-- 

CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `addedby` int(10) unsigned NOT NULL default '0',
  `comment` varchar(255) binary NOT NULL default '',
  `first` int(11) default NULL,
  `last` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `first_last` (`first`,`last`)
) TYPE=MyISAM AUTO_INCREMENT=37 AUTO_INCREMENT=37 ;

-- 
-- Daten für Tabelle `bans`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `bitbucket`
-- 

CREATE TABLE `bitbucket` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `filename` varchar(40) binary NOT NULL default '',
  `size` int(11) NOT NULL default '0',
  `originalname` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=69 AUTO_INCREMENT=69 ;

-- 
-- Daten für Tabelle `bitbucket`
-- 

INSERT INTO `bitbucket` VALUES (68, 3953, 0x37333665646436663730386266366137303235666134393365393337663561392e6a7067, 88374, 0x646a62726f636b656e2e6a7067);

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

-- 
-- Tabellenstruktur für Tabelle `bitreactor`
-- 

CREATE TABLE `bitreactor` (
  `torrentid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2496 AUTO_INCREMENT=2496 ;

-- 
-- Daten für Tabelle `bitreactor`
-- 

INSERT INTO `bitreactor` VALUES (4074, 3953, 2495);

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

-- 
-- Tabellenstruktur für Tabelle `blackjack`
-- 

CREATE TABLE `blackjack` (
  `userid` int(11) NOT NULL default '0',
  `points` int(11) NOT NULL default '0',
  `status` enum('playing','waiting') NOT NULL default 'playing',
  `cards` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `started` char(1) NOT NULL default '0',
  `gewonnen` enum('yes') NOT NULL default 'yes',
  `verloren` enum('yes') NOT NULL default 'yes',
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `blackjack`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `blocks`
-- 

CREATE TABLE `blocks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `blockid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userfriend` (`userid`,`blockid`)
) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;

-- 
-- Daten für Tabelle `blocks`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `bonus`
-- 

CREATE TABLE `bonus` (
  `id` int(5) NOT NULL auto_increment,
  `bonusname` varchar(50) binary NOT NULL default '',
  `points` double NOT NULL default '0',
  `description` text NOT NULL,
  `art` varchar(10) binary NOT NULL default 'traffic',
  `menge` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`,`points`)
) TYPE=MyISAM AUTO_INCREMENT=6 AUTO_INCREMENT=6 ;

-- 
-- Daten für Tabelle `bonus`
-- 

INSERT INTO `bonus` VALUES (4, 0x313047422055706c6f6164, 500, '', 0x74726166666963, 10737418240);
INSERT INTO `bonus` VALUES (3, 0x3447422055706c6f6164, 300, '', 0x74726166666963, 4294967296);
INSERT INTO `bonus` VALUES (2, 0x3247422055706c6f6164, 150, '', 0x74726166666963, 2147483648);
INSERT INTO `bonus` VALUES (1, 0x3147422055706c6f6164, 100, '', 0x74726166666963, 1073741824);
INSERT INTO `bonus` VALUES (5, 0x3120496e76697465, 600, 0x57656e6e2064752064696573652050756e6b74657a61686c2065727265696368742068617374206b616e6e737420647520646965736520676567656e20496e76697465732065696e746175736368656e, 0x696e76697465, 1);

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

-- 
-- Tabellenstruktur für Tabelle `bookmarks`
-- 

CREATE TABLE `bookmarks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `torrentid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 AUTO_INCREMENT=13 ;

-- 
-- Daten für Tabelle `bookmarks`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `cards`
-- 

CREATE TABLE `cards` (
  `id` int(11) NOT NULL auto_increment,
  `points` int(11) NOT NULL default '0',
  `pic` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=53 AUTO_INCREMENT=53 ;

-- 
-- Daten für Tabelle `cards`
-- 

INSERT INTO `cards` VALUES (1, 2, '2p.bmp');
INSERT INTO `cards` VALUES (2, 3, '3p.bmp');
INSERT INTO `cards` VALUES (3, 4, '4p.bmp');
INSERT INTO `cards` VALUES (4, 5, '5p.bmp');
INSERT INTO `cards` VALUES (5, 6, '6p.bmp');
INSERT INTO `cards` VALUES (6, 7, '7p.bmp');
INSERT INTO `cards` VALUES (7, 8, '8p.bmp');
INSERT INTO `cards` VALUES (8, 9, '9p.bmp');
INSERT INTO `cards` VALUES (9, 10, '10p.bmp');
INSERT INTO `cards` VALUES (10, 10, 'vp.bmp');
INSERT INTO `cards` VALUES (11, 10, 'dp.bmp');
INSERT INTO `cards` VALUES (12, 10, 'kp.bmp');
INSERT INTO `cards` VALUES (13, 1, 'tp.bmp');
INSERT INTO `cards` VALUES (14, 2, '2b.bmp');
INSERT INTO `cards` VALUES (15, 3, '3b.bmp');
INSERT INTO `cards` VALUES (16, 4, '4b.bmp');
INSERT INTO `cards` VALUES (17, 5, '5b.bmp');
INSERT INTO `cards` VALUES (18, 6, '6b.bmp');
INSERT INTO `cards` VALUES (19, 7, '7b.bmp');
INSERT INTO `cards` VALUES (20, 8, '8b.bmp');
INSERT INTO `cards` VALUES (21, 9, '9b.bmp');
INSERT INTO `cards` VALUES (22, 10, '10b.bmp');
INSERT INTO `cards` VALUES (23, 10, 'vb.bmp');
INSERT INTO `cards` VALUES (24, 10, 'db.bmp');
INSERT INTO `cards` VALUES (25, 10, 'kb.bmp');
INSERT INTO `cards` VALUES (26, 1, 'tb.bmp');
INSERT INTO `cards` VALUES (27, 2, '2k.bmp');
INSERT INTO `cards` VALUES (28, 3, '3k.bmp');
INSERT INTO `cards` VALUES (29, 4, '4k.bmp');
INSERT INTO `cards` VALUES (30, 5, '5k.bmp');
INSERT INTO `cards` VALUES (31, 6, '6k.bmp');
INSERT INTO `cards` VALUES (32, 7, '7k.bmp');
INSERT INTO `cards` VALUES (33, 8, '8k.bmp');
INSERT INTO `cards` VALUES (34, 9, '9k.bmp');
INSERT INTO `cards` VALUES (35, 10, '10k.bmp');
INSERT INTO `cards` VALUES (36, 10, 'vk.bmp');
INSERT INTO `cards` VALUES (37, 10, 'dk.bmp');
INSERT INTO `cards` VALUES (38, 10, 'kk.bmp');
INSERT INTO `cards` VALUES (39, 1, 'tk.bmp');
INSERT INTO `cards` VALUES (40, 2, '2c.bmp');
INSERT INTO `cards` VALUES (41, 3, '3c.bmp');
INSERT INTO `cards` VALUES (42, 4, '4c.bmp');
INSERT INTO `cards` VALUES (43, 5, '5c.bmp');
INSERT INTO `cards` VALUES (44, 6, '6c.bmp');
INSERT INTO `cards` VALUES (45, 7, '7c.bmp');
INSERT INTO `cards` VALUES (46, 8, '8c.bmp');
INSERT INTO `cards` VALUES (47, 9, '9c.bmp');
INSERT INTO `cards` VALUES (48, 10, '10c.bmp');
INSERT INTO `cards` VALUES (49, 10, 'vc.bmp');
INSERT INTO `cards` VALUES (50, 10, 'dc.bmp');
INSERT INTO `cards` VALUES (51, 10, 'kc.bmp');
INSERT INTO `cards` VALUES (52, 1, 'tc.bmp');

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

-- 
-- Tabellenstruktur für Tabelle `casino`
-- 

CREATE TABLE `casino` (
  `userid` int(10) NOT NULL default '0',
  `win` bigint(20) default NULL,
  `lost` bigint(20) default NULL,
  `trys` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `enableplay` enum('yes','no') NOT NULL default 'yes',
  `deposit` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `casino`
-- 

INSERT INTO `casino` VALUES (3953, 0, 0, 0, '2008-06-13 23:36:01', 0x796573, 0);
INSERT INTO `casino` VALUES (3954, 0, 0, 0, '2008-06-15 15:08:06', 0x796573, 0);
INSERT INTO `casino` VALUES (3960, 0, 0, 0, '2008-06-15 20:14:19', 0x796573, 0);

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

-- 
-- Tabellenstruktur für Tabelle `casino_bank`
-- 

CREATE TABLE `casino_bank` (
  `userid` int(10) unsigned NOT NULL default '0',
  `passphrase` varchar(32) binary NOT NULL default '',
  `balance` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `casino_bank`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `casino_bet`
-- 

CREATE TABLE `casino_bet` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `number` int(10) unsigned NOT NULL default '0',
  `bet_date` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1059 AUTO_INCREMENT=1059 ;

-- 
-- Daten für Tabelle `casino_bet`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `casino_bets`
-- 

CREATE TABLE `casino_bets` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) NOT NULL default '0',
  `proposed` varchar(40) binary NOT NULL default '',
  `challenged` varchar(40) binary NOT NULL default '',
  `amount` bigint(20) NOT NULL default '0',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`,`proposed`,`challenged`,`amount`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `casino_bets`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `casino_config`
-- 

CREATE TABLE `casino_config` (
  `id` tinyint(1) unsigned NOT NULL default '0',
  `max_win_user` bigint(20) unsigned NOT NULL default '0',
  `max_win_all` bigint(20) unsigned NOT NULL default '0',
  `max_games_day` int(50) unsigned NOT NULL default '0',
  `bet_number` int(10) unsigned NOT NULL default '0',
  `bet_ammount` bigint(20) unsigned NOT NULL default '0',
  `min_ratio` double unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `casino_config`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `casino_stake`
-- 

CREATE TABLE `casino_stake` (
  `csid` smallint(3) unsigned NOT NULL auto_increment,
  `name` varchar(20) binary NOT NULL default '',
  `value` double unsigned NOT NULL default '0',
  PRIMARY KEY  (`csid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `casino_stake`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `casino_stat`
-- 

CREATE TABLE `casino_stat` (
  `cstid` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `type` tinyint(1) unsigned NOT NULL default '0',
  `lost` double unsigned default '0',
  `win` double unsigned default '0',
  `play_date` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cstid`),
  KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `casino_stat`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `categories`
-- 

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) binary NOT NULL default '',
  `image` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=52 AUTO_INCREMENT=52 ;

-- 
-- Daten für Tabelle `categories`
-- 

INSERT INTO `categories` VALUES (1, 0x57696e646f77732d4170707a, 0x6361745f61707073322e676966);
INSERT INTO `categories` VALUES (4, 0x47616d65732f5043, 0x47616d657350432e6a7067);
INSERT INTO `categories` VALUES (5, 0x4d6f766965732f53564344, 0x6361745f737663642e6a7067);
INSERT INTO `categories` VALUES (6, 0x4d7573696b, 0x6361745f6d757369632e6a7067);
INSERT INTO `categories` VALUES (7, 0x53657269656e, 0x74762e6a7067);
INSERT INTO `categories` VALUES (9, 0x536f6e737469676573, 0x6361745f6f746865722e6a7067);
INSERT INTO `categories` VALUES (12, 0x47616d65732f4e696e74656e646f, 0x6361745f67616d65735f6e696e74656e646f2e6a7067);
INSERT INTO `categories` VALUES (23, 0x416e696d65, 0x416e696d652e6a7067);
INSERT INTO `categories` VALUES (19, 0x4d6f766965732f44697658766944, 0x6361745f6d6f766965735f787669642e6a7067);
INSERT INTO `categories` VALUES (20, 0x4d6f766965732f4456442d52, 0x445644312e6a7067);
INSERT INTO `categories` VALUES (24, 0x48c3b672737069656c2f48c3b67262756368, 0x6361745f686f6572737069656c652e6a7067);
INSERT INTO `categories` VALUES (25, 0x54562d526970, 0x6361745f74767269702e6a7067);
INSERT INTO `categories` VALUES (26, 0x4d6f766965732f284d29564344, 0x6361745f7663642e6a7067);
INSERT INTO `categories` VALUES (28, 0x47616d65732058626f782f333630, 0x583336302e6a7067);
INSERT INTO `categories` VALUES (29, 0x47616d657320505320322f33, 0x6361745f67616d65737073322e6a7067);
INSERT INTO `categories` VALUES (30, 0x48442f426c752d526179, 0x48445456312e6a7067);
INSERT INTO `categories` VALUES (46, 0x446f6b756d656e746174696f6e, 0x6361745f646f63756d656e746174696f6e2e6a7067);
INSERT INTO `categories` VALUES (32, 0x4d6f766965732f532d445644, 0x534456442e6a7067);
INSERT INTO `categories` VALUES (47, 0x5757452d5765656b6c79, 0x7777652e6a7067);
INSERT INTO `categories` VALUES (48, 0x5757452d5050565c5c5c2773, 0x7777652e6a7067);
INSERT INTO `categories` VALUES (40, 0x416c6c65732066c3bc72204b696473, 0x4b6964732e6a7067);
INSERT INTO `categories` VALUES (41, 0x57616c6c706170657273, 0x57616c6c70617065722e6a7067);
INSERT INTO `categories` VALUES (42, 0x47616d65732f505350, 0x6361745f67616d65735f7073702e6a7067);
INSERT INTO `categories` VALUES (49, 0x585858, 0x6361745f7878782e676966);
INSERT INTO `categories` VALUES (50, 0x45626f6f6b, 0x45626f6f6b2e676966);
INSERT INTO `categories` VALUES (51, 0x48442d526970, 0x6864322e676966);

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

-- 
-- Tabellenstruktur für Tabelle `cheaters`
-- 

CREATE TABLE `cheaters` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `userid` int(10) NOT NULL default '0',
  `torrentid` int(10) NOT NULL default '0',
  `client` varchar(255) binary NOT NULL default '',
  `rate` varchar(255) binary NOT NULL default '',
  `beforeup` varchar(255) binary NOT NULL default '',
  `upthis` varchar(255) binary NOT NULL default '',
  `timediff` varchar(255) binary NOT NULL default '',
  `userip` varchar(15) binary NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `cheaters`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `comments`
-- 

CREATE TABLE `comments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` int(10) unsigned NOT NULL default '0',
  `torrent` int(10) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `text` text NOT NULL,
  `ori_text` text NOT NULL,
  `editedby` int(10) unsigned NOT NULL default '0',
  `editedat` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `user` (`user`),
  KEY `torrent` (`torrent`)
) TYPE=MyISAM AUTO_INCREMENT=4312 AUTO_INCREMENT=4312 ;

-- 
-- Daten für Tabelle `comments`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `community partner`
-- 

CREATE TABLE `community partner` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `titel` varchar(255) binary default NULL,
  `banner` varchar(255) binary default NULL,
  `link` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `community partner`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `completed`
-- 

CREATE TABLE `completed` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `torrent_id` int(11) NOT NULL default '0',
  `torrent_name` varchar(255) binary NOT NULL default '',
  `torrent_category` int(10) NOT NULL default '0',
  `complete_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7226 AUTO_INCREMENT=7226 ;

-- 
-- Daten für Tabelle `completed`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `countries`
-- 

CREATE TABLE `countries` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) binary default NULL,
  `flagpic` varchar(50) binary default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=106 AUTO_INCREMENT=106 ;

-- 
-- Daten für Tabelle `countries`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `data`
-- 

CREATE TABLE `data` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime default NULL,
  `title` varchar(255) binary NOT NULL default '',
  `filename` varchar(255) binary NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  `uppedby` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) binary NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=87 AUTO_INCREMENT=87 ;

-- 
-- Daten für Tabelle `data`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `days`
-- 

CREATE TABLE `days` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=32 AUTO_INCREMENT=32 ;

-- 
-- Daten für Tabelle `days`
-- 

INSERT INTO `days` VALUES (1, 0x3031);
INSERT INTO `days` VALUES (2, 0x3032);
INSERT INTO `days` VALUES (3, 0x3033);
INSERT INTO `days` VALUES (4, 0x3034);
INSERT INTO `days` VALUES (5, 0x3035);
INSERT INTO `days` VALUES (6, 0x3036);
INSERT INTO `days` VALUES (7, 0x3037);
INSERT INTO `days` VALUES (8, 0x3038);
INSERT INTO `days` VALUES (9, 0x3039);
INSERT INTO `days` VALUES (10, 0x3130);
INSERT INTO `days` VALUES (11, 0x3131);
INSERT INTO `days` VALUES (12, 0x3132);
INSERT INTO `days` VALUES (13, 0x3133);
INSERT INTO `days` VALUES (14, 0x3134);
INSERT INTO `days` VALUES (15, 0x3135);
INSERT INTO `days` VALUES (16, 0x3136);
INSERT INTO `days` VALUES (17, 0x3137);
INSERT INTO `days` VALUES (18, 0x3138);
INSERT INTO `days` VALUES (19, 0x3139);
INSERT INTO `days` VALUES (20, 0x3230);
INSERT INTO `days` VALUES (21, 0x3231);
INSERT INTO `days` VALUES (22, 0x3232);
INSERT INTO `days` VALUES (23, 0x3233);
INSERT INTO `days` VALUES (24, 0x3234);
INSERT INTO `days` VALUES (25, 0x3235);
INSERT INTO `days` VALUES (26, 0x3236);
INSERT INTO `days` VALUES (27, 0x3237);
INSERT INTO `days` VALUES (28, 0x3238);
INSERT INTO `days` VALUES (29, 0x3239);
INSERT INTO `days` VALUES (30, 0x3330);
INSERT INTO `days` VALUES (31, 0x3331);

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

-- 
-- Tabellenstruktur für Tabelle `deluxebits`
-- 

CREATE TABLE `deluxebits` (
  `torrentid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3679 AUTO_INCREMENT=3679 ;

-- 
-- Daten für Tabelle `deluxebits`
-- 

INSERT INTO `deluxebits` VALUES (4074, 3953, 3678);

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

-- 
-- Tabellenstruktur für Tabelle `donates`
-- 

CREATE TABLE `donates` (
  `did` int(11) unsigned NOT NULL auto_increment,
  `tid` varchar(100) binary NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `hmu` varchar(10) binary NOT NULL default '',
  `hm_up` int(2) NOT NULL default '0',
  `kw` varchar(20) binary NOT NULL default '',
  `hnr` varchar(50) binary NOT NULL default '',
  `hnetz` varchar(50) binary NOT NULL default '',
  `awp` varchar(50) binary NOT NULL default '',
  `dts` varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (`did`)
) TYPE=MyISAM AUTO_INCREMENT=3 PACK_KEYS=1 AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `donates`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `donation`
-- 

CREATE TABLE `donation` (
  `donations` int(5) unsigned NOT NULL default '0',
  `requireddonations` int(5) unsigned NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `donation`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `downtime`
-- 

CREATE TABLE `downtime` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) binary default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=26 AUTO_INCREMENT=26 ;

-- 
-- Daten für Tabelle `downtime`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `dox`
-- 

CREATE TABLE `dox` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime default NULL,
  `title` varchar(255) binary NOT NULL default '',
  `filename` varchar(255) binary NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  `uppedby` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) binary NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `dox`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `faq`
-- 

CREATE TABLE `faq` (
  `id` int(10) NOT NULL auto_increment,
  `type` set('categ','item') NOT NULL default 'item',
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `flag` set('0','1','2','3') NOT NULL default '1',
  `categ` int(10) NOT NULL default '0',
  `order` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `faq`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `files`
-- 

CREATE TABLE `files` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `torrent` int(10) unsigned NOT NULL default '0',
  `filename` varchar(255) binary NOT NULL default '',
  `size` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `torrent` (`torrent`)
) TYPE=MyISAM AUTO_INCREMENT=230583 AUTO_INCREMENT=230583 ;

-- 
-- Daten für Tabelle `files`
-- 

INSERT INTO `files` VALUES (230582, 4074, 0x696e7374616c6c5f666c6173685f706c617965722e657865, 1495112);

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

-- 
-- Tabellenstruktur für Tabelle `flashscores`
-- 

CREATE TABLE `flashscores` (
  `ID` int(11) NOT NULL auto_increment,
  `game` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=696 AUTO_INCREMENT=696 ;

-- 
-- Daten für Tabelle `flashscores`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `forums`
-- 

CREATE TABLE `forums` (
  `sort` tinyint(3) unsigned NOT NULL default '0',
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `description` varchar(200) default NULL,
  `minclassread` tinyint(3) unsigned NOT NULL default '0',
  `minclasswrite` tinyint(3) unsigned NOT NULL default '0',
  `postcount` int(10) unsigned NOT NULL default '0',
  `topiccount` int(10) unsigned NOT NULL default '0',
  `minclasscreate` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 AUTO_INCREMENT=19 ;

-- 
-- Daten für Tabelle `forums`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `friends`
-- 

CREATE TABLE `friends` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `friendid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userfriend` (`userid`,`friendid`)
) TYPE=MyISAM AUTO_INCREMENT=275 AUTO_INCREMENT=275 ;

-- 
-- Daten für Tabelle `friends`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `hightorrent`
-- 

CREATE TABLE `hightorrent` (
  `torrentid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=715 AUTO_INCREMENT=715 ;

-- 
-- Daten für Tabelle `hightorrent`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `home`
-- 

CREATE TABLE `home` (
  `id` tinyint(4) unsigned NOT NULL auto_increment,
  `text` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `text` (`text`)
) TYPE=MyISAM AUTO_INCREMENT=2 AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `home`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `hours`
-- 

CREATE TABLE `hours` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=26 AUTO_INCREMENT=26 ;

-- 
-- Daten für Tabelle `hours`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `indexrelases`
-- 

CREATE TABLE `indexrelases` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat` text NOT NULL,
  `poster` text NOT NULL,
  `name` text NOT NULL,
  `zanr` text NOT NULL,
  `reziser` text NOT NULL,
  `vroliah` text NOT NULL,
  `opisalovo` text NOT NULL,
  `kacestvo` text NOT NULL,
  `video` text NOT NULL,
  `audio` text NOT NULL,
  `time` text NOT NULL,
  `lang` text NOT NULL,
  `url` text NOT NULL,
  `imd` text NOT NULL,
  `added` datetime default NULL,
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=182 AUTO_INCREMENT=182 ;

-- 
-- Daten für Tabelle `indexrelases`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `invites`
-- 

CREATE TABLE `invites` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `inviter` int(10) unsigned NOT NULL default '0',
  `inviteid` int(10) unsigned NOT NULL default '0',
  `invite` varchar(32) binary NOT NULL default '',
  `time_invited` datetime NOT NULL default '0000-00-00 00:00:00',
  `confirmed` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  KEY `inviter` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 AUTO_INCREMENT=7 ;

-- 
-- Daten für Tabelle `invites`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `konto`
-- 

CREATE TABLE `konto` (
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `text` text NOT NULL,
  `amount` bigint(20) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `konto`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `loginattempts`
-- 

CREATE TABLE `loginattempts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ip` varchar(15) binary NOT NULL default '',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `banned` enum('yes','no') NOT NULL default 'no',
  `attempts` int(10) NOT NULL default '0',
  `type` enum('login','recover') NOT NULL default 'login',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `loginattempts`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `lottery_config`
-- 

CREATE TABLE `lottery_config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `lottery_config`
-- 

INSERT INTO `lottery_config` VALUES ('ticket_amount', '500');
INSERT INTO `lottery_config` VALUES ('ticket_amount_type', 'MB');
INSERT INTO `lottery_config` VALUES ('user_tickets', '10');
INSERT INTO `lottery_config` VALUES ('class_allowed', '0|1|4|5|10|15|25|26|51|52|100');
INSERT INTO `lottery_config` VALUES ('total_winners', '4');
INSERT INTO `lottery_config` VALUES ('prize_fund', '80000');
INSERT INTO `lottery_config` VALUES ('start_date', '2008-06-06 14:15:00');
INSERT INTO `lottery_config` VALUES ('end_date', '2008-06-21 20:00:00');
INSERT INTO `lottery_config` VALUES ('use_prize_fund', '1');
INSERT INTO `lottery_config` VALUES ('enable', '1');
INSERT INTO `lottery_config` VALUES ('lottery_winners', '3019|3027|3192');
INSERT INTO `lottery_config` VALUES ('lottery_winners_amount', '36350634666.667');
INSERT INTO `lottery_config` VALUES ('lottery_winners_time', '2008-06-06 13:11:31');

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

-- 
-- Tabellenstruktur für Tabelle `main_nlpas`
-- 

CREATE TABLE `main_nlpas` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `EMAIL` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `main_nlpas`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `messages`
-- 

CREATE TABLE `messages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sender` int(10) unsigned NOT NULL default '0',
  `receiver` int(10) unsigned NOT NULL default '0',
  `folder_in` int(10) NOT NULL default '0',
  `folder_out` int(10) NOT NULL default '0',
  `added` datetime default NULL,
  `subject` varchar(255) binary NOT NULL default '(Kein Betreff)',
  `msg` text,
  `unread` enum('yes','no') NOT NULL default 'yes',
  `poster` bigint(20) unsigned NOT NULL default '0',
  `mod_flag` enum('','open','closed') NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `receiver` (`receiver`)
) TYPE=MyISAM AUTO_INCREMENT=5445 AUTO_INCREMENT=5445 ;

-- 
-- Daten für Tabelle `messages`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `minutes`
-- 

CREATE TABLE `minutes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 AUTO_INCREMENT=13 ;

-- 
-- Daten für Tabelle `minutes`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `modapp`
-- 

CREATE TABLE `modapp` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `active` tinyint(1) NOT NULL default '1',
  `userid` int(10) NOT NULL default '0',
  `applied` datetime NOT NULL default '0000-00-00 00:00:00',
  `grpacct` tinyint(1) NOT NULL default '0',
  `grpname` varchar(100) binary NOT NULL default '',
  `grpdes` varchar(4) binary NOT NULL default '',
  `content` varchar(100) binary NOT NULL default '',
  `comment` varchar(100) binary NOT NULL default '',
  `seeding` tinyint(1) NOT NULL default '0',
  `othergrps` tinyint(1) NOT NULL default '0',
  `seedtime` varchar(100) binary NOT NULL default '',
  `votes` text NOT NULL,
  `comment1` varchar(100) binary NOT NULL default 'yes',
  `comment2` varchar(100) binary NOT NULL default 'yes',
  `modcomments` varchar(100) binary NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `users` (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=3 AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `modapp`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `modcomments`
-- 

CREATE TABLE `modcomments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `userid` int(10) unsigned NOT NULL default '0',
  `moduid` int(10) unsigned NOT NULL default '0',
  `txt` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5191 AUTO_INCREMENT=5191 ;

-- 
-- Daten für Tabelle `modcomments`
-- 

INSERT INTO `modcomments` VALUES (5169, '2008-06-14 00:02:10', 3954, 3953, 0x426566c3b672646572756e67207a756d20275379734f70272e);
INSERT INTO `modcomments` VALUES (5170, '2008-06-14 02:22:54', 3956, 3954, 0x426566c3b672646572756e67207a756d2027506f7765722055736572272e);
INSERT INTO `modcomments` VALUES (5171, '2008-06-14 02:23:51', 3956, 3954, 0x426566c3b672646572756e67207a756d202765587472656d652055736572272e);
INSERT INTO `modcomments` VALUES (5172, '2008-06-14 02:25:03', 3956, 3954, 0x426566c3b672646572756e67207a756d2027564950272e);
INSERT INTO `modcomments` VALUES (5173, '2008-06-14 02:26:02', 3956, 3954, 0x426566c3b672646572756e67207a756d2027506172746e657220564950272e);
INSERT INTO `modcomments` VALUES (5174, '2008-06-14 02:27:01', 3956, 3954, 0x426566c3b672646572756e67207a756d202755706c6f61646572272e);
INSERT INTO `modcomments` VALUES (5175, '2008-06-14 02:28:45', 3956, 3954, 0x426566c3b672646572756e67207a756d20274d6f64657261746f72272e);
INSERT INTO `modcomments` VALUES (5176, '2008-06-14 02:30:14', 3956, 3954, 0x426566c3b672646572756e67207a756d2027434f2041646d696e272e);
INSERT INTO `modcomments` VALUES (5177, '2008-06-14 02:31:46', 3956, 3954, 0x426566c3b672646572756e67207a756d202741646d696e6973747261746f72272e);
INSERT INTO `modcomments` VALUES (5178, '2008-06-14 02:32:51', 3956, 3954, 0x426566c3b672646572756e67207a756d2027205465616d6c656974756e67272e);
INSERT INTO `modcomments` VALUES (5179, '2008-06-14 19:18:54', 3953, 3953, 0x4163636f756e742067657061726b74);
INSERT INTO `modcomments` VALUES (5183, '2008-06-15 19:36:03', 3957, 3957, 0x546f7272656e7462656772656e7a756e67206765c3a46e646572743a2030204c6565636865732c20302053656564732c202d3120476573616d74);
INSERT INTO `modcomments` VALUES (5182, '2008-06-15 19:01:11', 3957, 3953, 0x426566c3b672646572756e67207a756d20275379734f70272e);
INSERT INTO `modcomments` VALUES (5184, '2008-06-15 19:36:03', 3957, 3957, 0x557365726e616d65206765c3a46e64657274206175662027542e4e2e54272e);
INSERT INTO `modcomments` VALUES (5188, '2008-06-15 21:44:43', 3960, 3957, 0x546f7272656e7462656772656e7a756e67206765c3a46e646572743a2030204c6565636865732c20302053656564732c202d3120476573616d74);
INSERT INTO `modcomments` VALUES (5186, '2008-06-15 19:37:22', 3957, 3957, 0x546974656c206765c3a46e646572742061756620274963682053656820416c6c657321272e);
INSERT INTO `modcomments` VALUES (5189, '2008-06-15 21:44:43', 3960, 3957, 0x426566c3b672646572756e67207a756d20275379734f70272e);
INSERT INTO `modcomments` VALUES (5190, '2008-06-16 13:12:43', 3955, 3953, 0x426566c3b672646572756e67207a756d20275379734f70272e);

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

-- 
-- Tabellenstruktur für Tabelle `months`
-- 

CREATE TABLE `months` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 AUTO_INCREMENT=13 ;

-- 
-- Daten für Tabelle `months`
-- 

INSERT INTO `months` VALUES (1, 0x4a616e756172);
INSERT INTO `months` VALUES (2, 0x46656272756172);
INSERT INTO `months` VALUES (3, 0x4dc3a4727a);
INSERT INTO `months` VALUES (4, 0x417072696c);
INSERT INTO `months` VALUES (5, 0x4d6169);
INSERT INTO `months` VALUES (6, 0x4a756e69);
INSERT INTO `months` VALUES (7, 0x4a756c69);
INSERT INTO `months` VALUES (8, 0x417567757374);
INSERT INTO `months` VALUES (9, 0x53657074656d626572);
INSERT INTO `months` VALUES (10, 0x4f6b746f626572);
INSERT INTO `months` VALUES (11, 0x4e6f76656d626572);
INSERT INTO `months` VALUES (12, 0x44657a656d626572);

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

-- 
-- Tabellenstruktur für Tabelle `movie`
-- 

CREATE TABLE `movie` (
  `id` int(11) NOT NULL auto_increment,
  `filename` varchar(100) binary NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `movie`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `news`
-- 

CREATE TABLE `news` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(255) binary NOT NULL default '',
  `body` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `added` (`added`)
) TYPE=MyISAM AUTO_INCREMENT=30 AUTO_INCREMENT=30 ;

-- 
-- Daten für Tabelle `news`
-- 

INSERT INTO `news` VALUES (28, 3953, '2008-06-13 23:25:46', 0x74657374, 0x5b636f6c6f723d7265645d0d0a4461207769722065696e20416e7469204c6565636820547261636b65722073696e642c2068616c746574206575636820626974746520616e2064696520526567656c6e2e0d0a496e666f726d6174696f6e656e20676962742065732072656963686c69636820696e2064656e20526567656c6e20756e6420646572204641512e0d0a5769722062697474656e20657563682c206665727469676520546f7272656e747320776569746572207a752073656564656e21210d0a0d0a41622065696e657220476573616d74726174696f20766f6e20302e38302077657264657420496872207665727761726e7420210d0a41622065696e657220476573616d74726174696f20766f6e20302e37352077657264656e20457563682064696520446f776e6c6f61647265636874652067656e6f6d6d656e2021210d0a4665686c76657268616c74656e207769726420696d2065787472656d2046616c6c206d69742065696e656d2042616e6e0d0a0d0a62657374726166742e0d0a0d0a0d0a416e736f6e7374656e2077c3bc6e7363687420657563682064617320205465616d2065696e6520736368c3b66e6520756e6420616e67656e65686d65205a65697420686965722e0d0a0d0a4c696e6b7320206bc3b66e6e7420696872207363686175656e2077656c63686520436c69656e74732065726c617562742020756e642077656c63686520766572626f74656e2073696e642021210d0a0d0a0d0a0d0a2e2e3a3a57656273656564657220756e64204144534c322055736572206269747465206265696d205465616d206d656c64656e3a3a2e2e5b2f636f6c6f725d);
INSERT INTO `news` VALUES (29, 3957, '2008-06-15 19:22:23', 0x57696c6c6b6f6d6d656e, 0x5b63656e7465725d5b494d475d687474703a2f2f693235352e70686f746f6275636b65742e636f6d2f616c62756d732f68683133342f647261676f6e6865617274352f3635313137316930383570386d7933692e6769665b2f494d475d5b2f63656e7465725d);

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

-- 
-- Tabellenstruktur für Tabelle `newsletter`
-- 

CREATE TABLE `newsletter` (
  `id` int(6) NOT NULL auto_increment,
  `EMail` char(45) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 AUTO_INCREMENT=18 ;

-- 
-- Daten für Tabelle `newsletter`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `notconnectablepmlog`
-- 

CREATE TABLE `notconnectablepmlog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` int(10) unsigned NOT NULL default '0',
  `date` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 AUTO_INCREMENT=9 ;

-- 
-- Daten für Tabelle `notconnectablepmlog`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `nowait`
-- 

CREATE TABLE `nowait` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `torrent_id` int(10) unsigned NOT NULL default '0',
  `status` enum('pending','granted','rejected') NOT NULL default 'pending',
  `grantor` int(10) NOT NULL default '0',
  `msg` text NOT NULL
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `nowait`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `oldtraffic`
-- 

CREATE TABLE `oldtraffic` (
  `userid` int(11) unsigned NOT NULL default '0',
  `torrentid` int(11) unsigned NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `downloadtime` int(11) unsigned NOT NULL default '0',
  `uploadtime` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`torrentid`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `oldtraffic`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `onlinezeiten`
-- 

CREATE TABLE `onlinezeiten` (
  `uid` int(10) unsigned NOT NULL default '0',
  `std` tinyint(2) unsigned NOT NULL default '0',
  `cnt` bigint(15) unsigned NOT NULL default '1',
  UNIQUE KEY `uid` (`uid`,`std`),
  KEY `uid_2` (`uid`),
  KEY `std` (`std`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `onlinezeiten`
-- 

INSERT INTO `onlinezeiten` VALUES (3953, 12, 3);
INSERT INTO `onlinezeiten` VALUES (3953, 20, 1);

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

-- 
-- Tabellenstruktur für Tabelle `outime`
-- 

CREATE TABLE `outime` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) binary NOT NULL default '',
  `datum` date NOT NULL default '0000-00-00',
  `outage` tinyint(2) unsigned NOT NULL default '0',
  `aktiv` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `outime`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `partner`
-- 

CREATE TABLE `partner` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `titel` varchar(255) binary default NULL,
  `banner` varchar(255) binary default NULL,
  `link` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=80 AUTO_INCREMENT=80 ;

-- 
-- Daten für Tabelle `partner`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `partnernews`
-- 

CREATE TABLE `partnernews` (
  `id` bigint(255) NOT NULL auto_increment,
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `von` varchar(255) NOT NULL default '',
  `titel` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `tracker` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 AUTO_INCREMENT=18 ;

-- 
-- Daten für Tabelle `partnernews`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `peers`
-- 

CREATE TABLE `peers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `torrent` int(10) unsigned NOT NULL default '0',
  `peer_id` varchar(20) binary NOT NULL default '',
  `ip` varchar(64) binary NOT NULL default '',
  `port` smallint(5) unsigned NOT NULL default '0',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `to_go` bigint(20) unsigned NOT NULL default '0',
  `seeder` enum('yes','no') NOT NULL default 'no',
  `started` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `connectable` enum('yes','no') NOT NULL default 'yes',
  `userid` int(10) unsigned NOT NULL default '0',
  `agent` varchar(60) binary NOT NULL default '',
  `finishedat` int(10) unsigned NOT NULL default '0',
  `downloadoffset` bigint(20) unsigned NOT NULL default '0',
  `uploadoffset` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),
  KEY `torrent` (`torrent`),
  KEY `torrent_seeder` (`torrent`,`seeder`),
  KEY `last_action` (`last_action`),
  KEY `connectable` (`connectable`),
  KEY `userid` (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=113885 AUTO_INCREMENT=113885 ;

-- 
-- Daten für Tabelle `peers`
-- 

INSERT INTO `peers` VALUES (113884, 4074, 0x2d5554313530302dc2b5c28124c3a5142231c3b9680341c2aa, 0x38352e3137382e38312e3539, 32459, 0, 0, 0, 0x796573, '2008-06-17 18:35:33', '2008-06-17 19:35:39', 0x6e6f, 3953, 0x75546f7272656e742f31353030, 0, 0, 0);

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

-- 
-- Tabellenstruktur für Tabelle `pmfolders`
-- 

CREATE TABLE `pmfolders` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parent` int(10) unsigned NOT NULL default '0',
  `owner` int(10) unsigned NOT NULL default '0',
  `name` varchar(128) binary NOT NULL default '',
  `sortfield` varchar(64) binary NOT NULL default 'added',
  `sortorder` varchar(4) binary NOT NULL default 'DESC',
  `prunedays` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1972 AUTO_INCREMENT=1972 ;

-- 
-- Daten für Tabelle `pmfolders`
-- 

INSERT INTO `pmfolders` VALUES (1942, 0, 3953, 0x5f5f696e626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1943, 0, 3953, 0x5f5f6f7574626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1944, 0, 3953, 0x5f5f73797374656d, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1945, 0, 3953, 0x5f5f6d6f64, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1946, 0, 3953, 0x5f5f626c61636b6a61636b, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1947, 0, 3954, 0x5f5f696e626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1948, 0, 3954, 0x5f5f6f7574626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1949, 0, 3954, 0x5f5f73797374656d, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1950, 0, 3954, 0x5f5f6d6f64, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1951, 0, 3954, 0x5f5f626c61636b6a61636b, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1952, 0, 3956, 0x5f5f696e626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1953, 0, 3956, 0x5f5f6f7574626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1954, 0, 3956, 0x5f5f73797374656d, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1955, 0, 3956, 0x5f5f6d6f64, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1956, 0, 3956, 0x5f5f626c61636b6a61636b, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1957, 0, 3955, 0x5f5f696e626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1958, 0, 3955, 0x5f5f6f7574626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1959, 0, 3955, 0x5f5f73797374656d, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1960, 0, 3955, 0x5f5f6d6f64, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1961, 0, 3955, 0x5f5f626c61636b6a61636b, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1962, 0, 3957, 0x5f5f696e626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1963, 0, 3957, 0x5f5f6f7574626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1964, 0, 3957, 0x5f5f73797374656d, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1965, 0, 3957, 0x5f5f6d6f64, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1966, 0, 3957, 0x5f5f626c61636b6a61636b, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1967, 0, 3960, 0x5f5f696e626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1968, 0, 3960, 0x5f5f6f7574626f78, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1969, 0, 3960, 0x5f5f73797374656d, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1970, 0, 3960, 0x5f5f6d6f64, 0x6164646564, 0x44455343, 0);
INSERT INTO `pmfolders` VALUES (1971, 0, 3960, 0x5f5f626c61636b6a61636b, 0x6164646564, 0x44455343, 0);

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

-- 
-- Tabellenstruktur für Tabelle `pollanswers`
-- 

CREATE TABLE `pollanswers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pollid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `selection` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`pollid`),
  KEY `selection` (`selection`),
  KEY `userid` (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=462 AUTO_INCREMENT=462 ;

-- 
-- Daten für Tabelle `pollanswers`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `polls`
-- 

CREATE TABLE `polls` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `question` varchar(255) binary NOT NULL default '',
  `option0` varchar(150) binary NOT NULL default '',
  `option1` varchar(150) binary NOT NULL default '',
  `option2` varchar(150) binary NOT NULL default '',
  `option3` varchar(150) binary NOT NULL default '',
  `option4` varchar(150) binary NOT NULL default '',
  `option5` varchar(150) binary NOT NULL default '',
  `option6` varchar(150) binary NOT NULL default '',
  `option7` varchar(150) binary NOT NULL default '',
  `option8` varchar(150) binary NOT NULL default '',
  `option9` varchar(150) binary NOT NULL default '',
  `option10` varchar(150) binary NOT NULL default '',
  `option11` varchar(150) binary NOT NULL default '',
  `option12` varchar(150) binary NOT NULL default '',
  `option13` varchar(150) binary NOT NULL default '',
  `option14` varchar(150) binary NOT NULL default '',
  `option15` varchar(150) binary NOT NULL default '',
  `option16` varchar(150) binary NOT NULL default '',
  `option17` varchar(150) binary NOT NULL default '',
  `option18` varchar(150) binary NOT NULL default '',
  `option19` varchar(150) binary NOT NULL default '',
  `sort` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 AUTO_INCREMENT=19 ;

-- 
-- Daten für Tabelle `polls`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `posts`
-- 

CREATE TABLE `posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `topicid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `added` datetime default NULL,
  `body` text,
  `editedby` int(10) unsigned NOT NULL default '0',
  `editedat` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `topicid` (`topicid`),
  KEY `userid` (`userid`),
  FULLTEXT KEY `body` (`body`)
) TYPE=MyISAM AUTO_INCREMENT=10 AUTO_INCREMENT=10 ;

-- 
-- Daten für Tabelle `posts`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `pruefe`
-- 

CREATE TABLE `pruefe` (
  `pruefe` int(10) NOT NULL default '0',
  `email` char(45) default NULL,
  PRIMARY KEY  (`pruefe`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `pruefe`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `ratings`
-- 

CREATE TABLE `ratings` (
  `torrent` int(10) unsigned NOT NULL default '0',
  `user` int(10) unsigned NOT NULL default '0',
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`torrent`,`user`),
  KEY `user` (`user`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `ratings`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `ratiostats`
-- 

CREATE TABLE `ratiostats` (
  `userid` int(10) unsigned NOT NULL default '0',
  `timecode` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` enum('daily','hourly') NOT NULL default 'hourly',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`timecode`,`type`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `ratiostats`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `readposts`
-- 

CREATE TABLE `readposts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `topicid` int(10) unsigned NOT NULL default '0',
  `lastpostread` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`id`),
  KEY `topicid` (`topicid`)
) TYPE=MyISAM AUTO_INCREMENT=66 AUTO_INCREMENT=66 ;

-- 
-- Daten für Tabelle `readposts`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `report`
-- 

CREATE TABLE `report` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `reporter` int(10) NOT NULL default '0',
  `reason` text NOT NULL,
  `reportid` int(10) NOT NULL default '0',
  `typ` varchar(20) binary default NULL,
  `tid` varchar(20) binary default NULL,
  `behandla` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `report`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `reports`
-- 

CREATE TABLE `reports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `addedby` int(10) unsigned NOT NULL default '0',
  `votedfor` int(10) unsigned NOT NULL default '0',
  `votedfor_xtra` int(10) unsigned NOT NULL default '0',
  `type` enum('torrent','user','forum','tc_comment') NOT NULL default 'torrent',
  `reason` varchar(255) binary NOT NULL default '',
  `dealtby` int(10) unsigned NOT NULL default '0',
  `dealtwith` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `reports`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `requests`
-- 

CREATE TABLE `requests` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` int(10) unsigned NOT NULL default '0',
  `kategorie` int(10) unsigned NOT NULL default '0',
  `titel` varchar(250) binary NOT NULL default '',
  `info` text NOT NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `closed` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=132 AUTO_INCREMENT=132 ;

-- 
-- Daten für Tabelle `requests`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `requests2`
-- 

CREATE TABLE `requests2` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` int(10) unsigned NOT NULL default '0',
  `kategorie` int(10) unsigned NOT NULL default '0',
  `titel` varchar(250) binary NOT NULL default '',
  `info` text NOT NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `closed` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=34 AUTO_INCREMENT=34 ;

-- 
-- Daten für Tabelle `requests2`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `reseed`
-- 

CREATE TABLE `reseed` (
  `torrentid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=147 AUTO_INCREMENT=147 ;

-- 
-- Daten für Tabelle `reseed`
-- 

INSERT INTO `reseed` VALUES (4074, 3953, 146);

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

-- 
-- Tabellenstruktur für Tabelle `rules`
-- 

CREATE TABLE `rules` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `public` enum('yes','no') NOT NULL default 'yes',
  `class` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;

-- 
-- Daten für Tabelle `rules`
-- 

INSERT INTO `rules` VALUES (1, 'Test', 'Hier Text rein', 'yes', 0);

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

-- 
-- Tabellenstruktur für Tabelle `saugstube`
-- 

CREATE TABLE `saugstube` (
  `torrentid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3982 AUTO_INCREMENT=3982 ;

-- 
-- Daten für Tabelle `saugstube`
-- 

INSERT INTO `saugstube` VALUES (4074, 3953, 3981);

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

-- 
-- Tabellenstruktur für Tabelle `schongewusst`
-- 

CREATE TABLE `schongewusst` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `text` varchar(255) binary default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=47 AUTO_INCREMENT=47 ;

-- 
-- Daten für Tabelle `schongewusst`
-- 

INSERT INTO `schongewusst` VALUES (46, 0x446173205765627365656465722073696368204269747465206265696d205465616d204d656c64656e204dc3b6636874656e);

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

-- 
-- Tabellenstruktur für Tabelle `sendeplan`
-- 

CREATE TABLE `sendeplan` (
  `day` varchar(10) binary NOT NULL default '',
  `time` varchar(5) binary NOT NULL default '',
  `mod` varchar(15) binary NOT NULL default '',
  `genre` varchar(50) binary NOT NULL default ''
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `sendeplan`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `shitlist`
-- 

CREATE TABLE `shitlist` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ime` varchar(255) binary NOT NULL default '',
  `usrid` varchar(255) binary NOT NULL default '',
  `email` varchar(255) binary NOT NULL default '',
  `komentar` varchar(255) binary NOT NULL default '',
  `dodan` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 AUTO_INCREMENT=14 ;

-- 
-- Daten für Tabelle `shitlist`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `shoutbox`
-- 

CREATE TABLE `shoutbox` (
  `id` smallint(6) NOT NULL auto_increment,
  `userid` smallint(6) NOT NULL default '0',
  `username` varchar(25) binary NOT NULL default '',
  `date` int(11) NOT NULL default '0',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `shoutbox`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `shoutbox_censor`
-- 

CREATE TABLE `shoutbox_censor` (
  `word` varchar(10) binary default '0',
  KEY `word` (`word`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `shoutbox_censor`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `shoutbox_emoticons`
-- 

CREATE TABLE `shoutbox_emoticons` (
  `id` int(9) NOT NULL auto_increment,
  `text` varchar(20) binary NOT NULL default '',
  `image` varchar(50) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `shoutbox_emoticons`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `sitelog`
-- 

CREATE TABLE `sitelog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `typ` enum('torrentupload','torrentedit','torrentdelete','promotion','demotion','addwarn','remwarn','accenabled','accdisabled','accdeleted','waitgrant','waitreject','passkeyreset','torrentgranted') NOT NULL default 'torrentupload',
  `added` datetime default NULL,
  `txt` text,
  PRIMARY KEY  (`id`),
  KEY `added` (`added`)
) TYPE=MyISAM AUTO_INCREMENT=1064 AUTO_INCREMENT=1064 ;

-- 
-- Daten für Tabelle `sitelog`
-- 

INSERT INTO `sitelog` VALUES (1037, 0x746f7272656e7475706c6f6164, '2008-06-13 11:09:57', 0x44657220546f7272656e74203c6120687265663d2264657461696c732e7068703f69643d34303733223e34303733202874657374293c2f613e20777572646520766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393533223e646a62726f636b656e3c2f613e2720686f636867656c6164656e2e);
INSERT INTO `sitelog` VALUES (1038, 0x746f7272656e7465646974, '2008-06-13 11:11:24', 0x44657220546f7272656e74203c6120687265663d2264657461696c732e7068703f69643d34303733223e34303733202874657374293c2f613e20777572646520766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393533223e646a62726f636b656e3c2f613e2720626561726265697465742e);
INSERT INTO `sitelog` VALUES (1039, 0x70726f6d6f74696f6e, '2008-06-14 00:02:09', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393534223e466c6f72693c2f613e2720777572646520766f6e20646a62726f636b656e207a756d205379734f7020626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1040, '', '2008-06-14 01:29:01', '');
INSERT INTO `sitelog` VALUES (1041, 0x70726f6d6f74696f6e, '2008-06-14 02:22:53', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d20506f776572205573657220626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1042, 0x70726f6d6f74696f6e, '2008-06-14 02:23:50', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d2065587472656d65205573657220626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1043, 0x70726f6d6f74696f6e, '2008-06-14 02:25:03', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d2056495020626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1044, 0x70726f6d6f74696f6e, '2008-06-14 02:26:02', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d20506172746e65722056495020626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1045, 0x70726f6d6f74696f6e, '2008-06-14 02:27:01', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d2055706c6f6164657220626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1046, 0x70726f6d6f74696f6e, '2008-06-14 02:28:45', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d204d6f64657261746f7220626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1047, 0x70726f6d6f74696f6e, '2008-06-14 02:30:14', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d20434f2041646d696e20626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1048, 0x70726f6d6f74696f6e, '2008-06-14 02:31:46', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d2041646d696e6973747261746f7220626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1049, 0x70726f6d6f74696f6e, '2008-06-14 02:32:51', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393536223e54657374323c2f613e2720777572646520766f6e20466c6f7269207a756d20205465616d6c656974756e6720626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1050, '', '2008-06-14 03:26:02', '');
INSERT INTO `sitelog` VALUES (1051, '', '2008-06-14 19:18:54', 0x4163636f756e742066c3bc722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393533223e646a62726f636b656e3c2f613e2720777572646520766f6e20646a62726f636b656e2067657061726b74);
INSERT INTO `sitelog` VALUES (1052, 0x746f7272656e7464656c657465, '2008-06-14 22:53:23', 0x44657220546f7272656e7420343037332028746573742920777572646520766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393533223e646a62726f636b656e3c2f613e272067656cc3b6736368742028546f743a2030205365656465722c2030204c656563686572203d203020506565727320676573616d74290a);
INSERT INTO `sitelog` VALUES (1053, 0x746f7272656e7475706c6f6164, '2008-06-14 22:54:59', 0x44657220546f7272656e74203c6120687265663d2264657461696c732e7068703f69643d34303734223e343037342028696e7374616c6c2e666c6173682e706c617965722e657865293c2f613e20777572646520766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393533223e646a62726f636b656e3c2f613e2720686f636867656c6164656e2e);
INSERT INTO `sitelog` VALUES (1054, 0x746f7272656e7465646974, '2008-06-14 23:12:01', 0x44657220546f7272656e74203c6120687265663d2264657461696c732e7068703f69643d34303734223e343037342028696e7374616c6c2e666c6173682e706c617965722e657865293c2f613e20777572646520766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393533223e646a62726f636b656e3c2f613e2720626561726265697465742e);
INSERT INTO `sitelog` VALUES (1055, 0x746f7272656e7465646974, '2008-06-14 23:12:28', 0x44657220546f7272656e74203c6120687265663d2264657461696c732e7068703f69643d34303734223e343037342028696e7374616c6c2e666c6173682e706c617965722e657865293c2f613e20777572646520766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393533223e646a62726f636b656e3c2f613e2720626561726265697465742e);
INSERT INTO `sitelog` VALUES (1056, 0x70726f6d6f74696f6e, '2008-06-15 19:01:11', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393537223e544e543c2f613e2720777572646520766f6e20646a62726f636b656e207a756d205379734f7020626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1057, '', '2008-06-15 19:13:26', 0x4b617465676f726965205757452d50505627732f7777652e6a7067207775726465206765c3a46e64657274203d3d3e20275757452d5050565c5c5c2773272f277777652e6a7067272020766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393537223e544e543c2f613e27);
INSERT INTO `sitelog` VALUES (1058, '', '2008-06-15 19:13:26', 0x4b617465676f7269652057726573746c696e672d4456442f587669442f7777652e6a7067207775726465206765c3a46e64657274203d3d3e2027585858272f276361745f7878782e676966272020766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393537223e544e543c2f613e27);
INSERT INTO `sitelog` VALUES (1059, '', '2008-06-15 19:13:59', 0x4b617465676f7269652057696e646f77732d4170707a2f4170707a2e6a7067207775726465206765c3a46e64657274203d3d3e202757696e646f77732d4170707a272f276361745f61707073322e676966272020766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393537223e544e543c2f613e27);
INSERT INTO `sitelog` VALUES (1060, '', '2008-06-15 19:13:59', 0x4b617465676f726965205757452d5050565c27732f7777652e6a7067207775726465206765c3a46e64657274203d3d3e20275757452d5050565c5c5c5c5c5c5c2773272f277777652e6a7067272020766f6e20273c6120687265663d227573657264657461696c732e7068703f69643d33393537223e544e543c2f613e27);
INSERT INTO `sitelog` VALUES (1061, 0x70726f6d6f74696f6e, '2008-06-15 21:44:43', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393630223e4b697474793c2f613e2720777572646520766f6e20542e4e2e54207a756d205379734f7020626566c3b672646572742e);
INSERT INTO `sitelog` VALUES (1062, '', '2008-06-16 12:57:32', '');
INSERT INTO `sitelog` VALUES (1063, 0x70726f6d6f74696f6e, '2008-06-16 13:12:43', 0x4465722042656e75747a657220273c6120687265663d227573657264657461696c732e7068703f69643d33393535223e746573743c2f613e2720777572646520766f6e20646a62726f636b656e207a756d205379734f7020626566c3b672646572742e);

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

-- 
-- Tabellenstruktur für Tabelle `sluser`
-- 

CREATE TABLE `sluser` (
  `id` bigint(20) NOT NULL auto_increment,
  `modid` int(11) NOT NULL default '0',
  `sluserid` int(11) NOT NULL default '0',
  `pntime` varchar(255) binary NOT NULL default '',
  `torrentid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=822 PACK_KEYS=0 AUTO_INCREMENT=822 ;

-- 
-- Daten für Tabelle `sluser`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `snatched`
-- 

CREATE TABLE `snatched` (
  `id` int(11) NOT NULL auto_increment,
  `torrentid` int(11) default '0',
  `userid` int(11) default '0',
  `torrent` int(10) unsigned NOT NULL default '0',
  `torrent_name` varchar(255) binary NOT NULL default '',
  `torrent_category` int(10) unsigned NOT NULL default '0',
  `port` smallint(5) unsigned NOT NULL default '0',
  `ruploaded` bigint(20) unsigned NOT NULL default '0',
  `rdownloaded` bigint(20) unsigned NOT NULL default '0',
  `to_go` bigint(20) unsigned NOT NULL default '0',
  `seeder` enum('yes','no') NOT NULL default 'no',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `startdat` datetime NOT NULL default '0000-00-00 00:00:00',
  `completedat` datetime NOT NULL default '0000-00-00 00:00:00',
  `connectable` enum('yes','no') NOT NULL default 'yes',
  `agent` varchar(60) binary NOT NULL default '',
  `finished` enum('yes','no') NOT NULL default 'no',
  `takeuser` varchar(255) binary NOT NULL default '0',
  `takeit` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7226 PACK_KEYS=0 AUTO_INCREMENT=7226 ;

-- 
-- Daten für Tabelle `snatched`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `sponsor`
-- 

CREATE TABLE `sponsor` (
  `id2` int(10) unsigned NOT NULL auto_increment,
  `titel2` varchar(255) binary default NULL,
  `banner2` varchar(255) binary default NULL,
  `link2` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id2`)
) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;

-- 
-- Daten für Tabelle `sponsor`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `staffmessages`
-- 

CREATE TABLE `staffmessages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sender` int(10) unsigned NOT NULL default '0',
  `added` datetime default NULL,
  `msg` text,
  `subject` varchar(100) binary NOT NULL default '',
  `answeredby` int(10) unsigned NOT NULL default '0',
  `answered` tinyint(1) NOT NULL default '0',
  `answer` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=32 AUTO_INCREMENT=32 ;

-- 
-- Daten für Tabelle `staffmessages`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `startstoplog`
-- 

CREATE TABLE `startstoplog` (
  `userid` int(10) NOT NULL default '0',
  `event` enum('start','stop') NOT NULL default 'start',
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `torrent` int(10) NOT NULL default '0',
  `ip` varchar(15) binary NOT NULL default '',
  `peerid` varchar(20) binary NOT NULL default '',
  `useragent` varchar(255) binary NOT NULL default ''
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `startstoplog`
-- 

INSERT INTO `startstoplog` VALUES (3953, 0x7374617274, '2008-06-16 12:55:40', 4074, 0x38352e3137382e39302e313938, 0x2d5554313530302dc2b5c28145585ac2b36b576fc2be7cc387, 0x75546f7272656e742f31353030);
INSERT INTO `startstoplog` VALUES (3953, 0x73746f70, '2008-06-16 12:55:52', 4074, 0x38352e3137382e39302e313938, 0x2d5554313530302dc2b5c28145585ac2b36b576fc2be7cc387, 0x75546f7272656e742f31353030);
INSERT INTO `startstoplog` VALUES (3953, 0x7374617274, '2008-06-16 12:55:56', 4074, 0x38352e3137382e39302e313938, 0x2d5554313530302dc2b5c28145585ac2b36b576fc2be7cc387, 0x75546f7272656e742f31353030);
INSERT INTO `startstoplog` VALUES (3953, 0x73746f70, '2008-06-16 13:11:41', 4074, 0x38352e3137382e39302e313938, 0x2d5554313530302dc2b5c28145585ac2b36b576fc2be7cc387, 0x75546f7272656e742f31353030);
INSERT INTO `startstoplog` VALUES (3953, 0x7374617274, '2008-06-16 13:12:07', 4074, 0x38352e3137382e39302e313938, 0x2d5554313530302dc2b5c2810f4f2d4dc38355c3b776c394cb9c, 0x75546f7272656e742f31353030);
INSERT INTO `startstoplog` VALUES (3953, 0x73746f70, '2008-06-16 14:00:28', 4074, 0x38352e3137382e39302e313938, 0x2d5554313530302dc2b5c2810f4f2d4dc38355c3b776c394cb9c, 0x75546f7272656e742f31353030);
INSERT INTO `startstoplog` VALUES (3953, 0x7374617274, '2008-06-17 18:35:33', 4074, 0x38352e3137382e38312e3539, 0x2d5554313530302dc2b5c28124c3a5142231c3b9680341c2aa, 0x75546f7272656e742f31353030);

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

-- 
-- Tabellenstruktur für Tabelle `stats`
-- 

CREATE TABLE `stats` (
  `recordonline24` varchar(255) binary NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `stats`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `stream`
-- 

CREATE TABLE `stream` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `streamer` text NOT NULL,
  `descr` text NOT NULL,
  `addedby` int(10) unsigned NOT NULL default '0',
  `streamnr` varchar(10) binary default '1',
  `tage` int(10) unsigned NOT NULL default '0',
  `days` int(10) unsigned NOT NULL default '0',
  `months` int(10) unsigned NOT NULL default '0',
  `years` int(10) unsigned NOT NULL default '0',
  `hours` int(10) unsigned NOT NULL default '0',
  `minutes` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 AUTO_INCREMENT=8 ;

-- 
-- Daten für Tabelle `stream`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `stylesheets`
-- 

CREATE TABLE `stylesheets` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uri` varchar(255) NOT NULL default '',
  `name` varchar(64) NOT NULL default '',
  `default` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 AUTO_INCREMENT=9 ;

-- 
-- Daten für Tabelle `stylesheets`
-- 

INSERT INTO `stylesheets` VALUES (6, 'agentcool', 'Standart', 'yes');

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

-- 
-- Tabellenstruktur für Tabelle `tage`
-- 

CREATE TABLE `tage` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 AUTO_INCREMENT=8 ;

-- 
-- Daten für Tabelle `tage`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `teammembers`
-- 

CREATE TABLE `teammembers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `teamid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `leader` enum('no','yes') NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=81 AUTO_INCREMENT=81 ;

-- 
-- Daten für Tabelle `teammembers`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `teams`
-- 

CREATE TABLE `teams` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) binary NOT NULL default '',
  `banner` varchar(100) binary NOT NULL default '',
  `typ` enum('support','crew') NOT NULL default 'support',
  `suffix` varchar(100) binary NOT NULL default '',
  `sort` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=28 AUTO_INCREMENT=28 ;

-- 
-- Daten für Tabelle `teams`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `test`
-- 

CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` enum('radio','checkbox') NOT NULL default 'radio',
  `question` text NOT NULL,
  `answers` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=17 AUTO_INCREMENT=17 ;

-- 
-- Daten für Tabelle `test`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `thanks`
-- 

CREATE TABLE `thanks` (
  `torrentid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3890 AUTO_INCREMENT=3890 ;

-- 
-- Daten für Tabelle `thanks`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `tickets`
-- 

CREATE TABLE `tickets` (
  `id` int(4) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=113 AUTO_INCREMENT=113 ;

-- 
-- Daten für Tabelle `tickets`
-- 

INSERT INTO `tickets` VALUES (103, 3953);
INSERT INTO `tickets` VALUES (104, 3953);
INSERT INTO `tickets` VALUES (105, 3953);
INSERT INTO `tickets` VALUES (106, 3953);
INSERT INTO `tickets` VALUES (107, 3953);
INSERT INTO `tickets` VALUES (108, 3953);
INSERT INTO `tickets` VALUES (109, 3953);
INSERT INTO `tickets` VALUES (110, 3953);
INSERT INTO `tickets` VALUES (111, 3953);
INSERT INTO `tickets` VALUES (112, 3953);

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

-- 
-- Tabellenstruktur für Tabelle `topics`
-- 

CREATE TABLE `topics` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `subject` varchar(40) binary default NULL,
  `locked` enum('yes','no') NOT NULL default 'no',
  `forumid` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `sticky` enum('yes','no') NOT NULL default 'no',
  `views` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`),
  KEY `subject` (`subject`),
  KEY `lastpost` (`lastpost`)
) TYPE=MyISAM AUTO_INCREMENT=11 AUTO_INCREMENT=11 ;

-- 
-- Daten für Tabelle `topics`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `toppartner`
-- 

CREATE TABLE `toppartner` (
  `id1` int(10) unsigned NOT NULL auto_increment,
  `titel1` varchar(255) binary default NULL,
  `banner1` varchar(255) binary default NULL,
  `link1` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id1`)
) TYPE=MyISAM AUTO_INCREMENT=13 AUTO_INCREMENT=13 ;

-- 
-- Daten für Tabelle `toppartner`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `torrents`
-- 

CREATE TABLE `torrents` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `info_hash` varchar(20) binary NOT NULL default '',
  `name` varchar(255) binary NOT NULL default '',
  `filename` varchar(255) binary NOT NULL default '',
  `save_as` varchar(255) binary NOT NULL default '',
  `search_text` text NOT NULL,
  `descr` text NOT NULL,
  `ori_descr` text NOT NULL,
  `category` int(10) unsigned NOT NULL default '0',
  `size` bigint(20) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` enum('single','multi') NOT NULL default 'single',
  `numfiles` int(10) unsigned NOT NULL default '0',
  `numpics` int(1) NOT NULL default '0',
  `comments` int(10) unsigned NOT NULL default '0',
  `views` int(10) unsigned NOT NULL default '0',
  `hits` int(10) unsigned NOT NULL default '0',
  `times_completed` int(10) unsigned NOT NULL default '0',
  `leechers` int(10) unsigned NOT NULL default '0',
  `seeders` int(10) unsigned NOT NULL default '0',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `visible` enum('yes','no') NOT NULL default 'yes',
  `banned` enum('yes','no') NOT NULL default 'no',
  `activated` enum('yes','no') NOT NULL default 'yes',
  `owner` int(10) unsigned NOT NULL default '0',
  `gu_agent` int(10) unsigned NOT NULL default '0',
  `numratings` int(10) unsigned NOT NULL default '0',
  `ratingsum` int(10) unsigned NOT NULL default '0',
  `nfo` text NOT NULL,
  `bild` varchar(155) binary NOT NULL default '',
  `free` enum('yes','no') default 'no',
  `wonly` enum('yes','no') default 'no',
  `seedspeed` varchar(20) binary NOT NULL default 'n/a',
  `recommended` enum('yes','no') default 'no',
  `highlight` enum('yes','no') default 'no',
  `infourl` varchar(155) binary NOT NULL default '',
  `poster` varchar(155) binary NOT NULL default '',
  `uploadmulti` tinyint(1) unsigned NOT NULL default '1',
  `multi` tinyint(2) default '0',
  `team` int(10) NOT NULL default '0',
  `numratings_video` int(10) unsigned NOT NULL default '0',
  `ratingsum_video` int(10) unsigned NOT NULL default '0',
  `numratings_audio` int(10) unsigned NOT NULL default '0',
  `ratingsum_audio` int(10) unsigned NOT NULL default '0',
  `vip` enum('yes','no') default 'no',
  `language` enum('na','deutsch','englisch','französisch','japanisch','multi') NOT NULL default 'na',
  `Release1` varchar(20) binary NOT NULL default 'n/a',
  `Release2` varchar(20) binary NOT NULL default 'n/a',
  `Release3` varchar(20) binary NOT NULL default 'n/a',
  `Release4` varchar(20) binary NOT NULL default 'n/a',
  `scene` enum('0','yes','no') NOT NULL default '0',
  `allmulti` enum('yes','no') default 'no',
  `freeleech` enum('yes','no') default 'no',
  `allfreeleech` enum('yes','no') default 'no',
  `timeou` enum('yes','no') default 'no',
  `nuked` enum('yes','no','unnuked') NOT NULL default 'no',
  `nukedr` varchar(100) binary NOT NULL default '',
  `tube` varchar(80) binary NOT NULL default '',
  `yout` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `info_hash` (`info_hash`),
  KEY `owner` (`owner`),
  KEY `visible` (`visible`),
  KEY `category_visible` (`category`,`visible`),
  FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`)
) TYPE=MyISAM AUTO_INCREMENT=4075 AUTO_INCREMENT=4075 ;

-- 
-- Daten für Tabelle `torrents`
-- 

INSERT INTO `torrents` VALUES (4074, 0x0dc3b614617b347e4ee280a6c2bc75c290c5bec3adc384c3a51641c2ba58, 0x696e7374616c6c2e666c6173682e706c617965722e657865, 0x696e7374616c6c5f666c6173685f706c617965722e6578652e746f7272656e74, 0x696e7374616c6c5f666c6173685f706c617965722e657865, 0x696e7374616c6c20666c61736820706c617965722065786520696e7374616c6c20666c61736820706c6179657220657865, 0x7575757a75, 0x7575757a75, 6, 1495112, '2008-06-14 22:54:59', 0x73696e676c65, 1, 0, 0, 8, 4, 0, 0, 1, '2008-06-17 19:35:39', 0x796573, 0x6e6f, 0x796573, 3953, 0, 0, 0, '', '', 0x796573, 0x6e6f, 0x3332204b422f73, 0x796573, 0x796573, '', 0x68747470733a2f2f696d672e7765622e64652f762f6d61696c2f312f6e61762f636c75626c6f676f2e676966, 1, 2, 0, 0, 0, 0, 0, 0x796573, 0x64657574736368, 0x284b617465676f72696529, 0x28547970656e29, 0x28566964656f53524329, 0x28536f756e6453524329, 0x30, 0x6e6f, 0x796573, 0x6e6f, 0x6e6f, 0x796573, 0x656565, '', '');

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

-- 
-- Tabellenstruktur für Tabelle `torrentsmore`
-- 

CREATE TABLE `torrentsmore` (
  `torrentid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=712 AUTO_INCREMENT=712 ;

-- 
-- Daten für Tabelle `torrentsmore`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `trackerlog`
-- 

CREATE TABLE `trackerlog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `timecode` int(15) unsigned NOT NULL default '0',
  `tag` char(2) NOT NULL default '',
  `monat` char(2) NOT NULL default '',
  `jahr` varchar(4) NOT NULL default '',
  `eintrag` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `trackerlog`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `traffic`
-- 

CREATE TABLE `traffic` (
  `userid` int(11) unsigned NOT NULL default '0',
  `torrentid` int(11) unsigned NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `downloadtime` int(11) unsigned NOT NULL default '0',
  `uploadtime` int(11) unsigned NOT NULL default '0',
  `seedtime` int(100) NOT NULL default '0',
  PRIMARY KEY  (`userid`,`torrentid`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `traffic`
-- 

INSERT INTO `traffic` VALUES (3953, 4074, 0, 0, 0, 0, 14920);

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

-- 
-- Tabellenstruktur für Tabelle `uploadapp`
-- 

CREATE TABLE `uploadapp` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `active` tinyint(1) NOT NULL default '1',
  `userid` int(10) NOT NULL default '0',
  `applied` datetime NOT NULL default '0000-00-00 00:00:00',
  `grpacct` tinyint(1) NOT NULL default '0',
  `grpname` varchar(100) binary NOT NULL default '',
  `grpdes` varchar(4) binary NOT NULL default '',
  `content` varchar(100) binary NOT NULL default '',
  `comment` varchar(100) binary NOT NULL default '',
  `seeding` tinyint(1) NOT NULL default '0',
  `othergrps` tinyint(1) NOT NULL default '0',
  `seedtime` varchar(100) binary NOT NULL default '',
  `votes` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `users` (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=12 AUTO_INCREMENT=12 ;

-- 
-- Daten für Tabelle `uploadapp`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `uptime`
-- 

CREATE TABLE `uptime` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) binary default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=26 AUTO_INCREMENT=26 ;

-- 
-- Daten für Tabelle `uptime`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `users`
-- 

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(40) binary NOT NULL default '',
  `old_password` varchar(40) binary NOT NULL default '',
  `passhash` varchar(32) binary NOT NULL default '',
  `passkey` tinyblob NOT NULL,
  `secret` tinyblob NOT NULL,
  `email` varchar(80) binary NOT NULL default '',
  `status` enum('pending','confirmed') NOT NULL default 'confirmed',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_access` datetime NOT NULL default '0000-00-00 00:00:00',
  `editsecret` tinyblob NOT NULL,
  `privacy` enum('strong','normal','low') NOT NULL default 'normal',
  `stylesheet` int(10) default '1',
  `info` text,
  `acceptpms` enum('yes','friends','no') NOT NULL default 'yes',
  `ip` varchar(15) binary NOT NULL default '',
  `class` tinyint(3) unsigned NOT NULL default '0',
  `avatar` varchar(100) binary NOT NULL default '',
  `uploaded` bigint(20) unsigned NOT NULL default '5368109120',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `title` varchar(30) binary NOT NULL default '',
  `country` int(10) unsigned NOT NULL default '0',
  `notifs` varchar(200) binary NOT NULL default '',
  `enabled` enum('yes','no') NOT NULL default 'yes',
  `accept_rules` enum('yes','no') NOT NULL default 'yes',
  `accept_email` enum('yes','friends','no') NOT NULL default 'friends',
  `avatars` enum('yes','no') NOT NULL default 'yes',
  `donor` enum('yes','no') NOT NULL default 'no',
  `dipok` enum('yes','no') NOT NULL default 'no',
  `dipcomment` text NOT NULL,
  `oldtorrentlist` enum('yes','no') NOT NULL default 'no',
  `displaysearch` enum('yes','no') NOT NULL default 'yes',
  `warned` enum('yes','no') NOT NULL default 'no',
  `log_ratio` enum('yes','no') NOT NULL default 'no',
  `statbox` enum('top','bottom','hide') NOT NULL default 'top',
  `warneduntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `torrentsperpage` int(3) unsigned NOT NULL default '0',
  `topicsperpage` int(3) unsigned NOT NULL default '0',
  `postsperpage` int(3) unsigned NOT NULL default '0',
  `deletepms` enum('yes','no') NOT NULL default 'yes',
  `savepms` enum('yes','no') NOT NULL default 'no',
  `hideuseruploads` enum('yes','no') NOT NULL default 'no',
  `wgeturl` enum('yes','no') NOT NULL default 'no',
  `showcols` text NOT NULL,
  `tlimitall` int(10) NOT NULL default '0',
  `tlimitseeds` int(10) NOT NULL default '0',
  `tlimitleeches` int(10) NOT NULL default '0',
  `allowupload` enum('yes','no') NOT NULL default 'yes',
  `seedbonus` decimal(4,1) NOT NULL default '0.0',
  `indexnav` enum('open','closed') NOT NULL default 'open',
  `showradionav` enum('yes','no') NOT NULL default 'yes',
  `showtspeaknav` enum('yes','no') NOT NULL default 'yes',
  `radionav` enum('open','closed') NOT NULL default 'open',
  `comnav` enum('open','closed') NOT NULL default 'open',
  `tornav` enum('open','closed') NOT NULL default 'open',
  `usernav` enum('open','closed') NOT NULL default 'open',
  `gamenav` enum('open','closed') NOT NULL default 'open',
  `extranav` enum('open','closed') NOT NULL default 'open',
  `tspeaknav` enum('open','closed') NOT NULL default 'open',
  `adminnav` enum('open','closed') NOT NULL default 'open',
  `helpnav` enum('open','closed') NOT NULL default 'open',
  `parked` enum('yes','no') NOT NULL default 'no',
  `anon` enum('no','yes') NOT NULL default 'no',
  `icq` varchar(255) binary NOT NULL default '',
  `msn` varchar(255) binary NOT NULL default '',
  `aim` varchar(255) binary NOT NULL default '',
  `yahoo` varchar(255) binary NOT NULL default '',
  `skype` varchar(255) binary NOT NULL default '',
  `xxx` enum('yes','no') NOT NULL default 'no',
  `dsl_speed` enum('0','1000','2000','3000','4000','6000','16000') NOT NULL default '0',
  `commentpm` enum('yes','no') NOT NULL default 'no',
  `support` enum('yes','no') NOT NULL default 'no',
  `supportfor` text NOT NULL,
  `webseed` enum('yes','no') NOT NULL default 'no',
  `love` enum('yes','no') NOT NULL default 'no',
  `crew` tinyint(3) NOT NULL default '0',
  `allowdownload` enum('yes','no') default 'yes',
  `adsl` enum('yes','no') NOT NULL default 'no',
  `showrec` enum('yes','no') default 'yes',
  `konto` bigint(20) unsigned NOT NULL default '5368709120',
  `beobachtung` enum('yes','no') NOT NULL default 'no',
  `beobachtet_von` text NOT NULL,
  `promoter` enum('yes','no') NOT NULL default 'no',
  `modcount` bigint(20) NOT NULL default '0',
  `warnmodcount` bigint(20) NOT NULL default '0',
  `slcount` bigint(20) NOT NULL default '0',
  `pmsend` bigint(20) NOT NULL default '0',
  `gender` enum('Keine','Singel','Vergeben') NOT NULL default 'Keine',
  `geschlecht` enum('Keine','Weiblich','Männlich') NOT NULL default 'Keine',
  `uplspeed` text,
  `downspeed` text,
  `isp` text,
  `downtime` int(10) unsigned NOT NULL default '0',
  `uptime` int(10) unsigned NOT NULL default '0',
  `pcoff` enum('yes','no') NOT NULL default 'yes',
  `announce` enum('yes','no') NOT NULL default 'yes',
  `invites` int(10) unsigned NOT NULL default '4',
  `invitedby` int(10) unsigned NOT NULL default '1',
  `vdsl` enum('yes','no') NOT NULL default 'no',
  `shoutanfang` varchar(255) binary NOT NULL default '',
  `shoutende` varchar(255) binary NOT NULL default '',
  `shoutpost` enum('yes','no') NOT NULL default 'yes',
  `userfree` enum('yes','no') NOT NULL default 'no',
  `souuntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `moviefile` varchar(100) binary default NULL,
  `werbung` enum('0','Topliste','PartnerTracker','Google','Saugstube','Deluxebits','Freunde','andere') NOT NULL default '0',
  `bgshout` enum('1','2','3','4','5','6','7') NOT NULL default '1',
  `con` enum('yes','no') NOT NULL default 'no',
  `wech` enum('yes','no') NOT NULL default 'no',
  `dj` enum('yes','no') NOT NULL default 'no',
  `aktanon` enum('yes','no') NOT NULL default 'no',
  `systemwarn` enum('yes','no') NOT NULL default 'no',
  `warnedby` varchar(40) binary NOT NULL default '',
  `timeswarned` int(10) NOT NULL default '0',
  `lastwarned` datetime NOT NULL default '0000-00-00 00:00:00',
  `permban` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `status_added` (`status`,`added`),
  KEY `ip` (`ip`),
  KEY `uploaded` (`uploaded`),
  KEY `downloaded` (`downloaded`),
  KEY `country` (`country`),
  KEY `last_access` (`last_access`),
  KEY `enabled` (`enabled`),
  KEY `warned` (`warned`)
) TYPE=MyISAM AUTO_INCREMENT=3964 AUTO_INCREMENT=3964 ;

-- 
-- Daten für Tabelle `users`
-- 

INSERT INTO `users` VALUES (3962, 0x54484f5245, '', 0x3234626532316663656437306362303734346264666636303534336437366337, 0x8e1ee9d21cba6181, 0x262dfb82ea4b09279774399709a4ac8b95f16f96, 0x746f6c6a612d637572747340676d782e6465, 0x636f6e6669726d6564, '2008-06-17 19:11:21', '2008-06-17 19:15:23', '2008-06-17 19:23:49', '', 0x6e6f726d616c, 6, NULL, 0x796573, 0x38352e3137372e39382e313738, 0, '', 5368109120, 0, '', 0, '', 0x796573, 0x796573, 0x667269656e6473, 0x796573, 0x6e6f, 0x6e6f, '', 0x6e6f, 0x796573, 0x6e6f, 0x6e6f, 0x746f70, '0000-00-00 00:00:00', 0, 0, 0, 0x796573, 0x6e6f, 0x6e6f, 0x6e6f, '', 0, 0, 0, 0x796573, 0.0, 0x6f70656e, 0x796573, 0x796573, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6e6f, 0x6e6f, '', '', '', '', '', 0x6e6f, 0x30, 0x6e6f, 0x6e6f, '', 0x6e6f, 0x6e6f, 0, 0x796573, 0x6e6f, 0x796573, 5368709120, 0x6e6f, '', 0x6e6f, 0, 0, 0, 0, 0x4b65696e65, 0x4b65696e65, NULL, NULL, NULL, 0, 0, 0x796573, 0x796573, 4, 1, 0x6e6f, '', '', 0x796573, 0x6e6f, '0000-00-00 00:00:00', NULL, 0x30, 0x31, 0x6e6f, 0x6e6f, 0x6e6f, 0x6e6f, 0x6e6f, '', 0, '0000-00-00 00:00:00', 0x6e6f);
INSERT INTO `users` VALUES (3953, 0x646a62726f636b656e, '', 0x3135363436643361366138376461616566333561313536303063356332323231, 0x6ff79affc734b311, 0x2ea8c84972eb9a8a99d61b2aa0eb4d78a38545d1, 0x646a62726f636b656e407765622e6465, 0x636f6e6669726d6564, '2008-06-13 10:26:35', '2008-06-17 19:13:27', '2008-06-17 19:46:09', '', 0x6e6f726d616c, 6, '', '', 0x38352e3137382e38312e3539, 100, 0x687474703a2f2f646a62726f636b656e2e646a2e66756e7069632e64652f6269746275636b65742f37333665646436663730386266366137303235666134393365393337663561392e6a7067, 125229120, 0, '', 0, '', 0x796573, 0x796573, 0x667269656e6473, 0x796573, 0x6e6f, 0x6e6f, '', 0x6e6f, 0x796573, 0x6e6f, 0x6e6f, '', '0000-00-00 00:00:00', 0, 0, 0, 0x796573, 0x6e6f, 0x6e6f, 0x6e6f, '', 0, 0, 0, 0x796573, 4.0, 0x6f70656e, '', 0x796573, '', '', 0x6f70656e, 0x6f70656e, '', '', 0x6f70656e, 0x6f70656e, '', '', 0x796573, '', '', '', '', '', 0x6e6f, 0x3136303030, 0x6e6f, 0x6e6f, '', 0x796573, 0x796573, 0, 0x796573, 0x796573, 0x796573, 5368709120, 0x796573, 0x646a62726f636b656e, 0x796573, 0, 0, 0, 0, 0x4b65696e65, 0x4b65696e65, '', '', '', 0, 0, 0x796573, 0x796573, 10, 1, 0x796573, '', '', 0x796573, 0x6e6f, '0000-00-00 00:00:00', NULL, 0x30, 0x31, 0x6e6f, 0x796573, 0x796573, 0x6e6f, 0x6e6f, '', 0, '0000-00-00 00:00:00', 0x6e6f);
INSERT INTO `users` VALUES (3955, 0x74657374, '', 0x3265376636616366633637303634663531623566316239383238373030643966, 0x9176b0d98322e814, 0xb4d822529faedb132faa0aa4c9c699dd4357ce54, 0x676767, 0x636f6e6669726d6564, '2008-06-14 00:01:45', '2008-06-16 13:09:47', '2008-06-16 13:15:25', '', 0x6e6f726d616c, 1, '', 0x796573, 0x37372e332e3131332e323237, 100, '', 5368109120, 0, '', 0, '', 0x796573, 0x796573, 0x667269656e6473, 0x796573, 0x6e6f, 0x6e6f, '', 0x6e6f, 0x796573, 0x6e6f, 0x6e6f, 0x746f70, '0000-00-00 00:00:00', 0, 0, 0, 0x796573, 0x6e6f, 0x6e6f, 0x6e6f, '', 0, 0, 0, 0x796573, 0.0, 0x6f70656e, 0x796573, 0x796573, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6e6f, 0x6e6f, '', '', '', '', '', 0x6e6f, 0x30, 0x6e6f, 0x6e6f, '', 0x6e6f, '', 0, 0x796573, 0x6e6f, 0x796573, 5368709120, 0x6e6f, '', 0x6e6f, 0, 0, 0, 0, 0x4b65696e65, 0x4b65696e65, NULL, NULL, NULL, 0, 0, 0x796573, 0x6e6f, 4, 1, 0x6e6f, '', '', 0x796573, 0x6e6f, '0000-00-00 00:00:00', NULL, 0x30, 0x31, 0x6e6f, '', '', 0x6e6f, 0x6e6f, '', 0, '0000-00-00 00:00:00', 0x6e6f);
INSERT INTO `users` VALUES (3959, 0x667233734348, '', 0x6261626461376139623435356363633438323562336339323063663033333634, 0xe6dc58cff5c4b0f8, 0xf92f01c35c8b0f0cb2f9856d7399521f7c010684, 0x576f726c64417373407765622e6465, 0x636f6e6669726d6564, '2008-06-15 19:41:51', '2008-06-15 21:22:49', '2008-06-15 21:27:23', '', 0x6e6f726d616c, 6, NULL, 0x796573, 0x38342e3138352e31352e3438, 0, '', 5368109120, 0, '', 0, '', 0x796573, 0x796573, 0x667269656e6473, 0x796573, 0x6e6f, 0x6e6f, '', 0x6e6f, 0x796573, 0x6e6f, 0x6e6f, 0x746f70, '0000-00-00 00:00:00', 0, 0, 0, 0x796573, 0x6e6f, 0x6e6f, 0x6e6f, '', 0, 0, 0, 0x796573, 0.0, 0x6f70656e, 0x796573, 0x796573, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6f70656e, 0x6e6f, 0x6e6f, '', '', '', '', '', 0x6e6f, 0x30, 0x6e6f, 0x6e6f, '', 0x6e6f, 0x6e6f, 0, 0x796573, 0x6e6f, 0x796573, 5368709120, 0x6e6f, '', 0x6e6f, 0, 0, 0, 0, 0x4b65696e65, 0x4b65696e65, NULL, NULL, NULL, 0, 0, 0x796573, 0x796573, 4, 1, 0x6e6f, '', '', 0x796573, 0x6e6f, '0000-00-00 00:00:00', NULL, 0x30, 0x31, 0x6e6f, 0x6e6f, 0x6e6f, 0x6e6f, 0x6e6f, '', 0, '0000-00-00 00:00:00', 0x6e6f);

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

-- 
-- Tabellenstruktur für Tabelle `votes`
-- 

CREATE TABLE `votes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `what` enum('requests') NOT NULL default 'requests',
  `user` int(10) unsigned NOT NULL default '0',
  `voteid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=195 AUTO_INCREMENT=195 ;

-- 
-- Daten für Tabelle `votes`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `wuensche`
-- 

CREATE TABLE `wuensche` (
  `id` bigint(255) NOT NULL auto_increment,
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `von` varchar(255) NOT NULL default '',
  `genre` varchar(255) NOT NULL default '',
  `wunsch` varchar(255) NOT NULL default '',
  `interpret` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=46 AUTO_INCREMENT=46 ;

-- 
-- Daten für Tabelle `wuensche`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `years`
-- 

CREATE TABLE `years` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) binary NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 AUTO_INCREMENT=11 ;

-- 
-- Daten für Tabelle `years`
-- 

INSERT INTO `years` VALUES (3, 0x32303038);
INSERT INTO `years` VALUES (4, 0x32303039);
INSERT INTO `years` VALUES (5, 0x32303130);
INSERT INTO `years` VALUES (6, 0x32303131);
INSERT INTO `years` VALUES (7, 0x32303132);
INSERT INTO `years` VALUES (8, 0x32303133);
INSERT INTO `years` VALUES (9, 0x32303134);
INSERT INTO `years` VALUES (10, 0x32303135);

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

-- 
-- Tabellenstruktur für Tabelle `youtubevideo`
-- 

CREATE TABLE `youtubevideo` (
  `id` bigint(20) NOT NULL auto_increment,
  `link` varchar(100) binary NOT NULL default '',
  `name` varchar(100) binary NOT NULL default '',
  `addedby` varchar(100) binary NOT NULL default '',
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=24 AUTO_INCREMENT=24 ;

-- 
-- Daten für Tabelle `youtubevideo`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `youtubevideo2`
-- 

CREATE TABLE `youtubevideo2` (
  `id` bigint(20) NOT NULL auto_increment,
  `link` varchar(100) binary NOT NULL default '',
  `name` varchar(100) binary NOT NULL default '',
  `addedby` varchar(100) binary NOT NULL default '',
  `addtime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=32 AUTO_INCREMENT=32 ;

-- 
-- Daten für Tabelle `youtubevideo2`
-- 

