This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
exchange:reporting:database_definition [2010/03/06 04:16] ben |
exchange:reporting:database_definition [2010/12/06 09:23] (current) ben |
||
---|---|---|---|
Line 37: | Line 37: | ||
19 rows in set (0.01 sec) | 19 rows in set (0.01 sec) | ||
</code> | </code> | ||
- | |||
==== Setup ==== | ==== Setup ==== | ||
Database and Table creation statements: | Database and Table creation statements: | ||
<code> | <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> | </code> | ||
Line 57: | Line 61: | ||
<code> | <code> | ||
GRANT FILE ON *.* TO 'ben'@'localhost' IDENTIFIED BY '-------' WITH GRANT OPTION; | GRANT FILE ON *.* TO 'ben'@'localhost' IDENTIFIED BY '-------' WITH GRANT OPTION; | ||
+ | GRANT FILE ON *.* TO cu_exchange@'localhost'; | ||
</code> | </code> |