alter Table KeymanQuotation Add SurvivalBenefitOption money null

Alter Table client Add CKYCNo varchar(15) null

alter table bonus drop constraint CK__Bonus__BonusType__60A75C0F 
alter table insurancePlan drop constraint CK__Insurance__Bonus__02C769E9

alter Table Bonus add constraint CK__Bonus__BonusType__60A75C0F check 
([BonusType] = 'JMP' or [BonusType] = 'WLP' 
or [BonusType] = 'JSP' or [BonusType] = 'MBP' or [BonusType] = 'ENP' or [BonusType] = 'ANA' or [BonusType] = 'ANP' 
or [BonusType] = 'SNP' or [BonusType] = 'CBK' or [BonusType] = 'JRP' or [BonusType] = 'NJD' or [BonusType] = 'NJS' 
or [BonusType] = 'JAP' or [BonusType] = 'JTP' or [BonusType] = 'JMT' or [BonusType] = 'CCP' or [BonusType] = 'CFP'
or [BonusType] = 'JBP' or [BonusType] = 'JS1' or [BonusType] = 'JRP' or [BonusType] = 'JDP' or [BonusType] = 'JNP'
or [BonusType] = 'JPP' or [BonusType] = 'JAP' or [BonusType] = 'AMR' or [BonusType] = 'JB1' or [BonusType] = 'CMB'
or [BonusType] = '814' or [BonusType] = '817' or [BonusType] = '820' or [BonusType] = '048' or [BonusType] = '830'
or [BonusType] = '832' or [BonusType] = '833' or [BonusType] = '815' or  [BonusType] = '834' or [BonusType] = '836'
or [BonusType] = '838' or [BonusType] = '812' or [BonusType] = '845' or [BonusType] = '914' or [BonusType] = '917' 
or [BonusType] = '920' or  [BonusType] = '932' or [BonusType] = '933'
or [BonusType] = '915' or [BonusType] = '934' or [BonusType] = '936' or [BonusType] = '945' or [BonusType] = '745'
)

alter Table InsurancePlan add constraint CK__Insurance__Bonus__02C769E9 check 
([BonusType] = 'JMP' or [BonusType] = 'WLP' 
or [BonusType] = 'JSP' or [BonusType] = 'MBP' or [BonusType] = 'ENP' or [BonusType] = 'ANA' or [BonusType] = 'ANP' 
or [BonusType] = 'SNP' or [BonusType] = 'CBK' or [BonusType] = 'JRP' or [BonusType] = 'NJD' or [BonusType] = 'NJS' 
or [BonusType] = 'JAP' or [BonusType] = 'JTP' or [BonusType] = 'JMT' or [BonusType] = 'CCP' or [BonusType] = 'CFP'
or [BonusType] = 'JBP' or [BonusType] = 'JS1' or [BonusType] = 'JRP' or [BonusType] = 'JDP' or [BonusType] = 'JNP'
or [BonusType] = 'JPP' or [BonusType] = 'JAP' or [BonusType] = 'AMR' or [BonusType] = 'JB1' or [BonusType] = 'CMB'
or [BonusType] = '814' or [BonusType] = '817' or [BonusType] = '820' or [BonusType] = '048' or [BonusType] = '830'
or [BonusType] = '832' or [BonusType] = '833' or [BonusType] = '815' or  [BonusType] = '834' or [BonusType] = '836'
or [BonusType] = '838' or [BonusType] = '812' or [BonusType] = '845' or [BonusType] = '914' or [BonusType] = '917' 
or [BonusType] = '920' or  [BonusType] = '932' or [BonusType] = '933'
or [BonusType] = '915' or [BonusType] = '934' or [BonusType] = '936' or [BonusType] = '945' or [BonusType] = '745'
)

