View file comm/comm.sql

-- 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;