/*ALIAS>prop_db*/
/*Hist_TBL>SQL_UPDATES_INCOMES*/

/*SQLStart>000*/
CREATE TABLE SQL_UPDATES_INCOMES (
  SU_ID INTEGER NOT NULL,
  SU_NO INTEGER,
  SU_DATE DATE,
  SU_TEXT BLOB SUB_TYPE 0 SEGMENT SIZE 80,
  SU_FILENAME VARCHAR(100),
  SU_FILEDATE DATE,
  SU_COMPNAME VARCHAR(20),
  SU_USERNAME VARCHAR(20),
  PRIMARY KEY (SU_ID)
)
/*SQLStop>*/

/*SQLStart>000*/
create generator SUInc_Gen;
/*SQLStop>*/

/*SQLStart>000*/
CREATE TRIGGER SET_SUINC_ID FOR SQL_UPDATES_INCOMES BEFORE INSERT POSITION 0 AS
BEGIN
  New.SU_Id = Gen_Id(SUInc_gen,1);
END
/*SQLStop>*/

