Click here to Skip to main content
Click here to Skip to main content
Articles » Web Development » ASP.NET » Samples » Downloads
 
Add your own
alternative version
Go to top

Building a Web Message Board using Visual Studio 2008, Part I - The Basic Message Board

, 30 Dec 2007
This article builds a web based message board and uses several new technologies introduced with Visual Studio 2008 such as LINQ, WCF Web Programming, WCF Syndication, ASP.NET ListView, ASP.NET DataPager etc.
MessageBoard.zip
MessageBoard
MessageBoard.Core
MessageBoard.snk
Properties
MessageBoard.DataAccess.Linq
MessageBoard.snk
Properties
Settings.settings
MessageBoard.DataAccess.NonLinq
MessageBoard.snk
Properties
MessageBoard.Web
MessageBoard.snk
Properties
Service References
MessageBoard
App_Code
App_Data
App_Themes
Default
Floating
MessageBoard.png
newpost.jpg
post.jpg
Outlook
controlBarGradient.jpg
headerGradient.jpg
headerGradient2.jpg
ClassDiagram1.cd
Feed.svc
Global.asax
images
rss16.png
Install
Application Files
MessageBoard.Word_1_0_0_0
MessageBoard.dotx
MessageBoard.Word.dll.config.deploy
MessageBoard.Word.dll.deploy
MessageBoard.Word.dll.manifest
MessageBoard.Word.vsto
MessageBoard.dotx
MessageBoard.Word.vsto
setup.exe
MessageBoardService.svc
WebSite
��/****** Object:  ForeignKey [FK__aspnet_Me__Appli__164452B1]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__164452B1]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__164452B1]

GO

/****** Object:  ForeignKey [FK__aspnet_Me__UserI__173876EA]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__UserI__173876EA]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__173876EA]

GO

/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__47DBAE45]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pa__Appli__47DBAE45]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]'))

ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__47DBAE45]

GO

/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__4D94879B]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__4D94879B]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]'))

ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__4D94879B]

GO

/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__5165187F]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__5165187F]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]'))

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__5165187F]

GO

/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__52593CB8]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__UserI__52593CB8]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]'))

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__52593CB8]

GO

/****** Object:  ForeignKey [FK__aspnet_Pr__UserI__2B3F6F97]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pr__UserI__2B3F6F97]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]'))

ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT [FK__aspnet_Pr__UserI__2B3F6F97]

GO

/****** Object:  ForeignKey [FK__aspnet_Ro__Appli__34C8D9D1]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Ro__Appli__34C8D9D1]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]'))

ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [FK__aspnet_Ro__Appli__34C8D9D1]

GO

/****** Object:  ForeignKey [FK__aspnet_Us__Appli__060DEAE8]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__Appli__060DEAE8]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [FK__aspnet_Us__Appli__060DEAE8]

GO

/****** Object:  ForeignKey [FK__aspnet_Us__RoleI__398D8EEE]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__RoleI__398D8EEE]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]'))

ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__RoleI__398D8EEE]

GO

/****** Object:  ForeignKey [FK__aspnet_Us__UserI__38996AB5]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__UserI__38996AB5]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]'))

ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__UserI__38996AB5]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_FindState]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_FindState]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_FindState]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetSharedState]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetSharedState]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetSharedState]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_DeleteAllState]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_DeleteAllState]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_DeleteAllState]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_DeleteProfiles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteProfiles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Profile_DeleteProfiles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_CreateRole]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_CreateRole]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Roles_CreateRole]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_GetCountOfState]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_GetCountOfState]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_GetCountOfState]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetUserState]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetUserState]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetUserState]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_SetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_SetPageSettings]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_SetPageSettings]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_GetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_GetPageSettings]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_GetPageSettings]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_SetProperties]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_SetProperties]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Profile_SetProperties]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_CreateUser]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_CreateUser]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_CreateUser]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Applications_CreateApplication]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications_CreateApplication]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Applications_CreateApplication]

GO

/****** Object:  View [dbo].[vw_aspnet_Applications]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Applications]'))

DROP VIEW [dbo].[vw_aspnet_Applications]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_FindUsersByEmail]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByEmail]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByEmail]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_FindUsersByName]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByName]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByName]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetAllUsers]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetAllUsers]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_GetAllUsers]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetProfiles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProfiles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Profile_GetProfiles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Personalization_GetApplicationId]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Personalization_GetApplicationId]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Personalization_GetApplicationId]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_WebEvent_LogEvent]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_LogEvent]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_WebEvent_LogEvent]

GO

/****** Object:  View [dbo].[vw_aspnet_WebPartState_User]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_User]'))

DROP VIEW [dbo].[vw_aspnet_WebPartState_User]

GO

/****** Object:  View [dbo].[vw_aspnet_WebPartState_Shared]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Shared]'))

DROP VIEW [dbo].[vw_aspnet_WebPartState_Shared]

GO

/****** Object:  View [dbo].[vw_aspnet_WebPartState_Paths]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Paths]'))

DROP VIEW [dbo].[vw_aspnet_WebPartState_Paths]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Paths_CreatePath]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths_CreatePath]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Paths_CreatePath]

GO

/****** Object:  View [dbo].[vw_aspnet_UsersInRoles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_UsersInRoles]'))

DROP VIEW [dbo].[vw_aspnet_UsersInRoles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_GetAllRoles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_GetAllRoles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Roles_GetAllRoles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_RoleExists]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_RoleExists]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Roles_RoleExists]

GO

/****** Object:  View [dbo].[vw_aspnet_Roles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Roles]'))

DROP VIEW [dbo].[vw_aspnet_Roles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_DeleteRole]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_DeleteRole]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Roles_DeleteRole]

GO

/****** Object:  View [dbo].[vw_aspnet_Profiles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Profiles]'))

DROP VIEW [dbo].[vw_aspnet_Profiles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_CheckSchemaVersion]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_CheckSchemaVersion]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_CheckSchemaVersion]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_RegisterSchemaVersion]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_RegisterSchemaVersion]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_RegisterSchemaVersion]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UnRegisterSchemaVersion]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UnRegisterSchemaVersion]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_UnRegisterSchemaVersion]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_AddUsersToRoles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_UsersInRoles_AddUsersToRoles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_GetRolesForUser]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetRolesForUser]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetRolesForUser]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_FindUsersInRole]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_FindUsersInRole]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_UsersInRoles_FindUsersInRole]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_GetUsersInRoles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetUsersInRoles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetUsersInRoles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetNumberOfUsersOnline]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetNumberOfUsersOnline]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_GetNumberOfUsersOnline]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetProperties]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProperties]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Profile_GetProperties]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_DeleteInactiveProfiles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteInactiveProfiles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Profile_DeleteInactiveProfiles]

GO

/****** Object:  View [dbo].[vw_aspnet_Users]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Users]'))

DROP VIEW [dbo].[vw_aspnet_Users]

GO

/****** Object:  View [dbo].[vw_aspnet_MembershipUsers]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_MembershipUsers]'))

DROP VIEW [dbo].[vw_aspnet_MembershipUsers]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UpdateUser]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUser]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUser]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_IsUserInRole]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_IsUserInRole]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_UsersInRoles_IsUserInRole]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UnlockUser]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UnlockUser]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_UnlockUser]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_ResetPassword]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ResetPassword]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_ResetPassword]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_SetPassword]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_SetPassword]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_SetPassword]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetPassword]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPassword]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_GetPassword]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UpdateUserInfo]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUserInfo]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUserInfo]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetPasswordWithFormat]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPasswordWithFormat]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_GetPasswordWithFormat]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByEmail]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByEmail]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByEmail]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByUserId]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByUserId]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByUserId]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByName]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByName]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByName]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_AnyDataInTables]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_AnyDataInTables]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_AnyDataInTables]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Users_DeleteUser]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_DeleteUser]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Users_DeleteUser]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Users_CreateUser]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_CreateUser]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Users_CreateUser]

GO

/****** Object:  Table [dbo].[aspnet_PersonalizationAllUsers]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_PersonalizationAllUsers]

GO

/****** Object:  Table [dbo].[aspnet_PersonalizationPerUser]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_PersonalizationPerUser]

GO

/****** Object:  Table [dbo].[aspnet_Paths]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_Paths]

GO

/****** Object:  Table [dbo].[aspnet_UsersInRoles]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_UsersInRoles]

GO

/****** Object:  Table [dbo].[aspnet_Roles]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_Roles]

GO

/****** Object:  Table [dbo].[aspnet_Profile]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_Profile]

GO

/****** Object:  Table [dbo].[aspnet_Membership]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_Membership]

GO

/****** Object:  Table [dbo].[aspnet_Users]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_Users]

GO

/****** Object:  Table [dbo].[aspnet_WebEvent_Events]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_Events]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_WebEvent_Events]

GO

/****** Object:  Table [dbo].[aspnet_Applications]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_Applications]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RemoveAllRoleMembers]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Setup_RemoveAllRoleMembers]

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Setup_RestorePermissions]    Script Date: 12/21/2007 11:01:28 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RestorePermissions]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[aspnet_Setup_RestorePermissions]

GO

/****** Object:  Table [dbo].[Messages]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Messages]') AND type in (N'U'))

DROP TABLE [dbo].[Messages]

GO

/****** Object:  Table [dbo].[aspnet_SchemaVersions]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_SchemaVersions]') AND type in (N'U'))

DROP TABLE [dbo].[aspnet_SchemaVersions]

GO

/****** Object:  Default [DF__aspnet_Ap__Appli__03317E3D]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ap__Appli__03317E3D]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]'))

Begin

ALTER TABLE [dbo].[aspnet_Applications] DROP CONSTRAINT [DF__aspnet_Ap__Appli__03317E3D]



End

GO

/****** Object:  Default [DF__aspnet_Me__Passw__182C9B23]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Me__Passw__182C9B23]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

Begin

ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [DF__aspnet_Me__Passw__182C9B23]



End

GO

/****** Object:  Default [DF__aspnet_Pa__PathI__48CFD27E]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Pa__PathI__48CFD27E]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]'))

Begin

ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [DF__aspnet_Pa__PathI__48CFD27E]



End

GO

/****** Object:  Default [DF__aspnet_Perso__Id__5070F446]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Perso__Id__5070F446]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]'))

Begin

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [DF__aspnet_Perso__Id__5070F446]



End

GO

/****** Object:  Default [DF__aspnet_Ro__RoleI__35BCFE0A]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ro__RoleI__35BCFE0A]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]'))

Begin

ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [DF__aspnet_Ro__RoleI__35BCFE0A]



End

GO

/****** Object:  Default [DF__aspnet_Us__UserI__07020F21]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__UserI__07020F21]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

Begin

ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__UserI__07020F21]



End

GO

/****** Object:  Default [DF__aspnet_Us__Mobil__07F6335A]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__Mobil__07F6335A]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

Begin

ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__Mobil__07F6335A]



End

GO

/****** Object:  Default [DF__aspnet_Us__IsAno__08EA5793]    Script Date: 12/21/2007 11:01:27 ******/

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__IsAno__08EA5793]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

Begin

ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__IsAno__08EA5793]



End

GO

/****** Object:  Schema [aspnet_Membership_BasicAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_BasicAccess')

DROP SCHEMA [aspnet_Membership_BasicAccess]

GO

/****** Object:  Schema [aspnet_Membership_FullAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_FullAccess')

DROP SCHEMA [aspnet_Membership_FullAccess]

GO

/****** Object:  Schema [aspnet_Membership_ReportingAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_ReportingAccess')

DROP SCHEMA [aspnet_Membership_ReportingAccess]

GO

/****** Object:  Schema [aspnet_Personalization_BasicAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_BasicAccess')

DROP SCHEMA [aspnet_Personalization_BasicAccess]

GO

/****** Object:  Schema [aspnet_Personalization_FullAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_FullAccess')

DROP SCHEMA [aspnet_Personalization_FullAccess]

GO

/****** Object:  Schema [aspnet_Personalization_ReportingAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_ReportingAccess')

DROP SCHEMA [aspnet_Personalization_ReportingAccess]

GO

/****** Object:  Schema [aspnet_Profile_BasicAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_BasicAccess')

DROP SCHEMA [aspnet_Profile_BasicAccess]

GO

/****** Object:  Schema [aspnet_Profile_FullAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_FullAccess')

DROP SCHEMA [aspnet_Profile_FullAccess]

GO

/****** Object:  Schema [aspnet_Profile_ReportingAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_ReportingAccess')

DROP SCHEMA [aspnet_Profile_ReportingAccess]

GO

/****** Object:  Schema [aspnet_Roles_BasicAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_BasicAccess')

DROP SCHEMA [aspnet_Roles_BasicAccess]

GO

/****** Object:  Schema [aspnet_Roles_FullAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_FullAccess')

DROP SCHEMA [aspnet_Roles_FullAccess]

GO

/****** Object:  Schema [aspnet_Roles_ReportingAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_ReportingAccess')

DROP SCHEMA [aspnet_Roles_ReportingAccess]

GO

/****** Object:  Schema [aspnet_WebEvent_FullAccess]    Script Date: 12/21/2007 11:01:33 ******/

IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_WebEvent_FullAccess')

DROP SCHEMA [aspnet_WebEvent_FullAccess]

GO

/****** Object:  Role [aspnet_Membership_BasicAccess]    Script Date: 12/21/2007 11:01:28 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Membership_BasicAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_BasicAccess' AND type = 'R')

DROP ROLE [aspnet_Membership_BasicAccess]

GO

/****** Object:  Role [aspnet_Membership_FullAccess]    Script Date: 12/21/2007 11:01:28 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Membership_FullAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_FullAccess' AND type = 'R')

DROP ROLE [aspnet_Membership_FullAccess]

GO

/****** Object:  Role [aspnet_Membership_ReportingAccess]    Script Date: 12/21/2007 11:01:29 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Membership_ReportingAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_ReportingAccess' AND type = 'R')

DROP ROLE [aspnet_Membership_ReportingAccess]

GO

/****** Object:  Role [aspnet_Personalization_BasicAccess]    Script Date: 12/21/2007 11:01:29 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Personalization_BasicAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_BasicAccess' AND type = 'R')

DROP ROLE [aspnet_Personalization_BasicAccess]

GO

/****** Object:  Role [aspnet_Personalization_FullAccess]    Script Date: 12/21/2007 11:01:29 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Personalization_FullAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_FullAccess' AND type = 'R')

DROP ROLE [aspnet_Personalization_FullAccess]

GO

/****** Object:  Role [aspnet_Personalization_ReportingAccess]    Script Date: 12/21/2007 11:01:29 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Personalization_ReportingAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_ReportingAccess' AND type = 'R')

DROP ROLE [aspnet_Personalization_ReportingAccess]

GO

/****** Object:  Role [aspnet_Profile_BasicAccess]    Script Date: 12/21/2007 11:01:29 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Profile_BasicAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_BasicAccess' AND type = 'R')

DROP ROLE [aspnet_Profile_BasicAccess]

GO

/****** Object:  Role [aspnet_Profile_FullAccess]    Script Date: 12/21/2007 11:01:30 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Profile_FullAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_FullAccess' AND type = 'R')

DROP ROLE [aspnet_Profile_FullAccess]

GO

/****** Object:  Role [aspnet_Profile_ReportingAccess]    Script Date: 12/21/2007 11:01:30 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Profile_ReportingAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_ReportingAccess' AND type = 'R')

DROP ROLE [aspnet_Profile_ReportingAccess]

GO

/****** Object:  Role [aspnet_Roles_BasicAccess]    Script Date: 12/21/2007 11:01:30 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Roles_BasicAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_BasicAccess' AND type = 'R')

DROP ROLE [aspnet_Roles_BasicAccess]

GO

/****** Object:  Role [aspnet_Roles_FullAccess]    Script Date: 12/21/2007 11:01:30 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Roles_FullAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_FullAccess' AND type = 'R')

DROP ROLE [aspnet_Roles_FullAccess]

GO

/****** Object:  Role [aspnet_Roles_ReportingAccess]    Script Date: 12/21/2007 11:01:31 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_Roles_ReportingAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_ReportingAccess' AND type = 'R')

DROP ROLE [aspnet_Roles_ReportingAccess]

GO

/****** Object:  Role [aspnet_WebEvent_FullAccess]    Script Date: 12/21/2007 11:01:31 ******/

DECLARE @RoleName sysname

set @RoleName = N'aspnet_WebEvent_FullAccess'

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R')

Begin

	DECLARE @RoleMemberName sysname

	DECLARE Member_Cursor CURSOR FOR

	select [name]

	from dbo.sysusers 

	where uid in ( 

		select member_principal_id 

		from sys.database_role_members 

		where role_principal_id in (

			select principal_id

			FROM sys.database_principals where [name] = @RoleName  AND type = 'R' ))



	OPEN Member_Cursor;



	FETCH NEXT FROM Member_Cursor

	into @RoleMemberName



	WHILE @@FETCH_STATUS = 0

	BEGIN



		exec sp_droprolemember @rolename=@RoleName, @membername= @RoleMemberName



		FETCH NEXT FROM Member_Cursor

		into @RoleMemberName

	END;



	CLOSE Member_Cursor;

	DEALLOCATE Member_Cursor;

End

GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_WebEvent_FullAccess' AND type = 'R')

DROP ROLE [aspnet_WebEvent_FullAccess]

GO

/****** Object:  Role [aspnet_Membership_BasicAccess]    Script Date: 12/21/2007 11:01:28 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_BasicAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_BasicAccess' AND type = 'R')

CREATE ROLE [aspnet_Membership_BasicAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Membership_FullAccess]    Script Date: 12/21/2007 11:01:28 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_FullAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_FullAccess' AND type = 'R')

CREATE ROLE [aspnet_Membership_FullAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Membership_ReportingAccess]    Script Date: 12/21/2007 11:01:29 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_ReportingAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_ReportingAccess' AND type = 'R')

CREATE ROLE [aspnet_Membership_ReportingAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Personalization_BasicAccess]    Script Date: 12/21/2007 11:01:29 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_BasicAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_BasicAccess' AND type = 'R')

CREATE ROLE [aspnet_Personalization_BasicAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Personalization_FullAccess]    Script Date: 12/21/2007 11:01:29 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_FullAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_FullAccess' AND type = 'R')

CREATE ROLE [aspnet_Personalization_FullAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Personalization_ReportingAccess]    Script Date: 12/21/2007 11:01:29 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_ReportingAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_ReportingAccess' AND type = 'R')

CREATE ROLE [aspnet_Personalization_ReportingAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Profile_BasicAccess]    Script Date: 12/21/2007 11:01:29 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_BasicAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_BasicAccess' AND type = 'R')

CREATE ROLE [aspnet_Profile_BasicAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Profile_FullAccess]    Script Date: 12/21/2007 11:01:30 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_FullAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_FullAccess' AND type = 'R')

CREATE ROLE [aspnet_Profile_FullAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Profile_ReportingAccess]    Script Date: 12/21/2007 11:01:30 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_ReportingAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_ReportingAccess' AND type = 'R')

CREATE ROLE [aspnet_Profile_ReportingAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Roles_BasicAccess]    Script Date: 12/21/2007 11:01:30 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_BasicAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_BasicAccess' AND type = 'R')

CREATE ROLE [aspnet_Roles_BasicAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Roles_FullAccess]    Script Date: 12/21/2007 11:01:30 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_FullAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_FullAccess' AND type = 'R')

CREATE ROLE [aspnet_Roles_FullAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_Roles_ReportingAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_ReportingAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_ReportingAccess' AND type = 'R')

CREATE ROLE [aspnet_Roles_ReportingAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Role [aspnet_WebEvent_FullAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_WebEvent_FullAccess')

BEGIN

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_WebEvent_FullAccess' AND type = 'R')

CREATE ROLE [aspnet_WebEvent_FullAccess] AUTHORIZATION [dbo]



END

GO

/****** Object:  Schema [aspnet_Membership_BasicAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_BasicAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Membership_BasicAccess] AUTHORIZATION [aspnet_Membership_BasicAccess]'

GO

/****** Object:  Schema [aspnet_Membership_FullAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_FullAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Membership_FullAccess] AUTHORIZATION [aspnet_Membership_FullAccess]'

GO

/****** Object:  Schema [aspnet_Membership_ReportingAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_ReportingAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Membership_ReportingAccess] AUTHORIZATION [aspnet_Membership_ReportingAccess]'

GO

/****** Object:  Schema [aspnet_Personalization_BasicAccess]    Script Date: 12/21/2007 11:01:31 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_BasicAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Personalization_BasicAccess] AUTHORIZATION [aspnet_Personalization_BasicAccess]'

GO

/****** Object:  Schema [aspnet_Personalization_FullAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_FullAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Personalization_FullAccess] AUTHORIZATION [aspnet_Personalization_FullAccess]'

GO

/****** Object:  Schema [aspnet_Personalization_ReportingAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_ReportingAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Personalization_ReportingAccess] AUTHORIZATION [aspnet_Personalization_ReportingAccess]'

GO

/****** Object:  Schema [aspnet_Profile_BasicAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_BasicAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Profile_BasicAccess] AUTHORIZATION [aspnet_Profile_BasicAccess]'

GO

/****** Object:  Schema [aspnet_Profile_FullAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_FullAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Profile_FullAccess] AUTHORIZATION [aspnet_Profile_FullAccess]'

GO

/****** Object:  Schema [aspnet_Profile_ReportingAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_ReportingAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Profile_ReportingAccess] AUTHORIZATION [aspnet_Profile_ReportingAccess]'

GO

/****** Object:  Schema [aspnet_Roles_BasicAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_BasicAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Roles_BasicAccess] AUTHORIZATION [aspnet_Roles_BasicAccess]'

GO

/****** Object:  Schema [aspnet_Roles_FullAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_FullAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Roles_FullAccess] AUTHORIZATION [aspnet_Roles_FullAccess]'

GO

/****** Object:  Schema [aspnet_Roles_ReportingAccess]    Script Date: 12/21/2007 11:01:32 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_ReportingAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_Roles_ReportingAccess] AUTHORIZATION [aspnet_Roles_ReportingAccess]'

GO

/****** Object:  Schema [aspnet_WebEvent_FullAccess]    Script Date: 12/21/2007 11:01:33 ******/

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_WebEvent_FullAccess')

EXEC sys.sp_executesql N'CREATE SCHEMA [aspnet_WebEvent_FullAccess] AUTHORIZATION [aspnet_WebEvent_FullAccess]'

GO

