Просмотр архива Dcms-Social


CREATE TABLE IF NOT EXISTS `notification` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`id_object` int(11) NOT NULL,
  `type` varchar(11) NOT NULL,
  `avtor`
int(11) DEFAULT NULL,
  `all_type` varchar(11) DEFAULT NULL,
  `read`
int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS
`notification_set` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user`
int(11) NOT NULL,
  `komm` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;