--UPDATE FROM 8.13.9.0 TO 8.13.10.0


 	
DROP TABLE VERSION_8_13_9_0;


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

ALTER TABLE ZRDF ADD ZRDF_FINANCIALACCOUNT NUMBER(1) DEFAULT 0;

COMMENT ON COLUMN ZRDF.ZRDF_FINANCIALACCOUNT IS 'Valid for financial accounts';

CREATE TABLE ZFAR
  (
    ZFAR_ID      NUMBER(30) NOT NULL,
    ZFAR_ZFAC_ID NUMBER(30) NOT NULL,
    ZFAR_ZRDF_ID NUMBER(30) NOT NULL
  )
  TABLESPACE v8main;

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

COMMENT ON TABLE ZFAR IS 'Financial Account Rebate Link';

COMMENT ON COLUMN ZFAR.ZFAR_ZFAC_ID IS 'Financial Account ID';

COMMENT ON COLUMN ZFAR.ZFAR_ZRDF_ID IS 'Rebate ID';

ALTER TABLE ZFAC ADD ZFAC_NOZRDF NUMBER(1) DEFAULT 0;
COMMENT ON COLUMN ZFAC.ZFAC_NOZRDF IS 'To remove rebate linking for financial account';

ALTER TABLE W8HP ADD W8HP_PW_NUMBER_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_NUMBER_REQUIRED IS '1:Atleast one number is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_UPPERALPHABET_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_UPPERALPHABET_REQUIRED IS '1:Atleast one upper alphabet is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_LOWERALPHABET_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_LOWERALPHABET_REQUIRED IS '1:Atleast one lower alphabet is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_SPECIALCHAR_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_SPECIALCHAR_REQUIRED IS '1:Atleast one special character is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_MINIMUMLENGTH NUMBER(2) DEFAULT 8;


ALTER TABLE W8HP ADD (W8HP_HIDE_CC_INFORMATION NUMBER(1) DEFAULT 1);
COMMENT ON COLUMN W8HP.w8hp_hide_cc_information is 'Identifies if credit card related fields should be hidden in webconnect. 1: Yes, 0: No'; 

ALTER TABLE MMOD ADD MMOD_API_KEY varchar2(100);
COMMENT ON COLUMN MMOD.MMOD_API_KEY IS 'MMOD_API_KEY is required for successful connection in some cases';
alter table FRES modify FRES_TRANSACTION_NUMBER VARCHAR2(50);
alter table FRES ADD FRES_RESPONSE_CODE_LARGETEXT CLOB;
comment on column fres.FRES_RESPONSE_CODE_LARGETEXT is 'Response code provided by the fiscal unit. It is used instead of FRES_RESPONSE_CODE when we expect large response.';

ALTER TABLE FRES ADD FRES_TRANSACTION_TYPE_ID NUMBER(1);
COMMENT ON COLUMN FRES.FRES_TRANSACTION_TYPE_ID IS '1:Bookin, 2: CheckIn, 3:CheckOut 4:Cancel Reservation, 5:Booking Expenses, 6:Occupnacy Update';

ALTER TABLE W8HP ADD W8HP_ENABLE_GOOGLE_HOTELADS NUMBER(1) DEFAULT 0;
COMMENT ON COLUMN W8HP.W8HP_ENABLE_GOOGLE_HOTELADS IS '1: Enable Google Hotel Ads functionality,  0: Disable Google Hotel Ads functionality';

ALTER TABLE W8HP ADD W8HP_GOOGLE_ADS_ACCOUNT_ID VARCHAR2(60);
ALTER TABLE W8HP ADD W8HP_GOOGLE_ADS_LABEL VARCHAR2(60);
ALTER TABLE W8HP ADD W8HP_GOOGLE_ADS_TRACKING_ID VARCHAR2(60);
COMMENT ON COLUMN W8HP.W8HP_GOOGLE_ADS_ACCOUNT_ID IS 'Google Hotel Ads Account ID'; 
COMMENT ON COLUMN W8HP.W8HP_GOOGLE_ADS_LABEL IS 'Google Hotel Ads Label'; 
COMMENT ON COLUMN W8HP.W8HP_GOOGLE_ADS_TRACKING_ID IS 'Google Hotel Ads Tracking ID'; 
