about summary refs log tree commit diff
diff options
context:
space:
mode:
authorVincent Ambo <mail@tazj.in>2018-05-25T16·11+0200
committerVincent Ambo <github@tazj.in>2018-05-27T13·00+0200
commit468af132e89a8cb80392b7d6e12f1e53b849c0c1 (patch)
treef4877b500e25627a5f3b938692def8aa33cae925
parent33462c01fadc1093e1992f6277270ef809451841 (diff)
feat(db): Add migration & fields to indicate a thread is closed
-rw-r--r--migrations/2018-05-25-160648_add_closed_column/down.sql1
-rw-r--r--migrations/2018-05-25-160648_add_closed_column/up.sql1
-rw-r--r--src/models.rs1
-rw-r--r--src/schema.rs1
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,
     }
 }