1PRAGMA foreign_keys=OFF; 2 3CREATE TEMPORARY TABLE acks_temp 4( 5 page TEXT NOT NULL REFERENCES pages (page) ON DELETE CASCADE, 6 user TEXT NOT NULL, 7 ack INT NOT NULL, 8 PRIMARY KEY (page, user) 9); 10 11INSERT INTO acks_temp (page,user,ack) SELECT page,user,ack FROM acks; 12 13DROP TABLE acks; 14 15CREATE TABLE acks 16( 17 page TEXT NOT NULL REFERENCES pages (page), 18 user TEXT NOT NULL, 19 ack INT NOT NULL, 20 PRIMARY KEY (page, user, ack) 21); 22 23INSERT INTO acks (page,user,ack) SELECT page,user,ack FROM acks_temp; 24 25DROP TABLE acks_temp; 26 27PRAGMA foreign_keys=ON; 28