From 057382f8d138c63cdc48b0facd9bf4a4a229057a Mon Sep 17 00:00:00 2001
From: Akshay <nerdy@peppe.rs>
Date: Sun, 4 Oct 2020 13:23:46 +0530
Subject: init

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

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

diff --git a/migrations/2020-09-22-104623_create_users/down.sql b/migrations/2020-09-22-104623_create_users/down.sql
new file mode 100644
index 0000000..2c92cb7
--- /dev/null
+++ b/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/migrations/2020-09-22-104623_create_users/up.sql b/migrations/2020-09-22-104623_create_users/up.sql
new file mode 100644
index 0000000..dfd27d9
--- /dev/null
+++ b/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