CREATE TABLE `activity` ( `name` varchar(40) NOT NULL, `activity` varchar(40) NOT NULL, `activity_date` date DEFAULT '2014-01-01', `start_time` time DEFAULT '00:00:00', `finish_time` time DEFAULT '00:00:00', `note` varchar(200) DEFAULT NULL );