<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<AEUMUpdate>
  <Name>upd248</Name>
  <ApplicationID>APROP</ApplicationID>
  <Comment></Comment>
  <Version Major="6" Minor="7" Release="248" Build="1"/>
  <VersionMin Major="0" Minor="0" Release="0" Build="0"/>
  <FirstStep>2894</FirstStep>
  <FirebirdDialect>1</FirebirdDialect>
  <Step UpdateType="Query" StepNumber="2894" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="insert into dt_kl values(1700, 'Годишно разрешително', 1);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2895" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table documents&#xA;add DOC_SUMMERPRICE numeric(15,3);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2896" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table documents&#xA;add DOC_WINTERPRICE numeric(15, 3);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2897" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table anecs&#xA;add AN_SUMMERPRICE numeric(15, 3);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2898" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table anecs&#xA;add AN_WINTERPRICE numeric(15, 3)" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2899" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table values_calc&#xA;add VC_DESC_BLOB BLOB SUB_TYPE 1 SEGMENT SIZE 4096;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2900" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="update values_calc set VC_DESC_BLOB = VC_DESC;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2901" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table values_calc&#xA;drop VC_DESC;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2902" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table values_calc&#xA;alter VC_DESC_BLOB to VC_DESC;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2903" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="DELETE FROM system_strings WHERE sys_id = 14058;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2904" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Taxi&#xA;  ADD TAX_PRICE_WITHVAT NUMERIC(15,2),&#xA; ADD TAX_PRICE2_WITHVAT NUMERIC(15,2),&#xA;  ADD TAX_PRICE3_WITHVAT NUMERIC(15,2);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2905" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Taxi t&#xA;SET &#xA;	TAX_PRICE_WITHVAT =&#xA;	    ROUND(&#xA;	        t.TAX_PRICE *&#xA;	            (1 + (&#xA;	                SELECT CAST(TRIM(s.SYS_STR) AS DOUBLE PRECISION)&#xA;	                FROM SYSTEM_STRINGS s&#xA;	                WHERE s.SYS_ID = t.TAX_DDS) / 100.0),&#xA;	        2),&#xA;	TAX_PRICE2_WITHVAT =&#xA;	    ROUND(&#xA;	        t.TAX_PRICE2 *&#xA;	            (1 + (&#xA;	                SELECT CAST(TRIM(s.SYS_STR) AS DOUBLE PRECISION)&#xA;	                FROM SYSTEM_STRINGS s&#xA;	                WHERE s.SYS_ID = t.TAX_DDS) / 100.0),&#xA;	        2),&#xA;	TAX_PRICE3_WITHVAT =&#xA;	    ROUND(&#xA;	        t.TAX_PRICE3 *&#xA;	            (1 + (&#xA;	                SELECT CAST(TRIM(s.SYS_STR) AS DOUBLE PRECISION)&#xA;	                FROM SYSTEM_STRINGS s&#xA;	                WHERE s.SYS_ID = t.TAX_DDS) / 100.0),&#xA;	        2)&#xA;WHERE t.TAX_DDS &gt; 1200;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2906" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE system_strings SET sys_str = '6.7.248.1' WHERE sys_id = 1401;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
</AEUMUpdate>
