diff options
Diffstat (limited to 'src/db/sql')
-rw-r--r-- | src/db/sql/1-init.sql | 10 | ||||
-rw-r--r-- | src/db/sql/2-primary-key-question-responses.sql | 20 | ||||
-rw-r--r-- | src/db/sql/3-drop-deck-read.sql | 1 |
3 files changed, 0 insertions, 31 deletions
diff --git a/src/db/sql/1-init.sql b/src/db/sql/1-init.sql deleted file mode 100644 index 29d70ed..0000000 --- a/src/db/sql/1-init.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE IF NOT EXISTS cards ( - question VARCHAR PRIMARY KEY, - responses VARCHAR NOT NULL, - state VARCHAR NOT NULL, - created TIMESTAMP NOT NULL, - updated TIMESTAMP NULL, - deleted TIMESTAMP NULL, - deck_read TIMESTAMP NOT NULL, - ready TIMESTAMP NOT NULL -) diff --git a/src/db/sql/2-primary-key-question-responses.sql b/src/db/sql/2-primary-key-question-responses.sql deleted file mode 100644 index cb7df21..0000000 --- a/src/db/sql/2-primary-key-question-responses.sql +++ /dev/null @@ -1,20 +0,0 @@ -/* Allows to use ON CONFLICT on (question, responses) when inserting a card. */ - -CREATE TABLE IF NOT EXISTS cards_copy ( - question VARCHAR NOT NULL, - responses VARCHAR NOT NULL, - state VARCHAR NOT NULL, - created TIMESTAMP NOT NULL, - updated TIMESTAMP NULL, - deleted TIMESTAMP NULL, - deck_read TIMESTAMP NOT NULL, - ready TIMESTAMP NOT NULL, - PRIMARY KEY (question, responses) -); - -INSERT INTO cards_copy (question, responses, state, created, updated, deleted, deck_read, ready) - SELECT question, responses, state, created, updated, deleted, deck_read, ready FROM cards; - -DROP TABLE cards; - -ALTER TABLE cards_copy RENAME TO cards; diff --git a/src/db/sql/3-drop-deck-read.sql b/src/db/sql/3-drop-deck-read.sql deleted file mode 100644 index 1ca23d1..0000000 --- a/src/db/sql/3-drop-deck-read.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE cards DROP COLUMN deck_read; |