summary |
shortlog |
log |
commit | commitdiff |
tree
raw |
patch |
inline | side by side (from parent 1:
1c9c923)
So we must fix the schema, and include the volume name in the primary
key. This is still early days, so I'm just going to break it.
fs TEXT NOT NULL,
date TEXT NOT NULL,
vol TEXT NOT NULL,
fs TEXT NOT NULL,
date TEXT NOT NULL,
vol TEXT NOT NULL,
- PRIMARY KEY (host, fs, date));
+ PRIMARY KEY (host, fs, vol, date));
+CREATE INDEX idx_byhostfsdate ON idx (host, fs, date);
CREATE INDEX idx_byvol ON idx (vol);
EOF
CREATE INDEX idx_byvol ON idx (vol);
EOF