Differences

This shows you the differences between two versions of the page.

--- exchange:reporting:database_definition [2010/02/02 05:11]
ben
+++ exchange:reporting:database_definition [2010/02/02 14:40]
ben
@@ Line 39: / Line 39: @@
 <code>
 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);
 </code>

..., etc.