pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql
branchv0.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