--UPDATE FROM 8.10.1.0 TO 8.10.1.10


DROP TABLE VERSION_8_10_1_0;


/*  VERSION_8_10_1_10  */
CREATE TABLE VERSION_8_10_1_10 (
	 DUMMY	NUMBER	    NULL
)
;

ALTER TABLE YGCO ADD YGCO_NOTINBLOCK NUMBER(1) DEFAULT 0 NOT NULL;

COMMENT ON COLUMN YGCO.YGCO_NOTINBLOCK IS 'Codes with this setting enabled are not shown in the drop down list in Policylist Edit in block header';

ALTER TABLE YCDP ADD YCDP_NOTINBLOCK NUMBER(1);

COMMENT ON COLUMN YCDP.YCDP_NOTINBLOCK IS 'Codes with this setting enabled are not shown in the drop down list in Policylist Edit in block header';

ALTER TABLE YRGA ADD YRGA_FINALAMOUNT NUMBER(30,4);

ALTER TABLE YRGA ADD YRGA_FINALFOREIGNAMOUNT NUMBER(30,4);

ALTER TABLE YDET MODIFY YDET_YCAT_ID NULL;

UPDATE YDET SET YDET_YCAT_ID=NULL WHERE YDET_YCAT_ID=0; 

ALTER TABLE YDET ADD YDET_ANY_YCAT_ID NUMBER(30);

UPDATE YDET SET YDET_ANY_YCAT_ID=nvl(YDET_YCAT_ID,YDET_BED_YCAT_ID);

ALTER TABLE YDET MODIFY YDET_ANY_YCAT_ID NOT NULL;

ALTER TABLE SMRT ADD SMRT_CHILDS_G1_D NUMBER(5);
ALTER TABLE SMRT ADD SMRT_CHILDS_G2_D NUMBER(5);
ALTER TABLE SMRT ADD SMRT_CHILDS_G3_D NUMBER(5);
ALTER TABLE SMRT ADD SMRT_CHILDS_G1_M NUMBER(5);
ALTER TABLE SMRT ADD SMRT_CHILDS_G2_M NUMBER(5);
ALTER TABLE SMRT ADD SMRT_CHILDS_G3_M NUMBER(5);
ALTER TABLE SMRT ADD SMRT_CHILDS_G1_Y NUMBER(7);
ALTER TABLE SMRT ADD SMRT_CHILDS_G2_Y NUMBER(7);
ALTER TABLE SMRT ADD SMRT_CHILDS_G3_Y NUMBER(7);

ALTER TABLE SMRT ADD SMRT_YCAT_TYPE NUMBER(1);

ALTER TABLE YBED MODIFY YBED_DISPLORDER NUMBER(6);

ALTER TABLE YRCH MODIFY YRCH_DISPLORDER NUMBER(4);

ALTER TABLE YRCH MODIFY YRCH_SELECTORDER NUMBER(4);

ALTER TABLE YXLS ADD YXLS_PURPOSE NUMBER(1) DEFAULT 0 NOT NULL;

COMMENT ON COLUMN YXLS.YXLS_PURPOSE IS '0=Rooming list 1=Reservation multi guest';
