ALTER TABLE `profiles` 
ADD COLUMN `marital_status` VARCHAR(50) AFTER `gender`,
ADD COLUMN `city` VARCHAR(100),
ADD COLUMN `state` VARCHAR(100),
ADD COLUMN `family_type` VARCHAR(50);

ALTER TABLE `education_work` 
ADD COLUMN `education_detail` TEXT,
ADD COLUMN `occupation_detail` TEXT;

ALTER TABLE `partner_preferences` 
ADD COLUMN `pref_marital_status` VARCHAR(100),
ADD COLUMN `pref_height_min` VARCHAR(20),
ADD COLUMN `pref_height_max` VARCHAR(20);

ALTER TABLE `users` 
ADD COLUMN `country_id` INT(11) AFTER `profile_for`,
ADD COLUMN `phone_code` VARCHAR(10) AFTER `country_id`;



-----------
ALTER TABLE `user_images` ADD `status` INT NULL DEFAULT '0' AFTER `is_main`;
ALTER TABLE `users` ADD `status` INT NULL DEFAULT '0' AFTER `password`;