diff options
| author | David Baker <dave@matrix.org> | 2018-07-19 10:28:26 +0100 |
|---|---|---|
| committer | David Baker <dave@matrix.org> | 2018-07-19 10:28:26 +0100 |
| commit | 022469d8193596d9b93b049606db8fc40d939f19 (patch) | |
| tree | 53374fc71b711d81987bcc646787f2e640e7a021 | |
| parent | Add hopefully enlightening comment (diff) | |
| download | synapse-022469d8193596d9b93b049606db8fc40d939f19.tar.xz | |
Change column def so it works on pgsql & sqlite
Now I remember discovering previously there was no way to make boolean columns work
| -rw-r--r-- | synapse/storage/schema/delta/50/profiles_deactivated_users.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/50/profiles_deactivated_users.sql b/synapse/storage/schema/delta/50/profiles_deactivated_users.sql index 6c7c8ab734..c8893ecbe8 100644 --- a/synapse/storage/schema/delta/50/profiles_deactivated_users.sql +++ b/synapse/storage/schema/delta/50/profiles_deactivated_users.sql @@ -20,4 +20,4 @@ * so we can't easily join between the two tables. Plus, the batch number * realy ought to represent data in this table that has changed. */ -ALTER TABLE profiles ADD COLUMN active BOOLEAN DEFAULT 1 NOT NULL; +ALTER TABLE profiles ADD COLUMN active SMALLINT DEFAULT 1 NOT NULL; |