/****** 删除表结构 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Agent_Member]') AND parent_object_id = OBJECT_ID(N'[dbo].[Agent]'))
ALTER TABLE [dbo].[Agent] DROP CONSTRAINT [FK_Agent_Member]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BuyLimit_Category]') AND parent_object_id = OBJECT_ID(N'[dbo].[BuyLimit]'))
ALTER TABLE [dbo].[BuyLimit] DROP CONSTRAINT [FK_BuyLimit_Category]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Gift_Product]') AND parent_object_id = OBJECT_ID(N'[dbo].[Gift]'))
ALTER TABLE [dbo].[Gift] DROP CONSTRAINT [FK_Gift_Product]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Goods_Product]') AND parent_object_id = OBJECT_ID(N'[dbo].[Goods]'))
ALTER TABLE [dbo].[Goods] DROP CONSTRAINT [FK_Goods_Product]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_OrderProduct_Orders]') AND parent_object_id = OBJECT_ID(N'[dbo].[OrderProduct]'))
ALTER TABLE [dbo].[OrderProduct] DROP CONSTRAINT [FK_OrderProduct_Orders]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ShippingPrice_ShippingArea]') AND parent_object_id = OBJECT_ID(N'[dbo].[ShippingPrice]'))
ALTER TABLE [dbo].[ShippingPrice] DROP CONSTRAINT [FK_ShippingPrice_ShippingArea]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ShippPay_Shipping]') AND parent_object_id = OBJECT_ID(N'[dbo].[ShippPay]'))
ALTER TABLE [dbo].[ShippPay] DROP CONSTRAINT [FK_ShippPay_Shipping]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ShippPay_ShippingArea]') AND parent_object_id = OBJECT_ID(N'[dbo].[ShippPay]'))
ALTER TABLE [dbo].[ShippPay] DROP CONSTRAINT [FK_ShippPay_ShippingArea]
GO
/****** 对象:  Table [dbo].[ActCat]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ActCat]') AND type in (N'U'))
DROP TABLE [dbo].[ActCat]
GO
/****** 对象:  Table [dbo].[ActCatProduct]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ActCatProduct]') AND type in (N'U'))
DROP TABLE [dbo].[ActCatProduct]
GO
/****** 对象:  Table [dbo].[Activity]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Activity]') AND type in (N'U'))
DROP TABLE [dbo].[Activity]
GO
/****** 对象:  Table [dbo].[AD]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AD]') AND type in (N'U'))
DROP TABLE [dbo].[AD]
GO
/****** 对象:  Table [dbo].[ADCategory]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADCategory]') AND type in (N'U'))
DROP TABLE [dbo].[ADCategory]
GO
/****** 对象:  Table [dbo].[Admin]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Admin]') AND type in (N'U'))
DROP TABLE [dbo].[Admin]
GO
/****** 对象:  Table [dbo].[AdvancePayment]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AdvancePayment]') AND type in (N'U'))
DROP TABLE [dbo].[AdvancePayment]
GO
/****** 对象:  Table [dbo].[AdvNotify]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AdvNotify]') AND type in (N'U'))
DROP TABLE [dbo].[AdvNotify]
GO
/****** 对象:  Table [dbo].[AgencyDrawing]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgencyDrawing]') AND type in (N'U'))
DROP TABLE [dbo].[AgencyDrawing]
GO
/****** 对象:  Table [dbo].[AgencyFinance]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgencyFinance]') AND type in (N'U'))
DROP TABLE [dbo].[AgencyFinance]
GO
/****** 对象:  Table [dbo].[Agent]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Agent]') AND type in (N'U'))
DROP TABLE [dbo].[Agent]
GO
/****** 对象:  Table [dbo].[AgentCatRatio]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgentCatRatio]') AND type in (N'U'))
DROP TABLE [dbo].[AgentCatRatio]
GO
/****** 对象:  Table [dbo].[AgentDiscount]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgentDiscount]') AND type in (N'U'))
DROP TABLE [dbo].[AgentDiscount]
GO
/****** 对象:  Table [dbo].[AgentDrawing]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgentDrawing]') AND type in (N'U'))
DROP TABLE [dbo].[AgentDrawing]
GO
/****** 对象:  Table [dbo].[AgentFinance]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgentFinance]') AND type in (N'U'))
DROP TABLE [dbo].[AgentFinance]
GO
/****** 对象:  Table [dbo].[AgentLevel]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgentLevel]') AND type in (N'U'))
DROP TABLE [dbo].[AgentLevel]
GO
/****** 对象:  Table [dbo].[AgentPay]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AgentPay]') AND type in (N'U'))
DROP TABLE [dbo].[AgentPay]
GO
/****** 对象:  Table [dbo].[AppForm]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppForm]') AND type in (N'U'))
DROP TABLE [dbo].[AppForm]
GO
/****** 对象:  Table [dbo].[AppOpLog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppOpLog]') AND type in (N'U'))
DROP TABLE [dbo].[AppOpLog]
GO
/****** 对象:  Table [dbo].[AppPdt]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppPdt]') AND type in (N'U'))
DROP TABLE [dbo].[AppPdt]
GO
/****** 对象:  Table [dbo].[AppRefund]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppRefund]') AND type in (N'U'))
DROP TABLE [dbo].[AppRefund]
GO
/****** 对象:  Table [dbo].[AppShipping]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppShipping]') AND type in (N'U'))
DROP TABLE [dbo].[AppShipping]
GO
/****** 对象:  Table [dbo].[Article]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Article]') AND type in (N'U'))
DROP TABLE [dbo].[Article]
GO
/****** 对象:  Table [dbo].[ArticleCategory]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ArticleCategory]') AND type in (N'U'))
DROP TABLE [dbo].[ArticleCategory]
GO
/****** 对象:  Table [dbo].[backlist]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[backlist]') AND type in (N'U'))
DROP TABLE [dbo].[backlist]
GO
/****** 对象:  Table [dbo].[Bank]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Bank]') AND type in (N'U'))
DROP TABLE [dbo].[Bank]
GO
/****** 对象:  Table [dbo].[BankFQ]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BankFQ]') AND type in (N'U'))
DROP TABLE [dbo].[BankFQ]
GO
/****** 对象:  Table [dbo].[Brand]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Brand]') AND type in (N'U'))
DROP TABLE [dbo].[Brand]
GO
/****** 对象:  Table [dbo].[Bulletin]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Bulletin]') AND type in (N'U'))
DROP TABLE [dbo].[Bulletin]
GO
/****** 对象:  Table [dbo].[BuyLimit]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BuyLimit]') AND type in (N'U'))
DROP TABLE [dbo].[BuyLimit]
GO
/****** 对象:  Table [dbo].[BuyRecored]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BuyRecored]') AND type in (N'U'))
DROP TABLE [dbo].[BuyRecored]
GO
/****** 对象:  Table [dbo].[Card]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Card]') AND type in (N'U'))
DROP TABLE [dbo].[Card]
GO
/****** 对象:  Table [dbo].[CardContent]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CardContent]') AND type in (N'U'))
DROP TABLE [dbo].[CardContent]
GO
/****** 对象:  Table [dbo].[Catalogue]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Catalogue]') AND type in (N'U'))
DROP TABLE [dbo].[Catalogue]
GO
/****** 对象:  Table [dbo].[CatalogueVersion]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatalogueVersion]') AND type in (N'U'))
DROP TABLE [dbo].[CatalogueVersion]
GO
/****** 对象:  Table [dbo].[CatBrand]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatBrand]') AND type in (N'U'))
DROP TABLE [dbo].[CatBrand]
GO
/****** 对象:  Table [dbo].[Category]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Category]') AND type in (N'U'))
DROP TABLE [dbo].[Category]
GO
/****** 对象:  Table [dbo].[CategoryField]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CategoryField]') AND type in (N'U'))
DROP TABLE [dbo].[CategoryField]
GO
/****** 对象:  Table [dbo].[Complaint]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Complaint]') AND type in (N'U'))
DROP TABLE [dbo].[Complaint]
GO
/****** 对象:  Table [dbo].[ComplaintCat]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ComplaintCat]') AND type in (N'U'))
DROP TABLE [dbo].[ComplaintCat]
GO
/****** 对象:  Table [dbo].[Config]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Config]') AND type in (N'U'))
DROP TABLE [dbo].[Config]
GO
/****** 对象:  Table [dbo].[Coupon]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Coupon]') AND type in (N'U'))
DROP TABLE [dbo].[Coupon]
GO
/****** 对象:  Table [dbo].[CouponCart]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CouponCart]') AND type in (N'U'))
DROP TABLE [dbo].[CouponCart]
GO
/****** 对象:  Table [dbo].[CouponsMember]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CouponsMember]') AND type in (N'U'))
DROP TABLE [dbo].[CouponsMember]
GO
/****** 对象:  Table [dbo].[CouponsUsedItems]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CouponsUsedItems]') AND type in (N'U'))
DROP TABLE [dbo].[CouponsUsedItems]
GO
/****** 对象:  Table [dbo].[Currency]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Currency]') AND type in (N'U'))
DROP TABLE [dbo].[Currency]
GO
/****** 对象:  Table [dbo].[CustomFieldItem]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CustomFieldItem]') AND type in (N'U'))
DROP TABLE [dbo].[CustomFieldItem]
GO
/****** 对象:  Table [dbo].[Email]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Email]') AND type in (N'U'))
DROP TABLE [dbo].[Email]
GO
/****** 对象:  Table [dbo].[EmailList]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EmailList]') AND type in (N'U'))
DROP TABLE [dbo].[EmailList]
GO
/****** 对象:  Table [dbo].[EvalReply]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EvalReply]') AND type in (N'U'))
DROP TABLE [dbo].[EvalReply]
GO
/****** 对象:  Table [dbo].[Eventlog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Eventlog]') AND type in (N'U'))
DROP TABLE [dbo].[Eventlog]
GO
/****** 对象:  Table [dbo].[Express]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Express]') AND type in (N'U'))
DROP TABLE [dbo].[Express]
GO
/****** 对象:  Table [dbo].[FavCat]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FavCat]') AND type in (N'U'))
DROP TABLE [dbo].[FavCat]
GO
/****** 对象:  Table [dbo].[Favorite]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Favorite]') AND type in (N'U'))
DROP TABLE [dbo].[Favorite]
GO
/****** 对象:  Table [dbo].[FiltrateIP]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FiltrateIP]') AND type in (N'U'))
DROP TABLE [dbo].[FiltrateIP]
GO
/****** 对象:  Table [dbo].[FinanceDetail]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FinanceDetail]') AND type in (N'U'))
DROP TABLE [dbo].[FinanceDetail]
GO
/****** 对象:  Table [dbo].[FinanceIssue]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FinanceIssue]') AND type in (N'U'))
DROP TABLE [dbo].[FinanceIssue]
GO
/****** 对象:  Table [dbo].[FinanceSummaries]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FinanceSummaries]') AND type in (N'U'))
DROP TABLE [dbo].[FinanceSummaries]
GO
/****** 对象:  Table [dbo].[FinanceSummary]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FinanceSummary]') AND type in (N'U'))
DROP TABLE [dbo].[FinanceSummary]
GO
/****** 对象:  Table [dbo].[Fitting]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Fitting]') AND type in (N'U'))
DROP TABLE [dbo].[Fitting]
GO
/****** 对象:  Table [dbo].[FlashAD]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FlashAD]') AND type in (N'U'))
DROP TABLE [dbo].[FlashAD]
GO
/****** 对象:  Table [dbo].[Floor]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Floor]') AND type in (N'U'))
DROP TABLE [dbo].[Floor]
GO
/****** 对象:  Table [dbo].[FloorPdt]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FloorPdt]') AND type in (N'U'))
DROP TABLE [dbo].[FloorPdt]
GO
/****** 对象:  Table [dbo].[Gift]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Gift]') AND type in (N'U'))
DROP TABLE [dbo].[Gift]
GO
/****** 对象:  Table [dbo].[GiftCat]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GiftCat]') AND type in (N'U'))
DROP TABLE [dbo].[GiftCat]
GO
/****** 对象:  Table [dbo].[GiftOrder]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GiftOrder]') AND type in (N'U'))
DROP TABLE [dbo].[GiftOrder]
GO
/****** 对象:  Table [dbo].[GiftOrderItem]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GiftOrderItem]') AND type in (N'U'))
DROP TABLE [dbo].[GiftOrderItem]
GO
/****** 对象:  Table [dbo].[GiftOrderItems]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GiftOrderItems]') AND type in (N'U'))
DROP TABLE [dbo].[GiftOrderItems]
GO
/****** 对象:  Table [dbo].[GiftsCart]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GiftsCart]') AND type in (N'U'))
DROP TABLE [dbo].[GiftsCart]
GO
/****** 对象:  Table [dbo].[GiftsCart_temp]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GiftsCart_temp]') AND type in (N'U'))
DROP TABLE [dbo].[GiftsCart_temp]
GO
/****** 对象:  Table [dbo].[Goods]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Goods]') AND type in (N'U'))
DROP TABLE [dbo].[Goods]
GO
/****** 对象:  Table [dbo].[GoodsCart]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GoodsCart]') AND type in (N'U'))
DROP TABLE [dbo].[GoodsCart]
GO
/****** 对象:  Table [dbo].[KeyLink]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[KeyLink]') AND type in (N'U'))
DROP TABLE [dbo].[KeyLink]
GO
/****** 对象:  Table [dbo].[Keyword]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Keyword]') AND type in (N'U'))
DROP TABLE [dbo].[Keyword]
GO
/****** 对象:  Table [dbo].[Link]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Link]') AND type in (N'U'))
DROP TABLE [dbo].[Link]
GO
/****** 对象:  Table [dbo].[listpage]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[listpage]') AND type in (N'U'))
DROP TABLE [dbo].[listpage]
GO
/****** 对象:  Table [dbo].[log]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[log]') AND type in (N'U'))
DROP TABLE [dbo].[log]
GO
/****** 对象:  Table [dbo].[LoginRecord]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LoginRecord]') AND type in (N'U'))
DROP TABLE [dbo].[LoginRecord]
GO
/****** 对象:  Table [dbo].[MaxIDs]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MaxIDs]') AND type in (N'U'))
DROP TABLE [dbo].[MaxIDs]
GO
/****** 对象:  Table [dbo].[Member]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Member]') AND type in (N'U'))
DROP TABLE [dbo].[Member]
GO
/****** 对象:  Table [dbo].[MemberBookPmtGoods]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberBookPmtGoods]') AND type in (N'U'))
DROP TABLE [dbo].[MemberBookPmtGoods]
GO
/****** 对象:  Table [dbo].[MemberBookSecKill]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberBookSecKill]') AND type in (N'U'))
DROP TABLE [dbo].[MemberBookSecKill]
GO
/****** 对象:  Table [dbo].[MemberBookSuit]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberBookSuit]') AND type in (N'U'))
DROP TABLE [dbo].[MemberBookSuit]
GO
/****** 对象:  Table [dbo].[MemberBookTG]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberBookTG]') AND type in (N'U'))
DROP TABLE [dbo].[MemberBookTG]
GO
/****** 对象:  Table [dbo].[MemberExchangeGifts]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberExchangeGifts]') AND type in (N'U'))
DROP TABLE [dbo].[MemberExchangeGifts]
GO
/****** 对象:  Table [dbo].[MemberGroup]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberGroup]') AND type in (N'U'))
DROP TABLE [dbo].[MemberGroup]
GO
/****** 对象:  Table [dbo].[MemberSubscriptions]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberSubscriptions]') AND type in (N'U'))
DROP TABLE [dbo].[MemberSubscriptions]
GO
/****** 对象:  Table [dbo].[Message]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Message]') AND type in (N'U'))
DROP TABLE [dbo].[Message]
GO
/****** 对象:  Table [dbo].[NavBar]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NavBar]') AND type in (N'U'))
DROP TABLE [dbo].[NavBar]
GO
/****** 对象:  Table [dbo].[NewBid]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NewBid]') AND type in (N'U'))
DROP TABLE [dbo].[NewBid]
GO
/****** 对象:  Table [dbo].[NewBuy]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NewBuy]') AND type in (N'U'))
DROP TABLE [dbo].[NewBuy]
GO
/****** 对象:  Table [dbo].[NewNumber]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NewNumber]') AND type in (N'U'))
DROP TABLE [dbo].[NewNumber]
GO
/****** 对象:  Table [dbo].[NewProduct]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NewProduct]') AND type in (N'U'))
DROP TABLE [dbo].[NewProduct]
GO
/****** 对象:  Table [dbo].[News_Article]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News_Article]') AND type in (N'U'))
DROP TABLE [dbo].[News_Article]
GO
/****** 对象:  Table [dbo].[News_Category]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News_Category]') AND type in (N'U'))
DROP TABLE [dbo].[News_Category]
GO
/****** 对象:  Table [dbo].[NewsPdt]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NewsPdt]') AND type in (N'U'))
DROP TABLE [dbo].[NewsPdt]
GO
/****** 对象:  Table [dbo].[OrderCoupon]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderCoupon]') AND type in (N'U'))
DROP TABLE [dbo].[OrderCoupon]
GO
/****** 对象:  Table [dbo].[OrderInvoice]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderInvoice]') AND type in (N'U'))
DROP TABLE [dbo].[OrderInvoice]
GO
/****** 对象:  Table [dbo].[OrderOpLog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderOpLog]') AND type in (N'U'))
DROP TABLE [dbo].[OrderOpLog]
GO
/****** 对象:  Table [dbo].[OrderPresent]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderPresent]') AND type in (N'U'))
DROP TABLE [dbo].[OrderPresent]
GO
/****** 对象:  Table [dbo].[OrderProduct]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderProduct]') AND type in (N'U'))
DROP TABLE [dbo].[OrderProduct]
GO
/****** 对象:  Table [dbo].[OrderProductItem]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderProductItem]') AND type in (N'U'))
DROP TABLE [dbo].[OrderProductItem]
GO
/****** 对象:  Table [dbo].[OrderReview]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderReview]') AND type in (N'U'))
DROP TABLE [dbo].[OrderReview]
GO
/****** 对象:  Table [dbo].[Orders]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type in (N'U'))
DROP TABLE [dbo].[Orders]
GO
/****** 对象:  Table [dbo].[OutStockReg]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OutStockReg]') AND type in (N'U'))
DROP TABLE [dbo].[OutStockReg]
GO
/****** 对象:  Table [dbo].[PayInterface]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PayInterface]') AND type in (N'U'))
DROP TABLE [dbo].[PayInterface]
GO
/****** 对象:  Table [dbo].[Payment]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Payment]') AND type in (N'U'))
DROP TABLE [dbo].[Payment]
GO
/****** 对象:  Table [dbo].[paymentgift]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paymentgift]') AND type in (N'U'))
DROP TABLE [dbo].[paymentgift]
GO
/****** 对象:  Table [dbo].[PayNotify]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PayNotify]') AND type in (N'U'))
DROP TABLE [dbo].[PayNotify]
GO
/****** 对象:  Table [dbo].[PayNotifyLog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PayNotifyLog]') AND type in (N'U'))
DROP TABLE [dbo].[PayNotifyLog]
GO
/****** 对象:  Table [dbo].[PayType]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PayType]') AND type in (N'U'))
DROP TABLE [dbo].[PayType]
GO
/****** 对象:  Table [dbo].[PdtCity]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PdtCity]') AND type in (N'U'))
DROP TABLE [dbo].[PdtCity]
GO
/****** 对象:  Table [dbo].[PdtImg]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PdtImg]') AND type in (N'U'))
DROP TABLE [dbo].[PdtImg]
GO
/****** 对象:  Table [dbo].[PdtPropImg]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PdtPropImg]') AND type in (N'U'))
DROP TABLE [dbo].[PdtPropImg]
GO
/****** 对象:  Table [dbo].[PdtTag]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PdtTag]') AND type in (N'U'))
DROP TABLE [dbo].[PdtTag]
GO
/****** 对象:  Table [dbo].[PdtType]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PdtType]') AND type in (N'U'))
DROP TABLE [dbo].[PdtType]
GO
/****** 对象:  Table [dbo].[Permission]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Permission]') AND type in (N'U'))
DROP TABLE [dbo].[Permission]
GO
/****** 对象:  Table [dbo].[PmtCoupons]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtCoupons]') AND type in (N'U'))
DROP TABLE [dbo].[PmtCoupons]
GO
/****** 对象:  Table [dbo].[PmtCoupons1]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtCoupons1]') AND type in (N'U'))
DROP TABLE [dbo].[PmtCoupons1]
GO
/****** 对象:  Table [dbo].[PmtGenCoupons]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtGenCoupons]') AND type in (N'U'))
DROP TABLE [dbo].[PmtGenCoupons]
GO
/****** 对象:  Table [dbo].[PmtGifts]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtGifts]') AND type in (N'U'))
DROP TABLE [dbo].[PmtGifts]
GO
/****** 对象:  Table [dbo].[PmtGoods]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtGoods]') AND type in (N'U'))
DROP TABLE [dbo].[PmtGoods]
GO
/****** 对象:  Table [dbo].[PmtList]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtList]') AND type in (N'U'))
DROP TABLE [dbo].[PmtList]
GO
/****** 对象:  Table [dbo].[PmtProduct]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtProduct]') AND type in (N'U'))
DROP TABLE [dbo].[PmtProduct]
GO
/****** 对象:  Table [dbo].[PmtRule]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PmtRule]') AND type in (N'U'))
DROP TABLE [dbo].[PmtRule]
GO
/****** 对象:  Table [dbo].[Poll]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Poll]') AND type in (N'U'))
DROP TABLE [dbo].[Poll]
GO
/****** 对象:  Table [dbo].[Present]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Present]') AND type in (N'U'))
DROP TABLE [dbo].[Present]
GO
/****** 对象:  Table [dbo].[Product]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Product]') AND type in (N'U'))
DROP TABLE [dbo].[Product]
GO
/****** 对象:  Table [dbo].[ProductAsk]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductAsk]') AND type in (N'U'))
DROP TABLE [dbo].[ProductAsk]
GO
/****** 对象:  Table [dbo].[ProductField]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductField]') AND type in (N'U'))
DROP TABLE [dbo].[ProductField]
GO
/****** 对象:  Table [dbo].[ProductReview]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductReview]') AND type in (N'U'))
DROP TABLE [dbo].[ProductReview]
GO
/****** 对象:  Table [dbo].[Prop]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Prop]') AND type in (N'U'))
DROP TABLE [dbo].[Prop]
GO
/****** 对象:  Table [dbo].[PropValue]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PropValue]') AND type in (N'U'))
DROP TABLE [dbo].[PropValue]
GO
/****** 对象:  Table [dbo].[ReceivePay]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ReceivePay]') AND type in (N'U'))
DROP TABLE [dbo].[ReceivePay]
GO
/****** 对象:  Table [dbo].[ReceiverAddress]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ReceiverAddress]') AND type in (N'U'))
DROP TABLE [dbo].[ReceiverAddress]
GO
/****** 对象:  Table [dbo].[Repair]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Repair]') AND type in (N'U'))
DROP TABLE [dbo].[Repair]
GO
/****** 对象:  Table [dbo].[Review]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Review]') AND type in (N'U'))
DROP TABLE [dbo].[Review]
GO
/****** 对象:  Table [dbo].[ReviewReply]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ReviewReply]') AND type in (N'U'))
DROP TABLE [dbo].[ReviewReply]
GO
/****** 对象:  Table [dbo].[RltPdts]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RltPdts]') AND type in (N'U'))
DROP TABLE [dbo].[RltPdts]
GO
/****** 对象:  Table [dbo].[Role]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Role]') AND type in (N'U'))
DROP TABLE [dbo].[Role]
GO
/****** 对象:  Table [dbo].[RolePermission]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RolePermission]') AND type in (N'U'))
DROP TABLE [dbo].[RolePermission]
GO
/****** 对象:  Table [dbo].[SalesOrder]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SalesOrder]') AND type in (N'U'))
DROP TABLE [dbo].[SalesOrder]
GO
/****** 对象:  Table [dbo].[Score]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Score]') AND type in (N'U'))
DROP TABLE [dbo].[Score]
GO
/****** 对象:  Table [dbo].[sendlist]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sendlist]') AND type in (N'U'))
DROP TABLE [dbo].[sendlist]
GO
/****** 对象:  Table [dbo].[SharedLogin]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SharedLogin]') AND type in (N'U'))
DROP TABLE [dbo].[SharedLogin]
GO
/****** 对象:  Table [dbo].[ShipCart]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShipCart]') AND type in (N'U'))
DROP TABLE [dbo].[ShipCart]
GO
/****** 对象:  Table [dbo].[Shipping]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Shipping]') AND type in (N'U'))
DROP TABLE [dbo].[Shipping]
GO
/****** 对象:  Table [dbo].[ShippingArea]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingArea]') AND type in (N'U'))
DROP TABLE [dbo].[ShippingArea]
GO
/****** 对象:  Table [dbo].[ShippingExpression]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingExpression]') AND type in (N'U'))
DROP TABLE [dbo].[ShippingExpression]
GO
/****** 对象:  Table [dbo].[ShippingFree]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingFree]') AND type in (N'U'))
DROP TABLE [dbo].[ShippingFree]
GO
/****** 对象:  Table [dbo].[ShippingInvoice]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingInvoice]') AND type in (N'U'))
DROP TABLE [dbo].[ShippingInvoice]
GO
/****** 对象:  Table [dbo].[ShippingPrice]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippingPrice]') AND type in (N'U'))
DROP TABLE [dbo].[ShippingPrice]
GO
/****** 对象:  Table [dbo].[ShippPay]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShippPay]') AND type in (N'U'))
DROP TABLE [dbo].[ShippPay]
GO
/****** 对象:  Table [dbo].[ShopAdmin]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShopAdmin]') AND type in (N'U'))
DROP TABLE [dbo].[ShopAdmin]
GO
/****** 对象:  Table [dbo].[ShopEval]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShopEval]') AND type in (N'U'))
DROP TABLE [dbo].[ShopEval]
GO
/****** 对象:  Table [dbo].[ShoppingCart]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShoppingCart]') AND type in (N'U'))
DROP TABLE [dbo].[ShoppingCart]
GO
/****** 对象:  Table [dbo].[ShoppingCartCoupons]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShoppingCartCoupons]') AND type in (N'U'))
DROP TABLE [dbo].[ShoppingCartCoupons]
GO
/****** 对象:  Table [dbo].[ShoppingCartProductItems]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShoppingCartProductItems]') AND type in (N'U'))
DROP TABLE [dbo].[ShoppingCartProductItems]
GO
/****** 对象:  Table [dbo].[Spec]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Spec]') AND type in (N'U'))
DROP TABLE [dbo].[Spec]
GO
/****** 对象:  Table [dbo].[Storage]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Storage]') AND type in (N'U'))
DROP TABLE [dbo].[Storage]
GO
/****** 对象:  Table [dbo].[StorageCheck]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StorageCheck]') AND type in (N'U'))
DROP TABLE [dbo].[StorageCheck]
GO
/****** 对象:  Table [dbo].[StoreTemplate]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StoreTemplate]') AND type in (N'U'))
DROP TABLE [dbo].[StoreTemplate]
GO
/****** 对象:  Table [dbo].[SubCategory]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SubCategory]') AND type in (N'U'))
DROP TABLE [dbo].[SubCategory]
GO
/****** 对象:  Table [dbo].[Subscriptions]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Subscriptions]') AND type in (N'U'))
DROP TABLE [dbo].[Subscriptions]
GO
/****** 对象:  Table [dbo].[SubscriptionsContent]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SubscriptionsContent]') AND type in (N'U'))
DROP TABLE [dbo].[SubscriptionsContent]
GO
/****** 对象:  Table [dbo].[SubscriptionsOptions]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SubscriptionsOptions]') AND type in (N'U'))
DROP TABLE [dbo].[SubscriptionsOptions]
GO
/****** 对象:  Table [dbo].[Suit]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Suit]') AND type in (N'U'))
DROP TABLE [dbo].[Suit]
GO
/****** 对象:  Table [dbo].[SuitDetail]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SuitDetail]') AND type in (N'U'))
DROP TABLE [dbo].[SuitDetail]
GO
/****** 对象:  Table [dbo].[SuitsCart]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SuitsCart]') AND type in (N'U'))
DROP TABLE [dbo].[SuitsCart]
GO
/****** 对象:  Table [dbo].[Supplier]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Supplier]') AND type in (N'U'))
DROP TABLE [dbo].[Supplier]
GO
/****** 对象:  Table [dbo].[Survey]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Survey]') AND type in (N'U'))
DROP TABLE [dbo].[Survey]
GO
/****** 对象:  Table [dbo].[SurveyItem]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SurveyItem]') AND type in (N'U'))
DROP TABLE [dbo].[SurveyItem]
GO
/****** 对象:  Table [dbo].[SurveyOption]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SurveyOption]') AND type in (N'U'))
DROP TABLE [dbo].[SurveyOption]
GO
/****** 对象:  Table [dbo].[SurveyResult]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SurveyResult]') AND type in (N'U'))
DROP TABLE [dbo].[SurveyResult]
GO
/****** 对象:  Table [dbo].[SysErrorLog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SysErrorLog]') AND type in (N'U'))
DROP TABLE [dbo].[SysErrorLog]
GO
/****** 对象:  Table [dbo].[TagImg]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TagImg]') AND type in (N'U'))
DROP TABLE [dbo].[TagImg]
GO
/****** 对象:  Table [dbo].[TelAsk]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TelAsk]') AND type in (N'U'))
DROP TABLE [dbo].[TelAsk]
GO
/****** 对象:  Table [dbo].[Template]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Template]') AND type in (N'U'))
DROP TABLE [dbo].[Template]
GO
/****** 对象:  Table [dbo].[TopSale]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TopSale]') AND type in (N'U'))
DROP TABLE [dbo].[TopSale]
GO
/****** 对象:  Table [dbo].[Union]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Union]') AND type in (N'U'))
DROP TABLE [dbo].[Union]
GO
/****** 对象:  Table [dbo].[Unit]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Unit]') AND type in (N'U'))
DROP TABLE [dbo].[Unit]
GO
/****** 对象:  Table [dbo].[UsedScoreInCart]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UsedScoreInCart]') AND type in (N'U'))
DROP TABLE [dbo].[UsedScoreInCart]
GO
/****** 对象:  Table [dbo].[Video]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Video]') AND type in (N'U'))
DROP TABLE [dbo].[Video]
GO
/****** 对象:  Table [dbo].[VideoCat]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VideoCat]') AND type in (N'U'))
DROP TABLE [dbo].[VideoCat]
GO
/****** 对象:  Table [dbo].[VoteRecord]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VoteRecord]') AND type in (N'U'))
DROP TABLE [dbo].[VoteRecord]
GO
/****** 对象:  Table [dbo].[XpFinanceLog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpFinanceLog]') AND type in (N'U'))
DROP TABLE [dbo].[XpFinanceLog]
GO
/****** 对象:  Table [dbo].[XpScoreLog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpScoreLog]') AND type in (N'U'))
DROP TABLE [dbo].[XpScoreLog]
GO
/****** 对象:  Table [dbo].[XpShopLog]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpShopLog]') AND type in (N'U'))
DROP TABLE [dbo].[XpShopLog]
GO
/****** 对象:  Table [dbo].[Ztd]    脚本日期: 04/07/2012 15:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Ztd]') AND type in (N'U'))
DROP TABLE [dbo].[Ztd]
GO

/****** 删除存储过程 ******/

