No thats not what he is saying constants are varables that dont change i.e. a constant value. you are trying, rather the script you are installing is trying to assign it a value via a function which is not possible for a default value in MYSQL. i would try removing that default value, and trying out the script to see if there are any ill effects. FYI as far back as MYSQL 4.1.9 or further this will not work, so a downgrade might not fix it. Later.
~~:M A G n U m:~~
(Disclaimer: if any of this info is confusing or vague tough, its free!!)