Skip to content

Instantly share code, notes, and snippets.

@zoozalp

zoozalp/last_password_reset_date.sql

Created April 24, 2018 07:22
Show Gist options
  • Save zoozalp/6616782cef8ae21540b65984f6433024 to your computer and use it in GitHub Desktop.
Save zoozalp/6616782cef8ae21540b65984f6433024 to your computer and use it in GitHub Desktop.
Download ZIP
Add last password reset date to users table
Raw
last_password_reset_date.sql
alter table users add last_password_reset_date timestamp;
update users set last_password_reset_date = current_date;
alter table users alter column last_password_reset_date set not null;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment