How to create a table in MySQL

DROP TABLE IF EXISTS `album`;
CREATE TABLE `album` (
`ID` bigint(20) NOT NULL auto_increment,
`PID` bigint(20) NOT NULL,
`GUID` varchar(36) default 'UUID()',
`InsertTimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`UpdateTimeStamp` datetime NOT NULL,
`DeleteTimeStamp` datetime NOT NULL,
`Description` varchar(100) NOT NULL,
`Name` varchar(100) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;