<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<AEUMUpdate>
  <Name>upd059</Name>
  <ApplicationID>ATARGOVIA</ApplicationID>
  <Archive>false</Archive>
  <Comment></Comment>
  <Version Major="1" Minor="5" Release="59" Build="1"/>
  <VersionMin Major="1" Minor="5" Release="58" Build="1"/>
  <FirstStep>1062</FirstStep>
  <Step UpdateType="Query" StepNumber="1062" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE CHAR_KL (&#xA;    CHAR_ID INTEGER NOT NULL,&#xA;    CHAR_REG INTEGER NOT NULL,&#xA;    CHAR_TEXT VARCHAR(240) NOT NULL);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1063" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE CHAR_KL ADD CONSTRAINT PK_CHAR_KL PRIMARY KEY (CHAR_ID)" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1064" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE INDEX CHAR_KL_REG_IDX ON CHAR_KL (CHAR_REG);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1065" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE CHAR_KL_HIST (&#xA;    ID             INTEGER NOT NULL,&#xA;    HISTORY_DATE   DATE NOT NULL,&#xA;    HISTORY_TYPE   INTEGER NOT NULL,&#xA;    HISTORY_GROUP  INTEGER DEFAULT 0 NOT NULL,&#xA;    USER_ID        INTEGER NOT NULL,&#xA;    CHAR_ID INTEGER NOT NULL,&#xA;    CHAR_REG INTEGER NOT NULL,&#xA;    CHAR_TEXT VARCHAR(240) NOT NULL);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1066" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE CHAR_KL_HIST ADD PRIMARY KEY (ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1067" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE INDEX CHAR_KL_HIST_REG_IDX ON CHAR_KL_HIST (CHAR_REG);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1068" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE INDEX CHAR_KL_HIST_HG ON CHAR_KL_HIST (HISTORY_GROUP);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1069" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR GEN_HIST_CHAR_KL_ID" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1070" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE OR ALTER TRIGGER char_kl_hist_bi for char_kl_hist&#xA;ACTIVE BEFORE INSERT OR UPDATE POSITION 0&#xA;as&#xA;begin&#xA;  if (new.ID is null) then &#xA;    new.id = gen_id(GEN_HIST_CHAR_KL_ID,1);&#xA;  if (new.HISTORY_DATE is null) then &#xA;    new.HISTORY_DATE = current_timestamp; &#xA;end" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1071" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON CHAR_KL TO PUBLIC" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1072" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON CHAR_KL_HIST TO PUBLIC" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1073" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE CHAR_TBL (&#xA;    REGISTER_ID INTEGER NOT NULL,&#xA;	REGISTER_TYPE INTEGER NOT NULL,&#xA;    CHAR_ID INTEGER NOT NULL);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1074" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE CHAR_TBL ADD CONSTRAINT PK_CHAR_TBL PRIMARY KEY (REGISTER_ID,REGISTER_TYPE,CHAR_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1075" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON CHAR_TBL TO PUBLIC;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1076" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE OBJECTREGISTER&#xA;    ADD OR_CERTOPER VARCHAR(240),&#xA;    ADD OR_CERTOPERDATE DATE;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1077" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE OBJECTREGISTER_HIST&#xA;    ADD OR_CERTOPER VARCHAR(240),&#xA;    ADD OR_CERTOPERDATE DATE;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1078" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="delete from system_strings where SYS_ID = 0;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1079" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="insert into system_strings (SYS_ID,SYS_STR) values (0,'1.5.59.1');" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
</AEUMUpdate>
