<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<AEUMUpdate>
  <Name>upd236</Name>
  <ApplicationID>APROP</ApplicationID>
  <Archive>false</Archive>
  <Comment></Comment>
  <Version Major="6" Minor="7" Release="236" Build="1"/>
  <VersionMin Major="6" Minor="7" Release="236" Build="1"/>
  <FirstStep>2777</FirstStep>
  <Step UpdateType="Query" StepNumber="2777" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="create table TRANSACTIONS
(TR_ID INTEGER NOT NULL,
TR_UNIQUE_KEY VARCHAR(200),
TR_STARTDATE DATE,
TR_ENDTDATE DATE,
TR_VALUE NUMERIC(15, 2),
TR_STATE INTEGER,
TR_LOG BLOB SUB_TYPE 1 SEGMENT SIZE 4096,
constraint pk_transaction primary key(TR_ID));" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="true"/>
  <Step UpdateType="Query" StepNumber="2778" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON TRANSACTIONS TO PUBLIC;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2779" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR TRANSACTION_ID_GEN;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2780" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="SET GENERATOR TRANSACTION_ID_GEN TO 0;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2781" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="create unique index ix_unique_key on TRANSACTIONS(TR_UNIQUE_KEY);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2782" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE table TRANSACTION_DOCUMENT
(TD_DOC_ID INTEGER NOT NULL,
TD_TRANSACTION_ID INTEGER NOT NULL,
td_value  NUMERIC(15,2),
constraint fk_trans_docs foreign key(TD_DOC_ID) references documents(doc_id),
constraint fk_transaction foreign key(TD_TRANSACTION_ID) references transactions(TR_ID));" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2783" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON TRANSACTION_DOCUMENT TO PUBLIC;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2784" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table payment
add P_TRANSACTION_ID integer;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2785" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE LOCKS
(L_ID integer not null,
 L_TYPE VARCHAR(100) not null);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2786" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE LOCKS ADD PRIMARY KEY (L_ID, L_TYPE);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2787" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON LOCKS TO PUBLIC;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2788" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="alter table doccounts
drop constraint PK_DOCCOUNTS;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2789" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="drop trigger DOCCOUNTS_BIU;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2790" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE doccounts
add DC_PK_ID INTEGER NOT NULL;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2791" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE DOCCOUNTS ADD CONSTRAINT PK_DC_PK_ID PRIMARY KEY (DC_PK_ID);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2792" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE DOCCOUNTS ADD CONSTRAINT UNQ_DOCCOUNTS UNIQUE (DC_ID, DC_DOCTYPE);" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2793" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR DOCCOUNTS_ID_GEN;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2794" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="SET GENERATOR DOCCOUNTS_ID_GEN TO 0;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="DLL" StepNumber="2795" DllName="upd236.dll" DllProcName="SetDoccountsPrimaryKeys" PostgreSQL="" OracleSQL="" FirebirdSQL="insert into users (user_id, user_unitid, user_str, user_name, user_active_kasa)
values (9999, 0, 'Онлайн каса', 'Онлайн каса', 1);
" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="true"/>
  <Step UpdateType="Query" StepNumber="2796" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="insert into users (user_id, user_unitid, user_str, user_name, user_active_kasa)
values (9999, 0, 'Онлайн каса', 'Онлайн каса', 1);
" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="2797" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="update system_strings set sys_str = '6.7.236.1' where sys_id = 1401;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
</AEUMUpdate>
