--UPDATE FROM 8.9.2.1 TO 8.9.2.2


DROP TABLE VERSION_8_9_2_1;



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

ALTER TABLE YSEC ADD YSEC_DISPLORDER NUMBER(3);

COMMENT ON COLUMN YSEC.YSEC_DISPLORDER IS 'Display Order';

COMMENT ON COLUMN WPHS.WPHS_CRS_ROLE IS '1=central 2=mirror 3=partner 4=direct partner null=no crs functionality';

ALTER TABLE XCCS MODIFY XCCS_ISSUE_DATE VARCHAR2(6);

ALTER TABLE MMOD ADD MMOD_NOGUESTS_ALLOWED NUMBER(1);

COMMENT ON COLUMN MMOD.MMOD_NOGUESTS_ALLOWED IS 'indicates whether a reservation can be created with number of guests 0. Default = No';

ALTER TABLE MMOD ADD MMOD_USE_FA NUMBER(1);

COMMENT ON COLUMN MMOD.MMOD_USE_FA IS 'indicates whether a finacial account will be created for a new group. Default = Yes';

ALTER TABLE SHIS ADD SHIS_YDET_YCAT_ID_RATE NUMBER(30);

ALTER TABLE SHIS ADD SHIS_YCAT_SHORTDESC_RATE Varchar2(30);

CREATE TABLE YFBK ( 
 YFBK_OBJECT_ID VARCHAR2(30) NOT NULL 
,YFBK_NAME VARCHAR2(100) 
,YFBK_ACCESSTOKEN VARCHAR2(200) 
,YFBK_TYPE NUMBER (1) 
,YFBK_LASTUSED NUMBER (1) 
,YFBK_LASTLOGIN DATE
,YFBK_DISPLORDER NUMBER (2) 
,CONSTRAINT YFBK_PK PRIMARY KEY (YFBK_OBJECT_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

COMMENT ON TABLE YFBK IS 'Facebook accounts table';

ALTER TABLE WGBS ADD WGBS_ACCESSDENY NUMBER(1); 

ALTER TABLE W8HP ADD W8HP_USERATEMARKET NUMBER(1);

COMMENT ON COLUMN W8HP.W8HP_USERATEMARKET IS 'S8HP should user rate market code if it is defined';

ALTER TABLE TCCR MODIFY TCCR_VALUE NUMBER(30,4);

ALTER TABLE ZDCL ADD ZDCL_POSTONLYIFMANUAL NUMBER(1);

COMMENT ON COLUMN ZDCL.ZDCL_POSTONLYIFMANUAL IS 'Post Citytax only for manual postings';

ALTER TABLE YEVM ADD YEVM_MANUALDISPLORDER NUMBER(1);

COMMENT ON COLUMN YEVM.YEVM_MANUALDISPLORDER IS 'Display order manually changed by user';

ALTER TABLE SHIB MODIFY SHIB_YBOM_NOOFATTENDEES NUMBER(5);

ALTER TABLE SHIE MODIFY SHIE_YEVM_NOOFATTENDEES NUMBER(5);
