xref: /plugin/struct/db/update0002.sql (revision e6a2e26b57dd1411a582eba0bdba877d874c7fa3)
1-- what schemas are currently assigned to a page
2-- we do not store any timestamps or schemaIDs here because this always holds the
3-- current state only. Old states are determined by the actually saved data for a page
4-- at that time
5CREATE TABLE schema_assignments (
6    assign NOT NULL,
7    tbl NOT NULL,
8    PRIMARY KEY(assign, tbl)
9);
10