11 lines
540 B
SQL
11 lines
540 B
SQL
CREATE TABLE IF NOT EXISTS store_state (
|
|
id TINYINT UNSIGNED NOT NULL PRIMARY KEY,
|
|
document LONGTEXT NOT NULL,
|
|
updated_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3)
|
|
ON UPDATE CURRENT_TIMESTAMP(3),
|
|
CONSTRAINT store_state_document_json CHECK (JSON_VALID(document))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
INSERT IGNORE INTO store_state (id, document)
|
|
VALUES (1, '{"schemaVersion":1,"sources":[],"plugins":[],"releases":[],"syncRuns":[],"auditLog":[],"authAttempts":[],"meta":{}}');
|