blob: 239c81fffc9470db66b81398eacd8038c14aa803 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
DELIMITER $$
DROP PROCEDURE IF EXISTS upgrade_database_3860 $$
CREATE PROCEDURE upgrade_database_3860()
BEGIN
IF NOT EXISTS (
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='facebookConnect' AND COLUMN_NAME='fbUserCn'
) THEN
ALTER TABLE facebookConnect ADD fbUserCn varchar(64), ADD fbUserEmail varchar(64), ADD studyId varchar(12);
END IF;
END $$
DELIMITER ; $$
CALL upgrade_database_3860();
|
