Differences

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

--- exchange:reporting:database_definition [2010/03/06 04:16]
ben
+++ exchange:reporting:database_definition [2010/03/06 04:17]
ben
@@ Line 37: / Line 37: @@
 rows in set (0.01 sec)
 </code>
 ==== Setup ====
 Database and Table creation statements:
 <code>
-drop table exchange_info;
+useDB="use cu_exchange;"
-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);
+dropTable="drop table exchange_info;"
-alter table exchange_info ADD UNIQUE (dname);
+createTable="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);"
+alterTable="alter table exchange_info ADD UNIQUE (dname);"
 </code>

..., etc.