View file magazin/sql.sql

-- phpMyAdmin SQL Dump
-- version 2.11.4-rc1
-- http://www.phpmyadmin.net
--
-- Хост: localhost:3306
-- Время создания: Ноя 21 2009 г., 20:12
-- Версия сервера: 5.0.45
-- Версия PHP: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

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

CREATE TABLE IF NOT EXISTS `5dig` (
  `id` int(5) NOT NULL auto_increment,
  `cid` int(5) NOT NULL,
  `icq` int(5) NOT NULL,
  `cena` int(5) NOT NULL,
  `status` varchar(10) NOT NULL,
  `author` varchar(15) NOT NULL,
  `date` date NOT NULL,
  `view` int(5) NOT NULL,
  `opis` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `5dig`
--


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

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

CREATE TABLE IF NOT EXISTS `6dig` (
  `id` int(5) NOT NULL auto_increment,
  `cid` int(5) NOT NULL,
  `icq` int(5) NOT NULL,
  `cena` int(5) NOT NULL,
  `status` varchar(10) NOT NULL,
  `author` varchar(15) NOT NULL,
  `date` date NOT NULL,
  `view` int(5) NOT NULL,
  `opis` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `6dig`
--


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

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

CREATE TABLE IF NOT EXISTS `7dig` (
  `id` int(5) NOT NULL auto_increment,
  `cid` int(5) NOT NULL,
  `icq` int(5) NOT NULL,
  `cena` int(5) NOT NULL,
  `status` varchar(10) character set utf8 NOT NULL,
  `author` varchar(15) character set utf8 NOT NULL,
  `date` date NOT NULL,
  `view` int(5) NOT NULL,
  `opis` varchar(15) character set utf8 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `7dig`
--


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

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

CREATE TABLE IF NOT EXISTS `8dig` (
  `id` int(5) NOT NULL auto_increment,
  `cid` int(5) NOT NULL,
  `icq` int(5) NOT NULL,
  `cena` int(5) NOT NULL,
  `status` varchar(10) character set utf8 NOT NULL,
  `author` varchar(15) character set utf8 NOT NULL,
  `date` date NOT NULL,
  `view` int(5) NOT NULL,
  `opis` varchar(15) character set utf8 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `8dig`
--


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

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

CREATE TABLE IF NOT EXISTS `9dig` (
  `id` int(5) NOT NULL auto_increment,
  `cid` int(5) NOT NULL,
  `icq` int(5) NOT NULL,
  `cena` int(5) NOT NULL,
  `status` varchar(10) character set utf8 NOT NULL,
  `author` varchar(15) character set utf8 NOT NULL,
  `date` date NOT NULL,
  `view` int(5) NOT NULL,
  `opis` varchar(15) character set utf8 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `9dig`
--


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

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

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(5) NOT NULL,
  `login` varchar(15) character set utf8 NOT NULL,
  `password` varchar(50) character set utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `admin`
--

INSERT INTO `admin` (`id`, `login`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

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

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

CREATE TABLE IF NOT EXISTS `setting` (
  `title` varchar(15) character set utf8 NOT NULL,
  `meta_d` varchar(20) character set utf8 NOT NULL,
  `meta_k` varchar(20) character set utf8 NOT NULL,
  `verh` varchar(25) character set utf8 NOT NULL,
  `niz` varchar(25) character set utf8 NOT NULL,
  `rekl_v` varchar(50) character set utf8 NOT NULL,
  `rekl_n` varchar(50) character set utf8 NOT NULL,
  `wmr` varchar(13) character set utf8 NOT NULL,
  `wmz` varchar(13) character set utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Дамп данных таблицы `setting`
--

INSERT INTO `setting` (`title`, `meta_d`, `meta_k`, `verh`, `niz`, `rekl_v`, `rekl_n`, `wmr`, `wmz`) VALUES
('', '', '', '', 'by ChikSan(2oo9)', '', '', 'R023456789123', '');