View file install/cc.sql

File size: 17.67Kb
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 21, 2013 at 09:18 AM
-- Server version: 5.5.25
-- PHP Version: 5.2.12

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `coolcms`
--

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

--
-- Table structure for table `ad`
--

CREATE TABLE IF NOT EXISTS `ad` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `link` varchar(100) NOT NULL,
  `type` int(1) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2;

INSERT INTO `ad` (`id`, `name`, `link`, `type`, `time`) VALUES
(1, 'Наши партнеры', '../index.php?act=ourpartners', 1, 1374218235);

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

--
-- Table structure for table `adminchat`
--

CREATE TABLE IF NOT EXISTS `adminchat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `avatars`
--

CREATE TABLE IF NOT EXISTS `avatars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;

--
-- Dumping data for table `avatars`
--

INSERT INTO `avatars` (`id`, `path`) VALUES
(1, 'images/avatars/1.gif'),
(2, 'images/avatars/2.gif'),
(3, 'images/avatars/3.gif'),
(4, 'images/avatars/4.gif'),
(5, 'images/avatars/5.gif'),
(6, 'images/avatars/6.gif'),
(7, 'images/avatars/7.gif'),
(8, 'images/avatars/8.gif'),
(9, 'images/avatars/9.gif'),
(10, 'images/avatars/10.gif'),
(11, 'images/avatars/11.gif'),
(12, 'images/avatars/12.gif'),
(13, 'images/avatars/13.gif'),
(14, 'images/avatars/14.gif'),
(15, 'images/avatars/15.gif'),
(16, 'images/avatars/16.gif'),
(17, 'images/avatars/17.gif'),
(18, 'images/avatars/18.gif'),
(19, 'images/avatars/19.gif'),
(20, 'images/avatars/20.gif'),
(21, 'images/avatars/21.gif'),
(22, 'images/avatars/22.gif'),
(23, 'images/avatars/23.gif'),
(24, 'images/avatars/24.gif'),
(25, 'images/avatars/25.gif'),
(26, 'images/avatars/26.gif'),
(27, 'images/avatars/27.png'),
(28, 'images/avatars/28.png'),
(29, 'images/avatars/29.jpg'),
(30, 'images/avatars/30.jpg'),
(31, 'images/avatars/31.jpg'),
(32, 'images/avatars/32.jpg'),
(33, 'images/avatars/33.jpg'),
(34, 'images/avatars/34.jpg'),
(35, 'images/avatars/35.jpg'),
(36, 'images/avatars/36.jpg'),
(37, 'images/avatars/37.gif');

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

--
-- Table structure for table `ban`
--

CREATE TABLE IF NOT EXISTS `ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `until` int(10) NOT NULL,
  `reason` varchar(250) NOT NULL,
  `by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `blacklist`
--

CREATE TABLE IF NOT EXISTS `blacklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `blacklisted_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `blogs`
--

CREATE TABLE IF NOT EXISTS `blogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `text` text NOT NULL,
  `time` int(10) NOT NULL,
  `seen` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `blogs_cats`
--

CREATE TABLE IF NOT EXISTS `blogs_cats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `blogs_comm`
--

CREATE TABLE IF NOT EXISTS `blogs_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_blogs` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `book`
--

CREATE TABLE IF NOT EXISTS `book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `book`
--

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

--
-- Table structure for table `chat`
--

CREATE TABLE IF NOT EXISTS `chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
  `style` varchar(15) NOT NULL,
  `language` varchar(10) NOT NULL,
  `onpage` int(2) NOT NULL,
  `antispam` int(3) NOT NULL,
  `edit_time` int(4) NOT NULL,
  `kick` int(3) NOT NULL,
  `allowed_ext` varchar(200) NOT NULL,
  `regoff` int(1) NOT NULL,
  `cache_counters` int(5) NOT NULL,
  `activation` int(1) NOT NULL,
  `duplicate` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`id`, `style`, `language`, `onpage`, `antispam`, `edit_time`, `kick`, `allowed_ext`, `regoff`, `cache_counters`, `activation`, `duplicate`) VALUES
(1, 'edward', 'russian', 10, 2, 10, 100, 'zip|mp3|mp4|3gp|jpg|gif|png', 0, 0, 0, 1);

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

--
-- Table structure for table `forum_cats`
--

CREATE TABLE IF NOT EXISTS `forum_cats` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `order` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `forum_cats`
--

INSERT INTO `forum_cats` (`id`, `name`, `order`) VALUES
(1, 'Тестовый раздел', 0);

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

--
-- Table structure for table `forum_msg`
--

CREATE TABLE IF NOT EXISTS `forum_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `id_subcat` int(11) NOT NULL,
  `id_topic` int(5) NOT NULL,
  `id_user` int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  `votes` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `forum_msg`
--

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

--
-- Table structure for table `forum_subcats`
--

CREATE TABLE IF NOT EXISTS `forum_subcats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `order` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `forum_subcats`
--

INSERT INTO `forum_subcats` (`id`, `id_cat`, `name`, `order`) VALUES
(1, 1, 'Тестовый подраздел', 0);

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

--
-- Table structure for table `forum_topics`
--

CREATE TABLE IF NOT EXISTS `forum_topics` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_cat` int(3) NOT NULL,
  `id_subcat` int(11) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `id_user` int(11) NOT NULL,
  `last_time` int(10) NOT NULL,
  `stuck` int(1) NOT NULL,
  `closed` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `forum_topics`
--

--
-- Table structure for table `loads`
--

CREATE TABLE IF NOT EXISTS `loads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `id_subcat` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `desc` text NOT NULL,
  `author` varchar(20) NOT NULL,
  `site` varchar(20) NOT NULL,
  `file` varchar(50) NOT NULL,
  `screen` varchar(50) NOT NULL,
  `time` int(10) NOT NULL,
  `ok` int(1) NOT NULL,
  `loaded` int(11) NOT NULL,
  `seen` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `loads`
--
-- --------------------------------------------------------

--
-- Table structure for table `loads_cats`
--

CREATE TABLE IF NOT EXISTS `loads_cats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `loads_cats`
--

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

--
-- Table structure for table `loads_comm`
--

CREATE TABLE IF NOT EXISTS `loads_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_loads` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `loads_subcats`
--

CREATE TABLE IF NOT EXISTS `loads_subcats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `path` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `loads_subcats`
--

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

--
-- Table structure for table `my_friends`
--

CREATE TABLE IF NOT EXISTS `my_friends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `is_friend_of` int(11) NOT NULL,
  `ok` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `text` text,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `news`
--

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

--
-- Table structure for table `news_comm`
--

CREATE TABLE IF NOT EXISTS `news_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_news` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `news_comm`
--

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

--
-- Table structure for table `online`
--

CREATE TABLE IF NOT EXISTS `online` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `user_agent` varchar(250) NOT NULL,
  `place` varchar(50) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `online`
--

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

--
-- Table structure for table `photos`
--

CREATE TABLE IF NOT EXISTS `photos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `desc` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `file` varchar(250) NOT NULL,
  `seen` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `photos`
--

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

--
-- Table structure for table `photos_comm`
--

CREATE TABLE IF NOT EXISTS `photos_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_photos` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `pm`
--

CREATE TABLE IF NOT EXISTS `pm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_sender` int(11) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `pm`
--
-- --------------------------------------------------------

--
-- Table structure for table `pm_msg`
--

CREATE TABLE IF NOT EXISTS `pm_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_pm` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `id_sender` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `read` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `pm_msg`
--

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

--
-- Table structure for table `seen`
--

CREATE TABLE IF NOT EXISTS `seen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `id_data` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `seen`
--

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

--
-- Table structure for table `smiles`
--

CREATE TABLE IF NOT EXISTS `smiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `path` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;

--
-- Dumping data for table `smiles`
--

INSERT INTO `smiles` (`id`, `code`, `path`) VALUES
(1, ':)', 'images/smiles/1.gif'),
(2, ':-)', 'images/smiles/2.gif'),
(4, ':sad', 'images/smiles/4.gif'),
(5, ';)', 'images/smiles/5.gif'),
(6, '%0', 'images/smiles/6.gif'),
(7, ':(', 'images/smiles/7.gif'),
(8, ':-(', 'images/smiles/8.gif'),
(9, ':yy', 'images/smiles/9.gif'),
(10, ':sho', 'images/smiles/10.gif'),
(11, ':o_o', 'images/smiles/11.gif'),
(12, ':crazy', 'images/smiles/12.gif'),
(13, ':d', 'images/smiles/13.gif'),
(14, ':-d', 'images/smiles/14.gif'),
(15, ':peace', 'images/smiles/15.gif'),
(16, ':flud', 'images/smiles/16.gif'),
(17, ':closed', 'images/smiles/17.gif'),
(18, ':angry', 'images/smiles/18.gif'),
(19, ':bravo', 'images/smiles/19.gif'),
(20, ':ban', 'images/smiles/20.gif'),
(21, ':f', 'images/smiles/21.gif'),
(22, ':welcome', 'images/smiles/22.gif'),
(23, ':good', 'images/smiles/23.gif'),
(24, ':ubanned', 'images/smiles/24.gif'),
(25, ':spam', 'images/smiles/25.gif'),
(26, ':shut', 'images/smiles/26.gif'),
(27, ':shock', 'images/smiles/27.gif'),
(28, ':read', 'images/smiles/28.gif'),
(29, ':overlook', 'images/smiles/29.gif'),
(30, ':oops', 'images/smiles/30.gif'),
(31, ':?', 'images/smiles/31.gif'),
(32, ':@', 'images/smiles/32.gif'),
(33, ';/', 'images/smiles/33.gif'),
(34, ':off', 'images/smiles/34.gif'),
(35, ':lol', 'images/smiles/35.gif'),
(36, ':hack', 'images/smiles/36.gif'),
(37, ':sorry', 'images/smiles/37.gif');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(12) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `access` int(1) NOT NULL,
  `regtime` int(10) DEFAULT NULL,
  `lastvisit` int(10) NOT NULL,
  `karma` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `from` varchar(25) NOT NULL,
  `icq` int(9) NOT NULL,
  `skype` varchar(32) NOT NULL,
  `site` varchar(20) NOT NULL,
  `birthday` varchar(10) NOT NULL,
  `gender` int(1) NOT NULL,
  `about` varchar(150) DEFAULT NULL,
  `style` varchar(50) NOT NULL,
  `onpage` int(2) NOT NULL,
  `language` varchar(10) NOT NULL,
  `avatar` int(11) NOT NULL,
  `avatar_photo` int(1) NOT NULL,
  `ok` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--

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

--
-- Table structure for table `voting`
--

CREATE TABLE IF NOT EXISTS `voting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `id_data` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;