<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<AEUMUpdate>
  <Name>upd249</Name>
  <ApplicationID>APROP</ApplicationID>
  <Comment></Comment>
  <Version Major="6" Minor="7" Release="249" Build="1"/>
  <VersionMin Major="0" Minor="0" Release="0" Build="0"/>
  <FirstStep>2907</FirstStep>
  <FirebirdDialect>1</FirebirdDialect>
  <Step UpdateType="Query" StepNumber="2907" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Persons&#xA;ADD per_deathdate DATE;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2908" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Persons &#xA;ADD per_lastlbdsyncat DATE DEFAULT '17.11.1898';" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2909" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Persons&#xA;SET per_lastlbdsyncat = CAST('17.11.1898' AS DATE)&#xA;WHERE per_lastlbdsyncat IS NULL;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2910" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Persons &#xA;ALTER COLUMN per_lastlbdsyncat SET NOT NULL;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2911" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Persons &#xA;ADD per_ispresentinlbd smallint DEFAULT 0;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2912" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Persons&#xA;SET per_ispresentinlbd = 0&#xA;WHERE per_ispresentinlbd IS NULL;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2913" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Persons &#xA;ALTER COLUMN per_ispresentinlbd SET NOT NULL;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2914" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Persons&#xA;ADD CONSTRAINT chk_per_ispresentinlbd&#xA;CHECK (per_ispresentinlbd IN (0, 1));" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2915" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE ASCENDING INDEX per_lbdsync_index&#xA;ON Persons (per_ispresentinlbd, per_lastlbdsyncat);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2916" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE system_strings SET sys_str = '6.7.249.1' WHERE sys_id = 1401;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
</AEUMUpdate>
