<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<AEUMUpdate>
  <Name>upd239</Name>
  <ApplicationID>APROP</ApplicationID>
  <Archive>false</Archive>
  <Comment></Comment>
  <Version Major="6" Minor="7" Release="239" Build="1"/>
  <VersionMin Major="0" Minor="0" Release="0" Build="0"/>
  <FirstStep>2804</FirstStep>
  <FirebirdDialect>1</FirebirdDialect>
  <Step UpdateType="Query" StepNumber="2804" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR PaymentChannels_ID_GEN;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2805" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="SET GENERATOR PaymentChannels_ID_GEN to 0;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2806" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE PaymentChannels(&#xA;	PC_ID INTEGER NOT NULL,&#xA;	PC_DisplayName VARCHAR(250) NOT NULL,&#xA;	PC_SystemName VARCHAR(250) NOT NULL&#xA;);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2807" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE PaymentChannels&#xA;ADD CONSTRAINT PC_PRIMARYKEY PRIMARY KEY (PC_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2808" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE UNIQUE INDEX PC_SN_Unique ON PaymentChannels (PC_SystemName);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2809" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE  TRIGGER Set_PaymentChannels_ID_GEN for PaymentChannels&#xA;BEFORE INSERT &#xA;AS&#xA;BEGIN&#xA;  new.PC_ID = gen_id(PaymentChannels_ID_GEN, 1);&#xA;END;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2810" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT all ON PaymentChannels to public;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2811" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Invoices&#xA;ADD IN_PaymentChannelID INTEGER;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2812" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Invoices&#xA;ADD CONSTRAINT FK_PaymentChannels_Invoices&#xA;FOREIGN KEY (IN_PaymentChannelID) REFERENCES PaymentChannels(PC_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2813" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE OR ALTER procedure INVOICEADDHEADER (&#xA;    IN_PERID integer,&#xA;    IN_PAYID integer,&#xA;    IN_PAYTYPE char(1),&#xA;    IN_PAYSUM numeric(15,2),&#xA;    IN_PAYCLEARSUM numeric(15,2),&#xA;    IN_PAYDDS numeric(15,2),&#xA;    IN_PAYLIHVI numeric(15,2),&#xA;    IN_PAYWAY char(1),&#xA;    IN_COMMENT blob sub_type 1 segment size 4096,&#xA;    IN_PAYTEXT varchar(250),&#xA;    IN_OPERATORID integer,&#xA;    IN_OBMOL varchar(50),&#xA;    IN_PERPAYFROM varchar(50),&#xA;    IN_PAYNODDSSUM numeric(15,2),&#xA;    IN_PAYDDSSUM numeric(15,2),&#xA;    IN_FACTOR numeric(15,2),&#xA;    IN_PAYDATE date,&#xA;    IN_REALPAYDATE date,&#xA;    IN_NODDSDESCR varchar(255),&#xA;    IN_DDSEVENTDATE date,&#xA;    IN_PAYMENTCHANNELID integer)&#xA;returns (&#xA;    IN_ID integer)&#xA;as&#xA;declare variable IN_OPERATORNAME varchar(140);&#xA;declare variable IN_PERNAME varchar(140);&#xA;declare variable IN_PERADDR varchar(250);&#xA;declare variable IN_PERNM varchar(30);&#xA;declare variable IN_PEREGN varchar(15);&#xA;declare variable IN_PERDANN varchar(10);&#xA;declare variable IN_PERMOLNAME varchar(140);&#xA;declare variable IN_PERINDDS varchar(15);&#xA;declare variable IN_PER_ADDR_CORESP varchar(250);&#xA;declare variable IN_PER_TDNAP varchar(20);&#xA;declare variable IN_PER_TDNAP_ADDR varchar(50);&#xA;begin&#xA;  /* wzima se imeto na kasiera */&#xA;  select USER_STR from users&#xA;  where USER_ID = :IN_OperatorID&#xA;  into :IN_OperatorName;&#xA;&#xA;  /* wzimat se dannite na personata */&#xA;  select PerName, PerEgn, PerDanN, PerAddr, PerNM, PerMolName, PerINDDS, PerAddr_Coresp, PerTDNap, PerTDNap_Addr&#xA;  from PersonGetInfo(:IN_PerID)&#xA;  into :IN_PerName, :IN_PerEgn, :IN_PerDanN, :IN_PerAddr, :IN_PerNM, :IN_PERMOLNAME, :IN_PERINDDS,&#xA;  :IN_PER_ADDR_CORESP, :IN_PER_TDNAP, :IN_PER_TDNAP_ADDR;&#xA;&#xA;  if (IN_PAYDATE &lt; &quot;01.01.1990&quot; ) then&#xA;    IN_PayDate = &quot;NOW&quot;;&#xA;&#xA;  if (IN_DDSEVENTDATE &lt; &quot;01.01.1990&quot; ) then&#xA;    IN_DDSEVENTDATE = IN_PayDate;&#xA;  &#xA;  IN_ID = GEN_ID(IN_ID_GEN, 1);&#xA;  insert into Invoices (IN_ID, IN_PERID, IN_PERNAME, IN_PERADDR, IN_PERNM, IN_PEREGN,&#xA;                        IN_PERDANN, IN_PERMOLNAME, IN_PAYTYPE, IN_PAYTEXT, IN_PAYID,&#xA;                        IN_PAYSUM, IN_PAYDDS, IN_OPERATORID, IN_OPERATORNAME, IN_PAYLIHVI,&#xA;                        IN_PAYWAY, IN_ANUL, IN_COMMENT, IN_PAYCLEARSUM,&#xA;                        IN_OBMOL, IN_REAL, IN_PerPayFrom,&#xA;                        IN_PayDDSSum, IN_PayNoDDSSum, IN_FACTOR, IN_PAYDATE, IN_REALPAYDATE, &#xA;                        IN_PERINDDS, IN_FLAG2007, IN_NODDSDESCR, IN_DDSEVENTDATE,&#xA;                        IN_PER_ADDR_CORESP, IN_PER_TDNAP, IN_PER_TDNAP_ADDR, IN_PAYMENTCHANNELID)&#xA;  values               (:IN_ID, :IN_PERID, :IN_PERNAME, :IN_PERADDR, :IN_PERNM, :IN_PEREGN,&#xA;                        :IN_PERDANN, :IN_PERMOLNAME, :IN_PAYTYPE, :IN_PAYTEXT, :IN_PAYID,&#xA;                        :IN_PAYSUM, :IN_PAYDDS, :IN_OPERATORID, :IN_OPERATORNAME, :IN_PAYLIHVI,&#xA;                        :IN_PAYWAY, &quot;A&quot;, :IN_COMMENT, :IN_PAYCLEARSUM,&#xA;                        :IN_OBMOL, &quot;F&quot;, :IN_PerPayFrom,&#xA;                        :IN_PayDDSSum, :IN_PayNoDDSSum, :IN_FACTOR, :IN_PAYDATE, :IN_REALPAYDATE,&#xA;                        :IN_PERINDDS, &quot;T&quot;, :IN_NODDSDESCR, :IN_DDSEVENTDATE,&#xA;                        :IN_PER_ADDR_CORESP, :IN_PER_TDNAP, :IN_PER_TDNAP_ADDR, :IN_PAYMENTCHANNELID);&#xA;  &#xA;  suspend;&#xA;end;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2814" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="insert into users (user_id, user_unitid, user_str, user_name, user_active_kasa, user_active_rents, user_active_properties, user_active_incomes)&#xA;values (0, 0, 'Системен потребител', 'Системен потребител', 1, 1, 1, 1);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2815" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Invoices&#xA;SET IN_OPERATORID = 0, IN_OPERATORNAME = 'Системен потребител'&#xA;WHERE IN_OPERATORID = 9999;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2816" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Invoices inv&#xA;SET inv.IN_OPERATORID = 0, inv.IN_OPERATORNAME = COALESCE(inv.IN_OPERATORNAME, 'Системен потребител')&#xA;WHERE not exists(SELECT 1 FROM users u WHERE u.USER_ID = inv.IN_OPERATORID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2817" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Payment&#xA;SET P_USERID = 0, P_OPERATORNAME = 'Системен потребител'&#xA;WHERE P_USERID = 9999;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2818" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Payment pm&#xA;SET pm.P_USERID = 0, pm.P_OPERATORNAME = COALESCE(pm.P_OPERATORNAME, 'Системен потребител')&#xA;WHERE not exists(SELECT 1 FROM users u WHERE u.USER_ID = pm.P_USERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2819" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Daypayments&#xA;SET DP_OPID = 0&#xA;WHERE DP_OPID = 9999;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2820" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Daypayments dps&#xA;SET dps.DP_OPID = 0&#xA;WHERE not exists(SELECT 1 FROM users u WHERE u.USER_ID = dps.DP_OPID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2821" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE PayTaking&#xA;SET PT_OperatorID = 0&#xA;WHERE PT_OperatorID = 9999;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2822" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE PayTaking pt&#xA;SET pt.PT_OperatorID = 0&#xA;WHERE not exists(SELECT 1 FROM users u WHERE u.USER_ID = pt.PT_OperatorID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2823" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="DELETE FROM Users&#xA;WHERE USER_ID = 9999;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2824" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Invoices&#xA;ADD CONSTRAINT FK_Users_Invoices&#xA;FOREIGN KEY (IN_OPERATORID) REFERENCES Users(USER_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2825" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Payment&#xA;ADD CONSTRAINT FK_Users_Payments&#xA;FOREIGN KEY (P_USERID) REFERENCES Users(USER_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2826" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Daypayments&#xA;ADD CONSTRAINT FK_Users_Daypayments&#xA;FOREIGN KEY (DP_OPID) REFERENCES Users(USER_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2827" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE PayTaking&#xA;ADD CONSTRAINT FK_Users_PayTakings&#xA;FOREIGN KEY (PT_OperatorID) REFERENCES Users(USER_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2828" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Transactions&#xA;SET TR_STATE = 2&#xA;WHERE TR_STATE = 3;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2829" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Indetail ind&#xA;SET ind.ID_MASTERINVOICE = 0&#xA;WHERE (ind.ID_MASTERINVOICE &gt; (SELECT MAX(inv.IN_ID) FROM Invoices inv));" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2830" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Payment&#xA;ADD CONSTRAINT FK_Transactions_Payments&#xA;FOREIGN KEY (P_TRANSACTION_ID) REFERENCES Transactions(TR_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2831" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Renttypes rt&#xA;SET rt.RT_UNITID = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = rt.RT_UNITID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2832" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Renttypes rt&#xA;SET rt.RT_UNITID_L = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = rt.RT_UNITID_L);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2833" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Renttypes rt&#xA;SET rt.RT_UNITID_D = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = rt.RT_UNITID_D);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2834" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Renttypes&#xA;ADD CONSTRAINT FK_Obunits_Renttypes&#xA;FOREIGN KEY (RT_UNITID) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2835" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Renttypes&#xA;ADD CONSTRAINT FK_Obunits_L_Renttypes&#xA;FOREIGN KEY (RT_UNITID_L) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2836" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Renttypes&#xA;ADD CONSTRAINT FK_Obunits_D_Renttypes&#xA;FOREIGN KEY (RT_UNITID_D) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2837" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Indetail ind&#xA;SET ind.ID_UNITID = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = ind.ID_UNITID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2838" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Indetail ind&#xA;SET ind.ID_UNITID_L = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = ind.ID_UNITID_L);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2839" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Indetail ind&#xA;SET ind.ID_UNITID_D = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = ind.ID_UNITID_D);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2840" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Indetail&#xA;ADD CONSTRAINT FK_Obunits_Indetail&#xA;FOREIGN KEY (ID_UNITID) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2841" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Indetail&#xA;ADD CONSTRAINT FK_Obunits_L_Indetail&#xA;FOREIGN KEY (ID_UNITID_L) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2842" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Indetail&#xA;ADD CONSTRAINT FK_Obunits_D_Indetail&#xA;FOREIGN KEY (ID_UNITID_D) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2843" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Invoices inv&#xA;SET inv.IN_OBUNIT = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = inv.IN_OBUNIT);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2844" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Invoices inv&#xA;SET inv.IN_OPERATORUNITID = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = inv.IN_OPERATORUNITID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2845" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Invoices&#xA;ADD CONSTRAINT FK_Obunits_Invoices&#xA;FOREIGN KEY (IN_OBUNIT) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2846" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Invoices&#xA;ADD CONSTRAINT FK_Obunits_O_Invoices&#xA;FOREIGN KEY (IN_OPERATORUNITID) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2847" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Daypayments dps&#xA;SET dps.DP_UNITID = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = dps.DP_UNITID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2848" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Daypayments dps&#xA;SET dps.DP_OPERATORUNITID = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = dps.DP_OPERATORUNITID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2849" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Daypayments &#xA;ADD CONSTRAINT DP_UID_NOTNULL &#xA;check (DP_UNITID is not null);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2850" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Daypayments &#xA;ADD CONSTRAINT DP_OUID_NOTNULL &#xA;check (DP_OPERATORUNITID is not null);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2851" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Daypayments&#xA;ADD CONSTRAINT FK_Obunits_Daypayments&#xA;FOREIGN KEY (DP_UNITID) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2852" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Daypayments&#xA;ADD CONSTRAINT FK_Obunits_O_Daypayments&#xA;FOREIGN KEY (DP_OPERATORUNITID) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2853" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE Users u&#xA;SET u.USER_UNITID = 0&#xA;WHERE not exists(SELECT 1 FROM Obunits obs WHERE obs.unit_perid = u.USER_UNITID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2854" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE Users&#xA;ADD CONSTRAINT FK_Obunits_Users&#xA;FOREIGN KEY (USER_UNITID) REFERENCES Obunits(UNIT_PERID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2855" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="UPDATE system_strings SET sys_str = '6.7.239.1' WHERE sys_id = 1401;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
</AEUMUpdate>
