1 drop PROCEDURE IF EXISTS AddIsDoliday ; 2 CREATE PROCEDURE AddIsDoliday() 3 BEGIN 4 IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 't_fee_static' AND column_name = 'IsDoliday') THEN 5 ALTER TABLE t_fee_static ADD IsDoliday int(4) DEFAULT 0 COMMENT '是否节假日(1:是;0否;)' AFTER ticketTimeType; 6 END IF; 7 IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 't_fee_type' AND column_name = 'IsDoliday' ) THEN 8 ALTER TABLE t_fee_type ADD IsDoliday int(4) DEFAULT 0 COMMENT '是否节假日(1:是;0否;)' AFTER IsDelete; 9 END IF; 10 11 end ; 12 call AddIsDoliday(); 13 drop PROCEDURE IF EXISTS AddIsDoliday;