saleshouse

于 2013-03-25 15:20:15 发布
阅读量147 收藏
点赞数
--[dtproperties];
if exists (select 1 from sysobjects where id = object_id(N'[dtproperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dtproperties];
CREATE TABLE [dtproperties] (
      [id] int IDENTITY(1, 1) NOT NULL,
      [objectid] int NULL,
      [property] varchar(64) NOT NULL,
      [value] varchar(255) NULL,
      [uvalue] nvarchar(255) NULL,
      [lvalue] image NULL,
      [version] int default 0 NOT NULL);
ALTER TABLE [dtproperties] WITH NOCHECK ADD CONSTRAINT [pk_dtproperties] PRIMARY KEY  CLUSTERED ([id],[property])  ON [PRIMARY];
--[sys_authority];
if exists (select 1 from sysobjects where id = object_id(N'[sys_authority]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_authority];
CREATE TABLE [sys_authority] (
      [authorityid] int IDENTITY(1, 1) NOT NULL,
      [type] nvarchar(50) NULL,
      [code] nvarchar(50) NULL,
      [text] nvarchar(50) NULL,
      [fid] nvarchar(50) NULL,
      [fcode] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_authority] WITH NOCHECK ADD CONSTRAINT [PK_sys_authority] PRIMARY KEY  CLUSTERED ([authorityid])  ON [PRIMARY];
--[sys_defaultauthority];
if exists (select 1 from sysobjects where id = object_id(N'[sys_defaultauthority]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_defaultauthority];
CREATE TABLE [sys_defaultauthority] (
      [defauthorityid] int IDENTITY(1, 1) NOT NULL,
      [type] nvarchar(50) NULL,
      [code] nvarchar(50) NULL,
      [text] nvarchar(50) NULL,
      [fid] nvarchar(50) NULL,
      [fcode] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_defaultauthority] WITH NOCHECK ADD CONSTRAINT [PK_sys_defaultauthority] PRIMARY KEY  CLUSTERED ([defauthorityid])  ON [PRIMARY];
--[sys_FastReportAuthority];
if exists (select 1 from sysobjects where id = object_id(N'[sys_FastReportAuthority]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_FastReportAuthority];
CREATE TABLE [sys_FastReportAuthority] (
      [fastauthorityid] int IDENTITY(1, 1) NOT NULL,
      [type] nvarchar(50) NULL,
      [code] nvarchar(50) NULL,
      [text] nvarchar(50) NULL,
      [fid] nvarchar(50) NULL,
      [fcode] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_FastReportAuthority] WITH NOCHECK ADD CONSTRAINT [PK_sys_baobiao] PRIMARY KEY  CLUSTERED ([fastauthorityid])  ON [PRIMARY];
--[sys_GridControlLayout];
if exists (select 1 from sysobjects where id = object_id(N'[sys_GridControlLayout]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_GridControlLayout];
CREATE TABLE [sys_GridControlLayout] (
      [gclid] int IDENTITY(1, 1) NOT NULL,
      [gridname] nvarchar(50) NULL,
      [layout] image NULL,
      [formname] nvarchar(50) NULL,
      [userid] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_GridControlLayout] WITH NOCHECK ADD CONSTRAINT [PK_sys_GridControlLayout] PRIMARY KEY  CLUSTERED ([gclid])  ON [PRIMARY];
--[sys_log];
if exists (select 1 from sysobjects where id = object_id(N'[sys_log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_log];
CREATE TABLE [sys_log] (
      [logid] int IDENTITY(1, 1) NOT NULL,
      [username] nvarchar(200) NULL,
      [operate] nvarchar(200) NULL,
      [formtext] nvarchar(50) NULL,
      [mode] nvarchar(200) NULL,
      [otime] datetime default getdate() NULL,
      [oip] nvarchar(50) NULL);
ALTER TABLE [sys_log] WITH NOCHECK ADD CONSTRAINT [PK_sys_log] PRIMARY KEY  CLUSTERED ([logid])  ON [PRIMARY];
--[sys_NavBar];
if exists (select 1 from sysobjects where id = object_id(N'[sys_NavBar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_NavBar];
CREATE TABLE [sys_NavBar] (
      [keyid] nvarchar(50) NOT NULL,
      [pkey] nvarchar(50) NULL,
      [types] nvarchar(50) NULL,
      [imagelist] nvarchar(50) NULL,
      [bname] nvarchar(50) NULL,
      [btag] nvarchar(50) NULL,
      [btooltip] nvarchar(50) NULL,
      [btext] nvarchar(50) NULL,
      [imageindex] int NULL,
      [imagename] nvarchar(50) NULL,
      [largeImage] int NULL,
      [smallImage] int NULL,
      [dllname] nvarchar(50) NULL,
      [openform] nvarchar(50) NULL,
      [remark] nvarchar(50) NULL,
      [tb_type] int default 1 NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL);
ALTER TABLE [sys_NavBar] WITH NOCHECK ADD CONSTRAINT [PK_Sys_NavBar] PRIMARY KEY  CLUSTERED ([keyid])  ON [PRIMARY];
--[sys_role];
if exists (select 1 from sysobjects where id = object_id(N'[sys_role]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_role];
CREATE TABLE [sys_role] (
      [roleid] int IDENTITY(1, 1) NOT NULL,
      [name] nvarchar(50) NULL,
      [code] nvarchar(50) NULL,
      [remark] nvarchar(50) NULL,
      [rtype] int NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_role] WITH NOCHECK ADD CONSTRAINT [PK_sys_role] PRIMARY KEY  CLUSTERED ([roleid])  ON [PRIMARY];
--[sys_rolepvauthority];
if exists (select 1 from sysobjects where id = object_id(N'[sys_rolepvauthority]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_rolepvauthority];
CREATE TABLE [sys_rolepvauthority] (
      [rvt_id] int IDENTITY(1, 1) NOT NULL,
      [authorityid] int NULL,
      [pvid] int NULL,
      [types] int NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_rolepvauthority] WITH NOCHECK ADD CONSTRAINT [PK_sys_rolepvauthority] PRIMARY KEY  CLUSTERED ([rvt_id])  ON [PRIMARY];
--[sys_rolepvdefaultau];
if exists (select 1 from sysobjects where id = object_id(N'[sys_rolepvdefaultau]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_rolepvdefaultau];
CREATE TABLE [sys_rolepvdefaultau] (
      [rvt_id] int IDENTITY(1, 1) NOT NULL,
      [defauthorityid] int NULL,
      [pvid] int NULL,
      [types] int NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_rolepvdefaultau] WITH NOCHECK ADD CONSTRAINT [PK_sys_rolepvdefaultau] PRIMARY KEY  CLUSTERED ([rvt_id])  ON [PRIMARY];
--[sys_rolepvFastReport];
if exists (select 1 from sysobjects where id = object_id(N'[sys_rolepvFastReport]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_rolepvFastReport];
CREATE TABLE [sys_rolepvFastReport] (
      [rvt_id] int IDENTITY(1, 1) NOT NULL,
      [fastauthorityid] int NULL,
      [pvid] int NULL,
      [types] int NULL,
      [proid] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_rolepvFastReport] WITH NOCHECK ADD CONSTRAINT [PK_sys_rolepvbaobiao] PRIMARY KEY  CLUSTERED ([rvt_id])  ON [PRIMARY];
--[sys_Settings];
if exists (select 1 from sysobjects where id = object_id(N'[sys_Settings]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_Settings];
CREATE TABLE [sys_Settings] (
      [setid] int IDENTITY(1, 1) NOT NULL,
      [items] nvarchar(50) NULL,
      [setvalue] nvarchar(50) NULL,
      [remark] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_Settings] WITH NOCHECK ADD CONSTRAINT [PK_sys_Settings] PRIMARY KEY  CLUSTERED ([setid])  ON [PRIMARY];
--[sys_user];
if exists (select 1 from sysobjects where id = object_id(N'[sys_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_user];
CREATE TABLE [sys_user] (
      [userid] int IDENTITY(1, 1) NOT NULL,
      [account] nvarchar(50) NULL,
      [code] nvarchar(50) NULL,
      [name] nvarchar(50) NULL,
      [pwd] nvarchar(50) NULL,
      [percode] nvarchar(50) NULL,
      [usermenu] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL,
      [zname] nvarchar(50) NULL,
      [ztell] nvarchar(50) NULL,
      [zbeizhu] nvarchar(50) NULL,
      [zlouzuo] nvarchar(200) NULL);
ALTER TABLE [sys_user] WITH NOCHECK ADD CONSTRAINT [PK_sys_user] PRIMARY KEY  CLUSTERED ([userid])  ON [PRIMARY];
--[sys_userpvrole];
if exists (select 1 from sysobjects where id = object_id(N'[sys_userpvrole]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [sys_userpvrole];
CREATE TABLE [sys_userpvrole] (
      [upvr_id] int IDENTITY(1, 1) NOT NULL,
      [userid] int NULL,
      [roleid] int NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [sys_userpvrole] WITH NOCHECK ADD CONSTRAINT [PK_sys_userpvrole] PRIMARY KEY  CLUSTERED ([upvr_id])  ON [PRIMARY];
--[tb_aaa];
if exists (select 1 from sysobjects where id = object_id(N'[tb_aaa]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [tb_aaa];
CREATE TABLE [tb_aaa] (
      [fid] int IDENTITY(1, 1) NOT NULL,
      [fname] nvarchar(50) NULL,
      [lid] int NULL,
      [fcode] nvarchar(50) NULL,
      [lounum] int NULL,
      [dannum] int NULL,
      [fangnum] int NULL,
      [huxing] nvarchar(50) NULL,
      [beizhu] nvarchar(200) NULL,
      [xstype] nvarchar(50) NULL,
      [mianji] numeric(18, 2) NULL,
      [sjmianji] numeric(18, 2) NULL,
      [htdanjia] numeric(18, 2) NULL,
      [zxdanjia] numeric(18, 2) NULL,
      [cedanjia] numeric(18, 2) NULL,
      [kehuxingming] nchar(10) NULL,
      [cid] int NULL,
      [ccode] nvarchar(50) NULL,
      [xstime] datetime NULL,
      [xsyuan] nvarchar(50) NULL,
      [caozuoren] nvarchar(50) NULL,
      [czrid] int NULL,
      [shenpitime] datetime NULL,
      [sprid] int NULL,
      [shenpiren] nvarchar(50) NULL,
      [addtime] datetime NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [istui] int NULL,
      [tb_type] int NULL,
      [fxingzhi] nvarchar(50) NULL,
      [htze] numeric(18, 2) NULL,
      [rzmj] numeric(18, 2) NULL,
      [tuitime] datetime NULL,
      [tuipzh] nvarchar(50) NULL);
--[tb_bbb];
if exists (select 1 from sysobjects where id = object_id(N'[tb_bbb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [tb_bbb];
CREATE TABLE [tb_bbb] (
      [fid] int IDENTITY(1, 1) NOT NULL,
      [fname] nvarchar(50) NULL,
      [lid] int NULL,
      [fcode] nvarchar(50) NULL,
      [lounum] int NULL,
      [dannum] int NULL,
      [fangnum] int NULL,
      [huxing] nvarchar(50) NULL,
      [beizhu] nvarchar(200) NULL,
      [xstype] nvarchar(50) NULL,
      [mianji] numeric(18, 2) NULL,
      [sjmianji] numeric(18, 2) NULL,
      [htdanjia] numeric(18, 2) NULL,
      [zxdanjia] numeric(18, 2) NULL,
      [cedanjia] numeric(18, 2) NULL,
      [kehuxingming] nchar(10) NULL,
      [cid] int NULL,
      [ccode] nvarchar(50) NULL,
      [xstime] datetime NULL,
      [xsyuan] nvarchar(50) NULL,
      [caozuoren] nvarchar(50) NULL,
      [czrid] int NULL,
      [shenpitime] datetime NULL,
      [sprid] int NULL,
      [shenpiren] nvarchar(50) NULL,
      [addtime] datetime NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [istui] int NULL,
      [tb_type] int NULL,
      [fxingzhi] nvarchar(50) NULL,
      [htze] numeric(18, 2) NULL,
      [rzmj] numeric(18, 2) NULL,
      [tuitime] datetime NULL,
      [tuipzh] nvarchar(50) NULL);
--[tb_c];
if exists (select 1 from sysobjects where id = object_id(N'[tb_c]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [tb_c];
CREATE TABLE [tb_c] (
      [cwid] float NULL,
      [cheweihao] nvarchar(255) NULL,
      [fcode] nvarchar(255) NULL,
      [fid] nvarchar(255) NULL,
      [cid] nvarchar(255) NULL,
      [cheweiname] nvarchar(255) NULL,
      [lid] float NULL,
      [lname] nvarchar(255) NULL,
      [jiage] float NULL,
      [xieyihao] nvarchar(255) NULL,
      [xieyitime] nvarchar(255) NULL,
      [xiaoshou] nvarchar(255) NULL,
      [tiyong] nvarchar(255) NULL,
      [shenheren] nvarchar(255) NULL,
      [shenpitime] nvarchar(255) NULL,
      [beizhu] nvarchar(255) NULL,
      [addtime] nvarchar(255) NULL,
      [adduser] nvarchar(255) NULL,
      [lasttime] nvarchar(255) NULL,
      [lastuser] nvarchar(255) NULL,
      [istui] nvarchar(255) NULL,
      [tb_type] nvarchar(255) NULL);
--[TB_chewei];
if exists (select 1 from sysobjects where id = object_id(N'[TB_chewei]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_chewei];
CREATE TABLE [TB_chewei] (
      [cwid] int IDENTITY(1, 1) NOT NULL,
      [cheweihao] nvarchar(50) NULL,
      [fcode] nvarchar(50) NULL,
      [fid] int NULL,
      [cid] int NULL,
      [cheweiname] nvarchar(50) NULL,
      [lid] int NULL,
      [lname] nvarchar(50) NULL,
      [jiage] numeric(18, 2) NULL,
      [xieyihao] nvarchar(50) NULL,
      [xieyitime] datetime NULL,
      [xiaoshou] nvarchar(50) NULL,
      [tiyong] datetime NULL,
      [shenheren] nvarchar(50) NULL,
      [shenpitime] datetime NULL,
      [beizhu] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [istui] int default 0 NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [TB_chewei] WITH NOCHECK ADD CONSTRAINT [PK_TB_chewei] PRIMARY KEY  CLUSTERED ([cwid])  ON [PRIMARY];
--[tb_d];
if exists (select 1 from sysobjects where id = object_id(N'[tb_d]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [tb_d];
CREATE TABLE [tb_d] (
      [sid] float NULL,
      [stime] datetime NULL,
      [scode] nvarchar(255) NULL,
      [sjine] float NULL,
      [sjcode] nvarchar(255) NULL,
      [skfangshi] nvarchar(255) NULL,
      [skxiangmu] nvarchar(255) NULL,
      [fcode] nvarchar(255) NULL,
      [fid] nvarchar(255) NULL,
      [lid] float NULL,
      [shenpitime] nvarchar(255) NULL,
      [shenpiren] nvarchar(255) NULL,
      [beizhu] nvarchar(255) NULL,
      [addtime] nvarchar(255) NULL,
      [adduser] nvarchar(255) NULL,
      [lasttime] nvarchar(255) NULL,
      [lastuser] nvarchar(255) NULL,
      [istui] nvarchar(255) NULL,
      [tb_type] nvarchar(255) NULL,
      [isru] nvarchar(255) NULL,
      [rtime] nvarchar(255) NULL,
      [ruser] nvarchar(255) NULL,
      [rbeizhu] nvarchar(255) NULL,
      [pingzheng] nvarchar(255) NULL);
--[tb_e];
if exists (select 1 from sysobjects where id = object_id(N'[tb_e]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [tb_e];
CREATE TABLE [tb_e] (
      [sid] float NULL,
      [stime] datetime NULL,
      [scode] nvarchar(255) NULL,
      [sjine] float NULL,
      [sjcode] nvarchar(255) NULL,
      [skfangshi] nvarchar(255) NULL,
      [skxiangmu] nvarchar(255) NULL,
      [fid2] nvarchar(255) NULL,
      [lid] float NULL,
      [shenpitime] nvarchar(255) NULL,
      [shenpiren] nvarchar(255) NULL,
      [beizhu] nvarchar(255) NULL,
      [addtime] nvarchar(255) NULL,
      [adduser] nvarchar(255) NULL,
      [lasttime] nvarchar(255) NULL,
      [lastuser] nvarchar(255) NULL,
      [istui] nvarchar(255) NULL,
      [tb_type] nvarchar(255) NULL,
      [isru] nvarchar(255) NULL,
      [rtime] nvarchar(255) NULL,
      [ruser] nvarchar(255) NULL,
      [rbeizhu] nvarchar(255) NULL,
      [pingzheng] nvarchar(255) NULL,
      [fid] nvarchar(255) NULL);
--[TB_fangjian];
if exists (select 1 from sysobjects where id = object_id(N'[TB_fangjian]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_fangjian];
CREATE TABLE [TB_fangjian] (
      [fid] int IDENTITY(1, 1) NOT NULL,
      [fname] nvarchar(50) NULL,
      [lid] int NULL,
      [fcode] nvarchar(50) NULL,
      [lounum] int NULL,
      [dannum] int NULL,
      [fangnum] int NULL,
      [huxing] nvarchar(50) NULL,
      [beizhu] nvarchar(200) NULL,
      [xstype] nvarchar(50) NULL,
      [mianji] numeric(18, 2) NULL,
      [sjmianji] numeric(18, 2) NULL,
      [htdanjia] numeric(18, 2) NULL,
      [zxdanjia] numeric(18, 2) NULL,
      [cedanjia] numeric(18, 2) NULL,
      [kehuxingming] nchar(10) NULL,
      [cid] int NULL,
      [ccode] nvarchar(50) NULL,
      [xstime] datetime NULL,
      [xsyuan] nvarchar(50) NULL,
      [caozuoren] nvarchar(50) NULL,
      [czrid] int NULL,
      [shenpitime] datetime NULL,
      [sprid] int NULL,
      [shenpiren] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime default getdate() NULL,
      [lastuser] nvarchar(50) NULL,
      [istui] int default 0 NULL,
      [tb_type] int default 1 NULL,
      [fxingzhi] nvarchar(50) NULL,
      [htze] numeric(18, 2) default 0 NULL,
      [rzmj] numeric(18, 2) default 0 NULL,
      [tuitime] datetime NULL,
      [tuipzh] nvarchar(50) NULL);
ALTER TABLE [TB_fangjian] WITH NOCHECK ADD CONSTRAINT [PK_TB_fangjian] PRIMARY KEY  CLUSTERED ([fid])  ON [PRIMARY];
--[TB_fukuanjihua];
if exists (select 1 from sysobjects where id = object_id(N'[TB_fukuanjihua]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_fukuanjihua];
CREATE TABLE [TB_fukuanjihua] (
      [fkid] int IDENTITY(1, 1) NOT NULL,
      [cishu] nvarchar(50) NULL,
      [shijian] nvarchar(50) NULL,
      [jine] numeric(18, 2) NULL,
      [fid] int NULL,
      [beizhu] nvarchar(50) NULL,
      [ci] int NULL,
      [fkfs] nvarchar(50) NULL);
--[tb_h];
if exists (select 1 from sysobjects where id = object_id(N'[tb_h]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [tb_h];
CREATE TABLE [tb_h] (
      [sid] float NULL,
      [stime] datetime NULL,
      [scode] nvarchar(255) NULL,
      [sjine] float NULL,
      [sjcode] nvarchar(255) NULL,
      [skfangshi] nvarchar(255) NULL,
      [skxiangmu] nvarchar(255) NULL,
      [fcode] nvarchar(255) NULL,
      [fid] nvarchar(255) NULL,
      [lid] float NULL,
      [shenpitime] nvarchar(255) NULL,
      [shenpiren] nvarchar(255) NULL,
      [beizhu] nvarchar(255) NULL,
      [addtime] nvarchar(255) NULL,
      [adduser] nvarchar(255) NULL,
      [lasttime] nvarchar(255) NULL,
      [lastuser] nvarchar(255) NULL,
      [istui] nvarchar(255) NULL,
      [tb_type] nvarchar(255) NULL,
      [isru] nvarchar(255) NULL,
      [rtime] nvarchar(255) NULL,
      [ruser] nvarchar(255) NULL,
      [rbeizhu] nvarchar(255) NULL,
      [pingzheng] nvarchar(255) NULL);
--[TB_kehu];
if exists (select 1 from sysobjects where id = object_id(N'[TB_kehu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_kehu];
CREATE TABLE [TB_kehu] (
      [cid] int IDENTITY(1, 1) NOT NULL,
      [kehuxingming] nvarchar(50) NULL,
      [ccode] nvarchar(50) NULL,
      [cbianhao] nvarchar(50) NULL,
      [ctell] nvarchar(50) NULL,
      [cdizhi] nvarchar(50) NULL,
      [cbeizhu] nvarchar(200) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [istui] int default 0 NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [TB_kehu] WITH NOCHECK ADD CONSTRAINT [PK_TB_kehu] PRIMARY KEY  CLUSTERED ([cid])  ON [PRIMARY];
--[TB_loupan];
if exists (select 1 from sysobjects where id = object_id(N'[TB_loupan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_loupan];
CREATE TABLE [TB_loupan] (
      [lid] int IDENTITY(1, 1) NOT NULL,
      [lname] nvarchar(50) NULL,
      [lcode] nvarchar(50) NULL,
      [lpinyin] nvarchar(50) NULL,
      [lbeizhu] nvarchar(200) NULL,
      [ltaoshu] numeric(18, 2) NULL,
      [ztaoshu] numeric(18, 2) NULL,
      [wtaoshu] numeric(18, 2) NULL,
      [btaoshu] numeric(18, 2) NULL,
      [lkeshou] numeric(18, 2) NULL,
      [zkeshou] numeric(18, 2) NULL,
      [wkeshou] numeric(18, 2) NULL,
      [bkeshou] numeric(18, 2) NULL);
ALTER TABLE [TB_loupan] WITH NOCHECK ADD CONSTRAINT [PK_TB_loupan] PRIMARY KEY  CLUSTERED ([lid])  ON [PRIMARY];
--[TB_ruzhang];
if exists (select 1 from sysobjects where id = object_id(N'[TB_ruzhang]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_ruzhang];
CREATE TABLE [TB_ruzhang] (
      [rid] int IDENTITY(1, 1) NOT NULL,
      [rtype] nvarchar(50) NULL,
      [rtime] datetime NULL,
      [ruser] nvarchar(50) NULL,
      [rbeizhu] nvarchar(200) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [fid] int NULL,
      [rshenheren] nvarchar(50) NULL,
      [rshenhetime] datetime NULL,
      [rjine] numeric(18, 2) NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [TB_ruzhang] WITH NOCHECK ADD CONSTRAINT [PK_TB_ruzhang] PRIMARY KEY  CLUSTERED ([rid])  ON [PRIMARY];
--[TB_ruzhang111];
if exists (select 1 from sysobjects where id = object_id(N'[TB_ruzhang111]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_ruzhang111];
CREATE TABLE [TB_ruzhang111] (
      [rid] int NOT NULL,
      [rtype] nvarchar(50) NULL,
      [rtime] datetime NULL,
      [ruser] nvarchar(50) NULL,
      [rbeizhu] nvarchar(200) NULL,
      [addtime] datetime NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [fid] int NULL,
      [rshenheren] nvarchar(50) NULL,
      [rshenhetime] datetime NULL,
      [rjine] decimal(18, 2) NULL,
      [tb_type] int NULL);
--[TB_shoukuan];
if exists (select 1 from sysobjects where id = object_id(N'[TB_shoukuan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_shoukuan];
CREATE TABLE [TB_shoukuan] (
      [sid] int IDENTITY(1, 1) NOT NULL,
      [stime] datetime default getdate() NULL,
      [scode] nvarchar(50) NULL,
      [sjine] numeric(18, 2) NULL,
      [sjcode] nvarchar(50) NULL,
      [skfangshi] nvarchar(50) NULL,
      [skxiangmu] nvarchar(50) NULL,
      [fid] int NULL,
      [lid] int NULL,
      [shenpitime] datetime NULL,
      [shenpiren] nvarchar(50) NULL,
      [beizhu] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [istui] int default 0 NULL,
      [tb_type] int default 1 NULL,
      [isru] int default 0 NULL,
      [rtime] datetime NULL,
      [ruser] nvarchar(50) NULL,
      [rbeizhu] nvarchar(200) NULL,
      [pingzheng] nvarchar(50) NULL,
      [chong] numeric(18, 2) NULL,
      [yname] nvarchar(200) NULL,
      [chtime] datetime NULL,
      [chpzh] nvarchar(50) NULL);
ALTER TABLE [TB_shoukuan] WITH NOCHECK ADD CONSTRAINT [PK_TB_shoukuan] PRIMARY KEY  CLUSTERED ([sid])  ON [PRIMARY];
--[TB_yinhang];
if exists (select 1 from sysobjects where id = object_id(N'[TB_yinhang]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_yinhang];
CREATE TABLE [TB_yinhang] (
      [yid] int IDENTITY(1, 1) NOT NULL,
      [yname] nvarchar(50) NULL,
      [beizhu] nvarchar(50) NULL,
      [dianhua] nvarchar(50) NULL,
      [dizhi] nvarchar(50) NULL,
      [ycode] nvarchar(50) NULL);
--[TB_zhucangshi];
if exists (select 1 from sysobjects where id = object_id(N'[TB_zhucangshi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TB_zhucangshi];
CREATE TABLE [TB_zhucangshi] (
      [zid] int IDENTITY(1, 1) NOT NULL,
      [zbianhao] nvarchar(50) NULL,
      [fid] int NULL,
      [fcode] nvarchar(50) NULL,
      [kehuxingming] nvarchar(50) NULL,
      [zname] nvarchar(50) NULL,
      [zmianji] numeric(18, 2) NULL,
      [zdanjia] numeric(18, 2) NULL,
      [zxieyibianhao] nvarchar(50) NULL,
      [zxieyitime] datetime NULL,
      [zxiaoshou] nvarchar(50) NULL,
      [ztiyongtime] datetime NULL,
      [zshenpiren] nvarchar(50) NULL,
      [zshenpitime] datetime NULL,
      [beizhu] nvarchar(50) NULL,
      [addtime] datetime default getdate() NULL,
      [adduser] nvarchar(50) NULL,
      [lasttime] datetime NULL,
      [lastuser] nvarchar(50) NULL,
      [istui] int default 0 NULL,
      [tb_type] int default 1 NULL);
ALTER TABLE [TB_zhucangshi] WITH NOCHECK ADD CONSTRAINT [PK_TB_zhucangshi] PRIMARY KEY  CLUSTERED ([zid])  ON [PRIMARY];
--[房间统计];
if exists (select 1 from sysobjects where id = object_id(N'[房间统计]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [房间统计];
CREATE TABLE [房间统计] (
      [楼盘] nvarchar(50) NULL,
      [性质] nvarchar(50) NULL,
      [总套数] nvarchar(50) NULL,
      [可售面积] nvarchar(50) NULL,
      [已网签套数] int NULL,
      [已网签面积] numeric(18, 2) NULL,
      [合同总金额] numeric(18, 2) NULL,
      [合同已收款金额] numeric(18, 2) NULL,
      [合同尚欠款金额] numeric(18, 2) NULL,
      [协议套数] int NULL,
      [协议面积] numeric(18, 2) NULL,
      [协议总金额] numeric(18, 2) NULL,
      [协议已收款金额] numeric(18, 2) NULL,
      [协议尚欠款金额] numeric(18, 2) NULL,
      [已售出总套数] int NULL,
      [已售出总面积] numeric(18, 2) NULL,
      [已售出总金额] numeric(18, 2) NULL,
      [已收款总金额] numeric(18, 2) NULL,
      [欠款总金额] numeric(18, 2) NULL,
      [未售面积] numeric(18, 2) NULL,
      [未售套数] numeric(18, 2) NULL,
      [平均价格] numeric(18, 2) NULL,
      [预计总价格] numeric(18, 2) NULL,
      [应收款总额] numeric(18, 2) NULL);
--[dtproperties];
--[No Update];
--[sys_authority];
--[No Update];
--[sys_defaultauthority];
--[No Update];
--[sys_FastReportAuthority];
--[No Update];
--[sys_GridControlLayout];
--[No Update];
--[sys_log];
--[No Update];
--[sys_NavBar];
--[No Update];
--[sys_role];
--[No Update];
--[sys_rolepvauthority];
--[No Update];
--[sys_rolepvdefaultau];
--[No Update];
--[sys_rolepvFastReport];
--[No Update];
--[sys_Settings];
--[No Update];
--[sys_user];
--[No Update];
--[sys_userpvrole];
--[No Update];
--[tb_aaa];
--[No Update];
--[tb_bbb];
--[No Update];
--[tb_c];
--[No Update];
--[TB_chewei];
--[No Update];
--[tb_d];
--[No Update];
--[tb_e];
--[No Update];
--[TB_fangjian];
--[No Update];
--[TB_fukuanjihua];
--[No Update];
--[tb_h];
--[No Update];
--[TB_kehu];
--[No Update];
--[TB_loupan];
--[No Update];
--[TB_ruzhang];
--[No Update];
--[TB_ruzhang111];
--[No Update];
--[TB_shoukuan];
--[No Update];
--[TB_yinhang];
--[No Update];
--[TB_zhucangshi];
--[No Update];
--[房间统计];
--[No Update];
--[dtproperties];
--[No Update];
--[sys_authority];
--[No Update];
--[sys_defaultauthority];
--[No Update];
--[sys_FastReportAuthority];
--[No Update];
--[sys_GridControlLayout];
--[No Update];
--[sys_log];
--[No Update];
--[sys_NavBar];
--[No Update];
--[sys_role];
--[No Update];
--[sys_rolepvauthority];
--[No Update];
--[sys_rolepvdefaultau];
--[No Update];
--[sys_rolepvFastReport];
--[No Update];
--[sys_Settings];
--[No Update];
--[sys_user];
--[No Update];
--[sys_userpvrole];
--[No Update];
--[tb_aaa];
--[No Update];
--[tb_bbb];
--[No Update];
--[tb_c];
--[No Update];
--[TB_chewei];
--[No Update];
--[tb_d];
--[No Update];
--[tb_e];
--[No Update];
--[TB_fangjian];
--[No Update];
--[TB_fukuanjihua];
--[No Update];
--[tb_h];
--[No Update];
--[TB_kehu];
--[No Update];
--[TB_loupan];
--[No Update];
--[TB_ruzhang];
--[No Update];
--[TB_ruzhang111];
--[No Update];
--[TB_shoukuan];
--[No Update];
--[TB_yinhang];
--[No Update];
--[TB_zhucangshi];
--[No Update];
--[房间统计];
--[No Update];

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11238514/viewspace-757006/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11238514/viewspace-757006/

clg10073
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值