element-hq / element-hq/synapse

rooms table has a bunch of nullable columns

Open
#16,614 0 comments 0 reactions 0 assignees View on GitHub
A-Database T-Task
Dominant language
Python
Stars
4.6k
Forks
600
Avg merge
5d 22h
Merged PRs (30d)
51

Description

This issue has been migrated from [#16614](https://github.com/matrix-org/synapse/issues/16614).

---

See https://github.com/matrix-org/synapse/pull/16612#discussion_r1388011390, but `rooms` has the following nullable columns:

* `is_public`
* `creator`
* `room_version`
* `has_auth_chain_index`

The latter two were added to the table which is why they're nullable, but I suspect we can fill those in / add a constraint now?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.