From 2c2257bf23358ec71cbe6420a3b398ffd63849cd Mon Sep 17 00:00:00 2001 From: Franklin Wei Date: Thu, 28 Jun 2018 20:44:12 -0400 Subject: Remove unused column from FileLeaves and FileNodes tables --- sqlinit.txt | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) (limited to 'sqlinit.txt') 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 ( -- cgit v1.1