Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- user = mail-user
- password = PASSWD
- dbname = mail-db
- hosts = sql3.ne0.pl
- query = SELECT `domain` FROM `mailbox` WHERE `domain` = 'ne0.pl' AND `actived` = '1' GROUP BY `domain`
- -----------------------
- table mailbox:
- CREATE TABLE IF NOT EXISTS `mailbox` (
- `username` varchar(255) NOT NULL,
- `password` varchar(255) NOT NULL,
- `name` varchar(255) character set utf8 NOT NULL,
- `maildir` varchar(255) NOT NULL,
- `domain` varchar(255) NOT NULL,
- `actived` tinyint(1) NOT NULL default '1',
- PRIMARY KEY (`username`),
- KEY `domain` (`domain`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes';
- INSERT INTO `mailbox` (`username`, `password`, `name`, `maildir`, `domain`, `actived`) VALUES
- ('dupa', '2qLV1Y4k7g9y6', 'dupa', '', 'ne0.pl', 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement