if you are seeing 

Fatal error: Undefined class constant ‘COUPON_TYPE_NO_COUPON’ in /var/www/html/app/code/core/Mage/SalesRule/sql/salesrule_setup/mysql4-upgrade-1.4.0.0.1-1.4.0.0.2.php

edit

/var/www/html/app/code/core/Mage/SalesRule/sql/salesrule_setup/mysql4-upgrade-1.4.0.0.1-1.4.0.0.2.php

change

'smallint unsigned NOT NULL DEFAULT "' . Mage_SalesRule_Model_Rule::COUPON_TYPE_NO_COUPON . '"'

to 

'smallint unsigned NOT NULL DEFAULT "' . 1 . '"'

and

coupon_type = '" . Mage_SalesRule_Model_Rule::COUPON_TYPE_SPECIFIC . "';

to

coupon_type = '" . 2 . "';

run the upgrade then change the code back agian… real pain!!