--UPDATE FROM 8.8.4.3 TO 8.8.4.4


DROP TABLE VERSION_8_8_4_3;



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


CREATE TABLE YMSP (
   YMSP_ID NUMBER(30) NOT NULL
  ,YMSP_MASTER_YPAC_ID NUMBER(30) NOT NULL
  ,YMSP_SUB_YPAC_ID NUMBER(30) NOT NULL
  ,CONSTRAINT YMSP_PK PRIMARY KEY (YMSP_ID) USING INDEX TABLESPACE V8INDEX 
) TABLESPACE V8CONF;  

CREATE SEQUENCE SEQ_YMSP INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE NOORDER;

COMMENT ON TABLE YMSP IS 'master sub package link';

CREATE TABLE XCMH (
   XCMH_ID NUMBER(30) NOT NULL
  ,XCMH_CRSTYPE VARCHAR2(30) NOT NULL 
  ,XCMH_TABLENAME VARCHAR2(4) NOT NULL
  ,XCMH_TABLEID NUMBER(30) NOT NULL
  ,XCMH_GID VARCHAR2(100) NOT NULL
  ,CONSTRAINT XCMH_PK PRIMARY KEY (XCMH_ID) USING INDEX TABLESPACE V8INDEX
) TABLESPACE V8MAIN;

CREATE SEQUENCE SEQ_XCMH INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE NOORDER;

COMMENT ON TABLE XCMH IS 'third party global id for any table';

ALTER TABLE WATY ADD (WATY_WEBGUESTENABLED NUMBER(1), WATY_XCED_ID NUMBER(30)); 

ALTER TABLE YPAC ADD YPAC_SUPPRESSPRICE NUMBER (1);

COMMENT ON COLUMN YPAC.YPAC_SUPPRESSPRICE IS 'Flag if package price should be suppressed on rate query';