/****** Object:  Table [dbo].[aspnet_SchemaVersions]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_SchemaVersions]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_SchemaVersions](

	[Feature] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[CompatibleSchemaVersion] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[IsCurrentVersion] [bit] NOT NULL,

 CONSTRAINT [PK__aspnet_SchemaVer__0AD2A005] PRIMARY KEY CLUSTERED 

(

	[Feature] ASC,

	[CompatibleSchemaVersion] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'common', N'1', 1)

INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'health monitoring', N'1', 1)

INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'membership', N'1', 1)

INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'personalization', N'1', 1)

INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'profile', N'1', 1)

INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'role manager', N'1', 1)

/****** Object:  Table [dbo].[Messages]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Messages]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Messages](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[Subject] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[Text] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[PostedBy] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[PostedById] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[DatePosted] [smalldatetime] NOT NULL,

 CONSTRAINT [PK_Messages] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

SET IDENTITY_INSERT [dbo].[Messages] ON

INSERT [dbo].[Messages] ([Id], [Subject], [Text], [PostedBy], [PostedById], [DatePosted]) VALUES (1, N'This is a test', N'Might be the first test', N'(Anonymous)', N'', CAST(0x9A0800DF AS SmallDateTime))

INSERT [dbo].[Messages] ([Id], [Subject], [Text], [PostedBy], [PostedById], [DatePosted]) VALUES (2, N'Another test', N'Sure', N'(Anonymous)', N'', CAST(0x9A08015A AS SmallDateTime))

INSERT [dbo].[Messages] ([Id], [Subject], [Text], [PostedBy], [PostedById], [DatePosted]) VALUES (3, N'Microsoft Buys Multimap', N'Multimap will operate as a wholly owned subsidiary of Microsoft, as part of the Virtual Earth and Search teams in the Online Services Group. ', N'Satips', N'a27d69da-8471-4d83-92e0-e8fcd7d7f2f8', CAST(0x9A080410 AS SmallDateTime))

INSERT [dbo].[Messages] ([Id], [Subject], [Text], [PostedBy], [PostedById], [DatePosted]) VALUES (4, N'Top-secret US labs penetrated by phishers', N'One of the most sensitive science and technology labs in the US has been hacked as part of what it called "a sophisticated cyber attack that now appears to be part of a coordinated attempt to gain access to computer networks at numerous laboratories and other institutions across the country."

...

"At present we believe that about 11 staff opened the attachments, which enabled the hackers to infiltrate the system and remove data."

 



Sophisticated? A simple email with an executable attachment is sophisticated? That sounds like some huge spin to cover up brain dead stupidity to me. This behaviour I expect from a grandmother who just got on the internet for the first time, but 11 separate staff members at a secure reasearch lab? It boggles the mind.



http://www.channelregister.co.uk/2007/12/07/national_labs_breached', N'John Cardinal', N'51afff73-c57f-4a2e-ac86-6d7e77d104a8', CAST(0x9A080412 AS SmallDateTime))

SET IDENTITY_INSERT [dbo].[Messages] OFF

/****** Object:  StoredProcedure [dbo].[aspnet_Setup_RestorePermissions]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RestorePermissions]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Setup_RestorePermissions]

    @name   sysname

AS

BEGIN

    DECLARE @object sysname

    DECLARE @protectType char(10)

    DECLARE @action varchar(60)

    DECLARE @grantee sysname

    DECLARE @cmd nvarchar(500)

    DECLARE c1 cursor FORWARD_ONLY FOR

        SELECT Object, ProtectType, [Action], Grantee FROM #aspnet_Permissions where Object = @name



    OPEN c1



    FETCH c1 INTO @object, @protectType, @action, @grantee

    WHILE (@@fetch_status = 0)

    BEGIN

        SET @cmd = @protectType + '' '' + @action + '' on '' + @object + '' TO ['' + @grantee + '']''

        EXEC (@cmd)

        FETCH c1 INTO @object, @protectType, @action, @grantee

    END



    CLOSE c1

    DEALLOCATE c1

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RemoveAllRoleMembers]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Setup_RemoveAllRoleMembers]

    @name   sysname

AS

BEGIN

    CREATE TABLE #aspnet_RoleMembers

    (

        Group_name      sysname,

        Group_id        smallint,

        Users_in_group  sysname,

        User_id         smallint

    )



    INSERT INTO #aspnet_RoleMembers

    EXEC sp_helpuser @name



    DECLARE @user_id smallint

    DECLARE @cmd nvarchar(500)

    DECLARE c1 cursor FORWARD_ONLY FOR

        SELECT User_id FROM #aspnet_RoleMembers



    OPEN c1



    FETCH c1 INTO @user_id

    WHILE (@@fetch_status = 0)

    BEGIN

        SET @cmd = ''EXEC sp_droprolemember '' + '''''''' + @name + '''''', '''''' + USER_NAME(@user_id) + ''''''''

        EXEC (@cmd)

        FETCH c1 INTO @user_id

    END



    CLOSE c1

    DEALLOCATE c1

END' 

END

GO

/****** Object:  Table [dbo].[aspnet_Applications]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_Applications](

	[ApplicationName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[LoweredApplicationName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[ApplicationId] [uniqueidentifier] NOT NULL,

	[Description] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

 CONSTRAINT [PK__aspnet_Applicati__00551192] PRIMARY KEY NONCLUSTERED 

(

	[ApplicationId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON),

 CONSTRAINT [UQ__aspnet_Applicati__014935CB] UNIQUE NONCLUSTERED 

(

	[LoweredApplicationName] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON),

 CONSTRAINT [UQ__aspnet_Applicati__023D5A04] UNIQUE NONCLUSTERED 

(

	[ApplicationName] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]') AND name = N'aspnet_Applications_Index')

CREATE CLUSTERED INDEX [aspnet_Applications_Index] ON [dbo].[aspnet_Applications] 

(

	[LoweredApplicationName] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

INSERT [dbo].[aspnet_Applications] ([ApplicationName], [LoweredApplicationName], [ApplicationId], [Description]) VALUES (N'/', N'/', N'c26bc77c-1bba-44d7-bf37-2b40df275547', NULL)

/****** Object:  Table [dbo].[aspnet_WebEvent_Events]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_Events]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_WebEvent_Events](

	[EventId] [char](32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[EventTimeUtc] [datetime] NOT NULL,

	[EventTime] [datetime] NOT NULL,

	[EventType] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[EventSequence] [decimal](19, 0) NOT NULL,

	[EventOccurrence] [decimal](19, 0) NOT NULL,

	[EventCode] [int] NOT NULL,

	[EventDetailCode] [int] NOT NULL,

	[Message] [nvarchar](1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[ApplicationPath] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[ApplicationVirtualPath] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[MachineName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[RequestUrl] [nvarchar](1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[ExceptionType] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[Details] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

 CONSTRAINT [PK__aspnet_WebEvent___619B8048] PRIMARY KEY CLUSTERED 

(

	[EventId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

/****** Object:  Table [dbo].[aspnet_Users]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_Users](

	[ApplicationId] [uniqueidentifier] NOT NULL,

	[UserId] [uniqueidentifier] NOT NULL,

	[UserName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[LoweredUserName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[MobileAlias] [nvarchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[IsAnonymous] [bit] NOT NULL,

	[LastActivityDate] [datetime] NOT NULL,

 CONSTRAINT [PK__aspnet_Users__0519C6AF] PRIMARY KEY NONCLUSTERED 

(

	[UserId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND name = N'aspnet_Users_Index')

CREATE UNIQUE CLUSTERED INDEX [aspnet_Users_Index] ON [dbo].[aspnet_Users] 

(

	[ApplicationId] ASC,

	[LoweredUserName] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND name = N'aspnet_Users_Index2')

CREATE NONCLUSTERED INDEX [aspnet_Users_Index2] ON [dbo].[aspnet_Users] 

(

	[ApplicationId] ASC,

	[LastActivityDate] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

INSERT [dbo].[aspnet_Users] ([ApplicationId], [UserId], [UserName], [LoweredUserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'c26bc77c-1bba-44d7-bf37-2b40df275547', N'51afff73-c57f-4a2e-ac86-6d7e77d104a8', N'John Cardinal', N'john cardinal', NULL, 0, CAST(0x00009A08011E125A AS DateTime))

INSERT [dbo].[aspnet_Users] ([ApplicationId], [UserId], [UserName], [LoweredUserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'c26bc77c-1bba-44d7-bf37-2b40df275547', N'a27d69da-8471-4d83-92e0-e8fcd7d7f2f8', N'Satips', N'satips', NULL, 0, CAST(0x00009A08011CF85A AS DateTime))

/****** Object:  Table [dbo].[aspnet_Membership]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_Membership](

	[ApplicationId] [uniqueidentifier] NOT NULL,

	[UserId] [uniqueidentifier] NOT NULL,

	[Password] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[PasswordFormat] [int] NOT NULL,

	[PasswordSalt] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[MobilePIN] [nvarchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[Email] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[LoweredEmail] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[PasswordQuestion] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[PasswordAnswer] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

	[IsApproved] [bit] NOT NULL,

	[IsLockedOut] [bit] NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[LastLoginDate] [datetime] NOT NULL,

	[LastPasswordChangedDate] [datetime] NOT NULL,

	[LastLockoutDate] [datetime] NOT NULL,

	[FailedPasswordAttemptCount] [int] NOT NULL,

	[FailedPasswordAttemptWindowStart] [datetime] NOT NULL,

	[FailedPasswordAnswerAttemptCount] [int] NOT NULL,

	[FailedPasswordAnswerAttemptWindowStart] [datetime] NOT NULL,

	[Comment] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

 CONSTRAINT [PK__aspnet_Membershi__15502E78] PRIMARY KEY NONCLUSTERED 

(

	[UserId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]') AND name = N'aspnet_Membership_index')

CREATE CLUSTERED INDEX [aspnet_Membership_index] ON [dbo].[aspnet_Membership] 

(

	[ApplicationId] ASC,

	[LoweredEmail] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

INSERT [dbo].[aspnet_Membership] ([ApplicationId], [UserId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'c26bc77c-1bba-44d7-bf37-2b40df275547', N'51afff73-c57f-4a2e-ac86-6d7e77d104a8', N'VpyO6p2ZLq1jD9cO8i/Dd9Rg7fk=', 1, N'HihOe9wrgVsEe0OYbIMsTw==', NULL, N'j@j.com', N'j@j.com', N'test', N'SgDJfPiJOCcvLyAPwtRVcF5h5Is=', 1, 0, CAST(0x00009A08011E11FC AS DateTime), CAST(0x00009A08011E125A AS DateTime), CAST(0x00009A08011E11FC AS DateTime), CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), NULL)

INSERT [dbo].[aspnet_Membership] ([ApplicationId], [UserId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'c26bc77c-1bba-44d7-bf37-2b40df275547', N'a27d69da-8471-4d83-92e0-e8fcd7d7f2f8', N'sybahDKiuKeyTiotjOZdPgXYOzI=', 1, N'SKlPqKdXKNd4FmaaY+gOdw==', NULL, N'satips@satips.com', N'satips@satips.com', N'Test', N'RfoU8lqW5T2x4wUT6aMrm+UETfg=', 1, 0, CAST(0x00009A08011CF664 AS DateTime), CAST(0x00009A08011CF85A AS DateTime), CAST(0x00009A08011CF664 AS DateTime), CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), NULL)

/****** Object:  Table [dbo].[aspnet_Profile]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_Profile](

	[UserId] [uniqueidentifier] NOT NULL,

	[PropertyNames] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[PropertyValuesString] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[PropertyValuesBinary] [image] NOT NULL,

	[LastUpdatedDate] [datetime] NOT NULL,

 CONSTRAINT [PK__aspnet_Profile__2A4B4B5E] PRIMARY KEY CLUSTERED 

(

	[UserId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

/****** Object:  Table [dbo].[aspnet_Roles]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_Roles](

	[ApplicationId] [uniqueidentifier] NOT NULL,

	[RoleId] [uniqueidentifier] NOT NULL,

	[RoleName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[LoweredRoleName] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[Description] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

 CONSTRAINT [PK__aspnet_Roles__33D4B598] PRIMARY KEY NONCLUSTERED 

(

	[RoleId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]') AND name = N'aspnet_Roles_index1')

CREATE UNIQUE CLUSTERED INDEX [aspnet_Roles_index1] ON [dbo].[aspnet_Roles] 

(

	[ApplicationId] ASC,

	[LoweredRoleName] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

/****** Object:  Table [dbo].[aspnet_UsersInRoles]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_UsersInRoles](

	[UserId] [uniqueidentifier] NOT NULL,

	[RoleId] [uniqueidentifier] NOT NULL,

 CONSTRAINT [PK__aspnet_UsersInRo__37A5467C] PRIMARY KEY CLUSTERED 

(

	[UserId] ASC,

	[RoleId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]') AND name = N'aspnet_UsersInRoles_index')

CREATE NONCLUSTERED INDEX [aspnet_UsersInRoles_index] ON [dbo].[aspnet_UsersInRoles] 

(

	[RoleId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

/****** Object:  Table [dbo].[aspnet_Paths]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_Paths](

	[ApplicationId] [uniqueidentifier] NOT NULL,

	[PathId] [uniqueidentifier] NOT NULL,

	[Path] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

	[LoweredPath] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

 CONSTRAINT [PK__aspnet_Paths__46E78A0C] PRIMARY KEY NONCLUSTERED 

(

	[PathId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]') AND name = N'aspnet_Paths_index')

CREATE UNIQUE CLUSTERED INDEX [aspnet_Paths_index] ON [dbo].[aspnet_Paths] 

(

	[ApplicationId] ASC,

	[LoweredPath] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

/****** Object:  Table [dbo].[aspnet_PersonalizationPerUser]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_PersonalizationPerUser](

	[Id] [uniqueidentifier] NOT NULL,

	[PathId] [uniqueidentifier] NULL,

	[UserId] [uniqueidentifier] NULL,

	[PageSettings] [image] NOT NULL,

	[LastUpdatedDate] [datetime] NOT NULL,

 CONSTRAINT [PK__aspnet_Personali__4F7CD00D] PRIMARY KEY NONCLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]') AND name = N'aspnet_PersonalizationPerUser_index1')

CREATE UNIQUE CLUSTERED INDEX [aspnet_PersonalizationPerUser_index1] ON [dbo].[aspnet_PersonalizationPerUser] 

(

	[PathId] ASC,

	[UserId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]') AND name = N'aspnet_PersonalizationPerUser_ncindex2')

CREATE UNIQUE NONCLUSTERED INDEX [aspnet_PersonalizationPerUser_ncindex2] ON [dbo].[aspnet_PersonalizationPerUser] 

(

	[UserId] ASC,

	[PathId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

GO

/****** Object:  Table [dbo].[aspnet_PersonalizationAllUsers]    Script Date: 12/21/2007 11:01:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[aspnet_PersonalizationAllUsers](

	[PathId] [uniqueidentifier] NOT NULL,

	[PageSettings] [image] NOT NULL,

	[LastUpdatedDate] [datetime] NOT NULL,

 CONSTRAINT [PK__aspnet_Personali__4CA06362] PRIMARY KEY CLUSTERED 

(

	[PathId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)

)

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Users_CreateUser]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_CreateUser]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Users_CreateUser]

    @ApplicationId    uniqueidentifier,

    @UserName         nvarchar(256),

    @IsUserAnonymous  bit,

    @LastActivityDate DATETIME,

    @UserId           uniqueidentifier OUTPUT

AS

BEGIN

    IF( @UserId IS NULL )

        SELECT @UserId = NEWID()

    ELSE

    BEGIN

        IF( EXISTS( SELECT UserId FROM dbo.aspnet_Users

                    WHERE @UserId = UserId ) )

            RETURN -1

    END



    INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)

    VALUES (@ApplicationId, @UserId, @UserName, LOWER(@UserName), @IsUserAnonymous, @LastActivityDate)



    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Users_DeleteUser]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_DeleteUser]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Users_DeleteUser]

    @ApplicationName  nvarchar(256),

    @UserName         nvarchar(256),

    @TablesToDeleteFrom int,

    @NumTablesDeletedFrom int OUTPUT

AS

BEGIN

    DECLARE @UserId               uniqueidentifier

    SELECT  @UserId               = NULL

    SELECT  @NumTablesDeletedFrom = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

	    BEGIN TRANSACTION

	    SET @TranStarted = 1

    END

    ELSE

	SET @TranStarted = 0



    DECLARE @ErrorCode   int

    DECLARE @RowCount    int



    SET @ErrorCode = 0

    SET @RowCount  = 0



    SELECT  @UserId = u.UserId

    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a

    WHERE   u.LoweredUserName       = LOWER(@UserName)

        AND u.ApplicationId         = a.ApplicationId

        AND LOWER(@ApplicationName) = a.LoweredApplicationName



    IF (@UserId IS NULL)

    BEGIN

        GOTO Cleanup

    END



    -- Delete from Membership table if (@TablesToDeleteFrom & 1) is set

    IF ((@TablesToDeleteFrom & 1) <> 0 AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_MembershipUsers'') AND (type = ''V''))))

    BEGIN

        DELETE FROM dbo.aspnet_Membership WHERE @UserId = UserId



        SELECT @ErrorCode = @@ERROR,

               @RowCount = @@ROWCOUNT



        IF( @ErrorCode <> 0 )

            GOTO Cleanup



        IF (@RowCount <> 0)

            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1

    END



    -- Delete from aspnet_UsersInRoles table if (@TablesToDeleteFrom & 2) is set

    IF ((@TablesToDeleteFrom & 2) <> 0  AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_UsersInRoles'') AND (type = ''V''))) )

    BEGIN

        DELETE FROM dbo.aspnet_UsersInRoles WHERE @UserId = UserId



        SELECT @ErrorCode = @@ERROR,

                @RowCount = @@ROWCOUNT



        IF( @ErrorCode <> 0 )

            GOTO Cleanup



        IF (@RowCount <> 0)

            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1

    END



    -- Delete from aspnet_Profile table if (@TablesToDeleteFrom & 4) is set

    IF ((@TablesToDeleteFrom & 4) <> 0  AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_Profiles'') AND (type = ''V''))) )

    BEGIN

        DELETE FROM dbo.aspnet_Profile WHERE @UserId = UserId



        SELECT @ErrorCode = @@ERROR,

                @RowCount = @@ROWCOUNT



        IF( @ErrorCode <> 0 )

            GOTO Cleanup



        IF (@RowCount <> 0)

            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1

    END



    -- Delete from aspnet_PersonalizationPerUser table if (@TablesToDeleteFrom & 8) is set

    IF ((@TablesToDeleteFrom & 8) <> 0  AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_WebPartState_User'') AND (type = ''V''))) )

    BEGIN

        DELETE FROM dbo.aspnet_PersonalizationPerUser WHERE @UserId = UserId



        SELECT @ErrorCode = @@ERROR,

                @RowCount = @@ROWCOUNT



        IF( @ErrorCode <> 0 )

            GOTO Cleanup



        IF (@RowCount <> 0)

            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1

    END



    -- Delete from aspnet_Users table if (@TablesToDeleteFrom & 1,2,4 & 8) are all set

    IF ((@TablesToDeleteFrom & 1) <> 0 AND

        (@TablesToDeleteFrom & 2) <> 0 AND

        (@TablesToDeleteFrom & 4) <> 0 AND

        (@TablesToDeleteFrom & 8) <> 0 AND

        (EXISTS (SELECT UserId FROM dbo.aspnet_Users WHERE @UserId = UserId)))

    BEGIN

        DELETE FROM dbo.aspnet_Users WHERE @UserId = UserId



        SELECT @ErrorCode = @@ERROR,

                @RowCount = @@ROWCOUNT



        IF( @ErrorCode <> 0 )

            GOTO Cleanup



        IF (@RowCount <> 0)

            SELECT  @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1

    END



    IF( @TranStarted = 1 )

    BEGIN

	    SET @TranStarted = 0

	    COMMIT TRANSACTION

    END



    RETURN 0



Cleanup:

    SET @NumTablesDeletedFrom = 0



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

	    ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode



END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_AnyDataInTables]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_AnyDataInTables]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_AnyDataInTables]

    @TablesToCheck int

AS

BEGIN

    -- Check Membership table if (@TablesToCheck & 1) is set

    IF ((@TablesToCheck & 1) <> 0 AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_MembershipUsers'') AND (type = ''V''))))

    BEGIN

        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Membership))

        BEGIN

            SELECT N''aspnet_Membership''

            RETURN

        END

    END



    -- Check aspnet_Roles table if (@TablesToCheck & 2) is set

    IF ((@TablesToCheck & 2) <> 0  AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_Roles'') AND (type = ''V''))) )

    BEGIN

        IF (EXISTS(SELECT TOP 1 RoleId FROM dbo.aspnet_Roles))

        BEGIN

            SELECT N''aspnet_Roles''

            RETURN

        END

    END



    -- Check aspnet_Profile table if (@TablesToCheck & 4) is set

    IF ((@TablesToCheck & 4) <> 0  AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_Profiles'') AND (type = ''V''))) )

    BEGIN

        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Profile))

        BEGIN

            SELECT N''aspnet_Profile''

            RETURN

        END

    END



    -- Check aspnet_PersonalizationPerUser table if (@TablesToCheck & 8) is set

    IF ((@TablesToCheck & 8) <> 0  AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''vw_aspnet_WebPartState_User'') AND (type = ''V''))) )

    BEGIN

        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_PersonalizationPerUser))

        BEGIN

            SELECT N''aspnet_PersonalizationPerUser''

            RETURN

        END

    END



    -- Check aspnet_PersonalizationPerUser table if (@TablesToCheck & 16) is set

    IF ((@TablesToCheck & 16) <> 0  AND

        (EXISTS (SELECT name FROM sysobjects WHERE (name = N''aspnet_WebEvent_LogEvent'') AND (type = ''P''))) )

    BEGIN

        IF (EXISTS(SELECT TOP 1 * FROM dbo.aspnet_WebEvent_Events))

        BEGIN

            SELECT N''aspnet_WebEvent_Events''

            RETURN

        END

    END



    -- Check aspnet_Users table if (@TablesToCheck & 1,2,4 & 8) are all set

    IF ((@TablesToCheck & 1) <> 0 AND

        (@TablesToCheck & 2) <> 0 AND

        (@TablesToCheck & 4) <> 0 AND

        (@TablesToCheck & 8) <> 0 AND

        (@TablesToCheck & 32) <> 0 AND

        (@TablesToCheck & 128) <> 0 AND

        (@TablesToCheck & 256) <> 0 AND

        (@TablesToCheck & 512) <> 0 AND

        (@TablesToCheck & 1024) <> 0)

    BEGIN

        IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Users))

        BEGIN

            SELECT N''aspnet_Users''

            RETURN

        END

        IF (EXISTS(SELECT TOP 1 ApplicationId FROM dbo.aspnet_Applications))

        BEGIN

            SELECT N''aspnet_Applications''

            RETURN

        END

    END

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByName]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByName]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_GetUserByName]

    @ApplicationName      nvarchar(256),

    @UserName             nvarchar(256),

    @CurrentTimeUtc       datetime,

    @UpdateLastActivity   bit = 0

AS

BEGIN

    DECLARE @UserId uniqueidentifier



    IF (@UpdateLastActivity = 1)

    BEGIN

        SELECT TOP 1 m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,

                m.CreateDate, m.LastLoginDate, @CurrentTimeUtc, m.LastPasswordChangedDate,

                u.UserId, m.IsLockedOut,m.LastLockoutDate

        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m

        WHERE    LOWER(@ApplicationName) = a.LoweredApplicationName AND

                u.ApplicationId = a.ApplicationId    AND

                LOWER(@UserName) = u.LoweredUserName AND u.UserId = m.UserId



        IF (@@ROWCOUNT = 0) -- Username not found

            RETURN -1



        UPDATE   dbo.aspnet_Users

        SET      LastActivityDate = @CurrentTimeUtc

        WHERE    @UserId = UserId

    END

    ELSE

    BEGIN

        SELECT TOP 1 m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,

                m.CreateDate, m.LastLoginDate, u.LastActivityDate, m.LastPasswordChangedDate,

                u.UserId, m.IsLockedOut,m.LastLockoutDate

        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m

        WHERE    LOWER(@ApplicationName) = a.LoweredApplicationName AND

                u.ApplicationId = a.ApplicationId    AND

                LOWER(@UserName) = u.LoweredUserName AND u.UserId = m.UserId



        IF (@@ROWCOUNT = 0) -- Username not found

            RETURN -1

    END



    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByUserId]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByUserId]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_GetUserByUserId]

    @UserId               uniqueidentifier,

    @CurrentTimeUtc       datetime,

    @UpdateLastActivity   bit = 0

AS

BEGIN

    IF ( @UpdateLastActivity = 1 )

    BEGIN

        UPDATE   dbo.aspnet_Users

        SET      LastActivityDate = @CurrentTimeUtc

        FROM     dbo.aspnet_Users

        WHERE    @UserId = UserId



        IF ( @@ROWCOUNT = 0 ) -- User ID not found

            RETURN -1

    END



    SELECT  m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,

            m.CreateDate, m.LastLoginDate, u.LastActivityDate,

            m.LastPasswordChangedDate, u.UserName, m.IsLockedOut,

            m.LastLockoutDate

    FROM    dbo.aspnet_Users u, dbo.aspnet_Membership m

    WHERE   @UserId = u.UserId AND u.UserId = m.UserId



    IF ( @@ROWCOUNT = 0 ) -- User ID not found

       RETURN -1



    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetUserByEmail]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByEmail]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_GetUserByEmail]

    @ApplicationName  nvarchar(256),

    @Email            nvarchar(256)

AS

BEGIN

    IF( @Email IS NULL )

        SELECT  u.UserName

        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m

        WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND

                u.ApplicationId = a.ApplicationId    AND

                u.UserId = m.UserId AND

                m.LoweredEmail IS NULL

    ELSE

        SELECT  u.UserName

        FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m

        WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND

                u.ApplicationId = a.ApplicationId    AND

                u.UserId = m.UserId AND

                LOWER(@Email) = m.LoweredEmail



    IF (@@rowcount = 0)

        RETURN(1)

    RETURN(0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetPasswordWithFormat]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPasswordWithFormat]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_GetPasswordWithFormat]

    @ApplicationName                nvarchar(256),

    @UserName                       nvarchar(256),

    @UpdateLastLoginActivityDate    bit,

    @CurrentTimeUtc                 datetime

AS

BEGIN

    DECLARE @IsLockedOut                        bit

    DECLARE @UserId                             uniqueidentifier

    DECLARE @Password                           nvarchar(128)

    DECLARE @PasswordSalt                       nvarchar(128)

    DECLARE @PasswordFormat                     int

    DECLARE @FailedPasswordAttemptCount         int

    DECLARE @FailedPasswordAnswerAttemptCount   int

    DECLARE @IsApproved                         bit

    DECLARE @LastActivityDate                   datetime

    DECLARE @LastLoginDate                      datetime



    SELECT  @UserId          = NULL



    SELECT  @UserId = u.UserId, @IsLockedOut = m.IsLockedOut, @Password=Password, @PasswordFormat=PasswordFormat,

            @PasswordSalt=PasswordSalt, @FailedPasswordAttemptCount=FailedPasswordAttemptCount,

		    @FailedPasswordAnswerAttemptCount=FailedPasswordAnswerAttemptCount, @IsApproved=IsApproved,

            @LastActivityDate = LastActivityDate, @LastLoginDate = LastLoginDate

    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m

    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.ApplicationId = a.ApplicationId    AND

            u.UserId = m.UserId AND

            LOWER(@UserName) = u.LoweredUserName



    IF (@UserId IS NULL)

        RETURN 1



    IF (@IsLockedOut = 1)

        RETURN 99



    SELECT   @Password, @PasswordFormat, @PasswordSalt, @FailedPasswordAttemptCount,

             @FailedPasswordAnswerAttemptCount, @IsApproved, @LastLoginDate, @LastActivityDate



    IF (@UpdateLastLoginActivityDate = 1 AND @IsApproved = 1)

    BEGIN

        UPDATE  dbo.aspnet_Membership

        SET     LastLoginDate = @CurrentTimeUtc

        WHERE   UserId = @UserId



        UPDATE  dbo.aspnet_Users

        SET     LastActivityDate = @CurrentTimeUtc

        WHERE   @UserId = UserId

    END





    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UpdateUserInfo]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUserInfo]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_UpdateUserInfo]

    @ApplicationName                nvarchar(256),

    @UserName                       nvarchar(256),

    @IsPasswordCorrect              bit,

    @UpdateLastLoginActivityDate    bit,

    @MaxInvalidPasswordAttempts     int,

    @PasswordAttemptWindow          int,

    @CurrentTimeUtc                 datetime,

    @LastLoginDate                  datetime,

    @LastActivityDate               datetime

AS

BEGIN

    DECLARE @UserId                                 uniqueidentifier

    DECLARE @IsApproved                             bit

    DECLARE @IsLockedOut                            bit

    DECLARE @LastLockoutDate                        datetime

    DECLARE @FailedPasswordAttemptCount             int

    DECLARE @FailedPasswordAttemptWindowStart       datetime

    DECLARE @FailedPasswordAnswerAttemptCount       int

    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime



    DECLARE @ErrorCode     int

    SET @ErrorCode = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

	    BEGIN TRANSACTION

	    SET @TranStarted = 1

    END

    ELSE

    	SET @TranStarted = 0



    SELECT  @UserId = u.UserId,

            @IsApproved = m.IsApproved,

            @IsLockedOut = m.IsLockedOut,

            @LastLockoutDate = m.LastLockoutDate,

            @FailedPasswordAttemptCount = m.FailedPasswordAttemptCount,

            @FailedPasswordAttemptWindowStart = m.FailedPasswordAttemptWindowStart,

            @FailedPasswordAnswerAttemptCount = m.FailedPasswordAnswerAttemptCount,

            @FailedPasswordAnswerAttemptWindowStart = m.FailedPasswordAnswerAttemptWindowStart

    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m WITH ( UPDLOCK )

    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.ApplicationId = a.ApplicationId    AND

            u.UserId = m.UserId AND

            LOWER(@UserName) = u.LoweredUserName



    IF ( @@rowcount = 0 )

    BEGIN

        SET @ErrorCode = 1

        GOTO Cleanup

    END



    IF( @IsLockedOut = 1 )

    BEGIN

        GOTO Cleanup

    END



    IF( @IsPasswordCorrect = 0 )

    BEGIN

        IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAttemptWindowStart ) )

        BEGIN

            SET @FailedPasswordAttemptWindowStart = @CurrentTimeUtc

            SET @FailedPasswordAttemptCount = 1

        END

        ELSE

        BEGIN

            SET @FailedPasswordAttemptWindowStart = @CurrentTimeUtc

            SET @FailedPasswordAttemptCount = @FailedPasswordAttemptCount + 1

        END



        BEGIN

            IF( @FailedPasswordAttemptCount >= @MaxInvalidPasswordAttempts )

            BEGIN

                SET @IsLockedOut = 1

                SET @LastLockoutDate = @CurrentTimeUtc

            END

        END

    END

    ELSE

    BEGIN

        IF( @FailedPasswordAttemptCount > 0 OR @FailedPasswordAnswerAttemptCount > 0 )

        BEGIN

            SET @FailedPasswordAttemptCount = 0

            SET @FailedPasswordAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 )

            SET @FailedPasswordAnswerAttemptCount = 0

            SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 )

            SET @LastLockoutDate = CONVERT( datetime, ''17540101'', 112 )

        END

    END



    IF( @UpdateLastLoginActivityDate = 1 )

    BEGIN

        UPDATE  dbo.aspnet_Users

        SET     LastActivityDate = @LastActivityDate

        WHERE   @UserId = UserId



        IF( @@ERROR <> 0 )

        BEGIN

            SET @ErrorCode = -1

            GOTO Cleanup

        END



        UPDATE  dbo.aspnet_Membership

        SET     LastLoginDate = @LastLoginDate

        WHERE   UserId = @UserId



        IF( @@ERROR <> 0 )

        BEGIN

            SET @ErrorCode = -1

            GOTO Cleanup

        END

    END





    UPDATE dbo.aspnet_Membership

    SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,

        FailedPasswordAttemptCount = @FailedPasswordAttemptCount,

        FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,

        FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,

        FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart

    WHERE @UserId = UserId



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF( @TranStarted = 1 )

    BEGIN

	SET @TranStarted = 0

	COMMIT TRANSACTION

    END



    RETURN @ErrorCode



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

    	ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode



END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetPassword]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPassword]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_GetPassword]

    @ApplicationName                nvarchar(256),

    @UserName                       nvarchar(256),

    @MaxInvalidPasswordAttempts     int,

    @PasswordAttemptWindow          int,

    @CurrentTimeUtc                 datetime,

    @PasswordAnswer                 nvarchar(128) = NULL

AS

BEGIN

    DECLARE @UserId                                 uniqueidentifier

    DECLARE @PasswordFormat                         int

    DECLARE @Password                               nvarchar(128)

    DECLARE @passAns                                nvarchar(128)

    DECLARE @IsLockedOut                            bit

    DECLARE @LastLockoutDate                        datetime

    DECLARE @FailedPasswordAttemptCount             int

    DECLARE @FailedPasswordAttemptWindowStart       datetime

    DECLARE @FailedPasswordAnswerAttemptCount       int

    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime



    DECLARE @ErrorCode     int

    SET @ErrorCode = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

	    BEGIN TRANSACTION

	    SET @TranStarted = 1

    END

    ELSE

    	SET @TranStarted = 0



    SELECT  @UserId = u.UserId,

            @Password = m.Password,

            @passAns = m.PasswordAnswer,

            @PasswordFormat = m.PasswordFormat,

            @IsLockedOut = m.IsLockedOut,

            @LastLockoutDate = m.LastLockoutDate,

            @FailedPasswordAttemptCount = m.FailedPasswordAttemptCount,

            @FailedPasswordAttemptWindowStart = m.FailedPasswordAttemptWindowStart,

            @FailedPasswordAnswerAttemptCount = m.FailedPasswordAnswerAttemptCount,

            @FailedPasswordAnswerAttemptWindowStart = m.FailedPasswordAnswerAttemptWindowStart

    FROM    dbo.aspnet_Applications a, dbo.aspnet_Users u, dbo.aspnet_Membership m WITH ( UPDLOCK )

    WHERE   LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.ApplicationId = a.ApplicationId    AND

            u.UserId = m.UserId AND

            LOWER(@UserName) = u.LoweredUserName



    IF ( @@rowcount = 0 )

    BEGIN

        SET @ErrorCode = 1

        GOTO Cleanup

    END



    IF( @IsLockedOut = 1 )

    BEGIN

        SET @ErrorCode = 99

        GOTO Cleanup

    END



    IF ( NOT( @PasswordAnswer IS NULL ) )

    BEGIN

        IF( ( @passAns IS NULL ) OR ( LOWER( @passAns ) <> LOWER( @PasswordAnswer ) ) )

        BEGIN

            IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAnswerAttemptWindowStart ) )

            BEGIN

                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc

                SET @FailedPasswordAnswerAttemptCount = 1

            END

            ELSE

            BEGIN

                SET @FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount + 1

                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc

            END



            BEGIN

                IF( @FailedPasswordAnswerAttemptCount >= @MaxInvalidPasswordAttempts )

                BEGIN

                    SET @IsLockedOut = 1

                    SET @LastLockoutDate = @CurrentTimeUtc

                END

            END



            SET @ErrorCode = 3

        END

        ELSE

        BEGIN

            IF( @FailedPasswordAnswerAttemptCount > 0 )

            BEGIN

                SET @FailedPasswordAnswerAttemptCount = 0

                SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 )

            END

        END



        UPDATE dbo.aspnet_Membership

        SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,

            FailedPasswordAttemptCount = @FailedPasswordAttemptCount,

            FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,

            FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,

            FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart

        WHERE @UserId = UserId



        IF( @@ERROR <> 0 )

        BEGIN

            SET @ErrorCode = -1

            GOTO Cleanup

        END

    END



    IF( @TranStarted = 1 )

    BEGIN

	SET @TranStarted = 0

	COMMIT TRANSACTION

    END



    IF( @ErrorCode = 0 )

        SELECT @Password, @PasswordFormat



    RETURN @ErrorCode



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

    	ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode



END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_SetPassword]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_SetPassword]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_SetPassword]

    @ApplicationName  nvarchar(256),

    @UserName         nvarchar(256),

    @NewPassword      nvarchar(128),

    @PasswordSalt     nvarchar(128),

    @CurrentTimeUtc   datetime,

    @PasswordFormat   int = 0

AS

BEGIN

    DECLARE @UserId uniqueidentifier

    SELECT  @UserId = NULL

    SELECT  @UserId = u.UserId

    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m

    WHERE   LoweredUserName = LOWER(@UserName) AND

            u.ApplicationId = a.ApplicationId  AND

            LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.UserId = m.UserId



    IF (@UserId IS NULL)

        RETURN(1)



    UPDATE dbo.aspnet_Membership

    SET Password = @NewPassword, PasswordFormat = @PasswordFormat, PasswordSalt = @PasswordSalt,

        LastPasswordChangedDate = @CurrentTimeUtc

    WHERE @UserId = UserId

    RETURN(0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_ResetPassword]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ResetPassword]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_ResetPassword]

    @ApplicationName             nvarchar(256),

    @UserName                    nvarchar(256),

    @NewPassword                 nvarchar(128),

    @MaxInvalidPasswordAttempts  int,

    @PasswordAttemptWindow       int,

    @PasswordSalt                nvarchar(128),

    @CurrentTimeUtc              datetime,

    @PasswordFormat              int = 0,

    @PasswordAnswer              nvarchar(128) = NULL

AS

BEGIN

    DECLARE @IsLockedOut                            bit

    DECLARE @LastLockoutDate                        datetime

    DECLARE @FailedPasswordAttemptCount             int

    DECLARE @FailedPasswordAttemptWindowStart       datetime

    DECLARE @FailedPasswordAnswerAttemptCount       int

    DECLARE @FailedPasswordAnswerAttemptWindowStart datetime



    DECLARE @UserId                                 uniqueidentifier

    SET     @UserId = NULL



    DECLARE @ErrorCode     int

    SET @ErrorCode = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

	    BEGIN TRANSACTION

	    SET @TranStarted = 1

    END

    ELSE

    	SET @TranStarted = 0



    SELECT  @UserId = u.UserId

    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m

    WHERE   LoweredUserName = LOWER(@UserName) AND

            u.ApplicationId = a.ApplicationId  AND

            LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.UserId = m.UserId



    IF ( @UserId IS NULL )

    BEGIN

        SET @ErrorCode = 1

        GOTO Cleanup

    END



    SELECT @IsLockedOut = IsLockedOut,

           @LastLockoutDate = LastLockoutDate,

           @FailedPasswordAttemptCount = FailedPasswordAttemptCount,

           @FailedPasswordAttemptWindowStart = FailedPasswordAttemptWindowStart,

           @FailedPasswordAnswerAttemptCount = FailedPasswordAnswerAttemptCount,

           @FailedPasswordAnswerAttemptWindowStart = FailedPasswordAnswerAttemptWindowStart

    FROM dbo.aspnet_Membership WITH ( UPDLOCK )

    WHERE @UserId = UserId



    IF( @IsLockedOut = 1 )

    BEGIN

        SET @ErrorCode = 99

        GOTO Cleanup

    END



    UPDATE dbo.aspnet_Membership

    SET    Password = @NewPassword,

           LastPasswordChangedDate = @CurrentTimeUtc,

           PasswordFormat = @PasswordFormat,

           PasswordSalt = @PasswordSalt

    WHERE  @UserId = UserId AND

           ( ( @PasswordAnswer IS NULL ) OR ( LOWER( PasswordAnswer ) = LOWER( @PasswordAnswer ) ) )



    IF ( @@ROWCOUNT = 0 )

        BEGIN

            IF( @CurrentTimeUtc > DATEADD( minute, @PasswordAttemptWindow, @FailedPasswordAnswerAttemptWindowStart ) )

            BEGIN

                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc

                SET @FailedPasswordAnswerAttemptCount = 1

            END

            ELSE

            BEGIN

                SET @FailedPasswordAnswerAttemptWindowStart = @CurrentTimeUtc

                SET @FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount + 1

            END



            BEGIN

                IF( @FailedPasswordAnswerAttemptCount >= @MaxInvalidPasswordAttempts )

                BEGIN

                    SET @IsLockedOut = 1

                    SET @LastLockoutDate = @CurrentTimeUtc

                END

            END



            SET @ErrorCode = 3

        END

    ELSE

        BEGIN

            IF( @FailedPasswordAnswerAttemptCount > 0 )

            BEGIN

                SET @FailedPasswordAnswerAttemptCount = 0

                SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 )

            END

        END



    IF( NOT ( @PasswordAnswer IS NULL ) )

    BEGIN

        UPDATE dbo.aspnet_Membership

        SET IsLockedOut = @IsLockedOut, LastLockoutDate = @LastLockoutDate,

            FailedPasswordAttemptCount = @FailedPasswordAttemptCount,

            FailedPasswordAttemptWindowStart = @FailedPasswordAttemptWindowStart,

            FailedPasswordAnswerAttemptCount = @FailedPasswordAnswerAttemptCount,

            FailedPasswordAnswerAttemptWindowStart = @FailedPasswordAnswerAttemptWindowStart

        WHERE @UserId = UserId



        IF( @@ERROR <> 0 )

        BEGIN

            SET @ErrorCode = -1

            GOTO Cleanup

        END

    END



    IF( @TranStarted = 1 )

    BEGIN

	SET @TranStarted = 0

	COMMIT TRANSACTION

    END



    RETURN @ErrorCode



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

    	ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode



END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UnlockUser]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UnlockUser]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_UnlockUser]

    @ApplicationName                         nvarchar(256),

    @UserName                                nvarchar(256)

AS

BEGIN

    DECLARE @UserId uniqueidentifier

    SELECT  @UserId = NULL

    SELECT  @UserId = u.UserId

    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m

    WHERE   LoweredUserName = LOWER(@UserName) AND

            u.ApplicationId = a.ApplicationId  AND

            LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.UserId = m.UserId



    IF ( @UserId IS NULL )

        RETURN 1



    UPDATE dbo.aspnet_Membership

    SET IsLockedOut = 0,

        FailedPasswordAttemptCount = 0,

        FailedPasswordAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 ),

        FailedPasswordAnswerAttemptCount = 0,

        FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 ),

        LastLockoutDate = CONVERT( datetime, ''17540101'', 112 )

    WHERE @UserId = UserId



    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_IsUserInRole]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_IsUserInRole]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_IsUserInRole]

    @ApplicationName  nvarchar(256),

    @UserName         nvarchar(256),

    @RoleName         nvarchar(256)

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN(2)

    DECLARE @UserId uniqueidentifier

    SELECT  @UserId = NULL

    DECLARE @RoleId uniqueidentifier

    SELECT  @RoleId = NULL



    SELECT  @UserId = UserId

    FROM    dbo.aspnet_Users

    WHERE   LoweredUserName = LOWER(@UserName) AND ApplicationId = @ApplicationId



    IF (@UserId IS NULL)

        RETURN(2)



    SELECT  @RoleId = RoleId

    FROM    dbo.aspnet_Roles

    WHERE   LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId



    IF (@RoleId IS NULL)

        RETURN(3)



    IF (EXISTS( SELECT * FROM dbo.aspnet_UsersInRoles WHERE  UserId = @UserId AND RoleId = @RoleId))

        RETURN(1)

    ELSE

        RETURN(0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]

    @ApplicationName        nvarchar(256),

    @ProfileAuthOptions     int,

    @InactiveSinceDate      datetime

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

    BEGIN

        SELECT 0

        RETURN

    END



    SELECT  COUNT(*)

    FROM    dbo.aspnet_Users u, dbo.aspnet_Profile p

    WHERE   ApplicationId = @ApplicationId

        AND u.UserId = p.UserId

        AND (LastActivityDate <= @InactiveSinceDate)

        AND (

                (@ProfileAuthOptions = 2)

                OR (@ProfileAuthOptions = 0 AND IsAnonymous = 1)

                OR (@ProfileAuthOptions = 1 AND IsAnonymous = 0)

            )

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_UpdateUser]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUser]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_UpdateUser]

    @ApplicationName      nvarchar(256),

    @UserName             nvarchar(256),

    @Email                nvarchar(256),

    @Comment              ntext,

    @IsApproved           bit,

    @LastLoginDate        datetime,

    @LastActivityDate     datetime,

    @UniqueEmail          int,

    @CurrentTimeUtc       datetime

AS

BEGIN

    DECLARE @UserId uniqueidentifier

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @UserId = NULL

    SELECT  @UserId = u.UserId, @ApplicationId = a.ApplicationId

    FROM    dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m

    WHERE   LoweredUserName = LOWER(@UserName) AND

            u.ApplicationId = a.ApplicationId  AND

            LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.UserId = m.UserId



    IF (@UserId IS NULL)

        RETURN(1)



    IF (@UniqueEmail = 1)

    BEGIN

        IF (EXISTS (SELECT *

                    FROM  dbo.aspnet_Membership WITH (UPDLOCK, HOLDLOCK)

                    WHERE ApplicationId = @ApplicationId  AND @UserId <> UserId AND LoweredEmail = LOWER(@Email)))

        BEGIN

            RETURN(7)

        END

    END



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

	    BEGIN TRANSACTION

	    SET @TranStarted = 1

    END

    ELSE

	SET @TranStarted = 0



    UPDATE dbo.aspnet_Users WITH (ROWLOCK)

    SET

         LastActivityDate = @LastActivityDate

    WHERE

       @UserId = UserId



    IF( @@ERROR <> 0 )

        GOTO Cleanup



    UPDATE dbo.aspnet_Membership WITH (ROWLOCK)

    SET

         Email            = @Email,

         LoweredEmail     = LOWER(@Email),

         Comment          = @Comment,

         IsApproved       = @IsApproved,

         LastLoginDate    = @LastLoginDate

    WHERE

       @UserId = UserId



    IF( @@ERROR <> 0 )

        GOTO Cleanup



    IF( @TranStarted = 1 )

    BEGIN

	SET @TranStarted = 0

	COMMIT TRANSACTION

    END



    RETURN 0



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

    	ROLLBACK TRANSACTION

    END



    RETURN -1

END' 

END

GO

/****** Object:  View [dbo].[vw_aspnet_MembershipUsers]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_MembershipUsers]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_MembershipUsers]

  AS SELECT [dbo].[aspnet_Membership].[UserId],

            [dbo].[aspnet_Membership].[PasswordFormat],

            [dbo].[aspnet_Membership].[MobilePIN],

            [dbo].[aspnet_Membership].[Email],

            [dbo].[aspnet_Membership].[LoweredEmail],

            [dbo].[aspnet_Membership].[PasswordQuestion],

            [dbo].[aspnet_Membership].[PasswordAnswer],

            [dbo].[aspnet_Membership].[IsApproved],

            [dbo].[aspnet_Membership].[IsLockedOut],

            [dbo].[aspnet_Membership].[CreateDate],

            [dbo].[aspnet_Membership].[LastLoginDate],

            [dbo].[aspnet_Membership].[LastPasswordChangedDate],

            [dbo].[aspnet_Membership].[LastLockoutDate],

            [dbo].[aspnet_Membership].[FailedPasswordAttemptCount],

            [dbo].[aspnet_Membership].[FailedPasswordAttemptWindowStart],

            [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptCount],

            [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptWindowStart],

            [dbo].[aspnet_Membership].[Comment],

            [dbo].[aspnet_Users].[ApplicationId],

            [dbo].[aspnet_Users].[UserName],

            [dbo].[aspnet_Users].[MobileAlias],

            [dbo].[aspnet_Users].[IsAnonymous],

            [dbo].[aspnet_Users].[LastActivityDate]

  FROM [dbo].[aspnet_Membership] INNER JOIN [dbo].[aspnet_Users]

      ON [dbo].[aspnet_Membership].[UserId] = [dbo].[aspnet_Users].[UserId]

  '

GO

/****** Object:  View [dbo].[vw_aspnet_Users]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Users]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_Users]

  AS SELECT [dbo].[aspnet_Users].[ApplicationId], [dbo].[aspnet_Users].[UserId], [dbo].[aspnet_Users].[UserName], [dbo].[aspnet_Users].[LoweredUserName], [dbo].[aspnet_Users].[MobileAlias], [dbo].[aspnet_Users].[IsAnonymous], [dbo].[aspnet_Users].[LastActivityDate]

  FROM [dbo].[aspnet_Users]

  '

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_DeleteInactiveProfiles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteInactiveProfiles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Profile_DeleteInactiveProfiles]

    @ApplicationName        nvarchar(256),

    @ProfileAuthOptions     int,

    @InactiveSinceDate      datetime

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

    BEGIN

        SELECT  0

        RETURN

    END



    DELETE

    FROM    dbo.aspnet_Profile

    WHERE   UserId IN

            (   SELECT  UserId

                FROM    dbo.aspnet_Users u

                WHERE   ApplicationId = @ApplicationId

                        AND (LastActivityDate <= @InactiveSinceDate)

                        AND (

                                (@ProfileAuthOptions = 2)

                             OR (@ProfileAuthOptions = 0 AND IsAnonymous = 1)

                             OR (@ProfileAuthOptions = 1 AND IsAnonymous = 0)

                            )

            )



    SELECT  @@ROWCOUNT

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetProperties]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProperties]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Profile_GetProperties]

    @ApplicationName      nvarchar(256),

    @UserName             nvarchar(256),

    @CurrentTimeUtc       datetime

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN



    DECLARE @UserId uniqueidentifier

    SELECT  @UserId = NULL



    SELECT @UserId = UserId

    FROM   dbo.aspnet_Users

    WHERE  ApplicationId = @ApplicationId AND LoweredUserName = LOWER(@UserName)



    IF (@UserId IS NULL)

        RETURN

    SELECT TOP 1 PropertyNames, PropertyValuesString, PropertyValuesBinary

    FROM         dbo.aspnet_Profile

    WHERE        UserId = @UserId



    IF (@@ROWCOUNT > 0)

    BEGIN

        UPDATE dbo.aspnet_Users

        SET    LastActivityDate=@CurrentTimeUtc

        WHERE  UserId = @UserId

    END

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]

    @ApplicationName       nvarchar(256),

    @UserName              nvarchar(256),

    @NewPasswordQuestion   nvarchar(256),

    @NewPasswordAnswer     nvarchar(128)

AS

BEGIN

    DECLARE @UserId uniqueidentifier

    SELECT  @UserId = NULL

    SELECT  @UserId = u.UserId

    FROM    dbo.aspnet_Membership m, dbo.aspnet_Users u, dbo.aspnet_Applications a

    WHERE   LoweredUserName = LOWER(@UserName) AND

            u.ApplicationId = a.ApplicationId  AND

            LOWER(@ApplicationName) = a.LoweredApplicationName AND

            u.UserId = m.UserId

    IF (@UserId IS NULL)

    BEGIN

        RETURN(1)

    END



    UPDATE dbo.aspnet_Membership

    SET    PasswordQuestion = @NewPasswordQuestion, PasswordAnswer = @NewPasswordAnswer

    WHERE  UserId=@UserId

    RETURN(0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetNumberOfUsersOnline]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetNumberOfUsersOnline]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_GetNumberOfUsersOnline]

    @ApplicationName            nvarchar(256),

    @MinutesSinceLastInActive   int,

    @CurrentTimeUtc             datetime

AS

BEGIN

    DECLARE @DateActive datetime

    SELECT  @DateActive = DATEADD(minute,  -(@MinutesSinceLastInActive), @CurrentTimeUtc)



    DECLARE @NumOnline int

    SELECT  @NumOnline = COUNT(*)

    FROM    dbo.aspnet_Users u(NOLOCK),

            dbo.aspnet_Applications a(NOLOCK),

            dbo.aspnet_Membership m(NOLOCK)

    WHERE   u.ApplicationId = a.ApplicationId                  AND

            LastActivityDate > @DateActive                     AND

            a.LoweredApplicationName = LOWER(@ApplicationName) AND

            u.UserId = m.UserId

    RETURN(@NumOnline)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_GetUsersInRoles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetUsersInRoles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_GetUsersInRoles]

    @ApplicationName  nvarchar(256),

    @RoleName         nvarchar(256)

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN(1)

     DECLARE @RoleId uniqueidentifier

     SELECT  @RoleId = NULL



     SELECT  @RoleId = RoleId

     FROM    dbo.aspnet_Roles

     WHERE   LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId



     IF (@RoleId IS NULL)

         RETURN(1)



    SELECT u.UserName

    FROM   dbo.aspnet_Users u, dbo.aspnet_UsersInRoles ur

    WHERE  u.UserId = ur.UserId AND @RoleId = ur.RoleId AND u.ApplicationId = @ApplicationId

    ORDER BY u.UserName

    RETURN(0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_FindUsersInRole]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_FindUsersInRole]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_FindUsersInRole]

    @ApplicationName  nvarchar(256),

    @RoleName         nvarchar(256),

    @UserNameToMatch  nvarchar(256)

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN(1)

     DECLARE @RoleId uniqueidentifier

     SELECT  @RoleId = NULL



     SELECT  @RoleId = RoleId

     FROM    dbo.aspnet_Roles

     WHERE   LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId



     IF (@RoleId IS NULL)

         RETURN(1)



    SELECT u.UserName

    FROM   dbo.aspnet_Users u, dbo.aspnet_UsersInRoles ur

    WHERE  u.UserId = ur.UserId AND @RoleId = ur.RoleId AND u.ApplicationId = @ApplicationId AND LoweredUserName LIKE LOWER(@UserNameToMatch)

    ORDER BY u.UserName

    RETURN(0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_GetRolesForUser]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetRolesForUser]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_GetRolesForUser]

    @ApplicationName  nvarchar(256),

    @UserName         nvarchar(256)

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN(1)

    DECLARE @UserId uniqueidentifier

    SELECT  @UserId = NULL



    SELECT  @UserId = UserId

    FROM    dbo.aspnet_Users

    WHERE   LoweredUserName = LOWER(@UserName) AND ApplicationId = @ApplicationId



    IF (@UserId IS NULL)

        RETURN(1)



    SELECT r.RoleName

    FROM   dbo.aspnet_Roles r, dbo.aspnet_UsersInRoles ur

    WHERE  r.RoleId = ur.RoleId AND r.ApplicationId = @ApplicationId AND ur.UserId = @UserId

    ORDER BY r.RoleName

    RETURN (0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_AddUsersToRoles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_AddUsersToRoles]

	@ApplicationName  nvarchar(256),

	@UserNames		  nvarchar(4000),

	@RoleNames		  nvarchar(4000),

	@CurrentTimeUtc   datetime

AS

BEGIN

	DECLARE @AppId uniqueidentifier

	SELECT  @AppId = NULL

	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

	IF (@AppId IS NULL)

		RETURN(2)

	DECLARE @TranStarted   bit

	SET @TranStarted = 0



	IF( @@TRANCOUNT = 0 )

	BEGIN

		BEGIN TRANSACTION

		SET @TranStarted = 1

	END



	DECLARE @tbNames	table(Name nvarchar(256) NOT NULL PRIMARY KEY)

	DECLARE @tbRoles	table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)

	DECLARE @tbUsers	table(UserId uniqueidentifier NOT NULL PRIMARY KEY)

	DECLARE @Num		int

	DECLARE @Pos		int

	DECLARE @NextPos	int

	DECLARE @Name		nvarchar(256)



	SET @Num = 0

	SET @Pos = 1

	WHILE(@Pos <= LEN(@RoleNames))

	BEGIN

		SELECT @NextPos = CHARINDEX(N'','', @RoleNames,  @Pos)

		IF (@NextPos = 0 OR @NextPos IS NULL)

			SELECT @NextPos = LEN(@RoleNames) + 1

		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@RoleNames, @Pos, @NextPos - @Pos)))

		SELECT @Pos = @NextPos+1



		INSERT INTO @tbNames VALUES (@Name)

		SET @Num = @Num + 1

	END



	INSERT INTO @tbRoles

	  SELECT RoleId

	  FROM   dbo.aspnet_Roles ar, @tbNames t

	  WHERE  LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @AppId



	IF (@@ROWCOUNT <> @Num)

	BEGIN

		SELECT TOP 1 Name

		FROM   @tbNames

		WHERE  LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar,  @tbRoles r WHERE r.RoleId = ar.RoleId)

		IF( @TranStarted = 1 )

			ROLLBACK TRANSACTION

		RETURN(2)

	END



	DELETE FROM @tbNames WHERE 1=1

	SET @Num = 0

	SET @Pos = 1



	WHILE(@Pos <= LEN(@UserNames))

	BEGIN

		SELECT @NextPos = CHARINDEX(N'','', @UserNames,  @Pos)

		IF (@NextPos = 0 OR @NextPos IS NULL)

			SELECT @NextPos = LEN(@UserNames) + 1

		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@UserNames, @Pos, @NextPos - @Pos)))

		SELECT @Pos = @NextPos+1



		INSERT INTO @tbNames VALUES (@Name)

		SET @Num = @Num + 1

	END



	INSERT INTO @tbUsers

	  SELECT UserId

	  FROM   dbo.aspnet_Users ar, @tbNames t

	  WHERE  LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @AppId



	IF (@@ROWCOUNT <> @Num)

	BEGIN

		DELETE FROM @tbNames

		WHERE LOWER(Name) IN (SELECT LoweredUserName FROM dbo.aspnet_Users au,  @tbUsers u WHERE au.UserId = u.UserId)



		INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)

		  SELECT @AppId, NEWID(), Name, LOWER(Name), 0, @CurrentTimeUtc

		  FROM   @tbNames



		INSERT INTO @tbUsers

		  SELECT  UserId

		  FROM	dbo.aspnet_Users au, @tbNames t

		  WHERE   LOWER(t.Name) = au.LoweredUserName AND au.ApplicationId = @AppId

	END



	IF (EXISTS (SELECT * FROM dbo.aspnet_UsersInRoles ur, @tbUsers tu, @tbRoles tr WHERE tu.UserId = ur.UserId AND tr.RoleId = ur.RoleId))

	BEGIN

		SELECT TOP 1 UserName, RoleName

		FROM		 dbo.aspnet_UsersInRoles ur, @tbUsers tu, @tbRoles tr, aspnet_Users u, aspnet_Roles r

		WHERE		u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND tu.UserId = ur.UserId AND tr.RoleId = ur.RoleId



		IF( @TranStarted = 1 )

			ROLLBACK TRANSACTION

		RETURN(3)

	END



	INSERT INTO dbo.aspnet_UsersInRoles (UserId, RoleId)

	SELECT UserId, RoleId

	FROM @tbUsers, @tbRoles



	IF( @TranStarted = 1 )

		COMMIT TRANSACTION

	RETURN(0)

END                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     ' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]

	@ApplicationName  nvarchar(256),

	@UserNames		  nvarchar(4000),

	@RoleNames		  nvarchar(4000)

AS

BEGIN

	DECLARE @AppId uniqueidentifier

	SELECT  @AppId = NULL

	SELECT  @AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

	IF (@AppId IS NULL)

		RETURN(2)





	DECLARE @TranStarted   bit

	SET @TranStarted = 0



	IF( @@TRANCOUNT = 0 )

	BEGIN

		BEGIN TRANSACTION

		SET @TranStarted = 1

	END



	DECLARE @tbNames  table(Name nvarchar(256) NOT NULL PRIMARY KEY)

	DECLARE @tbRoles  table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)

	DECLARE @tbUsers  table(UserId uniqueidentifier NOT NULL PRIMARY KEY)

	DECLARE @Num	  int

	DECLARE @Pos	  int

	DECLARE @NextPos  int

	DECLARE @Name	  nvarchar(256)

	DECLARE @CountAll int

	DECLARE @CountU	  int

	DECLARE @CountR	  int





	SET @Num = 0

	SET @Pos = 1

	WHILE(@Pos <= LEN(@RoleNames))

	BEGIN

		SELECT @NextPos = CHARINDEX(N'','', @RoleNames,  @Pos)

		IF (@NextPos = 0 OR @NextPos IS NULL)

			SELECT @NextPos = LEN(@RoleNames) + 1

		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@RoleNames, @Pos, @NextPos - @Pos)))

		SELECT @Pos = @NextPos+1



		INSERT INTO @tbNames VALUES (@Name)

		SET @Num = @Num + 1

	END



	INSERT INTO @tbRoles

	  SELECT RoleId

	  FROM   dbo.aspnet_Roles ar, @tbNames t

	  WHERE  LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @AppId

	SELECT @CountR = @@ROWCOUNT



	IF (@CountR <> @Num)

	BEGIN

		SELECT TOP 1 N'''', Name

		FROM   @tbNames

		WHERE  LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar,  @tbRoles r WHERE r.RoleId = ar.RoleId)

		IF( @TranStarted = 1 )

			ROLLBACK TRANSACTION

		RETURN(2)

	END





	DELETE FROM @tbNames WHERE 1=1

	SET @Num = 0

	SET @Pos = 1





	WHILE(@Pos <= LEN(@UserNames))

	BEGIN

		SELECT @NextPos = CHARINDEX(N'','', @UserNames,  @Pos)

		IF (@NextPos = 0 OR @NextPos IS NULL)

			SELECT @NextPos = LEN(@UserNames) + 1

		SELECT @Name = RTRIM(LTRIM(SUBSTRING(@UserNames, @Pos, @NextPos - @Pos)))

		SELECT @Pos = @NextPos+1



		INSERT INTO @tbNames VALUES (@Name)

		SET @Num = @Num + 1

	END



	INSERT INTO @tbUsers

	  SELECT UserId

	  FROM   dbo.aspnet_Users ar, @tbNames t

	  WHERE  LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @AppId



	SELECT @CountU = @@ROWCOUNT

	IF (@CountU <> @Num)

	BEGIN

		SELECT TOP 1 Name, N''''

		FROM   @tbNames

		WHERE  LOWER(Name) NOT IN (SELECT au.LoweredUserName FROM dbo.aspnet_Users au,  @tbUsers u WHERE u.UserId = au.UserId)



		IF( @TranStarted = 1 )

			ROLLBACK TRANSACTION

		RETURN(1)

	END



	SELECT  @CountAll = COUNT(*)

	FROM	dbo.aspnet_UsersInRoles ur, @tbUsers u, @tbRoles r

	WHERE   ur.UserId = u.UserId AND ur.RoleId = r.RoleId



	IF (@CountAll <> @CountU * @CountR)

	BEGIN

		SELECT TOP 1 UserName, RoleName

		FROM		 @tbUsers tu, @tbRoles tr, dbo.aspnet_Users u, dbo.aspnet_Roles r

		WHERE		 u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND

					 tu.UserId NOT IN (SELECT ur.UserId FROM dbo.aspnet_UsersInRoles ur WHERE ur.RoleId = tr.RoleId) AND

					 tr.RoleId NOT IN (SELECT ur.RoleId FROM dbo.aspnet_UsersInRoles ur WHERE ur.UserId = tu.UserId)

		IF( @TranStarted = 1 )

			ROLLBACK TRANSACTION

		RETURN(3)

	END



	DELETE FROM dbo.aspnet_UsersInRoles

	WHERE UserId IN (SELECT UserId FROM @tbUsers)

	  AND RoleId IN (SELECT RoleId FROM @tbRoles)

	IF( @TranStarted = 1 )

		COMMIT TRANSACTION

	RETURN(0)

END

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        ' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_UnRegisterSchemaVersion]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UnRegisterSchemaVersion]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_UnRegisterSchemaVersion]

    @Feature                   nvarchar(128),

    @CompatibleSchemaVersion   nvarchar(128)

AS

BEGIN

    DELETE FROM dbo.aspnet_SchemaVersions

        WHERE   Feature = LOWER(@Feature) AND @CompatibleSchemaVersion = CompatibleSchemaVersion

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_RegisterSchemaVersion]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_RegisterSchemaVersion]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_RegisterSchemaVersion]

    @Feature                   nvarchar(128),

    @CompatibleSchemaVersion   nvarchar(128),

    @IsCurrentVersion          bit,

    @RemoveIncompatibleSchema  bit

AS

BEGIN

    IF( @RemoveIncompatibleSchema = 1 )

    BEGIN

        DELETE FROM dbo.aspnet_SchemaVersions WHERE Feature = LOWER( @Feature )

    END

    ELSE

    BEGIN

        IF( @IsCurrentVersion = 1 )

        BEGIN

            UPDATE dbo.aspnet_SchemaVersions

            SET IsCurrentVersion = 0

            WHERE Feature = LOWER( @Feature )

        END

    END



    INSERT  dbo.aspnet_SchemaVersions( Feature, CompatibleSchemaVersion, IsCurrentVersion )

    VALUES( LOWER( @Feature ), @CompatibleSchemaVersion, @IsCurrentVersion )

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_CheckSchemaVersion]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_CheckSchemaVersion]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion]

    @Feature                   nvarchar(128),

    @CompatibleSchemaVersion   nvarchar(128)

AS

BEGIN

    IF (EXISTS( SELECT  *

                FROM    dbo.aspnet_SchemaVersions

                WHERE   Feature = LOWER( @Feature ) AND

                        CompatibleSchemaVersion = @CompatibleSchemaVersion ))

        RETURN 0



    RETURN 1

END' 

END

GO

/****** Object:  View [dbo].[vw_aspnet_Profiles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Profiles]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_Profiles]

  AS SELECT [dbo].[aspnet_Profile].[UserId], [dbo].[aspnet_Profile].[LastUpdatedDate],

      [DataSize]=  DATALENGTH([dbo].[aspnet_Profile].[PropertyNames])

                 + DATALENGTH([dbo].[aspnet_Profile].[PropertyValuesString])

                 + DATALENGTH([dbo].[aspnet_Profile].[PropertyValuesBinary])

  FROM [dbo].[aspnet_Profile]

  '

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_DeleteRole]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_DeleteRole]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Roles_DeleteRole]

    @ApplicationName            nvarchar(256),

    @RoleName                   nvarchar(256),

    @DeleteOnlyIfRoleIsEmpty    bit

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN(1)



    DECLARE @ErrorCode     int

    SET @ErrorCode = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

        BEGIN TRANSACTION

        SET @TranStarted = 1

    END

    ELSE

        SET @TranStarted = 0



    DECLARE @RoleId   uniqueidentifier

    SELECT  @RoleId = NULL

    SELECT  @RoleId = RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId



    IF (@RoleId IS NULL)

    BEGIN

        SELECT @ErrorCode = 1

        GOTO Cleanup

    END

    IF (@DeleteOnlyIfRoleIsEmpty <> 0)

    BEGIN

        IF (EXISTS (SELECT RoleId FROM dbo.aspnet_UsersInRoles  WHERE @RoleId = RoleId))

        BEGIN

            SELECT @ErrorCode = 2

            GOTO Cleanup

        END

    END





    DELETE FROM dbo.aspnet_UsersInRoles  WHERE @RoleId = RoleId



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    DELETE FROM dbo.aspnet_Roles WHERE @RoleId = RoleId  AND ApplicationId = @ApplicationId



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

        COMMIT TRANSACTION

    END



    RETURN(0)



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

        ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode

END' 

END

GO

/****** Object:  View [dbo].[vw_aspnet_Roles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Roles]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_Roles]

  AS SELECT [dbo].[aspnet_Roles].[ApplicationId], [dbo].[aspnet_Roles].[RoleId], [dbo].[aspnet_Roles].[RoleName], [dbo].[aspnet_Roles].[LoweredRoleName], [dbo].[aspnet_Roles].[Description]

  FROM [dbo].[aspnet_Roles]

  '

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_RoleExists]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_RoleExists]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Roles_RoleExists]

    @ApplicationName  nvarchar(256),

    @RoleName         nvarchar(256)

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN(0)

    IF (EXISTS (SELECT RoleName FROM dbo.aspnet_Roles WHERE LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId ))

        RETURN(1)

    ELSE

        RETURN(0)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_GetAllRoles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_GetAllRoles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Roles_GetAllRoles] (

    @ApplicationName           nvarchar(256))

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN

    SELECT RoleName

    FROM   dbo.aspnet_Roles WHERE ApplicationId = @ApplicationId

    ORDER BY RoleName

END' 

END

GO

/****** Object:  View [dbo].[vw_aspnet_UsersInRoles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_UsersInRoles]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_UsersInRoles]

  AS SELECT [dbo].[aspnet_UsersInRoles].[UserId], [dbo].[aspnet_UsersInRoles].[RoleId]

  FROM [dbo].[aspnet_UsersInRoles]

  '

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Paths_CreatePath]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths_CreatePath]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Paths_CreatePath]

    @ApplicationId UNIQUEIDENTIFIER,

    @Path           NVARCHAR(256),

    @PathId         UNIQUEIDENTIFIER OUTPUT

AS

BEGIN

    BEGIN TRANSACTION

    IF (NOT EXISTS(SELECT * FROM dbo.aspnet_Paths WHERE LoweredPath = LOWER(@Path) AND ApplicationId = @ApplicationId))

    BEGIN

        INSERT dbo.aspnet_Paths (ApplicationId, Path, LoweredPath) VALUES (@ApplicationId, @Path, LOWER(@Path))

    END

    COMMIT TRANSACTION

    SELECT @PathId = PathId FROM dbo.aspnet_Paths WHERE LOWER(@Path) = LoweredPath AND ApplicationId = @ApplicationId

END' 

END

GO

/****** Object:  View [dbo].[vw_aspnet_WebPartState_Paths]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Paths]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_WebPartState_Paths]

  AS SELECT [dbo].[aspnet_Paths].[ApplicationId], [dbo].[aspnet_Paths].[PathId], [dbo].[aspnet_Paths].[Path], [dbo].[aspnet_Paths].[LoweredPath]

  FROM [dbo].[aspnet_Paths]

  '

GO

/****** Object:  View [dbo].[vw_aspnet_WebPartState_Shared]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Shared]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_WebPartState_Shared]

  AS SELECT [dbo].[aspnet_PersonalizationAllUsers].[PathId], [DataSize]=DATALENGTH([dbo].[aspnet_PersonalizationAllUsers].[PageSettings]), [dbo].[aspnet_PersonalizationAllUsers].[LastUpdatedDate]

  FROM [dbo].[aspnet_PersonalizationAllUsers]

  '

GO

/****** Object:  View [dbo].[vw_aspnet_WebPartState_User]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_User]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_WebPartState_User]

  AS SELECT [dbo].[aspnet_PersonalizationPerUser].[PathId], [dbo].[aspnet_PersonalizationPerUser].[UserId], [DataSize]=DATALENGTH([dbo].[aspnet_PersonalizationPerUser].[PageSettings]), [dbo].[aspnet_PersonalizationPerUser].[LastUpdatedDate]

  FROM [dbo].[aspnet_PersonalizationPerUser]

  '

GO

/****** Object:  StoredProcedure [dbo].[aspnet_WebEvent_LogEvent]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_LogEvent]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_WebEvent_LogEvent]

        @EventId         char(32),

        @EventTimeUtc    datetime,

        @EventTime       datetime,

        @EventType       nvarchar(256),

        @EventSequence   decimal(19,0),

        @EventOccurrence decimal(19,0),

        @EventCode       int,

        @EventDetailCode int,

        @Message         nvarchar(1024),

        @ApplicationPath nvarchar(256),

        @ApplicationVirtualPath nvarchar(256),

        @MachineName    nvarchar(256),

        @RequestUrl      nvarchar(1024),

        @ExceptionType   nvarchar(256),

        @Details         ntext

AS

BEGIN

    INSERT

        dbo.aspnet_WebEvent_Events

        (

            EventId,

            EventTimeUtc,

            EventTime,

            EventType,

            EventSequence,

            EventOccurrence,

            EventCode,

            EventDetailCode,

            Message,

            ApplicationPath,

            ApplicationVirtualPath,

            MachineName,

            RequestUrl,

            ExceptionType,

            Details

        )

    VALUES

    (

        @EventId,

        @EventTimeUtc,

        @EventTime,

        @EventType,

        @EventSequence,

        @EventOccurrence,

        @EventCode,

        @EventDetailCode,

        @Message,

        @ApplicationPath,

        @ApplicationVirtualPath,

        @MachineName,

        @RequestUrl,

        @ExceptionType,

        @Details

    )

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Personalization_GetApplicationId]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Personalization_GetApplicationId]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Personalization_GetApplicationId] (

    @ApplicationName NVARCHAR(256),

    @ApplicationId UNIQUEIDENTIFIER OUT)

AS

BEGIN

    SELECT @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_GetProfiles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProfiles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Profile_GetProfiles]

    @ApplicationName        nvarchar(256),

    @ProfileAuthOptions     int,

    @PageIndex              int,

    @PageSize               int,

    @UserNameToMatch        nvarchar(256) = NULL,

    @InactiveSinceDate      datetime      = NULL

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN



    -- Set the page bounds

    DECLARE @PageLowerBound int

    DECLARE @PageUpperBound int

    DECLARE @TotalRecords   int

    SET @PageLowerBound = @PageSize * @PageIndex

    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound



    -- Create a temp table TO store the select results

    CREATE TABLE #PageIndexForUsers

    (

        IndexId int IDENTITY (0, 1) NOT NULL,

        UserId uniqueidentifier

    )



    -- Insert into our temp table

    INSERT INTO #PageIndexForUsers (UserId)

        SELECT  u.UserId

        FROM    dbo.aspnet_Users u, dbo.aspnet_Profile p

        WHERE   ApplicationId = @ApplicationId

            AND u.UserId = p.UserId

            AND (@InactiveSinceDate IS NULL OR LastActivityDate <= @InactiveSinceDate)

            AND (     (@ProfileAuthOptions = 2)

                   OR (@ProfileAuthOptions = 0 AND IsAnonymous = 1)

                   OR (@ProfileAuthOptions = 1 AND IsAnonymous = 0)

                 )

            AND (@UserNameToMatch IS NULL OR LoweredUserName LIKE LOWER(@UserNameToMatch))

        ORDER BY UserName



    SELECT  u.UserName, u.IsAnonymous, u.LastActivityDate, p.LastUpdatedDate,

            DATALENGTH(p.PropertyNames) + DATALENGTH(p.PropertyValuesString) + DATALENGTH(p.PropertyValuesBinary)

    FROM    dbo.aspnet_Users u, dbo.aspnet_Profile p, #PageIndexForUsers i

    WHERE   u.UserId = p.UserId AND p.UserId = i.UserId AND i.IndexId >= @PageLowerBound AND i.IndexId <= @PageUpperBound



    SELECT COUNT(*)

    FROM   #PageIndexForUsers



    DROP TABLE #PageIndexForUsers

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_GetAllUsers]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetAllUsers]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_GetAllUsers]

    @ApplicationName       nvarchar(256),

    @PageIndex             int,

    @PageSize              int

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN 0





    -- Set the page bounds

    DECLARE @PageLowerBound int

    DECLARE @PageUpperBound int

    DECLARE @TotalRecords   int

    SET @PageLowerBound = @PageSize * @PageIndex

    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound



    -- Create a temp table TO store the select results

    CREATE TABLE #PageIndexForUsers

    (

        IndexId int IDENTITY (0, 1) NOT NULL,

        UserId uniqueidentifier

    )



    -- Insert into our temp table

    INSERT INTO #PageIndexForUsers (UserId)

    SELECT u.UserId

    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u

    WHERE  u.ApplicationId = @ApplicationId AND u.UserId = m.UserId

    ORDER BY u.UserName



    SELECT @TotalRecords = @@ROWCOUNT



    SELECT u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,

            m.CreateDate,

            m.LastLoginDate,

            u.LastActivityDate,

            m.LastPasswordChangedDate,

            u.UserId, m.IsLockedOut,

            m.LastLockoutDate

    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p

    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND

           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound

    ORDER BY u.UserName

    RETURN @TotalRecords

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_FindUsersByName]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByName]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_FindUsersByName]

    @ApplicationName       nvarchar(256),

    @UserNameToMatch       nvarchar(256),

    @PageIndex             int,

    @PageSize              int

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN 0



    -- Set the page bounds

    DECLARE @PageLowerBound int

    DECLARE @PageUpperBound int

    DECLARE @TotalRecords   int

    SET @PageLowerBound = @PageSize * @PageIndex

    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound



    -- Create a temp table TO store the select results

    CREATE TABLE #PageIndexForUsers

    (

        IndexId int IDENTITY (0, 1) NOT NULL,

        UserId uniqueidentifier

    )



    -- Insert into our temp table

    INSERT INTO #PageIndexForUsers (UserId)

        SELECT u.UserId

        FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m

        WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND u.LoweredUserName LIKE LOWER(@UserNameToMatch)

        ORDER BY u.UserName





    SELECT  u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,

            m.CreateDate,

            m.LastLoginDate,

            u.LastActivityDate,

            m.LastPasswordChangedDate,

            u.UserId, m.IsLockedOut,

            m.LastLockoutDate

    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p

    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND

           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound

    ORDER BY u.UserName



    SELECT  @TotalRecords = COUNT(*)

    FROM    #PageIndexForUsers

    RETURN @TotalRecords

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_FindUsersByEmail]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByEmail]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_FindUsersByEmail]

    @ApplicationName       nvarchar(256),

    @EmailToMatch          nvarchar(256),

    @PageIndex             int,

    @PageSize              int

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL

    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName

    IF (@ApplicationId IS NULL)

        RETURN 0



    -- Set the page bounds

    DECLARE @PageLowerBound int

    DECLARE @PageUpperBound int

    DECLARE @TotalRecords   int

    SET @PageLowerBound = @PageSize * @PageIndex

    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound



    -- Create a temp table TO store the select results

    CREATE TABLE #PageIndexForUsers

    (

        IndexId int IDENTITY (0, 1) NOT NULL,

        UserId uniqueidentifier

    )



    -- Insert into our temp table

    IF( @EmailToMatch IS NULL )

        INSERT INTO #PageIndexForUsers (UserId)

            SELECT u.UserId

            FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m

            WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND m.Email IS NULL

            ORDER BY m.LoweredEmail

    ELSE

        INSERT INTO #PageIndexForUsers (UserId)

            SELECT u.UserId

            FROM   dbo.aspnet_Users u, dbo.aspnet_Membership m

            WHERE  u.ApplicationId = @ApplicationId AND m.UserId = u.UserId AND m.LoweredEmail LIKE LOWER(@EmailToMatch)

            ORDER BY m.LoweredEmail



    SELECT  u.UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved,

            m.CreateDate,

            m.LastLoginDate,

            u.LastActivityDate,

            m.LastPasswordChangedDate,

            u.UserId, m.IsLockedOut,

            m.LastLockoutDate

    FROM   dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p

    WHERE  u.UserId = p.UserId AND u.UserId = m.UserId AND

           p.IndexId >= @PageLowerBound AND p.IndexId <= @PageUpperBound

    ORDER BY m.LoweredEmail



    SELECT  @TotalRecords = COUNT(*)

    FROM    #PageIndexForUsers

    RETURN @TotalRecords

END' 

END

GO

/****** Object:  View [dbo].[vw_aspnet_Applications]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Applications]'))

EXEC dbo.sp_executesql @statement = N'

  CREATE VIEW [dbo].[vw_aspnet_Applications]

  AS SELECT [dbo].[aspnet_Applications].[ApplicationName], [dbo].[aspnet_Applications].[LoweredApplicationName], [dbo].[aspnet_Applications].[ApplicationId], [dbo].[aspnet_Applications].[Description]

  FROM [dbo].[aspnet_Applications]

  '

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Applications_CreateApplication]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications_CreateApplication]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Applications_CreateApplication]

    @ApplicationName      nvarchar(256),

    @ApplicationId        uniqueidentifier OUTPUT

AS

BEGIN

    SELECT  @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName



    IF(@ApplicationId IS NULL)

    BEGIN

        DECLARE @TranStarted   bit

        SET @TranStarted = 0



        IF( @@TRANCOUNT = 0 )

        BEGIN

	        BEGIN TRANSACTION

	        SET @TranStarted = 1

        END

        ELSE

    	    SET @TranStarted = 0



        SELECT  @ApplicationId = ApplicationId

        FROM dbo.aspnet_Applications WITH (UPDLOCK, HOLDLOCK)

        WHERE LOWER(@ApplicationName) = LoweredApplicationName



        IF(@ApplicationId IS NULL)

        BEGIN

            SELECT  @ApplicationId = NEWID()

            INSERT  dbo.aspnet_Applications (ApplicationId, ApplicationName, LoweredApplicationName)

            VALUES  (@ApplicationId, @ApplicationName, LOWER(@ApplicationName))

        END





        IF( @TranStarted = 1 )

        BEGIN

            IF(@@ERROR = 0)

            BEGIN

	        SET @TranStarted = 0

	        COMMIT TRANSACTION

            END

            ELSE

            BEGIN

                SET @TranStarted = 0

                ROLLBACK TRANSACTION

            END

        END

    END

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Membership_CreateUser]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_CreateUser]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Membership_CreateUser]

    @ApplicationName                        nvarchar(256),

    @UserName                               nvarchar(256),

    @Password                               nvarchar(128),

    @PasswordSalt                           nvarchar(128),

    @Email                                  nvarchar(256),

    @PasswordQuestion                       nvarchar(256),

    @PasswordAnswer                         nvarchar(128),

    @IsApproved                             bit,

    @CurrentTimeUtc                         datetime,

    @CreateDate                             datetime = NULL,

    @UniqueEmail                            int      = 0,

    @PasswordFormat                         int      = 0,

    @UserId                                 uniqueidentifier OUTPUT

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL



    DECLARE @NewUserId uniqueidentifier

    SELECT @NewUserId = NULL



    DECLARE @IsLockedOut bit

    SET @IsLockedOut = 0



    DECLARE @LastLockoutDate  datetime

    SET @LastLockoutDate = CONVERT( datetime, ''17540101'', 112 )



    DECLARE @FailedPasswordAttemptCount int

    SET @FailedPasswordAttemptCount = 0



    DECLARE @FailedPasswordAttemptWindowStart  datetime

    SET @FailedPasswordAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 )



    DECLARE @FailedPasswordAnswerAttemptCount int

    SET @FailedPasswordAnswerAttemptCount = 0



    DECLARE @FailedPasswordAnswerAttemptWindowStart  datetime

    SET @FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, ''17540101'', 112 )



    DECLARE @NewUserCreated bit

    DECLARE @ReturnValue   int

    SET @ReturnValue = 0



    DECLARE @ErrorCode     int

    SET @ErrorCode = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

	    BEGIN TRANSACTION

	    SET @TranStarted = 1

    END

    ELSE

    	SET @TranStarted = 0



    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    SET @CreateDate = @CurrentTimeUtc



    SELECT  @NewUserId = UserId FROM dbo.aspnet_Users WHERE LOWER(@UserName) = LoweredUserName AND @ApplicationId = ApplicationId

    IF ( @NewUserId IS NULL )

    BEGIN

        SET @NewUserId = @UserId

        EXEC @ReturnValue = dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, 0, @CreateDate, @NewUserId OUTPUT

        SET @NewUserCreated = 1

    END

    ELSE

    BEGIN

        SET @NewUserCreated = 0

        IF( @NewUserId <> @UserId AND @UserId IS NOT NULL )

        BEGIN

            SET @ErrorCode = 6

            GOTO Cleanup

        END

    END



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF( @ReturnValue = -1 )

    BEGIN

        SET @ErrorCode = 10

        GOTO Cleanup

    END



    IF ( EXISTS ( SELECT UserId

                  FROM   dbo.aspnet_Membership

                  WHERE  @NewUserId = UserId ) )

    BEGIN

        SET @ErrorCode = 6

        GOTO Cleanup

    END



    SET @UserId = @NewUserId



    IF (@UniqueEmail = 1)

    BEGIN

        IF (EXISTS (SELECT *

                    FROM  dbo.aspnet_Membership m WITH ( UPDLOCK, HOLDLOCK )

                    WHERE ApplicationId = @ApplicationId AND LoweredEmail = LOWER(@Email)))

        BEGIN

            SET @ErrorCode = 7

            GOTO Cleanup

        END

    END



    IF (@NewUserCreated = 0)

    BEGIN

        UPDATE dbo.aspnet_Users

        SET    LastActivityDate = @CreateDate

        WHERE  @UserId = UserId

        IF( @@ERROR <> 0 )

        BEGIN

            SET @ErrorCode = -1

            GOTO Cleanup

        END

    END



    INSERT INTO dbo.aspnet_Membership

                ( ApplicationId,

                  UserId,

                  Password,

                  PasswordSalt,

                  Email,

                  LoweredEmail,

                  PasswordQuestion,

                  PasswordAnswer,

                  PasswordFormat,

                  IsApproved,

                  IsLockedOut,

                  CreateDate,

                  LastLoginDate,

                  LastPasswordChangedDate,

                  LastLockoutDate,

                  FailedPasswordAttemptCount,

                  FailedPasswordAttemptWindowStart,

                  FailedPasswordAnswerAttemptCount,

                  FailedPasswordAnswerAttemptWindowStart )

         VALUES ( @ApplicationId,

                  @UserId,

                  @Password,

                  @PasswordSalt,

                  @Email,

                  LOWER(@Email),

                  @PasswordQuestion,

                  @PasswordAnswer,

                  @PasswordFormat,

                  @IsApproved,

                  @IsLockedOut,

                  @CreateDate,

                  @CreateDate,

                  @CreateDate,

                  @LastLockoutDate,

                  @FailedPasswordAttemptCount,

                  @FailedPasswordAttemptWindowStart,

                  @FailedPasswordAnswerAttemptCount,

                  @FailedPasswordAnswerAttemptWindowStart )



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF( @TranStarted = 1 )

    BEGIN

	    SET @TranStarted = 0

	    COMMIT TRANSACTION

    END



    RETURN 0



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

    	ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode



END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_SetProperties]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_SetProperties]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Profile_SetProperties]

    @ApplicationName        nvarchar(256),

    @PropertyNames          ntext,

    @PropertyValuesString   ntext,

    @PropertyValuesBinary   image,

    @UserName               nvarchar(256),

    @IsUserAnonymous        bit,

    @CurrentTimeUtc         datetime

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL



    DECLARE @ErrorCode     int

    SET @ErrorCode = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

       BEGIN TRANSACTION

       SET @TranStarted = 1

    END

    ELSE

    	SET @TranStarted = 0



    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    DECLARE @UserId uniqueidentifier

    DECLARE @LastActivityDate datetime

    SELECT  @UserId = NULL

    SELECT  @LastActivityDate = @CurrentTimeUtc



    SELECT @UserId = UserId

    FROM   dbo.aspnet_Users

    WHERE  ApplicationId = @ApplicationId AND LoweredUserName = LOWER(@UserName)

    IF (@UserId IS NULL)

        EXEC dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, @IsUserAnonymous, @LastActivityDate, @UserId OUTPUT



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    UPDATE dbo.aspnet_Users

    SET    LastActivityDate=@CurrentTimeUtc

    WHERE  UserId = @UserId



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF (EXISTS( SELECT *

               FROM   dbo.aspnet_Profile

               WHERE  UserId = @UserId))

        UPDATE dbo.aspnet_Profile

        SET    PropertyNames=@PropertyNames, PropertyValuesString = @PropertyValuesString,

               PropertyValuesBinary = @PropertyValuesBinary, LastUpdatedDate=@CurrentTimeUtc

        WHERE  UserId = @UserId

    ELSE

        INSERT INTO dbo.aspnet_Profile(UserId, PropertyNames, PropertyValuesString, PropertyValuesBinary, LastUpdatedDate)

             VALUES (@UserId, @PropertyNames, @PropertyValuesString, @PropertyValuesBinary, @CurrentTimeUtc)



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF( @TranStarted = 1 )

    BEGIN

    	SET @TranStarted = 0

    	COMMIT TRANSACTION

    END



    RETURN 0



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

    	ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode



END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_GetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_GetPageSettings]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] (

    @ApplicationName  NVARCHAR(256),

    @UserName         NVARCHAR(256),

    @Path             NVARCHAR(256),

    @CurrentTimeUtc   DATETIME)

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    DECLARE @PathId UNIQUEIDENTIFIER

    DECLARE @UserId UNIQUEIDENTIFIER



    SELECT @ApplicationId = NULL

    SELECT @PathId = NULL

    SELECT @UserId = NULL



    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

    BEGIN

        RETURN

    END



    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)

    IF (@PathId IS NULL)

    BEGIN

        RETURN

    END



    SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)

    IF (@UserId IS NULL)

    BEGIN

        RETURN

    END



    UPDATE   dbo.aspnet_Users WITH (ROWLOCK)

    SET      LastActivityDate = @CurrentTimeUtc

    WHERE    UserId = @UserId

    IF (@@ROWCOUNT = 0) -- Username not found

        RETURN



    SELECT p.PageSettings FROM dbo.aspnet_PersonalizationPerUser p WHERE p.PathId = @PathId AND p.UserId = @UserId

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] (

    @ApplicationName  NVARCHAR(256),

    @UserName         NVARCHAR(256),

    @Path             NVARCHAR(256),

    @CurrentTimeUtc   DATETIME)

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    DECLARE @PathId UNIQUEIDENTIFIER

    DECLARE @UserId UNIQUEIDENTIFIER



    SELECT @ApplicationId = NULL

    SELECT @PathId = NULL

    SELECT @UserId = NULL



    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

    BEGIN

        RETURN

    END



    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)

    IF (@PathId IS NULL)

    BEGIN

        RETURN

    END



    SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)

    IF (@UserId IS NULL)

    BEGIN

        RETURN

    END



    UPDATE   dbo.aspnet_Users WITH (ROWLOCK)

    SET      LastActivityDate = @CurrentTimeUtc

    WHERE    UserId = @UserId

    IF (@@ROWCOUNT = 0) -- Username not found

        RETURN



    DELETE FROM dbo.aspnet_PersonalizationPerUser WHERE PathId = @PathId AND UserId = @UserId

    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationPerUser_SetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_SetPageSettings]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] (

    @ApplicationName  NVARCHAR(256),

    @UserName         NVARCHAR(256),

    @Path             NVARCHAR(256),

    @PageSettings     IMAGE,

    @CurrentTimeUtc   DATETIME)

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    DECLARE @PathId UNIQUEIDENTIFIER

    DECLARE @UserId UNIQUEIDENTIFIER



    SELECT @ApplicationId = NULL

    SELECT @PathId = NULL

    SELECT @UserId = NULL



    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT



    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)

    IF (@PathId IS NULL)

    BEGIN

        EXEC dbo.aspnet_Paths_CreatePath @ApplicationId, @Path, @PathId OUTPUT

    END



    SELECT @UserId = u.UserId FROM dbo.aspnet_Users u WHERE u.ApplicationId = @ApplicationId AND u.LoweredUserName = LOWER(@UserName)

    IF (@UserId IS NULL)

    BEGIN

        EXEC dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, 0, @CurrentTimeUtc, @UserId OUTPUT

    END



    UPDATE   dbo.aspnet_Users WITH (ROWLOCK)

    SET      LastActivityDate = @CurrentTimeUtc

    WHERE    UserId = @UserId

    IF (@@ROWCOUNT = 0) -- Username not found

        RETURN



    IF (EXISTS(SELECT PathId FROM dbo.aspnet_PersonalizationPerUser WHERE UserId = @UserId AND PathId = @PathId))

        UPDATE dbo.aspnet_PersonalizationPerUser SET PageSettings = @PageSettings, LastUpdatedDate = @CurrentTimeUtc WHERE UserId = @UserId AND PathId = @PathId

    ELSE

        INSERT INTO dbo.aspnet_PersonalizationPerUser(UserId, PathId, PageSettings, LastUpdatedDate) VALUES (@UserId, @PathId, @PageSettings, @CurrentTimeUtc)

    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetUserState]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetUserState]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetUserState] (

    @Count                  int                 OUT,

    @ApplicationName        NVARCHAR(256),

    @InactiveSinceDate      DATETIME            = NULL,

    @UserName               NVARCHAR(256)       = NULL,

    @Path                   NVARCHAR(256)       = NULL)

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

        SELECT @Count = 0

    ELSE

    BEGIN

        DELETE FROM dbo.aspnet_PersonalizationPerUser

        WHERE Id IN (SELECT PerUser.Id

                     FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths

                     WHERE Paths.ApplicationId = @ApplicationId

                           AND PerUser.UserId = Users.UserId

                           AND PerUser.PathId = Paths.PathId

                           AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)

                           AND (@UserName IS NULL OR Users.LoweredUserName = LOWER(@UserName))

                           AND (@Path IS NULL OR Paths.LoweredPath = LOWER(@Path)))



        SELECT @Count = @@ROWCOUNT

    END

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_GetCountOfState]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_GetCountOfState]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] (

    @Count int OUT,

    @AllUsersScope bit,

    @ApplicationName NVARCHAR(256),

    @Path NVARCHAR(256) = NULL,

    @UserName NVARCHAR(256) = NULL,

    @InactiveSinceDate DATETIME = NULL)

AS

BEGIN



    DECLARE @ApplicationId UNIQUEIDENTIFIER

    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

        SELECT @Count = 0

    ELSE

        IF (@AllUsersScope = 1)

            SELECT @Count = COUNT(*)

            FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths

            WHERE Paths.ApplicationId = @ApplicationId

                  AND AllUsers.PathId = Paths.PathId

                  AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))

        ELSE

            SELECT @Count = COUNT(*)

            FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths

            WHERE Paths.ApplicationId = @ApplicationId

                  AND PerUser.UserId = Users.UserId

                  AND PerUser.PathId = Paths.PathId

                  AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))

                  AND (@UserName IS NULL OR Users.LoweredUserName LIKE LOWER(@UserName))

                  AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] (

    @ApplicationName  NVARCHAR(256),

    @Path             NVARCHAR(256),

    @PageSettings     IMAGE,

    @CurrentTimeUtc   DATETIME)

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    DECLARE @PathId UNIQUEIDENTIFIER



    SELECT @ApplicationId = NULL

    SELECT @PathId = NULL



    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT



    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)

    IF (@PathId IS NULL)

    BEGIN

        EXEC dbo.aspnet_Paths_CreatePath @ApplicationId, @Path, @PathId OUTPUT

    END



    IF (EXISTS(SELECT PathId FROM dbo.aspnet_PersonalizationAllUsers WHERE PathId = @PathId))

        UPDATE dbo.aspnet_PersonalizationAllUsers SET PageSettings = @PageSettings, LastUpdatedDate = @CurrentTimeUtc WHERE PathId = @PathId

    ELSE

        INSERT INTO dbo.aspnet_PersonalizationAllUsers(PathId, PageSettings, LastUpdatedDate) VALUES (@PathId, @PageSettings, @CurrentTimeUtc)

    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Roles_CreateRole]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_CreateRole]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_Roles_CreateRole]

    @ApplicationName  nvarchar(256),

    @RoleName         nvarchar(256)

AS

BEGIN

    DECLARE @ApplicationId uniqueidentifier

    SELECT  @ApplicationId = NULL



    DECLARE @ErrorCode     int

    SET @ErrorCode = 0



    DECLARE @TranStarted   bit

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

        BEGIN TRANSACTION

        SET @TranStarted = 1

    END

    ELSE

        SET @TranStarted = 0



    EXEC dbo.aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId OUTPUT



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF (EXISTS(SELECT RoleId FROM dbo.aspnet_Roles WHERE LoweredRoleName = LOWER(@RoleName) AND ApplicationId = @ApplicationId))

    BEGIN

        SET @ErrorCode = 1

        GOTO Cleanup

    END



    INSERT INTO dbo.aspnet_Roles

                (ApplicationId, RoleName, LoweredRoleName)

         VALUES (@ApplicationId, @RoleName, LOWER(@RoleName))



    IF( @@ERROR <> 0 )

    BEGIN

        SET @ErrorCode = -1

        GOTO Cleanup

    END



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

        COMMIT TRANSACTION

    END



    RETURN(0)



Cleanup:



    IF( @TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

        ROLLBACK TRANSACTION

    END



    RETURN @ErrorCode



END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_Profile_DeleteProfiles]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteProfiles]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[aspnet_Profile_DeleteProfiles]

    @ApplicationName        nvarchar(256),

    @UserNames              nvarchar(4000)

AS

BEGIN

    DECLARE @UserName     nvarchar(256)

    DECLARE @CurrentPos   int

    DECLARE @NextPos      int

    DECLARE @NumDeleted   int

    DECLARE @DeletedUser  int

    DECLARE @TranStarted  bit

    DECLARE @ErrorCode    int



    SET @ErrorCode = 0

    SET @CurrentPos = 1

    SET @NumDeleted = 0

    SET @TranStarted = 0



    IF( @@TRANCOUNT = 0 )

    BEGIN

        BEGIN TRANSACTION

        SET @TranStarted = 1

    END

    ELSE

    	SET @TranStarted = 0



    WHILE (@CurrentPos <= LEN(@UserNames))

    BEGIN

        SELECT @NextPos = CHARINDEX(N'','', @UserNames,  @CurrentPos)

        IF (@NextPos = 0 OR @NextPos IS NULL)

            SELECT @NextPos = LEN(@UserNames) + 1



        SELECT @UserName = SUBSTRING(@UserNames, @CurrentPos, @NextPos - @CurrentPos)

        SELECT @CurrentPos = @NextPos+1



        IF (LEN(@UserName) > 0)

        BEGIN

            SELECT @DeletedUser = 0

            EXEC dbo.aspnet_Users_DeleteUser @ApplicationName, @UserName, 4, @DeletedUser OUTPUT

            IF( @@ERROR <> 0 )

            BEGIN

                SET @ErrorCode = -1

                GOTO Cleanup

            END

            IF (@DeletedUser <> 0)

                SELECT @NumDeleted = @NumDeleted + 1

        END

    END

    SELECT @NumDeleted

    IF (@TranStarted = 1)

    BEGIN

    	SET @TranStarted = 0

    	COMMIT TRANSACTION

    END

    SET @TranStarted = 0



    RETURN 0



Cleanup:

    IF (@TranStarted = 1 )

    BEGIN

        SET @TranStarted = 0

    	ROLLBACK TRANSACTION

    END

    RETURN @ErrorCode

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_DeleteAllState]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_DeleteAllState]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] (

    @AllUsersScope bit,

    @ApplicationName NVARCHAR(256),

    @Count int OUT)

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

        SELECT @Count = 0

    ELSE

    BEGIN

        IF (@AllUsersScope = 1)

            DELETE FROM aspnet_PersonalizationAllUsers

            WHERE PathId IN

               (SELECT Paths.PathId

                FROM dbo.aspnet_Paths Paths

                WHERE Paths.ApplicationId = @ApplicationId)

        ELSE

            DELETE FROM aspnet_PersonalizationPerUser

            WHERE PathId IN

               (SELECT Paths.PathId

                FROM dbo.aspnet_Paths Paths

                WHERE Paths.ApplicationId = @ApplicationId)



        SELECT @Count = @@ROWCOUNT

    END

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] (

    @ApplicationName  NVARCHAR(256),

    @Path              NVARCHAR(256))

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    DECLARE @PathId UNIQUEIDENTIFIER



    SELECT @ApplicationId = NULL

    SELECT @PathId = NULL



    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

    BEGIN

        RETURN

    END



    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)

    IF (@PathId IS NULL)

    BEGIN

        RETURN

    END



    DELETE FROM dbo.aspnet_PersonalizationAllUsers WHERE PathId = @PathId

    RETURN 0

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] (

    @ApplicationName  NVARCHAR(256),

    @Path              NVARCHAR(256))

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    DECLARE @PathId UNIQUEIDENTIFIER



    SELECT @ApplicationId = NULL

    SELECT @PathId = NULL



    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

    BEGIN

        RETURN

    END



    SELECT @PathId = u.PathId FROM dbo.aspnet_Paths u WHERE u.ApplicationId = @ApplicationId AND u.LoweredPath = LOWER(@Path)

    IF (@PathId IS NULL)

    BEGIN

        RETURN

    END



    SELECT p.PageSettings FROM dbo.aspnet_PersonalizationAllUsers p WHERE p.PathId = @PathId

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetSharedState]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetSharedState]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] (

    @Count int OUT,

    @ApplicationName NVARCHAR(256),

    @Path NVARCHAR(256))

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

        SELECT @Count = 0

    ELSE

    BEGIN

        DELETE FROM dbo.aspnet_PersonalizationAllUsers

        WHERE PathId IN

            (SELECT AllUsers.PathId

             FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths

             WHERE Paths.ApplicationId = @ApplicationId

                   AND AllUsers.PathId = Paths.PathId

                   AND Paths.LoweredPath = LOWER(@Path))



        SELECT @Count = @@ROWCOUNT

    END

END' 

END

GO

/****** Object:  StoredProcedure [dbo].[aspnet_PersonalizationAdministration_FindState]    Script Date: 12/21/2007 11:01:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_FindState]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[aspnet_PersonalizationAdministration_FindState] (

    @AllUsersScope bit,

    @ApplicationName NVARCHAR(256),

    @PageIndex              INT,

    @PageSize               INT,

    @Path NVARCHAR(256) = NULL,

    @UserName NVARCHAR(256) = NULL,

    @InactiveSinceDate DATETIME = NULL)

AS

BEGIN

    DECLARE @ApplicationId UNIQUEIDENTIFIER

    EXEC dbo.aspnet_Personalization_GetApplicationId @ApplicationName, @ApplicationId OUTPUT

    IF (@ApplicationId IS NULL)

        RETURN



    -- Set the page bounds

    DECLARE @PageLowerBound INT

    DECLARE @PageUpperBound INT

    DECLARE @TotalRecords   INT

    SET @PageLowerBound = @PageSize * @PageIndex

    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound



    -- Create a temp table to store the selected results

    CREATE TABLE #PageIndex (

        IndexId int IDENTITY (0, 1) NOT NULL,

        ItemId UNIQUEIDENTIFIER

    )



    IF (@AllUsersScope = 1)

    BEGIN

        -- Insert into our temp table

        INSERT INTO #PageIndex (ItemId)

        SELECT Paths.PathId

        FROM dbo.aspnet_Paths Paths,

             ((SELECT Paths.PathId

               FROM dbo.aspnet_PersonalizationAllUsers AllUsers, dbo.aspnet_Paths Paths

               WHERE Paths.ApplicationId = @ApplicationId

                      AND AllUsers.PathId = Paths.PathId

                      AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))

              ) AS SharedDataPerPath

              FULL OUTER JOIN

              (SELECT DISTINCT Paths.PathId

               FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Paths Paths

               WHERE Paths.ApplicationId = @ApplicationId

                      AND PerUser.PathId = Paths.PathId

                      AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))

              ) AS UserDataPerPath

              ON SharedDataPerPath.PathId = UserDataPerPath.PathId

             )

        WHERE Paths.PathId = SharedDataPerPath.PathId OR Paths.PathId = UserDataPerPath.PathId

        ORDER BY Paths.Path ASC



        SELECT @TotalRecords = @@ROWCOUNT



        SELECT Paths.Path,

               SharedDataPerPath.LastUpdatedDate,

               SharedDataPerPath.SharedDataLength,

               UserDataPerPath.UserDataLength,

               UserDataPerPath.UserCount

        FROM dbo.aspnet_Paths Paths,

             ((SELECT PageIndex.ItemId AS PathId,

                      AllUsers.LastUpdatedDate AS LastUpdatedDate,

                      DATALENGTH(AllUsers.PageSettings) AS SharedDataLength

               FROM dbo.aspnet_PersonalizationAllUsers AllUsers, #PageIndex PageIndex

               WHERE AllUsers.PathId = PageIndex.ItemId

                     AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound

              ) AS SharedDataPerPath

              FULL OUTER JOIN

              (SELECT PageIndex.ItemId AS PathId,

                      SUM(DATALENGTH(PerUser.PageSettings)) AS UserDataLength,

                      COUNT(*) AS UserCount

               FROM aspnet_PersonalizationPerUser PerUser, #PageIndex PageIndex

               WHERE PerUser.PathId = PageIndex.ItemId

                     AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound

               GROUP BY PageIndex.ItemId

              ) AS UserDataPerPath

              ON SharedDataPerPath.PathId = UserDataPerPath.PathId

             )

        WHERE Paths.PathId = SharedDataPerPath.PathId OR Paths.PathId = UserDataPerPath.PathId

        ORDER BY Paths.Path ASC

    END

    ELSE

    BEGIN

        -- Insert into our temp table

        INSERT INTO #PageIndex (ItemId)

        SELECT PerUser.Id

        FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths

        WHERE Paths.ApplicationId = @ApplicationId

              AND PerUser.UserId = Users.UserId

              AND PerUser.PathId = Paths.PathId

              AND (@Path IS NULL OR Paths.LoweredPath LIKE LOWER(@Path))

              AND (@UserName IS NULL OR Users.LoweredUserName LIKE LOWER(@UserName))

              AND (@InactiveSinceDate IS NULL OR Users.LastActivityDate <= @InactiveSinceDate)

        ORDER BY Paths.Path ASC, Users.UserName ASC



        SELECT @TotalRecords = @@ROWCOUNT



        SELECT Paths.Path, PerUser.LastUpdatedDate, DATALENGTH(PerUser.PageSettings), Users.UserName, Users.LastActivityDate

        FROM dbo.aspnet_PersonalizationPerUser PerUser, dbo.aspnet_Users Users, dbo.aspnet_Paths Paths, #PageIndex PageIndex

        WHERE PerUser.Id = PageIndex.ItemId

              AND PerUser.UserId = Users.UserId

              AND PerUser.PathId = Paths.PathId

              AND PageIndex.IndexId >= @PageLowerBound AND PageIndex.IndexId <= @PageUpperBound

        ORDER BY Paths.Path ASC, Users.UserName ASC

    END



    RETURN @TotalRecords

END' 

END

GO

/****** Object:  Default [DF__aspnet_Ap__Appli__03317E3D]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ap__Appli__03317E3D]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]'))

Begin

ALTER TABLE [dbo].[aspnet_Applications] ADD  CONSTRAINT [DF__aspnet_Ap__Appli__03317E3D]  DEFAULT (newid()) FOR [ApplicationId]



End

GO

/****** Object:  Default [DF__aspnet_Me__Passw__182C9B23]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Me__Passw__182C9B23]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

Begin

ALTER TABLE [dbo].[aspnet_Membership] ADD  CONSTRAINT [DF__aspnet_Me__Passw__182C9B23]  DEFAULT ((0)) FOR [PasswordFormat]



End

GO

/****** Object:  Default [DF__aspnet_Pa__PathI__48CFD27E]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Pa__PathI__48CFD27E]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]'))

Begin

ALTER TABLE [dbo].[aspnet_Paths] ADD  CONSTRAINT [DF__aspnet_Pa__PathI__48CFD27E]  DEFAULT (newid()) FOR [PathId]



End

GO

/****** Object:  Default [DF__aspnet_Perso__Id__5070F446]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Perso__Id__5070F446]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]'))

Begin

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD  CONSTRAINT [DF__aspnet_Perso__Id__5070F446]  DEFAULT (newid()) FOR [Id]



End

GO

/****** Object:  Default [DF__aspnet_Ro__RoleI__35BCFE0A]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ro__RoleI__35BCFE0A]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]'))

Begin

ALTER TABLE [dbo].[aspnet_Roles] ADD  CONSTRAINT [DF__aspnet_Ro__RoleI__35BCFE0A]  DEFAULT (newid()) FOR [RoleId]



End

GO

/****** Object:  Default [DF__aspnet_Us__UserI__07020F21]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__UserI__07020F21]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

Begin

ALTER TABLE [dbo].[aspnet_Users] ADD  CONSTRAINT [DF__aspnet_Us__UserI__07020F21]  DEFAULT (newid()) FOR [UserId]



End

GO

/****** Object:  Default [DF__aspnet_Us__Mobil__07F6335A]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__Mobil__07F6335A]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

Begin

ALTER TABLE [dbo].[aspnet_Users] ADD  CONSTRAINT [DF__aspnet_Us__Mobil__07F6335A]  DEFAULT (NULL) FOR [MobileAlias]



End

GO

/****** Object:  Default [DF__aspnet_Us__IsAno__08EA5793]    Script Date: 12/21/2007 11:01:27 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__IsAno__08EA5793]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

Begin

ALTER TABLE [dbo].[aspnet_Users] ADD  CONSTRAINT [DF__aspnet_Us__IsAno__08EA5793]  DEFAULT ((0)) FOR [IsAnonymous]



End

GO

/****** Object:  ForeignKey [FK__aspnet_Me__Appli__164452B1]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__164452B1]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

ALTER TABLE [dbo].[aspnet_Membership]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Me__Appli__164452B1] FOREIGN KEY([ApplicationId])

REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])

GO

ALTER TABLE [dbo].[aspnet_Membership] CHECK CONSTRAINT [FK__aspnet_Me__Appli__164452B1]

GO

/****** Object:  ForeignKey [FK__aspnet_Me__UserI__173876EA]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__UserI__173876EA]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))

ALTER TABLE [dbo].[aspnet_Membership]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Me__UserI__173876EA] FOREIGN KEY([UserId])

REFERENCES [dbo].[aspnet_Users] ([UserId])

GO

ALTER TABLE [dbo].[aspnet_Membership] CHECK CONSTRAINT [FK__aspnet_Me__UserI__173876EA]

GO

/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__47DBAE45]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pa__Appli__47DBAE45]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]'))

ALTER TABLE [dbo].[aspnet_Paths]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Pa__Appli__47DBAE45] FOREIGN KEY([ApplicationId])

REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])

GO

ALTER TABLE [dbo].[aspnet_Paths] CHECK CONSTRAINT [FK__aspnet_Pa__Appli__47DBAE45]

GO

/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__4D94879B]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__4D94879B]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]'))

ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Pe__PathI__4D94879B] FOREIGN KEY([PathId])

REFERENCES [dbo].[aspnet_Paths] ([PathId])

GO

ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] CHECK CONSTRAINT [FK__aspnet_Pe__PathI__4D94879B]

GO

/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__5165187F]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__5165187F]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]'))

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Pe__PathI__5165187F] FOREIGN KEY([PathId])

REFERENCES [dbo].[aspnet_Paths] ([PathId])

GO

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] CHECK CONSTRAINT [FK__aspnet_Pe__PathI__5165187F]

GO

/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__52593CB8]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__UserI__52593CB8]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]'))

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Pe__UserI__52593CB8] FOREIGN KEY([UserId])

REFERENCES [dbo].[aspnet_Users] ([UserId])

GO

ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] CHECK CONSTRAINT [FK__aspnet_Pe__UserI__52593CB8]

GO

/****** Object:  ForeignKey [FK__aspnet_Pr__UserI__2B3F6F97]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pr__UserI__2B3F6F97]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]'))

ALTER TABLE [dbo].[aspnet_Profile]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Pr__UserI__2B3F6F97] FOREIGN KEY([UserId])

REFERENCES [dbo].[aspnet_Users] ([UserId])

GO

ALTER TABLE [dbo].[aspnet_Profile] CHECK CONSTRAINT [FK__aspnet_Pr__UserI__2B3F6F97]

GO

/****** Object:  ForeignKey [FK__aspnet_Ro__Appli__34C8D9D1]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Ro__Appli__34C8D9D1]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]'))

ALTER TABLE [dbo].[aspnet_Roles]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Ro__Appli__34C8D9D1] FOREIGN KEY([ApplicationId])

REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])

GO

ALTER TABLE [dbo].[aspnet_Roles] CHECK CONSTRAINT [FK__aspnet_Ro__Appli__34C8D9D1]

GO

/****** Object:  ForeignKey [FK__aspnet_Us__Appli__060DEAE8]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__Appli__060DEAE8]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))

ALTER TABLE [dbo].[aspnet_Users]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Us__Appli__060DEAE8] FOREIGN KEY([ApplicationId])

REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])

GO

ALTER TABLE [dbo].[aspnet_Users] CHECK CONSTRAINT [FK__aspnet_Us__Appli__060DEAE8]

GO

/****** Object:  ForeignKey [FK__aspnet_Us__RoleI__398D8EEE]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__RoleI__398D8EEE]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]'))

ALTER TABLE [dbo].[aspnet_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Us__RoleI__398D8EEE] FOREIGN KEY([RoleId])

REFERENCES [dbo].[aspnet_Roles] ([RoleId])

GO

ALTER TABLE [dbo].[aspnet_UsersInRoles] CHECK CONSTRAINT [FK__aspnet_Us__RoleI__398D8EEE]

GO

/****** Object:  ForeignKey [FK__aspnet_Us__UserI__38996AB5]    Script Date: 12/21/2007 11:01:27 ******/

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__UserI__38996AB5]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]'))

