From 9d2b6ee10ec5359cc91769d430485c8c869ba1a8 Mon Sep 17 00:00:00 2001
From: Akshay <nerdy@peppe.rs>
Date: Thu, 24 Dec 2020 10:51:40 +0530
Subject: monorepo

---
 backend/migrations/2020-09-22-104623_create_users/down.sql | 3 +++
 backend/migrations/2020-09-22-104623_create_users/up.sql   | 8 ++++++++
 2 files changed, 11 insertions(+)
 create mode 100644 backend/migrations/2020-09-22-104623_create_users/down.sql
 create mode 100644 backend/migrations/2020-09-22-104623_create_users/up.sql

(limited to 'backend/migrations/2020-09-22-104623_create_users')

diff --git a/backend/migrations/2020-09-22-104623_create_users/down.sql b/backend/migrations/2020-09-22-104623_create_users/down.sql
new file mode 100644
index 0000000..2c92cb7
--- /dev/null
+++ b/backend/migrations/2020-09-22-104623_create_users/down.sql
@@ -0,0 +1,3 @@
+-- This file should undo anything in `up.sql`
+
+DROP TABLE members;
diff --git a/backend/migrations/2020-09-22-104623_create_users/up.sql b/backend/migrations/2020-09-22-104623_create_users/up.sql
new file mode 100644
index 0000000..dfd27d9
--- /dev/null
+++ b/backend/migrations/2020-09-22-104623_create_users/up.sql
@@ -0,0 +1,8 @@
+-- Your SQL goes here
+CREATE TABLE members (
+    id INTEGER PRIMARY KEY AUTO_INCREMENT,
+    username VARCHAR(255) NOT NULL UNIQUE,
+    password VARCHAR(255) NOT NULL,
+    phone_number VARCHAR(10) NOT NULL,
+    email_id VARCHAR(255) NOT NULL
+)
-- 
cgit v1.2.3