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

/*SQLStart>7026*/
create Table IncomeSettings (
  IncSetting_ID integer not null primary key,
  IncSetting_Str varchar(255)
);
/*SQLStop>7026*/

/*SQLStart>7027*/
alter table TAKINGTYPE 
  add TT_NumkindID smallint;
/*SQLStop>7027*/

/*SQLStart>7028*/
create Table Numkind_Nom (
  Numkind_id smallint not null primary key,
  Numkind_Prefix varchar(10),
  Numkind_Active char(1) default "T",
  Numkind_Value integer
);
/*SQLStop>7028*/

/*SQLStart>7029*/
create Generator Numkind_ID_Gen;
/*SQLStop>7029*/

/*ManyStart>7030*/
grant all on IncomeSettings to public;
grant all on Numkind_Nom to public;
/*ManyStop>7030*/