summaryrefslogtreecommitdiff
path: root/priv/repo/migrations/20180606173637_create_apid_host_extraction_index.exs
diff options
context:
space:
mode:
authorsquidboi <squidboi@waifu.club>2018-06-16 15:37:16 -0700
committersquidboi <squidboi@waifu.club>2018-06-16 15:37:16 -0700
commit2e294ee44a1baa7c0d3ac6b2905a70ed4e05cffb (patch)
tree740d660abc0ca455368144abc89c8a398e85caf0 /priv/repo/migrations/20180606173637_create_apid_host_extraction_index.exs
parent4f9ecfc77a54eef23741c89206b4cbce924f7d76 (diff)
parent1ea4a18ad859600841860cdd1a981da868aa18a0 (diff)
downloadpleroma-2e294ee44a1baa7c0d3ac6b2905a70ed4e05cffb.tar.gz
pleroma-2e294ee44a1baa7c0d3ac6b2905a70ed4e05cffb.zip
Merge branch 'develop' into feature/configurable-blocks
Diffstat (limited to 'priv/repo/migrations/20180606173637_create_apid_host_extraction_index.exs')
-rw-r--r--priv/repo/migrations/20180606173637_create_apid_host_extraction_index.exs8
1 files changed, 8 insertions, 0 deletions
diff --git a/priv/repo/migrations/20180606173637_create_apid_host_extraction_index.exs b/priv/repo/migrations/20180606173637_create_apid_host_extraction_index.exs
new file mode 100644
index 000000000..9831a1b82
--- /dev/null
+++ b/priv/repo/migrations/20180606173637_create_apid_host_extraction_index.exs
@@ -0,0 +1,8 @@
+defmodule Pleroma.Repo.Migrations.CreateApidHostExtractionIndex do
+ use Ecto.Migration
+ @disable_ddl_transaction true
+
+ def change do
+ create index(:activities, ["(split_part(actor, '/', 3))"], concurrently: true, name: :activities_hosts)
+ end
+end