Skip to main content

CREATE_TRANSACTION_LOG_TABLE

Constant CREATE_TRANSACTION_LOG_TABLE 

Source
pub const CREATE_TRANSACTION_LOG_TABLE: &str = "\nCREATE TABLE IF NOT EXISTS transaction_log (\n    seq_id      INTEGER PRIMARY KEY AUTOINCREMENT,\n    table_name  TEXT NOT NULL,\n    entity_id   TEXT NOT NULL,\n    operation   TEXT NOT NULL,\n    payload     TEXT NOT NULL,\n    recorded_at TEXT NOT NULL,\n    CHECK (recorded_at GLOB \'[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]T[0-9][0-9]:[0-9][0-9]:[0-9][0-9].[0-9][0-9][0-9][0-9][0-9][0-9]Z\' AND 1)\n);\n";