--
-- Структура таблицы `img`
--
CREATE TABLE IF NOT EXISTS `img` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_cat` int(10) unsigned NOT NULL,
`title` varchar(255) NOT NULL DEFAULT 'NOT NULL',
PRIMARY KEY (`id`),
KEY `id_cat` (`id_cat`),
FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
--
-- Дамп данных таблицы `img`
--
INSERT INTO `img` (`id`, `id_cat`, `title`) VALUES
(1, 3, 'Kristen Stewart'),
(2, 3, 'Kristen Stewart'),
(3, 3, 'Mena Suvari'),
(4, 4, 'Heidi Klum'),
(5, 4, 'Collien Fernandes'),
(6, 4, 'Ana Beatriz Barros'),
(7, 4, 'Ana Beatriz Barros'),
(8, 6, 'GMC Yukon Denali'),
(9, 5, 'Stacy Keibler'),
(10,6, 'Toyota Land Cruiser Prado');
--
-- Структура таблицы `categories`
--
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`p_id` int(10) unsigned NOT NULL,
`url` varchar(100) NOT NULL DEFAULT 'NOT NULL',
`hide_menu` enum('show','hide') NOT NULL DEFAULT 'show',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
KEY `p_id` (`p_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `categories`
--
INSERT INTO `categories` (`id`, `p_id`, `url`, `hide_menu`) VALUES
(1, 0, 'girls', 'show'),
(2, 0, 'cars', 'show'),
(3, 1, 'celebrities', 'show'),
(4, 1, 'models', 'show'),
(5, 1, 'beauties', 'show'),
(6, 2, '4x4', 'show');
|
