feat(db): Add migration & fields to indicate a thread is closed

4 files changed, 4 insertions, 0 deletions

diff --git a/migrations/2018-05-25-160648_add_closed_column/down.sql b/migrations/2018-05-25-160648_add_closed_column/down.sql
new file mode 100644
index 000000000000..fb2a98c0af42
--- /dev/null
+++ b/migrations/2018-05-25-160648_add_closed_column/down.sql
@@ -0,0 +1 @@
+ALTER TABLE threads DROP COLUMN closed;
diff --git a/migrations/2018-05-25-160648_add_closed_column/up.sql b/migrations/2018-05-25-160648_add_closed_column/up.sql
new file mode 100644
index 000000000000..d7d4c44da201
--- /dev/null
+++ b/migrations/2018-05-25-160648_add_closed_column/up.sql
@@ -0,0 +1 @@
+ALTER TABLE threads ADD COLUMN closed BOOLEAN NOT NULL DEFAULT false;
diff --git a/src/models.rs b/src/models.rs
index 3ad4a5ed9d7d..006596fd8331 100644
--- a/src/models.rs
+++ b/src/models.rs
@@ -39,6 +39,7 @@ pub struct Thread {
     pub posted: DateTime<Utc>,
     pub sticky: bool,
     pub user_id: i32,
+    pub closed: bool,
 }
 
 #[derive(Identifiable, Queryable, Serialize, Associations)]
diff --git a/src/schema.rs b/src/schema.rs
index a824c658c00f..f163f4b1e7ea 100644
--- a/src/schema.rs
+++ b/src/schema.rs
@@ -33,6 +33,7 @@ table! {
         posted -> Timestamptz,
         sticky -> Bool,
         user_id -> Int4,
+        closed -> Bool,
     }
 }