--UPDATE FROM 8.11.3.1 TO 8.11.3.2


 	
DROP TABLE VERSION_8_11_3_1;


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

ALTER TABLE ZFST ADD ZFST_SEND_RT number(1);

comment on column zfst.zfst_send_rt is 'Send Folio Details to RT (Registratore Telematico)';

create table wrtp (
    wrtp_id number(30) not null
   ,wrtp_name VARCHAR2(30) not null
   ,wrtp_serialnumber varchar2(30) not null   
   ,wrtp_url varchar2(30) not null
   ,wrtp_fiscaldate date
   ,constraint wrtp_pk primary key (wrtp_id) using index tablespace v8index) tablespace v8main;

create sequence seq_wrtp increment by 1 start with 1000 nomaxvalue nocycle nocache noorder;

comment on table wrtp is 'Registratore Telematico (RT) printers for Italy';

comment on column wrtp.wrtp_serialnumber is 'Device Serial Number'; 

comment on column wrtp.wrtp_url is 'URL assgned to the printer' ; 

comment on column wrtp.wrtp_fiscaldate is 'Current Date, will be updated on Day Close' ;

alter table wpca add wpca_wrtp_id Number(30) ;

comment on column wpca.wpca_wrtp_id is 'linked Registratore Telematico Printer used in Italy' ;

alter table ztxc add ztxc_rtcode number(2);

comment on column ztxc.ztxc_rtcode is 'Registratore Telematico code' ;



