Advertisement
Guest User

Untitled

a guest
May 20th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. user = mail-user
  2. password = PASSWD
  3. dbname = mail-db
  4. hosts = sql3.ne0.pl
  5.  
  6. query = SELECT `domain` FROM `mailbox` WHERE `domain` = 'ne0.pl' AND `actived` = '1' GROUP BY `domain`
  7.  
  8. -----------------------
  9. table mailbox:
  10.  
  11. CREATE TABLE IF NOT EXISTS `mailbox` (
  12. `username` varchar(255) NOT NULL,
  13. `password` varchar(255) NOT NULL,
  14. `name` varchar(255) character set utf8 NOT NULL,
  15. `maildir` varchar(255) NOT NULL,
  16. `domain` varchar(255) NOT NULL,
  17. `actived` tinyint(1) NOT NULL default '1',
  18. PRIMARY KEY (`username`),
  19. KEY `domain` (`domain`)
  20. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes';
  21.  
  22. INSERT INTO `mailbox` (`username`, `password`, `name`, `maildir`, `domain`, `actived`) VALUES
  23. ('dupa', '2qLV1Y4k7g9y6', 'dupa', '', 'ne0.pl', 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement