CREATE TABLE  flanbook ( flan_id VARCHAR(25), given VARCHAR(40),born  DATE, male CHAR(1),  first VARCHAR(20),  last VARCHAR(20),photo VARCHAR(50), photo_then VARCHAR(50),  died DATE,deceased CHAR(1) );
