GPKG_METADATA_REFERENCE top-level constant

String const GPKG_METADATA_REFERENCE

Implementation

const GPKG_METADATA_REFERENCE = """
  CREATE TABLE IF NOT EXISTS $TABLE_METADATA_REFERENCE (
    reference_scope TEXT NOT NULL,
    table_name TEXT,
    column_name TEXT,
    row_id_value INTEGER,
    timestamp DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
    md_file_id INTEGER NOT NULL,
    md_parent_id INTEGER,
    CONSTRAINT crmr_mfi_fk FOREIGN KEY (md_file_id) REFERENCES $TABLE_METADATA(id),
    CONSTRAINT crmr_mpi_fk FOREIGN KEY (md_parent_id) REFERENCES $TABLE_METADATA(id)
  );
""";