mysql>
mysql> CREATE TABLE Orders
-> (
-> OrderID SMALLINT UNSIGNED NOT NULL,
-> ModelID SMALLINT UNSIGNED NOT NULL,
-> ModelName VARCHAR(40),
-> PRIMARY KEY (OrderID),
-> FULLTEXT (ModelName)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> drop table orders;
Query OK, 0 rows affected (0.00 sec)
mysql>