xref: /plugin/struct/db/update0005.sql (revision 49d385736e9d9750c47001456827fe8af155ff49)

CREATE TABLE schema_assignments_patterns (
    pattern NOT NULL,
    tbl NOT NULL,
    PRIMARY KEY(pattern, tbl)
);
INSERT INTO schema_assignments_patterns SELECT * FROM schema_assignments;
DELETE FROM schema_assignments;