summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorLuke Barnard <lukeb@openmarket.com>2017-10-26 17:38:14 +0100
committerLuke Barnard <lukeb@openmarket.com>2017-10-26 17:38:14 +0100
commit713e60b9b6658d611b399d80a6ae429946713689 (patch)
treed30606ef4aaadf5eeaac4a5fa0e4a4f226e0196c /synapse/storage/schema/delta
parentAdd groups table to BOOLEAN_COLUMNS in synapse_port_db (diff)
downloadsynapse-713e60b9b6658d611b399d80a6ae429946713689.tar.xz
Awful hack to get default true
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/46/group_server.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/46/group_server.sql b/synapse/storage/schema/delta/46/group_server.sql
index 23ee1194d3..a892cff7e5 100644
--- a/synapse/storage/schema/delta/46/group_server.sql
+++ b/synapse/storage/schema/delta/46/group_server.sql
@@ -14,4 +14,5 @@
  */
 
 -- whether non-members can access group APIs
-ALTER TABLE groups ADD COLUMN is_public BOOL DEFAULT 1 NOT NULL;
+-- NB: awful hack to get the default to be true on postgres and 1 on sqlite
+ALTER TABLE groups ADD COLUMN is_public BOOL DEFAULT (1=1) NOT NULL;