pgsql/update_tables_0.5.x-0.6.pgsql
branchv0.6.x
changeset 538 1f9ea5658627
parent 530 95dd123b552e
child 548 92ef34f07da3
--- a/pgsql/update_tables_0.5.x-0.6.pgsql	Sat Apr 14 16:02:46 2012 +0000
+++ b/pgsql/update_tables_0.5.x-0.6.pgsql	Sat Apr 14 12:58:20 2012 +0200
@@ -173,6 +173,13 @@
 );
 
 -- ---
+-- 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