CREATE TABLE `enaza_transaction_$mid` (
  `order_id` BIGINT  NOT NULL,
  `contract_id` INT  NOT NULL,
  `charge_id` INT  NOT NULL,
  `descr` TEXT  NOT NULL,
  `amount` DECIMAL(10,2) NOT NULL,
  `dt` DATETIME  NOT NULL,
  PRIMARY KEY (`order_id`)
);
ALTER TABLE `enaza_transaction_$mid` ADD COLUMN `status` int(11) NULL default '0';
UPDATE enaza_transaction_$mid SET status=1 WHERE charge_id>0;
ALTER TABLE `enaza_transaction_$mid`	ADD COLUMN `product_id` int(11) NULL;

-- #BLOCK#
DELETE FROM script_event_type WHERE mid=$mid;
INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES ($mid, 'ru.bitel.bgbilling.modules.enaza.server.bean.event.GetAttensionEvent', 1, '    ');
INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES ($mid, 'ru.bitel.bgbilling.modules.enaza.server.bean.event.GetChargeTypeEvent', 1, '  ')
;-- #ENDB#