92 PRIMARY KEY(listidx, suprev, supidx), |
92 PRIMARY KEY(listidx, suprev, supidx), |
93 FOREIGN KEY (suprev, supidx) REFERENCES range(rev, idx), |
93 FOREIGN KEY (suprev, supidx) REFERENCES range(rev, idx), |
94 FOREIGN KEY (subrev, subidx) REFERENCES range(rev, idx) |
94 FOREIGN KEY (subrev, subidx) REFERENCES range(rev, idx) |
95 );""", |
95 );""", |
96 "CREATE INDEX subranges_index ON subranges (suprev, supidx);", |
96 "CREATE INDEX subranges_index ON subranges (suprev, supidx);", |
|
97 "CREATE INDEX superranges_index ON subranges (subrev, subidx);", |
97 "CREATE INDEX range_index ON range (rev, idx);", |
98 "CREATE INDEX range_index ON range (rev, idx);", |
98 ] |
99 ] |
99 _newmeta = "INSERT INTO meta (schemaversion, tiprev, tipnode) VALUES (?,?,?);" |
100 _newmeta = "INSERT INTO meta (schemaversion, tiprev, tipnode) VALUES (?,?,?);" |
100 _updatemeta = "UPDATE meta SET tiprev = ?, tipnode = ?;" |
101 _updatemeta = "UPDATE meta SET tiprev = ?, tipnode = ?;" |
101 _updaterange = "INSERT INTO range(rev, idx) VALUES (?,?);" |
102 _updaterange = "INSERT INTO range(rev, idx) VALUES (?,?);" |