1#
2# Sample MySQL or MariaDB configuration file
3#
4
5# MySQL or MariaDB example schema
6#
7#CREATE TABLE domains (
8#  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
9#  domain VARCHAR(255) NOT NULL DEFAULT ''
10#);
11#CREATE TABLE virtuals (
12#    id INTEGER AUTO_INCREMENT PRIMARY KEY,
13#    email VARCHAR(255) NOT NULL DEFAULT '',
14#    destination VARCHAR(255) NOT NULL DEFAULT ''
15#);
16#CREATE TABLE credentials (
17#    id INTEGER AUTO_INCREMENT PRIMARY KEY,
18#    email VARCHAR(255) NOT NULL DEFAULT '',
19#    password VARCHAR(255) NOT NULL DEFAULT ''
20#);
21
22# Database definition
23#
24host            localhost
25username        username
26password        password
27database        databasename
28
29# Alias lookup query
30#
31# rows   >= 0
32# fields == 1 (email VARCHAR)
33#
34query_alias		SELECT destination FROM virtuals WHERE email=?
35
36# Domain lookup query
37#
38# rows   == 1
39# fields == 1 (domain VARCHAR)
40#
41query_domain		SELECT domain FROM domains WHERE domain=?;
42
43# Credentials lookup query
44#
45# rows   == 1
46# fields == 2 (email VARCHAR, password VARCHAR)
47#
48query_credentials	SELECT email, password FROM credentials WHERE email=?;
49