mysql> show tables;
+-------------------------------+
| Tables_in_highlightstudioscom |
+-------------------------------+
| clientLink                    |
| company                       |
| illo                          |
| users                         |
+-------------------------------+
4 rows in set (0.02 sec)

mysql> describe illo;
+------------------+----------------------+------+-----+---------+----------------+
| Field            | Type                 | Null | Key | Default | Extra          |
+------------------+----------------------+------+-----+---------+----------------+
| illoID           | smallint(5) unsigned |      | PRI | NULL    | auto_increment |
| illoFullFile     | varchar(32)          |      |     |         |                |
| illoThumbFile    | varchar(32)          |      |     |         |                |
| illoPopupFile    | varchar(32)          |      |     |         |                |
| illoTitle        | varchar(32)          |      |     |         |                |
| illoLocalFile    | varchar(31)          |      |     |         |                |
| illoCategory     | varchar(6)           |      |     |         |                |
| illoHSID         | varchar(12)          |      |     |         |                |
| illoIndexedVisID | varchar(10)          |      |     |         |                |
| illoPhotoResID   | varchar(10)          |      |     |         |                |
| illoPixelsW      | smallint(5) unsigned |      |     | 0       |                |
| illoPixelsH      | smallint(5) unsigned |      |     | 0       |                |
| illoDesc         | text                 |      |     |         |                |
| illoKeywords     | text                 |      | MUL |         |                |
| illoIsPortfolio  | tinyint(3) unsigned  |      |     | 0       |                |
| illoAwards       | varchar(255)         | YES  |     | NULL    |                |
| illoIsClient     | tinyint(3) unsigned  |      |     | 0       |                |
| illoCopyright    | smallint(5) unsigned | YES  |     | NULL    |                |
+------------------+----------------------+------+-----+---------+----------------+

mysql> describe clientLink;
+-------------+----------------------+------+-----+---------+----------------+
| Field       | Type                 | Null | Key | Default | Extra          |
+-------------+----------------------+------+-----+---------+----------------+
| linkIlloID  | smallint(5) unsigned |      |     | 0       |                |
| linkComID   | smallint(5) unsigned |      |     | 0       |                |
| linkActive  | tinyint(3) unsigned  |      |     | 0       |                |
| linkEnduser | smallint(5) unsigned |      |     | 0       |                |
| linkID      | smallint(5) unsigned |      | PRI | NULL    | auto_increment |
+-------------+----------------------+------+-----+---------+----------------+
5 rows in set (0.02 sec)

mysql> describe company;
+----------------+----------------------+------+-----+---------+----------------+
| Field          | Type                 | Null | Key | Default | Extra          |
+----------------+----------------------+------+-----+---------+----------------+
| comID          | smallint(5) unsigned |      | PRI | NULL    | auto_increment |
| comLastName    | varchar(30)          |      |     |         |                |
| comFirstName   | varchar(20)          |      |     |         |                |
| comCompanyName | varchar(75)          |      |     |         |                |
| comEMail       | varchar(75)          |      |     |         |                |
| comPhone       | varchar(20)          |      |     |         |                |
| comIsEnduser   | tinyint(3) unsigned  |      |     | 0       |                |
| comPW          | varchar(20)          | YES  |     | NULL    |                |
+----------------+----------------------+------+-----+---------+----------------+
8 rows in set (0.02 sec)

mysql> describe users;    
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| userID   | smallint(6) |      | PRI | NULL    | auto_increment |
| userName | varchar(20) |      |     |         |                |
| userPW   | varchar(20) |      |     |         |                |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> describe crta;
+--------------------+----------------------+------+-----+------------+----------------+
| Field              | Type                 | Null | Key | Default    | Extra          |
+--------------------+----------------------+------+-----+------------+----------------+
| crtaID             | smallint(5) unsigned |      | PRI | NULL       | auto_increment |
| crtaLinkID         | smallint(5) unsigned |      |     | 0          |                |
| crtaLimitation     | tinyint(3) unsigned  |      |     | 0          |                |
| crtaLicensePeriod  | tinyint(3) unsigned  |      |     | 0          |                |
| crtaLicensePerText | varchar(255)         | YES  |     | NULL       |                |
| crtaExclusivity    | tinyint(3) unsigned  |      |     | 0          |                |
| crtaRegion         | tinyint(3) unsigned  |      |     | 0          |                |
| crtaRegionText     | varchar(255)         |      |     |            |                |
| crtaMedium         | tinyint(3) unsigned  |      |     | 0          |                |
| crtaFee            | varchar(16)          |      |     |            |                |
| crtaLicenseStart   | date                 |      |     | 0000-00-00 |                |
| crtaLicenseEnd     | date                 |      |     | 0000-00-00 |                |
| crtaAgreementDate  | date                 | YES  |     | NULL       |                |
| crtaUse            | varchar(255)         | YES  |     | NULL       |                |
+--------------------+----------------------+------+-----+------------+----------------+
14 rows in set (0.00 sec)