CREATE TABLE CARD_INFO (
    ID         INTEGER NOT NULL,
    CDATE      DATE NOT NULL,
    SOLD       SMALLINT DEFAULT 0 NOT NULL,
    SALE_DATE  DATE,
    DISABLED   SMALLINT DEFAULT 0 NOT NULL,
    DELETED    SMALLINT DEFAULT 0 NOT NULL,
    EXECUTED   SMALLINT DEFAULT 0 NOT NULL
);

CREATE OR ALTER trigger card_info_bu0 for card_info
active before update position 0
AS
begin
  if (new.executed is null) then
    new.executed = 0;
end

update card_info set deleted = 1 where id = 1

if (new.executed <> 0) then

update card_info set deleted = 1 where id = 1

CREATE OR ALTER trigger card_info_bi0 for card_info
active before insert position 0
AS
begin
  if (new.id is null) then
    new.id = gen_id(gen_card_info_id, 1);
end