· 8 years ago · Aug 23, 2018, 09:56 PM
1CREATE TABLE IF NOT EXISTS RUNS (
2 runsid INTEGER PRIMARY KEY AUTOINCREMENT,
3 programname TEXT,
4 args TEXT,
5 whitelist TEXT,
6 blacklist TEXT,
7 username TEXT,
8 timestamp TEXT)
9
10CREATE TABLE IF NOT EXISTS LINES (
11 runsid INTEGER REFERENCES RUNS (runsid),
12 linesid INTEGER KEY,
13 filepath TEXT,
14 linenum INTEGER,
15 timestamp TEXT,
16 PRIMARY KEY (runsid, linesid))
17
18CREATE TABLE IF NOT EXISTS VARS (
19 runsid INTEGER REFERENCES RUNS (runsid),
20 varsid INTEGER,
21 linesid INTEGER REFERENCES LINES (linesid),
22 name TEXT,
23 type TEXT,
24 PRIMARY KEY (runsid, varsid))
25
26CREATE TABLE IF NOT EXISTS VARVALUES (
27 runsid INTEGER REFERENCES RUNS (runsid),
28 varvaluesid INTEGER,
29 varsid INTEGER REFERENCES VARS (varsid),
30 linesid INTEGER REFERENCES LINES (linesid),
31 value TEXT,
32 type TEXT,
33 PRIMARY KEY (runsid, varvaluesid))
34
35CREATE TABLE IF NOT EXISTS VARDEATH (
36 runsid INTEGER REFERENCES RUNS (runsid),
37 vardeathid INTEGER,
38 varsid INTEGER REFERENCES VARS (varsid),
39 linesid INTEGER REFERENCES LINES (linesid),
40 PRIMARY KEY (runsid, vardeathid))
41
42CREATE TABLE IF NOT EXISTS VARUSED (
43 runsid INTEGER REFERENCES RUNS (runsid),
44 linesid INTEGER,
45 varsid INTEGER,
46 PRIMARY KEY (runsid, linesid, varsid))
47
48CREATE TABLE IF NOT EXISTS PROGRAMEXIT (
49 runsid INTEGER PRIMARY KEY REFERENCES RUNS (runsid),
50 exitcode INTEGER,
51 exception TEXT)
52
53INSERT INTO RUNS
54 (runsid, programname, args, whitelist, blacklist, username, timestamp)
55 VALUES (NULL, ?, ?, ?, ?, ?, ?)
56
57INSERT INTO LINES
58 (runsid, linesid, filepath, linenum, timestamp)
59 VALUES (?, ?, ?, ?, ?)
60
61INSERT INTO VARS
62 (runsid, varsid, linesid, name, type)
63 VALUES (?, ?, ?, ?, ?)
64
65INSERT INTO VARVALUES
66 (runsid, varvaluesid, varsid, linesid, value, type)
67 VALUES (?, ?, ?, ?, ?, ?)
68
69INSERT INTO VARDEATH
70 (runsid, vardeathid, varsid, linesid)
71 VALUES (?, ?, ?, ?)
72
73INSERT INTO VARUSED
74 (runsid, linesid, varsid)
75 VALUES (?, ?, ?)
76
77INSERT INTO PROGRAMEXIT
78 (runsid, exitcode, exception)
79 VALUES (?, ?, ?)