1 pragma foreign_keys = ON;
3 create table if not exists users (
4 id varchar(24) primary key not null,
5 name varchar(255) default "human"
8 create table if not exists flavors (
9 name varchar(255) primary key not null
12 insert or ignore into flavors values
19 create table if not exists coffees (
20 num integer primary key,
21 id varchar(24) references users(id), -- id may be unknown
22 flavor varchar(255) not null references flavors(name),
23 time datetime default current_timestamp
27 create table if not exists days (
28 num integer primary key not null
31 insert or ignore into days values
32 (0),(1),(2),(3),(4),(5),(6)