aboutsummaryrefslogtreecommitdiff
path: root/migrations/2020-09-22-104623_create_users
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2020-09-22-104623_create_users')
-rw-r--r--migrations/2020-09-22-104623_create_users/down.sql3
-rw-r--r--migrations/2020-09-22-104623_create_users/up.sql8
2 files changed, 11 insertions, 0 deletions
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 @@
1-- This file should undo anything in `up.sql`
2
3DROP 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 @@
1-- Your SQL goes here
2CREATE 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)