CREATE TABLE IF NOT EXISTS trayinfo_login_$mid
( 
	id int(11) NOT NULL auto_increment,
	type int NOT NULL,
	cid int NOT NULL,
	pswd char(100) NOT NULL default '',
	date1 date default NULL,
	date2 date default NULL,
	PRIMARY KEY ( id ),
	KEY type( type )
);

CREATE TABLE IF NOT EXISTS trayinfo_type_$mid
( 
	id int NOT NULL auto_increment,
	title varchar(100) NOT NULL,
	pt int NOT NULL,
	cost float NOT NULL,
	days int NOT NULL,
	date1 date default NULL,
	date2 date default NULL,
	PRIMARY KEY ( id ),
	KEY date1( date1 ),
	KEY date2( date2 )
);

ALTER TABLE `trayinfo_type_$mid` CHANGE COLUMN `cost` `cost` DECIMAL(10,2) NOT NULL DEFAULT '0';

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

SET @mid=$mid, @old_event_id=100, @new_event_id='ru.bitel.bgbilling.modules.trayinfo.server.bean.TrayInfoReplyEvent', @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#