1171 Primary Key Error, Need Suggestion

[Teamjr]

Hello,

I am getting this error below and I am not sure how to solve it.

 

1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

 

I try to execute the script below, but I also get the above error?

 

CREATE TABLE IF NOT EXISTS discount_coupons_to_orders ( coupons_id VARCHAR(32) NOT NULL DEFAULT '', orders_id INT(11) DEFAULT '0', PRIMARY KEY (coupons_id,orders_id) )

 

Thanks JR