diff options
| author | Joris | 2021-11-14 23:25:55 +0100 |
|---|---|---|
| committer | Joris | 2021-11-19 11:42:20 +0100 |
| commit | 9f94611a42d41cf94cdccb00b5d2eec0d5d02970 (patch) | |
| tree | 9bab5bc342e22aa38b13a2dbd3525bbfe2beedb5 /src/db/sql | |
| parent | 59c44b15010eea5490896a5b5d427b415ad6f56a (diff) | |
Add initial working version
Diffstat (limited to 'src/db/sql')
| -rw-r--r-- | src/db/sql/1-init.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/src/db/sql/1-init.sql b/src/db/sql/1-init.sql new file mode 100644 index 0000000..29d70ed --- /dev/null +++ b/src/db/sql/1-init.sql @@ -0,0 +1,10 @@ +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 +) |