-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 01, 2011 at 01:42 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=8 ;
--
-- Dumping data for table `ad`
--
INSERT INTO `ad` (`id`, `name`, `link`, `type`, `time`) VALUES
(7, 'Wap-хостинг 1xw.mobi', 'http://1xw.mobi', 1, 1309256221);
-- --------------------------------------------------------
--
-- Table structure for table `blog_articles`
--
CREATE TABLE IF NOT EXISTS `blog_articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_cat` int(11) NOT NULL,
`title` varchar(50) NOT NULL,
`text` text NOT NULL,
`tags` 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 `blog_articles`
--
-- --------------------------------------------------------
--
-- Table structure for table `blog_cats`
--
CREATE TABLE IF NOT EXISTS `blog_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 `blog_cats`
--
-- --------------------------------------------------------
--
-- Table structure for table `book`
--
CREATE TABLE IF NOT EXISTS `book` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`text` varchar(250) NOT NULL,
`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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `chat`
--
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE IF NOT EXISTS `config` (
`id` int(1) NOT NULL AUTO_INCREMENT,
`style` varchar(50) NOT NULL,
`title` varchar(50) NOT NULL,
`desc` varchar(50) NOT NULL,
`copy` varchar(50) NOT NULL,
`onpage` int(2) NOT NULL,
`antispam` int(3) NOT NULL,
`min_points` int(3) NOT NULL,
`max_priv` int(3) NOT NULL,
`feedback` text NOT NULL,
`blog_limitadd` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `config`
--
INSERT INTO `config` (`id`, `style`, `title`, `desc`, `copy`, `onpage`, `antispam`, `min_points`, `max_priv`, `feedback`, `blog_limitadd`) VALUES
(1, 'default', 'WMclub.mobi', 'fgh', '', 10, 5, 10, 50, 'E-mail: [email protected]\r\nICQ: 5298996', 0);
-- --------------------------------------------------------
--
-- Table structure for table `foes`
--
CREATE TABLE IF NOT EXISTS `foes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`is_foe_for` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `foes`
--
-- --------------------------------------------------------
--
-- 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,
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 `friends`
--
CREATE TABLE IF NOT EXISTS `friends` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`is_friend_for` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `friends`
--
-- --------------------------------------------------------
--
-- 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,
`order` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `loads_cats`
--
-- --------------------------------------------------------
--
-- 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,
`file` varchar(50) NOT NULL,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- 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,
`order` int(11) 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 `offers`
--
CREATE TABLE IF NOT EXISTS `offers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`text` text NOT NULL,
`user_id` int(11) NOT NULL,
`status` int(1) NOT NULL,
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `offers`
--
-- --------------------------------------------------------
--
-- 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,
`text` varchar(250) NOT NULL,
`sender` int(11) NOT NULL,
`time` int(10) NOT NULL,
`type` int(1) NOT NULL,
`read` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `private`
--
-- --------------------------------------------------------
--
-- 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=1 ;
--
-- Dumping data for table `smiles`
--
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`user_login` varchar(20) DEFAULT NULL,
`user_mail` varchar(20) DEFAULT NULL,
`user_pass` varchar(35) DEFAULT NULL,
`user_regtime` varchar(10) DEFAULT NULL,
`user_lastvisit` varchar(10) NOT NULL,
`user_access` int(1) NOT NULL,
`user_points` int(11) NOT NULL,
`profile_name` varchar(25) NOT NULL,
`profile_country` varchar(25) NOT NULL,
`profile_from` varchar(25) NOT NULL,
`profile_icq` varchar(10) NOT NULL,
`profile_site` varchar(25) NOT NULL,
`profile_birthday` varchar(10) NOT NULL,
`profile_sex` int(1) NOT NULL,
`profile_about` varchar(150) DEFAULT NULL,
`set_style` varchar(50) NOT NULL,
`set_onpage` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `users`
--