aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/2018-01-18-202058_create_users/up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2018-01-18-202058_create_users/up.sql')
-rw-r--r--migrations/2018-01-18-202058_create_users/up.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/migrations/2018-01-18-202058_create_users/up.sql b/migrations/2018-01-18-202058_create_users/up.sql
new file mode 100644
index 0000000..fee1340
--- /dev/null
+++ b/migrations/2018-01-18-202058_create_users/up.sql
@@ -0,0 +1,8 @@
+-- Create users table
+CREATE TABLE users (
+ id SERIAL PRIMARY KEY,
+ username VARCHAR NOT NULL,
+ realname VARCHAR,
+ email VARCHAR,
+ password VARCHAR NOT NULL
+)