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