Hishop网店系统V5.4正式版

/****** Object: ForeignKey [FK__aspnet_Me__Appli__0EA330E9] Script Date: 04/11/2011 09:04:20 ******/ 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: 04/11/2011 09:04:20 ******/ 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: 04/11/2011 09:04:20 ******/ 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: 04/11/2011 09:04:20 ******/ 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: 04/11/2011 09:04:20 ******/ 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: 04/11/2011 09:04:20 ******/ 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: 04/11/2011 09:04:20 ******/ 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: ForeignKey [FK_Hishop_CountDown_Products] Script Date: 04/11/2011 09:04:20 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Hishop_CountDown_Products]') AND type = 'F') ALTER TABLE [dbo].[Hishop_CountDown] DROP CONSTRAINT [FK_Hishop_CountDown_Products] GO /****** Object: ForeignKey [FK_Hishop_GroupBuy_Products] Script Date: 04/11/2011 09:04:20 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Hishop_GroupBuy_Products]') AND type = 'F') ALTER TABLE [dbo].[Hishop_GroupBuy] DROP CONSTRAINT [FK_Hishop_GroupBuy_Products] GO /****** Object: ForeignKey [FK_Hishop_ProductTypeBrands_Hishop_BrandCategories] Script Date: 04/11/2011 09:04:20 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Hishop_ProductTypeBrands_Hishop_BrandCategories]') AND type = 'F') ALTER TABLE [dbo].[Hishop_ProductTypeBrands] DROP CONSTRAINT [FK_Hishop_ProductTypeBrands_Hishop_BrandCategories] GO /****** Object: ForeignKey [FK_Hishop_ProductTypeBrands_Hishop_ProductTypes] Script Date: 04/11/2011 09:04:20 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Hishop_ProductTypeBrands_Hishop_ProductTypes]') AND type = 'F') ALTER TABLE [dbo].[Hishop_ProductTypeBrands] DROP CONSTRAINT [FK_Hishop_ProductTypeBrands_Hishop_ProductTypes] GO /****** Object: StoredProcedure [dbo].[sp_user_Get] Script Date: 04/11/2011 09:04:21 ******/ 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].[sp_cb_LeaveComments_Get] Script Date: 04/11/2011 09:04:21 ******/ IF �