From 9e011074bcc80e00e6deb5b914371718e5991ce2 Mon Sep 17 00:00:00 2001 From: Adam Mathes Date: Tue, 12 Jun 2018 14:58:02 -0700 Subject: sqlite3 support --- sqlite.init.sql | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 sqlite.init.sql (limited to 'sqlite.init.sql') diff --git a/sqlite.init.sql b/sqlite.init.sql new file mode 100644 index 0000000..d4d08c8 --- /dev/null +++ b/sqlite.init.sql @@ -0,0 +1,30 @@ +CREATE TABLE IF NOT EXISTS "feed" ( + "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + "url" varchar(100) NOT NULL UNIQUE, + "web_url" varchar(255) NOT NULL DEFAULT '', + "title" varchar(255) NOT NULL DEFAULT '', + "last_updated" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + "category" varchar(255) NOT NULL DEFAULT 'uncategorized' +); +CREATE INDEX "feed_url" ON "feed" ("url"); +CREATE INDEX "feed_category" ON "feed" ("category"); +CREATE INDEX "feed_id" ON "feed" ("id"); + +CREATE TABLE IF NOT EXISTS "item" ( + "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + "feed_id" int(11) NOT NULL, + "title" text NOT NULL DEFAULT '', + "url" varchar(255) NOT NULL UNIQUE, + "description" text NOT NULL DEFAULT '', + "publish_date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + "read_state" tinyint(1) NOT NULL DEFAULT '0', + "starred" tinyint(1) NOT NULL DEFAULT '0', + "full_content" text NOT NULL DEFAULT '', + "header_image" text NOT NULL DEFAULT '', + CONSTRAINT "item_ibfk_1" FOREIGN KEY ("feed_id") REFERENCES "feed" ("id") ON DELETE CASCADE +); +CREATE INDEX "item_url" ON "item" ("url"); +CREATE INDEX "item_publish_date" ON "item" ("publish_date"); +CREATE INDEX "item_feed_id" ON "item" ("feed_id"); +CREATE INDEX "item_rev_id" ON "item" ("id"); +CREATE INDEX "item_read_state" ON "item" ("read_state"); -- cgit v1.2.3