mayor-orig/mayor-base/update/pre003858-1-mayor_login.sql


1
2
3
4
5
6
7
8
9
10
11
12

DELIMITER $$
DROP PROCEDURE IF EXISTS upgrade_database_3858 $$
CREATE PROCEDURE upgrade_database_3858()
BEGIN
    IF EXISTS (
	SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='facebookConnect'
    ) THEN
    ALTER TABLE facebookConnect ADD UNIQUE INDEX (fbUserId);
END IF;
END $$
DELIMITER ; $$
CALL upgrade_database_3858();