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
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