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