xref: /plugin/ireadit/db/update0001.sql (revision 85300102eeb4c8e415de0f1ac21287aaee10e4bc)
1CREATE TABLE ireadit (
2    id INTEGER PRIMARY KEY,
3    page TEXT NOT NULL,
4    rev INTEGER NOT NULL DEFAULT 0
5);
6
7CREATE TABLE ireadit_user(
8    ireadit_id INTEGER NOT NULL,
9    user TEXT NOT NULL,
10    timestamp TEXT NULL,
11    PRIMARY KEY (ireadit_id, user)
12);
13