ALTER TABLE `users` ADD `use_for` TINYINT NULL DEFAULT NULL COMMENT '1=police,2=advocate' AFTER `file_name`; ====> 29/12/2018 UPDATE `users` SET `state` = '18 ====>20/12/2018 6/42020 ALTER TABLE `users` ADD `subscription` TINYINT NULL DEFAULT NULL COMMENT '1=subscribed , 0 = not subscribed' AFTER `state`; ALTER TABLE `users` ADD `mobile` VARCHAR(12) NULL DEFAULT NULL AFTER `password`; ALTER TABLE `users` ADD `google_id` VARCHAR(50) NULL DEFAULT NULL AFTER `subscription`;