From 43f9d78f8c00e13732b809519f0529ac293fd5ab Mon Sep 17 00:00:00 2001 From: Mitsuo Tokumori Date: Sun, 29 Oct 2023 07:41:04 -0500 Subject: Rename to ustayml (u-stayML) --- flaskr/schema.sql | 17 ----------------- 1 file changed, 17 deletions(-) delete mode 100644 flaskr/schema.sql (limited to 'flaskr/schema.sql') 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) -); -- cgit v1.2.3