ALTER TABLE PURCHASES MODIFY CUSTOMER_ID char NOT NULL;

Field, Type, Null, Key, Default, Extra
CUSTOMER_ID, char(5), YES, , NULL,

ALTER TABLE PURCHASES MODIFY  CUSTOMER_ID char NOT NULL;