Skip to content

Instantly share code, notes, and snippets.

@gogo40

gogo40/gist:0f399b020ea4613c89a3fc214a6a4da7

Created March 27, 2019 19:11
Show Gist options
  • Save gogo40/0f399b020ea4613c89a3fc214a6a4da7 to your computer and use it in GitHub Desktop.
Save gogo40/0f399b020ea4613c89a3fc214a6a4da7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
use mining_control;
ALTER TABLE materials_map
ADD is_destination INTEGER NULL DEFAULT 1;
ALTER TABLE code_report
ADD utm_x REAL DEFAULT NULL,
utm_y REAL NULL,
utm_zone_id INTEGER NULL;
ALTER TABLE codes_raw_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE cloud_point_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE operations_raw_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE perforator_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE scaler_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE weighing_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE transport_report
ADD unload_utm_x REAL NULL DEFAULT NULL,
unload_utm_y REAL NULL DEFAULT NULL,
unload_utm_zone_id INTEGER NULL DEFAULT NULL,
load_utm_x REAL NULL DEFAULT NULL,
load_utm_y REAL NULL DEFAULT NULL,
load_utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE load_report
ADD unload_utm_x REAL NULL DEFAULT NULL,
unload_utm_y REAL NULL DEFAULT NULL,
unload_utm_zone_id INTEGER NULL DEFAULT NULL,
load_utm_x REAL NULL DEFAULT NULL,
load_utm_y REAL NULL DEFAULT NULL,
load_utm_zone_id INTEGER NULL DEFAULT NULL;
Raw
gistfile2.txt
use mining_control;
ALTER TABLE materials_map
ADD is_destination INTEGER NULL DEFAULT 1;
ALTER TABLE code_report
ADD utm_x REAL DEFAULT NULL,
utm_y REAL NULL,
utm_zone_id INTEGER NULL;
ALTER TABLE codes_raw_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE cloud_point_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE operations_raw_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE perforator_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE scaler_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE weighing_report
ADD utm_x REAL NULL DEFAULT NULL,
utm_y REAL NULL DEFAULT NULL,
utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE transport_report
ADD unload_utm_x REAL NULL DEFAULT NULL,
unload_utm_y REAL NULL DEFAULT NULL,
unload_utm_zone_id INTEGER NULL DEFAULT NULL,
load_utm_x REAL NULL DEFAULT NULL,
load_utm_y REAL NULL DEFAULT NULL,
load_utm_zone_id INTEGER NULL DEFAULT NULL;
ALTER TABLE load_report
ADD unload_utm_x REAL NULL DEFAULT NULL,
unload_utm_y REAL NULL DEFAULT NULL,
unload_utm_zone_id INTEGER NULL DEFAULT NULL,
load_utm_x REAL NULL DEFAULT NULL,
load_utm_y REAL NULL DEFAULT NULL,
load_utm_zone_id INTEGER NULL DEFAULT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment