CREATE PROCEDURE SetSeatStatus(status TINYINT UNSIGNED, id_place INT UNSIGNED, tableName TINYTEXT, OUT SeatStatus TINYINT UNSIGNED) 
BEGIN
START TRANSACTION;
SET SeatStatus:=(SELECT p FROM tableName WHERE id=id_place FOR UPDATE);
IF (SeatStatus<>status) THEN
UPDATE t SET p=status WHERE id=id_place;
END IF;
COMMIT;
END

DELIMITER //
CREATE PROCEDURE SetSeatStatus(status TINYINT UNSIGNED, id_place INT UNSIGNED, tableName TINYTEXT, OUT SeatStatus TINYINT UNSIGNED) 
BEGIN
START TRANSACTION;
SET @oper:=CONCAT(“SET SeatStatus:=(SELECT p FROM ”,tableName,”  WHERE id=id_place FOR UPDATE);”);
PREPARE operand FROM @oper;
EXECUTE operand;
DEALLOCATE PREPARE operand;
IF (SeatStatus<>status) THEN
SET @oper:=CONCAT(“UPDATE ”,tableName,” SET p=status WHERE id=id_place;”);
PREPARE operand FROM @oper;
EXECUTE operand;
DEALLOCATE PREPARE operand;
END IF;
COMMIT;
END
//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE SetSeatStatus(status TINYINT UNSIGNED, id_place INT UNSIGNED) 
BEGIN
START TRANSACTION;
SET @oper:=CONCAT(“SET @SeatStatus:=(SELECT p FROM  ”,@tableName,” WHERE id=”,id_place,” FOR UPDATE);”);
PREPARE operand FROM @oper;
EXECUTE operand;
DEALLOCATE PREPARE operand;
IF (@SeatStatus<>status) THEN
SET @oper:=CONCAT(“UPDATE ”,@tableName,” SET p=”,status,” WHERE id=”,id_place,”;”);
PREPARE operand FROM @oper;
EXECUTE operand;
DEALLOCATE PREPARE operand;
END IF;
COMMIT;
END
//
DELIMITER ;

SET @SeatStatus:=2,@tableName=’t’;
CALL SetSeatStatus(0,4);

CREATE TABLE events (
id_event INT UNSIGNED NOT NULL AUTO_INCREMENT,
artist TINYTEXT,
program TEXT,
min_price INT UNSIGNED,
max_price INT UNSIGNED,
id_hall INT UNSIGNED,
date DATE,
time TIME,
PRIMARY KEY (id_event),
FOREIGN KEY (id_hall) REFERENCES halls(id_hall)
) ENGINE=MyISAM;

CREATE TABLE places (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
vacant BOOL,
id_pr INT UNSIGNED,
PRIMARY KEY (id),
FOREIGN KEY (id_pr) REFERENCES prices_table(id_pr)
) ENGINE=InnoDB;

CREATE TABLE prices_table (
id_pr INT UNSIGNED NOT NULL AUTO_INCREMENT,
price_value INT UNSIGNED,
red TINYINT UNSIGNED,
green TINYINT UNSIGNED,
blue TINYINT UNSIGNED,
PRIMARY KEY (id_pr)
) ENGINE=MyISAM;

CREATE TABLE halls (
id_hall INT UNSIGNED NOT NULL AUTO_INCREMENT,
name TINYTEXT,
region TINYTEXT,
city TINYTEXT,
street TINYTEXT,
house CHAR(8),
file TINYTEXT,
PRIMARY KEY (id_hall)
) ENGINE=MyISAM;