关于mysql的flyway脚本

自动创建字段脚本

DROP PROCEDURE IF EXISTS AUTO_SUBMIT_TABLE_SCRIPT;
DELIMITER $$
CREATE PROCEDURE AUTO_SUBMIT_TABLE_SCRIPT()
BEGIN
    DECLARE CurrentDatabase VARCHAR(255);
    DECLARE cnt integer;
    SELECT DATABASE() INTO CurrentDatabase;

    SELECT count(0)
    into cnt
    FROM information_schema.columns
    WHERE table_schema = CurrentDatabase
      AND table_name = 'auto_submit'
      AND column_name = 'NO';
    IF cnt = 0 THEN
        ALTER TABLE AUTO_SUBMIT
            ADD COLUMN NO VARCHAR(96) COMMENT '编号';
    END IF;

    SELECT count(0)
    into cnt
    FROM information_schema.columns
    WHERE table_schema = CurrentDatabase
      AND table_name = 'AUTO_SUBMIT'
      AND column_name = 'NAME';
    IF cnt = 0 THEN
        ALTER TABLE AUTO_SUBMIT
            ADD COLUMN NAME VARCHAR(256) COMMENT '名称';
    END IF;

END $$
DELIMITER $$

call AUTO_SUBMIT_TABLE_SCRIPT();
DROP PROCEDURE AUTO_SUBMIT_TABLE_SCRIPT;