超市管理系统 table hyspjg add sl decimal(12,3) null,yzxj

文件名称: 超市管理系统

所属分类: 餐饮零售

开发工具:

文件大小: 21kb

下载次数: 0

上传时间: 2011-11-11

提供者: yangwe*******

下载 (21kb)

不能下载？报告错误

详细说明： table hyspjg add sl decimal(12,3) null,yzxj decimal(12,2) null,hyzxj decimal(12,2) null,zdr char(6) null, zdrq smalldatetime null,zxr char(6) null,zxrq smalldatetime null go create table dbo.sjjhjld ( djmc char(20) null, fdbh char(3) null, fsksrq smalldatetime null, fsjsrq smalldatetime null, fszs smallint null, fsje decimal(12, 2) null, jszs smallint null, jsje decimal(12, 2) null, rq smalldatetime null, zxr char(6) null, xz char(1) null ) go create table dbo.psdzbqr ( psdh char(13) not null, pse decimal(12, 2) null, qrr char(6) null, qrrq smalldatetime null, shr char(6) null, shrq smalldatetime null ) go alter table spkcrb add spfl char(1) null go alter table spkcrb add brmle decimal(12,2) null,status char(1) null,rdrq smalldatetime null,zhrkrq smalldatetime null,zhxsrq smalldatetime null,zhwlrq smalldatetime null,zhdhrq smalldatetime null,cxmbl decimal(12,3) null,jhzzts smallint null go alter table spkcrb add zxj decimal(12,4) null go alter table spkcrb add zhjj decimal(12,4) null go alter table pfdmx add yhl decimal(12,2) null go alter table spzdjh add lsj decimal(12,4) null go alter table npdbcs add zbfdbh char(3) null go alter table npdbcs add zbbz char(1) null go alter table pfd add bmbh char(2) null go alter table gkthd add bmbh char(2) null go alter table gkthd add jsfsbh1 char(2) null go alter table qhdmx add dj decimal(12,4) null go alter table gkthd add jsfsbh2 char(2) null go alter table txxxb add rbkce decimal(12,2) null,pcbkce decimal(12,2) null go alter table gkthd add fkje1 decimal(12,2) null go alter table gkthd add fkje2 decimal(12,2) null go alter table gkthd add kh1 varchar null go alter table gkthd add kh2 varchar null go alter table gkthdmx add cbj decimal(12,4) null go alter table czrzb add ip char(20) null go alter table sprkerr add fdbh char(3) null go alter table gyskhbtemp add spbh char(6) null go alter table hyzd add mz smallint null go alter table gyskhb add dlpm smallint null go alter table gysfk add bmbh char(2) null, xzbh char(5) null, kl decimal(5,2) null go alter table yyyrbtemp add zgbh char(6) not null go alter table yyyrbtemp add ppbh char(6) not null go alter table yyyrbtemp add bj char(1) null go alter table yyyrbtemp add tcbl decimal(5,2) null go alter table yyyrb add zgbh char(6) not null go alter table yyyrb add ppbh char(6) not null go alter table yyyrb add bj char(1) null go alter table yyyrb add tcbl decimal(5,2) null go /* 客单价*/ alter table spsdbbgk drop jycs go alter table spsdbbgk add jycs smallint null go alter table xlrb add dljycs smallint null go alter table xlrb add zljycs smallint null go alter table fdrb add jycs smallint null go alter table xlrb add jycs smallint null go alter table xzrb add jycs smallint null go alter table spsdbbtemp add oldjh char(4) null go alter table spsdbbbmtemp add oldjh char(4) null go alter table spsdbbtemp add oldxlbh char(6) null, oldxph char(8) null go alter table spsdbbbmtemp add oldbmbh char(2) null, oldxph char(8) null go /*周转分析*/ alter table fdrb add dxpzs decimal(12,0) null, wtpzs decimal(12,0) null, wtkce decimal(12,2) null, wxkce decimal(12,2) null, dxkce decimal(12,2) null, zzts decimal(12,0) null, jcbl decimal(12,2) null, zzbhsxse decimal(12,2) null, zzmle decimal(12,2) null go alter table xzrb add dxpzs decimal(12,0) null, wtpzs decimal(12,0) null, wtkce decimal(12,2) null, wxkce decimal(12,2) null, dxkce decimal(12,2) null, zzts decimal(12,0) null, jcbl decimal(12,2) null, zzbhsxse decimal(12,2) null, zzmle decimal(12,2) null go alter table xlrb add dxpzs decimal(12,0) null, wtpzs decimal(12,0) null, wtkce decimal(12,2) null, wxkce decimal(12,2) null, dxkce decimal(12,2) null, zzts decimal(12,0) null, jcbl decimal(12,2) null, zzbhsxse decimal(12,2) null, zzmle decimal(12,2) null go alter table spzdjh add shl smallint null go /*自动补货*/ alter table dgdmx add qrsl decimal(12,3) null go alter table spzd add bhxs decimal(10,3) null go alter table spzdmx add bhxs decimal(10,3) null go alter table spzd add dhl decimal(10,3) null go alter table spzdmx add dhl decimal(10,3) null go alter table gyszd add ztts int null go alter table gyszd add dhzq int null go alter table gyszd add ddcs int null go alter table gyszd add zhdhrq smalldatetime null go alter table bhdmx add ztsl decimal(12,3) null, qyzxl decimal(12,3) null, pjxl decimal(12,3) null go alter table jgysdmx add cfxs decimal(12,3) null go alter table jgysd add djlx char(1) null,spbh char(6) null,cfsl decimal(12,3) null, bhsjj decimal(12,4) null go alter table jggyd add djlx char(1) null go alter table yxsjh add jhwds int null, sjwds int null, jhkce decimal(12, 2) null, jhzdxse decimal(12, 2) null, jhzzts smallint null, sjzzts smallint null, bmbh char(2) null go alter table nxsjh add jhzdxse decimal(12, 2) null, bmbh char(2) null go alter table xzzd add yxbbh char(4) null, zdxse decimal(12,2) null go alter table xsmxb add lxbh char(6) null, xsdbgh char(6) null, qydbgh char(6) null, npbj char(1) null go alter table bmzd add zdxse decimal(12,2) null go alter table ygzd add bz char(50) null go alter table rkdmx add shlx smallint null go alter table rkdmx add jxshl smallint null go alter table rkdmxtemp add shlx smallint null go alter table rkdmxtemp add jxshl smallint null go alter table thdmx add shlx smallint null go alter table thdmx add jxshl smallint null go alter table dgdmx add shlx smallint null go alter table dgdmx add jxshl smallint null go alter table thtzdmx add shlx smallint null go alter table thtzdmx add jxshl smallint null go alter table spzdjh add spfl char(1) null go alter table dgd add rkrq smalldatetime null go alter table dgd_bak add rkrq smalldatetime null go alter table dgdmx_bak add qrsl decimal(12,3) null go alter table dgdmx_bak add shlx smallint null go alter table dgdmx_bak add jxshl smallint null go alter table spzdjh add status char(1) null go alter table sprb add bdbj char(1) null go alter table sprbtemp add bdbj char(1) null go alter table pfdmx add cbj decimal(12,4) null go alter table pfdmx add yhl decimal(12,2) null go alter table pcbfk add bmbh char(2) null go alter table pcbfk add xzbh char(5) null go alter table pcbfk add zgbh char(6) null go alter table pcbfk add fsbj char(1) null go alter table spzdmxkc add jhbzl int null go alter table sprbtempkc add zxj decimal(12,4) null go alter table sprbtempkc add zhjj decimal(12,4) null go alter table sptm add tmxz char(1) null,bzl smallint null go alter table khspdjd add fsbj char(1) null go alter table khspdjd add fsrq smalldatetime null go alter table khspdjd add bz varchar(50) null go alter table spcgdjd add bz varchar(50) null go alter table spcgdjd add fsrq smalldatetime null go alter table xsdmxtemp add ddh char(13) null go alter table xsdmxtemp add dzrq smalldatetime null, fdbh char(3) null go alter table xsdmxtemp add gysbh char(6) null go alter table xsdmxtemp add dfckbh char(3) null go alter table dgdmxtemp add xsxs decimal(12,4) null go alter table spkc add lsj decimal(12,4) null go alter table spkc add ylsl decimal(12,3) null go alter table khspdjdmx add jylsj decimal(12,4) null go alter table zbsjjsqd add jsbj char(1) null go alter table dgdmxtemp add xsxs decimal(12,6) null go alter table rkd add bj char(1) null go alter table xsd add bj char(1) null go alter table xsd add fsbj char(1) null go alter table xsd add gysbh char(6) null go alter table rkdmx add cbe decimal(12,2) null go alter table xsdmx add cbe decimal(12,2) null go alter table psd add bj char(1) null go alter table psdmx add cbe decimal(12,2) null go alter table yktxfls add xh smallint null go alter table yktxfls add jh char(4) null go alter table yktxfls add fsbj char(1) null go alter table hykjkls add ye decimal(12,2) null go alter table hykjkls add fsbj char(1) null go alter table hykzd add zjje decimal(12,2) null go alter table hykzd add rhfs smallint null go alter table hykjkls add rhfs smallint null go alter table hykjkls add hylx smallint null go alter table hykzd add sye decimal(12,2) null go alter table yxsjh add nxsjh decimal(12,2) null go alter table yxsjh add nmljh decimal(12,2) null go alter table zxsjh add yjhxse decimal(12,2) null go alter table zxsjh add ysjxse decimal(12,2) null go alter table zxsjh add ytqxse decimal(12,2) null go alter table zxsjh add yjhmle decimal(12,2) null go alter table zxsjh add ysjmle decimal(12,2) null go alter table zxsjh add ytqmle decimal(12,2) null go alter table yktxfls add djlx char(1) null go alter table spsdbb add mle decimal(12,2) null go alter table spsdbbgk add mle decimal(12,2) null go alter table spsdbbbm add mle decimal(12,2) null go alter table spsdbbdl add mle decimal(12,2) null go alter table spsdbbzl add mle decimal(12,2) null go alter table spsdbbtemp add mle decimal(12,2) null go alter table spsdbbdltemp add mle decimal(12,2) null go alter table spsdbbzltemp add mle decimal(12,2) null go alter table spsdbbgktemp add mle decimal(12,2) null go alter table spsdbbbmtemp add mle decimal(12,2) null go alter table spsdbb add bhsxse decimal(12,2) null go alter table spsdbbgk add bhsxse decimal(12,2) null go alter table spsdbbbm add bhsxse decimal(12,2) null go alter table spsdbbdl add bhsxse decimal(12,2) null go alter table spsdbbzl add bhsxse decimal(12,2) null go alter table spsdbbtemp add bhsxse decimal(12,2) null go alter table spsdbbdltemp add bhsxse decimal(12,2) null go alter table spsdbbzltemp add bhsxse decimal(12,2) null go alter table spsdbbgktemp add bhsxse decimal(12,2) null go alter table spsdbbbmtemp add bhsxse decimal(12,2) null go alter table spxsrb add bhsxse decimal(12,2) null go alter table spxsrb add mle decimal(12,2) null go alter table xlzd add jypzs smallint null,zymjs smallint null go alter table khyskbjs add ckbh char(3) null go alter table khyskb add ckbh char(3) null go alter table khjsdmx add ckbh char(3) null go alter table khfk add ckbh char(3) null go alter table khpjtz add ckbh char(3) null go alter table dlyskjsb add ckbh char(3) null go alter table bmyskjsb add ckbh char(3) null go alter table bmxhrb add ckbh char(3) null go alter table dlxhrb add ckbh char(3) null go alter table xlzdmx add jlbj char(1) null,jypzs smallint null,zymjs smallint null go alter table bmzd add jhmll smallint null go alter table xzzd add jhmll smallint null go alter table xsthd add fsbj char(1) null go alter table pcbfk add fsbj char(1) null go alter table pcbfkfb add fsbj char(1) null go alter table gysyfkb add fsbj char(1) null go alter table spsdbbgk add mle decimal(12,2) null,bhsxse decimal(12,2) null go alter table spsdbb add mle decimal(12,2) null,bhsxse decimal(12,2) null go alter table spsdbbdl add mle decimal(12,2) null,bhsxse decimal(12,2) null go alter table spsdbbzl add mle decimal(12,2) null,bhsxse decimal(12,2) null go alter table spsdbbbm add mle decimal(12,2) null,bhsxse decimal(12,2) null go alter table spsdbbxp add mle decimal(12,2) null,bhsxse decimal(12,2) null go alter table spzd add psbzl2 smallint null go alter table spzdmx add psbzl2 smallint null go alter table spjxb add pjxl decimal(12,3) null go alter table khyskb add bcbj char(1) null go alter table khyskbjs add jh char(4) null go alter table sprbtemp add zgbh char(6) null,kl decimal(5,2) null,shl smallint null go alter table txxxb add rbkce decimal(12,2) null,pcbkce decimal(12,2) null go alter table spzdmx add spfl char(1) null go alter table psd add sxrq smalldatetime null go alter table spkcrb add brmle decimal(12,2) null,status char(1) null,rdrq smalldatetime null, zhrkrq smalldatetime null,zhxsrq smalldatetime null,zhwlrq smalldatetime null,zhdhrq smalldatetime null, cxmbl decimal(12,2) null,jhzzts decimal(12,2) null go alter table thtzdmx add sssl decimal(12,3) null go alter table csdmx add sssl decimal(12,3) null go alter table psthd add bz2 varchar(50) null go alter table psthd add ysgysbh char(6) null go alter table thtzd add bz2 varchar(50) null go alter table thtzd add ysgysbh char(6) null go alter table psdmx add jxshl smallint null go alter table psdmx add shlx smallint null go alter table psdmx add djlx char(1) null go alter table yyyrbtemp add gysbh char(6) null go alter table yyyrb add gysbh char(6) null go alter table psdmx add djxz char(1) null go alter table rkdmx add ysr char(6) null go alter table xsdmxtemp add ysr char(6) null go alter table xsdmxtemp add zcdh char(15) null go alter table xsdmxtemp add fhdh char(13) null go alter table xsdmxtemp add sssltz decimal(12,3) null go alter table xsdmxtemp add fsbj char(1) null go insert into sjcdqd (dataname,dataobject,tablename,discolname,filename,zbdatawindow ,mxdatawindow,autofs,bj) values('内部采购单','dw_selectcgd_fs','cgd','cgdh','cgd','dw_cgd_main_fs','dw_cgd_mx_fs','1','0') go insert into sjcdqd (dataname,dataobject,tablename,discolname,filename,zbdatawindow ,mxdatawindow,autofs,bj) values('团购单','dw_selectpfd_fs','pfd','pfdh','pfd','dw_pfd_main_fs','dw_pfd_mx_fs','1','0') go insert into sjcdqd (dataname,dataobject,tablename,discolname,filename,zbdatawindow ,mxdatawindow,autofs,bj) values('损溢单','dw_selectcsd_fs','csd','csdh','csd','dw_csd_main_fs','dw_csd_mx_fs','1','0') go alter table csd add fsbj char(1) null go alter table pfd add fsbj char(1) null go alter table cgd add fsbj char(1) null go alter table spycb add gysbh char(6) null go alter table gyszd add czkl decimal(6,2) null go alter table spcgdjd add npdh char(13) null go alter table spcgdjd add bj char(1) null go alter table khspdjd add bj char(1) null go alter table temp_spkc add zhjj decimal(12,4) null go alter table rkd add dybj char(1) null go alter table khspdjd add ksrq smalldatetime null,jsrq smalldatetime null go alter table psthdmx add hsthj decimal(12,4) null,shl smallint null go alter table spdhzq add dhzq smallint null go alter table bjdmx add yyhl decimal(5,2) null go alter table bjdmx add xyhl decimal(5,2) null go alter table bjdmx add yjfbj char(1) null go alter table bjdmx add xjfbj char(1) null go alter table xzdjspb add jfbj char(1) null go alter table hykzd add zkbj char(1) null,mkh char(20) null go alter table hylx add dqrq smalldatetime null go alter table spcgjg add zxr char(6) null go alter table fdzd add status char(1) null go drop table gysyfkyejchz go create table gysyfkyejchz(rq smalldatetime null,fdbh char(3) null,fdmc char(30) null,gysbh char(6) not null, gysfkye decimal(12,2) null, gysyfkbye decimal(12,2) null, pcbfkye decimal(12,2) null, jsfsbh char(2) null,gysmc char(60) null) go alter table spkcjc add rq smalldatetime null,fdmc char(30) null,spqc char(60) null go /****2009-12-15lzj修改 alter table spyb add bmbh char(2) not null default '00',xzbh char(5) not null, default '00000', dlbh char(2) not null default '00',zlbh char(4) not null default '0000',xlbh char(6) not null default '000000', ppbh char(6) not null default '000000',jxfsbh char(2) not null default '00',zgbh char(6) not null default '000000',kl decimal(5,2) not null default 0,shl smallint not null default 17 go alter table sprb add zgbh char(6) null,kl decimal(5,2) not null default 0 ,shl smallint go */ alter table spyb add bmbh char(2) null ,xzbh char(5) null, dlbh char(2) null ,zlbh char(4) null ,xlbh char(6) null , ppbh char(6) null ,jxfsbh char(2) null ,zgbh char(6) null ,kl decimal(5,2) null ,shl smallint null go alter table sprb add zgbh char(6) null,kl decimal(5,2) null ,shl smallint null go alter table xsd add jsdh char(13) null go alter table xsd add shl smallint null go alter table xsd cbe decimal(12,2) null go alter table xsd gysbh char(6) null go go alter table xsdmx add psbzl smallint null go alter table dlzd add status char(1) null go alter table zlzd add status char(1) null go alter table xlzd add status char(1) null go alter table khzd add bzdj char(1) null go alter table npdbcs add bs smallint null go alter table spkcgys add status char(1) NULL go alter table spkcgys add gysbh char(6) NULL go /****** 对象: Table [dbo].[spqhhzb] 脚本日期: 06/06/2009 13:49:34 ******/ /***2009-12-15lzj修改 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO drop table spqhhzb go CREATE TABLE [dbo].[spqhhzb]( [rq] [smalldatetime] NOT NULL, [fdbh] [char](3) COLLATE Chinese_PRC_CI_AS NOT NULL, [lbbh] [char](6) COLLATE Chinese_PRC_CI_AS NOT NULL, [xzbh] [char](5) COLLATE Chinese_PRC_CI_AS NOT NULL, [fdmc] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [lbmc] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [pzzsa] [decimal](12, 2) NULL, [qhpzsa] [decimal](12, 2) NULL, [qhla] [decimal](12, 2) NULL, [pzzsb] [decimal](12, 2) NULL, [qhpzsb] [decimal](12, 2) NULL, [qhlb] [decimal](12, 2) NULL, [cxpzs] [decimal](12, 2) NULL, [qhpzscx] [decimal](12, 2) NULL, [qhlcx] [decimal](12, 2) NULL, CONSTRAINT [pk_spqhhzb] PRIMARY KEY NONCLUSTERED ( [rq] ASC, [fdbh] ASC, [lbbh] ASC, [xzbh] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spjjqhmx]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[spjjqhmx]( [spbh] [char](6) NOT NULL, [brxss] [decimal](12, 3) NULL, [pjxss] [decimal](12, 3) NULL, [dhzq] [int] NULL, [jxfsbh] [char](2) NULL, [gysbh] [char](6) NULL, [ztsl] [decimal](12, 3) NULL, [kcsl] [decimal](12, 3) NULL, [zrxss] [decimal](12, 3) NULL, [fdbh] [char](3) NULL, [dlbh] [char](2) NULL ) ON [PRIMARY] END go */ alter table jjbddmx add jxshl smallint null go alter table jjbddmx add shlx smallint null go alter table xsdmx add shlx smallint null go alter table spxscxb add cxksrq smalldatetime null go alter table spxscxb add cxjsrq smalldatetime null go alter table spjjqhmx add lx char(1) null go alter table spyb add bmbh char(2) null go alter table spyb add xzbh char(5) null go alter table spyb add dlbh char(2) null go alter table spyb add zlbh char(4) null go alter table spyb add xlbh char(6) null go alter table spyb add jsfsbh char(2) null go alter table spyb add ppbh char(6) null go alter table spyb add zgbh char(6) null go alter table spyb add kl decimal(5,2) null go alter table spyb add shl smallint null go alter table xsmxb add gjs decimal(12,3) null go alter table xsmxb add gje decimal(12,2) null go alter table xsmxb add ckbh char(3) null go alter table fdzd add jhzzts smallint null go alter table spqhhzb add xzbh char(5) null go alter table pfdmx add hsjj decimal(12,2) null go alter table pfdmx add thdzs smallint null,thdsl decimal(12,3) null go alter table pfd add shfs char(1) NULL, shrq datetime NULL, thdfs smallint NULL go alter table pfd add qybh char(6) NULL, xqmc varchar(50) NULL, lch varchar(10) NULL, dyh varchar(10) NULL, fjh varchar(10) NULL go alter table dgd add ddly char(1) null,sxrq smalldatetime null go alter table bhd add ddly char(1) null go alter table xsd add ddly char(1) null go alter table xsdmx add hsdj decimal(12,4) null go alter table psd add ddly char(1) null go alter table dgd_bak add ddly char(1) null go alter table dgd add npdh char(13) null go alter table dgdmx add xsj decimal(12,4) null go alter table bhdmx add khbh char(13) null,fdbh char(3) null,rq smalldatetime null,gysbh char(6) null go alter table bhdmx add ckbh char(3) null go alter table dgdmx add xsj decimal(12,4) null go alter table bhdmx add fdgysbh char(6) null go alter table bhdmx add hth char(18) null go alter table dgdtemp add ddly char(1) null go alter table fdrb add brhyxse decimal(12,2) null go alter table fdyb add byhyxse decimal(12,2) null go alter table fdnb add bnhyxse decimal(12,2) null go alter table xlrb add brhyxse decimal(12,2) null go alter table xlyb add byhyxse decimal(12,2) null go alter table xlnb add bnhyxse decimal(12,2) null go alter table spzdmxkc add cgj decimal(12,4) null go alter table npdbcs add fdkce decimal(12,2) null go alter table npdbcs add pskce decimal(12,2) null go CREATE TABLE dbo.hykzdtemp (khid int NOT NULL, hyid int NULL, kh varchar(20) NULL, jmkh varchar(40) NULL, csmm char(10) NULL, fkr char(6) NULL, fkrq datetime NULL, zxr char(6) NULL, zxrq datetime NULL, sxrq datetime NULL, syzt tinyint NULL, lxid tinyint NULL, ye money NULL, xfe money NULL, yhe money NULL, jf decimal(12,2) NULL, rhfs smallint NULL, ljjf decimal(12,2) NULL, zhxgrq datetime NULL, ykh varchar(20) NULL, sye money NULL, zjje decimal(12,2) NULL, zkbj char(1) NULL, mkh char(20) NULL, oldykh varchar(20) NULL , CONSTRAINT PK_hykzdtemp PRIMARY KEY CLUSTERED (khid)) ...展开收缩

(系统自动生成,下载前可以参看下载内容)