From de3ec1fbef726e3794096d99cb1f3ca7066a5768 Mon Sep 17 00:00:00 2001
From: Struan Donald <struan@exo.org.uk>
Date: Tue, 9 Oct 2012 13:10:23 +0100
Subject: set interest_count default to 0 as null + 1 = null in postgres :(
 tests for the ui for interest_count as well

---
 db/schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'db/schema.sql')

diff --git a/db/schema.sql b/db/schema.sql
index 8757cf80e..7cb2f3257 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -217,7 +217,7 @@ create table problem (
     external_source_id text,
 
     -- number of me toos
-    interest_count integer
+    interest_count integer default 0
 );
 create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude);
 create index problem_user_id_idx on problem ( user_id );
-- 
cgit v1.2.3

