Просмотр архива DCMS S

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `type` enum('link') NOT NULL DEFAULT 'link',
  `name`
varchar(32) NOT NULL,
  `url` varchar(1024) 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`,
`counter`, `pos`, `icon`) VALUES
(1, 'link', 'Новости',
'/modules/news/', '/modules/news/count.php', 1, 'fa fa-newspaper-o'),
(2,
'link', 'Форум', '/modules/forum/', '/modules/forum/count.php', 2, 'fa
fa-comments-o'),
(3, 'link', 'Обменник', '/modules/obmen/',
'/modules/obmen/count.php', 3, 'fa fa-folder-open'),
(4, 'link',
'Пользователи', '/?users', '/modules/users/count.php', 4, 'fa
fa-users');