/************************************************************************************************************************
*
*
*  Date: May 08, 2017  09:02:20
*
*  This upgrade script was automatically generated by DBDiff for Oracle (www.dbdiff.com)
*
*  SOURCE DATABASE:  VERSION_8_10_2@V8
*  TARGET DATABASE:  VERSION_8_10_1@V8
*
*  This script should be executed as VERSION_8_10_1 in database VERSION_8_10_1@V8 except where otherwise noted.
*
*  IMPORTANT:  As with any script, you should always perform a sanity check before executing it in your target database.
*
*
************************************************************************************************************************/



/************************************************************************************************************************
*
*  tables
*
*  1107 tables were found in VERSION_8_10_2@V8
*  1092 tables were found in VERSION_8_10_1@V8
*
************************************************************************************************************************/




/************************************************************************************************************************
*
*  The following statements will drop tables that DO NOT exist in VERSION_8_10_2@V8
*
************************************************************************************************************************/


DROP TABLE VERSION_8_10_1_14;


/************************************************************************************************************************
*
*  The following statements will create tables that DO NOT exist in VERSION_8_10_1@V8
*
************************************************************************************************************************/


/*  ZASP  */
CREATE TABLE ZASP (
	 ZASP_ID	NUMBER(30)	NOT NULL
	,ZASP_TAXGROSSAMOUNT	NUMBER(30,4)	    NULL
	,ZASP_TAXGROSSAMOUNTFOREIGN	NUMBER(30,4)	    NULL
	,ZASP_TAXNETAMOUNT	NUMBER(30,4)	    NULL
	,ZASP_TAXNETAMOUNTFOREIGN	NUMBER(30,4)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE ZASP ADD (
	CONSTRAINT ZASP_PK
	PRIMARY KEY
	            (
	             ZASP_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX);

/*  YWRS  */
CREATE TABLE YWRS (
	 YWRS_ID	NUMBER(30)	NOT NULL
	,YWRS_YWRF_ID	NUMBER(30)	NOT NULL
	,YWRS_YSSL_ID	NUMBER(30)	NOT NULL
	,YWRS_DISPLORDER	NUMBER(3)	NOT NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YWRS ADD (
	CONSTRAINT YWRS_PK
	PRIMARY KEY
	            (
	             YWRS_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX);

/*  YWRF  */
CREATE TABLE YWRF (
	 YWRF_ID	NUMBER(30)	NOT NULL
	,YWRF_YPKE_ID	NUMBER(30)	NOT NULL
	,YWRF_YFSC_ID	NUMBER(30)	NOT NULL
	,YWRF_DISPLORDER	NUMBER(3)	NOT NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YWRF ADD (
	CONSTRAINT YWRF_PK
	PRIMARY KEY
	            (
	             YWRF_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX);

/*  YUSS  */
CREATE TABLE YUSS (
	 YUSS_ID	NUMBER(30)	NOT NULL
	,YUSS_SHORTDESC	VARCHAR2(5)	NOT NULL
	,YUSS_LONGDESC	VARCHAR2(30)	NOT NULL
	,YUSS_YPAC_ID	NUMBER(30)	    NULL
	,YUSS_YPFR_ID	NUMBER(30)	    NULL
	,YUSS_ZDCO_ID	NUMBER(30)	    NULL
	,YUSS_INACTIVE	NUMBER(1) DEFAULT 0 	NOT NULL
	,YUSS_WEB	NUMBER(1) DEFAULT 0 	NOT NULL
	,YUSS_DEFAULTAMOUNT	NUMBER(30,4)	    NULL
	,YUSS_ANYGUESTMEMBER	NUMBER(1) DEFAULT 0 	NOT NULL
	,YUSS_YALG_ID	NUMBER(30)	    NULL
	,YUSS_COMMENT	VARCHAR2(200)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUSS ADD (
	CONSTRAINT YUSS_PK
	PRIMARY KEY
	            (
	             YUSS_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX);

ALTER TABLE YUSS ADD (
	CONSTRAINT SYS_C0075916
	UNIQUE
	       (
	        YUSS_SHORTDESC
	       )
	USING INDEX
	TABLESPACE V8MAIN);

/*  YUSR  */
CREATE TABLE YUSR (
	 YUSR_ID	NUMBER(30)	NOT NULL
	,YUSR_YUSS_ID	NUMBER(30)	NOT NULL
	,YUSR_YRCH_ID	NUMBER(30)	NOT NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUSR ADD (
	CONSTRAINT YUSR_PK
	PRIMARY KEY
	            (
	             YUSR_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX);

/*  YUSP  */
CREATE TABLE YUSP (
	 YUSP_ID	NUMBER(30)	NOT NULL
	,YUSP_YUSS_ID	NUMBER(30)	NOT NULL
	,YUSP_FROM_YCAT_ID	NUMBER(30)	NOT NULL
	,YUSP_TO_YCAT_ID	NUMBER(30)	NOT NULL
	,YUSP_PRICE	NUMBER(30,4)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUSP ADD (
	CONSTRAINT YUSP_PK
	PRIMARY KEY
	            (
	             YUSP_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  YUSM  */
CREATE TABLE YUSM (
	 YUSM_ID	NUMBER(30)	NOT NULL
	,YUSM_YUSS_ID	NUMBER(30)	NOT NULL
	,YUSM_XMTY_ID	NUMBER(30)	NOT NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUSM ADD (
	CONSTRAINT YUSM_PK
	PRIMARY KEY
	            (
	             YUSM_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  YUSL  */
CREATE TABLE YUSL (
	 YUSL_ID	NUMBER(30)	NOT NULL
	,YUSL_YUSS_ID	NUMBER(30)	NOT NULL
	,YUSL_YCAT_ID	NUMBER(30)	NOT NULL
	,YUSL_MINAVL	NUMBER(4)	    NULL
	,YUSL_MINAVLPERC	NUMBER(2)	    NULL
	,YUSL_MAXUPSELL	NUMBER(4)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUSL ADD (
	CONSTRAINT YUSL_PK
	PRIMARY KEY
	            (
	             YUSL_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  YUSD  */
CREATE TABLE YUSD (
	 YUSD_ID	NUMBER(30)	NOT NULL
	,YUSD_YUSS_ID	NUMBER(30)	NOT NULL
	,YUSD_FROMDATE	DATE	NOT NULL
	,YUSD_TODATE	DATE	NOT NULL
	,YUSD_FROM_YCAT_ID	NUMBER(30)	    NULL
	,YUSD_TO_YCAT_ID	NUMBER(30)	    NULL
	,YUSD_PRICE	NUMBER(30,4)	    NULL
	,YUSD_OVERRIDESCHEMAPRICE	NUMBER(1) DEFAULT 0 	NOT NULL
	,YUSD_OVERRIDESCHEMALIMITCONT	NUMBER(1) DEFAULT 0 	NOT NULL
	,YUSD_COMMENT	VARCHAR2(200)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUSD ADD (
	CONSTRAINT YUSD_PK
	PRIMARY KEY
	            (
	             YUSD_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX);

/*  YUPS  */
CREATE TABLE YUPS (
	 YUPS_ID	NUMBER(30)	NOT NULL
	,YUPS_YRES_ID	NUMBER(30)	NOT NULL
	,YUPS_TIMESTAMP	DATE	NOT NULL
	,YUPS_YUSS_ID	NUMBER(30)	NOT NULL
	,YUPS_XCED_ID	NUMBER(30)	NOT NULL
	,YUPS_AMOUNT	NUMBER(30,4)	    NULL
	,YUPS_FAMOUNT	NUMBER(30,4)	    NULL
	,YUPS_YPAC_ID	NUMBER(30)	    NULL
	,YUPS_ZDCO_ID	NUMBER(30)	    NULL
	,YUPS_FROM_YCAT_ID	NUMBER(30)	    NULL
	,YUPS_TO_YCAT_ID	NUMBER(30)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUPS ADD (
	CONSTRAINT YUPS_PK
	PRIMARY KEY
	            (
	             YUPS_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  YUDP  */
CREATE TABLE YUDP (
	 YUDP_ID	NUMBER(30)	NOT NULL
	,YUDP_YUSD_ID	NUMBER(30)	NOT NULL
	,YUDP_FROM_YCAT_ID	NUMBER(30)	NOT NULL
	,YUDP_TO_YCAT_ID	NUMBER(30)	NOT NULL
	,YUDP_PRICE	NUMBER(30,4)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YUDP ADD (
	CONSTRAINT YUDP_PK
	PRIMARY KEY
	            (
	             YUDP_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  YUDL  */
CREATE TABLE YUDL (
	 YUDL_ID	NUMBER(30)	NOT NULL
	,YUDL_YUSD_ID	NUMBER(30)	NOT NULL
	,YUDL_YCAT_ID	NUMBER(30)	NOT NULL
	,YUDL_MINAVL	NUMBER(4)	    NULL
	,YUDL_MINAVLPERC	NUMBER(2)	    NULL
	,YUDL_MAXUPSELL	NUMBER(4)	    NULL
)
TABLESPACE V8MAIN
;

ALTER TABLE YUDL ADD (
	CONSTRAINT YUDL_PK
	PRIMARY KEY
	            (
	             YUDL_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  YCBL  */
CREATE TABLE YCBL (
	 YCBL_ID	NUMBER(30)	NOT NULL
	,YCBL_YBED_ID	NUMBER(30)	NOT NULL
	,YCBL_DAY	DATE	NOT NULL
	,YCBL_TIMESTAMP	DATE	NOT NULL
	,YCBL_ORIGIN	NUMBER(1)	NOT NULL
	,YCBL_RESGLOBALID	VARCHAR2(60)	NOT NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YCBL ADD (
	CONSTRAINT YCBL_PK
	PRIMARY KEY
	            (
	             YCBL_ID
	            )
        USING INDEX
	TABLESPACE V8INDEX
)
;

ALTER TABLE YCBL ADD (
	CONSTRAINT YCBL_LOCK
	UNIQUE
	       (
	        YCBL_YBED_ID
	       ,YCBL_DAY
	       )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  YBCK  */
CREATE TABLE YBCK (
	 YBCK_ID	NUMBER(30)	NOT NULL
	,YBCK_DAY	DATE	NOT NULL
	,YBCK_YBED_ID	NUMBER(30)	NOT NULL
	,YBCK_WPCA_ID	NUMBER(30)	NOT NULL
)
TABLESPACE V8MAIN;

ALTER TABLE YBCK ADD (
	CONSTRAINT SYS_C0076097
	PRIMARY KEY
	            (
	             YBCK_DAY
	            ,YBCK_YBED_ID
	            )
	USING INDEX
	TABLESPACE V8MAIN);

/*  XMBK  */
CREATE TABLE XMBK (
	 XMBK_ID	NUMBER(30)	NOT NULL
	,XMBK_XCMS_ID	NUMBER(30)	NOT NULL
	,XMBK_XCOM_ID	NUMBER(30)	    NULL
	,XMBK_XMNR_ID	NUMBER(30)	    NULL
)
TABLESPACE V8MAIN;

ALTER TABLE XMBK ADD (
	CONSTRAINT XMBK_PK
	PRIMARY KEY
	            (
	             XMBK_ID
	            )
	USING INDEX
	TABLESPACE V8INDEX
)
;

/*  VERSION_8_10_2_0  */
CREATE TABLE VERSION_8_10_2_0 (
	 DUMMY	NUMBER	    NULL
)
TABLESPACE V8MAIN
;



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

ALTER TABLE YEMI MODIFY ( YEMI_REBATE_PERC NUMBER(7,4));

ALTER TABLE YEBS MODIFY ( YEBS_REBATE_PERC NUMBER(7,4));

ALTER TABLE YEBR MODIFY ( YEBR_REBATE_PERC NUMBER(7,4));

ALTER TABLE YDEP MODIFY ( YDEP_PERCENTAGE_RMS NUMBER(7,4));

ALTER TABLE YDEP MODIFY ( YDEP_PERCENTAGE_CONF NUMBER(7,4));

ALTER TABLE YCAN MODIFY ( YCAN_PERCENTAGE_CONF NUMBER(7,4));

ALTER TABLE YCAN MODIFY ( YCAN_PERCENTAGE_RMS NUMBER(7,4));

ALTER TABLE YMRD MODIFY ( YMRD_REBATE_PERC NUMBER(7,4));

ALTER TABLE YBEF MODIFY ( YBEF_REBATE_PERC NUMBER(7,4));

ALTER TABLE ZOTA ADD ( ZOTA_BLOCK_INC_TENT NUMBER(1) NULL  );

COMMENT ON COLUMN ZOTA.ZOTA_BLOCK_INC_TENT IS 'Indicates whther also tentative blocks will be uploaded';

ALTER TABLE ZOTA ADD ( ZOTA_BLOCK_INC_CANC NUMBER(1) NULL  );

COMMENT ON COLUMN ZOTA.ZOTA_BLOCK_INC_CANC IS 'Indicates whether also cancelled blocks are uploaded';

ALTER TABLE ZOTA ADD ( ZOTA_UPDATE_RATEPLANS NUMBER(1) NULL  );

COMMENT ON COLUMN ZOTA.ZOTA_UPDATE_RATEPLANS IS 'Indicates whether updates on rate plan will be accepted or rejected';  

ALTER TABLE zota ADD ZOTA_OPTIMIZE_ALLOT NUMBER(1);

COMMENT ON COLUMN ZOTA.ZOTA_OPTIMIZE_ALLOT IS 'Indicates whether the upload message for allotment will be optimized regarding the details';

ALTER TABLE YPRL ADD ( YPRL_SOURCE NUMBER(1) DEFAULT 0 NOT NULL  );

COMMENT ON COLUMN YPRL.YPRL_SOURCE IS '0=Manual 1=Rate 2=Membership 3=Upsell';

ALTER TABLE YPOS ADD ( YPOS_BILLINGPERIOD NUMBER(1) DEFAULT 0 NOT NULL  );

ALTER TABLE YPOS ADD ( YPOS_ZARR_ID NUMBER(30) NULL  );

ALTER TABLE YPOS ADD ( YPOS_ZTCD_ID NUMBER(30) NULL  );

ALTER TABLE YPKS ADD ( YPKS_DEFAULT NUMBER(1) NULL  );

COMMENT ON COLUMN YPKS.YPKS_DEFAULT IS 'Default';

ALTER TABLE YPKG ADD ( YPKG_LENGTH NUMBER(3) NULL  );

COMMENT ON COLUMN YPKG.YPKG_LENGTH IS 'Package length';

ALTER TABLE YPAC ADD ( YPAC_ASB_ZDCO_ID NUMBER(30) NULL  );

COMMENT ON COLUMN YPAC.YPAC_ASB_ZDCO_ID IS 'Zdco id on Apartment style billing invoice';

ALTER TABLE YGLT ADD ( YGLT_FIDCRSID VARCHAR2(20) NULL  );

ALTER TABLE YCRL ADD ( YCRL_BEDCOUNT NUMBER(3) NULL  );

ALTER TABLE YCDP ADD ( YCDP_WEBENABLED NUMBER(1) NULL  );

COMMENT ON COLUMN YCDP.YCDP_WEBENABLED IS 'Available for online booking';

ALTER TABLE YCDP ADD ( YCDP_WEBSHORTINFO VARCHAR2(1000) NULL  );

COMMENT ON COLUMN YCDP.YCDP_WEBSHORTINFO IS 'Short information shown in online booking';

ALTER TABLE YCDP ADD ( YCDP_WEBLONGINFO VARCHAR2(2000) NULL  );

COMMENT ON COLUMN YCDP.YCDP_WEBLONGINFO IS 'Long information shown in online booking';

ALTER TABLE YBRC ADD ( YBRC_FIDCRSID VARCHAR2(20) NULL  );

ALTER TABLE YBAR ADD ( YBAR_YCAT_ID NUMBER(30) NULL  );

ALTER TABLE YAST ADD ( YAST_FIDCRSID VARCHAR2(20) NULL  );

ALTER TABLE WCIP ADD ( WCIP_SCANNINGMANDATORY NUMBER(1) NULL  );

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

COMMENT ON COLUMN W8HP.W8HP_CCM_YEST_ID IS 'Booking'; 

ALTER TABLE W8HP ADD ( W8HP_CCM_OVERRIDEWO NUMBER(1) NULL  );

COMMENT ON COLUMN W8HP.W8HP_CCM_OVERRIDEWO IS 'Override web only flag for package events/resources if package is Web Only';

ALTER TABLE MMOD ADD ( MMOD_REUSE_CRSNO NUMBER(1) NULL  );

COMMENT ON COLUMN MMOD.MMOD_REUSE_CRSNO IS 'Indicates, whether the interface allows the reuse of crs numbers'; 

ALTER TABLE MMOD ADD ( MMOD_REUSE_CRSNO_DAYS NUMBER(3) NULL  );

COMMENT ON COLUMN MMOD.MMOD_REUSE_CRSNO_DAYS IS 'number of days after a crs number can be resused'; 

ALTER TABLE W8HP ADD W8HP_CCM_CALENDARDAYS NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_CALENDARDAYS IS 'Calendar days mask';

ALTER TABLE W8HP ADD W8HP_CCM_DAYSWEBAVAILABILITY NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_DAYSWEBAVAILABILITY IS 'Maximum allowed days for bookings';

ALTER TABLE W8HP ADD W8HP_CCM_AVLSTARTTIME NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_AVLSTARTTIME IS 'Availability start time, eg. 09, 10';

ALTER TABLE W8HP ADD W8HP_CCM_AVLENDTIME NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_AVLENDTIME IS 'Availability end time, eg. 18, 20';

ALTER TABLE W8HP ADD W8HP_CCM_AVLINTERVAL NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_AVLINTERVAL IS 'Availability interval, eg 30min, 60 min';

ALTER TABLE W8HP ADD W8HP_CCM_AVLDEFAULTHOURS NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_AVLDEFAULTHOURS IS 'Availability default hours, eg. 2h';

ALTER TABLE W8HP ADD W8HP_CCM_AVLMINATTENDEES NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_AVLMINATTENDEES IS 'Availability min attendees, eg. 20';

ALTER TABLE W8HP ADD W8HP_CCM_AVLMAXATTENDEES NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_AVLMAXATTENDEES IS 'Availability max attendees, eg. 100';

ALTER TABLE W8HP ADD W8HP_CCM_AVLPACKAGEORDERING NUMBER(30);

COMMENT ON COLUMN W8HP.W8HP_CCM_AVLPACKAGEORDERING IS 'Package ordering, 0- Price Ascending, 1- Price Descending';

COMMENT ON TABLE YWRS IS 'Link package event/function space seattings for web purpose';

COMMENT ON TABLE YWRF IS 'Link package event/function spaces for web purpose';

COMMENT ON TABLE ZASP IS 'Apartment Style Billing posting data';

COMMENT ON COLUMN ZASP.ZASP_TAXGROSSAMOUNT IS 'Summary gross amount for summary tax postings';

COMMENT ON COLUMN ZASP.ZASP_TAXNETAMOUNT IS 'Summary net amount of main postings for summary tax postings';

COMMENT ON COLUMN WCIP.WCIP_SCANNINGMANDATORY IS 'Scanning is mandatory or not';

COMMENT ON TABLE YCBL IS 'Central Reservation Lock for beds in mirror and parnter';

COMMENT ON COLUMN YCBL.YCBL_ORIGIN IS '0=locally made 1=remotely requested';

COMMENT ON TABLE XMBK IS 'Mobile Key Communication details';

COMMENT ON COLUMN YBAR.YBAR_YCAT_ID IS 'ycat_id snet by Ideas for BarByLOS for room type';

COMMENT ON TABLE YUPS IS 'Upsell data for reservations'; 

COMMENT ON TABLE YUDL IS 'Upsell limit control'; 

COMMENT ON TABLE YUSL IS 'Upsell schema limit control';

COMMENT ON TABLE YUDP IS 'Upsell price configuration';

COMMENT ON TABLE YUSP IS 'Upsell schema price configuration';

COMMENT ON TABLE YUSD IS 'Upsell data';
   
COMMENT ON COLUMN YUSD.YUSD_PRICE IS 'Price is filled only if yuss_zdco_id is set and yuss_ypac_id is empty';

COMMENT ON TABLE YUSR IS 'Upsell schema rate code link';

COMMENT ON TABLE YUSM IS 'Upsell schema membership link';

COMMENT ON TABLE YUSS IS 'Upsell schema';

ALTER TABLE ZFCF ADD ZFCF_TRANSACTION_TYPE VARCHAR2(1);

COMMENT ON COLUMN ZFCF.ZFCF_TRANSACTION_TYPE IS 'indicates the type of transaction I = Initial, N = Invoice, Z = Zero';

ALTER TABLE MCOP ADD MCOP_USE_INACTIVE_CODES NUMBER(1);

COMMENT ON COLUMN MCOP.MCOP_USE_INACTIVE_CODES IS 'Indicates, whether als inactived codes can be entered into conversion'; 

create table WCPL (
    WCPL_id NUMBER(30) NOT NULL
   ,WCPL_WLOG_ID NUMBER(30) NOT NULL
   ,WCPL_TABLENAME VARCHAR2(30) NOT NULL 
   ,WCPL_TABLE_ID NUMBER(30) NOT NULL
   ,WCPL_FROMPRICE NUMBER(30, 4)
   ,WCPL_TOPRICE NUMBER(30, 4)
   ,WCPL_TEXT VARCHAR2(400)
   ,CONSTRAINT WCPL_PK PRIMARY KEY (WCPL_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

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

COMMENT ON TABLE WCPL IS 'Price Change Log';

COMMENT ON COLUMN WCPL.WCPL_ID IS 'ID';

COMMENT ON COLUMN WCPL.WCPL_WLOG_ID IS 'wlog id';

COMMENT ON COLUMN WCPL.WCPL_TABLENAME IS 'Table Name';

COMMENT ON COLUMN WCPL.WCPL_TABLE_ID IS 'Table id';

COMMENT ON COLUMN WCPL.WCPL_FROMPRICE IS ' from price';

COMMENT ON COLUMN WCPL.WCPL_TOPRICE IS 'to price';

COMMENT ON COLUMN WCPL.WCPL_TEXT IS 'Log text';

ALTER TABLE YCGV ADD YCGV_PERCENTAGE NUMBER(1);

ALTER TABLE YRGV ADD YRGV_PERCENTAGE NUMBER(1);

ALTER TABLE XPAC ADD XPAC_SHOWONROOMRACK NUMBER(1) DEFAULT 0 NOT NULL;

ALTER TABLE XPDA ADD XPDA_SHOWONROOMRACK NUMBER(1) DEFAULT 0 NOT NULL;




UPDATE YPRL SET YPRL_SOURCE=1 WHERE YPRL_FROMRATE=1;



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

CREATE SEQUENCE SEQ_XMBK INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YBCK INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YCBL INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUDL INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUDP INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUPS INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUSD INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUSL INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUSM INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUSP INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUSR INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YUSS INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YWRF INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_YWRS INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE SEQ_ZASP INCREMENT BY 1 START WITH 1001 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;



--- End of DBDiff for Oracle --- Elapsed Time: 00:13:28 ---
