diff options
| author | multiple creatures <dev@multiple-creature.party> | 2020-02-27 14:47:31 -0600 |
|---|---|---|
| committer | multiple creatures <dev@multiple-creature.party> | 2020-02-27 14:47:31 -0600 |
| commit | 3d0370c726f402874f01e476c6add2e5d882ac97 (patch) | |
| tree | 7b820e3aa4ef9ac734bbc4c11725c83a55e39fd7 | |
| parent | 99be0afbb14d34c35de756f1d1db0a53e59c8e95 (diff) | |
update schema file
| -rw-r--r-- | db/structure.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/db/structure.sql b/db/structure.sql index 937ad905e..5761e5e2f 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -2259,6 +2259,7 @@ CREATE TABLE public.statuses ( reject_replies boolean, tsv tsvector GENERATED ALWAYS AS (to_tsvector('public.fedi'::regconfig, public.f_strip_mentions(((spoiler_text || ' '::text) || text)))) STORED, hidden boolean, + deleted_at timestamp without time zone, CONSTRAINT statuses_hidden_null CHECK ((hidden IS NOT NULL)) ); @@ -4232,10 +4233,10 @@ CREATE UNIQUE INDEX index_status_stats_on_status_id ON public.status_stats USING -- --- Name: index_statuses_20180106; Type: INDEX; Schema: public; Owner: - +-- Name: index_statuses_20190820; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX index_statuses_20180106 ON public.statuses USING btree (account_id, id DESC, visibility, updated_at); +CREATE INDEX index_statuses_20190820 ON public.statuses USING btree (account_id, id DESC, visibility, updated_at) WHERE (deleted_at IS NULL); -- @@ -5438,6 +5439,8 @@ INSERT INTO "schema_migrations" (version) VALUES ('20190807172051'), ('20190807221924'), ('20190815232125'), +('20190819134503'), +('20190820003045'), ('20190831022432'), ('20191009231327'), ('20191010005320'), |