-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Окт 31 2008 г., 14:28
-- Версия сервера: 5.0.45
-- Версия PHP: 5.2.4
-- 
-- БД: `rutmb_1`
-- 

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

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

CREATE TABLE `realty_category` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(50) NOT NULL,
  `subcategory` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=85 ;

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

INSERT INTO `realty_category` VALUES (1, 'Продам', '', 0);
INSERT INTO `realty_category` VALUES (2, 'Куплю', '', 0);
INSERT INTO `realty_category` VALUES (3, 'Сдам в аренду', '', 0);
INSERT INTO `realty_category` VALUES (4, 'Сниму', '', 0);
INSERT INTO `realty_category` VALUES (5, 'Вторичный рынок, квартиры', '', 1);
INSERT INTO `realty_category` VALUES (6, 'Вторичный рынок, комнаты', '', 1);
INSERT INTO `realty_category` VALUES (7, 'Новостройки, квартиры', '', 1);
INSERT INTO `realty_category` VALUES (8, 'Коттеджи', '', 1);
INSERT INTO `realty_category` VALUES (9, 'Дома, дачи', '', 1);
INSERT INTO `realty_category` VALUES (10, 'Участки', '', 1);
INSERT INTO `realty_category` VALUES (11, 'Гаражи', '', 1);
INSERT INTO `realty_category` VALUES (12, 'Вторичный рынок, квартиры', '', 2);
INSERT INTO `realty_category` VALUES (13, 'Вторичный рынок, комнаты', '', 2);
INSERT INTO `realty_category` VALUES (14, 'Новостройки, квартиры', '', 2);
INSERT INTO `realty_category` VALUES (15, 'Коттеджи', '', 2);
INSERT INTO `realty_category` VALUES (16, 'Дома, дачи', '', 2);
INSERT INTO `realty_category` VALUES (17, 'Участки', '', 2);
INSERT INTO `realty_category` VALUES (18, 'Гаражи', '', 2);
INSERT INTO `realty_category` VALUES (19, 'Квартиры', '', 3);
INSERT INTO `realty_category` VALUES (20, 'Комнаты', '', 3);
INSERT INTO `realty_category` VALUES (21, 'Коттеджи', '', 3);
INSERT INTO `realty_category` VALUES (22, 'Дома, дачи', '', 3);
INSERT INTO `realty_category` VALUES (23, 'Участки', '', 3);
INSERT INTO `realty_category` VALUES (24, 'Гаражи', '', 3);
INSERT INTO `realty_category` VALUES (25, 'Вторичный рынок, квартиры', '', 4);
INSERT INTO `realty_category` VALUES (26, 'Вторичный рынок, комнаты', '', 4);
INSERT INTO `realty_category` VALUES (27, 'Коттеджи', '', 4);
INSERT INTO `realty_category` VALUES (28, 'Дома, дачи', '', 4);
INSERT INTO `realty_category` VALUES (29, 'Участки', '', 4);
INSERT INTO `realty_category` VALUES (30, 'Гаражи', '', 4);
INSERT INTO `realty_category` VALUES (31, '1к', '', 5);
INSERT INTO `realty_category` VALUES (32, '2к', '', 5);
INSERT INTO `realty_category` VALUES (33, '3к', '', 5);
INSERT INTO `realty_category` VALUES (34, '4к', '', 5);
INSERT INTO `realty_category` VALUES (35, '5к', '', 5);
INSERT INTO `realty_category` VALUES (36, '6к', '', 5);
INSERT INTO `realty_category` VALUES (37, '1', '', 6);
INSERT INTO `realty_category` VALUES (38, '2', '', 6);
INSERT INTO `realty_category` VALUES (39, '3', '', 6);
INSERT INTO `realty_category` VALUES (40, '4', '', 6);
INSERT INTO `realty_category` VALUES (41, '5', '', 6);
INSERT INTO `realty_category` VALUES (42, '6', '', 6);
INSERT INTO `realty_category` VALUES (43, '1к', '', 7);
INSERT INTO `realty_category` VALUES (44, '2к', '', 7);
INSERT INTO `realty_category` VALUES (45, '3к', '', 7);
INSERT INTO `realty_category` VALUES (46, '4к', '', 7);
INSERT INTO `realty_category` VALUES (47, '5к', '', 7);
INSERT INTO `realty_category` VALUES (48, '6к', '', 7);
INSERT INTO `realty_category` VALUES (49, '1к', '', 12);
INSERT INTO `realty_category` VALUES (50, '2к', '', 12);
INSERT INTO `realty_category` VALUES (51, '3к', '', 12);
INSERT INTO `realty_category` VALUES (52, '4к', '', 12);
INSERT INTO `realty_category` VALUES (53, '5к', '', 12);
INSERT INTO `realty_category` VALUES (54, '6к', '', 12);
INSERT INTO `realty_category` VALUES (55, '1', '', 13);
INSERT INTO `realty_category` VALUES (56, '2', '', 13);
INSERT INTO `realty_category` VALUES (57, '3', '', 13);
INSERT INTO `realty_category` VALUES (58, '4', '', 13);
INSERT INTO `realty_category` VALUES (59, '5', '', 13);
INSERT INTO `realty_category` VALUES (60, '6', '', 13);
INSERT INTO `realty_category` VALUES (61, '1к', '', 19);
INSERT INTO `realty_category` VALUES (62, '2к', '', 19);
INSERT INTO `realty_category` VALUES (63, '3к', '', 19);
INSERT INTO `realty_category` VALUES (64, '4к', '', 19);
INSERT INTO `realty_category` VALUES (65, '5к', '', 19);
INSERT INTO `realty_category` VALUES (66, '6к', '', 19);
INSERT INTO `realty_category` VALUES (67, '1', '', 20);
INSERT INTO `realty_category` VALUES (68, '2', '', 20);
INSERT INTO `realty_category` VALUES (69, '3', '', 20);
INSERT INTO `realty_category` VALUES (70, '4', '', 20);
INSERT INTO `realty_category` VALUES (71, '5', '', 20);
INSERT INTO `realty_category` VALUES (72, '6', '', 20);
INSERT INTO `realty_category` VALUES (73, '1к', '', 25);
INSERT INTO `realty_category` VALUES (74, '2к', '', 25);
INSERT INTO `realty_category` VALUES (75, '3к', '', 25);
INSERT INTO `realty_category` VALUES (76, '4к', '', 25);
INSERT INTO `realty_category` VALUES (77, '5к', '', 25);
INSERT INTO `realty_category` VALUES (78, '6к', '', 25);
INSERT INTO `realty_category` VALUES (79, '1', '', 26);
INSERT INTO `realty_category` VALUES (80, '2', '', 26);
INSERT INTO `realty_category` VALUES (81, '3', '', 26);
INSERT INTO `realty_category` VALUES (82, '4', '', 26);
INSERT INTO `realty_category` VALUES (83, '5', '', 26);
INSERT INTO `realty_category` VALUES (84, '6', '', 26);