--UPDATE FROM 8.9.4.3 TO 8.9.4.4


DROP TABLE VERSION_8_9_4_3;



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

ALTER TABLE XMNR ADD XMNR_SIGNUPPROPERTY VARCHAR2(100 CHAR);

COMMENT ON COLUMN XMNR.XMNR_SIGNUPPROPERTY IS 'The property''s (hotel''s) name, where the membership enrollment happened ';

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

COMMENT ON COLUMN MMOD.MMOD_ALTERNATE_PROFILE_DATA  IS 'indicates the use of alternate profile data for names and address';

CREATE TABLE GHAG (
   GHAG_ID NUMBER(30) NOT NULL
  ,GHAG_WLAN_ID NUMBER(30)
  ,GHAG_NAME1 VARCHAR2(35)
  ,GHAG_NAME2 VARCHAR2(35)
  ,GHAG_NAME3 VARCHAR2(35)
  ,LASTMODIFIED DATE
  ,CONSTRAINT GHAG_PK PRIMARY KEY (GHAG_ID) USING INDEX TABLESPACE V8INDEX
) TABLESPACE V8MAIN;

COMMENT ON TABLE GHAG IS 'Alternate storage for profile xcms table';

CREATE TABLE GHAA (
   GHAA_ID NUMBER(30) NOT NULL
  ,GHAA_STREET1 VARCHAR2(60)
  ,GHAA_STREET2 VARCHAR2(60)
  ,GHAA_STREET3 VARCHAR2(60)
  ,GHAA_ZIP VARCHAR2(15)
  ,GHAA_CITY VARCHAR2(60)
  ,LASTMODIFIED DATE
  ,CONSTRAINT GHAA_PK PRIMARY KEY (GHAA_ID) USING INDEX TABLESPACE V8INDEX
) TABLESPACE V8MAIN;

COMMENT ON TABLE GHAA IS 'Alternate storage for profile adresses xadr table';

CREATE TABLE GHAD (
   GHAD_ID NUMBER(30) NOT NULL
  ,GHAD_TITLE VARCHAR2(30)
  ,GHAD_ADDRGREET VARCHAR2(30)
  ,GHAD_LETTGREET VARCHAR2(60)
  ,LASTMODIFIED DATE
  ,CONSTRAINT GHAD_PK PRIMARY KEY (GHAD_ID) USING INDEX TABLESPACE V8INDEX
) TABLESPACE V8MAIN;

COMMENT ON TABLE GHAD IS 'Alternate storage for individul profiles xcid table';

ALTER TABLE XCMG ADD XCMG_INACTIVE NUMBER(1) DEFAULT 0;

ALTER TABLE XCMG ADD XCMG_INACTIVE_TIMESTAMP DATE;

COMMENT ON COLUMN ZPOS.ZPOS_NOREPRINT IS '0-Posting is not on a valid folio | 1-The posting is printed on an invoice | 2-Posting is on a void invoice | 3-Posting has been voided';
