--UPDATE FROM 8.7.3.1 TO 8.7.3.2


DROP TABLE VERSION_8_7_3_1;



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


ALTER TABLE MMOD ADD MMOD_FTP_PATH1 VARCHAR2(100);

COMMENT ON COLUMN MMOD.MMOD_FTP_PATH1 IS 'FTP Output path';

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

COMMENT ON COLUMN MMOD.MMOD_USE_NET_RATES IS 'Indicates the use of net rates. Default is gross rates';

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

COMMENT ON COLUMN MMOD.MMOD_HTTP_DOWNLOAD IS 'Indicates whether the listener is used also for downloads';

COMMENT ON COLUMN YHKS.YHKS_IFC_STATUS IS 'Obsolete column, YFVT is used instead';

CREATE TABLE MWSV
(
  MWSV_ID            NUMBER(30)                 NOT NULL,
  MWSV_MMOD_ID       NUMBER(30)                 NOT NULL,
  MWSV_SERVICE_NAME  VARCHAR2(100 BYTE)          NOT NULL,
  MWSV_URL           VARCHAR2(100 BYTE)         NOT NULL,
  CONSTRAINT MWSV_PK PRIMARY KEY (MWSV_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;

COMMENT ON COLUMN MWSV.MWSV_ID IS 'unique id';

COMMENT ON COLUMN MWSV.MWSV_MMOD_ID IS 'linkage to mmod';

COMMENT ON COLUMN MWSV.MWSV_SERVICE_NAME IS 'service name used to identify url in listener';

COMMENT ON COLUMN MWSV.MWSV_URL IS 'webservice url used for connection';

