lyfz_repos/经典版源码/document/数据库维护脚本/创建数据库CreateSQL.sql

USE [db]
GO
/****** 对象:  Table [dbo].[burncdreg]    脚本日期: 01/19/2015 17:07:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[burncdreg](
	[id] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[ren] [nvarchar](50) NULL,
	[remark] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[childmsg]    脚本日期: 01/19/2015 17:07:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[childmsg](
	[check] [nvarchar](50) NULL,
	[days] [nvarchar](50) NULL,
	[content] [nvarchar](max) NULL,
	[mode] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[client]    脚本日期: 01/19/2015 17:07:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[client](
	[id] [nvarchar](50) NULL,
	[name1] [nvarchar](50) NULL,
	[name2] [nvarchar](50) NULL,
	[phone1] [nvarchar](50) NULL,
	[phone2] [nvarchar](50) NULL,
	[qq1] [nvarchar](50) NULL,
	[qq2] [nvarchar](50) NULL,
	[addr1] [nvarchar](50) NULL,
	[addr2] [nvarchar](50) NULL,
	[occupation1] [nvarchar](50) NULL,
	[occupation2] [nvarchar](50) NULL,
	[birthday1] [nvarchar](50) NULL,
	[birthday2] [nvarchar](50) NULL,
	[time3] [nvarchar](50) NULL,
	[area] [nvarchar](50) NULL,
	[area2] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[check2] [nvarchar](50) NULL,
	[check3] [nvarchar](50) NULL,
	[sex] [nvarchar](50) NULL,
	[zodiac] [nvarchar](50) NULL,
	[photo] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[client2]    脚本日期: 01/19/2015 17:07:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client2](
	[name] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[qq] [nvarchar](50) NULL,
	[addr] [nvarchar](50) NULL,
	[from] [nvarchar](50) NULL,
	[reason] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[pinyin] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[sex] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ren] [nvarchar](50) NULL,
	[birthday] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[area] [nvarchar](50) NULL,
	[name2] [nvarchar](50) NULL,
	[status] [nvarchar](50) NULL,
	[pinyin2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[client2phonerecord]    脚本日期: 01/19/2015 17:07:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client2phonerecord](
	[phone] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[client2phonerecordout]    脚本日期: 01/19/2015 17:07:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client2phonerecordout](
	[phoneno] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[client3]    脚本日期: 01/19/2015 17:07:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client3](
	[name] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[qq] [nvarchar](50) NULL,
	[addr] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[pinyin] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[sex] [nvarchar](50) NULL,
	[ren] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dandate] [nvarchar](50) NULL,
	[name2] [nvarchar](50) NULL,
	[phone2] [nvarchar](50) NULL,
	[qq2] [nvarchar](50) NULL,
	[birthday] [nvarchar](50) NULL,
	[birthday2] [nvarchar](50) NULL,
	[time3] [nvarchar](50) NULL,
	[taoxiname] [nvarchar](50) NULL,
	[taoxijiage] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[check2] [nvarchar](50) NULL,
	[check3] [nvarchar](50) NULL,
	[pinyin2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[client3phonerecord]    脚本日期: 01/19/2015 17:07:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client3phonerecord](
	[phone] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[client3phonerecordout]    脚本日期: 01/19/2015 17:08:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client3phonerecordout](
	[phoneno] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[clientfrom]    脚本日期: 01/19/2015 17:08:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[clientfrom](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[clientreason]    脚本日期: 01/19/2015 17:08:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[clientreason](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[digitalwork]    脚本日期: 01/19/2015 17:08:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[digitalwork](
	[id] [nvarchar](50) NULL,
	[waiter1] [nvarchar](50) NULL,
	[waiter2] [nvarchar](50) NULL,
	[waiter3] [nvarchar](50) NULL,
	[date1] [nvarchar](50) NULL,
	[date2] [nvarchar](50) NULL,
	[date3] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dindan]    脚本日期: 01/19/2015 17:08:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindan](
	[id] [nvarchar](50) NULL,
	[money1] [nvarchar](50) NULL,
	[money2] [nvarchar](50) NULL,
	[money3] [nvarchar](50) NULL,
	[name1] [nvarchar](50) NULL,
	[name2] [nvarchar](50) NULL,
	[taoxiid] [nvarchar](50) NULL,
	[taoxiname] [nvarchar](50) NULL,
	[taoxijiage] [nvarchar](50) NULL,
	[taoxizs] [nvarchar](50) NULL,
	[time1] [nvarchar](50) NULL,
	[time2] [nvarchar](50) NULL,
	[time3] [nvarchar](50) NULL,
	[bm] [nvarchar](50) NULL,
	[ren] [nvarchar](50) NULL,
	[discount] [nvarchar](50) NULL,
	[payed1] [nvarchar](50) NULL,
	[payed2] [nvarchar](50) NULL,
	[payed3] [nvarchar](50) NULL,
	[payed4] [nvarchar](50) NULL,
	[payed5] [nvarchar](50) NULL,
	[time4] [nvarchar](50) NULL,
	[time5] [nvarchar](50) NULL,
	[takezs] [nvarchar](50) NULL,
	[choosezs] [nvarchar](50) NULL,
	[status] [nvarchar](50) NULL,
	[clothescount2] [nvarchar](50) NULL,
	[outside2] [nvarchar](50) NULL,
	[style] [nvarchar](50) NULL,
	[payed3time] [nvarchar](50) NULL,
	[payed4ren] [nvarchar](50) NULL,
	[payed4time] [nvarchar](50) NULL,
	[status2] [nvarchar](50) NULL,
	[status3] [nvarchar](50) NULL,
	[waiter1] [nvarchar](50) NULL,
	[waiter2] [nvarchar](50) NULL,
	[waiter3] [nvarchar](50) NULL,
	[waiter4] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[taketime] [nvarchar](50) NULL,
	[clothescount] [nvarchar](50) NULL,
	[outside] [nvarchar](50) NULL,
	[bz2] [nvarchar](max) NULL,
	[bz3] [nvarchar](max) NULL,
	[urgent] [nvarchar](50) NULL,
	[status4] [nvarchar](50) NULL,
	[status5] [nvarchar](50) NULL,
	[waiter5] [nvarchar](50) NULL,
	[waiter6] [nvarchar](50) NULL,
	[pinyin1] [nvarchar](50) NULL,
	[pinyin2] [nvarchar](50) NULL,
	[waiter7] [nvarchar](50) NULL,
	[status6] [nvarchar](50) NULL,
	[phone1] [nvarchar](50) NULL,
	[phone2] [nvarchar](50) NULL,
	[status7] [nvarchar](50) NULL,
	[memberno] [nvarchar](50) NULL,
	[waiter8] [nvarchar](50) NULL,
	[time6] [nvarchar](50) NULL,
	[status8] [nvarchar](50) NULL,
	[bruncount] [nvarchar](50) NULL,
	[tichenren1] [nvarchar](50) NULL,
	[tichenren2] [nvarchar](50) NULL,
	[tichenren3] [nvarchar](50) NULL,
	[tichenren4] [nvarchar](50) NULL,
	[tichenren5] [nvarchar](50) NULL,
	[send1] [nvarchar](50) NULL,
	[send2] [nvarchar](50) NULL,
	[send3] [nvarchar](50) NULL,
	[datetime4] [nvarchar](50) NULL,
	[datetime5] [nvarchar](50) NULL,
	[datetime6] [nvarchar](50) NULL,
	[waiter12] [nvarchar](50) NULL,
	[waiter22] [nvarchar](50) NULL,
	[waiter1rate] [nvarchar](50) NULL,
	[waiter2rate] [nvarchar](50) NULL,
	[waiter13] [nvarchar](50) NULL,
	[waiter14] [nvarchar](50) NULL,
	[waiter23] [nvarchar](50) NULL,
	[waiter24] [nvarchar](50) NULL,
	[waiter12rate] [nvarchar](50) NULL,
	[waiter13rate] [nvarchar](50) NULL,
	[waiter14rate] [nvarchar](50) NULL,
	[waiter22rate] [nvarchar](50) NULL,
	[waiter23rate] [nvarchar](50) NULL,
	[waiter24rate] [nvarchar](50) NULL,
	[ren2] [nvarchar](50) NULL,
	[renrate] [nvarchar](50) NULL,
	[ren2rate] [nvarchar](50) NULL,
	[txtype] [nvarchar](50) NULL,
	[delphotos] [nvarchar](max) NULL,
	[growthtxselname] [nvarchar](max) NULL,
	[delphotos2] [nvarchar](max) NULL,
	[designno] [nvarchar](max) NULL,
	[designreplaceno] [nvarchar](max) NULL,
	[size] [nvarchar](max) NULL,
	[dindantype] [nvarchar](50) NULL,
	[contractno1] [nvarchar](50) NULL,
	[contractno2] [nvarchar](50) NULL,
	[cfno] [nvarchar](50) NULL,
	[calldate] [nvarchar](50) NULL,
	[from] [nvarchar](50) NULL,
	[reason] [nvarchar](50) NULL,
	[time7] [nvarchar](50) NULL,
	[time8] [nvarchar](50) NULL,
	[time9] [nvarchar](50) NULL,
	[time10] [nvarchar](50) NULL,
	[authorize] [nvarchar](50) NULL,
	[discount2] [nvarchar](50) NULL,
	[authorize2] [nvarchar](50) NULL,
	[bz4] [nvarchar](max) NULL,
	[satisfaction1] [int] NULL,
	[satisfaction2] [int] NULL,
	[satisfaction3] [int] NULL,
	[satisfaction4] [int] NULL,
	[satisfaction5] [int] NULL,
	[satisfaction6] [int] NULL,
	[satisfaction7] [int] NULL,
	[bz5] [nvarchar](max) NULL,
	[send4] [int] NULL,
	[send5] [int] NULL,
	[waiter9] [nvarchar](120) NULL,
	[satisfaction8] [int] NULL,
	[VisitPeople1] [nvarchar](10) NULL,
	[VisitPeople2] [nvarchar](10) NULL,
	[VisitPeople3] [nvarchar](10) NULL,
	[VisitPeople4] [nvarchar](10) NULL,
	[VisitPeople5] [nvarchar](10) NULL,
	[VisitPeople6] [nvarchar](10) NULL,
	[VisitPeople7] [nvarchar](10) NULL,
	[VisitPeople8] [nvarchar](10) NULL,
	[VisitTime1] [nvarchar](20) NULL,
	[VisitTime2] [nvarchar](20) NULL,
	[VisitTime3] [nvarchar](20) NULL,
	[VisitTime4] [nvarchar](20) NULL,
	[VisitTime5] [nvarchar](20) NULL,
	[VisitTime6] [nvarchar](20) NULL,
	[VisitTime7] [nvarchar](20) NULL,
	[VisitTime8] [nvarchar](20) NULL,
	[curno] [nvarchar](50) NULL,
	[xplrr] [nvarchar](50) NULL,
	[xplrtime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dindanbukuan]    脚本日期: 01/19/2015 17:08:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindanbukuan](
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[id] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[ren] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[kind] [nvarchar](50) NULL,
	[ren2] [nvarchar](50) NULL,
	[item] [nvarchar](max) NULL,
	[paytype] [nvarchar](50) NULL,
	[jdd] [nvarchar](50) NULL,
	[financecheck] [nvarchar](10) NULL,
	[discount] [nvarchar](50) NULL,
	[time] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dindanbukuan2]    脚本日期: 01/19/2015 17:08:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindanbukuan2](
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[id] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[ren] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[bz] [nvarchar](500) NULL,
	[kind] [nvarchar](50) NULL,
	[ren2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dindanjd]    脚本日期: 01/19/2015 17:08:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindanjd](
	[id] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[time] [nvarchar](50) NULL,
	[waiter1] [nvarchar](50) NULL,
	[waiter2] [nvarchar](50) NULL,
	[status] [nvarchar](50) NULL,
	[waiter12] [nvarchar](50) NULL,
	[waiter22] [nvarchar](50) NULL,
	[bookingdate] [nvarchar](50) NULL,
	[dress] [nvarchar](150) NULL,
	[bz] [nvarchar](150) NULL,
	[clerk] [nvarchar](120) NULL,
	[inputtime] [nvarchar](50) NULL,
	[branch] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dindansp]    脚本日期: 01/19/2015 17:08:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindansp](
	[id] [nvarchar](50) NULL,
	[spid] [nvarchar](50) NULL,
	[shuliang] [nvarchar](120) NULL,
	[kind] [nvarchar](10) NULL,
	[price] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[no] [nvarchar](max) NULL,
	[status1] [nvarchar](50) NULL,
	[status2] [nvarchar](50) NULL,
	[status3] [nvarchar](50) NULL,
	[status4] [nvarchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[date1] [nvarchar](50) NULL,
	[date2] [nvarchar](50) NULL,
	[date3] [nvarchar](50) NULL,
	[date4] [nvarchar](50) NULL,
	[name1] [nvarchar](50) NULL,
	[name2] [nvarchar](50) NULL,
	[name3] [nvarchar](50) NULL,
	[name4] [nvarchar](50) NULL,
	[hqdate] [nvarchar](50) NULL,
	[hqtime] [nvarchar](50) NULL,
	[urgent] [nvarchar](50) NULL,
	[taketime] [nvarchar](50) NULL,
	[no2] [nvarchar](max) NULL,
	[growthtxname] [nvarchar](50) NULL,
	[status5] [nvarchar](50) NULL,
	[status6] [nvarchar](50) NULL,
	[date5] [nvarchar](50) NULL,
	[date6] [nvarchar](50) NULL,
	[name5] [nvarchar](50) NULL,
	[name6] [nvarchar](50) NULL,
	[ps] [nvarchar](50) NULL,
	[zs] [nvarchar](50) NULL,
	[ren1] [nvarchar](120) NULL,
	[ren2] [nvarchar](120) NULL,
	[hqstatus] [nvarchar](50) NULL,
	[bz] [nvarchar](200) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dindansp2]    脚本日期: 01/19/2015 17:08:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindansp2](
	[id] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[count] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dindansp3]    脚本日期: 01/19/2015 17:08:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindansp3](
	[id] [nvarchar](50) NULL,
	[spid] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[count] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dressarea]    脚本日期: 01/19/2015 17:08:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dressarea](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dresshire]    脚本日期: 01/19/2015 17:08:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dresshire](
	[money] [nvarchar](50) NULL,
	[money2] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[hireorsale] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[id] [nvarchar](50) NULL,
	[remark] [nvarchar](max) NULL,
	[date1] [nvarchar](50) NULL,
	[date2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dresshiredata]    脚本日期: 01/19/2015 17:08:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dresshiredata](
	[id] [nvarchar](50) NULL,
	[no] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[count] [nvarchar](50) NULL,
	[isreturn] [nvarchar](50) NULL,
	[returndate] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[hireorsale] [nvarchar](50) NULL,
	[date1] [nvarchar](50) NULL,
	[date2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dressinfo]    脚本日期: 01/19/2015 17:08:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dressinfo](
	[type] [nvarchar](50) NULL,
	[no] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[count] [nvarchar](50) NULL,
	[price1] [nvarchar](50) NULL,
	[price2] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[hirecount] [nvarchar](50) NULL,
	[salecount] [nvarchar](50) NULL,
	[balance] [nvarchar](50) NULL,
	[remark] [nvarchar](max) NULL,
	[dressarea] [nvarchar](50) NULL,
	[washcount] [nvarchar](50) NULL,
	[type2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[dresstype]    脚本日期: 01/19/2015 17:08:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dresstype](
	[name] [nvarchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[type] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[employeephonerecord]    脚本日期: 01/19/2015 17:08:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[employeephonerecord](
	[name] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[employeephonerecordout]    脚本日期: 01/19/2015 17:08:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[employeephonerecordout](
	[name] [nvarchar](50) NULL,
	[phoneno] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[expendtype]    脚本日期: 01/19/2015 17:08:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[expendtype](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[framesize]    脚本日期: 01/19/2015 17:08:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[framesize](
	[name] [nvarchar](50) NULL,
	[width] [nvarchar](50) NULL,
	[height] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[gongyingshang]    脚本日期: 01/19/2015 17:08:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[gongyingshang](
	[gyid] [nvarchar](20) NULL,
	[gyname] [nvarchar](30) NULL,
	[addr] [nvarchar](30) NULL,
	[tel] [nvarchar](20) NULL,
	[fax] [nvarchar](8) NULL,
	[netaddress] [nvarchar](20) NULL,
	[bz] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[growthtx]    脚本日期: 01/19/2015 17:08:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[growthtx](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[gudingfeiyong]    脚本日期: 01/19/2015 17:08:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[gudingfeiyong](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[dat] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[renyuan1] [nvarchar](50) NULL,
	[renyuan2] [nvarchar](50) NULL,
	[financecheck] [nvarchar](10) NULL,
	[time] [nvarchar](50) NULL,
	[photo] [image] NULL,
	[financecheck2] [nvarchar](50) NULL,
	[financecheck3] [nvarchar](50) NULL,
	[hasphoto] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[gudingfeiyongxiangmu]    脚本日期: 01/19/2015 17:08:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[gudingfeiyongxiangmu](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[xiangmu] [nvarchar](20) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[historydb]    脚本日期: 01/19/2015 17:08:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[historydb](
	[year] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[insidemsg]    脚本日期: 01/19/2015 17:08:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[insidemsg](
	[timestamp] [nvarchar](50) NULL,
	[content] [nvarchar](max) NULL,
	[sender] [nvarchar](50) NULL,
	[receiver] [nvarchar](max) NULL,
	[receiver2] [nvarchar](max) NULL,
	[file] [nvarchar](max) NULL,
	[files] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[jd]    脚本日期: 01/19/2015 17:08:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[jd](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[jdd]    脚本日期: 01/19/2015 17:08:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[jdd](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[log]    脚本日期: 01/19/2015 17:08:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[log](
	[date] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL,
	[content] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[loginsign]    脚本日期: 01/19/2015 17:08:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[loginsign](
	[name] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[cleck] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[loninbanset]    脚本日期: 01/19/2015 17:08:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[loninbanset](
	[weekname] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[banname1] [nvarchar](50) NULL,
	[banname2] [nvarchar](50) NULL,
	[banname3] [nvarchar](50) NULL,
	[banname4] [nvarchar](50) NULL,
	[banname5] [nvarchar](50) NULL,
	[banname6] [nvarchar](50) NULL,
	[banname7] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[lonindata]    脚本日期: 01/19/2015 17:08:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[lonindata](
	[no] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[lonintimeset]    脚本日期: 01/19/2015 17:08:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[lonintimeset](
	[name] [nvarchar](50) NULL,
	[time1] [nvarchar](50) NULL,
	[time2] [nvarchar](50) NULL,
	[time3] [nvarchar](50) NULL,
	[time4] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[txlb2]    脚本日期: 01/19/2015 17:09:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[txlb2](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[membercard2]    脚本日期: 01/19/2015 17:08:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard2](
	[memberno] [nvarchar](50) NULL,
	[card2no] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[sale2type]    脚本日期: 01/19/2015 17:09:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sale2type](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[membercard2blue]    脚本日期: 01/19/2015 17:08:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard2blue](
	[memberno] [nvarchar](50) NULL,
	[card2no] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[singleincomemoney]    脚本日期: 01/19/2015 17:09:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[singleincomemoney](
	[id] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[paytype] [nvarchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[financecheck] [nvarchar](10) NULL,
	[time] [nvarchar](50) NULL,
	[jdd] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[membercard3]    脚本日期: 01/19/2015 17:08:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard3](
	[memberno] [nvarchar](50) NULL,
	[card2no] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[balance] [nvarchar](50) NULL,
	[psw] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[membercard3childusereg]    脚本日期: 01/19/2015 17:08:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard3childusereg](
	[memberno] [nvarchar](50) NULL,
	[dindanid] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[membercard3usereg]    脚本日期: 01/19/2015 17:08:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard3usereg](
	[memberno] [nvarchar](50) NULL,
	[dindanid] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[membermanage]    脚本日期: 01/19/2015 17:09:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membermanage](
	[memberno] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[sex] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[qq] [nvarchar](50) NULL,
	[addr] [nvarchar](50) NULL,
	[occupation] [nvarchar](50) NULL,
	[birthday] [nvarchar](50) NULL,
	[pinyin] [nvarchar](50) NULL,
	[balance] [nvarchar](50) NULL,
	[sendmark1] [nvarchar](max) NULL,
	[sendmark2] [nvarchar](max) NULL,
	[psw] [nvarchar](50) NULL,
	[cardtype] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[discount] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[membermanageblue]    脚本日期: 01/19/2015 17:09:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membermanageblue](
	[memberno] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[sex] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[qq] [nvarchar](50) NULL,
	[addr] [nvarchar](50) NULL,
	[occupation] [nvarchar](50) NULL,
	[birthday] [nvarchar](50) NULL,
	[pinyin] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[jiage] [nvarchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[money2] [nvarchar](50) NULL,
	[money3] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[memberreg]    脚本日期: 01/19/2015 17:09:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg](
	[memberno] [nvarchar](50) NULL,
	[dindanid] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[date] [nvarchar](50) NULL,
	[card2no] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[taoxi] [nvarchar](50) NULL,
	[date2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[memberreg2]    脚本日期: 01/19/2015 17:09:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg2](
	[memberno] [nvarchar](50) NULL,
	[dindanid] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[point] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[memberreg2blue]    脚本日期: 01/19/2015 17:09:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg2blue](
	[memberno] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[memberreg3]    脚本日期: 01/19/2015 17:09:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg3](
	[memberno] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[financecheck] [nvarchar](50) NULL,
	[moneytype] [nvarchar](50) NULL,
	[time] [nvarchar](50) NULL,
	[money2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[memberreg4]    脚本日期: 01/19/2015 17:09:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg4](
	[memberno] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[card2no] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[memberregblue]    脚本日期: 01/19/2015 17:09:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberregblue](
	[memberno] [nvarchar](50) NULL,
	[dindanid] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[card2no] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[taoxi] [nvarchar](50) NULL,
	[date2] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[misscallrecord]    脚本日期: 01/19/2015 17:09:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[misscallrecord](
	[phone] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[msgtemp]    脚本日期: 01/19/2015 17:09:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[msgtemp](
	[title] [nvarchar](50) NULL,
	[content] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[msgtemp2]    脚本日期: 01/19/2015 17:09:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[msgtemp2](
	[name] [nvarchar](50) NULL,
	[content1] [nvarchar](max) NULL,
	[content2] [nvarchar](max) NULL,
	[check1] [nvarchar](50) NULL,
	[check2] [nvarchar](50) NULL,
	[point] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[mywork]    脚本日期: 01/19/2015 17:09:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mywork](
	[id] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL,
	[count1] [nvarchar](50) NULL,
	[count2] [nvarchar](50) NULL,
	[count3] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[inputdate] [nvarchar](50) NULL,
	[inputren] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[path]    脚本日期: 01/19/2015 17:09:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[path](
	[path1] [nvarchar](50) NULL,
	[path2] [nvarchar](50) NULL,
	[path3] [nvarchar](50) NULL,
	[path4] [nvarchar](50) NULL,
	[path5] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[phonerecord]    脚本日期: 01/19/2015 17:09:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[phonerecord](
	[id] [nvarchar](50) NULL,
	[phoneno] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[phonerecordout]    脚本日期: 01/19/2015 17:09:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[phonerecordout](
	[name] [nvarchar](50) NULL,
	[phoneno] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[photoprint]    脚本日期: 01/19/2015 17:09:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[photoprint](
	[id] [nvarchar](50) NULL,
	[name] [nvarchar](100) NULL,
	[count] [nvarchar](50) NULL,
	[status1] [nvarchar](50) NULL,
	[status2] [nvarchar](50) NULL,
	[time1] [nvarchar](50) NULL,
	[time2] [nvarchar](50) NULL,
	[area] [nvarchar](50) NULL,
	[statusOfReWork] [nvarchar](50) NULL,
	[timeOfReWork] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[renyuan]    脚本日期: 01/19/2015 17:09:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[renyuan](
	[bm] [nvarchar](50) NULL,
	[id] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[sex] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[address] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[base] [nvarchar](50) NULL,
	[rate1] [nvarchar](50) NULL,
	[rate2] [nvarchar](50) NULL,
	[bz2] [nvarchar](max) NULL,
	[address2] [nvarchar](50) NULL,
	[idno] [nvarchar](50) NULL,
	[marry] [nvarchar](50) NULL,
	[dimission] [nvarchar](50) NULL,
	[rate3] [nvarchar](50) NULL,
	[rate4] [nvarchar](50) NULL,
	[rate5] [nvarchar](50) NULL,
	[loginno1] [nvarchar](50) NULL,
	[loginno2] [nvarchar](50) NULL,
	[photo] [image] NULL,
	[level] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[salary]    脚本日期: 01/19/2015 17:09:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[salary](
	[name] [nvarchar](50) NULL,
	[year] [nvarchar](50) NULL,
	[month] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[rewards]    脚本日期: 01/19/2015 17:09:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rewards](
	[name] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[execute] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[renyuan] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[sendreg]    脚本日期: 01/19/2015 17:09:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendreg](
	[timestamp] [nvarchar](50) NULL,
	[msgcount] [nvarchar](50) NULL,
	[log] [nvarchar](50) NULL,
	[status] [nvarchar](50) NULL,
	[issended] [nvarchar](50) NULL,
	[isautosend] [nvarchar](50) NULL,
	[phones] [nvarchar](max) NULL,
	[content] [nvarchar](max) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[ren] [nvarchar](50) NULL,
	[msgtype] [nvarchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[singleincome]    脚本日期: 01/19/2015 17:09:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[singleincome](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
	[money] [nvarchar](50) NULL,
	[dat] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[renyuan1] [nvarchar](50) NULL,
	[renyuan2] [nvarchar](50) NULL,
	[renyuan3] [nvarchar](50) NULL,
	[sale2type] [nvarchar](50) NULL,
	[paytype] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[payed] [nvarchar](50) NULL,
	[balance] [nvarchar](50) NULL,
	[pinyin] [nvarchar](50) NULL,
	[financecheck] [nvarchar](10) NULL,
	[count] [nvarchar](50) NULL,
	[time] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[storeinfo]    脚本日期: 01/19/2015 17:09:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[storeinfo](
	[id] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[count] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[remark] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[storeinfo2]    脚本日期: 01/19/2015 17:09:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[storeinfo2](
	[id] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[count] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[remark] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[taoxi]    脚本日期: 01/19/2015 17:09:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[taoxi](
	[taoxiid] [nvarchar](50) NULL,
	[taoxiname] [nvarchar](20) NULL,
	[taoxijiage] [nvarchar](9) NULL,
	[zs] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[show] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[taoxifg]    脚本日期: 01/19/2015 17:09:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[taoxifg](
	[name] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[taoxishangpin1]    脚本日期: 01/19/2015 17:09:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[taoxishangpin1](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[taoxiid] [nvarchar](20) NULL,
	[spid1] [nvarchar](15) NULL,
	[shuliang] [nvarchar](15) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[taoxishangpin2]    脚本日期: 01/19/2015 17:09:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[taoxishangpin2](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[taoxiid] [nvarchar](15) NULL,
	[spid2] [nvarchar](15) NULL,
	[shuliang] [nvarchar](15) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[todaytake]    脚本日期: 01/19/2015 17:09:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[todaytake](
	[name] [nvarchar](50) NULL,
	[phone] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[time] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[price] [nvarchar](50) NULL,
	[waiter1] [nvarchar](50) NULL,
	[waiter2] [nvarchar](50) NULL,
	[receptionist] [nvarchar](50) NULL,
	[arrearage] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[remark] [nvarchar](max) NULL,
	[timestamp] [nvarchar](50) NULL,
	[content] [nvarchar](50) NULL,
	[mode] [nvarchar](50) NULL,
	[arrive] [nvarchar](50) NULL,
	[id] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[txlb]    脚本日期: 01/19/2015 17:09:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[txlb](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[unknownphonerecord]    脚本日期: 01/19/2015 17:09:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unknownphonerecord](
	[phone] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[unknownphonerecordout]    脚本日期: 01/19/2015 17:09:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unknownphonerecordout](
	[phoneno] [nvarchar](50) NULL,
	[datetime] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[update]    脚本日期: 01/19/2015 17:09:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[update](
	[data] [image] NULL,
	[data2] [image] NULL,
	[data3] [image] NULL,
	[data4] [image] NULL,
	[data5] [image] NULL,
	[data6] [image] NULL,
	[data7] [image] NULL,
	[ocx] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[user]    脚本日期: 01/19/2015 17:09:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user](
	[account] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[psw] [nvarchar](50) NULL,
	[rights] [nvarchar](80) NULL,
	[rate1] [nvarchar](50) NULL,
	[rate2] [nvarchar](50) NULL,
	[base] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[rights2] [nvarchar](max) NULL,
	[discount] [nvarchar](50) NULL,
	[discount2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[version]    脚本日期: 01/19/2015 17:10:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[version](
	[version] [nvarchar](50) NULL,
	[curdate] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[check2] [nvarchar](50) NULL,
	[check3] [nvarchar](50) NULL,
	[check4] [nvarchar](50) NULL,
	[edit1] [nvarchar](50) NULL,
	[edit2] [nvarchar](50) NULL,
	[edit3] [nvarchar](50) NULL,
	[edit4] [nvarchar](50) NULL,
	[info1] [nvarchar](50) NULL,
	[info2] [nvarchar](50) NULL,
	[info3] [nvarchar](50) NULL,
	[info4] [nvarchar](50) NULL,
	[info5] [nvarchar](50) NULL,
	[bak1] [nvarchar](50) NULL,
	[bak2] [nvarchar](50) NULL,
	[bak3] [nvarchar](50) NULL,
	[bak4] [nvarchar](50) NULL,
	[bak5] [nvarchar](50) NULL,
	[bak6] [nvarchar](50) NULL,
	[baktime] [nvarchar](50) NULL,
	[bakserver1] [nvarchar](50) NULL,
	[bakserver2] [nvarchar](50) NULL,
	[bakserver3] [nvarchar](50) NULL,
	[bakserver4] [nvarchar](50) NULL,
	[bakserver5] [nvarchar](50) NULL,
	[msgaccount] [nvarchar](50) NULL,
	[msgpsw] [nvarchar](50) NULL,
	[msgused] [nvarchar](50) NULL,
	[msgbalance] [nvarchar](50) NULL,
	[msgcheck1] [nvarchar](50) NULL,
	[msgcheck2] [nvarchar](50) NULL,
	[msgdays1] [nvarchar](50) NULL,
	[msgdays2] [nvarchar](50) NULL,
	[msgcontent1] [nvarchar](max) NULL,
	[msgcontent2] [nvarchar](max) NULL,
	[remarks] [nvarchar](max) NULL,
	[rate] [nvarchar](50) NULL,
	[msgcheck3] [nvarchar](50) NULL,
	[msgcontent3] [nvarchar](max) NULL,
	[salarycheck1] [nvarchar](50) NULL,
	[salarycheck2] [nvarchar](50) NULL,
	[msgcheck4] [nvarchar](50) NULL,
	[msgtime] [nvarchar](50) NULL,
	[msgphones] [nvarchar](max) NULL,
	[info6] [nvarchar](50) NULL,
	[msgcompanyname] [nvarchar](50) NULL,
	[msgphones2] [nvarchar](max) NULL,
	[msgsendtype] [nvarchar](50) NULL,
	[msgcontent5] [nvarchar](max) NULL,
	[msgcheck5] [nvarchar](50) NULL,
	[msgcontent6] [nvarchar](max) NULL,
	[msgcheck6] [nvarchar](50) NULL,
	[cardlength] [nvarchar](50) NULL,
	[salarycheck3] [nvarchar](50) NULL,
	[salarycheck4] [nvarchar](50) NULL,
	[setcheck1] [nvarchar](50) NULL,
	[setcheck2] [nvarchar](50) NULL,
	[setcheck3] [nvarchar](50) NULL,
	[setcheck4] [nvarchar](50) NULL,
	[setcheck5] [nvarchar](50) NULL,
	[printer1] [nvarchar](50) NULL,
	[printer2] [nvarchar](50) NULL,
	[printer3] [nvarchar](50) NULL,
	[setprintstyle] [nvarchar](50) NULL,
	[uploadcheck1] [nvarchar](50) NULL,
	[uploadcheck2] [nvarchar](50) NULL,
	[uploadcheck3] [nvarchar](50) NULL,
	[uploadcheck4] [nvarchar](50) NULL,
	[bak11] [nvarchar](50) NULL,
	[bak22] [nvarchar](50) NULL,
	[bak33] [nvarchar](50) NULL,
	[bak44] [nvarchar](50) NULL,
	[setprintstyle2] [nvarchar](50) NULL,
	[setcheck10] [nvarchar](50) NULL,
	[ziptype1] [nvarchar](50) NULL,
	[ziptype2] [nvarchar](50) NULL,
	[ziptype3] [nvarchar](50) NULL,
	[ziptype4] [nvarchar](50) NULL,
	[salaryset] [nvarchar](max) NULL,
	[limitcount1] [nvarchar](50) NULL,
	[limitcount2] [nvarchar](50) NULL,
	[limitcount3] [nvarchar](50) NULL,
	[rate2] [nvarchar](50) NULL,
	[setcheck11] [nvarchar](50) NULL,
	[setcheck12] [nvarchar](50) NULL,
	[setprintstyle3] [nvarchar](50) NULL,
	[msgcheck7] [nvarchar](50) NULL,
	[msgcheck8] [nvarchar](50) NULL,
	[msgcheck9] [nvarchar](50) NULL,
	[msgcheck10] [nvarchar](50) NULL,
	[msgcontent8] [nvarchar](max) NULL,
	[msgcontent9] [nvarchar](max) NULL,
	[msgcontent10] [nvarchar](max) NULL,
	[setcheck13] [nvarchar](50) NULL,
	[time1] [nvarchar](50) NULL,
	[time2] [nvarchar](50) NULL,
	[time3] [nvarchar](50) NULL,
	[setcheck14] [nvarchar](50) NULL,
	[setcheck15] [nvarchar](50) NULL,
	[msgcheck11] [nvarchar](50) NULL,
	[msgcheck12] [nvarchar](50) NULL,
	[msgcheck13] [nvarchar](50) NULL,
	[msgcheck14] [nvarchar](50) NULL,
	[msgcontent11] [nvarchar](max) NULL,
	[msgcontent12] [nvarchar](max) NULL,
	[msgcontent13] [nvarchar](max) NULL,
	[msgcontent14] [nvarchar](max) NULL,
	[setcheck6] [nvarchar](50) NULL,
	[msgcheck15] [nvarchar](50) NULL,
	[msgcontent15] [nvarchar](max) NULL,
	[logdays] [nvarchar](50) NULL,
	[setcheck17] [nvarchar](50) NULL,
	[setcheck18] [nvarchar](50) NULL,
	[setcheck19] [nvarchar](50) NULL,
	[uploadrule] [nvarchar](max) NULL,
	[setcheck20] [nvarchar](50) NULL,
	[cardnum] [nvarchar](50) NULL,
	[cardscale] [nvarchar](500) NULL,
	[info7] [nvarchar](120) NULL,
	[setcheck21] [nvarchar](50) NULL,
	[msgcheck16] [nvarchar](50) NULL,
	[hospitalmsgcheck1] [nvarchar](50) NULL,
	[hospitalmsgcheck2] [nvarchar](50) NULL,
	[serialno] [nvarchar](50) NULL,
	[serialno2] [nvarchar](50) NULL,
	[msgcheck17] [nvarchar](50) NULL,
	[msgcontent17] [nvarchar](max) NULL,
	[setcheck22] [nvarchar](50) NULL,
	[setcheck23] [nvarchar](50) NULL,
	[info8] [nvarchar](120) NULL,
	[setcheck24] [nvarchar](120) NULL,
	[outtime] [nvarchar](120) NULL,
	[info9] [nvarchar](120) NULL,
	[reverse1] [nvarchar](50) NULL,
	[reverse2] [nvarchar](50) NULL,
	[reverse3] [nvarchar](50) NULL,
	[reverse4] [nvarchar](50) NULL,
	[reverse5] [nvarchar](50) NULL,
	[photo] [image] NULL,
	[delcheck1] [nvarchar](50) NULL,
	[delcheck2] [nvarchar](50) NULL,
	[delcheck3] [nvarchar](50) NULL,
	[delcheck4] [nvarchar](50) NULL,
	[deledit1] [nvarchar](50) NULL,
	[deledit2] [nvarchar](50) NULL,
	[deledit3] [nvarchar](50) NULL,
	[deledit4] [nvarchar](50) NULL,
	[alarmdays1] [nvarchar](50) NULL,
	[alarmdays2] [nvarchar](50) NULL,
	[alarmdays3] [nvarchar](50) NULL,
	[alarmdays4] [nvarchar](50) NULL,
	[alarmdays5] [nvarchar](50) NULL,
	[alarmdays6] [nvarchar](50) NULL,
	[msAccount] [nvarchar](12) NULL,
	[msPassword] [nvarchar](16) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[workrate]    脚本日期: 01/19/2015 17:10:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[workrate](
	[type] [nvarchar](50) NULL,
	[data1] [nvarchar](50) NULL,
	[data2] [nvarchar](50) NULL,
	[data3] [nvarchar](50) NULL,
	[data4] [nvarchar](50) NULL,
	[data5] [nvarchar](50) NULL,
	[data6] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[worktype]    脚本日期: 01/19/2015 17:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[worktype](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[hospitalclient]    脚本日期: 01/19/2015 17:08:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[hospitalclient](
	[id] [nvarchar](50) NULL,
	[checkmsg] [nvarchar](50) NULL,
	[name1] [nvarchar](50) NULL,
	[name2] [nvarchar](50) NULL,
	[food] [nvarchar](50) NULL,
	[sex] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[birthdaytype] [nvarchar](50) NULL,
	[birthday] [nvarchar](50) NULL,
	[pregnancydays] [nvarchar](50) NULL,
	[qq] [nvarchar](50) NULL,
	[date1] [nvarchar](50) NULL,
	[from] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[hospital] [nvarchar](50) NULL,
	[remark] [nvarchar](50) NULL,
	[phone1] [nvarchar](50) NULL,
	[phone2] [nvarchar](50) NULL,
	[phone3] [nvarchar](50) NULL,
	[phone4] [nvarchar](50) NULL,
	[phone5] [nvarchar](50) NULL,
	[addr1] [nvarchar](50) NULL,
	[addr2] [nvarchar](50) NULL,
	[addr3] [nvarchar](50) NULL,
	[post1] [nvarchar](50) NULL,
	[post2] [nvarchar](50) NULL,
	[post3] [nvarchar](50) NULL,
	[pinyin1] [nvarchar](50) NULL,
	[pinyin2] [nvarchar](50) NULL,
	[inputdate] [nvarchar](50) NULL,
	[inputer] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[businesstype]    脚本日期: 01/19/2015 17:07:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[businesstype](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[businessintention]    脚本日期: 01/19/2015 17:07:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[businessintention](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[clienttype]    脚本日期: 01/19/2015 17:08:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[clienttype](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[hospital]    脚本日期: 01/19/2015 17:08:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[hospital](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[hospitalclientcontactreg]    脚本日期: 01/19/2015 17:08:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[hospitalclientcontactreg](
	[id] [nvarchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[businesstype] [nvarchar](50) NULL,
	[businessintention] [nvarchar](50) NULL,
	[bookingdate] [nvarchar](50) NULL,
	[desaddr] [nvarchar](50) NULL,
	[businessremark] [nvarchar](50) NULL,
	[alarmcheck] [nvarchar](50) NULL,
	[alarmdate] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[sendregdelay]    脚本日期: 01/19/2015 17:09:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sendregdelay](
	[timestamp] [nvarchar](50) NULL,
	[msgcount] [nvarchar](50) NULL,
	[log] [nvarchar](50) NULL,
	[status] [nvarchar](50) NULL,
	[issended] [nvarchar](50) NULL,
	[isautosend] [nvarchar](50) NULL,
	[phones] [nvarchar](max) NULL,
	[content] [nvarchar](max) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[ren] [nvarchar](50) NULL,
	[msgtype] [nvarchar](10) NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[fixedassets]    脚本日期: 01/19/2015 17:08:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fixedassets](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[count] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL,
	[remark] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[photo] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[msgcode]    脚本日期: 01/19/2015 17:09:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[msgcode](
	[type] [nvarchar](50) NULL,
	[code] [nvarchar](50) NULL,
	[good] [nvarchar](50) NULL,
	[medium] [nvarchar](50) NULL,
	[bad] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[clientqequirement]    脚本日期: 01/19/2015 17:08:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[clientqequirement](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[clientcontract]    脚本日期: 01/19/2015 17:08:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[clientcontract](
	[id] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[photo] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[annualfee]    脚本日期: 01/19/2015 17:07:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[annualfee](
	[id] [nvarchar](50) NULL,
	[year] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[clerk] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[area]    脚本日期: 01/19/2015 17:07:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[area](
	[id] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[bakstate]    脚本日期: 01/19/2015 17:07:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[bakstate](
	[date] [nvarchar](50) NULL,
	[photo] [nvarchar](50) NULL,
	[info] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[baseexpendtype]    脚本日期: 01/19/2015 17:07:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[baseexpendtype](
	[name] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[bumen]    脚本日期: 01/19/2015 17:07:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[bumen](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[sendreg2]    脚本日期: 01/19/2015 17:09:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendreg2](
	[price] [nvarchar](50) NULL,
	[yytime] [nvarchar](50) NULL,
	[client] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[phones] [nvarchar](max) NULL,
	[content] [nvarchar](max) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[ren] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[sendregcard]    脚本日期: 01/19/2015 17:09:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendregcard](
	[timestamp] [nvarchar](50) NULL,
	[phones] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[sendregreceive]    脚本日期: 01/19/2015 17:09:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendregreceive](
	[timestamp] [nvarchar](50) NULL,
	[phones] [nvarchar](200) NULL,
	[content] [nvarchar](200) NULL,
	[status] [nvarchar](200) NULL,
	[getid] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[shangpin]    脚本日期: 01/19/2015 17:09:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[shangpin](
	[spid] [nvarchar](50) NOT NULL CONSTRAINT [DF_shangpin_spid]  DEFAULT ('0'),
	[spname] [nvarchar](50) NULL,
	[spdanwei] [nvarchar](50) NULL,
	[spjiaga1] [nvarchar](50) NULL,
	[spjiage2] [nvarchar](50) NULL,
	[splb] [nvarchar](50) NULL,
	[spbz] [nvarchar](max) NULL,
	[spjiage3] [nvarchar](50) NULL,
	[hide] [nvarchar](10) NULL,
 CONSTRAINT [PK_shangpin] PRIMARY KEY CLUSTERED 
(
	[spid] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[shangpinlb]    脚本日期: 01/19/2015 17:09:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[shangpinlb](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  View [dbo].[takeview]    脚本日期: 01/19/2015 17:10:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[takeview] as select dbo.dindan.name1, dbo.dindan.name2, dbo.dindan.ren, dbo.dindan.taoxiname, dbo.dindan.taoxijiage, dbo.dindan.phone1,dbo.dindan.phone2, dbo.dindan.curno, dbo.dindan.pinyin1,dbo.dindan.pinyin2, dbo.dindan.time3, dbo.dindan.time5, dbo.dindan.dindantype, dbo.dindanjd.id,dbo.dindanjd.name, dbo.dindanjd.date, dbo.dindanjd.time,dbo.dindanjd.waiter1, dbo.dindanjd.waiter2, dbo.dindanjd.status, dbo.dindanjd.waiter12,dbo.dindanjd.waiter22, dbo.dindanjd.bookingdate, dbo.dindanjd.dress,dbo.dindanjd.bz, dbo.dindanjd.clerk, dbo.dindanjd.inputtime, dbo.dindanjd.branch,dbo.dindan.status3, dbo.dindan.payed4, dbo.dindan.payed5, dbo.dindan.money1, dbo.client.birthday1, dbo.client.check1, dbo.client.sex from dbo.dindan INNER JOIN dbo.dindanjd ON dbo.dindan.id = dbo.dindanjd.id INNER JOIN dbo.client ON dbo.dindan.id = dbo.client.id
GO
/****** 对象:  View [dbo].[hqview]    脚本日期: 01/19/2015 17:10:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[hqview] as select dbo.dindan.id, dbo.dindan.name1, dbo.dindan.name2, dbo.dindan.phone1, dbo.dindan.phone2,dbo.dindan.time3, dbo.client.check3, dbo.dindan.ren,dbo.dindan.taoxiname, dbo.dindan.taoxijiage, dbo.dindansp.name, dbo.dindansp.hqdate,dbo.dindansp.hqtime,dbo.dindansp.ren1, dbo.dindansp.ren2, dbo.dindansp.kind,dbo.dindansp.hqstatus,dbo.dindansp.bz from dbo.dindan INNER JOIN dbo.client ON dbo.dindan.id = dbo.client.id INNER JOIN dbo.dindansp ON dbo.client.id = dbo.dindansp.id
GO
/****** 对象:  View [dbo].[dindanclient]    脚本日期: 01/19/2015 17:10:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanclient] as select dbo.dindan.id, dbo.client.id AS Expr1, dbo.client.name1, dbo.client.name2,dbo.client.phone1, dbo.client.phone2, dbo.client.birthday1, dbo.client.birthday2,dbo.client.check1, dbo.client.check2, dbo.client.check3, dbo.dindan.time3, dbo.dindan.time1,dbo.dindan.taoxiname, dbo.dindan.taoxijiage, dbo.dindan.payed4 from dbo.dindan INNER JOIN dbo.client ON dbo.dindan.id = dbo.client.id
GO
/****** 对象:  View [dbo].[msgview]    脚本日期: 01/19/2015 17:10:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[msgview] as select dbo.sendregreceive.phones, dbo.dindan.id, dbo.dindan.name1, dbo.dindan.name2, dbo.sendregreceive.[content],dbo.sendregreceive.timestamp, dbo.dindan.time1,dbo.dindan.ren, dbo.dindan.waiter1, dbo.dindan.waiter2, dbo.dindan.waiter4,dbo.dindan.waiter5, dbo.dindan.waiter7, dbo.dindan.waiter3 from  dbo.sendregreceive LEFT JOIN dbo.dindan ON dbo.sendregreceive.phones = dbo.dindan.phone1 OR dbo.sendregreceive.phones = dbo.dindan.phone2
GO
/****** 对象:  View [dbo].[dindanbukuanview]    脚本日期: 01/19/2015 17:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanbukuanview] as select dbo.dindan.name1, dbo.dindan.name2, dbo.dindan.txtype, dbo.dindan.taoxiname,dbo.dindanbukuan.money, dbo.dindanbukuan.date, dbo.dindanbukuan.kind, dbo.dindanbukuan.ren,dbo.dindanbukuan.bz, dbo.dindanbukuan.id,dbo.dindanbukuan.paytype from dbo.dindan INNER JOIN dbo.dindanbukuan ON dbo.dindan.id = dbo.dindanbukuan.id
GO
/****** 对象:  View [dbo].[dindanspview3]    脚本日期: 01/19/2015 17:10:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanspview3] as select dbo.dindan.id, dbo.dindan.name1, dbo.dindan.name2, dbo.dindan.ren, dbo.dindan.taoxijiage, dbo.dindan.payed4, dbo.dindansp.name, dbo.dindansp.shuliang,dbo.dindan.time1 from dbo.dindan INNER JOIN dbo.dindansp ON dbo.dindan.id = dbo.dindansp.id
GO
/****** 对象:  View [dbo].[alarmview]    脚本日期: 01/19/2015 17:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[alarmview] as select dbo.dindan.id, dbo.dindan.name1, dbo.dindan.name2,dbo.dindan.ren,dbo.dindan.time1,dindan.time2,dindan.time4,dbo.dindan.status,dbo.dindan.status2,dbo.dindan.status8,dbo.dindan.phone1,dbo.dindan.phone2,dbo.dindan.pinyin1,dbo.dindan.pinyin2,(SELECT count(*) FROM  dbo.dindansp WHERE (kind<>'2' and name<>'入册' and name<>'入底' and status1 = '未完成') AND (id = dbo.dindan.id)) AS cot1,(SELECT count(*) FROM  dbo.dindansp WHERE (kind<>'2' and name<>'入册' and name<>'入底' and status2 = '未取') AND (id = dbo.dindan.id)) AS cot2 FROM dbo.dindan
GO
/****** 对象:  View [dbo].[annualfeeview]    脚本日期: 01/19/2015 17:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[annualfeeview] AS SELECT     dbo.dindan.name1, dbo.dindan.name2, dbo.dindan.time1, dbo.dindan.time2, dbo.dindan.ren, dbo.dindan.phone1, dbo.dindan.phone2, dbo.dindan.pinyin1,                       dbo.dindan.pinyin2, dbo.annualfee.year, dbo.annualfee.date, dbo.annualfee.clerk, dbo.dindan.id, dbo.dindan.bz, dbo.dindan.status5 FROM         dbo.dindan LEFT OUTER JOIN                       dbo.annualfee ON dbo.dindan.id = dbo.annualfee.id
GO
/****** 对象:  View [dbo].[dindanspview4]    脚本日期: 01/19/2015 17:10:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanspview4] as select dbo.dindan.id, dbo.dindan.name1, dbo.dindan.name2, dbo.dindan.ren, dbo.dindan.taoxijiage, dbo.dindan.payed4,dbo.dindanbukuan2.bz AS name, 1 AS shuliang,dbo.dindan.time1 from dbo.dindan INNER JOIN  dbo.dindanbukuan2 ON dbo.dindan.id = dbo.dindanbukuan2.id
GO
/****** 对象:  View [dbo].[dindanview]    脚本日期: 01/19/2015 17:10:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanview] as select *,(SELECT (case when exists(SELECT id FROM dbo.dindansp WHERE id = dbo.dindan.id and kind<>'5' and name<>'入册' and name<>'入底' and status1<>'OK') then '未完成' else 'OK' end)) AS STA from dbo.dindan
GO
/****** 对象:  View [dbo].[dindanspview]    脚本日期: 01/19/2015 17:10:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanspview] as select dbo.dindan.id, dbo.dindan.name1,dbo.dindan.name2, dbo.dindan.status5,dbo.dindan.waiter4,dbo.dindan.urgent, dbo.dindan.time5, dbo.dindan.ren, dbo.dindan.phone1,dbo.dindan.phone2,dbo.dindan.pinyin1,dbo.dindan.pinyin2, dbo.dindan.taoxijiage, dbo.dindan.payed4, dbo.dindan.payed5, dbo.dindan.money1,dbo.dindan.status3,dbo.dindan.dindantype, dbo.dindansp.name, dbo.dindansp.status3 as status32,dbo.dindansp.status4, dbo.dindansp.status5 AS status52, dbo.dindansp.status6, dbo.dindansp.status1,dbo.dindansp.status2, dbo.dindansp.urgent as urgent2, dbo.dindansp.date4, dbo.dindansp.kind from dbo.dindan INNER JOIN dbo.dindansp ON dbo.dindan.id = dbo.dindansp.id
GO
/****** 对象:  View [dbo].[photoprintview]    脚本日期: 01/19/2015 17:10:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[photoprintview] AS SELECT dbo.dindan.id, dbo.dindan.name1, dbo.dindan.name2, dbo.dindan.ren, dbo.dindan.waiter4, dbo.photoprint.name, dbo.photoprint.count, dbo.photoprint.status1, dbo.photoprint.status2, dbo.photoprint.time1, dbo.photoprint.time2, dbo.photoprint.statusOfReWork,dbo.photoprint.timeOfReWork,dbo.photoprint.area, dbo.dindan.status5, dbo.dindan.urgent, dbo.dindan.time5, dbo.dindan.phone1, dbo.dindan.phone2, dbo.dindan.pinyin1, dbo.dindan.pinyin2, dbo.dindan.status3, dbo.dindan.dindantype FROM dbo.dindan LEFT OUTER JOIN dbo.photoprint ON dbo.dindan.id = dbo.photoprint.id
GO
/****** 对象:  View [dbo].[dindanbukuanview2]    脚本日期: 01/19/2015 17:10:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanbukuanview2] as select dbo.dindan.name1, dbo.dindan.name2, dbo.dindanbukuan.autoid, dbo.dindanbukuan.id,dbo.dindanbukuan.money, dbo.dindanbukuan.ren, dbo.dindanbukuan.date, dbo.dindanbukuan.bz, dbo.dindanbukuan.kind,dbo.dindanbukuan.ren2, dbo.dindanbukuan.item, dbo.dindanbukuan.paytype, dbo.dindanbukuan.jdd, dbo.dindanbukuan.financecheck,dbo.dindanbukuan.discount, dbo.dindanbukuan.time from dbo.dindanbukuan INNER JOIN dbo.dindan ON dbo.dindanbukuan.id = dbo.dindan.id
GO
/****** 对象:  View [dbo].[qjview]    脚本日期: 01/19/2015 17:10:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[qjview] as select dbo.dindan.id, dbo.dindan.name2, dbo.dindan.name1, dbo.dindansp.name,dbo.dindansp.shuliang, dbo.dindansp.status4, dbo.dindansp.date2, dbo.dindansp.status1,dbo.dindansp.date3, dbo.dindansp.status3 from dbo.dindan INNER JOIN dbo.dindansp ON dbo.dindan.id = dbo.dindansp.id
GO
/****** 对象:  View [dbo].[digitalview]    脚本日期: 01/19/2015 17:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[digitalview] AS SELECT id, name1, name2, taoxiname, taoxijiage, waiter5, time8, waiter7, time9, waiter4, time10, status4, status6, status5, txtype,				 (SELECT     SUM(CAST(money AS float)) AS Expr1 				 FROM          dbo.dindanbukuan 				 WHERE      (bz = '选片二销') AND (id = dbo.dindan.id)) AS money2,				 (SELECT     SUM(CONVERT(float, ps)) AS Expr2 				 FROM          dbo.dindansp 				 WHERE      (id = dbo.dindan.id)) AS ps,				 (SELECT     SUM(CONVERT(float, zs)) AS Expr3 				 FROM          dbo.dindansp AS dindansp_1 				 WHERE      (id = dbo.dindan.id)) AS zs 				 FROM         dbo.dindan
GO
/****** 对象:  View [dbo].[dindanspview2]    脚本日期: 01/19/2015 17:10:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dindanspview2] as select dbo.shangpin.splb, dbo.dindansp.id, dbo.dindansp.spid, dbo.dindansp.shuliang, dbo.dindansp.kind, dbo.dindansp.price, dbo.dindansp.name, dbo.dindansp.no,dbo.dindansp.status1, dbo.dindansp.status2, dbo.dindansp.status3, dbo.dindansp.status4,dbo.dindansp.autoid, dbo.dindansp.date1, dbo.dindansp.date2,dbo.dindansp.date3, dbo.dindansp.date4, dbo.dindansp.name1,dbo.dindansp.name2,dbo.dindansp.name3, dbo.dindansp.name4, dbo.dindansp.hqdate,dbo.dindansp.hqtime, dbo.dindansp.urgent, dbo.dindansp.taketime, dbo.dindansp.no2,dbo.dindansp.status5, dbo.dindansp.status6, dbo.dindansp.date5,dbo.dindansp.date6, dbo.dindansp.name5, dbo.dindansp.name6,dbo.dindansp.growthtxname,dbo.dindansp.ps, dbo.dindansp.zs, dbo.dindansp.ren1,dbo.dindansp.ren2 from  dbo.dindansp LEFT OUTER JOIN  dbo.shangpin ON dbo.dindansp.spid = dbo.shangpin.spid
GO
/****** 对象:  View [dbo].[dressview]    脚本日期: 01/19/2015 17:10:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[dressview] as select dbo.dressinfo.no, dbo.dressinfo.name, dbo.dressinfo.count, dbo.dressinfo.salecount,dbo.dresshiredata.count AS count2, dbo.dresshiredata.isreturn,dbo.dresshiredata.hireorsale, dbo.dresshiredata.date1, dbo.dresshiredata.date2,dbo.dresshire.name AS clientname, dbo.dresshire.phone, dbo.dresshire.clerk,dbo.dresshire.date from dbo.dresshire INNER JOIN dbo.dresshiredata ON dbo.dresshire.id = dbo.dresshiredata.id RIGHT OUTER JOIN dbo.dressinfo ON dbo.dresshiredata.no = dbo.dressinfo.no
GO
/****** 对象:  View [dbo].[memberview2]    脚本日期: 01/19/2015 17:10:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[memberview2] as select dbo.membermanage.memberno, dbo.membermanage.name, dbo.membermanage.date,dbo.membermanage.money, dbo.membermanage.autoid,dbo.membermanage.sex, dbo.membermanage.phone, dbo.membermanage.qq,dbo.membermanage.addr, dbo.membermanage.occupation,dbo.membermanage.birthday, dbo.membermanage.pinyin, dbo.membermanage.balance,dbo.membermanage.sendmark1, dbo.membermanage.sendmark2,dbo.membermanage.psw, dbo.membermanage.cardtype,dbo.membermanage.check1,dbo.membermanage.discount, dbo.membercard2.card2no,dbo.membercard2.date AS card2date from dbo.membermanage LEFT OUTER JOIN dbo.membercard2 ON dbo.membermanage.memberno = dbo.membercard2.memberno
GO
/****** 对象:  View [dbo].[singleincomemoneyview]    脚本日期: 01/19/2015 17:10:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[singleincomemoneyview] as select dbo.singleincomemoney.*, dbo.singleincome.name, dbo.singleincome.sale2type,dbo.singleincome.renyuan3, dbo.singleincome.renyuan1 from dbo.singleincomemoney INNER JOIN dbo.singleincome ON dbo.singleincomemoney.id = dbo.singleincome.id
GO
/****** 对象:  View [dbo].[memberview3]    脚本日期: 01/19/2015 17:10:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[memberview3] as select dbo.membermanage.memberno, dbo.membermanage.name, dbo.membermanage.date,dbo.membermanage.money, dbo.membermanage.autoid,dbo.membermanage.sex, dbo.membermanage.phone, dbo.membermanage.qq,dbo.membermanage.addr, dbo.membermanage.occupation,dbo.membermanage.birthday, dbo.membermanage.pinyin, dbo.membermanage.balance,dbo.membermanage.sendmark1, dbo.membermanage.sendmark2,dbo.membermanage.psw, dbo.membermanage.cardtype,dbo.membermanage.check1, dbo.membermanage.discount, dbo.memberreg.card2no, dbo.memberreg.date2,dbo.memberreg.dindanid, dbo.memberreg.taoxi,dbo.memberreg.money AS card2money, dbo.memberreg.date as card2date, dbo.memberreg.type from dbo.membermanage LEFT OUTER JOIN dbo.memberreg ON dbo.membermanage.memberno = dbo.memberreg.memberno
GO
/****** 对象:  View [dbo].[memberview]    脚本日期: 01/19/2015 17:10:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[memberview] as select dbo.membermanage.name, dbo.memberreg3.memberno, dbo.memberreg3.money, dbo.memberreg3.date,dbo.memberreg3.clerk, dbo.memberreg3.id, dbo.memberreg3.financecheck, dbo.memberreg3.moneytype, dbo.memberreg3.time from dbo.memberreg3 INNER JOIN dbo.membermanage ON dbo.memberreg3.memberno = dbo.membermanage.memberno
GO
/****** 对象:  View [dbo].[accountview]    脚本日期: 01/19/2015 17:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[accountview] as select dbo.[user].account, dbo.[user].name, dbo.[user].psw, dbo.[user].rights, dbo.[user].rate1, dbo.[user].rate2,dbo.[user].base, dbo.[user].bz, dbo.[user].rights2,dbo.[user].discount, dbo.[user].discount2, dbo.renyuan.dimission, dbo.renyuan.[level],dbo.renyuan.bm from dbo.[user] LEFT OUTER JOIN dbo.renyuan ON dbo.[user].name = dbo.renyuan.name
GO
/****** 对象:  View [dbo].[hospitalview]    脚本日期: 01/19/2015 17:10:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[hospitalview] as select dbo.hospitalclient.id, dbo.hospitalclient.name1, dbo.hospitalclient.name2, dbo.hospitalclient.sex,'birthdaytype' = CASE hospitalclient.birthdaytype WHEN '1' THEN '预产期' ELSE '宝宝生日' END,dbo.hospitalclient.birthday,dbo.hospitalclient.[from], dbo.hospitalclient.phone1, dbo.hospitalclient.phone2, dbo.hospitalclient.qq, dbo.hospitalclient.inputdate, dbo.hospitalclient.inputer,dbo.hospitalclient.pinyin1, dbo.hospitalclient.pinyin2,dbo.hospitalclientcontactreg.businesstype,   dbo.hospitalclientcontactreg.businessintention, dbo.hospitalclientcontactreg.bookingdate,dbo.hospitalclientcontactreg.desaddr,  dbo.hospitalclientcontactreg.businessremark, dbo.hospitalclient.addr1, dbo.hospitalclient.addr2, dbo.hospitalclient.addr3,dbo.hospitalclient.type, dbo.hospitalclient.hospital, dbo.hospitalclient.clerk, dbo.hospitalclientcontactreg.alarmcheck,dbo.hospitalclientcontactreg.alarmdate from dbo.hospitalclient LEFT OUTER JOIN dbo.hospitalclientcontactreg ON dbo.hospitalclient.id = dbo.hospitalclientcontactreg.id
GO