<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<AEUMUpdate>
  <Name>upd060</Name>
  <ApplicationID>ATARGOVIA</ApplicationID>
  <Archive>false</Archive>
  <Comment></Comment>
  <Version Major="1" Minor="5" Release="60" Build="1"/>
  <VersionMin Major="1" Minor="5" Release="59" Build="1"/>
  <FirstStep>1080</FirstStep>
  <FirebirdDialect>3</FirebirdDialect>
  <Step UpdateType="Query" StepNumber="1080" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE ROOMREG (&#xA;    RR_ID INTEGER NOT NULL,&#xA;    RR_DEALER INTEGER NOT NULL,&#xA;    RR_MANAGER INTEGER,&#xA;    RR_OBJECT INTEGER NOT NULL,&#xA;    RR_TYPE INTEGER NOT NULL,&#xA;    RR_NOTICE INTEGER,&#xA;    RR_CERTNUM VARCHAR(100),&#xA;    RR_CERTDATE DATE,&#xA;    RR_REGNUM VARCHAR(100),&#xA;	RR_REGDATE DATE,&#xA;	RR_STOPNUM VARCHAR(100),&#xA;	RR_STOPDATE DATE,&#xA;    RR_CAPACITY VARCHAR(100),&#xA;    RR_CAPACITY_INT INTEGER,&#xA;    RR_BEDS VARCHAR(100),&#xA;	RR_BEDS_INT INTEGER,&#xA;	RR_SEASON VARCHAR(100),&#xA;	RR_INPUTNUM VARCHAR(100),&#xA;	RR_INPUTDATE DATE,&#xA;    RR_COMMENT BLOB SUB_TYPE 1);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1081" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE ROOMREG ADD CONSTRAINT PK_ROOMREG PRIMARY KEY (RR_ID);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1082" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR GEN_ROOMREG_ID;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1083" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="create trigger ROOMREG_bi for ROOMREG&#xA;active before insert position 0&#xA;as&#xA;begin&#xA;  if (new.rr_id is null) then&#xA;    new.rr_id = gen_id(gen_ROOMREG_id,1);&#xA;end&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1084" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON ROOMREG TO PUBLIC&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1085" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE ROOMREG_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;    RR_ID INTEGER NOT NULL,&#xA;    RR_DEALER INTEGER NOT NULL,&#xA;    RR_MANAGER INTEGER NOT NULL,&#xA;    RR_OBJECT INTEGER NOT NULL,&#xA;    RR_TYPE INTEGER NOT NULL,&#xA;    RR_NOTICE INTEGER,&#xA;    RR_CERTNUM VARCHAR(100),&#xA;    RR_CERTDATE DATE,&#xA;    RR_REGNUM VARCHAR(100),&#xA;	RR_REGDATE DATE,&#xA;	RR_STOPNUM VARCHAR(100),&#xA;	RR_STOPDATE DATE,&#xA;    RR_CAPACITY VARCHAR(100),&#xA;    RR_CAPACITY_INT INTEGER,&#xA;    RR_BEDS VARCHAR(100),&#xA;	RR_BEDS_INT INTEGER,&#xA;	RR_SEASON VARCHAR(100),&#xA;	RR_INPUTNUM VARCHAR(100),&#xA;	RR_INPUTDATE DATE,&#xA;    RR_COMMENT BLOB SUB_TYPE 1);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1086" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE ROOMREG_HIST ADD CONSTRAINT PK_ROOMREG_HIST PRIMARY KEY (ID);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1087" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE INDEX ROOMREG_HIST_HG ON ROOMREG_HIST (HISTORY_GROUP);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1088" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR GEN_HIST_ROOMREG_ID&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1089" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE OR ALTER TRIGGER ROOMREG_hist_bi for ROOMREG_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_ROOMREG_ID,1);&#xA;  if (new.HISTORY_DATE is null) then &#xA;    new.HISTORY_DATE = current_timestamp; &#xA;end&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1090" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON ROOMREG_HIST TO PUBLIC&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1091" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE ROOMREG_TYPE (&#xA;    RRT_ID INTEGER NOT NULL,&#xA;    RRT_TEXT VARCHAR(240) NOT NULL,&#xA;    RRT_NUMKIND INTEGER&#xA;)&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1092" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE ROOMREG_TYPE ADD CONSTRAINT PK_ROOMREG_TYPE PRIMARY KEY (RRT_ID);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1093" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR GEN_ROOMREG_TYPE_ID;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1094" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="create trigger ROOMREG_type_bi for ROOMREG_type&#xA;active before insert position 0&#xA;as&#xA;begin&#xA;  if (new.rrt_id is null) then&#xA;    new.rrt_id = gen_id(gen_ROOMREG_type_id,1);&#xA;end&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1095" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON ROOMREG_TYPE TO PUBLIC&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1096" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE TABLE ROOMREG_TYPE_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;    RRT_ID INTEGER NOT NULL,&#xA;    RRT_TEXT VARCHAR(240) NOT NULL,&#xA;    RRT_NUMKIND INTEGER&#xA;)&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1097" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE ROOMREG_TYPE_HIST ADD CONSTRAINT PK_ROOMREG_TYPE_HIST PRIMARY KEY (ID);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1098" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE GENERATOR GEN_HIST_ROOMREG_TYPE_ID;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1099" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="create trigger ROOMREG_TYPE_HIST_bi for ROOMREG_TYPE_HIST&#xA;active before insert position 0&#xA;as&#xA;begin&#xA;  if (new.ID is null) then &#xA;    new.id = gen_id(GEN_HIST_ROOMREG_TYPE_ID,1);&#xA;  if (new.HISTORY_DATE is null) then &#xA;    new.HISTORY_DATE = current_timestamp; &#xA;end&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1100" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="CREATE INDEX ROOMREG_TYPE_HIST_HG ON ROOMREG_TYPE_HIST (HISTORY_GROUP);&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1101" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="GRANT ALL ON ROOMREG_TYPE_HIST TO PUBLIC&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1102" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="INSERT INTO ROOMREG_TYPE (RRT_TEXT) VALUES ('Стая за гости');&#xA;INSERT INTO ROOMREG_TYPE (RRT_TEXT) VALUES ('Апартамент за гости');&#xA;INSERT INTO ROOMREG_TYPE_HIST (HISTORY_TYPE, HISTORY_GROUP, USER_ID, RRT_ID, RRT_TEXT) VALUES (1, 0, 1, 1, 'Стая за гости');&#xA;INSERT INTO ROOMREG_TYPE_HIST (HISTORY_TYPE, HISTORY_GROUP, USER_ID, RRT_ID, RRT_TEXT) VALUES (1, 0, 1, 2, 'Апартамент за гости');&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="true" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1103" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE ROOMREG&#xA;ADD CONSTRAINT FK_ROOMREG_DEALER&#xA;FOREIGN KEY (RR_DEALER)&#xA;REFERENCES FIRMS(F_ID)&#xA;ON DELETE SET NULL&#xA;ON UPDATE CASCADE&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1104" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE ROOMREG&#xA;ADD CONSTRAINT FK_ROOMREG_MANAGER&#xA;FOREIGN KEY (RR_MANAGER)&#xA;REFERENCES FIRMS(F_ID)&#xA;ON DELETE SET NULL&#xA;ON UPDATE CASCADE&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1105" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE ROOMREG&#xA;ADD CONSTRAINT FK_ROOMREG_OBJECT&#xA;FOREIGN KEY (RR_OBJECT)&#xA;REFERENCES OBJECTS(O_ID)&#xA;ON DELETE SET NULL&#xA;ON UPDATE CASCADE&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1106" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE OBJECTS ADD O_CADNUM VARCHAR(100)&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1107" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="ALTER TABLE OBJECTS_HIST ADD O_CADNUM VARCHAR(100)&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1108" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="delete from system_strings where SYS_ID = 0;&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
  <Step UpdateType="Query" StepNumber="1109" DllName="" DllProcName="" PostgreSQL="" OracleSQL="" FirebirdSQL="insert into system_strings (SYS_ID,SYS_STR) values (0,'1.5.60.1');&#xA;" PostgreMany="false" OracleMany="false" FirebirdMany="false" ContinueOnError="false"/>
</AEUMUpdate>
