| CREATE TABLE IF NOT EXISTS sync_tokens ( | |
| id TEXT PRIMARY KEY, | |
| name TEXT NOT NULL, | |
| token_hash TEXT NOT NULL UNIQUE, | |
| sync_api_key_id TEXT, | |
| revoked_at TEXT, | |
| last_used_at TEXT, | |
| created_at TEXT NOT NULL DEFAULT (datetime('now')), | |
| updated_at TEXT NOT NULL DEFAULT (datetime('now')) | |
| ); | |
| CREATE INDEX IF NOT EXISTS idx_sync_tokens_created_at ON sync_tokens(created_at); | |
| CREATE INDEX IF NOT EXISTS idx_sync_tokens_last_used_at ON sync_tokens(last_used_at); | |
| CREATE INDEX IF NOT EXISTS idx_sync_tokens_revoked_at ON sync_tokens(revoked_at); | |
| CREATE INDEX IF NOT EXISTS idx_sync_tokens_sync_api_key_id ON sync_tokens(sync_api_key_id); | |