--UPDATE FROM 8.8.1.0 TO 8.8.1.1


DROP TABLE VERSION_8_8_1_0;



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


COMMENT ON COLUMN YETG.YETG_ID IS 'Event Group ID';

COMMENT ON COLUMN YETG.YETG_SHORTDESC IS 'Event group short description';

COMMENT ON COLUMN YETG.YETG_NAME IS 'Event group name';

COMMENT ON COLUMN YETG.YETG_VALIDFROM IS 'Event group valid start date';

COMMENT ON COLUMN YETG.YETG_VALIDTO IS 'Event group valid end date';

COMMENT ON COLUMN YETG.YETG_DISPLORDER IS 'Event group display order';

COMMENT ON COLUMN YETG.YETG_INACTIVE IS 'Event group inactive flag';

COMMENT ON COLUMN YETE.YETE_ID IS 'Event group Event ID';

COMMENT ON COLUMN YETE.YETE_YETG_ID IS 'Event group ID';

COMMENT ON COLUMN YETF.YETF_YETE_ID IS 'Event group ID';

COMMENT ON COLUMN YETR.YETR_YETE_ID IS 'Linked Event group ID';

COMMENT ON COLUMN YETM.YETM_YETE_ID IS 'Linked Event group ID';

COMMENT ON COLUMN YETB.YETB_ID IS 'Booked Event group ID';

COMMENT ON COLUMN YETB.YETB_YETG_ID IS 'Event group ID';

COMMENT ON COLUMN YETB.YETB_NAME IS 'Booked Event group Name';

COMMENT ON COLUMN YETB.YETB_NOOFATTENDEES IS 'Booked Event group Number of Attendees';

COMMENT ON COLUMN YETB.YETB_STARTTIME IS 'Booked Event group Start Date';

COMMENT ON COLUMN YETB.YETB_ENDTIME IS 'Booked Event group End Date';

COMMENT ON COLUMN YETB.YETB_COPIEDFROM_YETB_ID IS 'Booked Event group copied ID';

COMMENT ON COLUMN YEVM.YEVM_YETB_ID IS 'Event group link ID';

COMMENT ON TABLE YETG IS 'Event Groups';

COMMENT ON TABLE YETE IS 'Event Group Events';

COMMENT ON TABLE YETF IS 'Event Group Function Spaces';

COMMENT ON TABLE YETM IS 'Event Group Std. Menus';

COMMENT ON TABLE YETB IS 'Booked Event Groups';

COMMENT ON TABLE YETR IS 'Event Group Misc. Items';

CREATE TABLE ZOTA
(
  ZOTA_ID         NUMBER(30) NOT NULL, 
  ZOTA_NAME       VARCHAR2(30) NOT NULL,
  ZOTA_URL    	  VARCHAR2(120) NOT NULL,
  ZOTA_YALG_ID    NUMBER(30),
  ZOTA_AGENTSINE  VARCHAR2(60),
  ZOTA_AGENTDUTYCODE VARCHAR2(60),
  ZOTA_REQUESTORURL VARCHAR2(60),
  ZOTA_REQUESTORTYPE VARCHAR2(30),
  ZOTA_REQUESTORID VARCHAR2(30),
  ZOTA_INACTIVE   NUMBER(1),
  ZOTA_OVERBOOKING NUMBER(1),
  ZOTA_TENTATIVE NUMBER(1),
  CONSTRAINT ZOTA_PK PRIMARY KEY (ZOTA_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;
  
COMMENT ON TABLE ZOTA IS 'Configuration of Upload OTA spec based Availability messages';  

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

ALTER TABLE WRPB ADD WRPB_MANUALSETLOCATION NUMBER (1);

COMMENT ON COLUMN WRPB.WRPB_MANUALSETLOCATION IS 'No automatic setlocation on demand when running report every time';

CREATE TABLE YTAA (
   YTAA_ID NUMBER(30) NOT NULL
  ,YTAA_YTAW_ID NUMBER(30) NOT NULL
  ,YTAA_XPDA_ID NUMBER(30) NOT NULL
  ,CONSTRAINT YTAA_PK PRIMARY KEY (YTAA_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;

COMMENT ON TABLE YTAA IS 'turnaway apptributes';

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

ALTER TABLE XPAC ADD XPAC_APPLTURNAWAY NUMBER(1);

ALTER TABLE YTAA ADD YTAA_XPAC_ID NUMBER(30);

UPDATE YTAA SET YTAA_XPAC_ID=(SELECT XPDA_XPAC_ID FROM XPDA WHERE XPDA_ID=YTAA_XPDA_ID);

ALTER TABLE WPCA ADD WPCA_CASH_DRAWER_BAUD NUMBER(5);

COMMENT ON COLUMN WPCA.WPCA_CASH_DRAWER_BAUD IS 'Cash Drawer baud rate';

ALTER TABLE WPCA ADD WPCA_CASH_DRAWER_NULLS NUMBER(2);

COMMENT ON COLUMN WPCA.WPCA_CASH_DRAWER_NULLS IS 'Cash Drawer. Amount of nulls to init';

ALTER TABLE WPCA ADD WPCA_CASH_DRAWER_STRING VARCHAR(20);

COMMENT ON COLUMN WPCA.WPCA_CASH_DRAWER_STRING IS 'Cash Drawer. String to send';

ALTER TABLE WPCA ADD WPCA_CASH_DRAWER_SLEEP NUMBER(2);

COMMENT ON COLUMN WPCA.WPCA_CASH_DRAWER_STRING IS 'Cash Drawer. Sleep time';
