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;

-- #BLOCK#
DELETE FROM script_event_type WHERE mid=$mid;
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 1, ' .    ');
INSERT INTO script_event_type (mid, event_id, title) VALUES ($mid, 2, '    ');
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#