Schema.sql

/****** Object: Database [Hishop] Script Date: 05/25/2009 15:35:56 ******/
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'microsoft_database_tools_deploystamp' , NULL,NULL, NULL,NULL, NULL,NULL))
EXEC dbo.sp_addextendedproperty @name=N'microsoft_database_tools_deploystamp', @value=N'5640e7e5-863f-4929-aba8-06be58a1f631'
GO
/****** Object: ForeignKey [FK__aspnet_Me__Appli__0EA330E9] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__0EA330E9]') AND type = 'F')
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__0EA330E9]
GO
/****** Object: ForeignKey [FK__aspnet_Me__UserI__0F975522] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__UserI__0F975522]') AND type = 'F')
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__0F975522]
GO
/****** Object: ForeignKey [FK__aspnet_Pr__UserI__239E4DCF] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__aspnet_Pr__UserI__239E4DCF]') AND type = 'F')
ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT [FK__aspnet_Pr__UserI__239E4DCF]
GO
/****** Object: ForeignKey [FK__aspnet_Ro__Appli__2D27B809] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__aspnet_Ro__Appli__2D27B809]') AND type = 'F')
ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [FK__aspnet_Ro__Appli__2D27B809]
GO
/****** Object: ForeignKey [FK__aspnet_Us__Appli__7E6CC920] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__Appli__7E6CC920]') AND type = 'F')
ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [FK__aspnet_Us__Appli__7E6CC920]
GO
/****** Object: ForeignKey [FK__aspnet_Us__RoleI__31EC6D26] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__RoleI__31EC6D26]') AND type = 'F')
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__RoleI__31EC6D26]
GO
/****** Object: ForeignKey [FK__aspnet_Us__UserI__30F848ED] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__UserI__30F848ED]') AND type = 'F')
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__UserI__30F848ED]
GO
/****** Object: StoredProcedure [dbo].[sp_user_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_user_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_user_Get]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Profile_DeleteProfiles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteProfiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Profile_DeleteProfiles]
GO
/****** Object: StoredProcedure [dbo].[sp_User_GetByEmail] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_User_GetByEmail]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_User_GetByEmail]
GO
/****** Object: StoredProcedure [dbo].[sp_GetUserIDByAppToken] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_GetUserIDByAppToken]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_GetUserIDByAppToken]
GO
/****** Object: StoredProcedure [dbo].[spb_ConsultationsReplyed_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_ConsultationsReplyed_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_ConsultationsReplyed_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_GetAnonymousUserID] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_GetAnonymousUserID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_GetAnonymousUserID]
GO
/****** Object: StoredProcedure [dbo].[sp_Users_Count_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Users_Count_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Users_Count_Get]
GO
/****** Object: StoredProcedure [dbo].[spb_BanlanceDetailsUserName_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_BanlanceDetailsUserName_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_BanlanceDetailsUserName_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_LeaveComments_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_LeaveComments_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_LeaveComments_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_User_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_User_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_User_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_UserReviewsAndReplys_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_UserReviewsAndReplys_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_UserReviewsAndReplys_Get]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Roles_CreateRole] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Roles_CreateRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Roles_CreateRole]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_CreateUser] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_CreateUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_CreateUser]
GO
/****** Object: StoredProcedure [dbo].[sp_System_CreateShop] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_System_CreateShop]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_System_CreateShop]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Profile_SetProperties] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Profile_SetProperties]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Profile_SetProperties]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_HelpCategory_Sequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_HelpCategory_Sequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_HelpCategory_Sequence]
GO
/****** Object: View [dbo].[vw_aspnet_Profiles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Profiles]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_aspnet_Profiles]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_ProductExpandCategory_Add] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_ProductExpandCategory_Add]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_ProductExpandCategory_Add]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_DisplaceCategory] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_DisplaceCategory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_DisplaceCategory]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Product_Create] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Product_Create]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Product_Create]
GO
/****** Object: StoredProcedure [dbo].[spb_ProductStock_Update] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_ProductStock_Update]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_ProductStock_Update]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Product_Update] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Product_Update]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Product_Update]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_ConsultationsAndReplys_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_ConsultationsAndReplys_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_ConsultationsAndReplys_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_InpourRequest_Create] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_InpourRequest_Create]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_InpourRequest_Create]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_InpourRequest_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_InpourRequest_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_InpourRequest_Delete]
GO
/****** Object: StoredProcedure [dbo].[sp_Users_ValidateAnswereAnswer] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Users_ValidateAnswereAnswer]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Users_ValidateAnswereAnswer]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_FindUsersByEmail] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByEmail]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByEmail]
GO
/****** Object: View [dbo].[vw_aspnet_Applications] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Applications]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_aspnet_Applications]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Profile_GetProfiles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProfiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Profile_GetProfiles]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Applications_CreateApplication] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Applications_CreateApplication]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Applications_CreateApplication]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_FindUsersByName] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByName]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_GetAllUsers] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetAllUsers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_GetAllUsers]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_AccountSummary_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_AccountSummary_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_AccountSummary_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_RegisterMemberRank_Set] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_RegisterMemberRank_Set]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_RegisterMemberRank_Set]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_UpgradeMemberToAgent] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_UpgradeMemberToAgent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_UpgradeMemberToAgent]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_AgentBalaneToMember] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_AgentBalaneToMember]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_AgentBalaneToMember]
GO
/****** Object: StoredProcedure [dbo].[sp_cd_ShoppingCartProducts_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cd_ShoppingCartProducts_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cd_ShoppingCartProducts_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_BalanceDetails_Create] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_BalanceDetails_Create]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_BalanceDetails_Create]
GO
/****** Object: StoredProcedure [dbo].[sp_User_PasswordAnswer_Change] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_User_PasswordAnswer_Change]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_User_PasswordAnswer_Change]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_Regions_Sequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_Regions_Sequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_Regions_Sequence]
GO
/****** Object: View [dbo].[vw_Allregion_Users] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_Allregion_Users]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_Allregion_Users]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_Regions_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_Regions_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_Regions_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_SetIsOffForum] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_SetIsOffForum]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_SetIsOffForum]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_InsertForum] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_InsertForum]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_InsertForum]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Users_CreateUser] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Users_CreateUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Users_CreateUser]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_UnlockUser] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_UnlockUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_UnlockUser]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_UpdateUser] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUser]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_GetPasswordWithFormat] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPasswordWithFormat]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_GetPasswordWithFormat]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_GetNumberOfUsersOnline] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetNumberOfUsersOnline]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_GetNumberOfUsersOnline]
GO
/****** Object: View [dbo].[vw_aspnet_MembershipUsers] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_MembershipUsers]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_aspnet_MembershipUsers]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_GetPassword] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPassword]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_GetPassword]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_ResetPassword] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_ResetPassword]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_ResetPassword]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_UpdateUserInfo] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUserInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUserInfo]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_SetPassword] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_SetPassword]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_SetPassword]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Profile_DeleteInactiveProfiles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteInactiveProfiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Profile_DeleteInactiveProfiles]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByName] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByName]
GO
/****** Object: View [dbo].[vw_aspnet_Users] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Users]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_aspnet_Users]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByEmail] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByEmail]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByEmail]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByUserId] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByUserId]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByUserId]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Profile_GetProperties] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProperties]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Profile_GetProperties]
GO
/****** Object: StoredProcedure [dbo].[sp_Emails_Enqueue] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Emails_Enqueue]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Emails_Enqueue]
GO
/****** Object: StoredProcedure [dbo].[sp_EmailQueue_Failure] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_EmailQueue_Failure]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_EmailQueue_Failure]
GO
/****** Object: StoredProcedure [dbo].[sp_EmailQueue_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_EmailQueue_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_EmailQueue_Delete]
GO
/****** Object: StoredProcedure [dbo].[sp_Emails_Dequeue] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Emails_Dequeue]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Emails_Dequeue]
GO
/****** Object: StoredProcedure [dbo].[sp_Supplier_NameExists] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Supplier_NameExists]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Supplier_NameExists]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Supplier_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Supplier_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Supplier_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_BannedAddress_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_BannedAddress_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_BannedAddress_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_BannedAddresses_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_BannedAddresses_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_BannedAddresses_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_Order_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Order_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Order_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_Orders_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_Orders_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_Orders_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cd_CreateOrder] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cd_CreateOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cd_CreateOrder]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_Affiche_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_Affiche_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_Affiche_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_ca_Coupon_Create] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ca_Coupon_Create]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ca_Coupon_Create]
GO
/****** Object: StoredProcedure [dbo].[sp_ca_Coupon_Update] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ca_Coupon_Update]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ca_Coupon_Update]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_DefaultMemberRank_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_DefaultMemberRank_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_DefaultMemberRank_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_ManageLogs_Add] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ManageLogs_Add]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ManageLogs_Add]
GO
/****** Object: StoredProcedure [dbo].[sp_ManageLogs_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ManageLogs_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ManageLogs_Delete]
GO
/****** Object: StoredProcedure [dbo].[spb_PromoteProducts_CreateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_PromoteProducts_CreateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_PromoteProducts_CreateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_Hotkeyword_SwapDisplaySequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_Hotkeyword_SwapDisplaySequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_Hotkeyword_SwapDisplaySequence]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_Hotkeywords_Log] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_Hotkeywords_Log]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_Hotkeywords_Log]
GO
/****** Object: StoredProcedure [dbo].[sp_OrderGiftItem_Add] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_OrderGiftItem_Add]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_OrderGiftItem_Add]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_BannedNetworks_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_BannedNetworks_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_BannedNetworks_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_BannedNetwork_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_BannedNetwork_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_BannedNetwork_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_ShippingMode_Create] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_ShippingMode_Create]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_ShippingMode_Create]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_ShippingMode_Update] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_ShippingMode_Update]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_ShippingMode_Update]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_ShippingMode_Sequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_ShippingMode_Sequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_ShippingMode_Sequence]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_ShippingModes_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_ShippingModes_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_ShippingModes_Delete]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_ShippingMode_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_ShippingMode_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_ShippingMode_Get]
GO
/****** Object: StoredProcedure [dbo].[spb_RelatedProduct_Add] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_RelatedProduct_Add]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_RelatedProduct_Add]
GO
/****** Object: StoredProcedure [dbo].[sp_BrandCategory_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_BrandCategory_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_BrandCategory_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_BrandCategory_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_BrandCategory_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_BrandCategory_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_ArticleCategory_Select] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ArticleCategory_Select]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ArticleCategory_Select]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_ArticleCategory_SwapDisplaySequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_ArticleCategory_SwapDisplaySequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_ArticleCategory_SwapDisplaySequence]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_ArticleCategory_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_ArticleCategory_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_ArticleCategory_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_ArticleCategory_MainCategory] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_ArticleCategory_MainCategory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_ArticleCategory_MainCategory]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_Vote_IsBackup] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_Vote_IsBackup]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_Vote_IsBackup]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_Votes_Create] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_Votes_Create]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_Votes_Create]
GO
/****** Object: StoredProcedure [dbo].[spb_PromoteGifts_CreateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_PromoteGifts_CreateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_PromoteGifts_CreateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_OnlineServiceItem_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_OnlineServiceItem_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_OnlineServiceItem_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_OnlineServiceItem_Sequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_OnlineServiceItem_Sequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_OnlineServiceItem_Sequence]
GO
/****** Object: StoredProcedure [dbo].[aspnet_UnRegisterSchemaVersion] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UnRegisterSchemaVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_UnRegisterSchemaVersion]
GO
/****** Object: StoredProcedure [dbo].[aspnet_RegisterSchemaVersion] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_RegisterSchemaVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_RegisterSchemaVersion]
GO
/****** Object: StoredProcedure [dbo].[aspnet_CheckSchemaVersion] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_CheckSchemaVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_CheckSchemaVersion]
GO
/****** Object: StoredProcedure [dbo].[sp_FeeFree_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_FeeFree_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_FeeFree_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_Discount_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Discount_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Discount_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_PromoteQuantityDiscount_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_PromoteQuantityDiscount_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_PromoteQuantityDiscount_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_OrderLookupItems_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_OrderLookupItems_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_OrderLookupItems_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_Currency_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_Currency_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_Currency_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_ca_Promote_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ca_Promote_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ca_Promote_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_Give_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Give_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Give_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_ca_Promote_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ca_Promote_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ca_Promote_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_PrivilegeInRoles_AddDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_PrivilegeInRoles_AddDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_PrivilegeInRoles_AddDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_OrderLookupLists_CreateUpDateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_OrderLookupLists_CreateUpDateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_OrderLookupLists_CreateUpDateDelete]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Roles_RoleExists] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Roles_RoleExists]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Roles_RoleExists]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Roles_GetAllRoles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Roles_GetAllRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Roles_GetAllRoles]
GO
/****** Object: View [dbo].[vw_aspnet_Roles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Roles]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_aspnet_Roles]
GO
/****** Object: StoredProcedure [dbo].[sp_Role_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Role_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Role_Get]
GO
/****** Object: StoredProcedure [dbo].[aspnet_AnyDataInTables] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_AnyDataInTables]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_AnyDataInTables]
GO
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_GetRolesForUser] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetRolesForUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetRolesForUser]
GO
/****** Object: View [dbo].[vw_aspnet_UsersInRoles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_UsersInRoles]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_aspnet_UsersInRoles]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Roles_DeleteRole] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Roles_DeleteRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Roles_DeleteRole]
GO
/****** Object: StoredProcedure [dbo].[aspnet_Users_DeleteUser] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Users_DeleteUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_Users_DeleteUser]
GO
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_IsUserInRole] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_IsUserInRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_UsersInRoles_IsUserInRole]
GO
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_FindUsersInRole] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_FindUsersInRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_UsersInRoles_FindUsersInRole]
GO
/****** Object: StoredProcedure [dbo].[sp_UserPrivileges_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_UserPrivileges_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_UserPrivileges_Get]
GO
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]
GO
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_GetUsersInRoles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetUsersInRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetUsersInRoles]
GO
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_AddUsersToRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[aspnet_UsersInRoles_AddUsersToRoles]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_BalanceDrawRequest_Update] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_BalanceDrawRequest_Update]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_BalanceDrawRequest_Update]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_BalanceDraw_Request] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_BalanceDraw_Request]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_BalanceDraw_Request]
GO
/****** Object: StoredProcedure [dbo].[sp_SiteSettings_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_SiteSettings_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_SiteSettings_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_Roles_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Roles_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Roles_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_Roles_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Roles_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Roles_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_SiteSettings_Save] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_SiteSettings_Save]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_SiteSettings_Save]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_ProductPrices_Set] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_ProductPrices_Set]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_ProductPrices_Set]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_UserRank_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_UserRank_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_UserRank_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_Help_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_Help_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_Help_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_HelpCategory_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_HelpCategory_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_HelpCategory_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_ca_Gift_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ca_Gift_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ca_Gift_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_Present_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Present_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Present_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_co_UpdatePayOrderStock] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_co_UpdatePayOrderStock]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_co_UpdatePayOrderStock]
GO
/****** Object: StoredProcedure [dbo].[sp_co_UpdateRefundOrderStock] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_co_UpdateRefundOrderStock]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_co_UpdateRefundOrderStock]
GO
/****** Object: StoredProcedure [dbo].[sp_User_ValidTradePassword] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_User_ValidTradePassword]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_User_ValidTradePassword]
GO
/****** Object: StoredProcedure [dbo].[sp_User_SetDealPassword] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_User_SetDealPassword]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_User_SetDealPassword]
GO
/****** Object: StoredProcedure [dbo].[sp_User_ToggleSettings] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_User_ToggleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_User_ToggleSettings]
GO
/****** Object: View [dbo].[vw_Users_FullUser] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_Users_FullUser]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[vw_Users_FullUser]
GO
/****** Object: StoredProcedure [dbo].[sp_system_UserIsOnline] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_system_UserIsOnline]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_system_UserIsOnline]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_ProductPrices_ReSet] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_ProductPrices_ReSet]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_ProductPrices_ReSet]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_ProductConsultation_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_ProductConsultation_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_ProductConsultation_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_Products_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Products_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Products_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_ProductsNoPage_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ProductsNoPage_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ProductsNoPage_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Category_Create] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Category_Create]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Category_Create]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_ReviewProducts_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_ReviewProducts_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_ReviewProducts_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Category_SwapDisplaySequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Category_SwapDisplaySequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Category_SwapDisplaySequence]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Category_Update] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Category_Update]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Category_Update]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Category_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Category_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Category_Delete]
GO
/****** Object: StoredProcedure [dbo].[sp_ca_Coupon_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ca_Coupon_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ca_Coupon_Delete]
GO
/****** Object: StoredProcedure [dbo].[sp_co_GetOrderInfo] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_co_GetOrderInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_co_GetOrderInfo]
GO
/****** Object: StoredProcedure [dbo].[sp_OrderOptionItem_Add] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_OrderOptionItem_Add]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_OrderOptionItem_Add]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_FriendlyLink_Sequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_FriendlyLink_Sequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_FriendlyLink_Sequence]
GO
/****** Object: StoredProcedure [dbo].[sp_cg_FriendlyLink_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cg_FriendlyLink_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cg_FriendlyLink_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_Article_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_Article_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_Article_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_ArticleCategory_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_ArticleCategory_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_ArticleCategory_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_User_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_User_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_User_Delete]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_ShippingAddress_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_ShippingAddress_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_ShippingAddress_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_Order_Delete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_Order_Delete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_Order_Delete]
GO
/****** Object: StoredProcedure [dbo].[sp_co_Order_Option] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_co_Order_Option]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_co_Order_Option]
GO
/****** Object: StoredProcedure [dbo].[sp_co_Order_UserPay] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_co_Order_UserPay]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_co_Order_UserPay]
GO
/****** Object: StoredProcedure [dbo].[sp_co_Order_UserOption] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_co_Order_UserOption]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_co_Order_UserOption]
GO
/****** Object: StoredProcedure [dbo].[spf_PaymentMode_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spf_PaymentMode_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spf_PaymentMode_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_PaymentMode_Sequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_PaymentMode_Sequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_PaymentMode_Sequence]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_PaymentMode_CreateUpdateDelete] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_PaymentMode_CreateUpdateDelete]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_PaymentMode_CreateUpdateDelete]
GO
/****** Object: StoredProcedure [dbo].[spb_ProductNotify] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_ProductNotify]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_ProductNotify]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Attribute_SwapDisplaySequence] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Attribute_SwapDisplaySequence]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Attribute_SwapDisplaySequence]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_ProductBrowseDetails_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_ProductBrowseDetails_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_ProductBrowseDetails_Get]
GO
/****** Object: Table [dbo].[aspnet_Membership] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[aspnet_Membership]
GO
/****** Object: Table [dbo].[aspnet_Profile] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Profile]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[aspnet_Profile]
GO
/****** Object: Table [dbo].[aspnet_UsersInRoles] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[aspnet_UsersInRoles]
GO
/****** Object: Table [dbo].[aspnet_Users] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[aspnet_Users]
GO
/****** Object: Table [dbo].[aspnet_Roles] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Roles]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[aspnet_Roles]
GO
/****** Object: StoredProcedure [dbo].[sp_cb_SendedMessages_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cb_SendedMessages_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cb_SendedMessages_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cc_Attributes_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cc_Attributes_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cc_Attributes_Get]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_BalanceDrawRequestsNoPage_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_BalanceDrawRequestsNoPage_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_BalanceDrawRequestsNoPage_Get]
GO
/****** Object: Table [dbo].[Hishop_OrderItems] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_OrderItems]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_OrderItems]
GO
/****** Object: StoredProcedure [dbo].[sp_OrderLeaveWords_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_OrderLeaveWords_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_OrderLeaveWords_Get]
GO
/****** Object: Table [dbo].[Hishop_HelpCategories] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_HelpCategories]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_HelpCategories]
GO
/****** Object: StoredProcedure [dbo].[sp_cf_BalanceDetails_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cf_BalanceDetails_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cf_BalanceDetails_Get]
GO
/****** Object: Table [dbo].[Hishop_OrderLeaveWords] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_OrderLeaveWords]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_OrderLeaveWords]
GO
/****** Object: StoredProcedure [dbo].[spb_PriceChangeLogs_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[spb_PriceChangeLogs_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[spb_PriceChangeLogs_Get]
GO
/****** Object: Table [dbo].[Hishop_BalanceFreezeDetails] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_BalanceFreezeDetails]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_BalanceFreezeDetails]
GO
/****** Object: Table [dbo].[Hishop_ProductExtendCategories] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_ProductExtendCategories]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_ProductExtendCategories]
GO
/****** Object: Table [dbo].[Hishop_Products] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_Products]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_Products]
GO
/****** Object: Table [dbo].[Hishop_RefundOrders] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_RefundOrders]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_RefundOrders]
GO
/****** Object: Table [dbo].[Hishop_ProductConsultations] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_ProductConsultations]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_ProductConsultations]
GO
/****** Object: Table [dbo].[Hishop_InpourRequest] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_InpourRequest]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_InpourRequest]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_OrderItemStatisticsNoPage_Get] Script Date: 05/25/2009 15:35:56 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_cs_OrderItemStatisticsNoPage_Get]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_cs_OrderItemStatisticsNoPage_Get]
GO
/****** Object: Table [dbo].[Hishop_PromoteSales_Discount] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_PromoteSales_Discount]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_PromoteSales_Discount]
GO
/****** Object: Table [dbo].[Hishop_DeductRequest] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_DeductRequest]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_DeductRequest]
GO
/****** Object: Table [dbo].[aspnet_Applications] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Applications]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[aspnet_Applications]
GO
/****** Object: Table [dbo].[Hishop_ShippingPayment] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_ShippingPayment]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_ShippingPayment]
GO
/****** Object: Table [dbo].[Hishop_ShippingTypeGroups] Script Date: 05/25/2009 15:35:55 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Hishop_ShippingTypeGroups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[Hishop_ShippingTypeGroups]
GO
/****** Object: StoredProcedure [dbo].[sp_cs_ProductSalesNoPage_Get] Script Date: 05/25/2009 15:35