--ABS-79844 / ABS-81670   moved with ABS-136780

---CUSTOMSPREFERENCELOOKUP table---

create table CUSTOMSPREFERENCELOOKUP
(
  commoditycode   VARCHAR2(8) not null,
  countryoforigin VARCHAR2(3) not null,
  preferred       VARCHAR2(1) default 'N' not null
);
-- Add comments to the columns 
comment on column CUSTOMSPREFERENCELOOKUP.commoditycode
  is 'CUSTOMSTARIFFNUMBER';
comment on column CUSTOMSPREFERENCELOOKUP.countryoforigin
  is 'COUNTRY ISO CODE';
comment on column CUSTOMSPREFERENCELOOKUP.preferred
  is 'Y OR N';
-- Create/Recreate primary, unique and foreign key constraints 
alter table CUSTOMSPREFERENCELOOKUP
  add constraint PK_CUSTOMSPREFERENCELOOKUP primary key (COMMODITYCODE, COUNTRYOFORIGIN);
