PageRenderTime 4ms CodeModel.GetById 0ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/apps/timeline/timeline.sql

http://zoop.googlecode.com/
SQL | 33 lines | 28 code | 5 blank | 0 comment | 0 complexity | 66fbd0e3de28ac036b10395dc5bd8547 MD5 | raw file
 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;