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