Файл: install/db_tables/avatar.sql
Строк: 9
CREATE TABLE IF NOT EXISTS `avatar_comments` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) NOT NULL DEFAULT '0',
`time` int(11)
NOT NULL,
`msg` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci
DEFAULT NULL,
`avatar_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `avatar_like` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_komm`
varchar(50) NOT NULL,
`like` varchar(50) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;