2 date TEXT NOT NULL PRIMARY KEY,
5 CREATE TABLE templates (
8 CREATE TABLE versioned_default_efforts (
9 template INTEGER NOT NULL,
10 datetime TEXT NOT NULL,
11 default_effort REAL NOT NULL,
12 PRIMARY KEY (template, datetime)
14 CREATE TABLE versioned_descriptions (
15 template INTEGER NOT NULL,
16 datetime TEXT NOT NULL,
17 description TEXT NOT NULL,
18 PRIMARY KEY (template, datetime)
20 CREATE TABLE versioned_titles (
21 template INTEGER NOT NULL,
22 datetime TEXT NOT NULL,
24 PRIMARY KEY (template, datetime)