/apps/timeline/timeline.sql

 1BEGIN;
 2
 3CREATE TABLE entry
 4(
 5    id serial primary key,
 6    "start" timestamp with time zone,
 7    "end" timestamp with time zone,
 8    is_duration boolean,
 9    title text
10);
11
12CREATE TABLE session_base
13(
14	session_id text NOT NULL PRIMARY KEY,
15	last_active timestamp with time zone NOT NULL
16);
17
18CREATE TABLE session_data
19(
20	session_id text NOT NULL,
21	key text,
22	value text,
23	PRIMARY KEY (session_id, key)
24);
25
26create table session_form
27(
28    id serial primary key,
29    session_id text not null,
30    fields text not null
31);
32
33COMMIT;