summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
index cb6a2c5..13a65aa 100644
--- a/schema.sql
+++ b/schema.sql
@@ -17,3 +17,4 @@ CREATE TABLE sharing (
size INTEGER);
CREATE INDEX sharing_insert_index ON sharing (pid1, pid2, fid1, fid2);
CREATE TABLE duplicate (cid INTEGER PRIMARY KEY, FOREIGN KEY (cid) REFERENCES content(id) ON DELETE CASCADE);
+CREATE TABLE issue (cid INTEGER REFERENCES content(id) ON DELETE CASCADE, issue TEXT);