From 9e011074bcc80e00e6deb5b914371718e5991ce2 Mon Sep 17 00:00:00 2001
From: Adam Mathes <adam@trenchant.org>
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

