--Order 20014101.60

ALTER TABLE WEBMENUDIALOG
	ADD (BIANALYSIS VARCHAR2(80) NULL);

COMMENT ON COLUMN WEBMENUDIALOG.BIANALYSIS IS 'Name of the BI analysis, if needed preceded with the folder name. Relative path to BI base folder system setting.This column is only populated when the dialog_id is pointing to the dialog with code WebBIContent';

DROP INDEX XAK1WEBMENUDIALOG;

CREATE UNIQUE INDEX XAK1WEBMENUDIALOG ON WEBMENUDIALOG
(WEBMENUGROUP_ID   ASC,DIALOG_ID   ASC,BIANALYSIS   ASC);

ALTER TABLE CUSTOMER
	ADD (ENCRYPTEDID VARCHAR2(32)  DEFAULT 0 NOT NULL);

COMMENT ON COLUMN CUSTOMER.ENCRYPTEDID IS 'Encrypted version of existing column Customer_ID. For use in Web portal to pass as parameter to BI analysis in the URL';
