 --
 
 CREATE TABLE IF NOT EXISTS `xpa_alias` (
+  `alias_id` int(11) NOT NULL auto_increment,
   `address` varchar(255) NOT NULL default '',
   `goto` text NOT NULL,
-  `domain` varchar(255) NOT NULL default '',
+  `domain_id` int(11) NOT NULL,
   `created` datetime NOT NULL default '0000-00-00 00:00:00',
   `modified` datetime NOT NULL default '0000-00-00 00:00:00',
   `active` tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (`address`),
-  KEY `address` (`address`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Aliases';
+  PRIMARY KEY  (`alias_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Aliases' AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 

--
-- Table structure for table `xpa_admin`
--

--

CREATE TABLE IF NOT EXISTS `xpa_mailbox` (
  `mailbox_id` int(11) NOT NULL auto_increment,
  `email_address` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `maildir` varchar(255) NOT NULL default '',
  `quota` int(10) NOT NULL default '0',
  `domain_id` int(11) NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`mailbox_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

