dstar2002-08-17.sql

服装销售系统,VB开发.没有解压密码

ALTER TABLE [dbo].[商品销售单表体] DROP CONSTRAINT FK_商品销售单表体_商品销售单表头
GO

/****** Object:  Stored Procedure dbo.P_INStoreBill    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[P_INStoreBill]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_INStoreBill]
GO

/****** Object:  Stored Procedure dbo.P_INStoreGoods    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[P_INStoreGoods]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_INStoreGoods]
GO

/****** Object:  Stored Procedure dbo.XP_进销存明细账    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[XP_进销存明细账]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[XP_进销存明细账]
GO

/****** Object:  View dbo.V_DATE_STORE    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_DATE_STORE]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_DATE_STORE]
GO

/****** Object:  View dbo.V_DifMainStore    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_DifMainStore]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_DifMainStore]
GO

/****** Object:  View dbo.V单品销售    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V单品销售]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V单品销售]
GO

/****** Object:  View dbo.V商品销售单    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V商品销售单]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V商品销售单]
GO

/****** Object:  View dbo.V_CalMainStore    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_CalMainStore]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_CalMainStore]
GO

/****** Object:  View dbo.V_IN_OUT_DETAIL    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_IN_OUT_DETAIL]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_IN_OUT_DETAIL]
GO

/****** Object:  View dbo.V_KFP_PSD    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_KFP_PSD]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_KFP_PSD]
GO

/****** Object:  View dbo.V_Out    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_Out]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_Out]
GO

/****** Object:  View dbo.V_PS_XS_DETAIL    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_PS_XS_DETAIL]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_PS_XS_DETAIL]
GO

/****** Object:  View dbo.V_WKFP_PSD    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_WKFP_PSD]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_WKFP_PSD]
GO

/****** Object:  View dbo.V_ZMZT    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_ZMZT]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_ZMZT]
GO

/****** Object:  View dbo.V_商品信息    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_商品信息]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_商品信息]
GO

/****** Object:  View dbo.职员信息    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[职员信息]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[职员信息]
GO

/****** Object:  View dbo.总库存    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[总库存]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[总库存]
GO

/****** Object:  View dbo.V_In_Detail    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_In_Detail]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_In_Detail]
GO

/****** Object:  View dbo.V_Out_Detail    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_Out_Detail]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_Out_Detail]
GO

/****** Object:  View dbo.V_PSD    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V_PSD]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V_PSD]
GO

/****** Object:  Table [dbo].[商品销售单表体]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[商品销售单表体]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[商品销售单表体]
GO

/****** Object:  Table [dbo].[bm]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[bm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bm]
GO

/****** Object:  Table [dbo].[Client]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Client]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Client]
GO

/****** Object:  Table [dbo].[codetemp]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[codetemp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[codetemp]
GO

/****** Object:  Table [dbo].[color]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[color]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[color]
GO

/****** Object:  Table [dbo].[GoodsType]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[GoodsType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GoodsType]
GO

/****** Object:  Table [dbo].[inf_sys]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[inf_sys]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[inf_sys]
GO

/****** Object:  Table [dbo].[InOutStore]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[InOutStore]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[InOutStore]
GO

/****** Object:  Table [dbo].[istock]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[istock]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[istock]
GO

/****** Object:  Table [dbo].[LocalMsg]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[LocalMsg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LocalMsg]
GO

/****** Object:  Table [dbo].[LSChainPDD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[LSChainPDD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LSChainPDD]
GO

/****** Object:  Table [dbo].[LSDBD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[LSDBD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LSDBD]
GO

/****** Object:  Table [dbo].[LSDHD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[LSDHD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LSDHD]
GO

/****** Object:  Table [dbo].[LSJHD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[LSJHD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LSJHD]
GO

/****** Object:  Table [dbo].[LSPDD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[LSPDD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LSPDD]
GO

/****** Object:  Table [dbo].[LSXSD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[LSXSD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LSXSD]
GO

/****** Object:  Table [dbo].[msize]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[msize]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[msize]
GO

/****** Object:  Table [dbo].[PayType]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[PayType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PayType]
GO

/****** Object:  Table [dbo].[pb]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[pb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pb]
GO

/****** Object:  Table [dbo].[POS多重付款]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[POS多重付款]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[POS多重付款]
GO

/****** Object:  Table [dbo].[POS汇总]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[POS汇总]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[POS汇总]
GO

/****** Object:  Table [dbo].[POS销售明细]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[POS销售明细]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[POS销售明细]
GO

/****** Object:  Table [dbo].[PSD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[PSD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PSD]
GO

/****** Object:  Table [dbo].[RecChainStore]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[RecChainStore]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[RecChainStore]
GO

/****** Object:  Table [dbo].[RecMainStore]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[RecMainStore]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[RecMainStore]
GO

/****** Object:  Table [dbo].[rstock]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[rstock]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[rstock]
GO

/****** Object:  Table [dbo].[ssize]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[ssize]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ssize]
GO

/****** Object:  Table [dbo].[stock]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[stock]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[stock]
GO

/****** Object:  Table [dbo].[store]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[store]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[store]
GO

/****** Object:  Table [dbo].[SYSLOG]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[SYSLOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SYSLOG]
GO

/****** Object:  Table [dbo].[UPLOAD]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[UPLOAD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UPLOAD]
GO

/****** Object:  Table [dbo].[厂商主档]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[厂商主档]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[厂商主档]
GO

/****** Object:  Table [dbo].[代销调拨单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[代销调拨单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[代销调拨单]
GO

/****** Object:  Table [dbo].[代销付款单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[代销付款单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[代销付款单]
GO

/****** Object:  Table [dbo].[代销进货单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[代销进货单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[代销进货单]
GO

/****** Object:  Table [dbo].[代销进价调整单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[代销进价调整单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[代销进价调整单]
GO

/****** Object:  Table [dbo].[代销退货单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[代销退货单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[代销退货单]
GO

/****** Object:  Table [dbo].[代销应付款]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[代销应付款]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[代销应付款]
GO

/****** Object:  Table [dbo].[代销优惠调价单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[代销优惠调价单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[代销优惠调价单]
GO

/****** Object:  Table [dbo].[订货单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[订货单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[订货单]
GO

/****** Object:  Table [dbo].[分店返货单]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[分店返货单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分店返货单]
GO

/****** Object:  Table [dbo].[分店库存]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[分店库存]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分店库存]
GO

/****** Object:  Table [dbo].[分店盘点轧帐]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[分店盘点轧帐]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分店盘点轧帐]
GO

/****** Object:  Table [dbo].[分店商品信息]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[分店商品信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分店商品信息]
GO

/****** Object:  Table [dbo].[分店销售]    Script Date: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[分店销售]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[分店销售]
GO