diff --git a/bitbucket-pipelines.yml b/bitbucket-pipelines.yml new file mode 100644 index 0000000..dcda4e7 --- /dev/null +++ b/bitbucket-pipelines.yml @@ -0,0 +1,12 @@ +# This is a sample build configuration for all languages. +# Check our guides at https://confluence.atlassian.com/x/VYk8Lw for more examples. +# Only use spaces to indent your .yml configuration. +# ----- +# You can specify a custom docker image from Docker Hub as your build environment. +# image: docker-image:tag + +pipelines: + default: + - step: + script: + - echo "Everything is awesome!" \ No newline at end of file diff --git a/util/db-mysql.sql b/util/db-mysql.sql index 26c9d30..f853ab9 100644 --- a/util/db-mysql.sql +++ b/util/db-mysql.sql @@ -91,6 +91,7 @@ create index `attachment_idx` on `attachment`(`piler_id`); create index `attachment_idx2` on `attachment`(`sig`, `size`, `ptr`); +create index `attachment_idx3` on `attachment`(`ptr`); drop view if exists `v_attachment`; create view `v_attachment` AS select `id` as `i`, `piler_id`, `attachment_id`, `ptr`, (select count(*) from `attachment` where `ptr`=`i`) as `refcount` from `attachment`;