From a5a6c91ae5c72428a15de36f8256a2b7b3fd343c Mon Sep 17 00:00:00 2001
From: girst <tobi@isticktoit.net>
Date: Thu, 11 Jun 2020 19:49:57 +0200
Subject: [PATCH] add reddit database tables

---
 config/setup.sql | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

diff --git a/config/setup.sql b/config/setup.sql
index de81862..e4998be 100644
--- a/config/setup.sql
+++ b/config/setup.sql
@@ -1,3 +1,7 @@
+-- --------------- --
+-- YOUTUBE RELATED --
+-- --------------- --
+
 CREATE TABLE channels(
 	id STRING PRIMARY KEY,
 	name STRING);
@@ -33,6 +37,29 @@ CREATE TABLE cipher(
 	url TEXT,
 	sts INTEGER,
 	algorithm TEXT);
+
+-- -------------- --
+-- REDDIT RELATED --
+-- -------------- --
+
+CREATE TABLE subreddits(
+	subreddit STRING COLLATE NOCASE, -- e.g. videos (not /r/...)
+	user STRING,
+	PRIMARY KEY (subreddit, user));
+CREATE TABLE reddit_posts(
+	id STRING PRIMARY KEY, -- post id (without thing type 't3_')
+	subreddit STRING,
+	title STRING);
+CREATE TABLE reddit_flags(
+	user STRING,
+	post_id STRING,
+	display TEXT CHECK(display IN (NULL, 'pinned', 'hidden')),
+	PRIMARY KEY (user, post_id));
+
+-- ------ --
+-- SHARED --
+-- ------ --
+
 CREATE TABLE users(
 	id INTEGER PRIMARY KEY AUTOINCREMENT,
 	name TEXT NOT NULL,
-- 
2.39.3