SHARE
TWEET

Untitled

a guest Sep 13th, 2017 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data
Top