CREATE DEFINER = 'root'@'localhost' PROCEDURE `fixture_id`(
        _ut VARCHAR(50),
        _sport VARCHAR(50),
        _country VARCHAR(50),
        _template VARCHAR(50),
        _league  VARCHAR(50)
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
	DECLARE inserted INT DEFAULT 0;
	DECLARE isset_id INT DEFAULT 0;
	
	SELECT id INTO isset_id FROM `fixtures` WHERE 
	`ut`= _ut and 
	`sport`= _sport and 
	`country`= _country and 
	`template`= _template and 
	`league`= _league 
	LIMIT 1;
	
	IF isset_id > 0 THEN
		SELECT isset_id 'id';
	ELSE
		INSERT INTO `fixtures` ( `ut`, `sport`, `country`, `template`, `tournament`, `league`, `status`) VALUES (_ut,_sport,_country,_template,'2014',_league,'Not started');
		SELECT LAST_INSERT_ID() INTO inserted;
		SELECT inserted 'id';
	END IF;
END;

SELECT LAST_INSERT_ID() INTO inserted;
		SELECT inserted 'id';

INSERT INTO `fixtures` (`ut`,`sport`,`country`,`template`,`league`,`tournament`,`status`) VALUES ('2014-09-20','Football','International','Euro 2016','Euro 2016','2014','Not started') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `fixture_events` (`name`,`date`,`fixture_id`,`participants`,`visible`) VALUES ('Azerbaijan - Bulgaria','2014-09-09 15:00:00','1','a:2:{i:0;s:10:"Azerbaijan";i:1;s:8:"Bulgaria";}','1') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `odds_groups` (`sport`,`caption`) VALUES ('Football','Win') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `odds_types` (`group_id`,`caption`,`enabled`) VALUES ('1','%par1','1') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `odds` (`partner_id`,`event_id`,`date`,`odds`,`type_id`,`enabled`,`margin`) VALUES ('1','1','2014-09-20 19:37:03','4.1','1','1','1.8') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
в среднем - от 00.00.250 до  00.00.400 !

CALL fixture_id('2014-09-20','Football','International','Euro 2016','Euro 2016');
CALL event_id('Azerbaijan - Bulgaria','2014-09-09 15:00:00','1','a:2:{i:0;s:10:\"Azerbaijan\";i:1;s:8:\"Bulgaria\";}');
CALL group_id('Football','Win');
CALL type_id('1','%par1');
CALL save_odds('1','1','2014-09-20 19:36:48','4.1','1','1.8');
в среднем - от 00.00.650 до  00.01.250 !

SELECT LAST_INSERT_ID() as `id`;