• Home
• im.actor.server
• actor-persist
• 1.0.130
• source code
• V20150707210259__AddUserCreatedAt.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.migration.V20150707210259__AddUserCreatedAt.sql Maven / Gradle / Ivy

alter table users add column created_at timestamp;
with sess as (select user_id, min(auth_time) as created_at from auth_sessions group by user_id) update users set created_at = (select created_at from sess where sess.user_id = id);
update users set created_at = now() where is_bot = true;