From 28fb362147358819afeb0f0a5fa7a4ad136499ac Mon Sep 17 00:00:00 2001 From: lonkaars Date: Thu, 13 Jul 2023 16:39:01 +0200 Subject: ignore terms --- db/user/init.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'db/user') diff --git a/db/user/init.sql b/db/user/init.sql index 1d0e830..af60fa3 100644 --- a/db/user/init.sql +++ b/db/user/init.sql @@ -4,6 +4,8 @@ create table if not exists user ( unique(username) ); +insert into user (id, username) values (0, 'root'); + create table if not exists sort_overlay ( id integer primary key autoincrement, user_id int not null default 0, @@ -14,3 +16,6 @@ create table if not exists sort_overlay ( unique(user_id, expression, reading) on conflict replace ); +create index sort_overlay_expression on sort_overlay (expression); +create index sort_overlay_reading on sort_overlay (reading); + -- cgit v1.2.3