X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/d1d4f8192da5a266cddb17bb8970b2b04387888c..faf4c5aa7a3c75b89d32b7d2205d004f9aa99cb7:/db/structure.sql?ds=sidebyside

diff --git a/db/structure.sql b/db/structure.sql
index efabdbee6..e73925d32 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -1989,6 +1989,20 @@ CREATE INDEX index_issue_comments_on_issue_id ON issue_comments USING btree (iss
 CREATE INDEX index_issue_comments_on_user_id ON issue_comments USING btree (user_id);
 
 
+--
+-- Name: index_issues_on_reportable_id_and_reportable_type; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE INDEX index_issues_on_reportable_id_and_reportable_type ON issues USING btree (reportable_id, reportable_type);
+
+
+--
+-- Name: index_issues_on_reported_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE INDEX index_issues_on_reported_user_id ON issues USING btree (reported_user_id);
+
+
 --
 -- Name: index_note_comments_on_body; Type: INDEX; Schema: public; Owner: -
 --
@@ -2136,20 +2150,6 @@ CREATE INDEX relations_changeset_id_idx ON relations USING btree (changeset_id);
 CREATE INDEX relations_timestamp_idx ON relations USING btree ("timestamp");
 
 
---
--- Name: reportable_object_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
---
-
-CREATE INDEX reportable_object_idx ON issues USING btree (reportable_id, reportable_type);
-
-
---
--- Name: reported_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
---
-
-CREATE INDEX reported_user_id_idx ON issues USING btree (reported_user_id);
-
-
 --
 -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -
 --
