Mohsen Pahlevanzadeh skrev den 2013-06-22 01:25:
How can i combine together?
i created username like this:
# sql dump
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `username` (
`concat(userid,"@",domain)` varchar(257)
);
CREATE TABLE IF NOT EXISTS `users` (
`userid` varchar(128) NOT NULL,
`domain` varchar(128) NOT NULL,
`password` varchar(64) NOT NULL,
`home` varchar(255) NOT NULL,
`uid` int(11) NOT NULL,
`gid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `users` (`userid`, `domain`, `password`, `home`, `uid`,
`gid`) VALUES
('me', 'example.org', 'password', 'homedir', 1000, 1000);
DROP TABLE IF EXISTS `username`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY
DEFINER VIEW `username` AS select
concat(`users`.`userid`,'@',`users`.`domain`) AS
`concat(userid,"@",domain)` from `users`;
now username contains same info that postfixadmin creates :)
--
senders that put my email into body content will deliver it to my own
trashcan, so if you like to get reply, dont do it
