CREATE TABLE list
	(
	     name	VARCHAR(35) NOT NULL,
	     tckr		VARCHAR(5) NOT NULL,
	     mrkt	VARCHAR(6) NOT NULL,
	     sctr		VARCHAR(6) NOT NULL,
	     mcap	DECIMAL(5,1) NULL,
	     active	ENUM('yes','no') NULL,
	     note	VARCHAR(60) NULL
	);