-- -------------------------------------------------------
-- reconfigure ic_check table to include which area used
-- and move some columns around for better logic
-- -------------------------------------------------------
ALTER TABLE `ic_check` 
	ADD COLUMN `area_id` INT NULL DEFAULT NULL AFTER `created_by`,
	CHANGE COLUMN `area_name` `area_name` VARCHAR(64) NULL DEFAULT NULL AFTER `area_id`,
	CHANGE COLUMN `area_description` `area_description` TEXT NULL DEFAULT NULL AFTER `area_name`;
