soc/project_data/sql/0.0.6/soc/soc.sql

DELIMITER ??
DROP PROCEDURE IF EXISTS schema_change ?? 
CREATE PROCEDURE schema_change () BEGIN
    IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () 
		AND TABLE_NAME = 'sys_org' AND COLUMN_NAME = 'affiliated_area' ) 
	THEN
    ALTER TABLE `sys_org` 
	ADD COLUMN `affiliated_area` varchar(100) NULL COMMENT '机构所属地区' AFTER `tree_parent_code`,
	ADD COLUMN `affiliated_bank` varchar(100) NULL COMMENT '机构所属行社' AFTER `affiliated_area`;

	END IF;
	
	 IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () 
		AND TABLE_NAME = 'sys_org' AND COLUMN_NAME = 'affiliated_area' ) 
	THEN
		ALTER TABLE `sync_fjnx_org` 
		ADD COLUMN `affiliated_area` varchar(100) NULL COMMENT '机构所属地区',
		ADD COLUMN `affiliated_bank` varchar(100) NULL COMMENT '机构所属行社' AFTER `affiliated_area`;

	END IF;

END ??
DELIMITER ;
CALL schema_change ();