X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=sql%2FPostgreSQL%2Fupgrade%2F5-6%2F001-auto.sql;fp=sql%2FPostgreSQL%2Fupgrade%2F5-6%2F001-auto.sql;h=0e6fe494433be6ce7966d45d8aef799c0f8a6857;hb=53c435119200ab9b1c2538a96b8374c51a078855;hp=0000000000000000000000000000000000000000;hpb=0e8f07fda6e40b5967d9c6b28b3200db22766343;p=debbugs.git

diff --git a/sql/PostgreSQL/upgrade/5-6/001-auto.sql b/sql/PostgreSQL/upgrade/5-6/001-auto.sql
new file mode 100644
index 0000000..0e6fe49
--- /dev/null
+++ b/sql/PostgreSQL/upgrade/5-6/001-auto.sql
@@ -0,0 +1,51 @@
+-- Convert schema 'sql/_source/deploy/5/001-auto.yml' to 'sql/_source/deploy/6/001-auto.yml':;
+
+;
+BEGIN;
+
+;
+CREATE INDEX bin_ver_ver_id_idx on bin_ver (ver);
+
+;
+CREATE INDEX bin_ver_src_ver_id_arch_idx on bin_ver (src_ver, arch);
+
+;
+CREATE INDEX bug_idxforwarded on bug (forwarded);
+
+;
+CREATE INDEX bug_idxlast_modified on bug (last_modified);
+
+;
+CREATE INDEX bug_idxcreation on bug (creation);
+
+;
+CREATE INDEX bug_idxlog_modified on bug (log_modified);
+
+;
+CREATE INDEX bug_message_idx_bug_message_number on bug_message (bug, message_number);
+
+;
+CREATE INDEX bug_ver_src_pkg_id_src_ver_id_idx on bug_ver (src_pkg, src_ver);
+
+;
+CREATE INDEX correspondent_full_name_idx_full_name on correspondent_full_name (full_name);
+
+;
+CREATE INDEX correspondent_full_name_idx_last_seen on correspondent_full_name (last_seen);
+
+;
+CREATE INDEX message_msgid_idx on message (msgid);
+
+;
+CREATE INDEX message_subject_idx on message (subject);
+
+;
+CREATE INDEX severity_ordering_idx on severity (ordering);
+
+;
+CREATE INDEX src_pkg_pkg on src_pkg (pkg);
+
+;
+
+COMMIT;
+