# # # patch "schema.sql" # from [f9c13c1cc7ea3fa4ba4196b9291582b74a161c14] # to [c093f206468fcc6663167a57258c07adb9c33880] # ============================================================ --- schema.sql f9c13c1cc7ea3fa4ba4196b9291582b74a161c14 +++ schema.sql c093f206468fcc6663167a57258c07adb9c33880 @@ -48,6 +48,8 @@ CREATE TABLE revision_ancestry unique(parent, child) ); +CREATE INDEX revision_ancestry__child ON revision_ancestry (child); + CREATE TABLE heights ( revision not null, -- joins with revisions.id @@ -77,8 +79,6 @@ CREATE TABLE next_roster_node_number node primary key -- only one entry in this table, ever ); -CREATE INDEX revision_ancestry__child ON revision_ancestry (child); - -- structures for managing RSA keys and file / revision certs CREATE TABLE public_keys