CREATE TABLE `cashcheck_payment_queue_$mid` (
  `payment_id` int(11) NOT NULL,
  `dt` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY (`payment_id`)
);

ALTER TABLE `cashcheck_payment_queue_$mid` ADD COLUMN `pos_id` INTEGER  NOT NULL DEFAULT 0;

-- create-copy-table + drop-queue-not-log
-- убрать к релизу 5.4 миграцию имён таблиц, исправить чтобы выше создавались сразу без $mid
CREATE TABLE `cashcheck_payment_log` SELECT * FROM `cashcheck_payment_queue_$mid`;
DELETE FROM `cashcheck_payment_log` WHERE pos_id=0;
DELETE FROM `cashcheck_payment_log` WHERE pos_id=-1;

-- http://bugs.mysql.com/bug.php?id=68670
ALTER TABLE `cashcheck_payment_log` CHANGE COLUMN `dt` `dt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

CREATE TABLE `cashcheck_charge_log` (
  `charge_id` int(11) NOT NULL COMMENT 'ид расхода из contract_charge',
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pos_id` int(11) NOT NULL DEFAULT '0' COMMENT 'номер ККМ, на котором был напечатан чек возврата',
  PRIMARY KEY (`charge_id`) USING BTREE
) COMMENT='очередь чеков на расходы';

-- #BLOCK#
DELETE FROM script_event_type WHERE mid="p$mid";

SET @mid='p$mid', @old_event_id=100, @new_event_id='ru.bitel.bgbilling.plugins.cashcheck.server.bean.AddPaymentCheckEvent', @event_title='Добавление позиции в чек';
INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES (@mid, @new_event_id, 1, @event_title);
INSERT INTO script_function_event_type(fid, mid, event_id) SELECT sfet1.fid, sfet1.mid, @new_event_id FROM script_function_event_type AS sfet1 LEFT JOIN script_function_event_type AS sfet2 ON sfet1.fid=sfet2.fid AND sfet1.mid=sfet2.mid AND sfet2.event_id=@new_event_id WHERE sfet1.mid=@mid AND sfet1.event_id=@old_event_id AND sfet2.fid IS NULL;

SET @mid='p$mid', @old_event_id=101, @new_event_id='ru.bitel.bgbilling.plugins.cashcheck.server.bean.EndCreateCheckEvent', @event_title='Завершение формирования чека';
INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES (@mid, @new_event_id, 1, @event_title);
INSERT INTO script_function_event_type(fid, mid, event_id) SELECT sfet1.fid, sfet1.mid, @new_event_id FROM script_function_event_type AS sfet1 LEFT JOIN script_function_event_type AS sfet2 ON sfet1.fid=sfet2.fid AND sfet1.mid=sfet2.mid AND sfet2.event_id=@new_event_id WHERE sfet1.mid=@mid AND sfet1.event_id=@old_event_id AND sfet2.fid IS NULL;

-- #ENDB#
