
CREATE DATABASE numismatics;

CREATE TABLE table1 (att_int INT(8) PRIMARY KEY,
			att_char CHAR(20),
			att_varchar VARCHAR(20),
			att_bit BIT,
			att_tinyint TINYINT,
			att_smallint SMALLINT(2),
			att_integer INTEGER(4),
			att_bigint BIGINT,
			att_real REAL,
			att_double DOUBLE,
			att_float FLOAT,
			att_decimal DECIMAL,
			att_numeric NUMERIC,
			att_bin bin(5));
