diff -r 9a23043b0530 -r 1f9ea5658627 pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql --- 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