CREATE TABLE npay_service_object_$mid
( 
	csid int(11) NOT NULL,
	oid int(11) NOT NULL,
	col int(11) NOT NULL,
	KEY csid (csid) 
);

ALTER TABLE npay_service_object_$mid ADD col INT DEFAULT 1 NOT NULL;

ALTER TABLE npay_service_object_$mid ADD id INT NOT NULL DEFAULT 0 FIRST;
UPDATE npay_service_object_$mid SET id=csid WHERE id=0;
ALTER TABLE npay_service_object_$mid CHANGE id id INT NOT NULL AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE npay_service_object_$mid ADD COLUMN cid INTEGER  NOT NULL AFTER id;
ALTER TABLE npay_service_object_$mid ADD INDEX cid(cid);
ALTER TABLE npay_service_object_$mid ADD INDEX oid(oid);
ALTER TABLE npay_service_object_$mid ADD sid INT NOT NULL AFTER cid;
ALTER TABLE npay_service_object_$mid ADD date1 DATE;
ALTER TABLE npay_service_object_$mid ADD date2 DATE;
ALTER TABLE npay_service_object_$mid ADD emid INT NOT NULL;
ALTER TABLE npay_service_object_$mid ADD eid INT NOT NULL;
ALTER TABLE npay_service_object_$mid ADD comment VARCHAR(250) NOT NULL;

-- удаление не привязанных к договорам абонплат
DELETE service_object FROM npay_service_object_$mid AS service_object LEFT JOIN contract ON service_object.cid=contract.id WHERE contract.id IS NULL;
-- переименование задачи
UPDATE scheduled_class SET class='ru.bitel.bgbilling.modules.npay.server.Calculator' WHERE class='bitel.billing.server.npay.Calculator';

-- #BLOCK#

DELETE FROM script_event_type WHERE mid=$mid;

SET @mid=$mid, @old_event_id=1, @new_event_id='ru.bitel.bgbilling.modules.npay.server.bean.event.DebetStatusManageOpenGetAdditionalCharge', @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=$mid, @old_event_id=2, @new_event_id='ru.bitel.bgbilling.modules.npay.server.bean.event.DebetStatusManageAfterOpen', @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;

INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES ($mid, 'ru.bitel.bgbilling.kernel.event.events.CalculateEvent', 0, 'Начисление');
INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES ($mid, 'ru.bitel.bgbilling.modules.npay.server.bean.event.ContractNpayChangedEvent', 1, 'Изменение абонплаты в договоре');




-- #ENDB#