Code:
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 29, 2008 at 08:13 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `tbdev2`
--
-- --------------------------------------------------------
--
-- Table structure for table `addedrequests`
--
CREATE TABLE `addedrequests` (
`id` int(10) unsigned NOT NULL auto_increment,
`requestid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`id`),
KEY `userid` (`userid`),
KEY `requestid_userid` (`requestid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `addedrequests`
--
-- --------------------------------------------------------
--
-- Table structure for table `adminpanel`
--
CREATE TABLE `adminpanel` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`url` varchar(20) default NULL,
`info` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2006 ;
--
-- Dumping data for table `adminpanel`
--
INSERT INTO `adminpanel` VALUES (2002, 'Add user', 'adduser.php', 'Add user');
INSERT INTO `adminpanel` VALUES (2003, 'Unconfirmed users', 'uncon.php', 'View unconfirmed accounts');
INSERT INTO `adminpanel` VALUES (2004, 'Announcement', 'announcement.php', 'Create important message for all tracker users');
INSERT INTO `adminpanel` VALUES (2005, 'Traceroute', 'traceroute.php', 'Trace IP');
-- --------------------------------------------------------
--
-- Table structure for table `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) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- Dumping data for table `announcement`
--
-- --------------------------------------------------------
--
-- Table structure for table `avps`
--
CREATE TABLE `avps` (
`arg` varchar(20) 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',
PRIMARY KEY (`arg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `avps`
--
INSERT INTO `avps` VALUES ('lastcleantime', '', 0, 1219968666);
-- --------------------------------------------------------
--
-- Table structure for table `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) NOT NULL default '',
`first` int(11) default NULL,
`last` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `first_last` (`first`,`last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `bans`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `blocks`
--
-- --------------------------------------------------------
--
-- Table structure for table `bonus`
--
CREATE TABLE `bonus` (
`id` int(5) NOT NULL auto_increment,
`bonusname` varchar(50) NOT NULL default '',
`points` decimal(4,1) NOT NULL default '0.0',
`description` text NOT NULL,
`art` varchar(10) NOT NULL default 'traffic',
`menge` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `bonus`
--
INSERT INTO `bonus` VALUES (1, '1.0GB Uploaded', 75.0, 'With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.', 'traffic', 1073741824);
INSERT INTO `bonus` VALUES (2, '2.5GB Uploaded', 150.0, 'With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.', 'traffic', 2684354560);
INSERT INTO `bonus` VALUES (3, '5GB Uploaded', 250.0, 'With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.', 'traffic', 5368709120);
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`sort_index` int(10) unsigned NOT NULL default '0',
`cat_desc` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` VALUES (1, 'Appz/misc', 'pic/style/icons/Appzmisc.png', 0, '');
INSERT INTO `categories` VALUES (2, 'XXX', 'pic/style/icons/Xxx.png', 0, '');
INSERT INTO `categories` VALUES (3, 'TV/rips', 'pic/style/icons/Tvrips.png', 0, '');
INSERT INTO `categories` VALUES (4, 'Music/MP3', 'pic/style/icons/Musicmp3.png', 0, '');
INSERT INTO `categories` VALUES (5, 'Anime', 'pic/style/icons/Anime.png', 0, '');
INSERT INTO `categories` VALUES (6, 'Appz/ISO', 'pic/style/icons/Appziso.png', 0, '');
INSERT INTO `categories` VALUES (7, 'Music/HQ', 'pic/style/icons/Musichq.png', 0, '');
INSERT INTO `categories` VALUES (8, 'Music/Clips', 'pic/style/icons/Musicclips.png', 0, '');
INSERT INTO `categories` VALUES (9, 'Movies/RUS ', 'pic/style/icons/Moviesrus.png', 0, '');
INSERT INTO `categories` VALUES (10, 'Movies/LV', 'pic/style/icons/Movieslv.png', 0, '');
INSERT INTO `categories` VALUES (11, 'Movies/ENG ', 'pic/style/icons/Movieseng.png', 0, '');
INSERT INTO `categories` VALUES (12, 'Movies/DVD ', 'pic/style/icons/Moviesdvd.png', 0, '');
INSERT INTO `categories` VALUES (13, 'Games/PC Rips ', 'pic/style/icons/Gamespcrips.png', 0, '');
INSERT INTO `categories` VALUES (14, 'Games/PC ISO ', 'pic/style/icons/Gamespciso.png', 0, '');
INSERT INTO `categories` VALUES (15, 'Games/PS2', 'pic/style/icons/Gamesps2.png', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `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) NOT NULL default '',
`rate` varchar(255) NOT NULL default '',
`beforeup` varchar(255) NOT NULL default '',
`upthis` varchar(255) NOT NULL default '',
`timediff` varchar(255) NOT NULL default '',
`userip` varchar(15) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cheaters`
--
-- --------------------------------------------------------
--
-- Table structure for table `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',
`request` int(11) NOT NULL default '0',
`offer` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user` (`user`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`flagpic` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=200 ;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` VALUES (1, 'Sweden', 'sweden.gif');
INSERT INTO `countries` VALUES (2, 'United States of America', 'usa.gif');
INSERT INTO `countries` VALUES (3, 'Russia', 'russia.gif');
INSERT INTO `countries` VALUES (4, 'Finland', 'finland.gif');
INSERT INTO `countries` VALUES (5, 'Canada', 'canada.gif');
INSERT INTO `countries` VALUES (6, 'France', 'france.gif');
INSERT INTO `countries` VALUES (7, 'Germany', 'germany.gif');
INSERT INTO `countries` VALUES (8, 'China', 'china.gif');
INSERT INTO `countries` VALUES (9, 'Italy', 'italy.gif');
INSERT INTO `countries` VALUES (10, 'Denmark', 'denmark.gif');
INSERT INTO `countries` VALUES (11, 'Norway', 'norway.gif');
INSERT INTO `countries` VALUES (12, 'United Kingdom', 'uk.gif');
INSERT INTO `countries` VALUES (13, 'Ireland', 'ireland.gif');
INSERT INTO `countries` VALUES (14, 'Poland', 'poland.gif');
INSERT INTO `countries` VALUES (15, 'Netherlands', 'netherlands.gif');
INSERT INTO `countries` VALUES (16, 'Belgium', 'belgium.gif');
INSERT INTO `countries` VALUES (17, 'Japan', 'japan.gif');
INSERT INTO `countries` VALUES (18, 'Brazil', 'brazil.gif');
INSERT INTO `countries` VALUES (19, 'Argentina', 'argentina.gif');
INSERT INTO `countries` VALUES (20, 'Australia', 'australia.gif');
INSERT INTO `countries` VALUES (21, 'New Zealand', 'newzealand.gif');
INSERT INTO `countries` VALUES (23, 'Spain', 'spain.gif');
INSERT INTO `countries` VALUES (24, 'Portugal', 'portugal.gif');
INSERT INTO `countries` VALUES (25, 'Mexico', 'mexico.gif');
INSERT INTO `countries` VALUES (26, 'Singapore', 'singapore.gif');
INSERT INTO `countries` VALUES (27, 'India', 'india.gif');
INSERT INTO `countries` VALUES (28, 'Albania', 'albania.gif');
INSERT INTO `countries` VALUES (29, 'South Africa', 'southafrica.gif');
INSERT INTO `countries` VALUES (30, 'South Korea', 'southkorea.gif');
INSERT INTO `countries` VALUES (31, 'Jamaica', 'jamaica.gif');
INSERT INTO `countries` VALUES (32, 'Luxembourg', 'luxembourg.gif');
INSERT INTO `countries` VALUES (33, 'Hong Kong', 'hongkong.gif');
INSERT INTO `countries` VALUES (34, 'Belize', 'belize.gif');
INSERT INTO `countries` VALUES (35, 'Algeria', 'algeria.gif');
INSERT INTO `countries` VALUES (36, 'Angola', 'angola.gif');
INSERT INTO `countries` VALUES (37, 'Austria', 'austria.gif');
INSERT INTO `countries` VALUES (38, 'Yugoslavia', 'yugoslavia.gif');
INSERT INTO `countries` VALUES (39, 'Western Samoa', 'westernsamoa.gif');
INSERT INTO `countries` VALUES (40, 'Malaysia', 'malaysia.gif');
INSERT INTO `countries` VALUES (41, 'Dominican Republic', 'dominicanrep.gif');
INSERT INTO `countries` VALUES (42, 'Greece', 'greece.gif');
INSERT INTO `countries` VALUES (43, 'Guatemala', 'guatemala.gif');
INSERT INTO `countries` VALUES (44, 'Israel', 'israel.gif');
INSERT INTO `countries` VALUES (45, 'Pakistan', 'pakistan.gif');
INSERT INTO `countries` VALUES (46, 'Czech Republic', 'czechrep.gif');
INSERT INTO `countries` VALUES (47, 'Serbia', 'serbia.gif');
INSERT INTO `countries` VALUES (48, 'Seychelles', 'seychelles.gif');
INSERT INTO `countries` VALUES (49, 'Taiwan', 'taiwan.gif');
INSERT INTO `countries` VALUES (50, 'Puerto Rico', 'puertorico.gif');
INSERT INTO `countries` VALUES (51, 'Chile', 'chile.gif');
INSERT INTO `countries` VALUES (52, 'Cuba', 'cuba.gif');
INSERT INTO `countries` VALUES (53, 'Congo', 'congo.gif');
INSERT INTO `countries` VALUES (54, 'Afghanistan', 'afghanistan.gif');
INSERT INTO `countries` VALUES (55, 'Turkey', 'turkey.gif');
INSERT INTO `countries` VALUES (56, 'Uzbekistan', 'uzbekistan.gif');
INSERT INTO `countries` VALUES (57, 'Switzerland', 'switzerland.gif');
INSERT INTO `countries` VALUES (58, 'Kiribati', 'kiribati.gif');
INSERT INTO `countries` VALUES (59, 'Philippines', 'philippines.gif');
INSERT INTO `countries` VALUES (60, 'Burkina Faso', 'burkinafaso.gif');
INSERT INTO `countries` VALUES (61, 'Nigeria', 'nigeria.gif');
INSERT INTO `countries` VALUES (62, 'Iceland', 'iceland.gif');
INSERT INTO `countries` VALUES (63, 'Nauru', 'nauru.gif');
INSERT INTO `countries` VALUES (64, 'Slovenia', 'slovenia.gif');
INSERT INTO `countries` VALUES (66, 'Turkmenistan', 'turkmenistan.gif');
INSERT INTO `countries` VALUES (67, 'Bosnia Herzegovina', 'bosniaherzegovina.gif');
INSERT INTO `countries` VALUES (68, 'Andorra', 'andorra.gif');
INSERT INTO `countries` VALUES (69, 'Lithuania', 'lithuania.gif');
INSERT INTO `countries` VALUES (70, 'Macedonia', 'macadonia.gif');
INSERT INTO `countries` VALUES (71, 'Netherlands Antilles', 'nethantilles.gif');
INSERT INTO `countries` VALUES (72, 'Ukraine', 'ukraine.gif');
INSERT INTO `countries` VALUES (73, 'Venezuela', 'venezuela.gif');
INSERT INTO `countries` VALUES (74, 'Hungary', 'hungary.gif');
INSERT INTO `countries` VALUES (75, 'Romania', 'romania.gif');
INSERT INTO `countries` VALUES (76, 'Vanuatu', 'vanuatu.gif');
INSERT INTO `countries` VALUES (77, 'Vietnam', 'vietnam.gif');
INSERT INTO `countries` VALUES (78, 'Trinidad & Tobago', 'trinidadandtobago.gif');
INSERT INTO `countries` VALUES (79, 'Honduras', 'honduras.gif');
INSERT INTO `countries` VALUES (80, 'Kyrgyzstan', 'kyrgyzstan.gif');
INSERT INTO `countries` VALUES (81, 'Ecuador', 'ecuador.gif');
INSERT INTO `countries` VALUES (82, 'Bahamas', 'bahamas.gif');
INSERT INTO `countries` VALUES (83, 'Peru', 'peru.gif');
INSERT INTO `countries` VALUES (84, 'Cambodia', 'cambodia.gif');
INSERT INTO `countries` VALUES (85, 'Barbados', 'barbados.gif');
INSERT INTO `countries` VALUES (86, 'Bangladesh', 'bangladesh.gif');
INSERT INTO `countries` VALUES (87, 'Laos', 'laos.gif');
INSERT INTO `countries` VALUES (88, 'Uruguay', 'uruguay.gif');
INSERT INTO `countries` VALUES (89, 'Antigua Barbuda', 'antiguabarbuda.gif');
INSERT INTO `countries` VALUES (90, 'Paraguay', 'paraguay.gif');
INSERT INTO `countries` VALUES (92, 'Union of Soviet Socialist Republics', 'ussr.gif');
INSERT INTO `countries` VALUES (93, 'Thailand', 'thailand.gif');
INSERT INTO `countries` VALUES (94, 'Senegal', 'senegal.gif');
INSERT INTO `countries` VALUES (95, 'Togo', 'togo.gif');
INSERT INTO `countries` VALUES (96, 'North Korea', 'northkorea.gif');
INSERT INTO `countries` VALUES (97, 'Croatia', 'croatia.gif');
INSERT INTO `countries` VALUES (98, 'Estonia', 'estonia.gif');
INSERT INTO `countries` VALUES (99, 'Colombia', 'colombia.gif');
INSERT INTO `countries` VALUES (100, 'Lebanon', 'lebanon.gif');
INSERT INTO `countries` VALUES (101, 'Latvia', 'latvia.gif');
INSERT INTO `countries` VALUES (102, 'Costa Rica', 'costarica.gif');
INSERT INTO `countries` VALUES (103, 'Egypt', 'egypt.gif');
INSERT INTO `countries` VALUES (104, 'Bulgaria', 'bulgaria.gif');
INSERT INTO `countries` VALUES (105, 'Isla de Muerte', 'jollyroger.gif');
INSERT INTO `countries` VALUES (106, 'Moldova', 'moldova.gif');
INSERT INTO `countries` VALUES (107, 'Armenia', 'armenia.gif');
INSERT INTO `countries` VALUES (108, 'Azerbaijan', 'azerbaijan.gif');
INSERT INTO `countries` VALUES (109, 'Bahrain', 'bahrain.gif');
INSERT INTO `countries` VALUES (110, 'Belarus', 'belarus.gif');
INSERT INTO `countries` VALUES (111, 'Benin', 'benin.gif');
INSERT INTO `countries` VALUES (112, 'Bhutan', 'bhutan.gif');
INSERT INTO `countries` VALUES (113, 'Bolivia', 'bolivia.gif');
INSERT INTO `countries` VALUES (114, 'Botswana', 'botswana.gif');
INSERT INTO `countries` VALUES (115, 'Brunei', 'brunei.gif');
INSERT INTO `countries` VALUES (116, 'Union of Myanmar', 'burma.gif');
INSERT INTO `countries` VALUES (117, 'Burundi', 'burund.gif');
INSERT INTO `countries` VALUES (118, 'Cameroon', 'cameroon.gif');
INSERT INTO `countries` VALUES (119, 'Central African Republic', 'centralafricanrep.gif');
INSERT INTO `countries` VALUES (120, 'Chad', 'chad.gif');
INSERT INTO `countries` VALUES (121, 'Comoros', 'comoros.gif');
INSERT INTO `countries` VALUES (122, 'Cyprus', 'cyprus.gif');
INSERT INTO `countries` VALUES (123, 'Democratic Republic of the Congo', 'demrepcongo.gif');
INSERT INTO `countries` VALUES (124, 'Djibouti', 'djiboutil.gif');
INSERT INTO `countries` VALUES (125, 'Dominica', 'dominica.gif');
INSERT INTO `countries` VALUES (126, 'El Salvador', 'elsalvado.gif');
INSERT INTO `countries` VALUES (127, 'Equatorial Guinea', 'eq_guinea.gif');
INSERT INTO `countries` VALUES (128, 'Eritrea', 'eritrea.gif');
INSERT INTO `countries` VALUES (129, 'Ethiopia', 'ethiopia.gif');
INSERT INTO `countries` VALUES (130, 'Fiji', 'fiji.gif');
INSERT INTO `countries` VALUES (131, 'Gabon', 'gabon.gif');
INSERT INTO `countries` VALUES (132, 'Gambia', 'gambia.gif');
INSERT INTO `countries` VALUES (133, 'Georgia', 'georgia.gif');
INSERT INTO `countries` VALUES (134, 'Ghana', 'ghana.gif');
INSERT INTO `countries` VALUES (135, 'Grenada', 'grenada.gif');
INSERT INTO `countries` VALUES (136, 'St. Vincent & the Grenadines', 'grenadines.gif');
INSERT INTO `countries` VALUES (137, 'Guinea-Bissau', 'guineabissau.gif');
INSERT INTO `countries` VALUES (138, 'Guinea', 'guineal.gif');
INSERT INTO `countries` VALUES (139, 'Guyana', 'guyana.gif');
INSERT INTO `countries` VALUES (140, 'Haiti', 'haiti.gif');
INSERT INTO `countries` VALUES (141, 'Hong Kong', 'hong_kong.gif');
INSERT INTO `countries` VALUES (142, 'Indonesia', 'indonesia.gif');
INSERT INTO `countries` VALUES (143, 'Iran', 'iran.gif');
INSERT INTO `countries` VALUES (144, 'Iraq', 'iraq.gif');
INSERT INTO `countries` VALUES (145, 'Ivory Coast', 'ivorycoast.gif');
INSERT INTO `countries` VALUES (146, 'Jordan', 'jordan.gif');
INSERT INTO `countries` VALUES (147, 'Kazakhstan', 'kazakhstan.gif');
INSERT INTO `countries` VALUES (148, 'Kenya', 'kenya.gif');
INSERT INTO `countries` VALUES (149, 'Kuwait', 'kuwait.gif');
INSERT INTO `countries` VALUES (150, 'Liberia', 'liberia.gif');
INSERT INTO `countries` VALUES (151, 'Libya', 'libya.gif');
INSERT INTO `countries` VALUES (152, 'Liechtenstein', 'liechtenstein.gif');
INSERT INTO `countries` VALUES (153, 'Macao', 'macau.gif');
INSERT INTO `countries` VALUES (154, 'Madagascar', 'madagascar.gif');
INSERT INTO `countries` VALUES (155, 'Malawi', 'malawi.gif');
INSERT INTO `countries` VALUES (156, 'Maldives', 'maldives.gif');
INSERT INTO `countries` VALUES (157, 'Mali', 'mali.gif');
INSERT INTO `countries` VALUES (158, 'Malta', 'malta.gif');
INSERT INTO `countries` VALUES (159, 'Mauritania', 'mauritania.gif');
INSERT INTO `countries` VALUES (160, 'Mauritius', 'mauritius.gif');
INSERT INTO `countries` VALUES (161, 'Micronesia', 'micronesia.gif');
INSERT INTO `countries` VALUES (162, 'Monaco', 'monaco.gif');
INSERT INTO `countries` VALUES (163, 'Mongolia', 'mongolia.gif');
INSERT INTO `countries` VALUES (164, 'Morocco', 'morocco.gif');
INSERT INTO `countries` VALUES (165, 'Mozambique', 'mozambique.gif');
INSERT INTO `countries` VALUES (166, 'Namibia', 'namibia.gif');
INSERT INTO `countries` VALUES (167, 'Nepal', 'nepal.gif');
INSERT INTO `countries` VALUES (168, 'Nicaragua', 'nicaragua.gif');
INSERT INTO `countries` VALUES (169, 'Niger', 'niger.gif');
INSERT INTO `countries` VALUES (170, 'North Korea', 'north_korea.gif');
INSERT INTO `countries` VALUES (171, 'Oman', 'oman.gif');
INSERT INTO `countries` VALUES (172, 'Panama', 'panama.gif');
INSERT INTO `countries` VALUES (173, 'Papua New Guinea', 'papuanewguinea.gif');
INSERT INTO `countries` VALUES (174, 'Qatar', 'qatar.gif');
INSERT INTO `countries` VALUES (175, 'Rwanda', 'rawanda.gif');
INSERT INTO `countries` VALUES (176, 'Sao Tome and Principe', 'sao_tome.gif');
INSERT INTO `countries` VALUES (177, 'Saudi Arabia', 'saudiarabia.gif');
INSERT INTO `countries` VALUES (178, 'Sierra Leone', 'sierraleone.gif');
INSERT INTO `countries` VALUES (179, 'Slovakia', 'slovakia.gif');
INSERT INTO `countries` VALUES (180, 'Solomon Islands', 'solomon_islands.gif');
INSERT INTO `countries` VALUES (181, 'Somalia', 'somalia.gif');
INSERT INTO `countries` VALUES (182, 'South Korea', 'south_korea.gif');
INSERT INTO `countries` VALUES (183, 'Sri Lanka', 'srilanka.gif');
INSERT INTO `countries` VALUES (184, 'St. Kitts & Nevis', 'stkitts_nevis.gif');
INSERT INTO `countries` VALUES (185, 'Saint Lucia', 'stlucia.gif');
INSERT INTO `countries` VALUES (186, 'Sudan', 'sudan.gif');
INSERT INTO `countries` VALUES (187, 'Suriname', 'suriname.gif');
INSERT INTO `countries` VALUES (188, 'Syria', 'syria.gif');
INSERT INTO `countries` VALUES (189, 'Tajikistan', 'tajikistan.gif');
INSERT INTO `countries` VALUES (190, 'Tanzania', 'tanzania.gif');
INSERT INTO `countries` VALUES (191, 'Tonga', 'tonga.gif');
INSERT INTO `countries` VALUES (192, 'Tunisia', 'tunisia.gif');
INSERT INTO `countries` VALUES (193, 'Tuvalu', 'tuvala.gif');
INSERT INTO `countries` VALUES (194, 'United Arab Emirates', 'uae.gif');
INSERT INTO `countries` VALUES (195, 'Uganda', 'uganda.gif');
INSERT INTO `countries` VALUES (196, 'Yemen', 'yemen.gif');
INSERT INTO `countries` VALUES (197, 'Zaire', 'zaire.gif');
INSERT INTO `countries` VALUES (198, 'Zambia', 'zambia.gif');
INSERT INTO `countries` VALUES (199, 'Zimbabwe', 'zimbabwe.gif');
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `files` (
`id` int(10) unsigned NOT NULL auto_increment,
`torrent` int(10) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`size` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `files`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `forums`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `friends`
--
-- --------------------------------------------------------
--
-- Table structure for table `helpdesk`
--
CREATE TABLE `helpdesk` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(60) NOT NULL default '',
`msg_problem` text,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`solved_date` datetime NOT NULL default '0000-00-00 00:00:00',
`solved` enum('no','yes','ignored') NOT NULL default 'no',
`added_by` int(10) NOT NULL default '0',
`solved_by` int(10) NOT NULL default '0',
`msg_answer` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `helpdesk`
--
-- --------------------------------------------------------
--
-- Table structure for table `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',
`added` datetime default NULL,
`msg` text,
`unread` enum('yes','no') NOT NULL default 'yes',
`poster` bigint(20) unsigned NOT NULL default '0',
`location` enum('in','out','both') NOT NULL default 'in',
PRIMARY KEY (`id`),
KEY `receiver` (`receiver`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `messages`
--
-- --------------------------------------------------------
--
-- Table structure for table `modpanel`
--
CREATE TABLE `modpanel` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`url` varchar(20) default NULL,
`info` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1015 ;
--
-- Dumping data for table `modpanel`
--
INSERT INTO `modpanel` VALUES (1001, 'Warned users', 'warned.php', 'See warned users');
INSERT INTO `modpanel` VALUES (1002, 'Poll overview', 'polls.php', 'View polls');
INSERT INTO `modpanel` VALUES (1003, 'Make poll', 'makepoll.php', 'Create new poll');
INSERT INTO `modpanel` VALUES (1004, 'User list', 'users.php', 'View users');
INSERT INTO `modpanel` VALUES (1005, 'Stats', 'stats.php', 'Tracker stats');
INSERT INTO `modpanel` VALUES (1006, 'Test IP', 'testip.php', 'Test single IP');
INSERT INTO `modpanel` VALUES (1007, 'Duplicate IP', 'ipcheck.php', 'Duplicate IP users');
INSERT INTO `modpanel` VALUES (1008, 'Leechers', 'leechers.php', 'Show users with ratio under 0.40');
INSERT INTO `modpanel` VALUES (1009, 'IP ban', 'bans.php', 'Ban single IP');
INSERT INTO `modpanel` VALUES (1011, 'Check script', 'proxy.php', 'Possable proxy server user check script');
INSERT INTO `modpanel` VALUES (1012, 'Uploaders', 'uploaders.php', 'See your uploaders info');
INSERT INTO `modpanel` VALUES (1013, 'Ratio cheaters', 'cheaters.php', 'Check if someone is cheating on tracker');
INSERT INTO `modpanel` VALUES (1014, 'Maybe Cheaters', 'maybecheaters.php', 'Those users maybe are cheaters');
-- --------------------------------------------------------
--
-- Table structure for table `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',
`body` text NOT NULL,
`title` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;
--
-- Dumping data for table `news`
--
-- --------------------------------------------------------
--
-- Table structure for table `offers`
--
CREATE TABLE `offers` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`yeah` int(10) unsigned NOT NULL default '0',
`against` int(10) unsigned NOT NULL default '0',
`category` int(11) NOT NULL default '0',
`comments` int(11) NOT NULL default '0',
`allowed` enum('allowed','pending','denied') NOT NULL default 'pending',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `offers`
--
-- --------------------------------------------------------
--
-- Table structure for table `offervotes`
--
CREATE TABLE `offervotes` (
`id` int(10) unsigned NOT NULL auto_increment,
`offerid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` enum('yeah','against') NOT NULL default 'yeah',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `offervotes`
--
-- --------------------------------------------------------
--
-- Table structure for table `peers`
--
CREATE TABLE `peers` (
`id` int(10) unsigned NOT NULL auto_increment,
`torrent` int(10) unsigned NOT NULL default '0',
`peer_id` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`ip` varchar(64) 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) 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',
`passkey` varchar(32) NOT NULL,
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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `peers`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `pollanswers`
--
-- --------------------------------------------------------
--
-- Table structure for table `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) NOT NULL default '',
`option0` varchar(40) NOT NULL default '',
`option1` varchar(40) NOT NULL default '',
`option2` varchar(40) NOT NULL default '',
`option3` varchar(40) NOT NULL default '',
`option4` varchar(40) NOT NULL default '',
`option5` varchar(40) NOT NULL default '',
`option6` varchar(40) NOT NULL default '',
`option7` varchar(40) NOT NULL default '',
`option8` varchar(40) NOT NULL default '',
`option9` varchar(40) NOT NULL default '',
`option10` varchar(40) NOT NULL default '',
`option11` varchar(40) NOT NULL default '',
`option12` varchar(40) NOT NULL default '',
`option13` varchar(40) NOT NULL default '',
`option14` varchar(40) NOT NULL default '',
`option15` varchar(40) NOT NULL default '',
`option16` varchar(40) NOT NULL default '',
`option17` varchar(40) NOT NULL default '',
`option18` varchar(40) NOT NULL default '',
`option19` varchar(40) NOT NULL default '',
`sort` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `polls`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `posts`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `readposts`
--
-- --------------------------------------------------------
--
-- Table structure for table `requests`
--
CREATE TABLE `requests` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`request` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(10) unsigned NOT NULL default '0',
`cat` int(10) unsigned NOT NULL default '0',
`filledby` int(10) unsigned NOT NULL default '0',
`filledurl` varchar(70) default NULL,
`filled` enum('yes','no') NOT NULL default 'no',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `id_added` (`id`,`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `requests`
--
-- --------------------------------------------------------
--
-- Table structure for table `shoutbox`
--
CREATE TABLE `shoutbox` (
`id` smallint(6) NOT NULL auto_increment,
`userid` smallint(6) NOT NULL default '0',
`username` varchar(25) NOT NULL default '',
`date` int(11) NOT NULL default '0',
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `shoutbox`
--
INSERT INTO `shoutbox` VALUES (1, 1, 'Dark', 1219955431, ';-)');
INSERT INTO `shoutbox` VALUES (2, 1, 'Dark', 1219962797, ':w00t:');
-- --------------------------------------------------------
--
-- Table structure for table `sitelog`
--
CREATE TABLE `sitelog` (
`id` int(10) unsigned NOT NULL auto_increment,
`added` datetime default NULL,
`txt` text,
PRIMARY KEY (`id`),
KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `sitelog`
--
-- --------------------------------------------------------
--
-- Table structure for table `stylesheets`
--
CREATE TABLE `stylesheets` (
`id` int(10) unsigned NOT NULL auto_increment,
`uri` varchar(255) NOT NULL default '',
`name` varchar(64) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `stylesheets`
--
INSERT INTO `stylesheets` VALUES (1, 'default.css', '(default)');
-- --------------------------------------------------------
--
-- Table structure for table `sysoppanel`
--
CREATE TABLE `sysoppanel` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`url` varchar(20) default NULL,
`info` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3014 ;
--
-- Dumping data for table `sysoppanel`
--
INSERT INTO `sysoppanel` VALUES (3001, 'Delete user', 'delacctadmin.php', 'Delete user without confirm');
INSERT INTO `sysoppanel` VALUES (3003, 'Mass mailer', 'massmail.php', 'Send mail to all tracker users');
INSERT INTO `sysoppanel` VALUES (3005, 'My_Sql stats', 'mysql_stats.php', 'See your MySql stats');
INSERT INTO `sysoppanel` VALUES (3006, 'Manage tracker categories', 'category.php', 'Manage your tracker torrent caregoties');
INSERT INTO `sysoppanel` VALUES (3008, 'Rest lost passwords', 'reset.php', 'Sysop''s reset users password, rest lost passwords');
INSERT INTO `sysoppanel` VALUES (3009, 'Edit forum', 'editforums.php', 'Edit your forum');
INSERT INTO `sysoppanel` VALUES (3010, 'PHP info', 'phpnfo.php', 'Check your PHP status');
INSERT INTO `sysoppanel` VALUES (3012, 'Do Cleanup', 'docleanup.php', 'Do cleanup functions');
INSERT INTO `sysoppanel` VALUES (3013, 'Optimize DB', 'optimize.php', 'This script will optimize your DB');
-- --------------------------------------------------------
--
-- Table structure for table `topics`
--
CREATE TABLE `topics` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`subject` varchar(40) 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `topics`
--
-- --------------------------------------------------------
--
-- Table structure for table `torrents`
--
CREATE TABLE `torrents` (
`id` int(10) unsigned NOT NULL auto_increment,
`info_hash` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`save_as` varchar(255) 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',
`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',
`owner` 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,
`description` varchar(120) 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `torrents`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(40) NOT NULL default '',
`old_password` varchar(40) NOT NULL default '',
`passhash` varchar(32) NOT NULL default '',
`secret` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`status` enum('pending','confirmed') NOT NULL default 'pending',
`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` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`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) NOT NULL default '',
`class` tinyint(3) unsigned NOT NULL default '0',
`avatar` varchar(100) NOT NULL default '',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`title` varchar(30) NOT NULL default '',
`country` int(10) unsigned NOT NULL default '0',
`notifs` varchar(100) NOT NULL default '',
`modcomment` text NOT NULL,
`enabled` enum('yes','no') NOT NULL default 'yes',
`avatars` enum('yes','no') NOT NULL default 'yes',
`donor` enum('yes','no') NOT NULL default 'no',
`warned` enum('yes','no') NOT NULL default 'no',
`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',
`parked` enum('yes','no') NOT NULL default 'no',
`announce` enum('yes','no') NOT NULL default 'no',
`passkey` varchar(32) NOT NULL,
`last_browse` int(11) NOT NULL default '0',
`seedbonus` decimal(3,1) NOT NULL,
`support` enum('yes','no') NOT NULL default 'no',
`supportfor` text NOT NULL,
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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` VALUES (1, 'Dark', '', '9d9c084717c38ffa2da1e62a67ffe6e6', 0x59c390c3bac2b2c3a8392516c59339c2a8c2ae25c3b0697238c28d161c, 'Darkcoder666@hotmail.com', 'confirmed', '2008-08-28 20:28:05', '2008-08-29 00:08:05', '2008-08-29 00:21:08', '', 'normal', 1, NULL, 'yes', '127.0.0.1', 6, '', 0, 0, '', 12, '', '', 'yes', 'yes', 'no', 'no', '0000-00-00 00:00:00', 0, 0, 0, 'yes', 'no', 'no', 'no', '', 1219958757, 0.0, 'no', '');
That sud do it must of missed some when exporting from phpmyadmin but that is the full export and will update other file asap thankyou for pointing them out ;)