CREATE TABLE `chat_lastread` (
`user_id` int(8) NOT NULL,
`dialog_id` int(16) NOT NULL,
`date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`user_id`,`dialog_id`),
KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;$db->query('
INSERT INTO chat_lastread (
`user_id`,
`dialog_id`,
`date`
) VALUES(
#user_id,
#dialog_id,
NOW()
) ON DUPLICATE KEY UPDATE date=NOW()'
, $user->getId(), $dialog_id);
if exists(select 1
from chat_lastread
where `user_id` = #user_id
and `dialog_id` = #dialog_id)
begin
update chat_lastread
set `date` = NOW()
from chat_lastread
where `user_id` = #user_id
and `dialog_id` = #dialog_id
end
else
begin
INSERT INTO chat_lastread (
`user_id`,
`dialog_id`,
`date`
) VALUES(
#user_id,
#dialog_id,
NOW()
)
end
Простой
Простой
Простой
Средний
Средний
