1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
INSERT INTO `mail_sys`.`domains`
(`id` ,`name`)
VALUES
('1', 'example.com'),
('2', 'hostname.example.com'),
('3', 'hostname'),
('4', 'localhost.example.com');
INSERT INTO `mail_sys`.`users`
(`id`, `domain_id`, `password` , `email`)
VALUES
('1', '1', ENCRYPT('PASSWORD', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))), 'user@example.com');
INSERT INTO `mail_sys`.`aliases`
(`id`, `domain_id`, `source`, `destination`)
VALUES
('1', '1', 'user@example.com', 'user@example.com');
|