mysql>mysql> CREATE TABLE myTable -> ( -> OrderID SMALLINT UNSIGNED NOT NULL, -> ModelID SMALLINT UNSIGNED NOT NULL, -> PRIMARY KEY (OrderID), -> INDEX (ModelID) -> );Query OK, 0 rows affected (0.03 sec)mysql>mysql> desc myTable;+---------+----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+----------------------+------+-----+---------+-------+| OrderID | smallint(5) unsigned | NO | PRI | | || ModelID | smallint(5) unsigned | NO | MUL | | |+---------+----------------------+------+-----+---------+-------+2 rows in set (0.00 sec)mysql>mysql> drop table myTable;Query OK, 0 rows affected (0.00 sec)
Name (required)
email (will not be published) (required)
Website