<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<AEUMUpdate>
  <Name>upd063</Name>
  <ApplicationID>ATARGOVIA</ApplicationID>
  <Archive>false</Archive>
  <Comment></Comment>
  <Version Major="1" Minor="5" Release="63" Build="1"/>
  <VersionMin Major="1" Minor="5" Release="62" Build="1"/>
  <FirstStep>1117</FirstStep>
  <FirebirdDialect>3</FirebirdDialect>
  <Step UpdateType="Query" StepNumber="1117" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE PAYMENT&#xA;    ADD P_INFO BLOB SUB_TYPE 1 SEGMENT SIZE 80,&#xA;	ADD P_INVOICEID INTEGER,&#xA;    ADD P_INVOICENUMBERS BLOB SUB_TYPE 1 SEGMENT SIZE 80,&#xA;	ADD P_INVOICEDATE DATE;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1118" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE PAYMENT SET P_INVOICEID=P_FID;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1119" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE PAYMENT_HIST&#xA;    ADD P_INFO BLOB SUB_TYPE 1 SEGMENT SIZE 80,&#xA;	ADD P_INVOICEID INTEGER,&#xA;    ADD P_INVOICENUMBERS BLOB SUB_TYPE 1 SEGMENT SIZE 80,&#xA;	ADD P_INVOICEDATE DATE;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1120" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE PAYMENT_HIST SET P_INVOICEID=P_FID;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="DLL" StepNumber="1121" DllName="upd063_aeum.dll" DllProcName="DoIt" PostgreSQL="" OracleSQL="" FirebirdSQL="" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1122" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="create or alter procedure AGETLASTPAY (&#xA;    AID integer,&#xA;    ATYPE integer)&#xA;returns (&#xA;    OUTID integer)&#xA;as&#xA;begin&#xA;  select max(payinner.p_num) from payment payinner  where (payinner.p_id=:aid) and&#xA;   (payinner.p_type=:atype) and (payinner.p_flags like &quot;__0%&quot;)&#xA;   and (payinner.P_INVOICENUMBERS is not null)&#xA;  into :outid;&#xA;  suspend;&#xA;end&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1123" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE PAYMENT &#xA;    DROP P_COMMENT, &#xA;	DROP P_FID,&#xA;	DROP P_FNUM, &#xA;	DROP P_FDATE;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1124" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE PAYMENT_HIST&#xA;    DROP P_COMMENT, &#xA;	DROP P_FID,&#xA;	DROP P_FNUM, &#xA;	DROP P_FDATE;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1125" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="delete from system_strings where SYS_ID = 0;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1126" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="insert into system_strings (SYS_ID,SYS_STR) values (0,'1.5.63.1');&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
</AEUMUpdate>
