3err0
/
sibtracker
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
sibtracker/schema.sql

918 lines
30 KiB
Raw Permalink Blame History

/*!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 cp1251 */;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_banned`
--
CREATE TABLE IF NOT EXISTS `cms_banned` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`users_id` mediumint(8) NOT NULL DEFAULT '0',
`descr` text NOT NULL,
`date` varchar(15) NOT NULL DEFAULT '',
`days` smallint(4) NOT NULL DEFAULT '0',
`ip` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `user_id` (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_category`
--
CREATE TABLE IF NOT EXISTS `cms_category` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`parentid` smallint(5) NOT NULL DEFAULT '0',
`posi` smallint(5) NOT NULL DEFAULT '1',
`name` varchar(50) NOT NULL DEFAULT '',
`alt_name` varchar(50) NOT NULL DEFAULT '',
`descr` varchar(200) NOT NULL DEFAULT '',
`keywords` text NOT NULL,
`news_sort` varchar(10) NOT NULL DEFAULT '',
`news_msort` varchar(4) NOT NULL DEFAULT '',
`news_number` smallint(5) NOT NULL DEFAULT '0',
`metatitle` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_chat`
--
CREATE TABLE IF NOT EXISTS `cms_chat` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`message` text NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ip` varchar(16) NOT NULL DEFAULT '',
`user_id` mediumint(8) NOT NULL DEFAULT '0',
`mgroup` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_comments`
--
CREATE TABLE IF NOT EXISTS `cms_comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`post_id` int(11) NOT NULL DEFAULT '0',
`user_id` mediumint(8) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`autor` varchar(40) NOT NULL DEFAULT '',
`email` varchar(40) NOT NULL DEFAULT '',
`text` text NOT NULL,
`ip` varchar(16) NOT NULL DEFAULT '',
`is_register` tinyint(1) NOT NULL DEFAULT '0',
`rating` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_covers`
--
CREATE TABLE IF NOT EXISTS `cms_covers` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`newsid` int(10) NOT NULL,
`link` varchar(1000) NOT NULL,
`thumb` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_email`
--
CREATE TABLE IF NOT EXISTS `cms_email` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(10) NOT NULL DEFAULT '',
`template` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_files`
--
CREATE TABLE IF NOT EXISTS `cms_files` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`news_id` int(10) NOT NULL DEFAULT '0',
`name` varchar(250) NOT NULL DEFAULT '',
`onserver` varchar(250) NOT NULL DEFAULT '',
`author` varchar(40) NOT NULL DEFAULT '',
`date` varchar(15) NOT NULL DEFAULT '',
`dcount` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_category`
--
CREATE TABLE IF NOT EXISTS `cms_forum_category` (
`sid` int(11) NOT NULL AUTO_INCREMENT,
`cat_name` varchar(128) NOT NULL DEFAULT '',
`posi` tinyint(3) NOT NULL DEFAULT '0',
KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_email`
--
CREATE TABLE IF NOT EXISTS `cms_forum_email` (
`id` int(11) NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL DEFAULT '',
`template` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_files`
--
CREATE TABLE IF NOT EXISTS `cms_forum_files` (
`file_id` int(11) NOT NULL AUTO_INCREMENT,
`file_type` varchar(10) NOT NULL DEFAULT '',
`forum_id` int(11) NOT NULL DEFAULT '0',
`topic_id` int(11) NOT NULL DEFAULT '0',
`post_id` int(11) NOT NULL DEFAULT '0',
`file_attach` tinyint(1) NOT NULL DEFAULT '0',
`file_name` varchar(250) NOT NULL DEFAULT '',
`onserver` varchar(250) NOT NULL DEFAULT '',
`file_author` varchar(40) NOT NULL DEFAULT '',
`file_date` int(10) NOT NULL DEFAULT '0',
`file_size` int(11) NOT NULL DEFAULT '0',
`dcount` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_forums`
--
CREATE TABLE IF NOT EXISTS `cms_forum_forums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parentid` int(11) NOT NULL DEFAULT '0',
`main_id` int(11) NOT NULL DEFAULT '0',
`topics` mediumint(6) NOT NULL DEFAULT '0',
`posts` mediumint(6) NOT NULL DEFAULT '0',
`name` varchar(128) NOT NULL DEFAULT '',
`description` text NOT NULL,
`position` tinyint(3) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`access_read` varchar(150) NOT NULL DEFAULT '',
`access_write` varchar(150) NOT NULL DEFAULT '',
`access_mod` varchar(150) NOT NULL DEFAULT '',
`access_topic` varchar(150) NOT NULL DEFAULT '',
`access_upload` varchar(150) NOT NULL DEFAULT '',
`access_download` varchar(150) NOT NULL DEFAULT '',
`f_last_tid` smallint(5) NOT NULL DEFAULT '0',
`f_last_title` varchar(70) NOT NULL DEFAULT '',
`f_last_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`f_last_poster_name` varchar(40) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`rules_title` varchar(128) NOT NULL DEFAULT '',
`rules` text NOT NULL,
`icon` varchar(40) NOT NULL DEFAULT '',
`moderators` varchar(150) NOT NULL DEFAULT '',
`postcount` tinyint(1) NOT NULL DEFAULT '1',
`fixpost` tinyint(1) NOT NULL DEFAULT '0',
`last_post_id` int(11) NOT NULL DEFAULT '0',
`banner` text NOT NULL,
`q_reply` tinyint(1) NOT NULL DEFAULT '1',
`i_edit` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_moderators`
--
CREATE TABLE IF NOT EXISTS `cms_forum_moderators` (
`mid` mediumint(8) NOT NULL AUTO_INCREMENT,
`forum_id` int(11) NOT NULL DEFAULT '0',
`member_name` varchar(32) NOT NULL DEFAULT '',
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`edit_post` tinyint(1) DEFAULT NULL,
`edit_topic` tinyint(1) DEFAULT NULL,
`delete_post` tinyint(1) DEFAULT NULL,
`delete_topic` tinyint(1) DEFAULT NULL,
`open_topic` tinyint(1) NOT NULL DEFAULT '0',
`close_topic` tinyint(1) DEFAULT NULL,
`mass_prune` tinyint(1) DEFAULT NULL,
`move_topic` tinyint(1) DEFAULT NULL,
`pin_topic` tinyint(1) DEFAULT NULL,
`unpin_topic` tinyint(1) DEFAULT NULL,
`is_group` tinyint(1) DEFAULT '0',
`group_id` smallint(3) DEFAULT NULL,
`combining_post` tinyint(1) NOT NULL DEFAULT '0',
`move_post` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `forum_id` (`forum_id`),
KEY `group_id` (`group_id`),
KEY `member_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_poll_log`
--
CREATE TABLE IF NOT EXISTS `cms_forum_poll_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`topic_id` int(10) unsigned NOT NULL DEFAULT '0',
`member` varchar(30) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `news_id` (`topic_id`,`member`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_posts`
--
CREATE TABLE IF NOT EXISTS `cms_forum_posts` (
`pid` int(11) NOT NULL AUTO_INCREMENT,
`topic_id` int(11) NOT NULL DEFAULT '0',
`post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`post_author` varchar(40) NOT NULL DEFAULT '',
`post_text` text NOT NULL,
`post_ip` varchar(16) NOT NULL DEFAULT '',
`is_register` tinyint(1) NOT NULL DEFAULT '0',
`e_mail` varchar(40) NOT NULL DEFAULT '',
`edit_user` varchar(40) NOT NULL DEFAULT '0',
`edit_time` int(10) NOT NULL DEFAULT '0',
`hidden` tinyint(1) NOT NULL DEFAULT '0',
`is_count` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_sessions`
--
CREATE TABLE IF NOT EXISTS `cms_forum_sessions` (
`id` varchar(60) NOT NULL DEFAULT '0',
`member_name` varchar(64) NOT NULL DEFAULT '',
`user_group` int(11) NOT NULL DEFAULT '5',
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`ip` varchar(16) NOT NULL DEFAULT '',
`browser` varchar(200) NOT NULL DEFAULT '',
`running_time` int(10) NOT NULL DEFAULT '0',
`location` varchar(40) NOT NULL DEFAULT '',
`act_index` int(10) NOT NULL DEFAULT '0',
`act_forum` int(10) NOT NULL DEFAULT '0',
`act_topic` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `act_topic` (`act_topic`),
KEY `act_forum` (`act_forum`),
KEY `act_index` (`act_index`),
KEY `running_time` (`running_time`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_subscription`
--
CREATE TABLE IF NOT EXISTS `cms_forum_subscription` (
`sid` int(11) NOT NULL AUTO_INCREMENT,
`user_id` mediumint(8) NOT NULL DEFAULT '0',
`topic_id` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_titles`
--
CREATE TABLE IF NOT EXISTS `cms_forum_titles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`posts` int(11) NOT NULL DEFAULT '0',
`title` varchar(128) NOT NULL DEFAULT '',
`pips` varchar(128) NOT NULL DEFAULT '',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_topics`
--
CREATE TABLE IF NOT EXISTS `cms_forum_topics` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`forum_id` int(11) NOT NULL DEFAULT '0',
`title` varchar(70) NOT NULL DEFAULT '',
`topic_descr` varchar(70) NOT NULL DEFAULT '',
`post` int(11) NOT NULL DEFAULT '0',
`views` int(11) NOT NULL DEFAULT '0',
`author_topic` varchar(40) NOT NULL DEFAULT '',
`start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_poster_name` varchar(40) NOT NULL DEFAULT '',
`topic_status` int(1) NOT NULL DEFAULT '0',
`hidden` int(1) NOT NULL DEFAULT '0',
`fixed` int(1) NOT NULL DEFAULT '1',
`poll_title` varchar(200) NOT NULL DEFAULT '',
`frage` varchar(200) NOT NULL DEFAULT '',
`poll_body` text NOT NULL,
`poll_count` mediumint(8) NOT NULL DEFAULT '0',
`answer` varchar(150) NOT NULL DEFAULT '',
`multiple` tinyint(1) NOT NULL DEFAULT '0',
`meta_descr` varchar(200) DEFAULT NULL,
`meta_keywords` text,
`first_post` int(11) NOT NULL DEFAULT '0',
`last_post_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_forum_views`
--
CREATE TABLE IF NOT EXISTS `cms_forum_views` (
`topic_id` int(11) NOT NULL DEFAULT '0',
`forum_id` int(11) NOT NULL DEFAULT '0',
`user_id` mediumint(8) NOT NULL DEFAULT '0',
`time` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_images`
--
CREATE TABLE IF NOT EXISTS `cms_images` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`images` text NOT NULL,
`news_id` int(10) NOT NULL DEFAULT '0',
`author` varchar(40) NOT NULL DEFAULT '',
`date` varchar(15) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `author` (`author`),
KEY `news_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_lostdb`
--
CREATE TABLE IF NOT EXISTS `cms_lostdb` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`lostname` mediumint(8) NOT NULL DEFAULT '0',
`lostid` varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `lostid` (`lostid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_online`
--
CREATE TABLE IF NOT EXISTS `cms_online` (
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`session` char(32) NOT NULL,
`lastdate` int(10) unsigned NOT NULL DEFAULT '0',
`useragent` char(255) NOT NULL,
`ip` char(15) DEFAULT NULL,
PRIMARY KEY (`session`),
KEY `idx` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_pm`
--
CREATE TABLE IF NOT EXISTS `cms_pm` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`subj` varchar(255) NOT NULL DEFAULT '',
`text` text NOT NULL,
`user` mediumint(8) NOT NULL DEFAULT '0',
`user_from` varchar(50) NOT NULL DEFAULT '',
`date` varchar(15) NOT NULL DEFAULT '',
`pm_read` char(3) NOT NULL DEFAULT '',
`folder` varchar(10) NOT NULL DEFAULT '',
`reply` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `folder` (`folder`),
KEY `user` (`user`),
KEY `user_from` (`user_from`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_poll`
--
CREATE TABLE IF NOT EXISTS `cms_poll` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`news_id` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(200) NOT NULL DEFAULT '',
`frage` varchar(200) NOT NULL DEFAULT '',
`body` text NOT NULL,
`votes` mediumint(8) NOT NULL DEFAULT '0',
`multiple` tinyint(1) NOT NULL DEFAULT '0',
`answer` varchar(150) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_poll_log`
--
CREATE TABLE IF NOT EXISTS `cms_poll_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`news_id` int(10) unsigned NOT NULL DEFAULT '0',
`member` varchar(30) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`,`member`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_post`
--
CREATE TABLE IF NOT EXISTS `cms_post` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`autor` varchar(40) NOT NULL DEFAULT '',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`short_story` text NOT NULL,
`full_story` text NOT NULL,
`title` varchar(255) NOT NULL DEFAULT '',
`descr` varchar(200) NOT NULL DEFAULT '',
`keywords` text NOT NULL,
`category` varchar(200) NOT NULL DEFAULT '0',
`alt_name` varchar(200) NOT NULL DEFAULT '',
`comm_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
`allow_comm` tinyint(1) NOT NULL DEFAULT '1',
`allow_main` tinyint(1) unsigned NOT NULL DEFAULT '1',
`allow_rate` tinyint(1) unsigned NOT NULL DEFAULT '1',
`approve` tinyint(1) NOT NULL DEFAULT '0',
`fixed` tinyint(1) NOT NULL DEFAULT '0',
`rating` smallint(5) NOT NULL DEFAULT '0',
`news_read` mediumint(8) unsigned NOT NULL DEFAULT '0',
`votes` tinyint(1) NOT NULL DEFAULT '0',
`access` varchar(150) NOT NULL DEFAULT '',
`remote_addr` varchar(255) NOT NULL,
`editdate` varchar(15) NOT NULL DEFAULT '',
`tags` varchar(255) NOT NULL DEFAULT '',
`metatitle` varchar(255) NOT NULL DEFAULT '',
`news_tid` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `autor` (`autor`),
KEY `alt_name` (`alt_name`),
KEY `category` (`category`),
KEY `approve` (`approve`),
KEY `allow_main` (`allow_main`),
KEY `date` (`date`),
KEY `comm_num` (`comm_num`),
KEY `tags` (`tags`),
FULLTEXT KEY `short_story` (`short_story`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_rate`
--
CREATE TABLE IF NOT EXISTS `cms_rate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type_id` int(10) NOT NULL DEFAULT '0',
`member` varchar(40) NOT NULL DEFAULT '',
`rating` int(1) NOT NULL DEFAULT '0',
`type` int(1) NOT NULL DEFAULT '1',
`date` varchar(15) NOT NULL,
`ip` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `news_id` (`type_id`),
KEY `member` (`member`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_reputation`
--
CREATE TABLE IF NOT EXISTS `cms_reputation` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`how` tinytext NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`author` varchar(40) NOT NULL DEFAULT '',
`komu` varchar(40) NOT NULL DEFAULT '',
`text` text NOT NULL,
`url_page` text NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_static`
--
CREATE TABLE IF NOT EXISTS `cms_static` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`descr` varchar(255) NOT NULL DEFAULT '',
`template` text NOT NULL,
`allow_br` tinyint(1) NOT NULL DEFAULT '0',
`grouplevel` varchar(100) NOT NULL DEFAULT 'all',
`metadescr` varchar(200) NOT NULL DEFAULT '',
`metakeys` text NOT NULL,
`views` mediumint(8) NOT NULL DEFAULT '0',
`date` varchar(15) NOT NULL DEFAULT '',
`metatitle` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `name` (`name`),
FULLTEXT KEY `template` (`template`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_static_files`
--
CREATE TABLE IF NOT EXISTS `cms_static_files` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`static_id` mediumint(8) NOT NULL DEFAULT '0',
`author` varchar(40) NOT NULL DEFAULT '',
`date` varchar(50) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`onserver` varchar(255) NOT NULL DEFAULT '',
`dcount` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `static_id` (`static_id`),
KEY `onserver` (`onserver`),
KEY `author` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_subscribe`
--
CREATE TABLE IF NOT EXISTS `cms_subscribe` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`news_id` int(11) NOT NULL DEFAULT '0',
`hash` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_table`
--
CREATE TABLE IF NOT EXISTS `cms_table` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`date` varchar(15) NOT NULL DEFAULT '',
`autor` varchar(40) NOT NULL DEFAULT '',
`runame` varchar(40) NOT NULL DEFAULT '',
`enname` varchar(40) NOT NULL DEFAULT '',
`fileyear` varchar(4) NOT NULL DEFAULT '0000',
`category` varchar(20) NOT NULL DEFAULT '',
`answer` text,
`status` tinyint(1) NOT NULL DEFAULT '0',
`editor` varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_tags`
--
CREATE TABLE IF NOT EXISTS `cms_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news_id` int(11) NOT NULL DEFAULT '0',
`tag` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`),
KEY `tag` (`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_torrents`
--
CREATE TABLE IF NOT EXISTS `cms_torrents` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`news_id` int(10) NOT NULL DEFAULT '0',
`name` varchar(250) NOT NULL DEFAULT '',
`onserver` varchar(250) NOT NULL DEFAULT '',
`author` varchar(40) NOT NULL DEFAULT '',
`dcount` smallint(5) NOT NULL,
`info_hash` blob NOT NULL,
`size` bigint(20) NOT NULL,
`gold` tinyint(4) NOT NULL DEFAULT '0',
`leechers` int(11) NOT NULL DEFAULT '0',
`seeders` int(11) NOT NULL DEFAULT '0',
`completed` int(11) NOT NULL DEFAULT '0',
`flags` int(11) NOT NULL DEFAULT '0',
`mtime` int(11) NOT NULL,
`ctime` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_usergroups`
--
CREATE TABLE IF NOT EXISTS `cms_usergroups` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`group_name` varchar(32) NOT NULL DEFAULT '',
`colour` varchar(40) NOT NULL,
`allow_cats` text NOT NULL,
`allow_adds` tinyint(1) NOT NULL DEFAULT '1',
`cat_add` text NOT NULL,
`allow_admin` tinyint(1) NOT NULL DEFAULT '0',
`allow_addc` tinyint(1) NOT NULL DEFAULT '0',
`allow_editc` tinyint(1) NOT NULL DEFAULT '0',
`allow_delc` tinyint(1) NOT NULL DEFAULT '0',
`edit_allc` tinyint(1) NOT NULL DEFAULT '0',
`del_allc` tinyint(1) NOT NULL DEFAULT '0',
`moderation` tinyint(1) NOT NULL DEFAULT '0',
`allow_all_edit` tinyint(1) NOT NULL DEFAULT '0',
`allow_edit` tinyint(1) NOT NULL DEFAULT '0',
`allow_pm` tinyint(1) NOT NULL DEFAULT '0',
`max_foto` varchar(10) NOT NULL DEFAULT '',
`allow_files` tinyint(1) NOT NULL DEFAULT '1',
`allow_hide` tinyint(1) NOT NULL DEFAULT '1',
`allow_short` tinyint(1) NOT NULL DEFAULT '0',
`allow_fixed` tinyint(1) NOT NULL DEFAULT '0',
`allow_feed` tinyint(1) NOT NULL DEFAULT '1',
`allow_search` tinyint(1) NOT NULL DEFAULT '1',
`allow_poll` tinyint(1) NOT NULL DEFAULT '1',
`allow_main` tinyint(1) NOT NULL DEFAULT '1',
`allow_rating` tinyint(1) NOT NULL DEFAULT '1',
`allow_offline` tinyint(1) NOT NULL DEFAULT '0',
`allow_image_upload` tinyint(1) NOT NULL DEFAULT '0',
`allow_file_upload` tinyint(1) NOT NULL DEFAULT '0',
`allow_tor_upload` tinyint(1) NOT NULL DEFAULT '0',
`allow_signature` tinyint(1) NOT NULL DEFAULT '0',
`allow_url` tinyint(1) NOT NULL DEFAULT '1',
`allow_image` tinyint(1) NOT NULL DEFAULT '0',
`max_signature` smallint(6) NOT NULL DEFAULT '0',
`max_info` smallint(6) NOT NULL DEFAULT '0',
`forum_post_edit` tinyint(1) NOT NULL DEFAULT '0',
`forum_post_del` tinyint(1) NOT NULL DEFAULT '0',
`forum_topic_set` tinyint(1) NOT NULL DEFAULT '0',
`forum_topic_edit` tinyint(1) NOT NULL DEFAULT '0',
`forum_topic_del` tinyint(1) NOT NULL DEFAULT '0',
`admin_addnews` tinyint(1) NOT NULL DEFAULT '0',
`admin_editnews` tinyint(1) NOT NULL DEFAULT '0',
`admin_categories` tinyint(1) NOT NULL DEFAULT '0',
`admin_editusers` tinyint(1) NOT NULL DEFAULT '0',
`admin_wordfilter` tinyint(1) NOT NULL DEFAULT '0',
`admin_static` tinyint(1) NOT NULL DEFAULT '0',
`admin_blockip` tinyint(1) NOT NULL DEFAULT '0',
`admin_iptools` tinyint(1) NOT NULL DEFAULT '0',
`admin_googlemap` tinyint(1) NOT NULL DEFAULT '0',
`admin_table` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_users`
--
CREATE TABLE IF NOT EXISTS `cms_users` (
`email` varchar(50) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`name` varchar(40) NOT NULL DEFAULT '',
`user_id` mediumint(8) NOT NULL AUTO_INCREMENT,
`time_zone` int(11) NOT NULL DEFAULT '0',
`news_num` smallint(6) NOT NULL DEFAULT '0',
`comm_num` mediumint(8) NOT NULL DEFAULT '0',
`user_group` smallint(5) NOT NULL DEFAULT '4',
`status` varchar(50) NOT NULL,
`lastdate` varchar(20) DEFAULT NULL,
`reg_date` varchar(20) DEFAULT NULL,
`banned` varchar(5) NOT NULL DEFAULT '',
`allow_mail` tinyint(1) NOT NULL DEFAULT '1',
`info` text NOT NULL,
`signature` text NOT NULL,
`foto` varchar(30) NOT NULL DEFAULT '',
`fullname` varchar(100) NOT NULL DEFAULT '',
`land` varchar(100) NOT NULL DEFAULT '',
`icq` varchar(20) NOT NULL DEFAULT '',
`skype` varchar(32) NOT NULL,
`favorites` text NOT NULL,
`pm_all` smallint(5) NOT NULL DEFAULT '0',
`pm_unread` smallint(5) NOT NULL DEFAULT '0',
`allowed_ip` varchar(255) NOT NULL DEFAULT '',
`hash` varchar(32) NOT NULL DEFAULT '',
`logged_ip` varchar(16) NOT NULL DEFAULT '',
`restricted` tinyint(1) NOT NULL DEFAULT '0',
`restricted_days` smallint(4) NOT NULL DEFAULT '0',
`restricted_date` varchar(15) NOT NULL DEFAULT '',
`mail_lc` tinyint(1) NOT NULL DEFAULT '1',
`birthday` text NOT NULL,
`sex` int(1) NOT NULL,
`repa` mediumint(8) DEFAULT '0',
`repa_mod` varchar(20) NOT NULL DEFAULT '0|0',
`repa_off` tinyint(1) DEFAULT '0',
`r_freeze` varchar(5) NOT NULL,
`photo` varchar(30) NOT NULL,
`can_leech` tinyint(4) NOT NULL DEFAULT '1',
`wait_time` int(11) NOT NULL DEFAULT '0',
`torrent_pass_version` int(11) NOT NULL,
`downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`forum_post` smallint(5) NOT NULL DEFAULT '0',
`forum_update` varchar(20) NOT NULL DEFAULT '0',
`forum_rank` varchar(40) NOT NULL DEFAULT '0',
`forum_pips` smallint(2) NOT NULL DEFAULT '0',
`forum_last` varchar(20) NOT NULL DEFAULT '0',
`forum_time` varchar(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `cms_users_friends`
--
CREATE TABLE IF NOT EXISTS `cms_users_friends` (
`user_id` mediumint(9) NOT NULL DEFAULT '0',
`friend_id` mediumint(9) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`approve` tinyint(1) NOT NULL DEFAULT '0',
`porder` mediumint(2) NOT NULL DEFAULT '0',
KEY `approve` (`approve`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `xbt_config`
--
CREATE TABLE IF NOT EXISTS `xbt_config` (
`name` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Äàìï äàííûõ òàáëèöû `xbt_config`
--
INSERT INTO `xbt_config` (`name`, `value`) VALUES
('announce_interval', '1800'),
('anonymous_announce', '1'),
('vip_group', '6'),
('anonymous_scrape', '0'),
('auto_register', '0'),
('clean_up_interval', '300'),
('column_files_completed', 'completed'),
('column_files_fid', 'id'),
('column_files_leechers', 'leechers'),
('column_files_seeders', 'seeders'),
('column_users_uid', 'user_id'),
('daemon', '1'),
('debug', '0'),
('full_scrape', '0'),
('freeday', '0'),
('gzip_scrape', '1'),
('listen_port', '2710'),
('log_access', '0'),
('log_announce', '0'),
('log_scrape', '0'),
('offline_message', ''),
('pid_file', '/var/run/xbt.pid'),
('query_log', ''),
('read_config_interval', '60'),
('read_db_interval', '60'),
('redirect_url', 'http://files-sib.net'),
('scrape_interval', '0'),
('table_files', 'cms_torrents'),
('table_users', 'cms_users'),
('write_db_interval', '15'),
('table_announce_log', 'xbt_announce_log'),
('cheaters', '0'),
('cheater_speed', '8388608'),
('freedaystart', '0'),
('freedaystop', '0'),
('torrent_pass_private_key', '');
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `xbt_deny_from_hosts`
--
CREATE TABLE IF NOT EXISTS `xbt_deny_from_hosts` (
`begin` int(10) unsigned NOT NULL,
`end` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- --------------------------------------------------------
--
-- Ñòðóêòóðà òàáëèöû `xbt_files_users`
--
CREATE TABLE IF NOT EXISTS `xbt_files_users` (
`fid` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`active` tinyint(4) NOT NULL,
`announced` int(11) NOT NULL,
`completed` int(11) NOT NULL,
`downloaded` bigint(20) unsigned NOT NULL,
`left` bigint(20) unsigned NOT NULL,
`uploaded` bigint(20) unsigned NOT NULL,
`mtime` int(11) NOT NULL,
`timespent` int(11) NOT NULL,
`down_speed` int(11) NOT NULL,
`up_speed` int(11) NOT NULL,
`ipa` varchar(255) NOT NULL,
`port` int(11) NOT NULL,
`downloadedz` bigint(11) unsigned NOT NULL,
`uploadedz` bigint(11) unsigned NOT NULL,
UNIQUE KEY `fid` (`fid`,`uid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Reference in new issue View Git Blame Copy Permalink