1CREATE DATABASE numismatics;
2
3CREATE DATABASE numismatics;
4
5CREATE TABLE coin (cid INT(8) PRIMARY KEY,
6                       unit VARCHAR(20),
7                       value NUMERIC(8,2), -- just a comment here;
8                       mintage_year INT(8),
9                       mint_id INT(8),
10                       CONSTRAINT mint_id_fk FOREIGN KEY(mint_id)
11                           REFERENCES mint(mid));
12