1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
ALTER TABLE "cards" RENAME TO "cards_non_strict";
CREATE TABLE IF NOT EXISTS "cards" (
question TEXT NOT NULL,
responses TEXT NOT NULL,
state TEXT NOT NULL,
created INTEGER NOT NULL, /* TIMESTAMP */
updated INTEGER NULL, /* TIMESTAMP */
deleted INTEGER NULL, /* TIMESTAMP */
ready INTEGER NOT NULL, /* TIMESTAMP */
PRIMARY KEY (question, responses)
) STRICT;
INSERT INTO cards (question, responses, state, created, updated, deleted, ready)
SELECT question, responses, state, created, updated, deleted, ready
FROM cards_non_strict;
DROP TABLE cards_non_strict;
|
