Add users table to schema.

3 files changed, 25 insertions, 0 deletions

diff --git a/migrations/2018-01-18-202058_create_users/down.sql b/migrations/2018-01-18-202058_create_users/down.sql
new file mode 100644
index 0000000..dc3714b
--- /dev/null
+++ b/migrations/2018-01-18-202058_create_users/down.sql
@@ -0,0 +1,2 @@
+-- This file should undo anything in `up.sql`
+DROP TABLE users;
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
+)
diff --git a/src/schema.rs b/src/schema.rs
index 3124ea5..ad122fd 100644
--- a/src/schema.rs
+++ b/src/schema.rs
@@ -6,3 +6,18 @@ table! {
         published -> Bool,
     }
 }
+
+table! {
+    users (id) {
+        id -> Int4,
+        username -> Varchar,
+        realname -> Nullable<Varchar>,
+        email -> Nullable<Varchar>,
+        password -> Varchar,
+    }
+}
+
+allow_tables_to_appear_in_same_query!(
+    posts,
+    users,
+);