DROP PROCEDURE IF EXISTS pro_AddColumn;
CREATE PROCEDURE pro_AddColumn() BEGIN
IF NOT EXISTS(SELECT 1 FROM information_schema.columns WHERE table_name=
'component'
AND COLUMN_NAME=
'PRINT_CHECK_STATUS'
) THEN
ALTER TABLE component ADD PRINT_CHECK_STATUS int(10)
default
0;
END
IF;
IF NOT EXISTS(SELECT 1 FROM information_schema.columns WHERE table_name=
'component'
AND COLUMN_NAME=
'PRINT_CHECK_TIME'
) THEN
ALTER TABLE component ADD PRINT_CHECK_TIME datetime NULL;
END
IF;
IF NOT EXISTS(SELECT 1 FROM information_schema.columns WHERE table_schema=podcloud AND table_name=
'component'
AND COLUMN_NAME=
'PRINT_CHECK_BACK_REASON'
) THEN
ALTER TABLE component ADD PRINT_CHECK_BACK_REASON varchar(500)
default
null;
END
IF;
END
;
CALL pro_AddColumn;
DROP PROCEDURE pro_AddColumn;
------------------------------------------------------------------------------------------------
DROP PROCEDURE IF EXISTS pro_AddIndex;
DELIMITER;
CREATE PROCEDURE pro_AddIndex() BEGIN IF NOT EXISTS (SELECT * FROM information_schema.statistics WHERE table_schema=CurrentDatabase AND table_name =
'rtc_phototype'
AND index_name =
'index_name'
) THEN
ALTER TABLE `rtc_Phototype` ADD INDEX index_name ( `imgtype` );
END
IF;
END
;
DELIMITER;
CALL pro_AddIndex();
Drop procedure pro_AddIndex;