diff options
| author | Franklin Wei <me@fwei.tk> | 2018-06-28 20:44:12 -0400 |
|---|---|---|
| committer | Franklin Wei <me@fwei.tk> | 2018-06-28 20:44:21 -0400 |
| commit | 2c2257bf23358ec71cbe6420a3b398ffd63849cd (patch) | |
| tree | ce685ffa8b694d586a94e121b110d8e7df4ab2bc /sqlinit.txt | |
| parent | 3040965c03d9dc7b7762629d8b132716d4091f20 (diff) | |
| download | csaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.zip csaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.tar.gz csaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.tar.bz2 csaa-2c2257bf23358ec71cbe6420a3b398ffd63849cd.tar.xz | |
Remove unused column from FileLeaves and FileNodes tables
Diffstat (limited to 'sqlinit.txt')
| -rw-r--r-- | sqlinit.txt | 8 |
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 ( |