few things that strike me about the table definition:
1) I recommend using a naming convention that will prevent the possibility of using reserved words. the naming convention I like to use is to use <tableName><columnName>
for example:
motbookings:
motbookingID
motbookingName
motbookingAddress
etc...
2) you have the ID column set to mediumint, but the length is restricted to 9. that is nnot long enough for a medium int.
instead use a regular int and set the length to 11:
int(11)
3) you have 2 un needed keys set for the ID column:
UNIQUE KEY `ID` (`ID`),
KEY `ID_2` (`ID`)
by setting the ID column as a primary key, it already has a unique constraint, and it is already set as a key
4) the date column is set to varchar(500)
`Address` varchar(500) DEFAULT NULL,
if your server is using 5.0.3 or earlier, the maximum length for a varchar column is 250, to be able to use a larger length, double check the mysql server version.