aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFranklin Wei <me@fwei.tk>2018-06-28 20:44:12 -0400
committerFranklin Wei <me@fwei.tk>2018-06-28 20:44:21 -0400
commit2c2257bf23358ec71cbe6420a3b398ffd63849cd (patch)
treece685ffa8b694d586a94e121b110d8e7df4ab2bc
parent3040965c03d9dc7b7762629d8b132716d4091f20 (diff)
downloadcsaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.zip
csaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.tar.gz
csaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.tar.bz2
csaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.tar.xz
Remove unused column from FileLeaves and FileNodes tables
-rw-r--r--sqlinit.txt8
1 files changed, 2 insertions, 6 deletions
diff --git a/sqlinit.txt b/sqlinit.txt
index b5c5196..8f17229 100644
--- a/sqlinit.txt
+++ b/sqlinit.txt
@@ -8,21 +8,17 @@ ACL_logleaves INTEGER
);
CREATE TABLE FileLeaves (
-FileIdx INTEGER,
LeafIdx INTEGER,
Idx INTEGER,
NextIdx INTEGER,
Val BLOB,
-PRIMARY KEY (FileIdx, LeafIdx),
-FOREIGN KEY (FileIdx) REFERENCES FileRecords(Idx)
+PRIMARY KEY (LeafIdx)
);
CREATE TABLE FileNodes (
-FileIdx INTEGER,
NodeIdx INTEGER,
Val BLOB,
-PRIMARY KEY (FileIdx, NodeIdx),
-FOREIGN KEY (FileIdx) REFERENCES FileRecords(Idx)
+PRIMARY KEY (NodeIdx)
);
CREATE TABLE Versions (