CREATE TABLE IF NOT EXISTS `menu` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`opis` varchar(50) NOT
NULL,
`url` varchar(100) DEFAULT NULL,
`counter` varchar(32) NOT NULL,
`pos` int(11) NOT NULL,
`icon` varchar(32) DEFAULT NULL,
`color_link`
varchar(32) DEFAULT '000000',
`color_icon` varchar(32) DEFAULT '0094FF',
PRIMARY KEY (`id`),
KEY `pos` (`pos`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`,
`icon`) VALUES
(1, 'Новости', '/modules/news/',
'/modules/news/count.php', 1, 'feed'),
(2, 'Чат', '/modules/mini_chat/',
'/modules/mini_chat/count.php', 2, 'comments-o'),
(3, 'Форум',
'/modules/forum/', '/modules/forum/count.php', 3, 'clipboard'),
(4,
'Загрузки', '/loads/', '/loads/count.php', 4, 'save'),
(5,
'Фотоальбомы', '/modules/foto/', '/modules/foto/count.php', 5,
'photo'),
(6, 'Видео', '/modules/videos/',
'/modules/videos/count.php', 6, 'youtube'),
(7, 'Блоги',
'/modules/diary/', '/modules/diary/count.php', 7, 'book'),
(8,
'Сообщества', '/public.php', '/modules/public/count.php', 8,
'street-view'),
(9, 'Пользователи', '/?users',
'/modules/users/count.php', 9, 'group'),
(10, 'Приложения',
'/modules/games/', '', 10, 'cubes');