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