equal
deleted
inserted
replaced
193 WHERE tid = (SELECT tid |
193 WHERE tid = (SELECT tid |
194 FROM domain_data |
194 FROM domain_data |
195 WHERE domain_data.gid = users.gid); |
195 WHERE domain_data.gid = users.gid); |
196 |
196 |
197 -- --- |
197 -- --- |
|
198 -- Account/domain notes |
|
199 -- --- |
|
200 |
|
201 ALTER TABLE users ADD COLUMN note text NULL DEFAULT NULL; |
|
202 ALTER TABLE domain_data ADD COLUMN note text NULL DEFAULT NULL; |
|
203 |
|
204 -- --- |
198 -- Restore view |
205 -- Restore view |
199 -- --- |
206 -- --- |
200 CREATE VIEW vmm_domain_info AS |
207 CREATE VIEW vmm_domain_info AS |
201 SELECT gid, count(uid) AS accounts, |
208 SELECT gid, count(uid) AS accounts, |
202 (SELECT count(DISTINCT address) |
209 (SELECT count(DISTINCT address) |