--UPDATE FROM 8.9.5.5 TO 8.9.5.6


DROP TABLE VERSION_8_9_5_5;


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

CREATE TABLE WSPD
(
   WSPD_ID         NUMBER (30) NOT NULL,
   WSPD_DATE       DATE,
   WSPD_DOWNLOAD   VARCHAR2 (60),
   WSPD_UPLOAD     VARCHAR2 (60),
   WSPD_XCED_ID    NUMBER (30),
   CONSTRAINT WSPD_PK PRIMARY KEY (WSPD_ID) USING INDEX TABLESPACE V8INDEX
)
TABLESPACE V8MAIN;

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

COMMENT ON TABLE WSPD IS 'Table to store the results for speed test functionality in webSuite';

COMMENT ON COLUMN WSPD.WSPD_ID IS 'unique id';

COMMENT ON COLUMN WSPD.WSPD_DATE IS 'Date and time of speed test start';

COMMENT ON COLUMN WSPD.WSPD_DOWNLOAD IS 'Result of download speed';

COMMENT ON COLUMN WSPD.WSPD_UPLOAD IS 'Result of upload speed';

COMMENT ON COLUMN WSPD.WSPD_XCED_ID IS 'User ID of user who started speed test';

ALTER TABLE WPCA ADD WPCA_KIOSK_ZFST_ID NUMBER(30);

COMMENT ON COLUMN WPCA.WPCA_KIOSK_ZFST_ID IS 'Custom folio styles per Kiosk terminal';
