-- Missing modifications on structural database; these were found during DB tests for 90200 release

ALTER TABLE RESIDUALVALUESCHEME
  ADD CONSTRAINT CALCBASIS_VALID1_1
  CHECK (CALCULATIONBASIS IN (1, 2, 3));
  
ALTER TABLE INTERNALSUPPLYCHAIN DROP COLUMN ACTIVE;

ALTER TABLE LDAPSETTINGS MODIFY(HOSTNAME DEFAULT 'ldap://127.0.0.1');