diff options
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 ( |