geo consistency controller table structure

This table holds a list of database changes that have been made and that need to have consequences executed It replaces the old editing_table table and is used to track changes impossible (or impractical) to perform even with Spatialite’s KNN2 triggers

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
table_name*	TEXT	YES			The name of the table that was changed
field_changed	TEXT	YES			Name of the field that was altered.

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS Geo_Consistency_Controller(
    table_name      TEXT,
    field_changed   TEXT,
    PRIMARY KEY (table_name, field_changed)
    );
create INDEX IF NOT EXISTS idx_polaris_geo_consistency_controller ON Geo_Consistency_Controller (table_name, field_changed);
create INDEX IF NOT EXISTS idx_polaris_geo_consistency_controller_tname ON Geo_Consistency_Controller (table_name);
create INDEX IF NOT EXISTS idx_polaris_geo_consistency_controller_field ON Geo_Consistency_Controller (field_changed);