This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
exchange:reporting:database_definition [2010/02/02 05:11] ben |
exchange:reporting:database_definition [2010/02/06 11:00] ben |
||
---|---|---|---|
Line 39: | Line 39: | ||
<code> | <code> | ||
drop table exchange_info; | drop table exchange_info; | ||
- | create table exchange_info (cname VARCHAR(120), dname VARCHAR(256), displayName VARCHAR(120), disabled BINARY DEFAULT 0, bes BINARY DEFAULT 0, goodlink BINARY DEFAULT 0, size BIGINT, uni VARCHAR(8), alpha_id VARCHAR(32), alpha_samid VARCHAR(32), ou VARCHAR(180), server VARCHAR(20), sg VARCHAR(80), mdb VARCHAR(120), legacyExchangeDN VARCHAR(120), lastLogon DATE, lastExchangeLogon DATE); | + | create table exchange_info (cname VARCHAR(120), dname VARCHAR(256), displayName VARCHAR(120), disabled BINARY DEFAULT 0, bes BINARY DEFAULT 0, goodlink BINARY DEFAULT 0, size BIGINT, mDBStorageQuota BIGINT,mDBOverQuotaLimit BIGINT, uni VARCHAR(8), alpha_id VARCHAR(32), alpha_samid VARCHAR(32), ou VARCHAR(180), server VARCHAR(20), sg VARCHAR(80), mdb VARCHAR(120), legacyExchangeDN VARCHAR(120), lastLogon DATE, lastExchangeLogon DATE); |
alter table exchange_info ADD UNIQUE (dname); | alter table exchange_info ADD UNIQUE (dname); | ||
</code> | </code> | ||
Line 49: | Line 49: | ||
</code> | </code> | ||
Yes, the password is there for all to see, this is a totally useless account/password combination. | Yes, the password is there for all to see, this is a totally useless account/password combination. | ||
+ | |||
+ | If file output is necessary, the FILE privilege must be granted: | ||
+ | <code> | ||
+ | GRANT FILE ON *.* TO 'ben'@'localhost' IDENTIFIED BY '-------' WITH GRANT OPTION; | ||
+ | </code> | ||
+ |