CREATE TABLE IF NOT EXISTS `menu` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`type` enum('link','razd','include') NOT NULL DEFAULT
'link',
`name` varchar(32) NOT NULL,
`url` varchar(1024) DEFAULT NULL,
`include` varchar(100) DEFAULT NULL,
`counter` varchar(32) NOT NULL,
`pos` int(11) NOT NULL,
`icon` varchar(32) DEFAULT NULL,
PRIMARY KEY
(`id`),
KEY `pos` (`pos`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT
INTO `menu` (`id`, `type`, `name`, `url`, `include`, `counter`, `pos`,
`icon`) VALUES
(1, 'link', 'Новости', '/modules/news/', '',
'/modules/news/count.php', 1, 'news.png'),
(2, 'link', 'События',
'/modules/events/', '', '/modules/events/count.php', 2,
'align_right.png'),
(3, 'link', 'Зона обмена', '/modules/obmen/',
'', '/modules/obmen/count.php', 3, 'file.png'),
(4, 'link', 'Форум',
'/modules/forum/', '', '/modules/forum/count.php', 4,
'text_signature.png'),
(5, 'include', '', '', '/modules/forum/include.php',
'', 5, 'default.png'),
(6, 'link', 'Фотогалерея',
'/modules/foto/', '', '/modules/foto/count.php', 6, 'photo_album.png'),
(7,
'link', 'Дневники', '/modules/diary/', '',
'/modules/diary/count.php', 7, 'book.png'),
(8, 'link',
'Пользователи', '/modules/users/', '',
'/modules/users/count.php', 8, 'users.png'),
(9, 'link',
'Информация', '/modules/info/', '', '', 9,
'information-button.png');