Database Changes 1.10 Oracle

Oracle

-- Added discount percent to allocations table
ALTER TABLE ALLOCATIONS ADD DISCOUNT_CATEGORY VARCHAR2(50) null;

-- Added discount percent to preallocations table
ALTER TABLE PREALLOCATIONS ADD DISCOUNT_CATEGORY VARCHAR2(50) null;

-- Added the potfolio ssn to the portfolios table
ALTER TABLE PORTFOLIOS ADD PORTFOLIO_SSN VARCHAR2(50) NULL;

-- Added the default discount category to the portfolios table
ALTER TABLE PORTFOLIOS ADD DEFAULT_DISCOUNT_CATEGORY VARCHAR2(50) NULL;

-- Added the account ssn to the accounts table
ALTER TABLE ACCOUNTS ADD ACCOUNT_SSN VARCHAR2(50) NULL;

-- Discount Category table.

create sequence DISCOUNT_CATEGORY_SEQ;
create table DISCOUNT_CATEGORY (
ID_DISCOUNT_CATEGORY NUMBER(10,0) not null,
REFERENCE_KEY VARCHAR2(50), 
DISCOUNT_PERCENT FLOAT,
DESCRIPTION VARCHAR2(255) null,
primary key (ID_DISCOUNT_CATEGORY)
);

-- Added discount percent to allocations table
ALTER TABLE ALLOCATIONS ADD BACKOFFICE_ID VARCHAR2(50) null;