   `UserProvider` varchar(32) NOT NULL,
   `UserProviderId` varchar(64) NOT NULL,
   `UserProviderLastCall` datetime NOT NULL,
+  `PasswordResetGuid` varchar(100) DEFAULT NULL,
+  `PasswordResetGuidExpireDate` datetime DEFAULT NULL,
   PRIMARY KEY (`userid`),
   KEY `fk_users_usersgroups` (`usergroupid`),
   CONSTRAINT `fk_users_usersgroups` FOREIGN KEY (`usergroupid`) REFERENCES `usersgroups` (`usergroupid`)

  `pagecontentshortname` varchar(128) NOT NULL,
  `pagecontenteditdate` datetime NOT NULL,
  PRIMARY KEY (`pagecontentid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pagecontents`
--
INSERT INTO `pagecontents` VALUES   (1,'About','\r\n	<p>This forum is powered by <a href=\"http://www.nearforums.com\">Nearforums</a>, an open source forum engine.</p>\r\n	<p>Nearforums is released under <a href=\"http://nearforums.codeplex.com/license\" target=\"_blank\">MIT License</a>, you can get the source at <a href=\"http://www.nearforums.com/source-code\">www.nearforums.com/source-code</a>.</p>','about','2011-03-29 14:39:22');

--
-- Definition of table `tags`

DELIMITER ;

--
-- Definition of procedure `SPUsersGetByPasswordResetGuid`
--

DROP PROCEDURE IF EXISTS `SPUsersGetByPasswordResetGuid`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `SPUsersGetByPasswordResetGuid`(
	param_Provider varchar(32)
	,param_PasswordResetGuid varchar(64)
)
BEGIN
SELECT
	U.UserId
	,U.UserName
	,U.UserGroupId
	,U.UserGuid
	,U.UserTimeZone
	,U.UserExternalProfileUrl
	,U.UserProviderLastCall
	,U.UserEmail
	,U.UserProviderId
	,U.PasswordResetGuid
	,U.PasswordResetGuidExpireDate
FROM
	Users U
WHERE
	UserProvider = param_Provider
	AND
	PasswordResetGuid = param_PasswordResetGuid;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `SPUsersGetByProvider`
--

