diff options
| author | Mitsuo Tokumori <[email protected]> | 2023-10-29 07:41:04 -0500 |
|---|---|---|
| committer | Mitsuo Tokumori <[email protected]> | 2023-10-29 07:41:04 -0500 |
| commit | 43f9d78f8c00e13732b809519f0529ac293fd5ab (patch) | |
| tree | d9779a6d4b511dd27cfe80b3f8d0ad2e5ef5d7da /flaskr/schema.sql | |
| parent | de8b3d760a37fc54645a2588b062f85963146070 (diff) | |
| download | ustayml-43f9d78f8c00e13732b809519f0529ac293fd5ab.tar.gz ustayml-43f9d78f8c00e13732b809519f0529ac293fd5ab.tar.bz2 ustayml-43f9d78f8c00e13732b809519f0529ac293fd5ab.zip | |
Rename to ustayml (u-stayML)
Diffstat (limited to 'flaskr/schema.sql')
| -rw-r--r-- | flaskr/schema.sql | 17 |
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) -); |