ALTER TABLE [dbo].[aspnet_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Us__UserI__38996AB5] FOREIGN KEY([UserId])

REFERENCES [dbo].[aspnet_Users] ([UserId])

GO

ALTER TABLE [dbo].[aspnet_UsersInRoles] CHECK CONSTRAINT [FK__aspnet_Us__UserI__38996AB5]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Profile_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Profile_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Roles_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_WebEvent_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] TO [aspnet_Membership_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_CreateUser] TO [aspnet_Membership_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_FindUsersByEmail] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_FindUsersByName] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetAllUsers] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetNumberOfUsersOnline] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetNumberOfUsersOnline] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetPassword] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetPasswordWithFormat] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetUserByEmail] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetUserByEmail] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetUserByName] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetUserByName] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetUserByUserId] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_GetUserByUserId] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_ResetPassword] TO [aspnet_Membership_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_SetPassword] TO [aspnet_Membership_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_UnlockUser] TO [aspnet_Membership_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_UpdateUser] TO [aspnet_Membership_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Membership_UpdateUserInfo] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Paths_CreatePath] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Personalization_GetApplicationId] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] TO [aspnet_Personalization_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAdministration_FindState] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] TO [aspnet_Personalization_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAdministration_ResetUserState] TO [aspnet_Personalization_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Profile_DeleteInactiveProfiles] TO [aspnet_Profile_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Profile_DeleteProfiles] TO [aspnet_Profile_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] TO [aspnet_Profile_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Profile_GetProfiles] TO [aspnet_Profile_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Profile_GetProperties] TO [aspnet_Profile_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Profile_SetProperties] TO [aspnet_Profile_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Profile_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Profile_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Roles_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_RegisterSchemaVersion] TO [aspnet_WebEvent_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Roles_CreateRole] TO [aspnet_Roles_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Roles_DeleteRole] TO [aspnet_Roles_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Roles_GetAllRoles] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Roles_RoleExists] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Membership_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Membership_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Personalization_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Profile_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Profile_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Roles_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UnRegisterSchemaVersion] TO [aspnet_WebEvent_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_Users_DeleteUser] TO [aspnet_Membership_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_AddUsersToRoles] TO [aspnet_Roles_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_FindUsersInRole] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_GetRolesForUser] TO [aspnet_Roles_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_GetRolesForUser] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_GetUsersInRoles] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_IsUserInRole] TO [aspnet_Roles_BasicAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_IsUserInRole] TO [aspnet_Roles_ReportingAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] TO [aspnet_Roles_FullAccess]

