diff options
author | Andrew Arnott <andrewarnott@gmail.com> | 2009-11-16 21:10:05 -0800 |
---|---|---|
committer | Andrew Arnott <andrewarnott@gmail.com> | 2009-11-16 21:10:05 -0800 |
commit | 2104fa92f0751189b53a5ba9105a52c01fa8a36e (patch) | |
tree | 10d17b46589d35c29757bbf2cc5978b13d4fefa6 /projecttemplates/RelyingPartyLogic/CreateDatabase.sql | |
parent | e9b25c72f5e149d7d46e42914f2e19153109e674 (diff) | |
download | DotNetOpenAuth-2104fa92f0751189b53a5ba9105a52c01fa8a36e.zip DotNetOpenAuth-2104fa92f0751189b53a5ba9105a52c01fa8a36e.tar.gz DotNetOpenAuth-2104fa92f0751189b53a5ba9105a52c01fa8a36e.tar.bz2 |
oops. forgot to fix the stored proc for the renamed columns.
Diffstat (limited to 'projecttemplates/RelyingPartyLogic/CreateDatabase.sql')
-rw-r--r-- | projecttemplates/RelyingPartyLogic/CreateDatabase.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql index 81aff9f..3e36000 100644 --- a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql +++ b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql @@ -144,7 +144,7 @@ AS END ELSE BEGIN - SET @roleid = (SELECT Id FROM dbo.Role WHERE [Name] = @role) + SET @roleid = (SELECT RoleId FROM dbo.Role WHERE [Name] = @role) END INSERT INTO dbo.UserRole (UserId, RoleId) VALUES (@userId, @roleid) |