ALTER TABLE `users`
  ADD COLUMN `role` VARCHAR(20) NOT NULL DEFAULT 'admin' AFTER `password`,
  ADD COLUMN `active` TINYINT(1) NOT NULL DEFAULT 1 AFTER `role`;