--UPDATE FROM 8.8.2.1 TO 8.8.2.2


DROP TABLE VERSION_8_8_2_1;



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


ALTER TABLE YBOM ADD YBOM_CHANNEL_YRAS_ID NUMBER(30);

COMMENT ON COLUMN YBOM.YBOM_CHANNEL_YRAS_ID IS 'Channel code link';

ALTER TABLE YRAS ADD YRAS_DEFAULT_CCM NUMBER(1) default 0 ;

COMMENT ON COLUMN YRAS.YRAS_DEFAULT_CCM IS 'Default for new CCM bookings can be set for one source and once channel code';

CREATE TABLE XGCA (
    XGCA_ID NUMBER(30) NOT NULL
   ,XGCA_SHORTDESC VARCHAR2(5) NOT NULL 
   ,XGCA_LONGDESC VARCHAR2(30) NOT NULL
   ,XGCA_INACTIVE NUMBER(1)
   ,XGCA_DISPLORDER NUMBER(3)
   ,CONSTRAINT XGCA_PK PRIMARY KEY (XGCA_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;
   
CREATE SEQUENCE SEQ_XGCA INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE NOORDER;

COMMENT ON TABLE XGCA IS 'childage category groups';

ALTER TABLE YRCH ADD YRCH_XGCA_ID NUMBER(30);

COMMENT ON COLUMN YRCH.YRCH_XGCA_ID IS 'childage category group';

COMMENT ON COLUMN XCAC.XCAC_XGCA_ID IS 'childage category group';
