The definition should look something like this:

CREATE TABLE `courses` (
  `courseid` bigint(20) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT NULL,
  `d2lcode` varchar(200) NOT NULL,
  `crns` varchar(100) DEFAULT NULL,
  `datein` datetime DEFAULT NULL,
  `transferasked` tinyint(1) NOT NULL DEFAULT '0',
  `transferaskeddate` datetime DEFAULT NULL,
  `transferred` tinyint(1) NOT NULL DEFAULT '0',
  `transferdate` datetime DEFAULT NULL,
  `tblopen` tinyint(1) NOT NULL DEFAULT '0',
  `tblopenstamp` datetime DEFAULT NULL,
  `enddate` datetime DEFAULT NULL,
  `transferenddate` datetime DEFAULT NULL,
  `campuscode` varchar(2) DEFAULT '?',
  `errorinchecking` tinyint(1) NOT NULL DEFAULT '0',
  `checkerror` text,
  `checkmesage` text,
  `errorintransfer` tinyint(1) NOT NULL DEFAULT '0',
  `transfererrormessage` text,
  PRIMARY KEY (`courseid`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1

And spit out something like this:
ALTER TABLE `courses` CHANGE `courseid` `courseid` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ''
ALTER TABLE `courses` CHANGE  `user`  `user` varchar(50) NOT NULL COMMENT '';
ALTER TABLE `courses` CHANGE  `d2lcode` `d2lcode` varchar(200) NOT NULL COMMENT '';
ALTER TABLE `courses` CHANGE  `crns` `crns` varchar(100) DEFAULT NULL COMMENT '';