Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\Administrator>mysql evsdb -u evs_protege -p
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26 to server version: 4.0.21-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> describe concept_history
    -> ;
+------------+--------------+------+-----+------------+----------------+
| Field      | Type         | Null | Key | Default    | Extra          |
+------------+--------------+------+-----+------------+----------------+
| historyid  | mediumint(9) |      | PRI | NULL       | auto_increment |
| concept    | varchar(32)  |      |     |            |                |
| editaction | varchar(6)   |      |     |            |                |
| editdate   | date         |      |     | 0000-00-00 |                |
| reference  | varchar(32)  | YES  |     | NULL       |                |
+------------+--------------+------+-----+------------+----------------+
5 rows in set (0.00 sec)

mysql> describe evs_history;
+---------------+---------------+------+-----+---------+----------------+
| Field         | Type          | Null | Key | Default | Extra          |
+---------------+---------------+------+-----+---------+----------------+
| historyid     | mediumint(9)  |      | PRI | NULL    | auto_increment |
| conceptcode   | varchar(32)   |      |     |         |                |
| conceptname   | varchar(255)  |      |     |         |                |
| action        | varchar(40)   |      |     |         |                |
| editdate      | timestamp(14) | YES  |     | NULL    |                |
| editname      | varchar(40)   |      |     |         |                |
| host          | varchar(50)   |      |     |         |                |
| published     | mediumint(22) | YES  |     | 0       |                |
| referencecode | varchar(32)   | YES  |     | NULL    |                |
+---------------+---------------+------+-----+---------+----------------+
9 rows in set (0.03 sec)

mysql>