1 files changed, 8 insertions, 0 deletions
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
+)

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 @@
	1	-- Your SQL goes here
	2	CREATE TABLE members (
	3	id INTEGER PRIMARY KEY AUTO_INCREMENT,
	4	username VARCHAR(255) NOT NULL UNIQUE,
	5	password VARCHAR(255) NOT NULL,
	6	phone_number VARCHAR(10) NOT NULL,
	7	email_id VARCHAR(255) NOT NULL
	8	)