ALTER TABLE `0_property` 
ADD COLUMN `amenities` VARCHAR(700) NULL AFTER `status`,
ADD COLUMN `furnishings` VARCHAR(700) NULL AFTER `amenities`,
ADD COLUMN `size` DOUBLE NULL AFTER `furnishings`,
ADD COLUMN `goodwill` DOUBLE NULL AFTER `size`,
ADD COLUMN `stock_value` DOUBLE NULL AFTER `goodwill`,
ADD COLUMN `period_in_business` DOUBLE NULL AFTER `stock_value`,
ADD COLUMN `profit` DOUBLE NULL AFTER `period_in_business`;

CREATE TABLE `0_property_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_for` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



