-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Янв 07 2013 г., 19:42
-- Версия сервера: 5.0.45
-- Версия PHP: 5.2.4
-- 
-- БД: `restzone`
-- 

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

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

CREATE TABLE `instans` (
  `id_inst` int(11) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `description` varchar(300) NOT NULL,
  `type` int(1) NOT NULL,
  `time` int(11) NOT NULL,
  `adres` varchar(150) NOT NULL,
  `phone` varchar(150) NOT NULL,
  `logo` varchar(150) NOT NULL,
  `text` longtext NOT NULL,
  `region` int(11) NOT NULL,
  `map` text NOT NULL,
  `cook` int(11) NOT NULL,
  `name_field` varchar(20) NOT NULL,
  `type_rest` int(11) NOT NULL,
  `exclusive` int(11) NOT NULL,
  `services` int(11) NOT NULL,
  `average_price` int(11) NOT NULL,
  `cat` int(11) NOT NULL,
  `mobile` varchar(30) default NULL,
  `work_time` varchar(300) NOT NULL,
  `site` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  PRIMARY KEY  (`id_inst`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

INSERT INTO `instans` VALUES (1, '3Garund', 'oleg', 2, 2147483647, 'Baku ,st Sovetsky', '+98037823458999', 'logo', 'Text', 1, '', 19, '19', 19, 19, 19, 19, 19, '19', '', '', '');
INSERT INTO `instans` VALUES (2, 'Night Planet', 'desc', 1, 2147483647, '', '', '', '', 0, '', 0, '', 0, 0, 0, 0, 0, '0', '', '', '');
INSERT INTO `instans` VALUES (3, 'Party Gold', 'desc', 1, 2147483647, '', '', '', '', 0, '', 0, '', 0, 0, 0, 0, 0, '0', '', '', '');
INSERT INTO `instans` VALUES (4, '1olda PARTY', 'QEQE', 1, 213455322, '', '', '', '', 0, '', 0, '', 0, 0, 0, 0, 0, '0', '', '', '');
INSERT INTO `instans` VALUES (5, 'BEER STACKE', 'QEQE', 1, 0, '', '', '', '', 0, '', 0, '', 0, 0, 0, 0, 0, '0', '', '', '');
INSERT INTO `instans` VALUES (6, 'еарнкен', 'кнкн', 3, 43535, '35', '35', '3535', '3535', 2, '<iframe width="305" height="305" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.ru/maps?f=q&amp;source=s_q&amp;hl=ru&amp;geocode=&amp;q=%D0%BA%D0%B8%D1%88%D0%B8%D0%BD%D0%B5%D0%B2&amp;aq=&amp;sll=55.354135,40.297852&amp;sspn=14.40107,39.506836&amp;ie=UTF8&amp;hq=&amp;hnear=%D0%9A%D0%B8%D1%88%D0%B8%D0%BD%D1%91%D0%B2,+%D0%9C%D0%BE%D0%BB%D0%B4%D0%B0%D0%B2%D0%B8%D1%8F&amp;ll=47.026859,28.841551&amp;spn=0.01682,0.038581&amp;t=m&amp;z=14&amp;output=embed"></iframe>', 1, '', 0, 0, 0, 0, 0, '0', '', '', '');
INSERT INTO `instans` VALUES (7, '324234', '2424', 4, 54353, '535', '35', '5335', '3535', 35, '3535', 35, '', 0, 0, 0, 0, 0, '0', '', '', '');

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

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

CREATE TABLE `rezervation` (
  `id` int(11) NOT NULL auto_increment,
  `id_inst` int(11) NOT NULL,
  `name` varchar(100) default NULL,
  `time` int(11) default NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(20) NOT NULL,
  `comment` varchar(250) NOT NULL,
  `room` int(11) NOT NULL,
  `persons` int(11) NOT NULL,
  `status` int(1) NOT NULL,
  `description` varchar(10000) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_inst` (`id_inst`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

INSERT INTO `rezervation` VALUES (1, 4, '0', 0, '5464564646', 'oli35@mail.ru', 'RYRY', 0, 1, 2, '', 0);
INSERT INTO `rezervation` VALUES (6, 3, '0', 0, '4564646', 'oli35@mail.ru', 'sfsf', 0, 3, 2, '', 0);
INSERT INTO `rezervation` VALUES (7, 3, '0', 0, '4564646', 'oli35@mail.ru', 'sfsf', 0, 3, 2, '', 0);
INSERT INTO `rezervation` VALUES (9, 3, '1', 1973, '1', 'oli35@mail.su', '1', 1, 1, 0, '1', 192883312);