Unnamed

CREATE TABLE `topten_type` (  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,  `group` TINYINT UNSIGNED NOT NULL DEFAULT 1,  `name` VARCHAR(255)  NOT NULL DEFAULT '',  `desc` VARCHAR(255)  DEFAULT '',  `enabled` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,  PRIMARY KEY(`id`))ENGINE = InnoDB;CREATE TABLE `topten_user` (  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,  `topten_type` TINYINT UNSIGNED NOT NULL DEFAULT 1,  `userid` INT(10) UNSIGNED NOT NULL,  `dl_bytes` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,  `ul_bytes` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,  `dl_speed` INT(10) UNSIGNED NOT NULL DEFAULT 0,  `ul_speed` INT(10) UNSIGNED NOT NULL DEFAULT 0,  `ratio` DECIMAL(8,2) UNSIGNED NOT NULL DEFAULT 0,  `joined` DATETIME  NOT NULL DEFAULT '0000-00-00 00:00:00',  PRIMARY KEY(`id`))ENGINE = InnoDB;CREATE TABLE `topten_torrent` (  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,  `topten_type` TINYINT UNSIGNED NOT NULL DEFAULT 0,  `torrentid` INT(10) UNSIGNED NOT NULL DEFAULT 0,  `total_snatches` INT(10) UNSIGNED NOT NULL DEFAULT 0,  `total_seeders` INT(10) UNSIGNED NOT NULL DEFAULT 0,  `total_downloaders` INT(10) UNSIGNED NOT NULL DEFAULT 0,  `total_bytes` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,  `ratio` DECIMAL(8,2) UNSIGNED DEFAULT 0,  PRIMARY KEY(`id`))ENGINE = InnoDB;CREATE TABLE `topten_country` (  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,  `topten_type` TINYINT UNSIGNED NOT NULL DEFAULT 1,  `countryid` TINYINT UNSIGNED NOT NULL DEFAULT 105,  `total` BIGINT(20) UNSIGNED DEFAULT 0,  PRIMARY KEY(`id`))ENGINE = InnoDB;CREATE TABLE `topten_client` (  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,  `topten_type` TINYINT UNSIGNED NOT NULL DEFAULT 1,  `client` VARCHAR(255)  DEFAULT '',  `total` INT UNSIGNED NOT NULL DEFAULT 0,  PRIMARY KEY(`id`))ENGINE = InnoDB;