Просмотр архива Магазин STRONG CMS

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
--
Хост: 127.0.0.1
-- Время создания: Апр 18 2015 г.,
22:19
-- Версия сервера: 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 */;

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE IF NOT EXISTS
`shop_dir` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200)
NOT NULL,
  `dir` int(11) NOT NULL DEFAULT '0',
  `up` int(1) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `shop_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(30) NOT NULL,
  `description` text NOT NULL,
  `price` int(11) NOT
NULL,
  `amount` int(11) NOT NULL,
  `goods` varchar(255) NOT NULL,
  `dir`
int(11) NOT NULL,
  `resale` int(1) NOT NULL DEFAULT '0',
  `time` int(11)
NOT NULL,
  `id_us` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `shop_gravamen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_us`
int(11) NOT NULL,
  `id_goods` int(11) NOT NULL,
  `text` text NOT NULL,
 
`read` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `shop_revievs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_us`
int(11) NOT NULL,
  `id_goods` int(11) NOT NULL,
  `type` int(1) NOT NULL,

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

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

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

CREATE TABLE IF NOT
EXISTS `shop_screen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `goods`
int(11) NOT NULL,
  `img` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`shop_sub` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_seller` int(11)
NOT NULL,
  `id_us` int(11) 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 */;