From 43f9d78f8c00e13732b809519f0529ac293fd5ab Mon Sep 17 00:00:00 2001
From: Mitsuo Tokumori <rtokumori@pucp.edu.pe>
Date: Sun, 29 Oct 2023 07:41:04 -0500
Subject: Rename to ustayml (u-stayML)

---
 ustayml/schema.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 ustayml/schema.sql

(limited to 'ustayml/schema.sql')

diff --git a/ustayml/schema.sql b/ustayml/schema.sql
new file mode 100644
index 0000000..be76d7e
--- /dev/null
+++ b/ustayml/schema.sql
@@ -0,0 +1,17 @@
+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

