Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

-- Added discount percent to instructions table
ALTER TABLE INSTRUCTIONS ADD DISCOUNT_PERCENT DOUBLE PRECISION null;

-- Add an instrument to the allocations table.
ALTER TABLE ALLOCATIONS ADD INSTRUMENT_ID INT null;
 
ALTER TABLE ALLOCATIONS 
	add constraint ALLOC_INSTRUMENT_FK 
	foreign key (INSTRUMENT_ID) 
	references INSTRUMENTS

 

--

-- ORACLE

--

----Derivative access type in users table
ALTER TABLE USERS ADD DERIVATIVES_ACCESS_TYPE NUMBER(10,0) NULL;

...