---
--- Database: `vexim`
---
CREATE DATABASE IF NOT EXISTS `vexim`;

---
--- Table: `domains`
---
DROP TABLE IF EXISTS `vexim`.`domains`;
CREATE TABLE IF NOT EXISTS `vexim`.`domains`
(
    domain_id      mediumint(8)  unsigned  NOT NULL  auto_increment,
	domain           varchar(64)             NOT NULL  default '',
	maildir          varchar(128)            NOT NULL  default '',
	uid              smallint(5)   unsigned  NOT NULL  default '99',
	gid              smallint(5)   unsigned  NOT NULL  default '99',
	max_accounts     int(10)       unsigned  NOT NULL  default '0', 
	quotas           int(10)       unsigned  NOT NULL  default '0',
	type             varchar(5)                        default NULL,
	avscan           bool                    NOT NULL  default '0',
	blocklists       bool                    NOT NULL  default '0',
	complexpass      bool                    NOT NULL  default '0',
	enabled          bool                    NOT NULL  default '1',
	mailinglists     bool                    NOT NULL  default '0',
	maxmsgsize       mediumint(8)  unsigned  NOT NULL  default '0',
	pipe             bool                    NOT NULL  default '0',
	spamassassin     bool                    NOT NULL  default '0',
	sa_tag           smallint(5)   unsigned  NOT NULL  default '0',
	sa_refuse        smallint(5)   unsigned  NOT NULL  default '0',
	PRIMARY KEY (domain_id),
	UNIQUE KEY domain (domain),
	KEY domain_id (domain_id),
	KEY domains (domain)
);

.....