Advertisement
Guest User

Untitled

a guest
Sep 13th, 2017
397
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. 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';
  2. +------------------------+-----+-----+-----------------+
  3. | home | uid | gid | quota_rule |
  4. +------------------------+-----+-----+-----------------+
  5. | /home/houmles.org/test | 800 | 100 | *:storage=52428 |
  6. +------------------------+-----+-----+-----------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> SELECT concat('/home/',home) as home, uid, gid, concat('*:storage=', round(quota_dovecot)) as quota_rule FROM users WHERE user = 'test@houmles.org';
  10. +------------------------+-----+-----+-----------------+
  11. | home | uid | gid | quota_rule |
  12. +------------------------+-----+-----+-----------------+
  13. | /home/houmles.org/test | 800 | 100 | *:storage=52428 |
  14. +------------------------+-----+-----+-----------------+
  15. 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement