diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-25 19:42:39 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-25 19:42:39 -0700 |
| commit | f3523b1d900e19911bf0041ac1c75877b0bfc943 (patch) | |
| tree | 4286885906e7758c4cf6625a369d17b96c4d8e62 /rust/migrations | |
| parent | f653c4070a076306825501ddbc27c0634d0e1438 (diff) | |
| download | fatcat-f3523b1d900e19911bf0041ac1c75877b0bfc943.tar.gz fatcat-f3523b1d900e19911bf0041ac1c75877b0bfc943.zip | |
return all edits for an editgroup GET
Diffstat (limited to 'rust/migrations')
| -rw-r--r-- | rust/migrations/2018-05-12-001226_init/up.sql | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql index 1fbd7c09..1f366f90 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -54,11 +54,11 @@ CREATE TABLE creator_ident ( CREATE TABLE creator_edit ( id BIGSERIAL PRIMARY KEY, - extra_json JSON, + editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL, ident_id UUID REFERENCES creator_ident(id) NOT NULL, rev_id BIGINT REFERENCES creator_rev(id), redirect_id UUID REFERENCES creator_ident(id), - editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL + extra_json JSON ); -------------------- Containers -------------------------------------------- @@ -82,11 +82,11 @@ CREATE TABLE container_ident ( CREATE TABLE container_edit ( id BIGSERIAL PRIMARY KEY, - extra_json JSON, + editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL, ident_id UUID REFERENCES container_ident(id) NOT NULL, rev_id BIGINT REFERENCES container_rev(id), redirect_id UUID REFERENCES container_ident(id), - editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL + extra_json JSON ); -------------------- Files ------------------------------------------------- @@ -108,11 +108,11 @@ CREATE TABLE file_ident ( CREATE TABLE file_edit ( id BIGSERIAL PRIMARY KEY, - extra_json JSON, + editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL, ident_id UUID REFERENCES file_ident(id) NOT NULL, rev_id BIGINT REFERENCES file_rev(id), redirect_id UUID REFERENCES file_ident(id), - editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL + extra_json JSON ); -------------------- Release ----------------------------------------------- @@ -143,11 +143,11 @@ CREATE TABLE release_ident ( CREATE TABLE release_edit ( id BIGSERIAL PRIMARY KEY, - extra_json JSON, + editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL, ident_id UUID REFERENCES release_ident(id) NOT NULL, rev_id BIGINT REFERENCES release_rev(id), redirect_id UUID REFERENCES release_ident(id), - editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL + extra_json JSON ); -------------------- Works -------------------------------------------------- @@ -169,11 +169,11 @@ CREATE TABLE work_ident ( CREATE TABLE work_edit ( id BIGSERIAL PRIMARY KEY, - extra_json JSON, + editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL, ident_id UUID REFERENCES work_ident(id) NOT NULL, rev_id BIGINT REFERENCES work_rev(id), redirect_id UUID REFERENCES work_ident(id), - editgroup_id BIGINT REFERENCES editgroup(id) NOT NULL + extra_json JSON ); |