diff options
| author | Neil Alexander <neilalexander@users.noreply.github.com> | 2022-11-01 16:08:13 +0000 |
|---|---|---|
| committer | Neil Alexander <neilalexander@users.noreply.github.com> | 2022-11-01 16:08:13 +0000 |
| commit | 6663728eb10a2d4e0975a5a970c87cb845562409 (patch) | |
| tree | 0ad51c7a77bb5198a46d59d1f35acca1891cbcff | |
| parent | 2acc1d65fb360f8a68cdc2e0e154365f2e7353d3 (diff) | |
Fix SQLite `roomserver_published` migration
| -rw-r--r-- | roomserver/storage/sqlite3/deltas/20221027084407_published_appservice.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/roomserver/storage/sqlite3/deltas/20221027084407_published_appservice.go b/roomserver/storage/sqlite3/deltas/20221027084407_published_appservice.go index cd923b1c..410fb7cf 100644 --- a/roomserver/storage/sqlite3/deltas/20221027084407_published_appservice.go +++ b/roomserver/storage/sqlite3/deltas/20221027084407_published_appservice.go @@ -24,8 +24,8 @@ func UpPulishedAppservice(ctx context.Context, tx *sql.Tx) error { _, err := tx.ExecContext(ctx, ` ALTER TABLE roomserver_published RENAME TO roomserver_published_tmp; CREATE TABLE IF NOT EXISTS roomserver_published ( room_id TEXT NOT NULL, - appservice_id TEXT NOT NULL, - network_id TEXT NOT NULL, + appservice_id TEXT NOT NULL DEFAULT '', + network_id TEXT NOT NULL DEFAULT '', published BOOLEAN NOT NULL DEFAULT false, CONSTRAINT unique_published_idx PRIMARY KEY (room_id, appservice_id, network_id) ); |