Problem setting default value for column with concat()

[Tim Russell]

Hi all,

When I run the following code the default value isn't being calculated using the concat
and other functions.  Instead it is setting the column definition as a string:    
CONCAT("TMP
How can I rework this to get a result more like 
TMP-T-00002
?


USE cro;

CREATE TABLE lpamform (
  crofileno VARCHAR(11) NOT NULL DEFAULT 'CONCAT("TMP-T-",ROUND(RAND(NOW())*100000))',
  docstatus ENUM('C','A') NOT NULL DEFAULT 'C',
  PRIMARY KEY (crofileno)
) TYPE=MyISAM;

Thanks,
Tim