DROP PROCEDURE if EXISTS `db_waasai`.`sp_update_106_107` $$
CREATE PROCEDURE `db_waasai`.`sp_update_106_107`()
BEGIN
IF NOT CheckIsObjectExist( 'tbl_user_card ', ' ') THEN
CREATE TABLE `tbl_user_card` (
`u_id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
`u_status` TINYINT(1) UNSIGNED DEFAULT '0 ',
`u_name` VARCHAR(20) NOT NULL,
PRIMARY KEY (`u_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
END IF;
IF NOT CheckIsObjectExist( 'tbl_user ', 'u_cards_num ') THEN
alter table `tbl_user` add column `u_cards_num` int (12) UNSIGNED DEFAULT '0 ' NULL after `u_age`;
update `tbl_user` set `u_cards_num`=1;
END IF;
END$$
DELIMITER;
CALL sp_update_106_107();
DROP PROCEDURE IF EXISTS `lsgw`.`sp_update_106_107`;
[code]