an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > Does the role id matter in the migration script?
Last Post 1/5/2010 11:39:06 AM By lukezy. 3 replies.
1/5/2010 9:11:47 AM
bansal_db
Posts: 181
Joined: 4/13/2009
Does the role id matter in the migration script?
Hey Luke,
 
Does the role id matters here?
 
INSERT INTO [dbo].[DSC_Role] ([roleId], [name], [discountRate], [minOrderAmount]) VALUES (9, N'ProductManager', 0.0000, 0.0000)
INSERT INTO [dbo].[DSC_Role] ([roleId], [name], [discountRate], [minOrderAmount]) VALUES (10, N'OrderManager', 0.0000, 0.0000)
 
 
Can these roles be any other role ids? I already have roles till roleId 15.
 
Thanks
1/5/2010 9:50:02 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Does the role id matter in the migration script?
No, it doesn't matter. You can use any ids.
DotShoppingCart Staff
1/5/2010 10:00:50 AM
bansal_db
Posts: 181
Joined: 4/13/2009
Re: Does the role id matter in the migration script?
Would changing the role id effect the encrypted role ids here?
 
 
SET IDENTITY_INSERT [dbo].[DSC_Template] OFF

INSERT INTO [dbo].[aspnet_Roles] ([RoleId], [ApplicationId], [RoleName], [LoweredRoleName], [Description]) VALUES (N'7924366a-810b-4e2b-8501-80afc387522a', N'0d663bb4-8150-479b-880d-cca0342f9e35', N'OrderManager', N'ordermanager', NULL)
INSERT INTO [dbo].[aspnet_Roles] ([RoleId], [ApplicationId], [RoleName], [LoweredRoleName], [Description]) VALUES (N'960b8a65-ee70-46f7-af82-42304434d8e8', N'0d663bb4-8150-479b-880d-cca0342f9e35', N'ProductManager', N'productmanager', NULL)

SET IDENTITY_INSERT [dbo].[DSC_Role] ON
INSERT INTO [dbo].[DSC_Role] ([roleId], [name], [discountRate], [minOrderAmount]) VALUES (9, N'ProductManager', 0.0000, 0.0000)
INSERT INTO [dbo].[DSC_Role] ([roleId], [name], [discountRate], [minOrderAmount]) VALUES (10, N'OrderManager', 0.0000, 0.0000)
SET IDENTITY_INSERT [dbo].[DSC_Role] OFF
GO
 
 
1/5/2010 11:39:06 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Does the role id matter in the migration script?
I don't think so. It's associated by the name.
DotShoppingCart Staff