🚀 go-pugleaf

> 
> wiesz co? zrób dumpa bazy (tabele postfixa) i pokaż samą strukturę
> 

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `postfix` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `postfix`;

--
-- Table structure for table `alias`
--

DROP TABLE IF EXISTS `alias`;
CREATE TABLE `alias` (
   `address` varchar(255) NOT NULL default '',
   `goto` text NOT NULL,
   PRIMARY KEY  (`address`),
   KEY `akias_srch` (`address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Virtual Aliases - mysql_virtual_alias_maps';

--
-- Table structure for table `domain`
--

DROP TABLE IF EXISTS `domain`;
CREATE TABLE `domain` (
   `id` int(6) NOT NULL auto_increment,
   `domain` varchar(255) NOT NULL default '',
   `description` varchar(255) NOT NULL default '',
   `helo_checks` varchar(128) NOT NULL default 'REJECT You are not me',
   PRIMARY KEY  (`id`),
   UNIQUE KEY `Nowy Index` (`domain`),
   KEY `domain-srch` (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Virtual Domains - mysql_virtual_domains_maps';

--
-- Table structure for table `mailbox`
--

DROP TABLE IF EXISTS `mailbox`;
CREATE TABLE `mailbox` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `domain_id` int(6) NOT NULL default '1',
   `username` varchar(255) NOT NULL default '',
   `password` varchar(255) NOT NULL default '',
   `password_plain` varchar(64) default NULL,
   `showpassword` enum('Y','N') NOT NULL default 'Y',
   `name` varchar(255) NOT NULL default '',
   `maildir` varchar(64) default NULL,
   `transport` varchar(9) NOT NULL default 'virtual',
   `quota` int(8) NOT NULL default '10484760',
   `priority` int(4) NOT NULL default '7',
   `policy_id` tinyint(4) NOT NULL default '1',
   `local` enum('Y','N') NOT NULL default 'Y',
   `quota_used` int(8) unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`),
   UNIQUE KEY `email_unique` (`username`),
   KEY `email_srch` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Virtual Mailboxes - 
mysql_virtual_mailbox_maps';

--
-- Table structure for table `policy`
--

DROP TABLE IF EXISTS `policy`;
CREATE TABLE `policy` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `policy_name` varchar(32) default NULL,
   `virus_lover` enum('Y','N') NOT NULL default 'N',
   `spam_lover` enum('Y','N') NOT NULL default 'N',
   `banned_files_lover` enum('Y','N') NOT NULL default 'N',
   `bad_header_lover` enum('Y','N') NOT NULL default 'N',
   `bypass_virus_checks` enum('Y','N') NOT NULL default 'N',
   `bypass_spam_checks` enum('Y','N') NOT NULL default 'N',
   `bypass_banned_checks` enum('Y','N') NOT NULL default 'N',
   `bypass_header_checks` enum('Y','N') NOT NULL default 'N',
   `spam_modifies_subj` enum('Y','N') NOT NULL default 'Y',
   `spam_quarantine_to` varchar(64) default NULL,
   `spam_tag_level` float NOT NULL default '-50',
   `spam_tag2_level` float NOT NULL default '5',
   `spam_kill_level` float NOT NULL default '8',
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
perqsista