mysql>mysql> CREATE TABLE Models -> ( -> ModelID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, -> Name VARCHAR(40) NOT NULL, -> PRIMARY KEY (ModelID) -> );Query OK, 0 rows affected (0.05 sec)mysql>mysql>mysql> CREATE TABLE Orders -> ( -> ID SMALLINT UNSIGNED NOT NULL PRIMARY KEY, -> ModelID SMALLINT UNSIGNED NOT NULL REFERENCES Models (ModelID), -> Description VARCHAR(40) -> );Query OK, 0 rows affected (0.03 sec)mysql>mysql> desc Models;+---------+----------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+---------+----------------------+------+-----+---------+----------------+| ModelID | smallint(5) unsigned | NO | PRI | NULL | auto_increment || Name | varchar(40) | NO | | | |+---------+----------------------+------+-----+---------+----------------+2 rows in set (0.02 sec)mysql>mysql> desc Orders;+-------------+----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-------------+----------------------+------+-----+---------+-------+| ID | smallint(5) unsigned | NO | PRI | | || ModelID | smallint(5) unsigned | NO | | | || Description | varchar(40) | YES | | NULL | |+-------------+----------------------+------+-----+---------+-------+3 rows in set (0.00 sec)mysql>mysql> drop table Orders;Query OK, 0 rows affected (0.00 sec)mysql>mysql> drop table Models;Query OK, 0 rows affected (0.00 sec)
Name (required)
email (will not be published) (required)
Website
