/*ALIAS>prop_db*/

/*SQLstart>1420*/
ALTER TABLE OBUNITS
  add UNIT_PREFIX varchar(2);
/*SQLstop>*/

/*SQLstart>1421*/
update OBUNITS
  set UNIT_PREFIX = "";
/*SQLstop>*/

/*SQLstart>1422*/
alter table users add user_unitid integer;
/*SQLstop>*/

/*SQLstart>1423*/
update users set user_unitid = 0;
/*SQLstop>*/

/*SQLstart>1424*/
alter table Invoices
  add IN_PREFIX varchar(2) default "",
  add IN_OPERATORUNITID integer default 0;
/*SQLstop>*/

/*SQLstart>1425*/
update Invoices
  set IN_PREFIX = "", IN_OPERATORUNITID = 0;
/*SQLstop>*/