--From PVD , request from HOW

-- Create/Recreate primary, unique and foreign key constraints 
alter table I_TEMPORARYDELIVERYSTOP 
 drop constraint PKI_TEMPORARYDELIVERYSTOP; 
 
alter table I_TEMPORARYDELIVERYSTOP 
 add constraint PKI_TEMPORARYDELIVERYSTOP unique (CUSTOMERNUMBER, DEPARTMENTNUMBER, CONSUMPTIONPOINTNUMBER, PRODUCTCODE, SIZECODE, FINISHINGMETHODCODE, DATEACTIVE, DELIVERYSCHEMECODE, SEASONTYPECODE, SEASONCODE, TEMPSTOPSTARTYEAR, TEMPSTOPSTARTYEARWEEK, TEMPSTOPENDYEAR, TEMPSTOPENDYEARWEEK, TEMPSTOPSTARTWEEK, TEMPSTOPENDWEEK, TEMPSTOPRETURNWEEK, ENDDATE, STARTDATE); 