ignore terms

1 files changed, 5 insertions, 0 deletions

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);
+