Bravo List
Register
Go Back   > Bravo List > Source Code > Active Trackers > FreeTSP
Reply
  #1  
Old 29th April 2020, 10:09
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Senior Member
 
Join Date: Jul 2013
P2P
Posts: 317
Default Project Planning
Source: SceneXpress

Code:
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Palvelin: mysql.de.santrex.net
-- Luontiaika: 15.09.2010 klo 13:33
-- Palvelimen versio: 5.0.77
-- PHP:n versio: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Tietokanta: `scenehdo_hellznet`
--

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

--
-- Rakenne taululle `addedrequests`
--

CREATE TABLE IF NOT EXISTS `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=605 ;

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

--
-- Rakenne taululle `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `site_name` varchar(255) character set latin1 NOT NULL default 'MySite',
  `max_user` varchar(6) character set latin1 NOT NULL default '50000',
  `torrent_dir` varchar(255) character set latin1 NOT NULL default 'torrents',
  `announce_url_1` varchar(255) character set latin1 NOT NULL default 'http://mysite.com:80/announce.php',
  `announce_url_2` varchar(255) character set latin1 NOT NULL default 'http://mysite.com:81/announce.php',
  `announce_url_3` varchar(255) character set latin1 NOT NULL default 'http://mysite.com:82/announce.php',
  `nforce_dir` varchar(255) character set latin1 NOT NULL default 'nforceCache',
  `peer_limit` varchar(6) character set latin1 NOT NULL default '100000',
  `domain` varchar(255) character set latin1 NOT NULL default 'http://mysite.com',
  `site_mail` varchar(255) character set latin1 NOT NULL default 'noreply@mysite.com',
  `nforce_time` varchar(6) character set latin1 NOT NULL default '3600',
  `mysql_backup_dir` varchar(255) character set latin1 NOT NULL default 'backups',
  `bucket_real_path` varchar(255) character set latin1 NOT NULL default '/home/www/bitbucket',
  `bucket_path` varchar(255) character set latin1 NOT NULL default 'http://mysite.com/bitbucket',
  `cache` varchar(255) character set latin1 NOT NULL default '/home/www/cache'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `adminpanel`
--

CREATE TABLE IF NOT EXISTS `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=2017 ;

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

--
-- Rakenne taululle `ads`
--

CREATE TABLE IF NOT EXISTS `ads` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL default '1',
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

--
-- Rakenne taululle `ads_120x240`
--

CREATE TABLE IF NOT EXISTS `ads_120x240` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_120x600`
--

CREATE TABLE IF NOT EXISTS `ads_120x600` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

--
-- Rakenne taululle `ads_125x125`
--

CREATE TABLE IF NOT EXISTS `ads_125x125` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Rakenne taululle `ads_160x600`
--

CREATE TABLE IF NOT EXISTS `ads_160x600` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Rakenne taululle `ads_180x150`
--

CREATE TABLE IF NOT EXISTS `ads_180x150` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_200x200`
--

CREATE TABLE IF NOT EXISTS `ads_200x200` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

--
-- Rakenne taululle `ads_234x60`
--

CREATE TABLE IF NOT EXISTS `ads_234x60` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_250x250`
--

CREATE TABLE IF NOT EXISTS `ads_250x250` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_300x60`
--

CREATE TABLE IF NOT EXISTS `ads_300x60` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_300x250`
--

CREATE TABLE IF NOT EXISTS `ads_300x250` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Rakenne taululle `ads_336x280`
--

CREATE TABLE IF NOT EXISTS `ads_336x280` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_377x125`
--

CREATE TABLE IF NOT EXISTS `ads_377x125` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_468x60`
--

CREATE TABLE IF NOT EXISTS `ads_468x60` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

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

--
-- Rakenne taululle `ads_480x60`
--

CREATE TABLE IF NOT EXISTS `ads_480x60` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `ads_728x90`
--

CREATE TABLE IF NOT EXISTS `ads_728x90` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) character set latin1 NOT NULL,
  `location` int(11) NOT NULL,
  `code` longtext character set latin1 NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

--
-- Rakenne taululle `announcement`
--

CREATE TABLE IF NOT EXISTS `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=44 ;

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

--
-- Rakenne taululle `announcement_main`
--

CREATE TABLE IF NOT EXISTS `announcement_main` (
  `main_id` int(10) unsigned NOT NULL auto_increment,
  `owner_id` int(10) unsigned NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `expires` datetime NOT NULL default '0000-00-00 00:00:00',
  `sql_query` text NOT NULL,
  `subject` text NOT NULL,
  `body` text NOT NULL,
  PRIMARY KEY  (`main_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `announcement_process`
--

