branch | v0.6.x |
changeset 538 | 1f9ea5658627 |
parent 530 | 95dd123b552e |
child 548 | 92ef34f07da3 |
--- a/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql Sat Apr 14 16:02:46 2012 +0000 +++ b/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql Sat Apr 14 12:58:20 2012 +0200 @@ -195,6 +195,13 @@ WHERE domain_data.gid = users.gid); -- --- +-- Account/domain notes +-- --- + +ALTER TABLE users ADD COLUMN note text NULL DEFAULT NULL; +ALTER TABLE domain_data ADD COLUMN note text NULL DEFAULT NULL; + +-- --- -- Restore view -- --- CREATE VIEW vmm_domain_info AS