2 date TEXT NOT NULL PRIMARY KEY,
5 CREATE TABLE templates (
6 id INTEGER PRIMARY KEY,
10 CREATE TABLE versioned_default_efforts (
11 template INTEGER NOT NULL,
12 datetime TEXT NOT NULL,
13 default_effort REAL NOT NULL,
14 PRIMARY KEY (template, datetime)
16 CREATE TABLE versioned_descriptions (
17 template INTEGER NOT NULL,
18 datetime TEXT NOT NULL,
19 description TEXT NOT NULL,
20 PRIMARY KEY (template, datetime)
22 CREATE TABLE versioned_titles (
23 template INTEGER NOT NULL,
24 datetime TEXT NOT NULL,
26 PRIMARY KEY (template, datetime)