Файл: install/db_tables/notification.sql
Строк: 39
CREATE TABLE IF NOT EXISTS `notification` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_kont` int(11) NOT
NULL,
`id_img` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg`
varchar(1024) NOT NULL,
`read` set('0','1') NOT NULL DEFAULT '0',
`text` text not null,
`type` varchar(10) not null,
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`,`id_kont`),
KEY `read` (`read`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `notifications` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_kont`
int(11) NOT NULL,
`id_img` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`read` set('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`,`id_kont`),
KEY `read`
(`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT
EXISTS `notification_set` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`lenta_foto` int(11) DEFAULT '1',
`lenta_forum` int(11) DEFAULT '1',
`lenta_avatar` int(11) DEFAULT '1',
`lenta_friends` int(11) DEFAULT '1',
`lenta_news` int(11) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;