~bigbes/lethe

ref: 934cfa2872e9be876dbfc2e8b087a0759588d1c2 lethe/internal/platform/database/migrations/0002_saved_searches.up.sql -rw-r--r-- 327 bytes
934cfa28 — Eugene Blikh oidcstub: implement /authorize + /token auth-code+PKCE; inject window.__LETHE_CONFIG__ into SPA a month ago 
                                                                                
1
2
3
4
5
6
7
8
9
10

CREATE TABLE saved_searches (
    owner      TEXT NOT NULL,
    name       TEXT NOT NULL,
    query      TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    PRIMARY KEY (owner, name)
) WITHOUT ROWID;
CREATE INDEX idx_saved_searches_owner_updated
    ON saved_searches (owner, updated_at DESC);