Use of MySQL for lookups

3 msg	Re: Virtual domain aliases
4 msg	address verify vs. virtual_alias_maps
20 msg	Postfix/ClamAV Config Error
4 msg	smtp /dev/poll problem
6 msg	Addresses filtering for only one supported domain
14 msg	Greylist question
1 msg	One transport with AUTH and other transport wit...
7 msg	Is this expected reject behavior for foreign IP...
3 msg	relay_domains and virtual_mailbox_domains not w...
2 msg	Need help debugging a possible content filter p...
11 msg	spam emails with \| in front of the email addresses
9 msg	unexpected domain rewrite (by postfix?)
5 msg	Error receiving email
20 msg	Postfix 2.5-20071111, smtp.gmail.com, bouncing ...
1 msg	Bounce notification configure
45 msg	Re: Recipient validation

Use of MySQL for lookups
\ jekillen (27 Nov 2007)
. \ Steve (27 Nov 2007)

8 msg	proposal: change behavior with respect to recip...
11 msg	OT: Any bad DKIM experiences?
8 msg	hashed spool directories

Subject:	Use of MySQL for lookups
Group:	Postfix-users
From:	jekillen
Date:	27 Nov 2007

Hello;
I am reading Postfix-Cyrus-Web-cyradm-HOWTO and
am reading the section on configuring MySQL.

With respect to the following configuration example:

# mysql config file for canonical lookups on postfix
# comments are ok.
#

# the user name and password to log into the mysql server
hosts = localhost
user = mail
password = secret

# the database name on the servers
dbname = mail

# the table name
table = virtual
#
select_field = alias
where_field = username
# Return the first match only
additional_conditions = and status = '1' limit 1

How does this table get created? Is that something
that Postfix does if it does not exist? Other wise
I would need a table description to manually create it
as well as other MySQL lookup tables.
The same is true for PAM_MySQL.

I have experience using MySQL with php in web
context, and have it installed and running on
machines to be use as mail servers.

Perhaps there is specific documentation references?
Thanks in advance;
Jeff K