exchange:reporting:database_definition
Differences
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 [2009/12/10 07:50] ben |
exchange:reporting:database_definition [2010/03/06 04:16] ben |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| <code> | <code> | ||
| mysql> describe exchange_info; | mysql> describe exchange_info; | ||
| - | +------------------+--------------+------+-----+---------+-------+ | + | +-------------------+--------------+------+-----+---------+-------+ |
| - | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
| - | +------------------+--------------+------+-----+---------+-------+ | + | +-------------------+--------------+------+-----+---------+-------+ |
| - | | cname | varchar(120) | YES | | NULL | | | + | | cname | varchar(120) | YES | | NULL | | |
| - | | dname | varchar(256) | YES | UNI | NULL | | | + | | dname | varchar(256) | YES | UNI | NULL | | |
| - | | displayName | varchar(120) | YES | | NULL | | | + | | displayName | varchar(120) | YES | | NULL | | |
| - | | disabled | binary(1) | YES | | 0 | | | + | | disabled | binary(1) | YES | | 0 | | |
| - | | bes | binary(1) | YES | | NULL | | | + | | bes | binary(1) | YES | | 0 | | |
| - | | goodlink | binary(1) | YES | | NULL | | | + | | goodlink | binary(1) | YES | | 0 | | |
| - | | size | bigint(20) | YES | | NULL | | | + | | size | bigint(20) | YES | | NULL | | |
| - | | uni | varchar(8) | YES | | NULL | | | + | | mDBStorageQuota | bigint(20) | YES | | NULL | | |
| - | | alpha_id | varchar(120) | YES | | NULL | | | + | | mDBOverQuotaLimit | bigint(20) | YES | | NULL | | |
| - | | ou | varchar(180) | YES | | NULL | | | + | | uni | varchar(8) | YES | | NULL | | |
| - | | server | varchar(20) | YES | | NULL | | | + | | alpha_id | varchar(32) | YES | | NULL | | |
| - | | sg | varchar(80) | YES | | NULL | | | + | | alpha_samid | varchar(32) | YES | | NULL | | |
| - | | mdb | varchar(120) | YES | | NULL | | | + | | ou | varchar(180) | YES | | NULL | | |
| - | | legacyExchangeDN | varchar(120) | YES | | NULL | | | + | | server | varchar(20) | YES | | NULL | | |
| - | | lastLogon | date | YES | | NULL | | | + | | sg | varchar(80) | YES | | NULL | | |
| - | +------------------+--------------+------+-----+---------+-------+ | + | | mdb | varchar(120) | YES | | NULL | | |
| - | 15 rows in set (0.01 sec) | + | | legacyExchangeDN | varchar(120) | YES | | NULL | | |
| + | | lastLogon | date | YES | | NULL | | | ||
| + | | lastExchangeLogon | date | YES | | NULL | | | ||
| + | +-------------------+--------------+------+-----+---------+-------+ | ||
| + | 19 rows in set (0.01 sec) | ||
| </code> | </code> | ||
| Line 39: | Line 43: | ||
| <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, goodlink BINARY, size BIGINT, uni VARCHAR(8), alpha_id VARCHAR(120), ou VARCHAR(180), server VARCHAR(20), sg VARCHAR(80), mdb VARCHAR(120), legacyExchangeDN VARCHAR(120), lastLogon 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> | ||
| + | |||
| + | Additionally, the user for this db is "cu_exchange", setup by: | ||
| + | <code> | ||
| + | GRANT ALL PRIVILEGES ON cu_exchange TO 'cu_exchange'@'localhost' IDENTIFIED BY 'cu_exchange' WITH GRANT OPTION; | ||
| + | GRANT ALL PRIVILEGES ON cu_exchange.* TO 'cu_exchange'@'localhost' IDENTIFIED BY 'cu_exchange' WITH GRANT OPTION; | ||
| + | </code> | ||
| + | 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> | </code> | ||
exchange/reporting/database_definition.txt · Last modified: 2010/12/06 09:23 by ben
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
