Hope
Premium
- Сообщения
- 48,305
- Решения
- 22
- Реакции
- 71,871
- Баллы
- 40,905
У автора по ходу некорректно построен запрос:
Код:
CREATE TABLE IF NOT EXISTS `xf_team_post` (
`post_id` int(10) unsigned not null AUTO_INCREMENT
,`team_id` int(10) unsigned not null
,`user_id` int(10) unsigned not null
,`username` varchar(50) not null default \'\'
,`message_state` enum(\'visible\', \'moderated\', \'deleted\') default \'visible\'
,`post_date` int(10) unsigned not null default \'0\'
,`message` mediumtext not null
,`likes` int(10) unsigned not null default \'0\'
,`like_users` mediumblob not null
,`comment_count` int(10) unsigned not null default \'0\'
,`warning_id` int(10) unsigned not null default \'0\'
,`first_comment_date` int(10) unsigned not null default \'0\'
,`last_comment_date` int(10) unsigned not null default \'0\'
,`latest_comment_ids` varbinary(100) not null default \'\'
,`sticky` tinyint(3) unsigned not null default \'0\'
,`share_privacy` varbinary(25) not null
,`attach_count` smallint(5) unsigned not null default \'0\'
, PRIMARY KEY (`post_id`)
, KEY `team_user` (`team_id`, `user_id`)
, KEY `post_date` (`post_date`)
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;