--UPDATE FROM 8.10.0.1 TO 8.10.0.10


DROP TABLE VERSION_8_10_0_1;


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


COMMENT ON COLUMN YRES.YRES_CALCSTATUS IS '0=expected(future) 1=expected today 2=checked in today 3=in house 4=exp dep today 5=departed today 6=history 7=day use exp 8=day use in house 9=day use history 10=waitlist 11=offer 12=cancelled 13=noshow 14=voucher template 15=day use exp today 16=day use departed today';

CREATE TABLE WRPN
(
WRPN_ID number(10) NOT NULL,
WRPN_GROUP_WRPT_ID NUMBER(10) NOT NULL,
WRPN_WRPT_ID NUMBER (10) NOT NULL,
WRPN_WLAN_ID NUMBER (10) NOT NULL
) TABLESPACE V8MAIN;

ALTER TABLE WRPN ADD CONSTRAINT WRPN_PK PRIMARY KEY (WRPN_ID) USING INDEX TABLESPACE V8INDEX;

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

COMMENT ON TABLE WRPN IS 'Report link table to link same purpose reports with different languages';

COMMENT ON COLUMN WRPN.WRPN_GROUP_WRPT_ID is 'main report';

COMMENT ON COLUMN WRPN.WRPN_WRPT_ID is 'linked report';

COMMENT ON COLUMN WRPN.WRPN_WLAN_ID is 'linked reports language';

