diff options
Diffstat (limited to 'synapse/storage')
| -rw-r--r-- | synapse/storage/schema/delta/56/stats_separated1.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/synapse/storage/schema/delta/56/stats_separated1.sql b/synapse/storage/schema/delta/56/stats_separated1.sql index 19a91416c2..1e17eae226 100644 --- a/synapse/storage/schema/delta/56/stats_separated1.sql +++ b/synapse/storage/schema/delta/56/stats_separated1.sql @@ -71,12 +71,12 @@ CREATE TABLE IF NOT EXISTS room_stats_current ( start_ts BIGINT, end_ts BIGINT, - current_state_events INT NOT NULL DEFAULT 0, - total_events INT NOT NULL DEFAULT 0, - joined_members INT NOT NULL DEFAULT 0, - invited_members INT NOT NULL DEFAULT 0, - left_members INT NOT NULL DEFAULT 0, - banned_members INT NOT NULL DEFAULT 0, + current_state_events INT NOT NULL, + total_events INT NOT NULL, + joined_members INT NOT NULL, + invited_members INT NOT NULL, + left_members INT NOT NULL, + banned_members INT NOT NULL, -- If initial stats regen is still to be performed: NULL -- If initial stats regen has been performed: the maximum delta stream @@ -120,8 +120,8 @@ CREATE TABLE IF NOT EXISTS user_stats_current ( start_ts BIGINT, end_ts BIGINT, - public_rooms INT DEFAULT 0 NOT NULL, - private_rooms INT DEFAULT 0 NOT NULL, + public_rooms INT NOT NULL, + private_rooms INT NOT NULL, -- If initial stats regen is still to be performed: NULL -- If initial stats regen has been performed: the maximum delta stream |