-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
33 lines (30 loc) · 840 Bytes
/
schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
DROP TABLE IF EXISTS category;
--DROP TABLE IF EXISTS feed;
DROP TABLE IF EXISTS article;
CREATE TABLE category (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
show_in_main BOOL
);
CREATE TABLE IF NOT EXISTS feed (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
url TEXT NOT NULL,
site_url TEXT NOT NULL,
category_id INTEGER,
FOREIGN KEY(category_id) REFERENCES category(id)
);
CREATE TABLE article (
id INTEGER PRIMARY KEY AUTOINCREMENT, -- db id
post_id TEXT NOT NULL, -- id given in the feed
title TEXT NOT NULL,
url TEXT,
read BOOL,
summary TEXT,
content TEXT,
date_published TIMESTAMP,
date_fetched TIMESTAMP,
feed_id INTEGER NOT NULL,
UNIQUE(feed_id, post_id) ON CONFLICT IGNORE,
FOREIGN KEY(feed_id) REFERENCES feed(id)
)