# THIS FILE IS CONTROLLED BY ANSIBLE - DO NOT CHANGE IN DEPLOYMENT!


# This file is commonly accessed via dict {} section in dovecot.conf

connect = host={{ mailserver.postgresql.host }} port={{ mailserver.postgresql.port }} dbname={{ mailserver.postgresql.dbname }} user={{ mailserver.postgresql.username }} password={{ mailserver.postgresql.password }}

# CREATE TABLE quota (
#   username varchar(100) not null,
#   bytes bigint not null default 0,
#   messages integer not null default 0,
#   primary key (username)
# );

#map {
#  pattern = priv/quota/storage
#  table = quota
#  username_field = username
#  value_field = bytes
#}
#map {
#  pattern = priv/quota/messages
#  table = quota
#  username_field = username
#  value_field = messages
#}

# CREATE TABLE expires (
#   username varchar(100) not null,
#   mailbox varchar(255) not null,
#   expire_stamp integer not null,
#   primary key (username, mailbox)
# );

#map {
#  pattern = shared/expire/$user/$mailbox
#  table = expires
#  value_field = expire_stamp
#
#  fields {
#    username = $user
#    mailbox = $mailbox
#  }
#}

map {
  pattern = shared/shared-boxes/user/$to/$from
  table = shared_folders
  value_field = dummy

  fields {
    from_user = $from
    to_user = $to
  }
}

map {
  pattern = shared/shared-boxes/anyone/$from
  table = shared_folders_anyone
  value_field = dummy

  fields {
    from_user = $from
  }
}