-- Make sure you have a backup before updating to a new version of ABSSolute!
-- Software order 502807 several i-table changes
-- delete from table I_UNIQUERESITEM to make sure we can always add the key to Businessunit!
delete from I_UNIQUERESITEM;
-- Create/Recreate primary, unique and foreign key constraints 
alter table I_UNIQUERESITEM
  add constraint FKI_UNIQUERESITEM_BUSINESSUNIT foreign key (BUSINESSUNITCODE)
  references businessunit (CODE);
-- Create/Recreate indexes 
create index XIF1_I_UNIQUERESITEM on I_UNIQUERESITEM (customernumber, clientnumber);
create index XIF2_I_UNIQUERESITEM on I_UNIQUERESITEM (businessunitcode);