CREATE TABLE IF NOT EXISTS `announcement_process` (
  `process_id` int(10) unsigned NOT NULL auto_increment,
  `main_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `status` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`process_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `attachmentdownloads`
--

CREATE TABLE IF NOT EXISTS `attachmentdownloads` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL default '',
  `fileid` int(10) NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `userid` int(10) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `downloads` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `attachments`
--

CREATE TABLE IF NOT EXISTS `attachments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `topicid` int(10) unsigned NOT NULL default '0',
  `postid` int(10) unsigned NOT NULL default '0',
  `filename` varchar(255) NOT NULL default '',
  `size` bigint(20) unsigned NOT NULL default '0',
  `owner` int(10) unsigned NOT NULL default '0',
  `downloads` int(10) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `topicid` (`topicid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Rakenne taululle `avps`
--

CREATE TABLE IF NOT EXISTS `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;

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

--
-- Rakenne taululle `bannedemails`
--

CREATE TABLE IF NOT EXISTS `bannedemails` (
  `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 '',
  `email` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

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

--
-- Rakenne taululle `banned_agent`
--

CREATE TABLE IF NOT EXISTS `banned_agent` (
  `id` int(3) NOT NULL auto_increment,
  `agent` varchar(255) character set latin1 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;

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

--
-- Rakenne taululle `bans`
--

CREATE TABLE IF NOT EXISTS `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,
  `ip` int(15) default NULL,
  PRIMARY KEY  (`id`),
  KEY `first_last` (`first`,`last`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=156 ;

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

--
-- Rakenne taululle `bet`
--

CREATE TABLE IF NOT EXISTS `bet` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(150) character set latin1 NOT NULL,
  `description` text character set latin1 NOT NULL,
  `active` tinyint(1) unsigned NOT NULL default '0',
  `bet_close_date` datetime NOT NULL,
  `allPaid` tinyint(3) unsigned NOT NULL,
  `winner` tinyint(3) unsigned NOT NULL default '0',
  `topicid` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `active` (`active`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

--
-- Rakenne taululle `betchoices`
--

CREATE TABLE IF NOT EXISTS `betchoices` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `betid` int(10) unsigned NOT NULL default '0',
  `name` varchar(150) character set latin1 NOT NULL,
  `active` tinyint(1) unsigned NOT NULL default '0',
  `choice1` varchar(40) character set latin1 default NULL,
  `choice2` varchar(40) character set latin1 default NULL,
  `choice3` varchar(40) character set latin1 default NULL,
  `choice4` varchar(40) character set latin1 default NULL,
  `choice5` varchar(40) character set latin1 default NULL,
  `choice6` varchar(40) character set latin1 default NULL,
  `choice7` varchar(40) character set latin1 default NULL,
  `choice8` varchar(40) character set latin1 default NULL,
  `choice9` varchar(40) character set latin1 default NULL,
  `choice10` varchar(40) character set latin1 default NULL,
  `payout1` decimal(4,2) default NULL,
  `payout2` decimal(4,2) default NULL,
  `payout3` decimal(4,2) default NULL,
  `payout4` decimal(4,2) default NULL,
  `payout5` decimal(4,2) default NULL,
  `payout6` decimal(4,2) default NULL,
  `payout7` decimal(4,2) default NULL,
  `payout8` decimal(4,2) default NULL,
  `payout9` decimal(4,2) default NULL,
  `payout10` decimal(4,2) default NULL,
  PRIMARY KEY  (`id`),
  KEY `betid` (`betid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

--
-- Rakenne taululle `bets`
--

CREATE TABLE IF NOT EXISTS `bets` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `betid` int(10) unsigned NOT NULL default '0',
  `choice` tinyint(2) unsigned NOT NULL default '0',
  `bet` bigint(13) unsigned NOT NULL default '0',
  `paid` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`),
  KEY `betid` (`betid`),
  KEY `choice` (`choice`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

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

--
-- Rakenne taululle `bet_winns`
--

CREATE TABLE IF NOT EXISTS `bet_winns` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `betid` int(10) unsigned NOT NULL default '0',
  `choice` tinyint(2) default NULL,
  PRIMARY KEY  (`id`),
  KEY `betid` (`betid`),
  KEY `choice` (`choice`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

--
-- Rakenne taululle `bitbucket`
--

CREATE TABLE IF NOT EXISTS `bitbucket` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `filename` varchar(255) character set latin1 NOT NULL default '',
  `location` varchar(255) character set latin1 NOT NULL default '',
  `userid` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

--
-- Rakenne taululle `bj`
--

CREATE TABLE IF NOT EXISTS `bj` (
  `id` int(11) NOT NULL auto_increment,
  `placeholder` varchar(20) character set cp1251 NOT NULL default '',
  `gamer` varchar(20) character set cp1251 NOT NULL default '',
  `points` tinyint(4) NOT NULL default '0',
  `plstat` enum('playing','waiting','finished') character set cp1251 NOT NULL default 'playing',
  `bet` bigint(11) NOT NULL default '0',
  `cards` tinytext character set cp1251 NOT NULL,
  `date` int(11) NOT NULL default '0',
  `winner` varchar(20) character set cp1251 NOT NULL default '',
  `gamewithid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1008428 ;

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

--
-- Rakenne taululle `blackjack`
--

CREATE TABLE IF NOT EXISTS `blackjack` (
  `userid` int(11) NOT NULL default '0',
  `points` int(11) NOT NULL default '0',
  `status` enum('playing','waiting') character set latin1 NOT NULL default 'playing',
  `cards` text character set latin1 NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `blocks`
--

CREATE TABLE IF NOT EXISTS `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=36 ;

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

--
-- Rakenne taululle `bonus`
--

CREATE TABLE IF NOT EXISTS `bonus` (
  `id` int(5) NOT NULL auto_increment,
  `bonusname` varchar(50) NOT NULL default '',
  `points` decimal(5,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=9 ;

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

--
-- Rakenne taululle `bugs`
--

CREATE TABLE IF NOT EXISTS `bugs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(60) NOT NULL default '',
  `msg_bug` 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 ;

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

--
-- Rakenne taululle `cards`
--

CREATE TABLE IF NOT EXISTS `cards` (
  `id` int(11) NOT NULL auto_increment,
  `points` int(11) NOT NULL default '0',
  `pic` text character set latin1 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

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

--
-- Rakenne taululle `casino`
--

CREATE TABLE IF NOT EXISTS `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') character set cp1251 NOT NULL default 'yes',
  `deposit` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `casino_bets`
--

CREATE TABLE IF NOT EXISTS `casino_bets` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) NOT NULL default '0',
  `proposed` varchar(40) character set cp1251 NOT NULL default '',
  `challenged` varchar(40) character set cp1251 NOT NULL default '',
  `result` char(1) character set cp1251 NOT NULL default '0',
  `amount` bigint(20) NOT NULL default '0',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `rand` enum('yes','no') character set cp1251 NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`,`proposed`,`challenged`,`amount`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=168711 ;

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

--
-- Rakenne taululle `categories`
--

CREATE TABLE IF NOT EXISTS `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=46 ;

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

--
-- Rakenne taululle `cheaters`
--

CREATE TABLE IF NOT EXISTS `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=63 ;

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

--
-- Rakenne taululle `clients`
--

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `client` varchar(32) character set latin1 NOT NULL default '',
  `agentString` varchar(64) character set latin1 NOT NULL default '',
  `freq` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ;

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

--
-- Rakenne taululle `coderspanel`
--

CREATE TABLE IF NOT EXISTS `coderspanel` (
  `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=3051 ;

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

--
-- Rakenne taululle `comments`
--

CREATE TABLE IF NOT EXISTS `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',
  `photo_gallery` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `user` (`user`),
  KEY `torrent` (`torrent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6148 ;

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

--
-- Rakenne taululle `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `name` varchar(255) character set latin1 NOT NULL default '',
  `signup` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `connect_info`
--

CREATE TABLE IF NOT EXISTS `connect_info` (
  `id` int(10) NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `userid` int(11) NOT NULL default '0',
  `ip` varchar(64) character set latin1 NOT NULL default '',
  `passkey` varchar(32) character set latin1 NOT NULL default '',
  `torrentid` int(11) NOT NULL default '0',
  `agent` varchar(60) character set latin1 NOT NULL default '',
  `peerid` varchar(20) character set latin1 NOT NULL default '',
  `port` smallint(5) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=602 ;

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

--
-- Rakenne taululle `countries`
--

CREATE TABLE IF NOT EXISTS `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 ;

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

--
-- Rakenne taululle `designerspanel`
--

CREATE TABLE IF NOT EXISTS `designerspanel` (
  `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=3035 ;

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

--
-- Rakenne taululle `faq`
--

CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;

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

--
-- Rakenne taululle `files`
--

CREATE TABLE IF NOT EXISTS `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`),
  KEY `idx_torrent` (`torrent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=555468 ;

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

--
-- Rakenne taululle `forums`
--

CREATE TABLE IF NOT EXISTS `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',
  `forid` tinyint(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

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

--
-- Rakenne taululle `friends`
--

CREATE TABLE IF NOT EXISTS `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',
  `confirmed` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userfriend` (`userid`,`friendid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=904 ;

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

--
-- Rakenne taululle `funds`
--

CREATE TABLE IF NOT EXISTS `funds` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cash` decimal(8,2) NOT NULL default '0.00',
  `user` int(10) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

--
-- Rakenne taululle `gallery_admin`
--

CREATE TABLE IF NOT EXISTS `gallery_admin` (
  `per_page` smallint(4) NOT NULL default '20',
  `num_rows` tinyint(2) NOT NULL default '20',
  `max_file_size` int(12) NOT NULL default '1048576',
  KEY `per_page` (`per_page`),
  KEY `num_rows` (`num_rows`),
  KEY `max_file_size` (`max_file_size`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `gallery_admin_users`
--

CREATE TABLE IF NOT EXISTS `gallery_admin_users` (
  `user_class` tinyint(3) NOT NULL default '0',
  `gal_per_member` int(4) NOT NULL default '0',
  `number_total` int(4) NOT NULL default '0',
  `number_of_pics` int(4) NOT NULL default '0',
  PRIMARY KEY  (`user_class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `image_ratings`
--

CREATE TABLE IF NOT EXISTS `image_ratings` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `image_id` int(10) unsigned NOT NULL default '0',
  `user_id` 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  (`id`),
  KEY `user` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `invites`
--

CREATE TABLE IF NOT EXISTS `invites` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `inviter` int(10) unsigned NOT NULL default '0',
  `inviteid` int(10) NOT NULL default '0',
  `invites` int(10) unsigned NOT NULL default '4',
  `invitedby` int(10) unsigned NOT NULL default '1',
  `invite` varchar(32) character set latin1 NOT NULL default '',
  `time_invited` datetime NOT NULL default '0000-00-00 00:00:00',
  `confirmed` char(3) character set latin1 NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  KEY `inviter` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;

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

--
-- Rakenne taululle `iplog`
--

CREATE TABLE IF NOT EXISTS `iplog` (
  `id` int(100) unsigned NOT NULL auto_increment,
  `ip` varchar(15) character set latin1 default NULL,
  `userid` int(10) default NULL,
  `access` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=954 ;

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

--
-- Rakenne taululle `languages`
--

CREATE TABLE IF NOT EXISTS `languages` (
  `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=3 ;

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

--
-- Rakenne taululle `leecherspmlog`
--

CREATE TABLE IF NOT EXISTS `leecherspmlog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` int(10) unsigned NOT NULL default '0',
  `date` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `loginattempts`
--

CREATE TABLE IF NOT EXISTS `loginattempts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ip` varchar(15) character set latin1 NOT NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `banned` enum('yes','no') character set latin1 NOT NULL default 'no',
  `attempts` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `lottery_config`
--

CREATE TABLE IF NOT EXISTS `lottery_config` (
  `name` varchar(255) character set cp1251 NOT NULL default '',
  `value` varchar(255) character set cp1251 NOT NULL default '',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `messages`
--

CREATE TABLE IF NOT EXISTS `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',
  `saved` enum('no','yes') NOT NULL default 'no',
  `subject` text,
  PRIMARY KEY  (`id`),
  KEY `receiver` (`receiver`),
  KEY `idx_sender` (`sender`),
  KEY `idx_location` (`location`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=586350 ;

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

--
-- Rakenne taululle `modcomments`
--

CREATE TABLE IF NOT EXISTS `modcomments` (
  `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
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `moderators`
--

CREATE TABLE IF NOT EXISTS `moderators` (
  `naam` varchar(40) character set latin1 NOT NULL default '',
  `letter` char(1) character set latin1 NOT NULL default '',
  `mod_id` int(5) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `modpanel`
--

CREATE TABLE IF NOT EXISTS `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=1024 ;

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

--
-- Rakenne taululle `my_gallerys`
--

CREATE TABLE IF NOT EXISTS `my_gallerys` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `gallery_name` varchar(60) character set latin1 NOT NULL default '',
  `share_gallery` enum('public','private','friends') character set latin1 NOT NULL default 'public',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Rakenne taululle `news`
--

CREATE TABLE IF NOT EXISTS `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 character set latin1 NOT NULL,
  `title` varchar(255) character set latin1 NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `added` (`added`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=140 ;

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

--
-- Rakenne taululle `offers`
--

CREATE TABLE IF NOT EXISTS `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=13 ;

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

--
-- Rakenne taululle `offervotes`
--

CREATE TABLE IF NOT EXISTS `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=35 ;

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

--
-- Rakenne taululle `onlinerec`
--

CREATE TABLE IF NOT EXISTS `onlinerec` (
  `users` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`users`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `overforums`
--

CREATE TABLE IF NOT EXISTS `overforums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(60) character set latin1 NOT NULL default '',
  `description` varchar(200) character set latin1 default NULL,
  `minclassview` tinyint(3) unsigned NOT NULL default '0',
  `forid` tinyint(3) unsigned NOT NULL default '1',
  `sort` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

--
-- Rakenne taululle `partner`
--

CREATE TABLE IF NOT EXISTS `partner` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) character set latin1 collate latin1_general_ci default NULL,
  `banner` varchar(255) character set latin1 collate latin1_general_ci default NULL,
  `link` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
  `addedby` bigint(20) unsigned NOT NULL,
  `addedon` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Rakenne taululle `peers`
--

CREATE TABLE IF NOT EXISTS `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=4126730 ;

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

--
-- Rakenne taululle `photo_gallery`
--

CREATE TABLE IF NOT EXISTS `photo_gallery` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `name` varchar(120) character set latin1 NOT NULL default '',
  `location` varchar(240) character set latin1 NOT NULL default '',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `numratings` int(10) unsigned NOT NULL default '0',
  `ratingsum` int(10) unsigned NOT NULL default '0',
  `in_gallery` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

--
-- Rakenne taululle `pmboxes`
--

CREATE TABLE IF NOT EXISTS `pmboxes` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `boxnumber` tinyint(4) NOT NULL default '2',
  `name` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

--
-- Rakenne taululle `pollanswers`
--

CREATE TABLE IF NOT EXISTS `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=16134 ;

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

--
-- Rakenne taululle `polls`
--

CREATE TABLE IF NOT EXISTS `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=80 ;

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

--
-- Rakenne taululle `postpollanswers`
--

CREATE TABLE IF NOT EXISTS `postpollanswers` (
  `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Poll for Forum Posts' AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `postpolls`
--

CREATE TABLE IF NOT EXISTS `postpolls` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `question` text NOT NULL,
  `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 'no',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Post Polls Table' AUTO_INCREMENT=2 ;

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

--
-- Rakenne taululle `posts`
--

CREATE TABLE IF NOT EXISTS `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=20751 ;

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

--
-- Rakenne taululle `radio`
--

CREATE TABLE IF NOT EXISTS `radio` (
  `id` int(5) NOT NULL auto_increment,
  `name` varchar(100) character set latin1 NOT NULL,
  `url` varchar(100) character set latin1 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Rakenne taululle `rangclass`
--

CREATE TABLE IF NOT EXISTS `rangclass` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `rangpic` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Rakenne taululle `ratings`
--

CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Rakenne taululle `readposts`
--

CREATE TABLE IF NOT EXISTS `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=102090 ;

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

--
-- Rakenne taululle `referers`
--

CREATE TABLE IF NOT EXISTS `referers` (
  `ID` mediumint(9) NOT NULL auto_increment,
  `website` varchar(60) character set latin1 default NULL,
  `hits` varchar(60) character set latin1 default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=130 ;

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

--
-- Rakenne taululle `reports`
--

CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `reported_by` int(10) unsigned NOT NULL default '0',
  `reporting_what` int(10) unsigned NOT NULL default '0',
  `reporting_type` enum('User','Comment','Request_Comment','Offer_Comment','Request','Offer','Torrent','Hit_And_Run','Post') character set latin1 NOT NULL default 'Torrent',
  `reason` text character set latin1 NOT NULL,
  `who_delt_with_it` int(10) unsigned NOT NULL default '0',
  `delt_with` tinyint(1) NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `how_delt_with` text character set latin1 NOT NULL,
  `2nd_value` int(10) unsigned NOT NULL default '0',
  `when_delt_with` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Rakenne taululle `requests`
--

CREATE TABLE IF NOT EXISTS `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=345 ;

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

--
-- Rakenne taululle `reseed`
--

CREATE TABLE IF NOT EXISTS `reseed` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `torrent` int(10) unsigned NOT NULL default '0',
  `user` int(5) NOT NULL default '0',
  `reason` varchar(255) default NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `fulfilled` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `torrent` (`torrent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Rakenne taululle `rules`
--

CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

--
-- Rakenne taululle `russiantrackers`
--

CREATE TABLE IF NOT EXISTS `russiantrackers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `url` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Rakenne taululle `shoutbox`
--

CREATE TABLE IF NOT EXISTS `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,
  `text` text character set utf8 collate utf8_romanian_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3403 ;

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

--
-- Rakenne taululle `sitelog`
--

CREATE TABLE IF NOT EXISTS `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=62246 ;

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

--
-- Rakenne taululle `snatched`
--

CREATE TABLE IF NOT EXISTS `snatched` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `torrentid` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `port` smallint(5) unsigned NOT NULL default '0',
  `connectable` enum('yes','no') NOT NULL default 'no',
  `agent` varchar(60) NOT NULL default '',
  `peer_id` varchar(20) NOT NULL default '',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `upspeed` bigint(20) NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `downspeed` bigint(20) NOT NULL default '0',
  `to_go` bigint(20) unsigned NOT NULL default '0',
  `seeder` enum('yes','no') NOT NULL default 'no',
  `seedtime` int(10) unsigned NOT NULL default '0',
  `leechtime` int(10) unsigned NOT NULL default '0',
  `start_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `complete_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `idx_userid` (`userid`),
  KEY `idx_torrentid` (`torrentid`),
  KEY `idx_peer_id` (`peer_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=192291 ;

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

--
-- Rakenne taululle `speed`
--

CREATE TABLE IF NOT EXISTS `speed` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

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

--
-- Rakenne taululle `staffchat`
--

CREATE TABLE IF NOT EXISTS `staffchat` (
  `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,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=955 ;

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

--
-- Rakenne taululle `staffleaderpanel`
--

CREATE TABLE IF NOT EXISTS `staffleaderpanel` (
  `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=2021 ;

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

--
-- Rakenne taululle `staffmessages`
--

CREATE TABLE IF NOT EXISTS `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) NOT NULL default '',
  `answeredby` int(10) unsigned NOT NULL default '0',
  `answered` tinyint(1) NOT NULL default '0',
  `answer` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=81 ;

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

--
-- Rakenne taululle `staffpanel`
--

CREATE TABLE IF NOT EXISTS `staffpanel` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `page_name` varchar(30) NOT NULL default '',
  `file_name` varchar(30) NOT NULL default '',
  `description` varchar(100) NOT NULL default '',
  `av_class` tinyint(3) unsigned NOT NULL default '0',
  `added_by` int(10) unsigned NOT NULL default '0',
  `added` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `file_name` (`file_name`),
  KEY `av_class` (`av_class`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;

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

--
-- Rakenne taululle `stats`
--

CREATE TABLE IF NOT EXISTS `stats` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `regusers` int(10) unsigned NOT NULL default '0',
  `unconusers` int(10) unsigned NOT NULL default '0',
  `torrents` int(10) unsigned NOT NULL default '0',
  `seeders` int(10) unsigned NOT NULL default '0',
  `leechers` int(10) unsigned NOT NULL default '0',
  `torrentstoday` int(10) unsigned NOT NULL default '0',
  `donors` int(10) unsigned NOT NULL default '0',
  `unconnectables` int(10) unsigned NOT NULL default '0',
  `forumtopics` int(10) unsigned NOT NULL default '0',
  `forumposts` int(10) unsigned NOT NULL default '0',
  `numactive` int(10) unsigned NOT NULL default '0',
  `totalup` int(15) unsigned NOT NULL default '0',
  `totaldown` int(15) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Rakenne taululle `stylesheets`
--

CREATE TABLE IF NOT EXISTS `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=23 ;

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

--
-- Rakenne taululle `subs`
--

CREATE TABLE IF NOT EXISTS `subs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) character set latin1 NOT NULL default '',
  `filename` varchar(255) character set latin1 NOT NULL default '',
  `cd` int(10) unsigned NOT NULL default '0',
  `frame` varchar(255) character set latin1 NOT NULL default '',
  `comment` text character set latin1 NOT NULL,
  `added` datetime default NULL,
  `size` int(10) unsigned NOT NULL default '0',
  `uppedby` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) character set latin1 NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Rakenne taululle `sysoppanel`
--

CREATE TABLE IF NOT EXISTS `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=3032 ;

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

--
-- Rakenne taululle `thanks`
--

CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24008 ;

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

--
-- Rakenne taululle `tickets`
--

CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(4) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `topics`
--

CREATE TABLE IF NOT EXISTS `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',
  `pollid` 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=492 ;

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

--
-- Rakenne taululle `torrents`
--

CREATE TABLE IF NOT EXISTS `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',
  `staffrec` enum('yes','no') NOT NULL default 'no',
  `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 '',
  `anonymous` enum('yes','no') NOT NULL default 'no',
  `genre` varchar(40) NOT NULL,
  `poster` varchar(255) NOT NULL,
  `tube` varchar(80) NOT NULL default '',
  `sticky` enum('yes','no') NOT NULL default 'no',
  `request` enum('yes','no') NOT NULL default 'no',
  `freeleech` enum('yes','no') NOT NULL default 'yes',
  `url` varchar(80) default NULL,
  `trailers` varchar(80) default NULL,
  `double` enum('yes','no') NOT NULL default 'no',
  `pretime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `info_hash` (`info_hash`),
  KEY `owner` (`owner`),
  KEY `visible` (`visible`),
  KEY `category_visible` (`category`,`visible`),
  KEY `idx_staffrec` (`staffrec`),
  KEY `idx_seeders` (`seeders`),
  KEY `idx_category` (`category`),
  KEY `idx_owner` (`owner`),
  KEY `idx_sticky` (`sticky`),
  FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15332 ;

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

--
-- Rakenne taululle `torrent_ratings`
--

CREATE TABLE IF NOT EXISTS `torrent_ratings` (
  `id` int(11) NOT NULL auto_increment,
  `up_rated` int(11) NOT NULL default '0',
  `userid` varchar(200) character set latin1 NOT NULL default '',
  `down_rated` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `uploadapp`
--

CREATE TABLE IF NOT EXISTS `uploadapp` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) NOT NULL default '0',
  `applied` datetime NOT NULL default '0000-00-00 00:00:00',
  `speed` varchar(50) NOT NULL,
  `offer` longtext NOT NULL,
  `reason` longtext NOT NULL,
  `sites` enum('yes','no') NOT NULL default 'no',
  `sitenames` varchar(150) NOT NULL default '',
  `scene` enum('yes','no') NOT NULL default 'no',
  `creating` enum('yes','no') NOT NULL default 'no',
  `seeding` enum('yes','no') NOT NULL default 'no',
  `connectable` enum('yes','no','pending') NOT NULL default 'pending',
  `status` enum('accepted','rejected','pending') NOT NULL default 'pending',
  `moderator` varchar(40) NOT NULL default '',
  `comment` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `users` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=118 ;

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

--
-- Rakenne taululle `usercp`
--

CREATE TABLE IF NOT EXISTS `usercp` (
  `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=2041 ;

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

--
-- Rakenne taululle `userhits`
--

CREATE TABLE IF NOT EXISTS `userhits` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `hitid` int(10) unsigned NOT NULL default '0',
  `number` int(10) unsigned NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1403 ;

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

--
-- Rakenne taululle `users`
--

CREATE TABLE IF NOT EXISTS `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 '4',
  `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 'pic/default_avatar.png',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `bonusupload` bigint(20) NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `title` varchar(999) NOT NULL,
  `country` int(10) unsigned NOT NULL default '75',
  `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',
  `language` int(10) NOT NULL default '1',
  `support` enum('yes','no') NOT NULL default 'no',
  `supportfor` text NOT NULL,
  `last_post` datetime NOT NULL default '0000-00-00 00:00:00',
  `forum_access` datetime NOT NULL default '0000-00-00 00:00:00',
  `forumpost` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'yes',
  `gender` enum('Male','Female','N/A') NOT NULL default 'N/A',
  `timezone` smallint(3) NOT NULL default '0',
  `dst` tinyint(2) NOT NULL default '0',
  `signatures` enum('yes','no') NOT NULL default 'yes',
  `signature` varchar(225) NOT NULL default '',
  `seedbonus` decimal(5,1) NOT NULL default '0.0',
  `bonuscomment` text,
  `vip_added` enum('yes','no') NOT NULL default 'no',
  `vip_until` datetime NOT NULL default '0000-00-00 00:00:00',
  `smile_until` datetime NOT NULL default '0000-00-00 00:00:00',
  `rangclass` int(10) unsigned NOT NULL default '0',
  `invited_by` int(10) NOT NULL default '0',
  `invitees` varchar(100) NOT NULL,
  `invites` smallint(5) NOT NULL default '0',
  `uploadpos` enum('yes','no') NOT NULL default 'no',
  `chatpost` enum('yes','no') NOT NULL default 'yes',
  `uplspeed` text,
  `downspeed` text,
  `isp` text,
  `showfriends` enum('yes','no') NOT NULL default 'no',
  `timeswarned` int(10) NOT NULL default '0',
  `hits` int(10) NOT NULL default '0',
  `page_now` varchar(40) NOT NULL default '',
  `downloadpos` enum('yes','no') NOT NULL default 'yes',
  `bjwins` int(10) NOT NULL default '0',
  `bjlosses` int(10) NOT NULL default '0',
  `zodiac` int(10) unsigned NOT NULL default '0',
  `download` int(10) unsigned NOT NULL default '0',
  `upload` int(10) unsigned NOT NULL default '0',
  `anonymous` enum('yes','no') default NULL,
  `reseeds` int(5) NOT NULL default '0',
  `donated` decimal(8,2) NOT NULL default '0.00',
  `donoruntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `total_donated` decimal(8,2) NOT NULL default '0.00',
  `invitedby` int(10) unsigned NOT NULL default '1',
  `birthday` date default '0000-00-00',
  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`),
  KEY `idx_class` (`class`),
  KEY `idx_passkey` (`passkey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24025 ;

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

--
-- Rakenne taululle `users2`
--

CREATE TABLE IF NOT EXISTS `users2` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(40) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `old_password` varchar(40) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `passhash` varchar(32) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `secret` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(80) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `status` enum('pending','confirmed') character set utf8 collate utf8_unicode_ci 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',
  `forum_access` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_staffmsg` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_pm` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_comment` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_post` datetime NOT NULL default '0000-00-00 00:00:00',
  `editsecret` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `privacy` enum('strong','normal','low') character set utf8 collate utf8_unicode_ci NOT NULL default 'normal',
  `stylesheet` int(10) default '1',
  `info` text character set utf8 collate utf8_unicode_ci,
  `acceptpms` enum('yes','friends','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `commentpm` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `ip` varchar(15) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `class` tinyint(3) unsigned NOT NULL default '0',
  `avatar` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `title` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `country` int(10) unsigned NOT NULL default '0',
  `notifs` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `modcomment` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `enabled` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `avatars` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `donor` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'no',
  `donated` decimal(8,2) NOT NULL default '0.00',
  `donoruntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `total_donated` decimal(8,2) NOT NULL default '0.00',
  `warned` enum('yes','no') character set utf8 collate utf8_unicode_ci 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') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `savepms` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'no',
  `support` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'no',
  `supportfor` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `supportlang` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,
  `passkey` varchar(32) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `permban` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'no',
  `last_browse` int(11) NOT NULL default '0',
  `uploadpos` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `forumpost` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `downloadpos` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `clientselect` int(10) unsigned default '0',
  `signatures` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'yes',
  `signature` varchar(225) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `tzoffset` int(10) NOT NULL default '0',
  `cheat` smallint(6) NOT NULL default '0',
  `download` int(10) unsigned NOT NULL default '0',
  `upload` int(10) unsigned NOT NULL default '0',
  `invites` int(10) NOT NULL default '4',
  `invited_by` int(10) NOT NULL default '0',
  `gender` enum('Male','Female','N/A') character set utf8 collate utf8_unicode_ci NOT NULL default 'N/A',
  `vip_added` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'no',
  `vip_until` datetime NOT NULL default '0000-00-00 00:00:00',
  `seedbonus` decimal(5,1) NOT NULL default '0.0',
  `bonuscomment` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `parked` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'no',
  `leechwarn` enum('yes','no') character set utf8 collate utf8_unicode_ci NOT NULL default 'no',
  `leechwarnuntil` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastwarned` datetime NOT NULL default '0000-00-00 00:00:00',
  `timeswarned` int(10) NOT NULL default '0',
  `warnedby` varchar(40) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `page` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `passhint` text character set utf8 collate utf8_unicode_ci,
  `hintanswer` text character set utf8 collate utf8_unicode_ci,
  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`),
  KEY `cheat` (`cheat`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=665 ;

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

--
-- Rakenne taululle `userscheck`
--

CREATE TABLE IF NOT EXISTS `userscheck` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `password_again` varchar(32) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `country` int(30) unsigned NOT NULL default '3',
  `you_know` varchar(10) NOT NULL default '',
  `choice` varchar(10) NOT NULL default '',
  `rustracker` int(30) unsigned NOT NULL default '0',
  `trackerusername` varchar(40) NOT NULL default '',
  `download` int(10) unsigned NOT NULL default '0',
  `upload` int(10) unsigned NOT NULL default '0',
  `why_you` varchar(255) default NULL,
  `other_info` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `userscheckvote`
--

CREATE TABLE IF NOT EXISTS `userscheckvote` (
  `id` int(11) NOT NULL auto_increment,
  `comingusergid` int(11) NOT NULL default '0',
  `uservoteid` int(11) NOT NULL default '0',
  `yesno` enum('yes','no') default 'no',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Rakenne taululle `zodiac`
--

CREATE TABLE IF NOT EXISTS `zodiac` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) character set latin1 default NULL,
  `zodiacpic` varchar(50) character set latin1 default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
__________________
Vultr VPS ~ https://www.vultr.com/?ref=8548641
\sudo,yum/
Reply With Quote
  #2  
Old 29th April 2020, 11:56
Krypto's Avatar
Krypto Krypto is offline
Retired from BVList
 
Join Date: Jan 2008
P2P
Posts: 512
Default
What has this got to do with FreeTSP?
__________________
As an Admin I cannot Demote myself so, regardless of what my Userclass says, as of now I'm no longer a Member of BVList.

This Site's Reputation has been Destroyed beyond repair by certain individuals and, like recent members before me
I no longer wish to be associated with these childish tit-for-tat Posts
Reply With Quote
  #3  
Old 29th April 2020, 16:00
Napon's Avatar
Napon Napon is offline
Banned
 
Join Date: Feb 2016
P2P
Posts: 525
Default
lol he post crap and not tell you what its for and what to change ect why post shit that no fucker knows what its for hes good at this
Reply With Quote
  #4  
Old 30th April 2020, 07:47
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Senior Member
 
Join Date: Jul 2013
P2P
Posts: 317
Default
Updated admincp example cross script information already provided change PHP via own empty script you know how to play why shall I explain when all people do is complain.

[PHP]
CREATE TABLE IF NOT EXISTS `userscheck` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(40) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`password_again` varchar(32) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`country` int(30) unsigned NOT NULL default '3',
`you_know` varchar(10) NOT NULL default '',
`choice` varchar(10) NOT NULL default '',
`rustracker` int(30) unsigned NOT NULL default '0',
`trackerusername` varchar(40) NOT NULL default '',
`download` int(10) unsigned NOT NULL default '0',
`upload` int(10) unsigned NOT NULL default '0',
`why_you` varchar(255) default NULL,
`other_info` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[PHP]

usercp.php add inside maybe?
__________________
Vultr VPS ~ https://www.vultr.com/?ref=8548641
\sudo,yum/
Reply With Quote
  #5  
Old 30th April 2020, 08:12
fireknight's Avatar
fireknight fireknight is offline
Moderator
 
Join Date: Aug 2010
Australia
Posts: 166
Default
Neither I or Krypto have complained.
Reply With Quote
  #6  
Old 30th April 2020, 11:24
Krypto's Avatar
Krypto Krypto is offline
Retired from BVList
 
Join Date: Jan 2008
P2P
Posts: 512
Question
All I'm going to say on this is again what does this have to do with FreeTSP? Posting a dump of a DB structure tells me nothing!!

Quote:
Originally Posted by BamBam0077 View Post
Updated admincp example cross script information already provided change PHP via own empty script you know how to play why shall I explain when all people do is complain.
usercp.php add inside maybe?
Again this is another example of not explaining things clearly, what are we supposed to put what inside admincp.php and usercp.php

I'm trying to be constructive here but if you think this is complaining then so be it.

Sorry but if you can't or won't put a proper explanation then I see no point in posting things like this as they serve no purpose and they'll be removed in due course.
__________________
As an Admin I cannot Demote myself so, regardless of what my Userclass says, as of now I'm no longer a Member of BVList.

This Site's Reputation has been Destroyed beyond repair by certain individuals and, like recent members before me
I no longer wish to be associated with these childish tit-for-tat Posts
Reply With Quote
The Following User Says Thank You to Krypto For This Useful Post:
Napon (30th April 2020)
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 18:53. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2020, vBulletin Solutions Inc.