1
2CREATE INDEX unit_index ON coin(unit);
3
4CREATE TABLE coin (cid INT(8) PRIMARY KEY,
5                       unit VARCHAR(20),
6                       value NUMERIC(8,2), -- just a comment here;
7                       mintage_year INT(8),
8                       mint_id INT(8));
9
10CREATE DATABASE numismatics;  
11