blob: c3ae440cd6cfaec06a8226a2539c8581c99de131 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
DROP TABLE IF EXISTS project;
CREATE TABLE project (
title VARCHAR(64) NOT NULL,
body TEXT DEFAULT NULL,
difficulty INT NOT NULL DEFAULT 1 REFERENCES difficulty(diff),
trigger_date DATE DEFAULT NULL,
started DATE NOT NULL DEFAULT CURRENT_DATE,
span INT NOT NULL DEFAULT 7 -- time to last for in days
);
DROP TABLE IF EXISTS difficulty;
CREATE TABLE difficulty (
diff VARCHAR(16)
);
DROP TABLE IF EXISTS tag;
CREATE TABLE tag (
t VARCHAR(16)
);
DROP TABLE IF EXISTS project_tag;
CREATE TABLE project_tag (
project INT REFERENCES project(rowid),
tag INT REFERENCES tag(rowid)
);
DROP TABLE IF EXISTS assignment;
CREATE TABLE assignment (
who VARCHAR(32) NOT NULL,
repo_link VARCHAR(128) DEFAULT NULL,
project INT NOT NULL REFERENCES project(rowid)
);
|
