Create the Exim SQL database

mysql> CREATE DATABASE exim;
mysql> GRANT ALL PRIVILEGES ON exim.* TO mail@localhost
    -> IDENTIFIED BY 'my_password' WITH GRANT OPTION;
mysql> quit

# Create the aliases table.
CREATE TABLE aliases (
  local_part varchar(64) NOT NULL default '',
  domain varchar(128) NOT NULL default 'sharewiz.net',
  recipients text,
  PRIMARY KEY  (local_part,domain)
);
 
# Populate aliases.
INSERT INTO aliases VALUES ('postmaster', 'sharewiz.net', 'admin');
INSERT INTO aliases VALUES ('mailer-daemon', 'sharewiz.net', 'postmaster');
INSERT INTO aliases VALUES ('root', 'sharewiz.net', 'postmaster');
INSERT INTO aliases VALUES ('bin', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('daemon', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('sync', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('mail', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('pop', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('uucp', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('ftp', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('nobody', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('www', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('named', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('postgres', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('mysql', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('squid', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('operator', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('abuse', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('hostmaster', 'sharewiz.net', 'root');
INSERT INTO aliases VALUES ('webmaster', 'sharewiz.net', 'root');
 
# Create the domains table.
CREATE TABLE domains (
  domain varchar(128) NOT NULL default '',
  type enum('LOCAL','RELAY','VIRTUAL') default 'LOCAL',
  PRIMARY KEY  (domain)
);
 
# Populate the domains table
INSERT INTO domains VALUES ('sharewiz.net', 'LOCAL');
 
# Create the userforward table.
CREATE TABLE userforward (
  local_part varchar(64) NOT NULL default '',
  domain varchar(128) NOT NULL default '',
  recipients text,
  PRIMARY KEY  (local_part,domain)
);
 
# Create the users table.
CREATE TABLE users (
  login varchar(64) NOT NULL default '',
  name varchar(128) NOT NULL default '',
  password varchar(64) NOT NULL default '',
  decrypt varchar(64) NOT NULL default '',
  uid int(10) unsigned default '1003',
  gid int(10) unsigned default '6',
  domain varchar(128) NOT NULL default 'sharewiz.net',
  quota tinyint(4) default '0',
  status enum('0','1') default '1',
  PRIMARY KEY  (login,domain)
);

mysql -u mail -p exim
mysql> \. exim.sql
mysql> INSERT INTO users (login,name,password,decrypt) 
    -> VALUES ('admin','John',encrypt('my_password'),'my_password');
mysql> quit