diff options
| -rw-r--r-- | db/schema_0022-add_interest_count_to_problems.sql | 2 | ||||
| -rw-r--r-- | db/schema_0026-change_interest_count_default.sql | 9 |
2 files changed, 1 insertions, 10 deletions
diff --git a/db/schema_0022-add_interest_count_to_problems.sql b/db/schema_0022-add_interest_count_to_problems.sql index 62092aa0a..4a4703ae1 100644 --- a/db/schema_0022-add_interest_count_to_problems.sql +++ b/db/schema_0022-add_interest_count_to_problems.sql @@ -1,6 +1,6 @@ begin; ALTER table problem - ADD COLUMN interest_count integer; + ADD COLUMN interest_count integer DEFAULT 0; commit; diff --git a/db/schema_0026-change_interest_count_default.sql b/db/schema_0026-change_interest_count_default.sql deleted file mode 100644 index 7c78f6fe8..000000000 --- a/db/schema_0026-change_interest_count_default.sql +++ /dev/null @@ -1,9 +0,0 @@ -BEGIN; - - ALTER TABLE problem - ALTER COLUMN interest_count SET DEFAULT 0; - - UPDATE problem SET interest_count = 0 - WHERE interest_count IS NULL; - -COMMIT; |