-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 23, 2012 at 02:58 PM
-- Server version: 5.1.40
-- PHP Version: 5.3.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 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 ;
--
-- Dumping data for table `ad`
--
-- --------------------------------------------------------
--
-- 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 ;
--
-- Dumping data for table `adminchat`
--
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `blogs`
--
-- --------------------------------------------------------
--
-- 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 ;
--
-- Dumping data for table `blogs_cats`
--
-- --------------------------------------------------------
--
-- Table structure for table `book`
--
CREATE TABLE IF NOT EXISTS `book` (
`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 ;
--
-- Dumping data for table `book`
--
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE IF NOT EXISTS `config` (
`id` int(1) NOT NULL AUTO_INCREMENT,
`style` varchar(15) NOT NULL,
`onpage` int(2) NOT NULL,
`antispam` int(3) NOT NULL,
`edit_time` int(4) NOT NULL,
`kick` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `config`
--
INSERT INTO `config` (`id`, `style`, `onpage`, `antispam`, `edit_time`, `kick`) VALUES
(1, 'red', 10, 1, 10, 10);
-- --------------------------------------------------------
--
-- Table structure for table `contacts`
--
CREATE TABLE IF NOT EXISTS `contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`is_contact_for` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `contacts`
--
-- --------------------------------------------------------
--
-- Table structure for table `forum_cats`
--
CREATE TABLE IF NOT EXISTS `forum_cats` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `forum_cats`
--
-- --------------------------------------------------------
--
-- 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(50) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `forum_subcats`
--
-- --------------------------------------------------------
--
-- 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 `gallery`
--
CREATE TABLE IF NOT EXISTS `gallery` (
`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,
`rating` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `gallery`
--
-- --------------------------------------------------------
--
-- Table structure for table `ignores`
--
CREATE TABLE IF NOT EXISTS `ignores` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`is_ignored_for` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ignores`
--
-- --------------------------------------------------------
--
-- 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_load` int(11) NOT NULL,
`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 ;
--
-- Dumping data for table `loads_comm`
--
-- --------------------------------------------------------
--
-- Table structure for table `loads_files`
--
CREATE TABLE IF NOT EXISTS `loads_files` (
`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,
`time` int(10) NOT NULL,
`ok` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `loads_files`
--
-- --------------------------------------------------------
--
-- 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 `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` 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,
`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 ;
--
-- 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,
`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 `private`
--
CREATE TABLE IF NOT EXISTS `private` (
`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 `private`
--
-- --------------------------------------------------------
--
-- Table structure for table `private_msg`
--
CREATE TABLE IF NOT EXISTS `private_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_private` 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,
`seen` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `private_msg`
--
-- --------------------------------------------------------
--
-- 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, ':)', 'inc/smiles/1.gif'),
(2, ':-)', 'inc/smiles/2.gif'),
(3, ';))', 'inc/smiles/4.gif'),
(4, ':sad', 'inc/smiles/4.gif'),
(5, ';)', 'inc/smiles/5.gif'),
(6, '%0', 'inc/smiles/6.gif'),
(7, ':(', 'inc/smiles/7.gif'),
(8, ':-(', 'inc/smiles/8.gif'),
(9, ':yy', 'inc/smiles/9.gif'),
(10, ':sho', 'inc/smiles/10.gif'),
(11, ':o_o', 'inc/smiles/11.gif'),
(12, ':crazy', 'inc/smiles/12.gif'),
(13, ':d', 'inc/smiles/13.gif'),
(14, ':-d', 'inc/smiles/14.gif'),
(15, ':peace', 'inc/smiles/15.gif'),
(16, ':flud', 'inc/smiles/16.gif'),
(17, ':closed', 'inc/smiles/17.gif'),
(18, ':angry', 'inc/smiles/18.gif'),
(19, ':bravo', 'inc/smiles/19.gif'),
(20, ':ban', 'inc/smiles/20.gif'),
(21, ':f', 'inc/smiles/21.gif'),
(22, ':welcome', 'inc/smiles/22.gif'),
(23, ':good', 'inc/smiles/23.gif'),
(24, ':ubanned', 'inc/smiles/24.gif'),
(25, ':spam', 'inc/smiles/25.gif'),
(26, ':shut', 'inc/smiles/26.gif'),
(27, ':shock', 'inc/smiles/27.gif'),
(28, ':read', 'inc/smiles/28.gif'),
(29, ':overlook', 'inc/smiles/29.gif'),
(30, ':oops', 'inc/smiles/30.gif'),
(31, ':?', 'inc/smiles/31.gif'),
(32, ':@', 'inc/smiles/32.gif'),
(33, ';/', 'inc/smiles/33.gif'),
(34, ':off', 'inc/smiles/34.gif'),
(35, ':lol', 'inc/smiles/35.gif'),
(36, ':hack', 'inc/smiles/36.gif'),
(37, ':sorry', 'inc/smiles/37.gif');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`login` varchar(12) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`pass` varchar(32) DEFAULT NULL,
`access` int(1) NOT NULL,
`regtime` int(10) DEFAULT NULL,
`lastvisit` int(10) NOT NULL,
`karma` int(11) NOT NULL,
`locked` int(10) NOT NULL,
`locked_who` int(11) NOT NULL,
`reason` varchar(250) NOT NULL,
`name` varchar(20) NOT NULL,
`from` varchar(25) NOT NULL,
`icq` int(9) NOT NULL,
`site` varchar(20) NOT NULL,
`birthday` varchar(10) NOT NULL,
`sex` int(1) NOT NULL,
`about` varchar(150) DEFAULT NULL,
`style` varchar(50) NOT NULL,
`onpage` int(2) 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_who` int(11) NOT NULL,
`id_for` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `voting`
--