GO

GRANT EXECUTE ON [dbo].[aspnet_WebEvent_LogEvent] TO [aspnet_WebEvent_FullAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Applications] TO [aspnet_Membership_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Applications] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Applications] TO [aspnet_Profile_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Applications] TO [aspnet_Roles_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_MembershipUsers] TO [aspnet_Membership_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Profiles] TO [aspnet_Profile_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Roles] TO [aspnet_Roles_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Users] TO [aspnet_Membership_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Users] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Users] TO [aspnet_Profile_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_Users] TO [aspnet_Roles_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_UsersInRoles] TO [aspnet_Roles_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_WebPartState_Paths] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_WebPartState_Shared] TO [aspnet_Personalization_ReportingAccess]

GO

GRANT SELECT ON [dbo].[vw_aspnet_WebPartState_User] TO [aspnet_Personalization_ReportingAccess]

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_BasicAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Membership_BasicAccess', @membername=N'aspnet_Membership_FullAccess'



END

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_ReportingAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Membership_ReportingAccess', @membername=N'aspnet_Membership_FullAccess'



END

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_BasicAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Personalization_BasicAccess', @membername=N'aspnet_Personalization_FullAccess'



END

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Personalization_ReportingAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Personalization_ReportingAccess', @membername=N'aspnet_Personalization_FullAccess'



END

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_BasicAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Profile_BasicAccess', @membername=N'aspnet_Profile_FullAccess'



END

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Profile_ReportingAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Profile_ReportingAccess', @membername=N'aspnet_Profile_FullAccess'



END

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_BasicAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Roles_BasicAccess', @membername=N'aspnet_Roles_FullAccess'



END

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Roles_ReportingAccess')

BEGIN

EXEC sys.sp_addrolemember @rolename=N'aspnet_Roles_ReportingAccess', @membername=N'aspnet_Roles_FullAccess'



END

GO

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Rama Krishna Vavilala
Architect
United States United States
No Biography provided

| Advertise | Privacy | Mobile
Web01 | 2.8.140921.1 | Last Updated 30 Dec 2007
Article Copyright 2007 by Rama Krishna Vavilala
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid