Skip to content

Instantly share code, notes, and snippets.

@kumar303
Created March 3, 2015 21:41
Show Gist options
  • Save kumar303/aff8caedf59da3459bdb to your computer and use it in GitHub Desktop.
Save kumar303/aff8caedf59da3459bdb to your computer and use it in GitHub Desktop.
ALTER TABLE `users`
ADD COLUMN `last_login_attempt` DATETIME NULL DEFAULT NULL,
ADD COLUMN `last_login_attempt_ip` CHAR(45) NOT NULL DEFAULT '' AFTER `last_login_attempt`,
ADD COLUMN `failed_login_attempts` MEDIUMINT(8) UNSIGNED NOT NULL
DEFAULT '0' AFTER `last_login_attempt_ip`;
ALTER TABLE `users` CHANGE `fxa_uid` `username` varchar(255);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment