-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 15, 2013 at 06:55 PM
-- 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=1 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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,
`userimport` int(1) NOT NULL,
`email_ver` int(1) NOT NULL,
`advertiser` varchar(50) 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`, `userimport`, `email_ver`, `advertiser`) VALUES
(1, 'edward', 'russian', 10, 2, 10, 100, 'zip|mp3|mp4|3gp|jpg|gif|png', 0, 0, 1, 1, 0, 1, 'advertiser.com/dfgdfg/');
-- --------------------------------------------------------
--
-- 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=1 ;
-- --------------------------------------------------------
--
-- 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,
`rating` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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=1 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- Table structure for table `from`
--
CREATE TABLE IF NOT EXISTS `from` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` text COLLATE utf8_unicode_ci NOT NULL,
`url` text COLLATE utf8_unicode_ci NOT NULL,
`ip` text COLLATE utf8_unicode_ci NOT NULL,
`per` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- Table structure for table `logs_from`
--
CREATE TABLE IF NOT EXISTS `logs_from` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(50) NOT NULL,
`ip` varchar(50) NOT NULL,
`per` int(11) NOT NULL,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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 `status`
--
CREATE TABLE IF NOT EXISTS `status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`min_karma` int(11) NOT NULL,
`max_karma` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
`status` varchar(25) NOT NULL,
`avatar` int(11) NOT NULL,
`avatar_photo` int(1) NOT NULL,
`email_ver` varchar(10) NOT NULL,
`ok` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `users`
--