Sql Server

Sql Server

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

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

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

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

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

-- Discount Category table.
create table DISCOUNT_CATEGORY (
ID_DISCOUNT_CATEGORY INT IDENTITY NOT NULL,
REFERENCE_KEY VARCHAR(50) NOT NULL, 
DISCOUNT_PERCENT DOUBLE PRECISION NOT NULL,
DESCRIPTION VARCHAR(255) null,
primary key (ID_DISCOUNT_CATEGORY)
)

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