--- a/pgsql/create_tables.pgsql Sat Apr 14 16:02:46 2012 +0000
+++ b/pgsql/create_tables.pgsql Sat Apr 14 12:58:20 2012 +0200
@@ -104,6 +104,7 @@
ssid bigint NOT NULL DEFAULT 1, -- default service_set
tid bigint NOT NULL DEFAULT 1, -- default transport
domaindir varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294
+ note varchar NULL DEFAULT NULL,
CONSTRAINT pkey_domain_data PRIMARY KEY (gid),
CONSTRAINT fkey_domain_data_qid_quotalimit FOREIGN KEY (qid)
REFERENCES quotalimit (qid),
@@ -132,6 +133,7 @@
qid bigint NULL DEFAULT NULL,
ssid bigint NULL DEFAULT NULL,
tid bigint NULL DEFAULT NULL,
+ note varchar NULL DEFAULT NULL,
CONSTRAINT pkey_users PRIMARY KEY (local_part, gid),
CONSTRAINT ukey_users_uid UNIQUE (uid),
CONSTRAINT fkey_users_gid_domain_data FOREIGN KEY (gid)