Просмотр архива DCMS Special v 7.0.2 beta

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `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`,
`name`, `url`, `counter`, `pos`, `icon`) VALUES
(1, 'Новости',
'/modules/news/', '/modules/news/count.php', 1, 'local_library'),
(2,
'Форум', '/modules/forum/', '/modules/forum/count.php', 2,
'forum'),
(3, 'Обменник', '/modules/obmen/',
'/modules/obmen/count.php', 3, 'folder'),
(4, 'Фотоальбомы',
'/modules/foto/', '/modules/foto/count.php', 4, 'photo_album'),
(5,
'Пользователи', '/?users', '/modules/users/count.php', 5,
'group');