From f165dc0202eb77cbfb51a35755fcfba3ad8d597f Mon Sep 17 00:00:00 2001 From: girst Date: Fri, 15 Oct 2021 05:39:49 +0200 Subject: [PATCH] commit database change to setup.sql --- config/setup.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/config/setup.sql b/config/setup.sql index 4d6ff93..05cfd5f 100644 --- a/config/setup.sql +++ b/config/setup.sql @@ -69,6 +69,7 @@ CREATE TABLE IF NOT EXISTS users( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE, password TEXT NOT NULL, + is_admin BOOLEAN DEFAULT 0, token TEXT NOT NULL); -- TODO: deprecated; use users.id instead CREATE TABLE IF NOT EXISTS user_tokens( -- stores revocable url tokens for feeds. user_id INTEGER PRIMARY KEY NOT NULL, -- 2.39.3