/************************************************************************************************************************
*
*
*  Date: September 07, 2011  13:13:13
*
*  This upgrade script was automatically generated by DBDiff for Oracle (www.dbdiff.com)
*
*  SOURCE DATABASE:  VERSION_8_9_0@AMD64
*  TARGET DATABASE:  VERSION_8_8_4@AMD64
*
*  This script should be executed as VERSION_8_8_4 in database VERSION_8_8_4@AMD64 except where otherwise noted.
*
*  IMPORTANT:  As with any script, you should always perform a sanity check before executing it in your target database.
*
*
************************************************************************************************************************/




/************************************************************************************************************************
*
*  sequences
*
*  The following statements will upgrade the sequences
*
************************************************************************************************************************/

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


/************************************************************************************************************************
*
*  tables
*
*  907 tables were found in VERSION_8_9_0@AMD64
*  871 tables were found in VERSION_8_8_4@AMD64
*
************************************************************************************************************************/




/************************************************************************************************************************
*
*  The following statements will drop tables that DO NOT exist in VERSION_8_9_0@AMD64
*
************************************************************************************************************************/


DROP TABLE VERSION_8_8_4_0;


/************************************************************************************************************************
*
*  The following statements will drop Views that DO NOT exist in VERSION_8_9_0@AMD64
*
************************************************************************************************************************/


DROP VIEW V8_ED_CCM_YEMN_YEMN;


/************************************************************************************************************************
*
*  The following statements will create tables that DO NOT exist in VERSION_8_8_4@AMD64
*
************************************************************************************************************************/


