geo consistency controller table structure

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 geo_consistency_controller_idx ON Geo_Consistency_Controller (table_name, field_changed);
create INDEX IF NOT EXISTS geo_consistency_controller_tname_idx ON Geo_Consistency_Controller (table_name);
create INDEX IF NOT EXISTS geo_consistency_controller_field_idx ON Geo_Consistency_Controller (field_changed);