schema_0062-add-user-created-last-active.sql « db - fixmystreet - This is mySociety's popular map-based reporting platform: easy to install in new countries and regions http://fixmystreet.org/

about summary refs log tree commit diff stats

path: root/db/schema_0062-add-user-created-last-active.sql

blob: 0e8875870df8e19d50623f3d9d0273179893ab2e (plain)

BEGIN;

ALTER TABLE users ADD created timestamp default current_timestamp not null;
ALTER TABLE users ADD last_active timestamp default current_timestamp not null;

COMMIT;