12 lines
472 B
SQL
12 lines
472 B
SQL
|
CREATE TABLE IF NOT EXISTS wiki_ingest_checkpoints (
|
||
|
|
tenant_id BIGINT UNSIGNED NOT NULL,
|
||
|
|
knowledge_base_id VARCHAR(36) NOT NULL,
|
||
|
|
knowledge_id VARCHAR(36) NOT NULL,
|
||
|
|
fingerprint VARCHAR(64) NOT NULL,
|
||
|
|
stage VARCHAR(32) NOT NULL,
|
||
|
|
item_key VARCHAR(64) NOT NULL,
|
||
|
|
payload LONGTEXT NOT NULL,
|
||
|
|
updated_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
||
|
|
PRIMARY KEY (tenant_id, knowledge_base_id, knowledge_id, fingerprint, stage, item_key)
|
||
|
|
);
|