snikket-ios/Shared/db-schema-13.sql

15 lines
297 B
PL/PgSQL

BEGIN;
CREATE TABLE IF NOT EXISTS chat_history_sync (
id TEXT NOT NULL COLLATE NOCASE,
account TEXT NOT NULL COLLATE NOCASE,
component TEXT COLLATE NOCASE,
from_timestamp INTEGER NOT NULL,
from_id TEXT,
to_timestamp INTEGER NOT NULL
);
COMMIT;
PRAGMA user_version = 13;