/*  FPLD  */
CREATE TABLE FPLD (
	 FPLD_ID	NUMBER(30)	NOT NULL
	,FPLD_SHORTDESC	VARCHAR2(3)	NOT NULL
	,FPLD_LONGDESC	VARCHAR2(30)	NOT NULL
	,FPLD_DISPLAYORDER	NUMBER(5)	NOT NULL
	,FPLD_ROLE	NUMBER(1)	NOT NULL
	,FPLD_INACTIVE	NUMBER(1)	    NULL
	,FPLD_VALIDFROM	DATE	    NULL
	,FPLD_VALIDUNTIL	DATE	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE FPLD ADD (
	CONSTRAINT FPLD_PK
	PRIMARY KEY
	            (
	             FPLD_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  FPLS  */
CREATE TABLE FPLS (
	 FPLS_ID	NUMBER(30)	NOT NULL
	,FPLS_FPLD_ID	NUMBER(30)	NOT NULL
	,FPLS_YOUT_ID	NUMBER(30)	    NULL
	,FPLS_YSME_ID	NUMBER(30)	    NULL
	,FPLS_PRICE	NUMBER(30,4)	NOT NULL
	,FPLS_EXCLUDE	NUMBER(1)	    NULL
	,FPLS_FLEX	NUMBER(1)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE FPLS ADD (
	CONSTRAINT FPLS_PK
	PRIMARY KEY
	            (
	             FPLS_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX FPLS_FPLD_ID ON FPLS
	(
	  FPLS_FPLD_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX FPLS_YOUT_ID ON FPLS
	(
	  FPLS_YOUT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX FPLS_YSME_ID ON FPLS
	(
	  FPLS_YSME_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  SFOR  */
CREATE TABLE SFOR (
	 SFOR_ID	NUMBER(30)	NOT NULL
	,SFOR_DATE	DATE	NOT NULL
	,SFOR_YRES_ID	NUMBER(30)	    NULL
	,SFOR_ZFAC_ID	NUMBER(30)	    NULL
	,SFOR_YDET_ID	NUMBER(30)	    NULL
	,SFOR_YRES_ACTARRTIME	DATE	    NULL
	,SFOR_YRES_ACTDEPTIME	DATE	    NULL
	,SFOR_YRES_EXPARRTIME	DATE	    NULL
	,SFOR_YRES_EXPDEPTIME	DATE	    NULL
	,SFOR_YRES_RESSTATUS	NUMBER(1)	    NULL
	,SFOR_YRES_NOAVAILREASON	NUMBER(1)	    NULL
	,SFOR_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_GUESTNAME	VARCHAR2(35)	    NULL
	,SFOR_YCLN_1_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_COMPANYNAME	VARCHAR2(35)	    NULL
	,SFOR_YCLN_2_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_TAGENTNAME	VARCHAR2(35)	    NULL
	,SFOR_YCLN_3_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_SOURCENAME	VARCHAR2(35)	    NULL
	,SFOR_YCLN_4_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_INDINAME	VARCHAR2(35)	    NULL
	,SFOR_YCLN_5_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_VENDNAME	VARCHAR2(35)	    NULL
	,SFOR_YCLN_6_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_MPLANNAME	VARCHAR2(35)	    NULL
	,SFOR_YCLN_7_XCMS_ID	NUMBER(30)	    NULL
	,SFOR_BOOKERNAME	VARCHAR2(35)	    NULL
	,SFOR_YDET_YGRP_ID	NUMBER(30)	    NULL
	,SFOR_GROUPNAME	VARCHAR2(30)	    NULL
	,SFOR_YBLH_ID	NUMBER(30)	    NULL
	,SFOR_YBLH_SHORTDESC	VARCHAR2(10)	    NULL
	,SFOR_YDET_YRMS_ID	NUMBER(30)	    NULL
	,SFOR_YRMS_SHORTDESC	VARCHAR2(10)	    NULL
	,SFOR_YDET_YCAT_ID	NUMBER(30)	    NULL
	,SFOR_YCAT_SHORTDESC	VARCHAR2(5)	    NULL
	,SFOR_YDET_YRCH_ID	NUMBER(30)	    NULL
	,SFOR_YRCH_SHORTDESC	VARCHAR2(10)	    NULL
	,SFOR_YDET_XCMA_ID	NUMBER(30)	    NULL
	,SFOR_XCMA_SHORTDESC	VARCHAR2(3)	    NULL
	,SFOR_SOURCE_ID	NUMBER(30)	    NULL
	,SFOR_SOURCE	VARCHAR2(30)	    NULL
	,SFOR_CHANNEL_ID	NUMBER(30)	    NULL
	,SFOR_CHANNEL	VARCHAR2(30)	    NULL
	,SFOR_YDET_ADULTNO	NUMBER(3)	    NULL
	,SFOR_YDET_SHARENUM	NUMBER(30)	    NULL
	,SFOR_TOTALYRGL_NUMBER	NUMBER(30,4)	    NULL
	,SFOR_GROSSROOMREV	NUMBER(30,4)	    NULL
	,SFOR_NETROOMREV	NUMBER(30,4)	    NULL
	,SFOR_GROSSFBREV	NUMBER(30,4)	    NULL
	,SFOR_NETFBREV	NUMBER(30,4)	    NULL
	,SFOR_GROSSMINIBARREV	NUMBER(30,4)	    NULL
	,SFOR_NETMINIBARREV	NUMBER(30,4)	    NULL
	,SFOR_GROSSTELEREV	NUMBER(30,4)	    NULL
	,SFOR_NETTELEREV	NUMBER(30,4)	    NULL
	,SFOR_GROSSMISCREV	NUMBER(30,4)	    NULL
	,SFOR_NETMISCREV	NUMBER(30,4)	    NULL
	,SFOR_NETREV	NUMBER(30,4)	    NULL
	,SFOR_GROSSREV	NUMBER(30,4)	    NULL
	,SFOR_ARR_ID	NUMBER(1)	    NULL
	,SFOR_DEP_ID	NUMBER(1)	    NULL
	,SFOR_YDET_NOOFROOMS	NUMBER(3)	    NULL
	,SFOR_XCOU_ID	NUMBER(30)	    NULL
	,SFOR_HOTELCODE	VARCHAR2(5)	    NULL
	,SFOR_WPHS_ID	NUMBER(30)	    NULL
	,SFOR_PARTNER_ID	NUMBER(30)	    NULL
	,SFOR_IMPORTED	NUMBER(1)	    NULL
	,SFOR_YRCH_COMPSTATUS	NUMBER(1)	    NULL
	,SFOR_VIPCODE	VARCHAR2(3)	    NULL
	,SFOR_VIPCODE_LONGDESC	VARCHAR2(30)	    NULL
	,SFOR_YBOM_ID	NUMBER(30)	    NULL
	,SFOR_XSTA_ID	NUMBER(30)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE SFOR ADD (
	CONSTRAINT SFOR_PK
	PRIMARY KEY
	            (
	             SFOR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX SFOR_ARR_ID ON SFOR
	(
	  SFOR_ARR_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_CHANNEL_ID ON SFOR
	(
	  SFOR_CHANNEL_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_DEP_ID ON SFOR
	(
	  SFOR_DEP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_PARTNER_ID ON SFOR
	(
	  SFOR_PARTNER_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_SOURCE_ID ON SFOR
	(
	  SFOR_SOURCE_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_WPHS_ID ON SFOR
	(
	  SFOR_WPHS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_XCMS_ID ON SFOR
	(
	  SFOR_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_XCOU_ID ON SFOR
	(
	  SFOR_XCOU_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_XSTA_ID ON SFOR
	(
	  SFOR_XSTA_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YBLH_ID ON SFOR
	(
	  SFOR_YBLH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YBOM_ID ON SFOR
	(
	  SFOR_YBOM_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YCLN_1_XCMS_ID ON SFOR
	(
	  SFOR_YCLN_1_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YCLN_2_XCMS_ID ON SFOR
	(
	  SFOR_YCLN_2_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YCLN_3_XCMS_ID ON SFOR
	(
	  SFOR_YCLN_3_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YCLN_4_XCMS_ID ON SFOR
	(
	  SFOR_YCLN_4_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YCLN_5_XCMS_ID ON SFOR
	(
	  SFOR_YCLN_5_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YCLN_6_XCMS_ID ON SFOR
	(
	  SFOR_YCLN_6_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YCLN_7_XCMS_ID ON SFOR
	(
	  SFOR_YCLN_7_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YDET_ID ON SFOR
	(
	  SFOR_YDET_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YDET_XCMA_ID ON SFOR
	(
	  SFOR_YDET_XCMA_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YDET_YCAT_ID ON SFOR
	(
	  SFOR_YDET_YCAT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YDET_YGRP_ID ON SFOR
	(
	  SFOR_YDET_YGRP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YDET_YRCH_ID ON SFOR
	(
	  SFOR_YDET_YRCH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YDET_YRMS_ID ON SFOR
	(
	  SFOR_YDET_YRMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_YRES_ID ON SFOR
	(
	  SFOR_YRES_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SFOR_ZFAC_ID ON SFOR
	(
	  SFOR_ZFAC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  VERSION_8_9_0_0  */
CREATE TABLE VERSION_8_9_0_0 (
	 DUMMY	NUMBER	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;


/*  W8HP  */
CREATE TABLE W8HP (
	 W8HP_ID	NUMBER(30)	NOT NULL
	,W8HP_URLTEXT	VARCHAR2(200)	    NULL
	,W8HP_QUESTIONNAIRETEXT	VARCHAR2(2000)	    NULL
	,W8HP_TABRESMAXPAX	NUMBER(2)	    NULL
	,W8HP_XPDA_ID	NUMBER(30)	    NULL
	,W8HP_CCM_WRPT_ID	NUMBER(30)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE W8HP ADD (
	CONSTRAINT W8HP_PK
	PRIMARY KEY
	            (
	             W8HP_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX W8HP_CCM_WRPT_ID ON W8HP
	(
	  W8HP_CCM_WRPT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX W8HP_XPDA_ID ON W8HP
	(
	  W8HP_XPDA_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WDWI  */
CREATE TABLE WDWI (
	 WDWI_ID	NUMBER(30)	NOT NULL
	,WDWI_NAME	VARCHAR2(50)	NOT NULL
	,WDWI_DESCRIPTION	VARCHAR2(200)	    NULL
	,WDWI_INACTIVE	NUMBER(1)	    NULL
	,WDWI_LEFT	NUMBER(30)	    NULL
	,WDWI_TOP	NUMBER(30)	    NULL
	,WDWI_HEIGHT	NUMBER(30)	    NULL
	,WDWI_WIDTH	NUMBER(30)	    NULL
	,WDWI_URL	VARCHAR2(250)	NOT NULL
	,WDWI_DISPLORDER	NUMBER(10)	    NULL
	,WDWI_HIDDEN	NUMBER(1)	    NULL
	,WDWI_CONTENT	NCLOB	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WDWI ADD (
	CONSTRAINT WDWI_PK
	PRIMARY KEY
	            (
	             WDWI_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WDWI_DISPLORDER ON WDWI
	(
	  WDWI_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WDWU  */
CREATE TABLE WDWU (
	 WDWU_ID	NUMBER(30)	NOT NULL
	,WDWU_XCED_ID	NUMBER(30)	NOT NULL
	,WDWU_NAME	VARCHAR2(100)	    NULL
	,WDWU_WDWI_ID	NUMBER(30)	NOT NULL
	,WDWU_TOP	NUMBER(30)	NOT NULL
	,WDWU_LEFT	NUMBER(30)	NOT NULL
	,WDWU_HEIGHT	NUMBER(30)	NOT NULL
	,WDWU_WIDTH	NUMBER(30)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WDWU ADD (
	CONSTRAINT WDWU_PK
	PRIMARY KEY
	            (
	             WDWU_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WDWU_WDWI_ID ON WDWU
	(
	  WDWU_WDWI_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX WDWU_XCED_ID ON WDWU
	(
	  WDWU_XCED_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WERS  */
CREATE TABLE WERS (
	 WERS_ID	NUMBER(30)	NOT NULL
	,WERS_TEXT	VARCHAR2(60)	NOT NULL
	,WERS_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WERS ADD (
	CONSTRAINT WERS_PK
	PRIMARY KEY
	            (
	             WERS_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
ALTER TABLE WERS ADD (
	CONSTRAINT WERS_TEXT
	UNIQUE
	       (
	        WERS_TEXT
	       )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WERS_DISPLORDER ON WERS
	(
	  WERS_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WLOR  */
CREATE TABLE WLOR (
	 WLOR_ID	NUMBER(30)	NOT NULL
	,WLOR_WLOP_ID	NUMBER(30)	NOT NULL
	,WLOR_YRES_ID	NUMBER(30)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WLOR ADD (
	CONSTRAINT WLOR_PK
	PRIMARY KEY
	            (
	             WLOR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WLOR_WLOP_ID ON WLOR
	(
	  WLOR_WLOP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX WLOR_YRES_ID ON WLOR
	(
	  WLOR_YRES_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WNAR  */
CREATE TABLE WNAR (
	 WNAR_ID	NUMBER(30)	NOT NULL
	,WNAR_WRPT_ID	NUMBER(30)	NOT NULL
	,WNAR_TIMESTAMP	DATE	NOT NULL
	,WNAR_SYSDATE	DATE	NOT NULL
	,WNAR_REPORT	LONG RAW	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8LARGE
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WNAR ADD (
	CONSTRAINT WNAR_PK
	PRIMARY KEY
	            (
	             WNAR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WNAR_WRPT_ID ON WNAR
	(
	  WNAR_WRPT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  WOIP  */
CREATE TABLE WOIP (
	 WOIP_ID	NUMBER(30)	NOT NULL
	,WOIP_SOURCETABLENAME	VARCHAR2(20)	NOT NULL
	,WOIP_SOURCEID	NUMBER(30)	NOT NULL
	,WOIP_STATUS	NUMBER(1)	NOT NULL
	,WOIP_LASTSTATUSCHANGE	DATE	NOT NULL
	,WOIP_TAG	VARCHAR2(30)	NOT NULL
	,WOIP_DESCRIPTION	VARCHAR2(500)	NOT NULL
	,WOIP_COMMENT	VARCHAR2(200)	    NULL
	,WOIP_ERRORLOG	VARCHAR2(2000)	    NULL
	,WOIP_V8ID	NUMBER(30)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WOIP ADD (
	CONSTRAINT WOIP_PK
	PRIMARY KEY
	            (
	             WOIP_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  WSFS  */
CREATE TABLE WSFS (
	 WSFS_ID	NUMBER(30)	NOT NULL
	,WSFS_TABLE_NAME	VARCHAR2(4)	NOT NULL
	,WSFS_TABLE_ID	NUMBER(30)	NOT NULL
	,WSFS_SYNC_DATE	DATE	    NULL
	,WSFS_SF_ID	VARCHAR2(30)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE WSFS ADD (
	CONSTRAINT WSFS_PK
	PRIMARY KEY
	            (
	             WSFS_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX WSFS_SF_ID ON WSFS
	(
	  WSFS_SF_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX WSFS_TABLE_ID ON WSFS
	(
	  WSFS_TABLE_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  XOPC  */
CREATE TABLE XOPC (
	 XOPC_ID	NUMBER(30)	NOT NULL
	,XOPC_SHORTDESC	VARCHAR2(3)	    NULL
	,XOPC_LONGDESC	VARCHAR2(30)	NOT NULL
	,XOPC_SF_ID	VARCHAR2(30)	    NULL
	,XOPC_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE XOPC ADD (
	CONSTRAINT XOPC_PK
	PRIMARY KEY
	            (
	             XOPC_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX XOPC_DISPLORDER ON XOPC
	(
	  XOPC_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX XOPC_SF_ID ON XOPC
	(
	  XOPC_SF_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  XOPD  */
CREATE TABLE XOPD (
	 XOPD_ID	NUMBER(30)	NOT NULL
	,XOPD_SHORTDESC	VARCHAR2(3)	    NULL
	,XOPD_LONGDESC	VARCHAR2(30)	NOT NULL
	,XOPD_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE XOPD ADD (
	CONSTRAINT XOPD_PK
	PRIMARY KEY
	            (
	             XOPD_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX XOPD_DISPLORDER ON XOPD
	(
	  XOPD_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  XOPL  */
CREATE TABLE XOPL (
	 XOPL_ID	NUMBER(30)	NOT NULL
	,XOPL_SHORTDESC	VARCHAR2(3)	    NULL
	,XOPL_LONGDESC	VARCHAR2(30)	NOT NULL
	,XOPL_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE XOPL ADD (
	CONSTRAINT XOPL_PK
	PRIMARY KEY
	            (
	             XOPL_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX XOPL_DISPLORDER ON XOPL
	(
	  XOPL_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  XOPS  */
CREATE TABLE XOPS (
	 XOPS_ID	NUMBER(30)	NOT NULL
	,XOPS_SHORTDESC	VARCHAR2(3)	    NULL
	,XOPS_LONGDESC	VARCHAR2(30)	NOT NULL
	,XOPS_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE XOPS ADD (
	CONSTRAINT XOPS_PK
	PRIMARY KEY
	            (
	             XOPS_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX XOPS_DISPLORDER ON XOPS
	(
	  XOPS_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  XOPT  */
CREATE TABLE XOPT (
	 XOPT_ID	NUMBER(30)	NOT NULL
	,XOPT_SHORTDESC	VARCHAR2(3)	    NULL
	,XOPT_LONGDESC	VARCHAR2(30)	NOT NULL
	,XOPT_CLOSEDAYS	NUMBER(3)	    NULL
	,XOPT_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE XOPT ADD (
	CONSTRAINT XOPT_PK
	PRIMARY KEY
	            (
	             XOPT_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX XOPT_DISPLORDER ON XOPT
	(
	  XOPT_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  XPHN  */
CREATE TABLE XPHN (
	 XPHN_ID	NUMBER(30)	NOT NULL
	,XPHN_XCMS_ID	NUMBER(30)	NOT NULL
	,XPHN_PHONENUMBER	VARCHAR2(30)	NOT NULL
	,XPHN_CALLTIME	DATE	    NULL
	,XPHN_INCOMING	NUMBER(1)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE XPHN ADD (
	CONSTRAINT XPHN_PK
	PRIMARY KEY
	            (
	             XPHN_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX XPHN_XCMS_ID ON XPHN
	(
	  XPHN_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YBLW  */
CREATE TABLE YBLW (
	 YBLW_ID	NUMBER(30)	NOT NULL
	,YBLW_YBLH_ID	NUMBER(30)	NOT NULL
	,YBLW_XCMS_ID	NUMBER(30)	NOT NULL
	,YBLW_STARTDATE	DATE	    NULL
	,YBLW_ENDDATE	DATE	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YBLW ADD (
	CONSTRAINT YBLW_PK
	PRIMARY KEY
	            (
	             YBLW_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YBLW_XCMS_ID ON YBLW
	(
	  YBLW_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YBLW_YBLH_ID ON YBLW
	(
	  YBLW_YBLH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YCRL  */
CREATE TABLE YCRL (
	 YCRL_ID	NUMBER(30)	NOT NULL
	,YCRL_YRMS_ID	NUMBER(30)	NOT NULL
	,YCRL_DAY	DATE	NOT NULL
	,YCRL_TIMESTAMP	DATE	NOT NULL
	,YCRL_ORIGIN	NUMBER(1)	NOT NULL
	,YCRL_RESGLOBALID	VARCHAR2(60)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YCRL ADD (
	CONSTRAINT YCRL_PK
	PRIMARY KEY
	            (
	             YCRL_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
ALTER TABLE YCRL ADD (
	CONSTRAINT YCRL_LOCK
	UNIQUE
	       (
	        YCRL_YRMS_ID
	       ,YCRL_DAY
	       )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YCRL_TIMESTAMP ON YCRL
	(
	  YCRL_TIMESTAMP
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YCRL_YRMS_ID ON YCRL
	(
	  YCRL_YRMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YCRS  */
CREATE TABLE YCRS (
	 YCRS_TABLEID	NUMBER(30)	NOT NULL
	,YCRS_TABLENAME	VARCHAR2(4)	NOT NULL
	,YCRS_GLOBALID	VARCHAR2(60)	    NULL
	,YCRS_OWNED	NUMBER(1)	NOT NULL
	,YCRS_LOCALTIMESTAMP	DATE	    NULL
	,YCRS_LOCALHASH	VARCHAR2(32)	    NULL
	,YCRS_HASHMISMATCH	DATE	    NULL
	,YCRS_TRANSFERERROR	DATE	    NULL
	,YCRS_ERRORTEXT	VARCHAR2(1000)	    NULL
	,YCRS_MODIFIEDWITHOUTOWNED	NUMBER(1)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YCRS ADD (
	CONSTRAINT YCRS_PK
	PRIMARY KEY
	            (
	             YCRS_TABLEID
	            ,YCRS_TABLENAME
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  YHRI  */
CREATE TABLE YHRI (
	 YHRI_ID	NUMBER(30)	NOT NULL
	,YHRI_ARRDATE	DATE	NOT NULL
	,YHRI_MAXSOLD	NUMBER(10)	NOT NULL
	,YHRI_ROOMSOLD	NUMBER(10)	    NULL
	,YHRI_CEILING	NUMBER(10)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YHRI ADD (
	CONSTRAINT YHRI_PK
	PRIMARY KEY
	            (
	             YHRI_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  YOPF  */
CREATE TABLE YOPF (
	 YOPF_ID	NUMBER(30)	NOT NULL
	,YOPF_YSFT_ID	NUMBER(30)	NOT NULL
	,YOPF_XOPP_ID	NUMBER(30)	NOT NULL
	,YOPF_FROMDATE	DATE	NOT NULL
	,YOPF_TODATE	DATE	NOT NULL
	,YOPF_NOOFFS	NUMBER(3)	NOT NULL
	,YOPF_PAX	NUMBER(3)	NOT NULL
	,YOPF_COFFEE	NUMBER(1)	    NULL
	,YOPF_LUNCH	NUMBER(1)	    NULL
	,YOPF_DINNER	NUMBER(1)	    NULL
	,YOPF_NOTES	VARCHAR2(1000)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YOPF ADD (
	CONSTRAINT YOPF_PK
	PRIMARY KEY
	            (
	             YOPF_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YOPF_XOPP_ID ON YOPF
	(
	  YOPF_XOPP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YOPF_YSFT_ID ON YOPF
	(
	  YOPF_YSFT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YOPR  */
CREATE TABLE YOPR (
	 YOPR_ID	NUMBER(30)	NOT NULL
	,YOPR_YSRC_ID	NUMBER(30)	NOT NULL
	,YOPR_XOPP_ID	NUMBER(30)	NOT NULL
	,YOPR_FROMDATE	DATE	NOT NULL
	,YOPR_TODATE	DATE	NOT NULL
	,YOPR_NOOFROOMS	NUMBER(3)	NOT NULL
	,YOPR_PAX	NUMBER(3)	NOT NULL
	,YOPR_NOTES	VARCHAR2(1000)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YOPR ADD (
	CONSTRAINT YOPR_PK
	PRIMARY KEY
	            (
	             YOPR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YOPR_XOPP_ID ON YOPR
	(
	  YOPR_XOPP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YOPR_YSRC_ID ON YOPR
	(
	  YOPR_YSRC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YRAA  */
CREATE TABLE YRAA (
	 YRAA_ID	NUMBER(30)	NOT NULL
	,YRAA_YDET_ID	NUMBER(30)	NOT NULL
	,YRAA_AGE	NUMBER(3)	NOT NULL
	,YRAA_NUMBER	NUMBER(3)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRAA ADD (
	CONSTRAINT YRAA_PK
	PRIMARY KEY
	            (
	             YRAA_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YRAA_YDET_ID ON YRAA
	(
	  YRAA_YDET_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YRDB  */
CREATE TABLE YRDB (
	 YRDB_ID	NUMBER(30)	NOT NULL
	,YRDB_DISPLORDER	NUMBER(5)	NOT NULL
	,YRDB_TYPE	NUMBER(2)	NOT NULL
	,YRDB_VALUE	NUMBER(5)	NOT NULL
	,YRDB_YRDT_ID	NUMBER(30)	NOT NULL
	,YRDB_MINDAYS	NUMBER(5)	    NULL
	,YRDB_MAXDAYS	NUMBER(5)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRDB ADD (
	CONSTRAINT YRDB_PK
	PRIMARY KEY
	            (
	             YRDB_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YRDB_DISPLORDER ON YRDB
	(
	  YRDB_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRDB_YRDT_ID ON YRDB
	(
	  YRDB_YRDT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YRDL  */
CREATE TABLE YRDL (
	 YRDL_DATE	DATE	NOT NULL
	,YRDL_CREATIONDATE	DATE	NOT NULL
	,YRDL_REASON	VARCHAR2(2000)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRDL ADD (
	CONSTRAINT YRDL_PK
	PRIMARY KEY
	            (
	             YRDL_DATE
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;

/*  YRDU  */
CREATE TABLE YRDU (
	 YRDU_ID	NUMBER(30)	NOT NULL
	,YRDU_FIDELIODATE	DATE	NOT NULL
	,YRDU_PCDATE	DATE	NOT NULL
	,YRDU_YRDC_FOR_DATE	DATE	NOT NULL
	,YRDU_YRDC_OLD_DATE	DATE	    NULL
	,YRDU_YRDT_ID	NUMBER(30)	NOT NULL
	,YRDU_OLD_YRDT_ID	NUMBER(30)	    NULL
	,YRDU_TYPE	NUMBER(1) DEFAULT 0 	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRDU ADD (
	CONSTRAINT YRDU_PK
	PRIMARY KEY
	            (
	             YRDU_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YRDU_OLD_YRDT_ID ON YRDU
	(
	  YRDU_OLD_YRDT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRDU_YRDT_ID ON YRDU
	(
	  YRDU_YRDT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YRLH  */
CREATE TABLE YRLH (
	 YRLH_ID	NUMBER(30)	NOT NULL
	,YRLH_YRCH_ID	NUMBER(30)	    NULL
	,YRLH_LINK_YRCH_ID	NUMBER(30)	    NULL
	,YRLH_LINKTYPE	NUMBER(1)	    NULL
	,YRLH_VALUE	NUMBER(30,4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRLH ADD (
	CONSTRAINT YRLH_PK
	PRIMARY KEY
	            (
	             YRLH_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YRLH_LINK_YRCH_ID ON YRLH
	(
	  YRLH_LINK_YRCH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRLH_YRCH_ID ON YRLH
	(
	  YRLH_YRCH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YRSL  */
CREATE TABLE YRSL (
	 YRSL_ID	NUMBER(30)	NOT NULL
	,YRSL_YSRC_ID	NUMBER(30)	NOT NULL
	,YRSL_YCAT_ID	NUMBER(30)	NOT NULL
	,YRSL_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YRSL ADD (
	CONSTRAINT YRSL_PK
	PRIMARY KEY
	            (
	             YRSL_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YRSL_DISPLORDER ON YRSL
	(
	  YRSL_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRSL_YCAT_ID ON YRSL
	(
	  YRSL_YCAT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YRSL_YSRC_ID ON YRSL
	(
	  YRSL_YSRC_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YSFL  */
CREATE TABLE YSFL (
	 YSFL_ID	NUMBER(30)	NOT NULL
	,YSFL_YSTY_ID	NUMBER(30)	NOT NULL
	,YSFL_YSFT_ID	NUMBER(30)	NOT NULL
	,YSFL_DISPLORDER	NUMBER(3)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YSFL ADD (
	CONSTRAINT YSFL_PK
	PRIMARY KEY
	            (
	             YSFL_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YSFL_DISPLORDER ON YSFL
	(
	  YSFL_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YSFL_YSFT_ID ON YSFL
	(
	  YSFL_YSFT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YSFL_YSTY_ID ON YSFL
	(
	  YSFL_YSTY_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YSFT  */
CREATE TABLE YSFT (
	 YSFT_ID	NUMBER(30)	NOT NULL
	,YSFT_SHORTDESC	VARCHAR2(5)	NOT NULL
	,YSFT_LONGDESC	VARCHAR2(30)	NOT NULL
	,YSFT_DISPLORDER	NUMBER(3)	NOT NULL
	,YSFT_INACTIVE	NUMBER(1)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YSFT ADD (
	CONSTRAINT YSFT_PK
	PRIMARY KEY
	            (
	             YSFT_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YSFT_DISPLORDER ON YSFT
	(
	  YSFT_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YSRC  */
CREATE TABLE YSRC (
	 YSRC_ID	NUMBER(30)	NOT NULL
	,YSRC_SHORTDESC	VARCHAR2(5)	NOT NULL
	,YSRC_LONGDESC	VARCHAR2(30)	NOT NULL
	,YSRC_DISPLORDER	NUMBER(3)	NOT NULL
	,YSRC_INACTIVE	NUMBER(1)	    NULL
	,YSRC_SHORTWEBINFO	VARCHAR2(1000)	    NULL
	,YSRC_LONGWEBINFO	VARCHAR2(2000)	    NULL
	,YSRC_MD_LONGWEBINFO	VARCHAR2(2000)	    NULL
	,YSRC_MD_SHORTWEBINFO	VARCHAR2(1000)	    NULL
	,YSRC_EXTENDEDWEBINFO	VARCHAR2(2000)	    NULL
	,YSRC_MD_EXTENDEDWEBINFO	VARCHAR2(2000)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8CONF
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YSRC ADD (
	CONSTRAINT YSRC_PK
	PRIMARY KEY
	            (
	             YSRC_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YSRC_DISPLORDER ON YSRC
	(
	  YSRC_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YTRR  */
CREATE TABLE YTRR (
	 YTRR_ID	NUMBER(30)	NOT NULL
	,YTRR_CALCDATE	DATE	    NULL
	,YTRR_CALCFORDATE	DATE	    NULL
	,YTRR_YRES_ID	NUMBER(30)	    NULL
	,YTRR_YDET_ID	NUMBER(30)	    NULL
	,YTRR_YBLH_ID	NUMBER(30)	    NULL
	,YTRR_YGRP_ID	NUMBER(30)	    NULL
	,YTRR_XCMA_ID	NUMBER(30)	    NULL
	,YTRR_YCAT_ID	NUMBER(30)	    NULL
	,YTRR_GROSS_TOTAL	NUMBER(30,4)	    NULL
	,YTRR_NET_TOTAL	NUMBER(30,4)	    NULL
	,YTRR_GROSS_ROOM	NUMBER(30,4)	    NULL
	,YTRR_NET_ROOM	NUMBER(30,4)	    NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE YTRR ADD (
	CONSTRAINT YTRR_PK
	PRIMARY KEY
	            (
	             YTRR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX YTRRDATES ON YTRR
	(
	  YTRR_CALCDATE
	 ,YTRR_CALCFORDATE
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_CALCDATE ON YTRR
	(
	  YTRR_CALCDATE
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_CALCFORDATE ON YTRR
	(
	  YTRR_CALCFORDATE
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_XCMA_ID ON YTRR
	(
	  YTRR_XCMA_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_YBLH_ID ON YTRR
	(
	  YTRR_YBLH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_YCAT_ID ON YTRR
	(
	  YTRR_YCAT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_YDET_ID ON YTRR
	(
	  YTRR_YDET_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_YGRP_ID ON YTRR
	(
	  YTRR_YGRP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX YTRR_YRES_ID ON YTRR
	(
	  YTRR_YRES_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  ZCNR  */
CREATE TABLE ZCNR (
	 ZCNR_ID	NUMBER(30)	NOT NULL
	,ZCNR_RANGE_START	VARCHAR2(40)	NOT NULL
	,ZCNR_RANGE_END	VARCHAR2(40)	NOT NULL
	,ZCNR_ZCCS_ID	NUMBER(30)	NOT NULL
)
PCTFREE  10
PCTUSED  40
INITRANS 1
MAXTRANS 255
TABLESPACE V8MAIN
    STORAGE (
	INITIAL 64K
	NEXT 64K
	MINEXTENTS 1
	MAXEXTENTS 2147483645
	PCTINCREASE 50
	FREELISTS 1 FREELIST GROUPS 1
        )
;

ALTER TABLE ZCNR ADD (
	CONSTRAINT ZCNR_PK
	PRIMARY KEY
	            (
	             ZCNR_ID
	            )
	USING INDEX
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
)
;
CREATE INDEX ZCNR_ZCCS_ID ON ZCNR
	(
	  ZCNR_ZCCS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;

/*  YRFR  */
CREATE TABLE YRFR (
    YRFR_ID NUMBER(30) NOT NULL
   ,YRFR_DATE DATE NOT NULL
   ,YRFR_XCED_ID NUMBER(30) NOT NULL
   ,CONSTRAINT YRFR_PK PRIMARY KEY (YRFR_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  XOPP  */
CREATE TABLE XOPP (
   XOPP_ID NUMBER(30) NOT NULL
  ,XOPP_OWNER_XCED_ID NUMBER(30)
  ,XOPP_ACCOUNT_XCMS_ID NUMBER(30)
  ,XOPP_NAME VARCHAR2(120) 
  ,XOPP_DESCRIPTION VARCHAR2(1000)
  ,XOPP_XOPS_ID NUMBER(30)
  ,XOPP_AMOUNT NUMBER(30, 4)
  ,XOPP_PROBABILITY NUMBER(3)
  ,XOPP_EXPECTEDREVENUE NUMBER(30, 4)
  ,XOPP_TOTALOPPORTUNITYQUANTITY NUMBER(30, 4)  
  ,XOPP_CLOSEDATE DATE  
  ,XOPP_XOPT_ID NUMBER(30)
  ,XOPP_XOPL_ID NUMBER(30)
  ,XOPP_ISCLOSED NUMBER(1)  
  ,XOPP_ISWON NUMBER(1)  
  ,XOPP_XOPC_ID NUMBER(30)  
  ,XOPP_HASOPPORTUNITYLINEITEM NUMBER(1)  
  ,XOPP_FISCALQUARTER NUMBER(1)  
  ,XOPP_FISCALYEAR NUMBER(4)  
  ,XOPP_XOPD_ID NUMBER(30)  
  ,XOPP_TRACKINGNUMBER VARCHAR(30)  
  ,XOPP_ORDERNUMBER VARCHAR(30) 
  ,XOPP_CURRENTGENERATOR VARCHAR(100) 
  ,XOPP_MAINCOMPETITOR VARCHAR(100) 
  ,XOPP_THIRD_PARTY_ID VARCHAR(30) 
  ,XOPP_SF_LASTMODIFIED_DATE DATE
  ,XOPP_INACTIVE_REASON VARCHAR2(100)
  ,XOPP_NEXTSTEP VARCHAR2(255)
  ,XOPP_PRIVATE NUMBER(1)
  ,XOPP_INACTIVE NUMBER(1)
  ,CONSTRAINT XOPP_PK PRIMARY KEY (XOPP_ID) USING INDEX TABLESPACE V8INDEX
) TABLESPACE V8MAIN;

/*  XCNL  */
CREATE TABLE XCNL (
    XCNL_ID NUMBER(30) NOT NULL
   ,XCNL_XCNC_ID NUMBER(30) NOT NULL
   ,XCNL_WHDE_ID NUMBER(30) NOT NULL
   ,CONSTRAINT XCNL_PK PRIMARY KEY (XCNL_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  WDEC  */
CREATE TABLE WDEC (
  WDEC_ID           NUMBER(30)                  NOT NULL,
  WDEC_REPORT_ROLE  NUMBER(2)                   NOT NULL,
  WDEC_WRPT_ID      NUMBER(30)                  NOT NULL
  ,CONSTRAINT WDEC_PK PRIMARY KEY (WDEC_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  XSST  */   
CREATE TABLE XSST
(
  XSST_ID          NUMBER(30)                   NOT NULL,
  XSST_SHORTDESC   VARCHAR2(3 BYTE)             NOT NULL,
  XSST_LONGDESC    VARCHAR2(30 BYTE)            NOT NULL,
  XSST_DISPLORDER  NUMBER(3)                        NULL,
  XSST_GVMNT_ID    NUMBER(30)                       NULL
  ,CONSTRAINT XSST_PK PRIMARY KEY (XSST_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;
   
/*  FPLI  */   
CREATE TABLE FPLI
(
  FPLI_ID          NUMBER(30)                   NOT NULL,
  FPLI_FPLD_ID     NUMBER(30)                   NOT NULL,
  FPLI_YOUT_ID     NUMBER(30),
  FPLI_YCMI_ID     NUMBER(30),
  FPLI_PRICE       NUMBER(30,4),
  FPLI_EXCLUDE     NUMBER(1),
  FPLI_FLEX        NUMBER(1)                    NOT NULL,
  constraint fpli_pk primary key (fpli_id) using index tablespace v8index
)
TABLESPACE V8CONF;

/*  WRPX  */   
CREATE TABLE WRPX (
    WRPX_ID NUMBER(30) NOT NULL
   ,WRPX_SEARCHTYPE NUMBER(1) NOT NULL
   ,WRPX_INTERNALCATEGORY NUMBER(1) 
   ,WRPX_RESSTATUS NUMBER(1) 
   ,CONSTRAINT WRPX_PK PRIMARY KEY (WRPX_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  WFMS  */   
CREATE TABLE WFMS (
    WFMS_ID NUMBER(30) NOT NULL
   ,WFMS_WFMC_ID NUMBER(30) NOT NULL
   ,WFMS_SCRIPT LONG
   ,CONSTRAINT WFMS_PK PRIMARY KEY (WFMS_ID) USING INDEX TABLESPACE V8INDEX
) TABLESPACE V8MAIN;
   
/*  WAMT  */   
CREATE TABLE WAMT
(
  WAMT_ID NUMBER(30) NOT NULL
  ,WAMT_WATY_ID NUMBER(30)
  ,WAMT_PLACE_TYPE NUMBER(1)
  ,WAMT_XCED_ID NUMBER(30)
  ,WAMT_NOTES VARCHAR2(2000)
  ,WAMT_INACTIVE NUMBER(1)
  ,WAMT_CONDITION VARCHAR2(2000)
  ,CONSTRAINT WAMT_PK PRIMARY KEY (WAMT_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  YOPL  */     
CREATE TABLE YOPL (
YOPL_ID NUMBER(30) NOT NULL
,YOPL_YOPF_ID NUMBER(30) NOT NULL
,YOPL_YEVM_ID NUMBER(30) NOT NULL
,CONSTRAINT YOPL_PK PRIMARY KEY (YOPL_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  XCHS  */     
CREATE TABLE XCHS (
 XCHS_ID NUMBER(30) NOT NULL
,XCHS_XCMS_ID NUMBER(30) NOT NULL
,XCHS_WPHS_ID NUMBER(30) NOT NULL
,XCHS_INSERT_DATE DATE
,XCHS_LASTUPDATE_DATE DATE
,CONSTRAINT XCHS_PK PRIMARY KEY (XCHS_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  XMTL  */     
CREATE TABLE XMTL (
     XMTL_ID NUMBER(30) NOT NULL
    ,XMTL_XMTY_ID NUMBER(30) NOT NULL
    ,XMTL_LEVEL NUMBER(1) NOT NULL
    ,XMTL_SHORTDESC VARCHAR2(5) NOT NULL 
    ,XMTL_LONGDESC VARCHAR2(30) NOT NULL
    ,XMTL_POINTLIMIT NUMBER(30)
    ,CONSTRAINT XMTL_PK PRIMARY KEY (XMTL_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  ZBCF  */     	
	CREATE TABLE ZBCF (
   ZBCF_ID NUMBER(30) NOT NULL
  ,ZBCF_XMTY_ID NUMBER(30) NOT NULL
  ,ZBCF_STAYPERADULT NUMBER(1) NOT NULL
  ,ZBCF_FIRSTSTAYPERADULT NUMBER(1) NOT NULL
  ,ZBCF_NIGHTPERADULT NUMBER(1) NOT NULL
  ,ZBCF_RATECODESTAYPERADULT NUMBER(1) NOT NULL
  ,ZBCF_RATECODEFIRSTSTAYPERADULT NUMBER(1) NOT NULL
  ,ZBCF_RATECODENIGHTPERADULT NUMBER(1) NOT NULL
  ,ZBCF_ROOMTYPESTAYPERADULT NUMBER(1) NOT NULL
  ,ZBCF_ROOMTYPEFIRSTSTAYPERADULT NUMBER(1) NOT NULL
  ,ZBCF_ROOMTYPENIGHTPERADULT NUMBER(1) NOT NULL
,CONSTRAINT ZBCF_PK PRIMARY KEY (ZBCF_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  ZBPC  */     	  
CREATE TABLE ZBPC (
   ZBPC_ID         NUMBER(30) NOT NULL
  ,ZBPC_XMTY_ID    NUMBER(30) NOT NULL
  ,ZBPC_XMTL_ID    NUMBER(30) 
  ,ZBPC_ZDCO_ID    NUMBER(30) 
  ,ZBPC_CARDROLE   NUMBER(1) NOT NULL
  ,ZBPC_TYPE       NUMBER(1) NOT NULL
  ,ZBPC_VALUE      NUMBER(30,4) NOT NULL  
  ,CONSTRAINT ZBPC_PK PRIMARY KEY (ZBPC_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  ZBPD  */     	    
CREATE TABLE ZBPD (
   ZBPD_ID         NUMBER(30) NOT NULL
  ,ZBPD_XMTY_ID    NUMBER(30) NOT NULL
  ,ZBPD_XMTL_ID    NUMBER(30)
  ,ZBPD_CARDROLE   NUMBER(1) NOT NULL
  ,ZBPD_ZDCO_ID    NUMBER(30)
  ,ZBPD_VALUE      NUMBER(20)
  ,ZBPD_FLATVALUE  NUMBER(20)  
  ,CONSTRAINT ZBPD_PK PRIMARY KEY (ZBPD_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  ZBPX  */     	    
CREATE TABLE ZBPX (
   ZBPX_ID         NUMBER(30) NOT NULL
  ,ZBPX_XMTY_ID    NUMBER(30) NOT NULL
  ,ZBPX_XMTL_ID    NUMBER(30)
  ,ZBPX_CARDROLE   NUMBER(1) NOT NULL
  ,ZBPX_YRCH_ID    NUMBER(30)
  ,ZBPX_YCAT_ID    NUMBER(30)
  ,ZBPX_PERSTAY    NUMBER(20)
  ,ZBPX_PERNIGHT   NUMBER(20)
  ,ZBPX_FIRSTSTAY  NUMBER(20)
  ,CONSTRAINT ZBPX_PK PRIMARY KEY (ZBPX_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  ZBPS  */     	    
  CREATE TABLE ZBPS (
   ZBPS_ID         NUMBER(30) NOT NULL
  ,ZBPS_XMNR_ID    NUMBER(30) NOT NULL
  ,ZBPS_VALUE      NUMBER(30) NOT NULL
  ,ZBPS_TIMESTAMP  DATE NOT NULL
  ,ZBPS_MANUAL     NUMBER(1) NOT NULL
  ,ZBPS_YRES_ID    NUMBER(30)
  ,ZBPS_XCED_ID    NUMBER(30) NOT NULL
  ,ZBPS_CARDROLE   NUMBER(1)
  ,ZBPS_EXPIRY     DATE
  ,ZBPS_CONSUMED   NUMBER(30) NOT NULL
  ,ZBPS_TYPE       NUMBER(1)
  ,ZBPS_WPHS_ID    NUMBER(30)
  ,ZBPS_UPLOADSTATUS NUMBER(1) 
  ,ZBPS_UPLOADTIMESTAMP DATE
  ,ZBPS_ARRIVAL    DATE 
  ,ZBPS_DEPARTURE  DATE 
  ,ZBPS_ZBPP_ID    NUMBER(30)
  ,ZBPS_QUANTITY   NUMBER(3)
  ,ZBPS_COMMENT    VARCHAR2(200)
  ,ZBPS_TRANSFERFROM_XMNR_ID NUMBER(30)
  ,CONSTRAINT ZBPS_PK PRIMARY KEY (ZBPS_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  ZBPP  */     	    
CREATE TABLE ZBPP (
   ZBPP_ID        NUMBER(30) NOT NULL
  ,ZBPP_SHORTDESC VARCHAR2(5) NOT NULL
  ,ZBPP_LONGDESC  VARCHAR2(60) NOT NULL
  ,ZBPP_PRICE     NUMBER(30) NOT NULL
  ,ZBPP_ONSTOCK   NUMBER(30)
  ,ZBPP_INACTIVE  NUMBER(30)
  ,ZBPP_CHECKAVL  NUMBER(1) NOT NULL 
  ,ZBPP_TYPE      NUMBER(1) NOT NULL
  ,CONSTRAINT ZBPP_PK PRIMARY KEY (ZBPP_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  ZBPR  */     	      
CREATE TABLE ZBPR (
   ZBPR_ID         NUMBER(30) NOT NULL
  ,ZBPR_XMNR_ID    NUMBER(30) NOT NULL
  ,ZBPR_VALUE      NUMBER(30) NOT NULL
  ,ZBPR_TIMESTAMP  DATE NOT NULL
  ,ZBPR_MANUAL     NUMBER(1) NOT NULL
  ,ZBPR_XCED_ID    NUMBER(30) NOT NULL
  ,ZBPR_ZPOS_ID    NUMBER(30)
  ,ZBPR_ZBPP_ID    NUMBER(30)
  ,ZBPR_QUANTITY   NUMBER(3)   
  ,ZBPR_WPHS_ID    NUMBER(30) 
  ,ZBPR_COMMENT    VARCHAR2(200)
  ,ZBPR_TRANSFERTO_XMNR_ID NUMBER(30)
  ,CONSTRAINT ZBPR_PK PRIMARY KEY (ZBPR_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  ZBST  */     	      
CREATE TABLE ZBST (
   ZBST_ID NUMBER(30) NOT NULL
  ,ZBST_XMNR_ID NUMBER(30) NOT NULL
  ,ZBST_TIMESTAMP DATE NOT NULL
  ,ZBST_BALANCE NUMBER(15) NOT NULL
  ,ZBST_STATEMENTNUMBER NUMBER(15) NOT NULL
  ,ZBST_LAST_ZBPS_ID NUMBER(30)
  ,ZBST_WTXT_ID NUMBER(30)
  ,ZBST_WRPT_ID NUMBER(30)
  ,ZBST_DELIVERYMETHOD NUMBER(1)
  ,ZBST_PREV_ZBST_ID NUMBER(30)
  ,ZBST_WMAI_ID NUMBER(30)
  ,CONSTRAINT ZBST_PK PRIMARY KEY (ZBST_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  MIMP  */     	        
 CREATE TABLE MIMP
(
  MIMP_ID        NUMBER(30)                     NOT NULL,
  MIMP_MMOD_ID   NUMBER(30)                     NOT NULL,
  MIMP_RECEIVED  DATE                           NOT NULL,
  MIMP_FILENAME  VARCHAR2(50 BYTE)              NOT NULL,
  MIMP_MSG_LINE  VARCHAR2(3000 BYTE),
  CONSTRAINT MIMP_PK PRIMARY KEY (MIMP_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  ZINS  */     	         
CREATE TABLE ZINS (
    ZINS_ID NUMBER(30) NOT NULL
   ,ZINS_ZINV_ID NUMBER(30) NULL
   ,ZINS_ZINN_ID NUMBER(30) 
   ,ZINS_NUMBER VARCHAR2(60) 
   ,ZINS_AMOUNT NUMBER(30, 4) 
   ,ZINS_SIGNATURE VARCHAR2(172) NOT NULL
   ,ZINS_KEYVERSION NUMBER(1) NOT NULL
   ,CONSTRAINT ZINS_PK PRIMARY KEY (ZINS_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  YFSP  */     	         
   CREATE TABLE YFSP
(
    YFSP_ID NUMBER(30) NOT NULL,
    YFSP_DISPLAY NUMBER(3),
    YFSP_FLOOR VARCHAR2(3) NOT NULL,
    YFSP_FLOORNAME VARCHAR2(30),
    YFSP_PICTURE LONG RAW,
    YFSP_PICTURE_C VARCHAR2(2000),
    YFSP_SHORTDESC VARCHAR2(3),
    CONSTRAINT YFSP_PK PRIMARY KEY (YFSP_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8LARGE;

/*  SRP2  */     	         
CREATE TABLE SRP2
(
  SRP2_ID                NUMBER(30)             NOT NULL,
  SRP2_DATE              DATE                   NOT NULL,
  SRP2_ZDCO_ID           NUMBER(30)             NOT NULL,
  SRP2_NETREV_D          NUMBER(30,4)               NULL,
  SRP2_GROSSREV_D        NUMBER(30,4)               NULL,
  SRP2_NETREV_M          NUMBER(30,4)               NULL,
  SRP2_GROSSREV_M        NUMBER(30,4)               NULL,
  SRP2_NETREV_Y          NUMBER(30,4)               NULL,
  SRP2_GROSSREV_Y        NUMBER(30,4)               NULL,
  SRP2_PARTNER_ID        NUMBER(30)                 NULL,
  SRP2_IMPORTED          NUMBER(1)                  NULL,
  SRP2_WPHS_ID           NUMBER(30)                 NULL,
  SRP2_ZDCO_LONGDESC     VARCHAR2(30 BYTE)          NULL,
  SRP2_ZDCO_NUMERICDESC  NUMBER(5)                  NULL,
  SRP2_ZDCG_LONGDESC     VARCHAR2(30 BYTE)          NULL,
  SRP2_ZDCO_CDT          NUMBER(1)                  NULL,
  SRP2_TYPE              NUMBER(30)             DEFAULT 0                         NULL
) TABLESPACE V8MAIN ; 

ALTER TABLE SRP2 ADD CONSTRAINT SRP2_PK PRIMARY KEY (SRP2_ID) USING INDEX TABLESPACE V8INDEX;

/*  SRD2  */     	         
CREATE TABLE SRD2
(
  SRD2_ID                NUMBER(30)             NOT NULL,
  SRD2_DATE              DATE                   NOT NULL,
  SRD2_ZDCO_ID           NUMBER(30)             NOT NULL,
  SRD2_YCAD_ID           NUMBER(30)             NOT NULL,
  SRD2_NETREV_D          NUMBER(30,4)               NULL,
  SRD2_GROSSREV_D        NUMBER(30,4)               NULL,
  SRD2_NETREV_M          NUMBER(30,4)               NULL,
  SRD2_GROSSREV_M        NUMBER(30,4)               NULL,
  SRD2_NETREV_Y          NUMBER(30,4)               NULL,
  SRD2_GROSSREV_Y        NUMBER(30,4)               NULL,
  SRD2_PARTNER_ID        NUMBER(30)                 NULL,
  SRD2_IMPORTED          NUMBER(1)                  NULL,
  SRD2_WPHS_ID           NUMBER(30)                 NULL,
  SRD2_ZDCO_LONGDESC     VARCHAR2(30 BYTE)          NULL,
  SRD2_ZDCO_NUMERICDESC  NUMBER(5)                  NULL,
  SRD2_ZDCG_LONGDESC     VARCHAR2(30 BYTE)          NULL,
  SRD2_ZDCO_CDT          NUMBER(1)                  NULL,
  SRD2_TYPE              NUMBER(30)             DEFAULT 0                         NULL
) TABLESPACE V8MAIN ; 

ALTER TABLE SRD2 ADD CONSTRAINT SRD2_PK PRIMARY KEY (SRD2_ID) USING INDEX TABLESPACE V8INDEX;

/*  YCRT  */     	         
CREATE TABLE YCRT (
   YCRT_ID NUMBER(30) NOT NULL
  ,YCRT_SHORTDESC VARCHAR2(5) NOT NULL
  ,YCRT_LONGDESC VARCHAR2(200) NOT NULL 
  ,YCRT_XCMA_ID NUMBER(30)
  ,YCRT_YCAT_ID NUMBER(30)
  ,YCRT_YRCH_ID NUMBER(30)
  ,YCRT_CONTRACT_YRCH_ID NUMBER(30)
  ,YCRT_WEEKSTARTTYPE NUMBER(1)
  ,YCRT_WEEKSTARTVALUE NUMBER(1)
  ,YCRT_INACTIVE NUMBER(1)
  ,YCRT_DISPLORDER NUMBER(3) NOT NULL
  ,YCRT_WCOL_ID NUMBER(30)
  ,YCRT_MANDATORYCONTRACTNUMBER NUMBER(1)
  ,YCRT_SOURCE_YRAS_ID NUMBER(30)
  ,YCRT_COMPANY_XCMS_ID NUMBER(30)
  ,YCRT_SOURCE_XCMS_ID NUMBER(30)
  ,YCRT_TRAVELAGENT_XCMS_ID NUMBER(30)
  ,CONSTRAINT YCRT_PK PRIMARY KEY (YCRT_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

/*  YCRS  */     	           
CREATE TABLE YRCS (
   YRCS_ID NUMBER(30) NOT NULL
  ,YRCS_XCMS_ID NUMBER(30) NOT NULL
  ,YRCS_VALIDFROM DATE NOT NULL
  ,YRCS_VALIDUNTIL DATE
  ,YRCS_STAYFROM DATE
  ,YRCS_STAYUNTIL DATE
  ,YRCS_YCRT_ID NUMBER(30)
  ,YRCS_WEEK NUMBER(2)
  ,YRCS_LENGTHWEEKS NUMBER(2)
  ,YRCS_FLOATING NUMBER(1)
  ,YRCS_YCAT_ID NUMBER(30)
  ,YRCS_YRMS_ID NUMBER(30)
  ,YRCS_YRCH_ID NUMBER(30)
  ,YRCS_CONTRACT_YRCH_ID NUMBER(30)
  ,YRCS_XCMA_ID NUMBER(30)
  ,YRCS_COMMENT VARCHAR2(2000)
  ,YRCS_NOOFPERSONS NUMBER(3)
  ,YRCS_ARRIVALDAYOFWEEK NUMBER(1)
  ,YRCS_ACTIONTIMESTAMP DATE
  ,YRCS_ERRORTEXT VARCHAR2(2000)
  ,YRCS_LASTACTIONYEAR NUMBER(4)
  ,YRCS_CONTRACTNUMBER VARCHAR2(50)
  ,YRCS_SOURCE_YRAS_ID NUMBER(30)
  ,CONSTRAINT YRCS_PK PRIMARY KEY (YRCS_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;
  
/*  YCRY  */     	           
CREATE TABLE YRCY (
   YRCY_ID NUMBER(30) NOT NULL
  ,YRCY_YRCS_ID NUMBER(30) NOT NULL
  ,YRCY_YEAR NUMBER(4) NOT NULL
  ,YRCY_WEEK NUMBER(2) 
  ,YRCY_WEEKTO NUMBER(2)
  ,YRCY_YEARLYFEE_PERSTAY NUMBER(30,4)
  ,YRCY_YCAT_ID NUMBER(30)
  ,YRCY_YRMS_ID NUMBER(30)
  ,CONSTRAINT YRCY_PK PRIMARY KEY (YRCY_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  YCRZ  */     	             
CREATE TABLE YRCZ (
   YRCZ_ID NUMBER(30) NOT NULL
  ,YRCZ_YRCS_ID NUMBER(30) NOT NULL
  ,YRCZ_YEAR NUMBER(4) NOT NULL
  ,YRCZ_WEEKFROM NUMBER(2) NOT NULL
  ,YRCZ_WEEKTO NUMBER(2) NOT NULL
  ,YRCZ_FEE NUMBER(30,4) NOT NULL
  ,YRCZ_TIMESTAMP DATE NOT NULL
  ,YRCZ_XCED_ID NUMBER(30) NOT NULL
  ,YRCZ_XCMS_ID NUMBER(30) NOT NULL
  ,YRCZ_ZFAC_ID NUMBER(30) NOT NULL
  ,CONSTRAINT YCRZ_PK PRIMARY KEY (YRCZ_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN; 

/*  YCRM  */
CREATE TABLE YRCM (
   YRCM_ID NUMBER(30)
  ,YRCM_YRCS_ID NUMBER(30) NOT NULL
  ,YRCM_XCMS_ID NUMBER(30) NOT NULL
  ,CONSTRAINT YRCM_PK PRIMARY KEY (YRCM_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

/*  WCRN  */
CREATE TABLE WCRN (
    WCRN_ID NUMBER(30)
   ,WCRN_WLAN_ID NUMBER(30) NOT NULL
   ,WCRN_GRIDNAME VARCHAR2(200) NOT NULL
   ,WCRN_ORIGINALCOLUMNNAME VARCHAR2(60) NOT NULL
   ,WCRN_NEWCOLUMNNAME VARCHAR2(60) NOT NULL
   ,CONSTRAINT WCRN_PK PRIMARY KEY (WCRN_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;
  
/*  YMSP  */
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;  

/*  XCMH  */
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;
  
/*  WLIB  */
  CREATE TABLE WLIB (
   WLIB_ID NUMBER(30) NOT NULL
  ,WLIB_TIMESTAMP DATE NOT NULL
  ,WLIB_HASH VARCHAR2(32)
  ,WLIB_DATA CLOB NOT NULL
  ,CONSTRAINT WLIB_PK PRIMARY KEY (WLIB_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;   

  
/************************************************************************************************************************
*
*  The following statements will upgrade the COMMON tables
*
************************************************************************************************************************/


ALTER TABLE CART MODIFY ( CART_WEBNAME VARCHAR2(300) );

ALTER TABLE COUP ADD ( COUP_ORDERING_XCMS_ID NUMBER(30) NULL  );

ALTER TABLE IDCO MODIFY ( IDCO_CALL_TYPE VARCHAR2(128) );

ALTER TABLE MCNV ADD ( MCNV_SUBTYPE NUMBER(2) NULL  );

ALTER TABLE QNRF ADD ( QNRF_INPUTSOURCE NUMBER(1) NULL  );

ALTER TABLE RRES ADD ( RRES_YEVM_ID NUMBER(30) NULL  );

ALTER TABLE RRES ADD ( RRES_CRSSYSTEM VARCHAR2(30) NULL  );

ALTER TABLE RRST ADD ( RRST_WEBINFO VARCHAR2(2000) NULL  );

ALTER TABLE RRST ADD ( RRST_LONGWEBINFO VARCHAR2(2000) NULL  );

ALTER TABLE RRST ADD ( RRST_MD_SHORTWEBINFO VARCHAR2(1000) NULL  );

ALTER TABLE RRST ADD ( RRST_MD_LONGWEBINFO VARCHAR2(2000) NULL  );

ALTER TABLE RRST ADD ( RRST_THRESHOLD VARCHAR2(2000) NULL  );

ALTER TABLE RRST ADD ( RRST_WEBENABLED NUMBER(1) NULL  );

ALTER TABLE SBUD ADD ( SBUD_WPHS_ID NUMBER(30) NULL  );

ALTER TABLE SBUD ADD ( SBUD_PARTNER_ID NUMBER(30) NULL  );

ALTER TABLE SBUD ADD ( SBUD_IMPORTED NUMBER(1) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G1_D NUMBER(6) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G1_M NUMBER(6) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G1_Y NUMBER(6) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G2_D NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G2_M NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G2_Y NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G3_D NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G3_M NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_CHILDS_G3_Y NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G1_D NUMBER(6) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G1_M NUMBER(6) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G1_Y NUMBER(6) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G2_D NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G2_M NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G2_Y NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G3_D NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G3_M NUMBER(7) NULL  );

ALTER TABLE SMAD ADD ( SMAD_DOMESTICCHILDS_G3_Y NUMBER(7) NULL  );

ALTER TABLE SMAN ADD ( SMAN_DAYUSEONDEPARTURE_D NUMBER(5) NULL  );

ALTER TABLE SMAN ADD ( SMAN_DAYUSEONDEPARTURE_M NUMBER(5) NULL  );

ALTER TABLE SMAN ADD ( SMAN_DAYUSEONDEPARTURE_Y NUMBER(7) NULL  );

ALTER TABLE SMAN ADD ( SMAN_DAYUSEONDEP_ADULTS_D NUMBER(5) NULL  );

ALTER TABLE SMAN ADD ( SMAN_DAYUSEONDEP_ADULTS_M NUMBER(5) NULL  );

ALTER TABLE SMAN ADD ( SMAN_DAYUSEONDEP_ADULTS_Y NUMBER(7) NULL  );

ALTER TABLE TACD ADD ( TACD_FR_COMABLEAMOUNT NUMBER(30,4) NULL  );

ALTER TABLE TACD ADD ( TACD_FR_COMM_AMOUNT NUMBER(30,4) NULL  );

ALTER TABLE TACD ADD ( TACD_FR_DT NUMBER(30,4) NULL  );

ALTER TABLE WANT ADD ( WANT_NOTES_VC VARCHAR2(2000) NULL  );

ALTER TABLE WERR ADD ( WERR_COMMENTTIMESTAMP DATE NULL  );

ALTER TABLE WERR ADD ( WERR_COMMENTUSER VARCHAR2(60) NULL  );

ALTER TABLE WERR ADD ( WERR_STATUSTEXT VARCHAR2(60) NULL  );

ALTER TABLE WFLS MODIFY ( WFLS_NAME VARCHAR2(50) );

ALTER TABLE WILG ADD ( WILG_ERRORDESC_VC VARCHAR2(2000) NULL  );

ALTER TABLE WLAN ADD ( WLAN_WEBCULTURE VARCHAR2(10) NULL  );

ALTER TABLE WLOG ADD ( WLOG_TERMINAL VARCHAR2(60) NULL  );

ALTER TABLE WMSO ADD ( WMSO_BODY_WFAQ_ID NUMBER(30) NULL  );

ALTER TABLE WMSO ADD ( WMSO_ATTACHMENT_WFAQ_ID NUMBER(30) NULL  );

ALTER TABLE WMSO ADD ( WMSO_SUBJECT VARCHAR2(60) NULL  );

ALTER TABLE WMSO ADD ( WMSO_ATTACHMENT VARCHAR2(200) NULL  );

ALTER TABLE WNAE ADD ( WNAE_DEFTYPE NUMBER(1) NULL  );

ALTER TABLE WNAE ADD ( WNAE_WRPT_ID NUMBER(30) NULL  );

ALTER TABLE WNAE ADD ( WNAE_EXPORTTYPE NUMBER(1) NULL  );

ALTER TABLE WPHS ADD ( WPHS_TASKANDACTIVITY NUMBER(1) NULL  );

ALTER TABLE WPHS ADD ( WPHS_VPDID NUMBER(30) NULL  );

ALTER TABLE WPHS ADD ( WPHS_CRS_ROLE NUMBER(1) NULL  );

ALTER TABLE WQNR ADD ( WQNR_WEBINTRODUCTIONTEXT VARCHAR2(2000) NULL  );

ALTER TABLE WSPS ADD ( WSPS_VPDID NUMBER(30) NULL  );

ALTER TABLE WTBC MODIFY ( WTBC_DISPLORDER NUMBER(3) NULL  );

ALTER TABLE XCAC ADD ( XCAC_COUNTFOROCCUPANCY NUMBER(1) NULL  );

ALTER TABLE XCED ADD ( XCED_IFCONLY NUMBER(1) NULL  );

ALTER TABLE XCED ADD ( XCED_TRANSPORTATION NUMBER(1) NULL  );

ALTER TABLE XCED ADD ( XCED_SALESFORCE_ID VARCHAR2(30) NULL  );

ALTER TABLE XCED ADD ( XCED_ADSLOGINNAME VARCHAR2(30) NULL  );

ALTER TABLE XCOM ADD ( XCOM_MAILID VARCHAR2(100) NULL  );

ALTER TABLE XCTH ADD ( XCTH_MASTER_XCTH_ID NUMBER(30) NULL  );

ALTER TABLE XCTH ADD ( XCTH_WPHS_ID NUMBER(30) NULL  );

ALTER TABLE XJLG ADD ( XJLG_YRES_ID NUMBER(30) NULL  );

ALTER TABLE XJLG ADD ( XJLG_YGRP_ID NUMBER(30) NULL  );

ALTER TABLE XMLD ADD ( XMLD_AUTOSUBFOLDERS NUMBER(1) NULL  );

ALTER TABLE XMLS MODIFY ( XMLS_MAILID VARCHAR2(2000) );

ALTER TABLE XMLS MODIFY ( XMLS_STOREID VARCHAR2(2000) );

ALTER TABLE XMTY ADD ( XMTY_WEBNAME VARCHAR2(60) NULL  );

ALTER TABLE XMTY ADD ( XMTY_WEBSHORTDESC VARCHAR2(300) NULL  );

ALTER TABLE XMTY ADD ( XMTY_WIMG_ID NUMBER(30) NULL  );

ALTER TABLE YEMN ADD ( YEMN_POSTGUARANTEED NUMBER(1) NULL  );

ALTER TABLE YFRD ADD ( YFRD_INACTIVE NUMBER(1) DEFAULT 0 NULL  );

ALTER TABLE YFSC ADD ( YFSC_INACTIVE NUMBER(1) DEFAULT 0 NULL  );

ALTER TABLE YFVT ADD ( YFVT_GUESTSERVICE_STATUS NUMBER(1) NULL  );

ALTER TABLE YMES ADD ( YMES_WACT_ID NUMBER(30) NULL  );

ALTER TABLE YPIL ADD ( YPIL_CALCTYPE NUMBER(1) DEFAULT 0 NOT NULL  );

ALTER TABLE YRCH ADD ( YRCH_SUPRESSRATE NUMBER(1) NULL  );

ALTER TABLE YRCO ADD ( YRCO_YBLH_ID NUMBER(30) NULL  );

ALTER TABLE YRCO ADD ( YRCO_DOCNAME VARCHAR2(60) NULL  );

ALTER TABLE YRDC ADD ( YRDC_AUTOMATIC NUMBER(1) DEFAULT 0 NOT NULL  );

ALTER TABLE YRES ADD ( YRES_DENYKIOSKCHECKIN NUMBER(1) NULL  );

ALTER TABLE YRMS ADD ( YRMS_GUESTSERVICE_STATUS NUMBER(1) NULL  );

ALTER TABLE YSSC ADD ( YSSC_INACTIVE NUMBER(1) DEFAULT 0 NULL  );

ALTER TABLE YXLS MODIFY ( YXLS_COLUMNS VARCHAR2(800) );

ALTER TABLE ZCCS ADD ( ZCCS_PREFIX VARCHAR2(50) NULL  );

ALTER TABLE ZCCS ADD ( ZCCS_CARD_LENGTH VARCHAR2(50) NULL  );

ALTER TABLE ZCCS ADD ( ZCCS_VALIDATION_RULE NUMBER(1) NULL  );

ALTER TABLE ZCCS ADD ( ZCCS_USER_DEFINED NUMBER(1) NULL  );

ALTER TABLE ZCCS ADD ( ZCCS_DISPLORDER NUMBER(3) NULL  );

ALTER TABLE ZCCS ADD ( ZCCS_INACTIVE NUMBER(1) NULL  );

ALTER TABLE ZPOS ADD ( ZPOS_DEPOSIT_ZINV_ID NUMBER(30) NULL  );

ALTER TABLE WNAS ADD ( WNAS_INACTIVE NUMBER(1) NULL  );

ALTER TABLE YFMI ADD ( YFMI_NOOFPAX NUMBER(1) DEFAULT 0 NOT NULL  );

ALTER TABLE XJET ADD ( XJET_DAYSRETRY NUMBER(3) NULL  );   

ALTER TABLE XJET ADD ( XJET_NOJETWEBGRPDEFAULT NUMBER(1) NULL  );

ALTER TABLE XJET ADD ( XJET_ALLOWTENTATIVE NUMBER(1) NULL  );

ALTER TABLE XJET ADD ( XJET_NADAYSINADVANCE NUMBER(3) NULL  );

ALTER TABLE XJET ADD ( XJET_BETRIEBNRALPHA VARCHAR(10) NULL  );

ALTER TABLE WZIP ADD ( WZIP_XSST_ID NUMBER(30) NULL  );

ALTER TABLE YRES ADD ( YRES_YRFR_ID NUMBER (30) NULL  );

ALTER TABLE WFMC ADD ( WFMC_SYSTEMVERSION NUMBER(1) DEFAULT 0 NOT NULL  );

ALTER TABLE W8HP ADD ( W8HP_CCM_MS_XCMA_ID NUMBER(30) NULL  );
                     
ALTER TABLE W8HP ADD ( W8HP_CCM_SC_YRAS_ID NUMBER(30) NULL  );

ALTER TABLE W8HP ADD ( W8HP_CCM_CC_YRAS_ID NUMBER(30) NULL  );

ALTER TABLE W8HP ADD ( W8HP_CCM_NC_XCNC_ID NUMBER(30) NULL  );

ALTER TABLE W8HP ADD ( W8HP_CCM_CM_XCMS_ID NUMBER(30) NULL  );

ALTER TABLE W8HP ADD ( W8HP_XML_MWRD DATE NULL  );

ALTER TABLE W8HP ADD ( W8HP_XML_S8HPAVLLIMIT_YALG_ID NUMBER(30) NULL  );

ALTER TABLE YEBS ADD YEBS_MERGEDFLAG NUMBER(3) DEFAULT 0;

ALTER TABLE SRPD ADD SRPD_TYPE NUMBER(30) DEFAULT 0;

ALTER TABLE SRDS ADD SRDS_TYPE NUMBER(30) DEFAULT 0;

ALTER TABLE SMAN ADD
(
  SMAN_D_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAN_D_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAN_D_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAN_D_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAN_D_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_D_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAN_D_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_D_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAN_D_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_D_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_D_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAN_D_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAN_D_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAN_D_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAN_D_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAN_D_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_D_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_D_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAN ADD
(
  SMAN_V_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAN_V_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAN_V_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAN_V_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAN_V_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_V_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAN_V_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_V_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAN_V_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_V_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_V_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAN_V_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAN_V_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAN_V_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAN_V_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAN_V_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_V_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_V_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAN ADD
(
  SMAN_D_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_D_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAN_D_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAN_D_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAN_D_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAN_D_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAN_D_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAN_D_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAN_D_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAN_D_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAN_D_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAN_D_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_D_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_D_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAN_D_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);

ALTER TABLE SMAN ADD
(
  SMAN_V_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_V_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAN_V_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAN_V_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAN_V_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAN_V_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAN_V_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAN_V_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAN_V_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAN_V_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAN_V_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAN_V_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_V_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_V_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAN_V_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);  

ALTER TABLE SMAD ADD
(
  SMAD_D_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAD_D_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAD_D_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAD_D_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAD_D_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_D_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAD_D_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_D_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAD_D_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_D_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_D_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAD_D_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAD_D_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAD_D_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAD_D_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAD_D_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_D_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_D_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAD ADD
(
  SMAD_V_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAD_V_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAD_V_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAD_V_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAD_V_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_V_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAD_V_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_V_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAD_V_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_V_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_V_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAD_V_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAD_V_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAD_V_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAD_V_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAD_V_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_V_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_V_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAD ADD
(
  SMAD_D_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_D_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAD_D_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAD_D_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAD_D_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAD_D_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAD_D_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAD_D_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAD_D_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAD_D_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAD_D_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAD_D_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_D_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_D_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAD_D_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);

ALTER TABLE SMAD ADD
(
  SMAD_V_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_V_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAD_V_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAD_V_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAD_V_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAD_V_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAD_V_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAD_V_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAD_V_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAD_V_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAD_V_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAD_V_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_V_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_V_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAD_V_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);  

ALTER TABLE COUP ADD COUP_VOID_ZFAC_ID NUMBER(30,0);

ALTER TABLE CART ADD CART_TAXWHENUSED NUMBER(1);

ALTER TABLE COUP ADD COUP_FULLYPAID NUMBER(1);

ALTER TABLE XMTY ADD XMTY_BONUSPOINT NUMBER(1);

ALTER TABLE XMTY ADD XMTY_WEBENABLED NUMBER(1);

ALTER TABLE XMTY ADD XMTY_NUMBEROFLEVELS NUMBER(1);

ALTER TABLE XMNR ADD XMNR_LEVELNUMBER NUMBER(1);

ALTER TABLE YRES ADD YRES_BONUS_XMNR_ID NUMBER(30);

ALTER TABLE XMNR ADD XMNR_INACTIVE NUMBER(1);

ALTER TABLE XMNR ADD XMNR_ISSUEDBY_XCED_ID NUMBER(30);

ALTER TABLE SHIS ADD SHIS_XSTA_ID NUMBER(30);

ALTER TABLE XMNR ADD XMNR_INACTIVEREASON VARCHAR2(60);

ALTER TABLE WPCA ADD WPCA_SKIPMAKEKEYFORTRANSPONDER NUMBER(1) DEFAULT 0;

ALTER TABLE ZOTA ADD ZOTA_ZCNV_ID NUMBER(30);

ALTER TABLE MQU2 ADD MQU2_RESEND NUMBER(1,0);

ALTER TABLE MURL ADD MURL_INACTIVE NUMBER(1,0);

ALTER TABLE MWSV ADD MWSV_INACTIVE NUMBER(1,0);

ALTER TABLE MIMP ADD MIMP_MSG_TYPE NUMBER(1,0);

ALTER TABLE MIMP ADD MIMP_TABLE_ID NUMBER(30,0);

ALTER TABLE XMTY ADD XMTY_ZINN_ID NUMBER(30);

ALTER TABLE YFSC ADD YFSC_FLOOR NUMBER(3);

ALTER TABLE YRES ADD YRES_YRCS_ID NUMBER(30);

ALTER TABLE YRCO ADD YRCO_YRCS_ID NUMBER(30);

ALTER TABLE YRCO ADD YRCO_YRCS_YEAR NUMBER(4);

ALTER TABLE MMOD ADD MMOD_USE_FREETEXT NUMBER(1,0);

ALTER TABLE MMOD ADD MMOD_FTP_PASSIVE NUMBER(1,0);

ALTER TABLE MMOD ADD MMOD_FTP_BACKUP NUMBER(1,0);

ALTER TABLE MMOD ADD MMOD_FTP_BACKUPPATH VARCHAR2(100);

ALTER TABLE SMBD ADD SMBD_WPHS_ID NUMBER(30);

ALTER TABLE SMBD ADD SMBD_PARTNER_ID NUMBER(30);

ALTER TABLE SMBD ADD SMBD_IMPORTED NUMBER(1);

ALTER TABLE ZBCF ADD ZBCF_CARDROLE NUMBER(1) DEFAULT 0 NOT NULL;

ALTER TABLE WMAI MODIFY WMAI_TO VARCHAR2(2000); 

ALTER TABLE WMAI MODIFY WMAI_CC VARCHAR2(2000);

ALTER TABLE WMAI MODIFY WMAI_BCC VARCHAR2(2000);

ALTER TABLE YPAC ADD YPAC_SUBSTRACTINCLUDEDPACKAGE NUMBER(1);

ALTER TABLE YPRR ADD YPRR_MINARRIVAL NUMBER (3); 

ALTER TABLE YPRR ADD YPRR_MAXARRIVAL NUMBER (3); 

ALTER TABLE YPRR ADD YPRR_YPFR_ID NUMBER (30);

ALTER TABLE YPRR ADD YPRR_XCAC_ID NUMBER (30);

ALTER TABLE YPRR ADD YPRR_EB_PERCENTAGE NUMBER(1);

ALTER TABLE YCRT MODIFY YCRT_WEEKSTARTVALUE NUMBER(2);

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

ALTER TABLE YPAC ADD YPAC_SUPPRESSPRICE NUMBER (1);

ALTER TABLE WRPD MODIFY WRPD_VALUE VARCHAR2(3000);

ALTER TABLE COUP MODIFY COUP_ISSUE NULL;


/************************************************************************************************************************
*
*  The following statements will upgrade the data and COMMON tables
*
************************************************************************************************************************/


ALTER TABLE XCMG ADD ( XCMG_GLOBALID_TMP VARCHAR2(50) NULL  );

UPDATE XCMG SET XCMG_GLOBALID_TMP = TO_CHAR(XCMG_GLOBALID);

ALTER TABLE XCMG DROP COLUMN XCMG_GLOBALID;

ALTER TABLE XCMG RENAME COLUMN XCMG_GLOBALID_TMP TO XCMG_GLOBALID;

ALTER TABLE XCTH ADD (XCTH_EXPIRYDATE DATE, XCTH_SIGNUPDATE DATE, XCTH_STARTDATE DATE, XCTH_CONTRACTNAME VARCHAR2(30 CHAR));

UPDATE XCTH SET 
       XCTH_EXPIRYDATE   = (SELECT XMNR_EXPIRYDATE FROM XMNR, XCTL WHERE XCTL_XCTH_ID=XCTH_ID AND XMNR_ID = XCTL_XMNR_ID AND ROWNUM = 1),
       XCTH_SIGNUPDATE   = (SELECT XMNR_SIGNUPDATE FROM XMNR, XCTL WHERE XCTL_XCTH_ID=XCTH_ID AND XMNR_ID = XCTL_XMNR_ID AND ROWNUM = 1),
       XCTH_STARTDATE    = (SELECT XMNR_STARTDATE  FROM XMNR, XCTL WHERE XCTL_XCTH_ID=XCTH_ID AND XMNR_ID = XCTL_XMNR_ID AND ROWNUM = 1),
       XCTH_CONTRACTNAME = (SELECT XMNR_VALUE      FROM XMNR, XCTL WHERE XCTL_XCTH_ID=XCTH_ID AND XMNR_ID = XCTL_XMNR_ID AND ROWNUM = 1);

ALTER TABLE XCTL ADD (XCTL_XCMS_ID NUMBER(30) NULL  );

UPDATE XCTL SET XCTL_XCMS_ID = (SELECT XMNR_XCMS_ID FROM XMNR WHERE XMNR_ID = XCTL_XMNR_ID);

COMMIT;


/************************************************************************************************************************
*
*  The following statements will upgrade the indexes for the COMMON tables
*
************************************************************************************************************************/


/*  COUP  */

CREATE INDEX COUP_ORDERING_XCMS_ID ON COUP
	(
	  COUP_ORDERING_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  RRES  */

CREATE INDEX RRES_YEVM_ID ON RRES
	(
	  RRES_YEVM_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  SBUD  */

CREATE INDEX SBUD_PARTNER_ID ON SBUD
	(
	  SBUD_PARTNER_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX SBUD_WPHS_ID ON SBUD
	(
	  SBUD_WPHS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  WMSO  */

CREATE INDEX WMSO_ATTACHMENT_WFAQ_ID ON WMSO
	(
	  WMSO_ATTACHMENT_WFAQ_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX WMSO_BODY_WFAQ_ID ON WMSO
	(
	  WMSO_BODY_WFAQ_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  WNAE  */

CREATE INDEX WNAE_WRPT_ID ON WNAE
	(
	  WNAE_WRPT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  XCED  */

CREATE INDEX XCED_SALESFORCE_ID ON XCED
	(
	  XCED_SALESFORCE_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  XCMG  */
DROP INDEX XCMG_XCMS_ID;
DROP INDEX XCMG_XCMS_GLOBALID;
CREATE INDEX XCMG_XCMS_ID ON XCMG
	(
	  XCMG_XCMS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  XCTH  */

CREATE INDEX XCTH_MASTER_XCTH_ID ON XCTH
	(
	  XCTH_MASTER_XCTH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX XCTH_WPHS_ID ON XCTH
	(
	  XCTH_WPHS_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  XJLG  */

CREATE INDEX XJLG_YGRP_ID ON XJLG
	(
	  XJLG_YGRP_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;
CREATE INDEX XJLG_YRES_ID ON XJLG
	(
	  XJLG_YRES_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  XMTY  */

CREATE INDEX XMTY_WIMG_ID ON XMTY
	(
	  XMTY_WIMG_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  YMES  */

CREATE INDEX YMES_WACT_ID ON YMES
	(
	  YMES_WACT_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  YRCO  */

CREATE INDEX YRCO_YBLH_ID ON YRCO
	(
	  YRCO_YBLH_ID
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;



/*  ZCCS  */

CREATE INDEX ZCCS_DISPLORDER ON ZCCS
	(
	  ZCCS_DISPLORDER
	)
	PCTFREE    10
	INITRANS   2
	MAXTRANS   255
	TABLESPACE V8INDEX
;


/************************************************************************************************************************
*
*  The following statements will upgrade the data
*
************************************************************************************************************************/


INSERT INTO YMSP SELECT SEQ_YMSP.NEXTVAL,YPAC_MASTER_YPAC_ID,YPAC_ID FROM YPAC WHERE YPAC_MASTER_YPAC_ID IS NOT NULL;

UPDATE FPLI SET FPLI_YOUT_ID = NULL WHERE FPLI_YOUT_ID = 0;

UPDATE YCMR SET YCMR_YOUT_ID = NULL WHERE YCMR_DEFAULT > 0;

DELETE FROM WFTR WHERE WFTR_FORM LIKE 'fAutoRoomAssign' AND (WFTR_COMPONENT = 'Panel2' OR WFTR_COMPONENT = 'Panel4');

UPDATE W8HP SET W8HP_CCM_MS_XCMA_ID=(SELECT TO_NUMBER(WUSS_VALUE) FROM WUSS WHERE WUSS_NAME='WebBookingConferenceMarketCode');

UPDATE W8HP SET W8HP_CCM_SC_YRAS_ID=(SELECT TO_NUMBER(WUSS_VALUE) FROM WUSS WHERE WUSS_NAME='WebBookingConferenceSourceCode');

UPDATE W8HP SET W8HP_CCM_CC_YRAS_ID=(SELECT TO_NUMBER(WUSS_VALUE) FROM WUSS WHERE WUSS_NAME='WBConferenceChannelCode');

UPDATE W8HP SET W8HP_CCM_NC_XCNC_ID=(SELECT TO_NUMBER(WUSS_VALUE) FROM WUSS WHERE WUSS_NAME='WebBookingConferenceNotesCategory');

UPDATE W8HP SET W8HP_CCM_CM_XCMS_ID=(SELECT TO_NUMBER(WUSS_VALUE) FROM WUSS WHERE WUSS_NAME='WebBookingConferenceManager');

UPDATE W8HP SET W8HP_XML_S8HPAVLLIMIT_YALG_ID=(SELECT TO_NUMBER(WUSS_VALUE) FROM WUSS WHERE WUSS_NAME='XMLWebAvlLimit');

INSERT INTO ZBCF SELECT SEQ_ZBCF.NEXTVAL, ZBCF_XMTY_ID, ZBCF_STAYPERADULT, ZBCF_FIRSTSTAYPERADULT, ZBCF_NIGHTPERADULT, ZBCF_RATECODESTAYPERADULT, ZBCF_RATECODEFIRSTSTAYPERADULT, ZBCF_RATECODENIGHTPERADULT, ZBCF_ROOMTYPESTAYPERADULT, ZBCF_ROOMTYPEFIRSTSTAYPERADULT, ZBCF_ROOMTYPENIGHTPERADULT, 1 FROM ZBCF WHERE ZBCF_CARDROLE=0;

UPDATE YPRR SET YPRR_EB_PERCENTAGE=1, YPRR_EB_CALCMETHOD=2 WHERE YPRR_EB_CALCMETHOD=1;

UPDATE YPRR SET YPRR_EB_POSTDAY=-1 WHERE YPRR_EB_CALCMETHOD=2 AND YPRR_EB_POSTDAY=1; 

UPDATE YPRR SET YPRR_MINARRIVAL=YPRR_MINDAY, YPRR_MAXARRIVAL=YPRR_MAXDAY WHERE YPRR_RULE=1 AND (YPRR_MINARRIVAL IS NULL OR YPRR_MAXARRIVAL IS NULL);

UPDATE YPRR SET YPRR_MINDAY=0, YPRR_MAXDAY=0 WHERE YPRR_RULE=1 AND (YPRR_MINARRIVAL=YPRR_MINDAY AND YPRR_MAXARRIVAL=YPRR_MAXDAY);


/************************************************************************************************************************
*
*  The following statements will upgrade the column and table comments
*
************************************************************************************************************************/


COMMENT ON COLUMN YEBS.YEBS_MERGEDFLAG IS '0-booked by package; 1-created by merge functionality';

COMMENT ON COLUMN SRPD.SRPD_TYPE IS '0 Standard (all revenue), 1 Hotel, 2 Deposit, 3 Voucher';

COMMENT ON COLUMN SRDS.SRDS_TYPE IS '0 Standard (all revenue), 1 Hotel, 2 Deposit, 3 Voucher';

COMMENT ON COLUMN COUP.COUP_VOID_ZFAC_ID IS 'Link to FA of the voided voucher';

COMMENT ON COLUMN CART.CART_TAXWHENUSED IS 'when 1, Tax will be calculated when the voucher is used, not when the voucher is created';

COMMENT ON COLUMN COUP.COUP_FULLYPAID IS 'when 1, means that voucher has been fully paid (V* voucher management only)';

COMMENT ON COLUMN XMTY.XMTY_ROLE IS '1 = A/R Number     2 = IATA Number     3 = VAT Number  4 = Frequent Flyer Cards and Loyalty Cards and Bonus point cards (differentiation will not be handled on this level)     5 = Corporate ID (also used for V8Online IFC)     6 = Unique 3rd party Profile ID for Property Interface     7 = Rebate cards     8 = Contract number    9 = Fiscal Code (Legge Bersani, needed in Italy)    ... to be continued for special numbers';

COMMENT ON COLUMN XMTY.XMTY_BONUSPOINT IS '1=bonus point functionality is enabled for these cards. same as xmty_role=4 but this enables to combine bonus point feature with rebate card feature.'; 

COMMENT ON COLUMN XMTY.XMTY_WEBENABLED IS '1=available over web interface when creating new bonus point card';

COMMENT ON TABLE XMTL IS 'membership type levels';

COMMENT ON TABLE ZBCF IS 'bonus point membership type config'; 

COMMENT ON TABLE ZBPC IS 'bonus point configuration';

COMMENT ON COLUMN ZBPC.ZBPC_TYPE IS '0=% of total revenue  1=% of revenue per department code  2=per stay  3=for first stay  4=per night 5=redemption (payment rules with points)';

COMMENT ON COLUMN ZBPC.ZBPC_CARDROLE IS '0=rules for guest card linked to reservation 1=rules for bookers card';

COMMENT ON COLUMN ZBPC.ZBPC_ZDCO_ID IS 'filled only if zbpc_type=5 (payment department code)';

COMMENT ON TABLE ZBPD IS 'bonus point earning configuration for department codes';

COMMENT ON COLUMN ZBPD.ZBPD_CARDROLE IS '0=rules for guest card linked to reservation 1=rules for bookers card';

COMMENT ON TABLE ZBPX IS 'bonus point earning configuration for ratecode and roomtype';

COMMENT ON COLUMN ZBPX.ZBPX_CARDROLE IS '0=rules for guest card linked to reservation 1=rules for bookers card';

COMMENT ON TABLE ZBPS IS 'bonus points (earned)';

COMMENT ON COLUMN ZBPS.ZBPS_CARDROLE IS '0=guest card linked to reservation 1=bookers card';

COMMENT ON COLUMN ZBPS.ZBPS_CONSUMED IS 'number of consumed point. to be able to calculate balance considering expiry dates';

COMMENT ON COLUMN ZBPS.ZBPS_TYPE IS 'copied from zbpc type when zbps is created automatically';

COMMENT ON COLUMN ZBPS.ZBPS_UPLOADSTATUS IS '1=upload in progress 2=upload successful 3=upload failed';

COMMENT ON COLUMN ZBPS.ZBPS_TRANSFERFROM_XMNR_ID IS 'transferred from'; 

COMMENT ON TABLE ZBPP IS 'bonus point product catalog';

COMMENT ON COLUMN ZBPP.ZBPP_PRICE IS 'price in points';

COMMENT ON COLUMN ZBPP.ZBPP_ONSTOCK IS 'number of products available';

COMMENT ON COLUMN ZBPP.ZBPP_CHECKAVL IS '1=check availability 0=dont';

COMMENT ON COLUMN ZBPP.ZBPP_TYPE IS '0=earning 1=redemption';

COMMENT ON TABLE ZBPR IS 'bonus point redemption';

COMMENT ON COLUMN ZBPR.ZBPR_ZPOS_ID IS 'payment posting';

COMMENT ON COLUMN ZBPR.ZBPR_ZBPP_ID IS 'product id';

COMMENT ON COLUMN ZBPR.ZBPR_QUANTITY IS 'product quantity';   

COMMENT ON COLUMN ZBPR.ZBPR_TRANSFERTO_XMNR_ID IS 'transferred to';

COMMENT ON COLUMN YRES.YRES_BONUS_XMNR_ID IS 'link to bonus point card';

COMMENT ON COLUMN XMNR.XMNR_INACTIVE IS '1 = inactive';

COMMENT ON TABLE ZBST IS 'bonus point card statement';

COMMENT ON COLUMN XMNR.XMNR_ISSUEDBY_XCED_ID IS 'an employee who earns awards for generating a new guest membership'; 

COMMENT ON COLUMN XMNR.XMNR_INACTIVEREASON IS 'reason why card is inactive/active';

COMMENT ON COLUMN WPCA.WPCA_SKIPMAKEKEYFORTRANSPONDER IS '1. Makekey during Transponder check-in will be skiped in this workstation ';

COMMENT ON COLUMN MQU2.MQU2_RESEND IS 'Indicates whether message could not yet be sent';

COMMENT ON COLUMN MURL.MURL_INACTIVE IS 'Indicates which setup URL is really used';

COMMENT ON COLUMN MWSV.MWSV_INACTIVE IS 'Indicates which setup webservice is really used';

COMMENT ON COLUMN MIMP.MIMP_ID IS 'unique id';

COMMENT ON COLUMN MIMP.MIMP_MMOD_ID IS 'link to mmod';

COMMENT ON COLUMN MIMP.MIMP_RECEIVED IS 'timestamp of incomming ASCII message';

COMMENT ON COLUMN MIMP.MIMP_FILENAME IS 'name of ASCII request file';

COMMENT ON COLUMN MIMP.MIMP_MSG_LINE IS 'one booking from the reqeust store in one line';

COMMENT ON TABLE ZINS IS 'Portuguese Invoice Signatures';

COMMENT ON COLUMN MIMP.MIMP_MSG_TYPE IS 'Indicates type of message. 1 = Reservation, 2 = Profile';

COMMENT ON COLUMN MIMP.MIMP_TABLE_ID IS 'record id of reservation, profile, depending on msg type';

COMMENT ON COLUMN XMTY.XMTY_ZINN_ID IS 'membership numbers from zinn';

COMMENT ON TABLE YFSP IS 'FUNCTION SPACES FLOOR PLAN';

COMMENT ON COLUMN YFSP.YFSP_ID IS 'YFSP_ID';

COMMENT ON COLUMN YFSP.YFSP_DISPLAY IS 'DISPLAY ORDER';

COMMENT ON COLUMN YFSP.YFSP_FLOOR IS 'FLOOR CODE';

COMMENT ON COLUMN YFSP.YFSP_FLOORNAME IS 'FLOOR NAME';

COMMENT ON COLUMN YFSP.YFSP_PICTURE IS 'FLOOR PLAN ';

COMMENT ON COLUMN YFSP.YFSP_PICTURE_C IS 'FLOOR PLAN FUNCTION SPACES';

COMMENT ON COLUMN YFSP.YFSP_SHORTDESC IS 'SHORTDESC'; 

COMMENT ON COLUMN YFSC.YFSC_FLOOR IS 'FUNCTION SPACE FLOOR';

COMMENT ON COLUMN ZINN.ZINN_TYPE IS ' 1 = invoices, 2 = user definable number cycles, 3 = currency exchange (zfag_type 3), 4 = autonumber for booth telephone charges paid cash, 5 = City Ledger Folio, 11 = autonumber zfag_type 1 (ar postings), 12 = autonumber zfag_type 2 (ar payments), 13 = void invoice, 14 = fattura (for italy), 15 = nota di credito (for Italy or credit note for Greece, Portugal or Spain), 16 = proforma, 17 = fattura and nota di credito (for italy), 18 = nota korekta (for poland), 19 = Egyptian AR Invoice, 20 = AR Payment Receipt, 21 = registration cards, 22 = Ticket BarCode, 23 = Contract Numbers, 31 = automatic fa numbers (zfac_autonumber), 32 = lost and found, 33 = police export, 34 = tourist export, 35 = jetweb interface, 36 = Voucher, 37 = membership numbers';

COMMENT ON TABLE YCRT IS 'Vacation sharing template (reservation contract template)';

COMMENT ON COLUMN YCRT.YCRT_WEEKSTARTTYPE IS '0=n. day of the year according to calendar 1=first instance of n. day of the week (n=ycrt_weekstartvalue)';

COMMENT ON COLUMN YCRT.YCRT_MANDATORYCONTRACTNUMBER IS '1=yrcs_contractnumber is mandatory';

COMMENT ON COLUMN YCRT.YCRT_YRCH_ID IS 'ratecode for reservations';

COMMENT ON COLUMN YCRT.YCRT_CONTRACT_YRCH_ID IS 'ratecode for contract yearly charges';

COMMENT ON TABLE YRCS IS 'Vacation sharer contracts (reservation contracts)';

COMMENT ON COLUMN YRCS.YRCS_STAYFROM IS 'year part is ignored. also ignored if week values are filled';

COMMENT ON COLUMN YRCS.YRCS_STAYUNTIL IS 'year part is ignored. also ignored if week values are filled';

COMMENT ON COLUMN YRCS.YRCS_WEEK IS 'on which week the stay begins';

COMMENT ON COLUMN YRCS.YRCS_LENGTHWEEKS IS 'length of stay in weeks';

COMMENT ON COLUMN YRCS.YRCS_FLOATING IS '1=week value needs to be defined for every year separately. yrcs_week is ignored';

COMMENT ON COLUMN YRCS.YRCS_YCAT_ID IS 'filled only if different from template';

COMMENT ON COLUMN YRCS.YRCS_YRMS_ID IS 'fixed room';

COMMENT ON COLUMN YRCS.YRCS_YRCH_ID IS 'reservation rate code';

COMMENT ON COLUMN YRCS.YRCS_CONTRACT_YRCH_ID IS 'contract yearly charges rate code';

COMMENT ON COLUMN YRCS.YRCS_ARRIVALDAYOFWEEK IS '1=sunday 7=saturday';

COMMENT ON COLUMN YRCS.YRCS_ERRORTEXT IS 'error information from last automatic reservation creation procedure';

COMMENT ON COLUMN YRES.YRES_YRCS_ID IS 'Link to vacation sharer';

COMMENT ON TABLE YRCY IS 'Vacation sharing years for exception and floating weeks';

COMMENT ON TABLE YRCZ IS 'Vacation sharing yearly fee postings to zfac';

COMMENT ON COLUMN SRPD.SRPD_TYPE IS 'Obsolete column, new table SRP2 used instead to differentiate';

COMMENT ON COLUMN SRDS.SRDS_TYPE IS 'Obsolete column, new table SRD2 used instead to differentiate';

COMMENT ON COLUMN SRP2.SRP2_TYPE IS '0 Standard (all revenue), 1 Hotel, 2 Deposit, 3 Voucher';

COMMENT ON COLUMN SRD2.SRD2_TYPE IS '0 Standard (all revenue), 1 Hotel, 2 Deposit, 3 Voucher';

COMMENT ON TABLE YRCM IS 'res (vacation) contract members';

COMMENT ON TABLE WCRN IS 'column rename in grids';

COMMENT ON COLUMN MMOD.MMOD_USE_FREETEXT IS 'Indicates whether comment also stored in Freetext2 field in yres';

COMMENT ON COLUMN MMOD.MMOD_FTP_PASSIVE IS 'Indicates whether the ftp is used in passive mode';

COMMENT ON COLUMN MMOD.MMOD_FTP_BACKUP IS 'Indicates whether the interface makes a backup on the ftp of received file';

COMMENT ON COLUMN MMOD.MMOD_FTP_BACKUPPATH IS 'backup path on the ftp';

COMMENT ON COLUMN ZBCF.ZBCF_CARDROLE IS '0=rules for guest card linked to reservation 1=rules for bookers card';

COMMENT ON COLUMN YPAC.YPAC_SUBSTRACTINCLUDEDPACKAGE IS 'substract included packages from base. ypac_perctobase adds addtorate packages only';

COMMENT ON COLUMN YPRR.YPRR_MINARRIVAL IS 'minimum days in advance';

COMMENT ON COLUMN YPRR.YPRR_MAXARRIVAL IS 'maximum days in advance';

COMMENT ON COLUMN YPRR.YPRR_YPFR_ID IS 'Nights frequency';

COMMENT ON COLUMN YPRR.YPRR_XCAC_ID IS 'xcac_id=0 = no pax control,  xcac_id=-1 = ADULT Control, xcac_id>0 xcac_id Child control ';

COMMENT ON COLUMN YPRR.YPRR_EB_PERCENTAGE IS 'Percentage can be chosen also for daily and stay promotions';

COMMENT ON COLUMN YPRR.YPRR_EB_CALCMETHOD IS '1: OBSOLETE NOT USED (was Percentage), 2:Night  3: Stay 4: Frequency ';

COMMENT ON COLUMN YPRR.YPRR_RULE IS 'Discount Types: 0 - Free Nights, 1 - Percentage/Fix Amount';

COMMENT ON COLUMN YPRR.YPRR_EB_POSTDAY IS '0: Obsolete NOT USED (was Percentage Calculation), 1: Evenly Spread, 2:First Day  3: Last Day';

COMMENT ON COLUMN YPRR.YPRR_VALUE IS 'Percentage/Fix Amount or Number of Nights for free, depends on Discount Type';

COMMENT ON COLUMN YPRR.YPRR_MINDAY IS 'Minimum Nights for Rule to apply';

COMMENT ON COLUMN YPRR.YPRR_MAXDAY IS 'Maximum Nights for Rule to apply, if MAXDAY=0 every Reservation that has equal or more Nights, the Rule applies';

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

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

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

COMMIT;

--- End of DBDiff for Oracle --- Elapsed Time: 00:05:15 ---
