View file install/db_tables/menu.sql

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');