commit 5d1fb7cb0ba228319426a796308565c6db78a13d from: mischa date: Mon Sep 05 21:58:35 2022 UTC correct comments commit - 7d4b5ea46b97dd021913672aada2486793a1ac2f commit + 5d1fb7cb0ba228319426a796308565c6db78a13d blob - fd9950701378ce98d0a59619f098c6e6df9b539e blob + 38e1d5f3ce94d6b7a4dc50ca9dcdc0945f77fd00 --- README.md +++ README.md @@ -15,7 +15,7 @@ Database needed to use SQL with OpenSMTPD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`username`), KEY `username` (`username`) - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='as60131 Admin - Virtual Admins' + ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='OpenSMTPD Admin - Virtual Admins' CREATE TABLE `alias` ( `address` varchar(255) NOT NULL DEFAULT '', @@ -25,7 +25,7 @@ Database needed to use SQL with OpenSMTPD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`address`), KEY `address` (`address`) - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='as60131 Admin - Virtual Aliases' + ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='OpenSMTPD Admin - Virtual Aliases' CREATE TABLE `domain` ( `domain` varchar(255) NOT NULL DEFAULT '', @@ -36,14 +36,14 @@ Database needed to use SQL with OpenSMTPD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`domain`), KEY `domain` (`domain`) - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='as60131 Admin - Virtual Domains' + ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='OpenSMTPD Admin - Virtual Domains' CREATE TABLE `domain_admins` ( `username` varchar(255) NOT NULL DEFAULT '', `domain` varchar(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', KEY `username` (`username`) - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='as60131 Admin - Domain Admins' + ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='OpenSMTPD Admin - Domain Admins' CREATE TABLE `log` ( `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', @@ -52,7 +52,7 @@ Database needed to use SQL with OpenSMTPD `action` varchar(255) NOT NULL DEFAULT '', `data` varchar(255) NOT NULL DEFAULT '', KEY `timestamp` (`timestamp`) - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='as60131 Admin - Log' + ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='OpenSMTPD Admin - Log' CREATE TABLE `mailbox` ( `username` varchar(255) NOT NULL DEFAULT '', @@ -64,7 +64,7 @@ Database needed to use SQL with OpenSMTPD `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`username`), KEY `username` (`username`) - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='as60131 Admin - Virtual Mailboxes' + ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='OpenSMTPD Admin - Virtual Mailboxes' CREATE TABLE `vacation` ( `email` varchar(255) NOT NULL DEFAULT '', @@ -75,7 +75,7 @@ Database needed to use SQL with OpenSMTPD `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`email`), KEY `email` (`email`) - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='as60131 Admin - Virtual Vacation' + ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='OpenSMTPD Admin - Virtual Vacation' Config for OpenSMTPTD, MySQL/MariaDB example: