CREATE TABLE ex_pit_transactions
(
  id bigserial NOT NULL,
  bid int4 NOT NULL,
  fma text NOT NULL,
  volume numeric( 30 , 3 ) NOT NULL,
  cur_id int4 NOT NULL,
  ts timestamp NOT NULL DEFAULT now(),
  comments char( 255 ),
  dat date NOT NULL DEFAULT ('now'::text)::date,
  tm time NOT NULL DEFAULT ('now'::text)::time with time zone,
  cnt int4 NOT NULL,
  sid int4 NOT NULL,
  op_type int4 NOT NULL,
  confirm bool NOT NULL DEFAULT false,
  CONSTRAINT ex_pit_transactions_id_pkey PRIMARY KEY (id)
) 
WITH OIDS;

CREATE TABLE commission_ex_pit_tran
(
  id_tran int8 NOT NULL, -- ид ручной (внебиржевой) проводки
  volume numeric( 30 , 4 ) NOT NULL, -- сумма комиссионной проводки
  ts timestamp NOT NULL DEFAULT now(), -- время добавления записи в таблицу
  comments char( 255 ), -- комментарий комиссионной проводки
  c_type int2 NOT NULL, -- тип комиссионной проводки: 1-комиссия брокера, 2- комиссия торговой системы
  CONSTRAINT commission_ex_pit_tran_id_tran_fkey FOREIGN KEY (id_tran)
      REFERENCES ex_pit_transactions (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT commission_ex_pit_tran_unique2_key UNIQUE (id_tran, c_type)
) 
WITH OIDS;

CREATE TRIGGER commission_ex_pit_tran_trig_before
  BEFORE DELETE
  ON commission_ex_pit_tran
  FOR EACH ROW
  EXECUTE PROCEDURE recalc_money_balance();

CREATE TRIGGER commission_ex_pit_tran_trig_before
  BEFORE DELETE
  ON commission_ex_pit_tran
  FOR EACH ROW
  EXECUTE PROCEDURE recalc_money_balance();

    CREATE RULE ex_pit_transactions_Delete AS ON DELETE TO ex_pit_transactions
    DO INSTEAD
    (
        DELETE FROM commission_ex_pit_tran WHERE id_tran = OLD.id;
        DELETE FROM ex_pit_transactions WHERE id = OLD.old;
    );

    CREATE RULE ex_pit_transactions_Delete AS ON DELETE TO ex_pit_transactions
    DO INSTEAD
    (
        DELETE FROM commission_ex_pit_tran WHERE id_tran = OLD.id;
        DELETE FROM ex_pit_transactions WHERE id = OLD.old;
    );

    CREATE RULE ex_pit_transactions_Delete AS ON DELETE TO ex_pit_transactions
    DO INSTEAD
    (
        DELETE FROM commission_ex_pit_tran WHERE id_tran = OLD.id;
        DELETE FROM ex_pit_transactions WHERE id = OLD.old;
    );

CREATE OR REPLACE RULE ex_pit_transactions_del AS
    ON DELETE TO ex_pit_transactions DO  DELETE FROM commission_ex_pit_tran
  WHERE commission_ex_pit_tran.id_tran = old.id;