/****** 对象:  StoredProcedure [dbo].[AddOrder_Proc]    脚本日期: 04/10/2012 11:34:58 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AddOrder_Proc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[AddOrder_Proc]
GO
/****** 对象:  StoredProcedure [dbo].[CreateAllProc]    脚本日期: 04/10/2012 11:34:58 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CreateAllProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[CreateAllProc]
GO
/****** 对象:  StoredProcedure [dbo].[CreateTableProc]    脚本日期: 04/10/2012 11:34:58 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CreateTableProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[CreateTableProc]
GO
/****** 对象:  StoredProcedure [dbo].[listcoupons]    脚本日期: 04/10/2012 11:34:58 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[listcoupons]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[listcoupons]
GO
/****** 对象:  StoredProcedure [dbo].[listpagetext]    脚本日期: 04/10/2012 11:34:58 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[listpagetext]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[listpagetext]
GO
/****** 对象:  StoredProcedure [dbo].[logger]    脚本日期: 04/10/2012 11:34:58 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[logger]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[logger]
GO
/****** 对象:  StoredProcedure [dbo].[LookCartProc]    脚本日期: 04/10/2012 11:34:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LookCartProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[LookCartProc]
GO
/****** 对象:  StoredProcedure [dbo].[max1]    脚本日期: 04/10/2012 11:34:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[max1]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[max1]
GO
/****** 对象:  StoredProcedure [dbo].[MemberLogin_Proc]    脚本日期: 04/10/2012 11:34:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MemberLogin_Proc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[MemberLogin_Proc]
GO
/****** 对象:  StoredProcedure [dbo].[P_BuyLimit]    脚本日期: 04/10/2012 11:34:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_BuyLimit]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_BuyLimit]
GO
/****** 对象:  StoredProcedure [dbo].[P_Category_Update_CategoryNo]    脚本日期: 04/10/2012 11:34:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_Category_Update_CategoryNo]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_Category_Update_CategoryNo]
GO
/****** 对象:  StoredProcedure [dbo].[P_Category_Update_ParentNo]    脚本日期: 04/10/2012 11:34:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_Category_Update_ParentNo]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_Category_Update_ParentNo]
GO
/****** 对象:  StoredProcedure [dbo].[p_get_category_path]    脚本日期: 04/10/2012 11:34:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[p_get_category_path]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[p_get_category_path]
GO
/****** 对象:  StoredProcedure [dbo].[P_PmtGenCoupons]    脚本日期: 04/10/2012 11:35:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_PmtGenCoupons]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_PmtGenCoupons]
GO
/****** 对象:  StoredProcedure [dbo].[P_PmtProduct]    脚本日期: 04/10/2012 11:35:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_PmtProduct]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_PmtProduct]
GO
/****** 对象:  StoredProcedure [dbo].[P_PromotionMemberGroup]    脚本日期: 04/10/2012 11:35:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_PromotionMemberGroup]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_PromotionMemberGroup]
GO
/****** 对象:  StoredProcedure [dbo].[P_VideoCat_Update_CategoryNo]    脚本日期: 04/10/2012 11:35:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_VideoCat_Update_CategoryNo]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_VideoCat_Update_CategoryNo]
GO
/****** 对象:  StoredProcedure [dbo].[pr_backup_db]    脚本日期: 04/10/2012 11:35:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pr_backup_db]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pr_backup_db]
GO
/****** 对象:  StoredProcedure [dbo].[Pr_BackupDataBase]    脚本日期: 04/10/2012 11:35:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_BackupDataBase]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Pr_BackupDataBase]
GO
/****** 对象:  StoredProcedure [dbo].[pr_insertData]    脚本日期: 04/10/2012 11:35:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pr_insertData]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pr_insertData]
GO
/****** 对象:  StoredProcedure [dbo].[Pr_RunSQL]    脚本日期: 04/10/2012 11:35:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_RunSQL]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Pr_RunSQL]
GO
/****** 对象:  StoredProcedure [dbo].[pr_update_order_status]    脚本日期: 04/10/2012 11:35:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pr_update_order_status]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pr_update_order_status]
GO
/****** 对象:  StoredProcedure [dbo].[pr_update_product_storage]    脚本日期: 04/10/2012 11:35:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pr_update_product_storage]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pr_update_product_storage]
GO
/****** 对象:  StoredProcedure [dbo].[StoredProcedureconfig]    脚本日期: 04/10/2012 11:35:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StoredProcedureconfig]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[StoredProcedureconfig]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ActivityDetail_Get]    脚本日期: 04/10/2012 11:35:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ActivityDetail_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ActivityDetail_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Admin_Add]    脚本日期: 04/10/2012 11:35:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Admin_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Admin_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Admin_Delete]    脚本日期: 04/10/2012 11:35:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Admin_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Admin_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Admin_Login]    脚本日期: 04/10/2012 11:35:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Admin_Login]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Admin_Login]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Admin_Update]    脚本日期: 04/10/2012 11:35:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Admin_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Admin_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AdminDetail_Get]    脚本日期: 04/10/2012 11:35:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AdminDetail_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AdminDetail_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AdminPassword_Update]    脚本日期: 04/10/2012 11:35:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AdminPassword_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AdminPassword_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AdminPermission_Get]    脚本日期: 04/10/2012 11:35:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AdminPermission_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AdminPermission_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AdvancePayment_Add]    脚本日期: 04/10/2012 11:35:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AdvancePayment_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AdvancePayment_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Agent_Add]    脚本日期: 04/10/2012 11:35:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Agent_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Agent_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Agent_Delete]    脚本日期: 04/10/2012 11:35:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Agent_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Agent_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Agent_Get]    脚本日期: 04/10/2012 11:35:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Agent_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Agent_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Agent_LevelID_Update]    脚本日期: 04/10/2012 11:35:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Agent_LevelID_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Agent_LevelID_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Agent_Update]    脚本日期: 04/10/2012 11:35:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Agent_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Agent_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentDrawing_Add]    脚本日期: 04/10/2012 11:35:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentDrawing_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentDrawing_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentDrawing_Get]    脚本日期: 04/10/2012 11:35:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentDrawing_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentDrawing_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentDrawing_Update]    脚本日期: 04/10/2012 11:35:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentDrawing_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentDrawing_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentDrawingRelateInfo_Get]    脚本日期: 04/10/2012 11:35:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentDrawingRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentDrawingRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentFinance_Add]    脚本日期: 04/10/2012 11:35:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentFinance_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentFinance_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentFinance_Get]    脚本日期: 04/10/2012 11:35:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentFinance_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentFinance_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentFinance_Status_Update]    脚本日期: 04/10/2012 11:35:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentFinance_Status_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentFinance_Status_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentFinanceRelateInfo_Get]    脚本日期: 04/10/2012 11:35:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentFinanceRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentFinanceRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentLevel_Add]    脚本日期: 04/10/2012 11:35:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentLevel_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentLevel_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentLevel_Delete]    脚本日期: 04/10/2012 11:35:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentLevel_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentLevel_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentLevel_Get]    脚本日期: 04/10/2012 11:35:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentLevel_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentLevel_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentLevel_Update]    脚本日期: 04/10/2012 11:35:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentLevel_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentLevel_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentMember_Get]    脚本日期: 04/10/2012 11:35:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentMember_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentMember_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentPay_Add]    脚本日期: 04/10/2012 11:35:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentPay_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentPay_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentPay_Get]    脚本日期: 04/10/2012 11:35:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentPay_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentPay_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentPayDetail_Get]    脚本日期: 04/10/2012 11:35:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentPayDetail_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentPayDetail_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentPayRelateInfo_Get]    脚本日期: 04/10/2012 11:35:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentPayRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentPayRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AgentRelateInfo_Get]    脚本日期: 04/10/2012 11:35:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AgentRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AgentRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppForm_Add]    脚本日期: 04/10/2012 11:35:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppForm_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppForm_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppForm_Get]    脚本日期: 04/10/2012 11:35:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppForm_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppForm_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppForm_Update]    脚本日期: 04/10/2012 11:35:06 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppForm_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppForm_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppFormRelateInfo_Get]    脚本日期: 04/10/2012 11:35:07 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppFormRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppFormRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppOpLog_Add]    脚本日期: 04/10/2012 11:35:07 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppOpLog_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppOpLog_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppRefund_Add]    脚本日期: 04/10/2012 11:35:07 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppRefund_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppRefund_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppRefund_Get]    脚本日期: 04/10/2012 11:35:07 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppRefund_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppRefund_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppRefund_Update]    脚本日期: 04/10/2012 11:35:07 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppRefund_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppRefund_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AppShipping_Add]    脚本日期: 04/10/2012 11:35:07 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AppShipping_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AppShipping_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_AreaShipping_Get]    脚本日期: 04/10/2012 11:35:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_AreaShipping_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_AreaShipping_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Cart_Look]    脚本日期: 04/10/2012 11:35:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Cart_Look]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Cart_Look]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Cart_Update]    脚本日期: 04/10/2012 11:35:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Cart_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Cart_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CartItem_Add]    脚本日期: 04/10/2012 11:35:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CartItem_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CartItem_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CartItem_Add_20110823]    脚本日期: 04/10/2012 11:35:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CartItem_Add_20110823]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CartItem_Add_20110823]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CartPdtQty_Update]    脚本日期: 04/10/2012 11:35:08 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CartPdtQty_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CartPdtQty_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CartShipPrice_Get]    脚本日期: 04/10/2012 11:35:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CartShipPrice_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CartShipPrice_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CartStore_Look]    脚本日期: 04/10/2012 11:35:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CartStore_Look]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CartStore_Look]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CatBrand_Get]    脚本日期: 04/10/2012 11:35:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CatBrand_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CatBrand_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Category_Add]    脚本日期: 04/10/2012 11:35:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Category_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Category_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Category_Delete]    脚本日期: 04/10/2012 11:35:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Category_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Category_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Category_Get]    脚本日期: 04/10/2012 11:35:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Category_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Category_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Category_Update]    脚本日期: 04/10/2012 11:35:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Category_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Category_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CatPdtNum_Update]    脚本日期: 04/10/2012 11:35:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CatPdtNum_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CatPdtNum_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CatRelateInfo_Select]    脚本日期: 04/10/2012 11:35:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CatRelateInfo_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CatRelateInfo_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Channel_Init]    脚本日期: 04/10/2012 11:35:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Channel_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Channel_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Checkout_Init]    脚本日期: 04/10/2012 11:35:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Checkout_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Checkout_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CheckoutFQ_Init]    脚本日期: 04/10/2012 11:35:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CheckoutFQ_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CheckoutFQ_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CheckoutSecKill_Init]    脚本日期: 04/10/2012 11:35:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CheckoutSecKill_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CheckoutSecKill_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CheckoutSucc_Init]    脚本日期: 04/10/2012 11:35:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CheckoutSucc_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CheckoutSucc_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Common_Random_Cet]    脚本日期: 04/10/2012 11:35:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Common_Random_Cet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Common_Random_Cet]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Add]    脚本日期: 04/10/2012 11:35:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Cancle]    脚本日期: 04/10/2012 11:35:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Cancle]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Cancle]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Exchange]    脚本日期: 04/10/2012 11:35:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Exchange]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Exchange]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Issue]    脚本日期: 04/10/2012 11:35:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Issue]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Issue]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Update]    脚本日期: 04/10/2012 11:35:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Use]    脚本日期: 04/10/2012 11:35:12 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Use]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Use]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Use_20110816]    脚本日期: 04/10/2012 11:35:12 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Use_20110816]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Use_20110816]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Coupon_Use_20111013]    脚本日期: 04/10/2012 11:35:12 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Coupon_Use_20111013]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Coupon_Use_20111013]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CouponPmt_Get]    脚本日期: 04/10/2012 11:35:12 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CouponPmt_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CouponPmt_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CouponsMember_Get]    脚本日期: 04/10/2012 11:35:12 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CouponsMember_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CouponsMember_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CouponsMember_PageList_Get]    脚本日期: 04/10/2012 11:35:12 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CouponsMember_PageList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CouponsMember_PageList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_CouponWaitIssue_Get]    脚本日期: 04/10/2012 11:35:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_CouponWaitIssue_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_CouponWaitIssue_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Default_Init]    脚本日期: 04/10/2012 11:35:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Default_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Default_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_EvalReply_Insert]    脚本日期: 04/10/2012 11:35:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_EvalReply_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_EvalReply_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_EventLog_Add]    脚本日期: 04/10/2012 11:35:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_EventLog_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_EventLog_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_EventLog_Insert]    脚本日期: 04/10/2012 11:35:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_EventLog_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_EventLog_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ExportFinanceSummaries]    脚本日期: 04/10/2012 11:35:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ExportFinanceSummaries]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ExportFinanceSummaries]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ExportFinanceSummary]    脚本日期: 04/10/2012 11:35:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ExportFinanceSummary]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ExportFinanceSummary]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceDetail_Insert]    脚本日期: 04/10/2012 11:35:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceDetail_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceDetail_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceDetail_Select]    脚本日期: 04/10/2012 11:35:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceDetail_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceDetail_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceDetail_Update]    脚本日期: 04/10/2012 11:35:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceDetail_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceDetail_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceLog_Get]    脚本日期: 04/10/2012 11:35:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceLog_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceLog_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceSummaries_SelectByFenYe]    脚本日期: 04/10/2012 11:35:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceSummaries_SelectByFenYe]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceSummaries_SelectByFenYe]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceSummariesStatistics_Select]    脚本日期: 04/10/2012 11:35:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceSummariesStatistics_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceSummariesStatistics_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceSummary_Select]    脚本日期: 04/10/2012 11:35:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceSummary_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceSummary_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FinanceSummaryStatistics_Select]    脚本日期: 04/10/2012 11:35:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FinanceSummaryStatistics_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FinanceSummaryStatistics_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FlashAD_Add]    脚本日期: 04/10/2012 11:35:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FlashAD_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FlashAD_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FlashAD_Update]    脚本日期: 04/10/2012 11:35:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FlashAD_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FlashAD_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FlashADSort_Update]    脚本日期: 04/10/2012 11:35:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FlashADSort_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FlashADSort_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Floor_Add]    脚本日期: 04/10/2012 11:35:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Floor_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Floor_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Floor_Delete]    脚本日期: 04/10/2012 11:35:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Floor_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Floor_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Floor_Get]    脚本日期: 04/10/2012 11:35:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Floor_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Floor_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Floor_Update]    脚本日期: 04/10/2012 11:35:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Floor_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Floor_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FloorAndPdt_Get]    脚本日期: 04/10/2012 11:35:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FloorAndPdt_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FloorAndPdt_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_FloorRelatedInfo_Get]    脚本日期: 04/10/2012 11:35:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_FloorRelatedInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_FloorRelatedInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_GetShopSettingBySid]    脚本日期: 04/10/2012 11:35:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_GetShopSettingBySid]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_GetShopSettingBySid]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_GetSubCategory_Path]    脚本日期: 04/10/2012 11:35:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_GetSubCategory_Path]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_GetSubCategory_Path]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Gift_Add]    脚本日期: 04/10/2012 11:35:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Gift_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Gift_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Gift_Delete]    脚本日期: 04/10/2012 11:35:16 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Gift_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Gift_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Gift_Path]    脚本日期: 04/10/2012 11:35:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Gift_Path]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Gift_Path]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Gift_Update]    脚本日期: 04/10/2012 11:35:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Gift_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Gift_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_GiftCanExchageNum_Count]    脚本日期: 04/10/2012 11:35:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_GiftCanExchageNum_Count]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_GiftCanExchageNum_Count]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_GiftList_Select]    脚本日期: 04/10/2012 11:35:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_GiftList_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_GiftList_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_GiftRelateInfo_Get]    脚本日期: 04/10/2012 11:35:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_GiftRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_GiftRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_GoodsName_Update]    脚本日期: 04/10/2012 11:35:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_GoodsName_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_GoodsName_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_GoodsSearch_Get]    脚本日期: 04/10/2012 11:35:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_GoodsSearch_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_GoodsSearch_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_LimitTime_RuleAndPdt_Get]    脚本日期: 04/10/2012 11:35:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_LimitTime_RuleAndPdt_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_LimitTime_RuleAndPdt_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Login_Record]    脚本日期: 04/10/2012 11:35:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Login_Record]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Login_Record]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MainStatisics_Get]    脚本日期: 04/10/2012 11:35:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MainStatisics_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MainStatisics_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MaxID_Get]    脚本日期: 04/10/2012 11:35:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MaxID_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MaxID_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Member_Insert]    脚本日期: 04/10/2012 11:35:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Member_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Member_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Member_Login]    脚本日期: 04/10/2012 11:35:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Member_Login]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Member_Login]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Member_Update]    脚本日期: 04/10/2012 11:35:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Member_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Member_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberAddressInfo_Update]    脚本日期: 04/10/2012 11:35:19 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberAddressInfo_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberAddressInfo_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberBookTG_Delete]    脚本日期: 04/10/2012 11:35:19 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberBookTG_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberBookTG_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberBookTG_Get]    脚本日期: 04/10/2012 11:35:19 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberBookTG_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberBookTG_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberDetails_Get]    脚本日期: 04/10/2012 11:35:19 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberDetails_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberDetails_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberInfo_Get]    脚本日期: 04/10/2012 11:35:19 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberPassword_Update]    脚本日期: 04/10/2012 11:35:19 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberPassword_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberPassword_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberScore_Update]    脚本日期: 04/10/2012 11:35:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberScore_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberScore_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MemberThirdPart_Insert]    脚本日期: 04/10/2012 11:35:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MemberThirdPart_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MemberThirdPart_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_MyOrders_Get]    脚本日期: 04/10/2012 11:35:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_MyOrders_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_MyOrders_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_NewPdtAsk_Select]    脚本日期: 04/10/2012 11:35:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_NewPdtAsk_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_NewPdtAsk_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_NotReviewProduct_Select]    脚本日期: 04/10/2012 11:35:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_NotReviewProduct_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_NotReviewProduct_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ObjectModifyTime_View]    脚本日期: 04/10/2012 11:35:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ObjectModifyTime_View]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ObjectModifyTime_View]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_Cancel]    脚本日期: 04/10/2012 11:35:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_Cancel]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_Cancel]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_Complete]    脚本日期: 04/10/2012 11:35:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_Complete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_Complete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_Confirm]    脚本日期: 04/10/2012 11:35:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_Confirm]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_Confirm]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_ConfirmReceived]    脚本日期: 04/10/2012 11:35:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_ConfirmReceived]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_ConfirmReceived]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_Delete]    脚本日期: 04/10/2012 11:35:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_Make]    脚本日期: 04/10/2012 11:35:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_Make]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_Make]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_Refund]    脚本日期: 04/10/2012 11:35:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_Refund]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_Refund]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_SendGoods]    脚本日期: 04/10/2012 11:35:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_SendGoods]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_SendGoods]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Order_Update]    脚本日期: 04/10/2012 11:35:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Order_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Order_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderCitic_Select]    脚本日期: 04/10/2012 11:35:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderCitic_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderCitic_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderInvoice_Insert]    脚本日期: 04/10/2012 11:35:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderInvoice_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderInvoice_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderList_Get]    脚本日期: 04/10/2012 11:35:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderMoney_Change]    脚本日期: 04/10/2012 11:35:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderMoney_Change]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderMoney_Change]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderOpLog_Add]    脚本日期: 04/10/2012 11:35:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderOpLog_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderOpLog_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderPayNotify_Add]    脚本日期: 04/10/2012 11:35:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderPayNotify_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderPayNotify_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderProduct_Get]    脚本日期: 04/10/2012 11:35:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderProduct_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderProduct_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderRefundNotify_Add]    脚本日期: 04/10/2012 11:35:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderRefundNotify_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderRefundNotify_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderRelateInfo_Get]    脚本日期: 04/10/2012 11:35:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderRemark_Update]    脚本日期: 04/10/2012 11:35:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderRemark_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderRemark_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Orders_Search]    脚本日期: 04/10/2012 11:35:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Orders_Search]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Orders_Search]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderSecKill_Make]    脚本日期: 04/10/2012 11:35:23 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderSecKill_Make]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderSecKill_Make]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderStatistics]    脚本日期: 04/10/2012 11:35:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderStatistics]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderStatistics]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderStatus_BatchUpdate]    脚本日期: 04/10/2012 11:35:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderStatus_BatchUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderStatus_BatchUpdate]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderTG_BatchMake]    脚本日期: 04/10/2012 11:35:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderTG_BatchMake]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderTG_BatchMake]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_OrderTG_Make]    脚本日期: 04/10/2012 11:35:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_OrderTG_Make]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_OrderTG_Make]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PaymentOrder_Get]    脚本日期: 04/10/2012 11:35:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PaymentOrder_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PaymentOrder_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PayOnLineGift_Send]    脚本日期: 04/10/2012 11:35:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PayOnLineGift_Send]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PayOnLineGift_Send]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Pdt_Insert]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Pdt_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Pdt_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Pdt_Update]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Pdt_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Pdt_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtAsk_Get]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtAsk_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtAsk_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtAsk_Select]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtAsk_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtAsk_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtAsk_Update]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtAsk_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtAsk_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtCityName_Update]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtCityName_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtCityName_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtExport_Get]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtExport_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtExport_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtForBaiduOpen_Get]    脚本日期: 04/10/2012 11:35:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtForBaiduOpen_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtForBaiduOpen_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtImg_Get]    脚本日期: 04/10/2012 11:35:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtImg_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtImg_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtInfo_Select]    脚本日期: 04/10/2012 11:35:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtInfo_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtInfo_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtLimitTime_Get]    脚本日期: 04/10/2012 11:35:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtLimitTime_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtLimitTime_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtLimitTime_PageList_Get]    脚本日期: 04/10/2012 11:35:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtLimitTime_PageList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtLimitTime_PageList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtList_Get]    脚本日期: 04/10/2012 11:35:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtList_Search]    脚本日期: 04/10/2012 11:35:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtList_Search]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtList_Search]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtPromotion_PageList_Get]    脚本日期: 04/10/2012 11:35:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtPromotion_PageList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtPromotion_PageList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtRecentView_Get]    脚本日期: 04/10/2012 11:35:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtRecentView_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtRecentView_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtRelateInfo_Get]    脚本日期: 04/10/2012 11:35:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtReview_BatchAdd]    脚本日期: 04/10/2012 11:35:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtReview_BatchAdd]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtReview_BatchAdd]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtReviewList_Get]    脚本日期: 04/10/2012 11:35:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtReviewList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtReviewList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtSearch_Get]    脚本日期: 04/10/2012 11:35:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtSearch_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtSearch_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtSearch_Init]    脚本日期: 04/10/2012 11:35:27 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtSearch_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtSearch_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtSearchForRule_Get]    脚本日期: 04/10/2012 11:35:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtSearchForRule_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtSearchForRule_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtSecKill_Get]    脚本日期: 04/10/2012 11:35:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtSecKill_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtSecKill_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtSecKill_PageList_Get]    脚本日期: 04/10/2012 11:35:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtSecKill_PageList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtSecKill_PageList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtSecKill_PageList_Get_bak]    脚本日期: 04/10/2012 11:35:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtSecKill_PageList_Get_bak]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtSecKill_PageList_Get_bak]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtSkumap_Update]    脚本日期: 04/10/2012 11:35:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtSkumap_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtSkumap_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtStatus_Update]    脚本日期: 04/10/2012 11:35:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtStatus_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtStatus_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtTag_Add]    脚本日期: 04/10/2012 11:35:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtTag_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtTag_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtTag_Get]    脚本日期: 04/10/2012 11:35:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtTag_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtTag_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PdtTopSale_Get]    脚本日期: 04/10/2012 11:35:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PdtTopSale_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PdtTopSale_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtGoods_Get]    脚本日期: 04/10/2012 11:35:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtGoods_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtGoods_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtGoodsRelateInfo_Get]    脚本日期: 04/10/2012 11:35:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtGoodsRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtGoodsRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtList_Insert]    脚本日期: 04/10/2012 11:35:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtList_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtList_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtList_Update]    脚本日期: 04/10/2012 11:35:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtList_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtList_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_CouponIssue_Insert]    脚本日期: 04/10/2012 11:35:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_CouponIssue_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_CouponIssue_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_CouponIssue_RelatedInfo_Get]    脚本日期: 04/10/2012 11:35:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_CouponIssue_RelatedInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_CouponIssue_RelatedInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_CouponIssue_Update]    脚本日期: 04/10/2012 11:35:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_CouponIssue_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_CouponIssue_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_Delete]    脚本日期: 04/10/2012 11:35:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_Insert]    脚本日期: 04/10/2012 11:35:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_LimitTime_Insert]    脚本日期: 04/10/2012 11:35:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_LimitTime_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_LimitTime_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_LimitTime_RelatedInfo_Get]    脚本日期: 04/10/2012 11:35:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_LimitTime_RelatedInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_LimitTime_RelatedInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_LimitTime_Update]    脚本日期: 04/10/2012 11:35:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_LimitTime_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_LimitTime_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_PageList_Get]    脚本日期: 04/10/2012 11:35:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_PageList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_PageList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PmtRule_Update]    脚本日期: 04/10/2012 11:35:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PmtRule_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PmtRule_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Proc_BatchUpdateBrand]    脚本日期: 04/10/2012 11:35:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Proc_BatchUpdateBrand]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Proc_BatchUpdateBrand]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Proc_BatchUpdateIsforsale]    脚本日期: 04/10/2012 11:35:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Proc_BatchUpdateIsforsale]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Proc_BatchUpdateIsforsale]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Proc_BatchUpdateName]    脚本日期: 04/10/2012 11:35:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Proc_BatchUpdateName]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Proc_BatchUpdateName]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Proc_BatchUpdatePrice]    脚本日期: 04/10/2012 11:35:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Proc_BatchUpdatePrice]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Proc_BatchUpdatePrice]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Proc_BatchUpdateShortDesc]    脚本日期: 04/10/2012 11:35:31 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Proc_BatchUpdateShortDesc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Proc_BatchUpdateShortDesc]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Proc_BatchUpdateWeight]    脚本日期: 04/10/2012 11:35:32 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Proc_BatchUpdateWeight]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Proc_BatchUpdateWeight]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Product_Delete]    脚本日期: 04/10/2012 11:35:32 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Product_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Product_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductList_Select]    脚本日期: 04/10/2012 11:35:32 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductList_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductList_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductNum_Update]    脚本日期: 04/10/2012 11:35:32 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductNum_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductNum_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductReview_Check]    脚本日期: 04/10/2012 11:35:32 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductReview_Check]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductReview_Check]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductReview_Delete]    脚本日期: 04/10/2012 11:35:32 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductReview_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductReview_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductReview_Insert]    脚本日期: 04/10/2012 11:35:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductReview_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductReview_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductReview_Update]    脚本日期: 04/10/2012 11:35:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductReview_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductReview_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductSelectByFenYe]    脚本日期: 04/10/2012 11:35:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductSelectByFenYe]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductSelectByFenYe]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductStatistics_Select]    脚本日期: 04/10/2012 11:35:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductStatistics_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductStatistics_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ProductStorage_Update]    脚本日期: 04/10/2012 11:35:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ProductStorage_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ProductStorage_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Prop_Delete]    脚本日期: 04/10/2012 11:35:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Prop_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Prop_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PropValue_Add]    脚本日期: 04/10/2012 11:35:33 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PropValue_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PropValue_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_PropValueSort_Update]    脚本日期: 04/10/2012 11:35:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_PropValueSort_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_PropValueSort_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ReceivePay_Add]    脚本日期: 04/10/2012 11:35:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ReceivePay_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ReceivePay_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ReceivePay_Insert]    脚本日期: 04/10/2012 11:35:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ReceivePay_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ReceivePay_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ReceiverAddress_Insert]    脚本日期: 04/10/2012 11:35:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ReceiverAddress_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ReceiverAddress_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ReceiverAddress_Update]    脚本日期: 04/10/2012 11:35:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ReceiverAddress_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ReceiverAddress_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Role_Add]    脚本日期: 04/10/2012 11:35:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Role_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Role_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Role_Delete]    脚本日期: 04/10/2012 11:35:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Role_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Role_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Role_Update]    脚本日期: 04/10/2012 11:35:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Role_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Role_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_RolePermission_Add]    脚本日期: 04/10/2012 11:35:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_RolePermission_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_RolePermission_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_RolePermission_Get]    脚本日期: 04/10/2012 11:35:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_RolePermission_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_RolePermission_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ScoreLog_Init]    脚本日期: 04/10/2012 11:35:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ScoreLog_Init]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ScoreLog_Init]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ScoreLog_Insert]    脚本日期: 04/10/2012 11:35:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ScoreLog_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ScoreLog_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SecKill_Add]    脚本日期: 04/10/2012 11:35:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SecKill_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SecKill_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SecKillMember_Get]    脚本日期: 04/10/2012 11:35:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SecKillMember_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SecKillMember_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShippingPrice_Select]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShippingPrice_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShippingPrice_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShippingPrice_Update]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShippingPrice_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShippingPrice_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShipPrice_Get]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShipPrice_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShipPrice_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShopEval_Check]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShopEval_Check]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShopEval_Check]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShopEval_Delete]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShopEval_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShopEval_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShopEval_Insert]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShopEval_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShopEval_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShopEval_Select]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShopEval_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShopEval_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShopEval_Update]    脚本日期: 04/10/2012 11:35:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShopEval_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShopEval_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_ShopEvalAndReply_Select]    脚本日期: 04/10/2012 11:35:37 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_ShopEvalAndReply_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_ShopEvalAndReply_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Storage_Add]    脚本日期: 04/10/2012 11:35:37 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Storage_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Storage_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_StorageCheck_Add]    脚本日期: 04/10/2012 11:35:37 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_StorageCheck_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_StorageCheck_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_StoreCart_Look]    脚本日期: 04/10/2012 11:35:37 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_StoreCart_Look]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_StoreCart_Look]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SubCategory_Delete]    脚本日期: 04/10/2012 11:35:37 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SubCategory_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SubCategory_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SubCategory_Insert]    脚本日期: 04/10/2012 11:35:37 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SubCategory_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SubCategory_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SubCategory_Select]    脚本日期: 04/10/2012 11:35:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SubCategory_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SubCategory_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SubCategory_Update]    脚本日期: 04/10/2012 11:35:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SubCategory_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SubCategory_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SubCategoryChilds_Update]    脚本日期: 04/10/2012 11:35:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SubCategoryChilds_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SubCategoryChilds_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Suit_Add]    脚本日期: 04/10/2012 11:35:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Suit_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Suit_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Suit_Delete]    脚本日期: 04/10/2012 11:35:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Suit_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Suit_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Suit_Update]    脚本日期: 04/10/2012 11:35:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Suit_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Suit_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SuitList_Get]    脚本日期: 04/10/2012 11:35:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SuitList_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SuitList_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SuitRelatedInfo_Get]    脚本日期: 04/10/2012 11:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SuitRelatedInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SuitRelatedInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Supplier_ShopAdmin_Delete]    脚本日期: 04/10/2012 11:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Supplier_ShopAdmin_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Supplier_ShopAdmin_Delete]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Supplier_ShopAdmin_Insert]    脚本日期: 04/10/2012 11:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Supplier_ShopAdmin_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Supplier_ShopAdmin_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Supplier_ShopAdmin_Select]    脚本日期: 04/10/2012 11:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Supplier_ShopAdmin_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Supplier_ShopAdmin_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Supplier_ShopAdmin_Update]    脚本日期: 04/10/2012 11:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Supplier_ShopAdmin_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Supplier_ShopAdmin_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SupplierInfo_Get]    脚本日期: 04/10/2012 11:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SupplierInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SupplierInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SupplierLogin_Select]    脚本日期: 04/10/2012 11:35:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SupplierLogin_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SupplierLogin_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SupplierPdt_Update]    脚本日期: 04/10/2012 11:35:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SupplierPdt_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SupplierPdt_Update]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Sys_CreateTableProc]    脚本日期: 04/10/2012 11:35:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Sys_CreateTableProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Sys_CreateTableProc]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Sys_Email_Send]    脚本日期: 04/10/2012 11:35:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Sys_Email_Send]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Sys_Email_Send]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Sys_MakeDeleteProc]    脚本日期: 04/10/2012 11:35:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Sys_MakeDeleteProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Sys_MakeDeleteProc]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Sys_MakeInsertProc]    脚本日期: 04/10/2012 11:35:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Sys_MakeInsertProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Sys_MakeInsertProc]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Sys_MakeSelectProc]    脚本日期: 04/10/2012 11:35:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Sys_MakeSelectProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Sys_MakeSelectProc]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Sys_MakeUpdateProc]    脚本日期: 04/10/2012 11:35:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Sys_MakeUpdateProc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Sys_MakeUpdateProc]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_SystemConfig_Select]    脚本日期: 04/10/2012 11:35:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_SystemConfig_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_SystemConfig_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Test_Add]    脚本日期: 04/10/2012 11:35:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Test_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Test_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_TGGoodsList_Select]    脚本日期: 04/10/2012 11:35:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_TGGoodsList_Select]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_TGGoodsList_Select]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_TGGoodsRelateInfo_Get]    脚本日期: 04/10/2012 11:35:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_TGGoodsRelateInfo_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_TGGoodsRelateInfo_Get]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_TuanGou_Add]    脚本日期: 04/10/2012 11:35:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_TuanGou_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_TuanGou_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_UpdateFinanceStatus_Step1]    脚本日期: 04/10/2012 11:35:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_UpdateFinanceStatus_Step1]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_UpdateFinanceStatus_Step1]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_UpdateFinanceStatus_Step2]    脚本日期: 04/10/2012 11:35:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_UpdateFinanceStatus_Step2]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_UpdateFinanceStatus_Step2]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_UpdateFinanceStatus_Step3]    脚本日期: 04/10/2012 11:35:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_UpdateFinanceStatus_Step3]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_UpdateFinanceStatus_Step3]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_UpdateFinanceStatus_Step4]    脚本日期: 04/10/2012 11:35:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_UpdateFinanceStatus_Step4]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_UpdateFinanceStatus_Step4]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_Vote_Add]    脚本日期: 04/10/2012 11:35:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_Vote_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_Vote_Add]
GO
/****** 对象:  StoredProcedure [dbo].[XpProc_XpFinanceLog_Insert]    脚本日期: 04/10/2012 11:35:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpProc_XpFinanceLog_Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpProc_XpFinanceLog_Insert]
GO
/****** 对象:  StoredProcedure [dbo].[XpShop_SheQu_Update]    脚本日期: 04/10/2012 11:35:42 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[XpShop_SheQu_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[XpShop_SheQu_Update]
GO

/****** 删除函数 ******/
/****** 对象:  UserDefinedFunction [dbo].[f_addsign]    脚本日期: 04/10/2012 19:25:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_addsign]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_addsign]
GO
/****** 对象:  UserDefinedFunction [dbo].[f_BuyLimitPrice]    脚本日期: 04/10/2012 19:25:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_BuyLimitPrice]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_BuyLimitPrice]
GO
/****** 对象:  UserDefinedFunction [dbo].[f_GetCategoryNo]    脚本日期: 04/10/2012 19:25:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_GetCategoryNo]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_GetCategoryNo]
GO
/****** 对象:  UserDefinedFunction [dbo].[f_GetShippingAreaNo]    脚本日期: 04/10/2012 19:25:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_GetShippingAreaNo]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_GetShippingAreaNo]
GO
/****** 对象:  UserDefinedFunction [dbo].[f_getstorage]    脚本日期: 04/10/2012 19:25:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_getstorage]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_getstorage]
GO
/****** 对象:  UserDefinedFunction [dbo].[f_GetVideoCategoryNo]    脚本日期: 04/10/2012 19:25:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_GetVideoCategoryNo]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_GetVideoCategoryNo]
GO
/****** 对象:  UserDefinedFunction [dbo].[f_l_removesign]    脚本日期: 04/10/2012 19:25:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_l_removesign]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_l_removesign]
GO
/****** 对象:  UserDefinedFunction [dbo].[f_r_removesign]    脚本日期: 04/10/2012 19:25:39 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_r_removesign]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[f_r_removesign]
GO
/****** 对象:  UserDefinedFunction [dbo].[fnCleanDefaultValue]    脚本日期: 04/10/2012 19:25:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fnCleanDefaultValue]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fnCleanDefaultValue]
GO
/****** 对象:  UserDefinedFunction [dbo].[fnColumnDefault]    脚本日期: 04/10/2012 19:25:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fnColumnDefault]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fnColumnDefault]
GO
/****** 对象:  UserDefinedFunction [dbo].[fnIsColumnPrimaryKey]    脚本日期: 04/10/2012 19:25:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fnIsColumnPrimaryKey]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fnIsColumnPrimaryKey]
GO
/****** 对象:  UserDefinedFunction [dbo].[fnTableHasPrimaryKey]    脚本日期: 04/10/2012 19:25:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fnTableHasPrimaryKey]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fnTableHasPrimaryKey]
GO
/****** 对象:  UserDefinedFunction [dbo].[MD5]    脚本日期: 04/10/2012 19:25:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MD5]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[MD5]
GO
/****** 对象:  UserDefinedFunction [dbo].[fnTableColumnInfo]    脚本日期: 04/10/2012 19:25:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fnTableColumnInfo]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fnTableColumnInfo]
GO
/****** 对象:  UserDefinedFunction [dbo].[func_splitchar]    脚本日期: 04/10/2012 19:25:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[func_splitchar]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[func_splitchar]
GO
/****** 对象:  UserDefinedFunction [dbo].[func_splitint]    脚本日期: 04/10/2012 19:25:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[func_splitint]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[func_splitint]
GO
/****** 对象:  UserDefinedFunction [dbo].[func_splitint2]    脚本日期: 04/10/2012 19:25:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[func_splitint2]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[func_splitint2]
GO
/****** 对象:  UserDefinedFunction [dbo].[SplitToTable_Func]    脚本日期: 04/10/2012 19:25:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SplitToTable_Func]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[SplitToTable_Func]
GO

/****** 删除视图 ******/
/****** 对象:  View [dbo].[PmtGoodsList]    脚本日期: 04/12/2012 14:16:35 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[PmtGoodsList]'))
DROP VIEW [dbo].[PmtGoodsList]