# Create president table for US Historical League

USE u30;
DROP TABLE IF EXISTS president;
CREATE TABLE president
(
	last_name VARCHAR(15) NOT NULL,
	first_name VARCHAR(15) NOT NULL,
	suffix VARCHAR(5) NULL,		/* name suffix (Jr., II, etc.) */
	city VARCHAR(20) NOT NULL,
	state VARCHAR(2) NOT NULL,
	birth DATE NOT NULL,
	death DATE NULL
);
