Line # Revision Author
1 76 dpavlin CREATE TABLE wn_workspaces(
2 wsid serial,
3 wsname TEXT NOT NULL,
4 nextNoteNum INT NOT NULL,
5 82 dpavlin time timestamp NOT NULL default now(),
6 76 dpavlin primary key(wsid)
7 );
8
9 CREATE TABLE wn_notes (
10 nid serial,
11 noteid TEXT NOT NULL,
12 content TEXT NOT NULL,
13 bgcolor TEXT NOT NULL,
14 xposition INT NOT NULL,
15 yposition INT NOT NULL,
16 height INT NOT NULL,
17 width INT NOT NULL,
18 zindex INT NOT NULL,
19 wsid INT NOT NULL references wn_workspaces(wsid),
20 82 dpavlin time timestamp NOT NULL default now(),
21 76 dpavlin primary key(nid)
22 );
23
24 create index wn_notes_wsid on wn_notes(wsid);
25