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