1DROP TABLE schema_assignments; 2-- this table now will hold information about all pages that ever had a schema assigned 3-- which is basically the same as all pages that ever had struct data saved 4CREATE TABLE schema_assignments ( 5 pid NOT NULL, 6 tbl NOT NULL, 7 assigned BOOLEAN NOT NULL DEFAULT 1, 8 PRIMARY KEY(pid, tbl) 9); 10