--UPDATE FROM 8.11.5.0 TO 8.11.6.0


 	
DROP TABLE VERSION_8_11_5_0;


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

ALTER TABLE ZTXC ADD ZTXC_EINVOICE_VATCODE VARCHAR2(10 byte);
COMMENT ON COLUMN ZTXC.ZTXC_EINVOICE_VATCODE is 'einvoice vatcode for italy Electronic Invoice';

alter table zinv modify ZINV_FISCALNUMBER varchar2(400);

ALTER TABLE W8HP ADD W8HP_PW_NUMBER_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_NUMBER_REQUIRED IS '1:Atleast one number is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_UPPERALPHABET_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_UPPERALPHABET_REQUIRED IS '1:Atleast one upper alphabet is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_LOWERALPHABET_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_LOWERALPHABET_REQUIRED IS '1:Atleast one lower alphabet is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_SPECIALCHAR_REQUIRED NUMBER(1) DEFAULT 1;
COMMENT ON COLUMN W8HP.W8HP_PW_SPECIALCHAR_REQUIRED IS '1:Atleast one special character is mandatory in the password and 0: Optional';

ALTER TABLE W8HP ADD W8HP_PW_MINIMUMLENGTH NUMBER(2) DEFAULT 8;
COMMENT ON COLUMN W8HP.W8HP_PW_MINIMUMLENGTH IS 'Minimum length of password';