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
8CREATE INDEX unit_index ON coin(unit);
9
10CREATE INDEX unit_index1 ON coin(unit);
11
12