Просмотр архива Скрипт WM мастерской

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
--
Хост: 127.0.0.1
-- Время создания: Июл 08 2014 г.,
01:37
-- Версия сервера: 5.5.25
-- Версия PHP:
5.3.13

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


/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;

--
-- База данных: `profiwm`
--

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

--
--
Структура таблицы `forum_podrazdel`
--

CREATE TABLE IF NOT
EXISTS `forum_podrazdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`razdel` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
--
Структура таблицы `forum_post`
--

CREATE TABLE IF NOT
EXISTS `forum_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
int(11) NOT NULL,
  `podrazdel` int(11) NOT NULL,
  `thema` int(11) NOT
NULL,
  `text` mediumtext NOT NULL,
  `us` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `citata` mediumtext NOT NULL,
  `citata_us` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

--
--
Структура таблицы `forum_razdel`
--

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

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

--
--
Структура таблицы `forum_thema`
--

CREATE TABLE IF NOT
EXISTS `forum_thema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
int(11) NOT NULL,
  `podrazdel` int(11) NOT NULL,
  `text` mediumtext NOT
NULL,
  `name` varchar(244) NOT NULL,
  `us` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `status` int(2) NOT NULL,
  `up` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

--
--
Структура таблицы `news`
--

CREATE TABLE IF NOT EXISTS
`news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text NOT NULL,
 
`us` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
--
Структура таблицы `news_comm`
--

CREATE TABLE IF NOT
EXISTS `news_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time`
int(11) NOT NULL,
  `text` text NOT NULL,
  `us` int(11) NOT NULL,
  `news`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

--
--
Структура таблицы `smiles`
--

CREATE TABLE IF NOT EXISTS
`smiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(244)
NOT NULL,
  `icon` varchar(244) NOT NULL,
  `razdel` varchar(30) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

--
--
Структура таблицы `smiles_razdel`
--

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

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

--
--
Структура таблицы `users`
--

CREATE TABLE IF NOT EXISTS
`users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(20) NOT
NULL,
  `pass` varchar(255) NOT NULL,
  `sex` varchar(1) NOT NULL,
  `name`
varchar(30) NOT NULL,
  `email` varchar(40) NOT NULL,
  `icq` int(18) NOT
NULL,
  `osebe` varchar(255) NOT NULL,
  `strana` varchar(25) NOT NULL,
 
`gorod` varchar(30) NOT NULL,
  `datareg` varchar(255) NOT NULL,
  `level`
varchar(1) NOT NULL,
  `str` int(2) NOT NULL,
  `vizit` int(11) NOT NULL,
 
`ip` varchar(20) NOT NULL,
  `browser` varchar(200) NOT NULL,
  `gde`
varchar(50) NOT NULL,
  `avatar` varchar(255) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!40101
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;