ALTER TABLE `users` ADD `company_type` VARCHAR(255) NOT NULL AFTER `phone_number`;
ALTER TABLE `users` ADD `aadhar_no` INT NULL DEFAULT NULL AFTER `otp_expiry`, ADD `aadhar_front` VARCHAR(255) NULL DEFAULT NULL AFTER `aadhar_no`, ADD `aadhar_back` VARCHAR(255) NULL DEFAULT NULL AFTER `aadhar_front`, ADD `cancelled_cheque` VARCHAR(255) NULL DEFAULT NULL AFTER `aadhar_back`;
ALTER TABLE `users` ADD `pan_no` VARCHAR(20) NULL DEFAULT NULL AFTER `cancelled_cheque`, ADD `pan_file` VARCHAR(255) NULL DEFAULT NULL AFTER `pan_no`, ADD `e_shop` VARCHAR(255) NULL DEFAULT NULL AFTER `pan_file`, ADD `pan_no_company` VARCHAR(20) NULL DEFAULT NULL AFTER `e_shop`, ADD `pan_file_company` VARCHAR(255) NULL DEFAULT NULL AFTER `pan_no_company`, ADD `coi_no` VARCHAR(20) NULL DEFAULT NULL AFTER `pan_file_company`, ADD `coi_file` VARCHAR(255) NULL DEFAULT NULL AFTER `coi_no`, ADD `moa_file` VARCHAR(255) NULL DEFAULT NULL AFTER `coi_file`, ADD `aoa_file` VARCHAR(255) NULL DEFAULT NULL AFTER `moa_file`, ADD `gst_no` VARCHAR(20) NULL DEFAULT NULL AFTER `aoa_file`, ADD `gst_file` VARCHAR(255) NULL DEFAULT NULL AFTER `gst_no`;
ALTER TABLE `users` CHANGE `aadhar_no` `aadhar_no` VARCHAR(255) NULL DEFAULT NULL, CHANGE `pan_no` `pan_no` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `users` ADD `latitude` DOUBLE NULL DEFAULT NULL AFTER `gst_file`, ADD `longitude` DOUBLE NULL DEFAULT NULL AFTER `latitude`, ADD `ip` VARCHAR(50) NULL DEFAULT NULL AFTER `longitude`;