summaryrefslogtreecommitdiffstats
path: root/flaskr/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'flaskr/schema.sql')
-rw-r--r--flaskr/schema.sql17
1 files changed, 0 insertions, 17 deletions
diff --git a/flaskr/schema.sql b/flaskr/schema.sql
deleted file mode 100644
index be76d7e..0000000
--- a/flaskr/schema.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-DROP TABLE IF EXISTS user;
-DROP TABLE IF EXISTS post;
-
-CREATE TABLE user (
- id INTEGER PRIMARY KEY AUTOINCREMENT,
- username TEXT UNIQUE NOT NULL,
- password TEXT NOT NULL
-);
-
-CREATE TABLE post (
- id INTEGER PRIMARY KEY AUTOINCREMENT,
- author_id INTEGER NOT NULL,
- created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- title TEXT NOT NULL,
- body TEXT NOT NULL,
- FOREIGN KEY (author_id) REFERENCES user (id)
-);