..., etc.

===== Database Definition =====


==== Name ====

Database name: CU_Exchange
==== Tables ====

Tables: exchange_info

Table description:
<code>
mysql> describe exchange_info;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| cname            | varchar(120) | YES  |     | NULL    |       |
| dname            | varchar(256) | YES  | UNI | NULL    |       |
| displayName      | varchar(120) | YES  |     | NULL    |       |
| disabled         | binary(1)    | YES  |     | 0       |       |
| bes              | binary(1)    | YES  |     | 0       |       |
| goodlink         | binary(1)    | YES  |     | 0       |       |
| size             | bigint(20)   | YES  |     | NULL    |       |
| uni              | varchar(8)   | YES  |     | NULL    |       |
| alpha_id         | varchar(32)  | YES  |     | NULL    |       |
| alphasam_id      | varchar(32)  | YES  |     | NULL    |       |
| ou               | varchar(180) | YES  |     | NULL    |       |
| server           | varchar(20)  | YES  |     | NULL    |       |
| sg               | varchar(80)  | YES  |     | NULL    |       |
| mdb              | varchar(120) | YES  |     | NULL    |       |
| legacyExchangeDN | varchar(120) | YES  |     | NULL    |       |
| lastLogon        | date         | YES  |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+
15 rows in set (0.01 sec)
</code>
==== Setup ====

Database and Table creation statements:
<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, 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>

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>
..., etc.

User Tools

Site Tools

Page Tools
