...
-- Added discount percent to instructions table
ALTER TABLE INSTRUCTIONS ADD DISCOUNT_PERCENT FLOAT NULL;
-- Add an instrument to the allocations table.ALTER TABLE ALLOCATIONS ADD INSTRUMENT_ID NUMBER(10,0) NULL; ALTER TABLE ALLOCATIONS ADD CONSTRAINT ALLOC_INSTRUMENT_FK FOREIGN KEY (INSTRUMENT_ID) REFERENCES INSTRUMENTS(ID_INSTRUMENTS);