Db8aNydP

1drop table if exists users;
2drop table if exists categories;
3
4create table users (
5	id integer primary key autoincrement,
6	username string,
7	password string,
8	email string,
9	hide_email bool,
10	admin bool
11);
12
13create table categories (
14	id integer primary key autoincrement,
15	name string not null
16);
17
18insert into users (username, password, admin) values ('admin', 'd869db7fe62fb07c25a0403ecaea55031744b5fb', 1);
19insert into categories (name) values ('test');
20insert into categories (name) values ('foo');
21insert into categories (name) values ('just');
22insert into categories (name) values ('because');
23insert into categories (name) values ('foobar');
24insert into categories (name) values ('hello world');