X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;ds=sidebyside;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_140_sender_idx.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_140_sender_idx.sql;h=3aa66a1380dfce1c65f371fcdf461c4b1fc82448;hb=20f446a492d8e681156423f0dc3637db78c45bae;hp=0000000000000000000000000000000000000000;hpb=458c3278a4b9102bcc470d48816fac379492a588;p=quassel.git

diff --git a/src/core/SQL/PostgreSQL/setup_140_sender_idx.sql b/src/core/SQL/PostgreSQL/setup_140_sender_idx.sql
new file mode 100644
index 00000000..3aa66a13
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/setup_140_sender_idx.sql
@@ -0,0 +1 @@
+CREATE UNIQUE INDEX sender_sender_realname_avatarurl_uindex ON sender(sender, realname, avatarurl);