This is an old revision of the document!
Database name: CU_Exchange
Tables: exchange_info
Table description:
mysql> describe exchange_info; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | name | varchar(120) | YES | UNI | NULL | | | enabled | binary(1) | YES | | NULL | | | bes | binary(1) | YES | | NULL | | | goodlink | binary(1) | YES | | NULL | | | size | varchar(16) | YES | | NULL | | | uni | varchar(8) | YES | | NULL | | | alpha_id | varchar(120) | YES | | NULL | | | ou | varchar(180) | YES | | NULL | | | server | varchar(20) | YES | | NULL | | | mdb | varchar(120) | YES | | NULL | | | legacyExchangeDN | varchar(120) | YES | | NULL | | +------------------+--------------+------+-----+---------+-------+ 11 rows in set (0.04 sec)
Database and Table creation statements:
drop table exchange_info; create table exchange_info (cname VARCHAR(120), dname VARCHAR(256), enabled BINARY, bes BINARY, goodlink BINARY, size VARCHAR(16), uni VARCHAR(8), alpha_id VARCHAR(120), ou VARCHAR(180), server VARCHAR(20), mdb VARCHAR(120), legacyExchangeDN VARCHAR(120)); alter table exchange_info ADD UNIQUE (dname);