Something went wrong. Try again.
a simple rss/atom interface
Something went wrong. Try again.
343 B · 10 lines
SQL
at main
12345678910CREATE TABLE read_item ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, item_url TEXT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE, UNIQUE(user_id, item_url));
CREATE INDEX idx_read_item_user_url ON read_item(user_id, item_url);