Column types

CREATE TABLE Orders
(
OrderId INT NOT NULL,
ProductName VARCHAR(50) NOT NULL,
OrderDate datetime ,
PRIMARY KEY (OrderId)
)

mysql> create table tape_usage ( when_at datetime , inuse int );
Query OK, 0 rows affected (0.61 sec)
 
mysql> desc tape_usage;
+---------+----------+------+-----+---------+-------+
| Field   | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| when_at | datetime | YES  |     | NULL    |       |
| inuse   | int(11)  | YES  |     | NULL    |       |
+---------+----------+------+-----+---------+-------+
2 rows in set (0.15 sec)