Просмотр файла www/db.sql

Размер файла: 8.01Kb
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1
-- Время создания: Янв 09 2018 г., 12:27
-- Версия сервера: 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 */;

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

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

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

CREATE TABLE IF NOT EXISTS `s_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `avtor` int(11) NOT NULL,
  `data` int(11) NOT NULL,
  `razdel` varchar(11) NOT NULL,
  `ider` int(11) NOT NULL,
  `text` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `s_forum_mgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11) NOT NULL,
  `podrazdel` int(11) NOT NULL,
  `tema` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `mgs` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

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

CREATE TABLE IF NOT EXISTS `s_forum_nast` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tema` int(11) NOT NULL,
  `mgs` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `s_forum_podraz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `opis` varchar(250) NOT NULL,
  `poz` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

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

CREATE TABLE IF NOT EXISTS `s_forum_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `user` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

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

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

CREATE TABLE IF NOT EXISTS `s_forum_tema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11) NOT NULL,
  `podrazdel` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `stat` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `mgs` text NOT NULL,
  `pozitzia` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

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

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

CREATE TABLE IF NOT EXISTS `s_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `avtor` int(11) NOT NULL,
  `nazvan` varchar(250) NOT NULL,
  `url` text NOT NULL,
  `status` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `s_ismail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `avtor` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `text` text NOT NULL,
  `admin` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `tema` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `s_nast` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_sp` text NOT NULL,
  `name_s` text NOT NULL,
  `url_img` text NOT NULL,
  `reg_s` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `s_nevs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazvanie` varchar(150) NOT NULL,
  `data` int(11) NOT NULL,
  `nevs` text NOT NULL,
  `avtor` int(11) NOT NULL,
  `admin` int(11) NOT NULL,
  `image` varchar(250) NOT NULL,
  `status` int(11) NOT NULL,
  `poza` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

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

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

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

CREATE TABLE IF NOT EXISTS `s_useres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `avatar` text NOT NULL,
  `login` text NOT NULL,
  `pass` text NOT NULL,
  `mail` text NOT NULL,
  `pol` int(2) NOT NULL,
  `timereg` int(20) NOT NULL,
  `admin` int(11) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `br` varchar(250) NOT NULL,
  `onli` int(20) NOT NULL,
  `ban` int(20) NOT NULL,
  `prin` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

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

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

CREATE TABLE IF NOT EXISTS `s_vhmail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `avtor` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `text` text NOT NULL,
  `admin` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `tema` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

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

CREATE TABLE IF NOT EXISTS `s_vit_categ` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `s_vit_kor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `tovar` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `s_vit_nast` (
  `id` int(11) NOT NULL,
  `link` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `s_vit_tovar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `opis` text NOT NULL,
  `tth` text NOT NULL,
  `zena` int(11) NOT NULL,
  `szena` int(11) NOT NULL,
  `valet` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `categ` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `foto1` varchar(250) NOT NULL,
  `foto2` varchar(250) NOT NULL,
  `foto3` varchar(250) NOT NULL,
  `foto4` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

/*!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 */;