gistfile1.txt

use mc;


ALTER TABLE `code_report` 
ADD COLUMN `utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_zone_id` INTEGER NULL DEFAULT NULL;

ALTER TABLE `codes_raw_report` 
ADD COLUMN `utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_zone_id` INTEGER NULL DEFAULT NULL;


ALTER TABLE `cloud_point_report` 
ADD COLUMN `utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_zone_id` INTEGER NULL DEFAULT NULL;


ALTER TABLE `operations_raw_report` 
ADD COLUMN `utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_zone_id` INTEGER NULL DEFAULT NULL;


ALTER TABLE `perforator_report` 
ADD COLUMN `utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_zone_id` INTEGER NULL DEFAULT NULL;


ALTER TABLE `scaler_report` 
ADD COLUMN `utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_zone_id` INTEGER NULL DEFAULT NULL;


ALTER TABLE `weighing_report` 
ADD COLUMN `utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `utm_zone_id` INTEGER NULL DEFAULT NULL;


ALTER TABLE `transport_report` 
ADD COLUMN `unload_utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `unload_utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `unload_utm_zone_id` INTEGER NULL DEFAULT NULL,
ADD COLUMN `load_utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `load_utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `load_utm_zone_id` INTEGER NULL DEFAULT NULL;

ALTER TABLE `load_report` 
ADD COLUMN `unload_utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `unload_utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `unload_utm_zone_id` INTEGER NULL DEFAULT NULL,
ADD COLUMN `load_utm_x` REAL NULL DEFAULT NULL,
ADD COLUMN `load_utm_y` REAL NULL DEFAULT NULL,
ADD COLUMN `load_utm_zone_id` INTEGER NULL DEFAULT NULL;


ALTER TABLE `materials_map` 
ADD COLUMN `is_destination` INTEGER NULL DEFAULT 1;