Файл: comm/comm.sql
Строк: 139
-- Wap PhpMyAdmin 211
-- http://master-land.net/phpmyadmin
-- Generation
Time: 2013-10-12 15:47
-- MySQL Server Version: 5.5.29
-- PHP Version:
5.4.10
-- Database: `db1376802715`
--
--------------------------------------------------------
--
-- Table
structure for table `comm`
--
CREATE TABLE `comm` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` text NOT NULL,
`desc` text NOT NULL,
`id_user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT
'0',
`id_cat` int(11) NOT NULL DEFAULT '0',
`visits` int(11) NOT NULL
DEFAULT '0',
`adult` enum('0','1') NOT NULL DEFAULT '0',
`chat`
enum('0','1') NOT NULL DEFAULT '0',
`forum` enum('0','1') NOT NULL
DEFAULT '1',
`files` enum('0','1') NOT NULL DEFAULT '0',
`join_rule`
enum('1','2','3') NOT NULL DEFAULT '1',
`read_rule` enum('1','2') NOT
NULL DEFAULT '1',
`write_rule` enum('1','2') NOT NULL DEFAULT '1',
`chat_rule` enum('1','2') NOT NULL DEFAULT '1',
`deviz` text NOT NULL,
`interests` text NOT NULL,
`rules` text NOT NULL,
`mdi` text,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_ban`
--
CREATE TABLE `comm_ban` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`type` set('1','2','3') NOT NULL DEFAULT
'1',
`time` int(11) NOT NULL,
`id_comm` int(11) NOT NULL,
`id_banned`
int(11) NOT NULL,
`prich` varchar(1024) NOT NULL,
`view` set('1','0')
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_comm`
(`id_comm`,`id_banned`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_blist`
--
CREATE TABLE `comm_blist` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) DEFAULT NULL,
`id_user` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_cat`
--
CREATE TABLE `comm_cat` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`desc` text NOT
NULL,
`pos` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_chat`
--
CREATE TABLE `comm_chat` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL,
`id_user`
int(11) DEFAULT NULL,
`time` int(11) NOT NULL,
`message` varchar(1024)
DEFAULT NULL,
`reply` int(11) DEFAULT NULL,
`reply_msg` text,
`private` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY
`id_comm` (`id_comm`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_files`
--
CREATE TABLE `comm_files` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL,
`id_user`
int(11) DEFAULT NULL,
`id_dir` int(11) DEFAULT NULL,
`time` int(11) NOT
NULL,
`name` varchar(40) DEFAULT NULL,
`ras` varchar(512) DEFAULT
NULL,
`desc` text,
`type` enum('dir','file') DEFAULT NULL,
`counter`
text,
`rating` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY
`id_comm` (`id_comm`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_files_komm`
--
CREATE TABLE `comm_files_komm`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL
DEFAULT '0',
`id_user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT
NULL DEFAULT '0',
`id_file` int(11) NOT NULL DEFAULT '0',
`sk`
enum('0','1') NOT NULL DEFAULT '0',
`sk_user` int(11) NOT NULL DEFAULT
'0',
`id_reply` int(11) NOT NULL DEFAULT '0',
`reply_msg` text,
`msg`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_files_rating`
--
CREATE TABLE
`comm_files_rating` (
`id_file` int(11) NOT NULL,
`id_user` int(11) NOT
NULL,
`id_comm` int(11) NOT NULL,
KEY `id_file` (`id_file`,`id_user`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_forum`
--
CREATE TABLE `comm_forum` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL DEFAULT '0',
`name` text NOT NULL,
`desc` text NOT NULL,
`id_user` int(11) NOT NULL
DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`id_cat` int(11) NOT
NULL DEFAULT '0',
`type` enum('cat','topic') DEFAULT NULL,
`msg` text,
`pos` int(11) NOT NULL DEFAULT '0',
`locked` enum('0','1') NOT NULL
DEFAULT '0',
`locked_user` int(11) NOT NULL DEFAULT '0',
`locked_time`
int(11) NOT NULL DEFAULT '0',
`last_user` int(11) NOT NULL DEFAULT '0',
`last_time` int(11) NOT NULL DEFAULT '0',
`locked_id_user` int(11)
DEFAULT '0',
`last_id_user` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_forum_komm`
--
CREATE TABLE `comm_forum_komm`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL
DEFAULT '0',
`id_user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT
NULL DEFAULT '0',
`id_topic` int(11) NOT NULL DEFAULT '0',
`sk`
enum('0','1') NOT NULL DEFAULT '0',
`sk_user` int(11) NOT NULL DEFAULT
'0',
`id_reply` int(11) NOT NULL DEFAULT '0',
`reply_msg` text,
`msg`
text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_journal`
--
CREATE TABLE `comm_journal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`id_ank` int(11) NOT NULL,
`type`
enum('in_blist','out_blist','in_comm','out_comm','access') DEFAULT NULL,
`access` enum('creator','adm','mod','user') DEFAULT 'user',
`time`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_readmin`
--
CREATE TABLE `comm_readmin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) DEFAULT '0',
`id_user` int(11) DEFAULT '0',
`time` int(11) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_users`
--
CREATE TABLE `comm_users` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL,
`id_user`
int(11) NOT NULL,
`activate` enum('0','1') DEFAULT '1',
`invite`
enum('0','1') DEFAULT '0',
`invite_user` int(11) DEFAULT NULL,
`access`
enum('creator','adm','mod','user') DEFAULT 'user',
`time` int(11) NOT
NULL,
`last_time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_users_ban`
--
CREATE TABLE `comm_users_ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_comm` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`id_ank` int(11) NOT NULL,
`type`
enum('forum','chat') DEFAULT NULL,
`reason` enum('1','2','3','4','5','6')
DEFAULT NULL,
`time_ban` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(512) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `comm_visits`
--
CREATE TABLE `comm_visits` (
`time` int(11) NOT NULL,
`id_comm` int(11) NOT NULL,
`id_user` int(11)
NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;