1CREATE TABLE schema_assignments_patterns (
2    pattern NOT NULL,
3    tbl NOT NULL,
4    PRIMARY KEY(pattern, tbl)
5);
6INSERT INTO schema_assignments_patterns SELECT * FROM schema_assignments;
7DELETE FROM schema_assignments;
8