diff options
| author | David Robertson <davidr@element.io> | 2022-09-26 18:28:32 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-09-26 18:28:32 +0100 |
| commit | 0a38c7ec6d46b6e51bfa53ff44e51637d3c63f5c (patch) | |
| tree | 3509b9f8af1050186338a6f06f15e76f87562f89 /synapse/storage/schema/common | |
| parent | typing: check origin server of typing event against room's servers (#13830) (diff) | |
| download | synapse-0a38c7ec6d46b6e51bfa53ff44e51637d3c63f5c.tar.xz | |
Snapshot schema 72 (#13873)
Including another batch of fixes to the schema dump script
Diffstat (limited to 'synapse/storage/schema/common')
| -rw-r--r-- | synapse/storage/schema/common/full_schemas/72/full.sql.postgres | 8 | ||||
| -rw-r--r-- | synapse/storage/schema/common/full_schemas/72/full.sql.sqlite | 6 |
2 files changed, 14 insertions, 0 deletions
diff --git a/synapse/storage/schema/common/full_schemas/72/full.sql.postgres b/synapse/storage/schema/common/full_schemas/72/full.sql.postgres new file mode 100644 index 0000000000..f0e546f052 --- /dev/null +++ b/synapse/storage/schema/common/full_schemas/72/full.sql.postgres @@ -0,0 +1,8 @@ +CREATE TABLE background_updates ( + update_name text NOT NULL, + progress_json text NOT NULL, + depends_on text, + ordering integer DEFAULT 0 NOT NULL +); +ALTER TABLE ONLY background_updates + ADD CONSTRAINT background_updates_uniqueness UNIQUE (update_name); diff --git a/synapse/storage/schema/common/full_schemas/72/full.sql.sqlite b/synapse/storage/schema/common/full_schemas/72/full.sql.sqlite new file mode 100644 index 0000000000..d5a2c04aa9 --- /dev/null +++ b/synapse/storage/schema/common/full_schemas/72/full.sql.sqlite @@ -0,0 +1,6 @@ +CREATE TABLE background_updates ( + update_name text NOT NULL, + progress_json text NOT NULL, + depends_on text, ordering INT NOT NULL DEFAULT 0, + CONSTRAINT background_updates_uniqueness UNIQUE (update_name) +); |