--From PVD
-- Create/Recreate primary, unique and foreign key constraints 
alter table I_EMBLEMTEMPLATE
  drop constraint PK_I_EMBLEMTEMPLATE cascade;
drop index PK_I_EMBLEMTEMPLATE;
alter table I_EMBLEMTEMPLATE
  add constraint PK_I_EMBLEMTEMPLATE unique (CUSTOMERNUMBER, TEMPLATECODE, PRODUCTCODE, SIZECODE, TEXTCOLORCODE, BORDERCOLORCODE, BACKGROUNDCOLORCODE, FABRICCODE, PLACEMENTCODE, EMBLEMFONTDESCRIPTION, EMBLEMTYPE);