about summary refs log tree commit diff
path: root/db
diff options
context:
space:
mode:
authormultiple creatures <dev@multiple-creature.party>2020-02-27 14:47:31 -0600
committermultiple creatures <dev@multiple-creature.party>2020-02-27 14:47:31 -0600
commit3d0370c726f402874f01e476c6add2e5d882ac97 (patch)
tree7b820e3aa4ef9ac734bbc4c11725c83a55e39fd7 /db
parent99be0afbb14d34c35de756f1d1db0a53e59c8e95 (diff)
update schema file
Diffstat (limited to 'db')
-rw-r--r--db/structure.sql7
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'),