GPKG_GEOMETRY_COLUMNS top-level constant

String const GPKG_GEOMETRY_COLUMNS

Implementation

const GPKG_GEOMETRY_COLUMNS = """
  CREATE TABLE IF NOT EXISTS $TABLE_GEOMETRY_COLUMNS (
    table_name TEXT NOT NULL,
    column_name TEXT NOT NULL,
    geometry_type_name TEXT NOT NULL,
    srs_id INTEGER NOT NULL,
    z TINYINT NOT NULL,
    m TINYINT NOT NULL,
    CONSTRAINT pk_geom_cols PRIMARY KEY (table_name, column_name),
    CONSTRAINT uk_gc_table_name UNIQUE (table_name),
    CONSTRAINT fk_gc_tn FOREIGN KEY (table_name) REFERENCES $TABLE_GEOPACKAGE_CONTENTS(table_name),
    CONSTRAINT fk_gc_srs FOREIGN KEY (srs_id) REFERENCES $TABLE_SPATIAL_REF_SYS (srs_id)
  );
""";