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


CREATE TABLE IF NOT EXISTS `profile` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `private` enum('0','1','2') DEFAULT '0',
  `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 `profile` (`id`, `private`, `name`,
`url`, `counter`, `pos`, `icon`) VALUES
(1, '1', 'Сообщения',
'/user/mail/', '', 1, 'email'),
(2, '1', 'Черный список',
'/user/blacklist/', '/user/blacklist/count.php', 2,
'do_not_disturb_alt'),
(3, '1', 'Уведомления',
'/user/notification/', '/user/notification/count.php', 3,
'notifications');