Файл: m/m.sql
Строк: 156
-- 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 */;