DROP TABLE IF EXISTS `bigdata`;

CREATE TABLE `bigdata` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `number` bigint(20) DEFAULT NULL,
  `name` varchar(20) CHARACTER SET cp1251 DEFAULT NULL,
  `sec_id1` bigint(20) DEFAULT NULL,
  `sec_id2` bigint(20) DEFAULT NULL,
  `name2` varchar(20) CHARACTER SET cp1251 DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `numb` (`number`)
) ENGINE=InnoDB AUTO_INCREMENT=10100001 DEFAULT CHARSET=utf8;

DELIMITER $$

USE `test`$$

DROP FUNCTION IF EXISTS `filler`$$

CREATE DEFINER=`root`@`%` FUNCTION `filler`(lim INT) RETURNS INT(11)
BEGIN
    DECLARE cnt INT DEFAULT 0;
    DECLARE f_numb BIGINT DEFAULT 222222222222;
    DECLARE f_name VARCHAR (20);
    DECLARE f_name2 VARCHAR (20);
    DECLARE f_date DATE;
    DECLARE f_id1 BIGINT;
    DECLARE f_id2 BIGINT;
    WHILE
        cnt < lim DO SET f_numb = f_numb + 1;
        SET f_name = ELT(
            0.5 + RAND() * 6,
            'Иван',
            'Андрей',
            'Артем',
            'Дима',
            'Вова',
            'Саша'
        );
        SET f_name2 = ELT(
            0.5 + RAND() * 6,
            'Сидоров',
            'Иванов',
            'Петров',
            'Матроскин',
            'Воробьянинов',
            'Селезнев'
        );
        SET f_date = TIMESTAMPADD(
            SECOND,
            FLOOR(
                RAND() * TIMESTAMPDIFF(
                    SECOND,
                    '2015-01-07 00:00:00',
                    '2019-08-24 00:00:00'
                )
            ),
            '2015-01-07 00:00:00'
        );
        SET f_id1 = FLOOR(RAND() * 999999999999);
        SET f_id2 = FLOOR(RAND() * 999999999999);
        INSERT INTO `test`.`bigdata` (
            `date`,
            `number`,
            `name`,
            `sec_id1`,
            `sec_id2`,
            `name2`
        )
        VALUES
            (
                f_date,
                f_numb,
                f_name,
                f_id1,
                f_id2,
                f_name2
            );
        SET cnt = cnt + 1;
    END WHILE;
    RETURN cnt;
END$$

DELIMITER ;

SELECT filler(1000000);