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);