CREATE TABLE IF NOT EXISTS lists ( list_id INT NOT NULL AUTO_INCREMENT, -- unique ID of list scheduled_dt DATE, -- day for which this entry is scheduled value VARCHAR(512) NOT NULL, -- list text (i.e., "You know you're in Jersey when ...") PRIMARY KEY pk_lists (list_id), INDEX ik_lists_1 (scheduled_dt) ) ENGINE=MyISAM;