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/09 11:21] ben |
exchange:reporting:database_definition [2010/01/28 11:14] ben |
||
---|---|---|---|
Line 23: | Line 23: | ||
| size | bigint(20) | YES | | NULL | | | | size | bigint(20) | YES | | NULL | | | ||
| uni | varchar(8) | YES | | NULL | | | | uni | varchar(8) | YES | | NULL | | | ||
- | | alpha_id | varchar(120) | YES | | NULL | | | + | | alpha_id | varchar(32) | YES | | NULL | | |
+ | | alphasam_id | varchar(32) | YES | | NULL | | | ||
| ou | varchar(180) | YES | | NULL | | | | ou | varchar(180) | YES | | NULL | | | ||
| server | varchar(20) | YES | | NULL | | | | server | varchar(20) | YES | | NULL | | | ||
Line 29: | Line 30: | ||
| mdb | varchar(120) | YES | | NULL | | | | mdb | varchar(120) | YES | | NULL | | | ||
| legacyExchangeDN | varchar(120) | YES | | NULL | | | | legacyExchangeDN | varchar(120) | YES | | NULL | | | ||
+ | | lastLogon | date | YES | | NULL | | | ||
+------------------+--------------+------+-----+---------+-------+ | +------------------+--------------+------+-----+---------+-------+ | ||
- | 14 rows in set (0.08 sec) | + | 15 rows in set (0.01 sec) |
</code> | </code> | ||
- | |||
==== Setup ==== | ==== Setup ==== | ||
Line 38: | 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, 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)); | + | 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(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> | ||
+ | |||
+ | 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. |