about summary refs log tree commit diff
path: root/db
diff options
context:
space:
mode:
authorHolly 'Frinkel' Lotor <admin@frinkel.tech>2020-01-20 11:54:21 -0500
committerHolly 'Frinkel' Lotor <admin@frinkel.tech>2020-01-20 16:56:53 -0500
commit259f0b15fc10470c00c57d88aec07617b5ee6ece (patch)
tree4a7bc0176181b760cab594a65c388713632cb95d /db
parentb0630ddc8261250c5edbf2907648695041649e98 (diff)
Merge first smoke test
Diffstat (limited to 'db')
-rw-r--r--db/structure.sql76
1 files changed, 5 insertions, 71 deletions
diff --git a/db/structure.sql b/db/structure.sql
index e3ba0572e..494690003 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -551,6 +551,8 @@ CREATE TABLE public.accounts (
     force_private boolean DEFAULT false NOT NULL,
     unboostable boolean DEFAULT false NOT NULL,
     block_anon boolean DEFAULT false NOT NULL
+    block_anon boolean DEFAULT false NOT NULL,
+    trust_level integer
 );
 
 
@@ -2249,40 +2251,6 @@ CREATE TABLE public.statuses_tags (
 
 
 --
--- Name: stream_entries; Type: TABLE; Schema: public; Owner: -
---
-
-CREATE TABLE public.stream_entries (
-    id bigint NOT NULL,
-    activity_id bigint,
-    activity_type character varying,
-    created_at timestamp without time zone NOT NULL,
-    updated_at timestamp without time zone NOT NULL,
-    hidden boolean DEFAULT false NOT NULL,
-    account_id bigint
-);
-
-
---
--- Name: stream_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
---
-
-CREATE SEQUENCE public.stream_entries_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MINVALUE
-    NO MAXVALUE
-    CACHE 1;
-
-
---
--- Name: stream_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
---
-
-ALTER SEQUENCE public.stream_entries_id_seq OWNED BY public.stream_entries.id;
-
-
---
 -- Name: tags; Type: TABLE; Schema: public; Owner: -
 --
 
@@ -2914,13 +2882,6 @@ ALTER TABLE ONLY public.status_stats ALTER COLUMN id SET DEFAULT nextval('public
 
 
 --
--- Name: stream_entries id; Type: DEFAULT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.stream_entries ALTER COLUMN id SET DEFAULT nextval('public.stream_entries_id_seq'::regclass);
-
-
---
 -- Name: tags id; Type: DEFAULT; Schema: public; Owner: -
 --
 
@@ -3435,14 +3396,6 @@ ALTER TABLE ONLY public.statuses
 
 
 --
--- Name: stream_entries stream_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.stream_entries
-    ADD CONSTRAINT stream_entries_pkey PRIMARY KEY (id);
-
-
---
 -- Name: tags tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
@@ -4282,20 +4235,6 @@ CREATE UNIQUE INDEX index_statuses_tags_on_tag_id_and_status_id ON public.status
 
 
 --
--- Name: index_stream_entries_on_account_id_and_activity_type_and_id; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE INDEX index_stream_entries_on_account_id_and_activity_type_and_id ON public.stream_entries USING btree (account_id, activity_type, id);
-
-
---
--- Name: index_stream_entries_on_activity_id_and_activity_type; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE INDEX index_stream_entries_on_activity_id_and_activity_type ON public.stream_entries USING btree (activity_id, activity_type);
-
-
---
 -- Name: index_tags_on_name; Type: INDEX; Schema: public; Owner: -
 --
 
@@ -4480,14 +4419,6 @@ ALTER TABLE ONLY public.users
 
 
 --
--- Name: stream_entries fk_5659b17554; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.stream_entries
-    ADD CONSTRAINT fk_5659b17554 FOREIGN KEY (account_id) REFERENCES public.accounts(id) ON DELETE CASCADE;
-
-
---
 -- Name: favourites fk_5eb6c2b873; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
@@ -5413,8 +5344,11 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20190531082330'),
 ('20190531082452'),
 ('20190531084425'),
+('20190701022101'),
+('20190706233204'),
 ('20190714172440'),
 ('20190714172721'),
+('20190715164535'),
 ('20190719121326'),
 ('20190719212820'),
 ('20190722014444'),