USE evgen24;

DROP TABLE map;
CREATE TABLE `map`(
     `id` INT(10) NOT NULL AUTO_INCREMENT,
     `x` INT(5) NOT NULL,
     `y` INT(5) NOT NULL,
     `status` INT(3) NOT NULL,
     PRIMARY KEY (`id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

DROP PROCEDURE IF EXISTS X;
DELIMITER $$
CREATE PROCEDURE X()
BEGIN
   DECLARE i INT DEFAULT 0;
   WHILE i < 400 DO
   INSERT INTO map (X,
         Y,
         STATUS)
         VALUES('1','1', FLOOR((RAND() * 5)));
   SET i = i + 1;           
   END WHILE;
END$$
DELIMITER;$$
CALL X();