/*ALIAS>prop_db*/

/*SQLStart>2695*/
ALTER TABLE taxorders
ADD TO_CANCELED DATE;
/*SQLStop*/

/*SQLStart>2696*/
ALTER TABLE taxorders
ADD TO_CANCELREASON  VARCHAR(240);
/*SQLStop*/

/*SQLStart>2697*/
INSERT INTO SYSTEM_STRINGS  (sys_id, sys_str) VALUES (14025,'');
/*SQLStop*/

/*SQLStart>2698*/
insert into blobsettings VALUES (1, 14026, null);
/*SQLStop*/


/*SQLStart>2699*/
ALTER TABLE TAXORDERS
DROP to_checkexpired;
/*SQLStop*/

/*SQLStart>2700*/
CREATE OR ALTER TRIGGER taxorders_bi for taxorders
active before insert position 0
AS
begin
  NEW.TO_OrderDate = "NOW";
  NEW.TO_PayOpID = 0;
  NEW.TO_Paid = "F";
end
/*SQLStop*/

/*SQLStart>2701*/
ALTER TABLE TAXORDERS
DROP TO_ANUL;
/*SQLStop*/

/*SQLStart>2702*/
INSERT INTO system_strings
VALUES (14024, '0');
/*SQLStop*/

/*SQLStart>2703*/
update system_strings set sys_str = '6.7.219.1' where sys_id = 1401;  /*BackOffice*/
/*SQLStop*/
