将此代码DROP PROCEDURE IF EXISTS schema_change;$$ CREATE PROCEDURE schema_change() BEGIN CREATE TABLE IF NOT EXISTS `bis_record_upload_list` ( `pkid` int(11) NOT NULL AUTO_INCREMENT, `hash_code` varchar(255) DEFAULT NULL COMMENT '检验码', `path` varchar(255) DEFAULT NULL COMMENT '路径', PRIMARY KEY (`pkid`), UNIQUE KEY `hash_code` (`hash_code`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4; IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'bis_record_upload_list' AND column_name = 'hash_code') THEN alter table bis_record_upload_list add `hash_code` varchar(255) DEFAULT NULL COMMENT '检验码'; END IF; END;$$ CALL schema_change();$$ DROP PROCEDURE IF EXISTS schema_change;$$修改成kingbase语句

DROP PROCEDURE IF EXISTS schema_change;

CREATE OR REPLACE PROCEDURE schema_change()
AS
$$
BEGIN
CREATE TABLE IF NOT EXISTS bis_record_upload_list (
pkid SERIAL PRIMARY KEY,
hash_code VARCHAR(255) DEFAULT NULL COMMENT '检验码',
path VARCHAR(255) DEFAULT NULL COMMENT '路径'
);

IF NOT EXISTS (
SELECT *
FROM information_schema.columns
WHERE table_schema = current_database()
AND table_name = 'bis_record_upload_list'
AND column_name = 'hash_code'
)
THEN
ALTER TABLE bis_record_upload_list ADD COLUMN hash_code VARCHAR(255) DEFAULT NULL COMMENT '检验码';
END IF;
END;
$$
LANGUAGE plpgsql;

CALL schema_change();

DROP PROCEDURE IF EXISTS schema_change;