summaryrefslogtreecommitdiffstats
path: root/projecttemplates/RelyingPartyLogic/CreateDatabase.sql
diff options
context:
space:
mode:
authorAndrew Arnott <andrewarnott@gmail.com>2009-11-16 21:10:05 -0800
committerAndrew Arnott <andrewarnott@gmail.com>2009-11-16 21:10:05 -0800
commit2104fa92f0751189b53a5ba9105a52c01fa8a36e (patch)
tree10d17b46589d35c29757bbf2cc5978b13d4fefa6 /projecttemplates/RelyingPartyLogic/CreateDatabase.sql
parente9b25c72f5e149d7d46e42914f2e19153109e674 (diff)
downloadDotNetOpenAuth-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.sql2
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)