Files

68 lines
838 B
SQL

DROP procedure IF EXISTS `SetPersonFacebookId`
#
DROP procedure IF EXISTS `SetPersonTwitterId`
#
DROP procedure IF EXISTS `SetPersonGPlusId`
#
CREATE PROCEDURE `SetPersonFacebookId`(
IN personId INTEGER,
IN facebookId VARCHAR(64)
)
BEGIN
UPDATE People SET People.FacebookId=facebookId
WHERE People.PersonId=personId;
SELECT ROW_COUNT() AS RowsUpdated;
END
#
CREATE PROCEDURE `SetPersonTwitterId`(
IN personId INTEGER,
IN twitterId VARCHAR(64)
)
BEGIN
UPDATE People SET People.TwitterId=twitterId
WHERE People.PersonId=personId;
SELECT ROW_COUNT() AS RowsUpdated;
END
#
CREATE PROCEDURE `SetPersonGPlusId`(
IN personId INTEGER,
IN gPlusId VARCHAR(64)
)
BEGIN
UPDATE People SET People.GPlusId=gPlusId
WHERE People.PersonId=personId;
SELECT ROW_COUNT() AS RowsUpdated;
END