FvMRp3Ht

1CREATE TABLE IF NOT EXISTS table1 (
2  id_a          INT NOT NULL,
3  id_b          INT NOT NULL,
4  PRIMARY KEY (id_a, id_b)
5);
6
7CREATE TABLE IF NOT EXISTS table2 (
8  id_a           INT NOT NULL,
9  id_b           INT NOT NULL,
10  another_column TEXT NOT NULL,
11  PRIMARY KEY (id_a, id_b),
12  FOREIGN KEY (id_a, id_b) REFERENCES tabl1 (id_a, id_b) ON DELETE CASCADE