diff options
Diffstat (limited to 'db/user/init.sql')
| -rw-r--r-- | db/user/init.sql | 5 |
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); + |