Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT concat('/home/',home) as home, uid, gid, concat('*:storage=', left(quota,length(quota)-3)) as quota_rule FROM users WHERE user = 'test@houmles.org';
- +------------------------+-----+-----+-----------------+
- | home | uid | gid | quota_rule |
- +------------------------+-----+-----+-----------------+
- | /home/houmles.org/test | 800 | 100 | *:storage=52428 |
- +------------------------+-----+-----+-----------------+
- 1 row in set (0.00 sec)
- mysql> SELECT concat('/home/',home) as home, uid, gid, concat('*:storage=', round(quota_dovecot)) as quota_rule FROM users WHERE user = 'test@houmles.org';
- +------------------------+-----+-----+-----------------+
- | home | uid | gid | quota_rule |
- +------------------------+-----+-----+-----------------+
- | /home/houmles.org/test | 800 | 100 | *:storage=52428 |
- +------------------------+-----+-----+-----------------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement