From dc00439160dd68625f4f4ca0106a4a3a908404ce Mon Sep 17 00:00:00 2001
From: girst <tobi@isticktoit.net>
Date: Tue, 9 Jun 2020 18:39:19 +0200
Subject: [PATCH] schema for users table

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

diff --git a/config/setup.sql b/config/setup.sql
index 27e402c..f7285a6 100644
--- a/config/setup.sql
+++ b/config/setup.sql
@@ -32,3 +32,11 @@ CREATE TABLE cipher(
 	url TEXT,
 	sts INTEGER,
 	algorithm TEXT);
+CREATE TABLE users(
+	id INTEGER PRIMARY KEY AUTOINCREMENT,
+	name TEXT NOT NULL,
+	password TEXT NOT NULL,
+	token TEXT NOT NULL); -- TODO: move into user_tokens table
+-- CREATE TABLE user_tokens( -- stores retractable url tokens for feeds.
+-- 	user_id INTEGER NOT NULL,
+-- 	token TEXT NOT NULL);
-- 
2.39.3