..., 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    |       |
| mDBStorageQuota   | bigint(20)   | YES  |     | NULL    |       |
| mDBOverQuotaLimit | bigint(20)   | YES  |     | NULL    |       |
| uni               | varchar(8)   | YES  |     | NULL    |       |
| alpha_id          | varchar(32)  | YES  |     | NULL    |       |
| alpha_samid       | 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    |       |
| lastExchangeLogon | date         | YES  |     | NULL    |       |
+-------------------+--------------+------+-----+---------+-------+
19 rows in set (0.01 sec)
</code>
==== Setup ====

Database and Table creation statements:
<code>
useDB="use cu_exchange;"
dropTable="drop table exchange_info;"
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>

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
