Hi,
I'm trying to setup quota with the following layout
CREATE TABLE "domain" (
"id" INTEGER,
"name" TEXT,
"active" INTEGER DEFAULT 0,
PRIMARY KEY("id"),
UNIQUE("name")
)
CREATE TABLE "address" (
"id" INTEGER,
"localpart" TEXT NOT NULL,
"domain_id" INTEGER NOT NULL,
PRIMARY KEY("id"),
UNIQUE("localpart","domain_id")
)
CREATE TABLE "mailbox" (
"id" INTEGER,
"address_id" INTEGER,
"active" INTEGER DEFAULT 0,
"password" TEXT,
"quota_bytes" INTEGER DEFAULT 0,
PRIMARY KEY("id")
)
As I like to update the quota and I like to use a dict/map I'm not sure if I
can update this following:
map {
pattern = priv/quota/storage
table = maibox
value_field = dummy
fields {
value_field = quota_bytes
id = mailbox_id
}
mailbox_id will be queried using password_query using: "mailbox.id as
mailbox_id"
Using such map I hope to be able to use:
SELECT quota_bytes FROM mailbox WHERE id = '$mailbox_id'
INSERT INTO mailbox (quota_bytes) VALUES ('$value') ON DUPLICATE KEY UPDATE
quota_bytes='$value'
Can someone help me with this ?
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
