USE [master]
GO
/****** Object:  Database [dbnull]    Script Date: 2014/10/30 11:22:13 ******/
CREATE DATABASE [dbnull] ON  PRIMARY 
( NAME = N'dbnull', FILENAME = N'E:\lyfzbin\Services\\数据\dbnull.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'dbnull_log', FILENAME = N'E:\lyfzbin\Services\数据\dbnull_log.LDF' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
--GO
--ALTER DATABASE [dbnull] SET COMPATIBILITY_LEVEL = 90
--GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [dbnull].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [dbnull] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [dbnull] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [dbnull] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [dbnull] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [dbnull] SET ARITHABORT OFF 
GO
ALTER DATABASE [dbnull] SET AUTO_CLOSE ON 
GO
ALTER DATABASE [dbnull] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [dbnull] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [dbnull] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [dbnull] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [dbnull] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [dbnull] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [dbnull] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [dbnull] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [dbnull] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [dbnull] SET  DISABLE_BROKER 
GO
ALTER DATABASE [dbnull] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [dbnull] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [dbnull] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [dbnull] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [dbnull] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [dbnull] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [dbnull] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [dbnull] SET  MULTI_USER 
GO
ALTER DATABASE [dbnull] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [dbnull] SET DB_CHAINING OFF 
GO
USE [dbnull]
GO
/****** Object:  Table [dbo].[area]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[area](
	[id] [varchar](50) NULL,
	[name] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[bakstate]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[baseexpendtype]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[bumen]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[burncdreg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[burncdreg](
	[id] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[ren] [varchar](50) NULL,
	[remark] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[businessintention]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[businesstype]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[childmsg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[childmsg](
	[check] [varchar](50) NULL,
	[days] [varchar](50) NULL,
	[content] [varchar](max) NULL,
	[mode] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[client]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client](
	[id] [varchar](50) NULL,
	[name1] [varchar](50) NULL,
	[name2] [varchar](50) NULL,
	[phone1] [varchar](50) NULL,
	[phone2] [varchar](50) NULL,
	[qq1] [varchar](50) NULL,
	[qq2] [varchar](50) NULL,
	[addr1] [varchar](50) NULL,
	[addr2] [varchar](50) NULL,
	[occupation1] [varchar](50) NULL,
	[occupation2] [varchar](50) NULL,
	[birthday1] [varchar](50) NULL,
	[birthday2] [varchar](50) NULL,
	[time3] [varchar](50) NULL,
	[area] [varchar](50) NULL,
	[area2] [varchar](50) NULL,
	[check1] [varchar](50) NULL,
	[check2] [varchar](50) NULL,
	[check3] [varchar](50) NULL,
	[sex] [varchar](50) NULL,
	[zodiac] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[client2]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client2](
	[name] [varchar](50) NULL,
	[phone] [varchar](50) NULL,
	[qq] [varchar](50) NULL,
	[addr] [varchar](50) NULL,
	[from] [varchar](50) NULL,
	[reason] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[pinyin] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[sex] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ren] [varchar](50) NULL,
	[birthday] [varchar](50) NULL,
	[check1] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[client2phonerecord]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client2phonerecord](
	[phone] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[client2phonerecordout]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client2phonerecordout](
	[phoneno] [varchar](50) NULL,
	[datetime] [varchar](50) NULL,
	[name] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[client3]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client3](
	[name] [varchar](50) NULL,
	[phone] [varchar](50) NULL,
	[qq] [varchar](50) NULL,
	[addr] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[pinyin] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[sex] [varchar](50) NULL,
	[ren] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dandate] [varchar](50) NULL,
	[name2] [varchar](50) NULL,
	[phone2] [varchar](50) NULL,
	[qq2] [varchar](50) NULL,
	[birthday] [varchar](50) NULL,
	[birthday2] [varchar](50) NULL,
	[time3] [varchar](50) NULL,
	[taoxiname] [varchar](50) NULL,
	[taoxijiage] [varchar](50) NULL,
	[check1] [varchar](50) NULL,
	[check2] [varchar](50) NULL,
	[check3] [varchar](50) NULL,
	[pinyin2] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[client3phonerecord]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client3phonerecord](
	[phone] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[client3phonerecordout]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client3phonerecordout](
	[phoneno] [varchar](50) NULL,
	[datetime] [varchar](50) NULL,
	[name] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[clientfrom]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[clientfrom](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[clientqequirement]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[clientreason]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[clientreason](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[clienttype]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[digitalwork]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[digitalwork](
	[id] [varchar](50) NULL,
	[waiter1] [varchar](50) NULL,
	[waiter2] [varchar](50) NULL,
	[waiter3] [varchar](50) NULL,
	[date1] [varchar](50) NULL,
	[date2] [varchar](50) NULL,
	[date3] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dindan]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindan](
	[id] [varchar](50) NULL,
	[money1] [varchar](50) NULL,
	[money2] [varchar](50) NULL,
	[money3] [varchar](50) NULL,
	[name1] [varchar](50) NULL,
	[name2] [varchar](50) NULL,
	[taoxiid] [varchar](50) NULL,
	[taoxiname] [varchar](50) NULL,
	[taoxijiage] [varchar](50) NULL,
	[taoxizs] [varchar](50) NULL,
	[time1] [varchar](50) NULL,
	[time2] [varchar](50) NULL,
	[time3] [varchar](50) NULL,
	[bm] [varchar](50) NULL,
	[ren] [varchar](50) NULL,
	[discount] [varchar](50) NULL,
	[payed1] [varchar](50) NULL,
	[payed2] [varchar](50) NULL,
	[payed3] [varchar](50) NULL,
	[payed4] [varchar](50) NULL,
	[payed5] [varchar](50) NULL,
	[time4] [varchar](50) NULL,
	[time5] [varchar](50) NULL,
	[takezs] [varchar](50) NULL,
	[choosezs] [varchar](50) NULL,
	[status] [varchar](50) NULL,
	[clothescount2] [varchar](50) NULL,
	[outside2] [varchar](50) NULL,
	[style] [varchar](50) NULL,
	[payed3time] [varchar](50) NULL,
	[payed4ren] [varchar](50) NULL,
	[payed4time] [varchar](50) NULL,
	[status2] [varchar](50) NULL,
	[status3] [varchar](50) NULL,
	[waiter1] [varchar](50) NULL,
	[waiter2] [varchar](50) NULL,
	[waiter3] [varchar](50) NULL,
	[waiter4] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[taketime] [varchar](50) NULL,
	[clothescount] [varchar](50) NULL,
	[outside] [varchar](50) NULL,
	[bz2] [varchar](max) NULL,
	[bz3] [varchar](max) NULL,
	[urgent] [varchar](50) NULL,
	[status4] [varchar](50) NULL,
	[status5] [varchar](50) NULL,
	[waiter5] [varchar](50) NULL,
	[waiter6] [varchar](50) NULL,
	[pinyin1] [varchar](50) NULL,
	[pinyin2] [varchar](50) NULL,
	[waiter7] [varchar](50) NULL,
	[status6] [varchar](50) NULL,
	[phone1] [varchar](50) NULL,
	[phone2] [varchar](50) NULL,
	[status7] [varchar](50) NULL,
	[memberno] [varchar](50) NULL,
	[waiter8] [varchar](50) NULL,
	[time6] [varchar](50) NULL,
	[status8] [varchar](50) NULL,
	[bruncount] [varchar](50) NULL,
	[tichenren1] [varchar](50) NULL,
	[tichenren2] [varchar](50) NULL,
	[tichenren3] [varchar](50) NULL,
	[tichenren4] [varchar](50) NULL,
	[tichenren5] [varchar](50) NULL,
	[send1] [varchar](50) NULL,
	[send2] [varchar](50) NULL,
	[send3] [varchar](50) NULL,
	[datetime4] [varchar](50) NULL,
	[datetime5] [varchar](50) NULL,
	[datetime6] [varchar](50) NULL,
	[waiter12] [varchar](50) NULL,
	[waiter22] [varchar](50) NULL,
	[waiter1rate] [varchar](50) NULL,
	[waiter2rate] [varchar](50) NULL,
	[waiter13] [varchar](50) NULL,
	[waiter14] [varchar](50) NULL,
	[waiter23] [varchar](50) NULL,
	[waiter24] [varchar](50) NULL,
	[waiter12rate] [varchar](50) NULL,
	[waiter13rate] [varchar](50) NULL,
	[waiter14rate] [varchar](50) NULL,
	[waiter22rate] [varchar](50) NULL,
	[waiter23rate] [varchar](50) NULL,
	[waiter24rate] [varchar](50) NULL,
	[ren2] [varchar](50) NULL,
	[renrate] [varchar](50) NULL,
	[ren2rate] [varchar](50) NULL,
	[txtype] [varchar](50) NULL,
	[delphotos] [varchar](max) NULL,
	[growthtxselname] [varchar](max) NULL,
	[delphotos2] [varchar](max) NULL,
	[designno] [varchar](max) NULL,
	[designreplaceno] [varchar](max) NULL,
	[size] [varchar](max) NULL,
	[dindantype] [varchar](50) NULL,
	[contractno1] [varchar](50) NULL,
	[contractno2] [varchar](50) NULL,
	[cfno] [varchar](50) NULL,
	[calldate] [varchar](50) NULL,
	[from] [varchar](50) NULL,
	[reason] [varchar](50) NULL,
	[time7] [varchar](50) NULL,
	[time8] [varchar](50) NULL,
	[time9] [varchar](50) NULL,
	[time10] [varchar](50) NULL,
	[authorize] [varchar](50) NULL,
	[discount2] [varchar](50) NULL,
	[authorize2] [varchar](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,
	[curno] [nvarchar](50) NULL,
	[xplrr] [nvarchar](50) NULL,
	[xplrtime] [nvarchar](50) NULL,
	[ImageStatus] [numeric](6, 0) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dindanbukuan]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[ren] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[kind] [varchar](50) NULL,
	[ren2] [varchar](50) NULL,
	[item] [nvarchar](max) NULL,
	[paytype] [varchar](50) NULL,
	[jdd] [varchar](50) NULL,
	[financecheck] [nvarchar](10) NULL,
	[discount] [nvarchar](50) NULL,
	[time] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dindanbukuan2]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[ren] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[bz] [nvarchar](500) NULL,
	[kind] [varchar](50) NULL,
	[ren2] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dindanjd]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindanjd](
	[id] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[date] [nvarchar](50) NULL,
	[time] [varchar](50) NULL,
	[waiter1] [varchar](50) NULL,
	[waiter2] [varchar](50) NULL,
	[status] [varchar](50) NULL,
	[waiter12] [varchar](50) NULL,
	[waiter22] [varchar](50) NULL,
	[bookingdate] [varchar](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
/****** Object:  Table [dbo].[dindansp]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindansp](
	[id] [varchar](20) NULL,
	[spid] [varchar](15) NULL,
	[shuliang] [nvarchar](120) NULL,
	[kind] [nvarchar](10) NULL,
	[price] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[no] [varchar](max) NULL,
	[status1] [varchar](50) NULL,
	[status2] [varchar](50) NULL,
	[status3] [varchar](50) NULL,
	[status4] [varchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[date1] [varchar](50) NULL,
	[date2] [varchar](50) NULL,
	[date3] [varchar](50) NULL,
	[date4] [varchar](50) NULL,
	[name1] [varchar](50) NULL,
	[name2] [varchar](50) NULL,
	[name3] [varchar](50) NULL,
	[name4] [varchar](50) NULL,
	[hqdate] [varchar](50) NULL,
	[hqtime] [varchar](50) NULL,
	[urgent] [varchar](50) NULL,
	[taketime] [varchar](50) NULL,
	[no2] [varchar](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] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dindansp2]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindansp2](
	[id] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[count] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[clerk] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dindansp3]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dindansp3](
	[id] [varchar](50) NULL,
	[spid] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[count] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dressarea]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dressarea](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dresshire]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dresshire](
	[money] [varchar](50) NULL,
	[money2] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[clerk] [varchar](50) NULL,
	[hireorsale] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[phone] [varchar](50) NULL,
	[id] [varchar](50) NULL,
	[remark] [varchar](max) NULL,
	[date1] [varchar](50) NULL,
	[date2] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dresshiredata]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dresshiredata](
	[id] [varchar](50) NULL,
	[no] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[count] [varchar](50) NULL,
	[isreturn] [varchar](50) NULL,
	[returndate] [varchar](50) NULL,
	[clerk] [varchar](50) NULL,
	[hireorsale] [varchar](50) NULL,
	[date1] [varchar](50) NULL,
	[date2] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dressinfo]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dressinfo](
	[type] [varchar](50) NULL,
	[no] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[count] [varchar](50) NULL,
	[price1] [varchar](50) NULL,
	[price2] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[hirecount] [varchar](50) NULL,
	[salecount] [varchar](50) NULL,
	[balance] [varchar](50) NULL,
	[remark] [varchar](max) NULL,
	[dressarea] [varchar](50) NULL,
	[washcount] [varchar](50) NULL,
	[type2] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[dresstype]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dresstype](
	[name] [varchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[type] [nvarchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[employeephonerecord]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[employeephonerecord](
	[name] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[employeephonerecordout]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[employeephonerecordout](
	[name] [varchar](50) NULL,
	[phoneno] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[expendtype]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[expendtype](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[files]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[files](
	[FileNO] [int] IDENTITY(1,1) NOT NULL,
	[PartNO] [int] NULL,
	[FileType] [int] NULL,
	[FilesName] [varchar](256) NULL,
	[FileRemark] [varchar](256) NULL,
	[Width] [int] NULL,
	[Height] [int] NULL,
	[AddTime] [datetime] NULL,
	[OrderNO] [int] NULL,
	[Del] [tinyint] NULL,
 CONSTRAINT [PK_FILES] PRIMARY KEY CLUSTERED 
(
	[FileNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[fixedassets]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[framesize]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[framesize](
	[name] [varchar](50) NULL,
	[width] [varchar](50) NULL,
	[height] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[gongyingshang]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[gongyingshang](
	[gyid] [varchar](20) NULL,
	[gyname] [varchar](30) NULL,
	[addr] [varchar](30) NULL,
	[tel] [varchar](20) NULL,
	[fax] [varchar](8) NULL,
	[netaddress] [varchar](20) NULL,
	[bz] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[growthtx]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[growthtx](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[gudingfeiyong]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[dat] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[renyuan1] [varchar](50) NULL,
	[renyuan2] [varchar](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
/****** Object:  Table [dbo].[gudingfeiyongxiangmu]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](20) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[historydb]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[historydb](
	[year] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[hospital]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[hospitalclient]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[hospitalclientcontactreg]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[insidemsg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[insidemsg](
	[timestamp] [varchar](50) NULL,
	[content] [varchar](max) NULL,
	[sender] [varchar](50) NULL,
	[receiver] [varchar](max) NULL,
	[receiver2] [varchar](max) NULL,
	[file] [nvarchar](max) NULL,
	[files] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[jd]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[jd](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[jdd]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[jdd](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[log]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[log](
	[date] [varchar](50) NULL,
	[datetime] [varchar](50) NULL,
	[content] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[loginsign]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[loginsign](
	[name] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[cleck] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[loninbanset]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[loninbanset](
	[weekname] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[banname1] [varchar](50) NULL,
	[banname2] [varchar](50) NULL,
	[banname3] [varchar](50) NULL,
	[banname4] [varchar](50) NULL,
	[banname5] [varchar](50) NULL,
	[banname6] [varchar](50) NULL,
	[banname7] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[lonindata]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[lonindata](
	[no] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[lonintimeset]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[lonintimeset](
	[name] [varchar](50) NULL,
	[time1] [varchar](50) NULL,
	[time2] [varchar](50) NULL,
	[time3] [varchar](50) NULL,
	[time4] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[membercard2]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard2](
	[memberno] [varchar](50) NULL,
	[card2no] [varchar](50) NULL,
	[date] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[membercard2blue]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard2blue](
	[memberno] [varchar](50) NULL,
	[card2no] [varchar](50) NULL,
	[date] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[membercard3]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard3](
	[memberno] [varchar](50) NULL,
	[card2no] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[balance] [varchar](50) NULL,
	[psw] [nvarchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[membercard3childusereg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard3childusereg](
	[memberno] [varchar](50) NULL,
	[dindanid] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[membercard3usereg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membercard3usereg](
	[memberno] [varchar](50) NULL,
	[dindanid] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[membermanage]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membermanage](
	[memberno] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[sex] [varchar](50) NULL,
	[phone] [varchar](50) NULL,
	[qq] [varchar](50) NULL,
	[addr] [varchar](50) NULL,
	[occupation] [varchar](50) NULL,
	[birthday] [varchar](50) NULL,
	[pinyin] [varchar](50) NULL,
	[balance] [varchar](50) NULL,
	[sendmark1] [varchar](max) NULL,
	[sendmark2] [varchar](max) NULL,
	[psw] [nvarchar](50) NULL,
	[cardtype] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[discount] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[membermanageblue]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[membermanageblue](
	[memberno] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[sex] [varchar](50) NULL,
	[phone] [varchar](50) NULL,
	[qq] [varchar](50) NULL,
	[addr] [varchar](50) NULL,
	[occupation] [varchar](50) NULL,
	[birthday] [varchar](50) NULL,
	[pinyin] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[jiage] [varchar](50) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[money2] [varchar](50) NULL,
	[money3] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[memberreg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg](
	[memberno] [varchar](50) NULL,
	[dindanid] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[date] [varchar](50) NULL,
	[card2no] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[taoxi] [varchar](50) NULL,
	[date2] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[memberreg2]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg2](
	[memberno] [varchar](50) NULL,
	[dindanid] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[point] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[memberreg2blue]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg2blue](
	[memberno] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[date] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[memberreg3]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg3](
	[memberno] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[clerk] [varchar](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
/****** Object:  Table [dbo].[memberreg4]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberreg4](
	[memberno] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[card2no] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[clerk] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[memberregblue]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[memberregblue](
	[memberno] [varchar](50) NULL,
	[dindanid] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[card2no] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[taoxi] [varchar](50) NULL,
	[date2] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[misscallrecord]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[misscallrecord](
	[phone] [varchar](50) NULL,
	[datetime] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[type] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[msgcode]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[msgtemp]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[msgtemp](
	[title] [varchar](50) NULL,
	[content] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[msgtemp2]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[msgtemp2](
	[name] [varchar](50) NULL,
	[content1] [varchar](max) NULL,
	[content2] [varchar](max) NULL,
	[check1] [varchar](50) NULL,
	[check2] [varchar](50) NULL,
	[point] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[mywork]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mywork](
	[id] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[datetime] [varchar](50) NULL,
	[count1] [varchar](50) NULL,
	[count2] [varchar](50) NULL,
	[count3] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[inputdate] [varchar](50) NULL,
	[inputren] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Part]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Part](
	[PartNO] [int] IDENTITY(1,1) NOT NULL,
	[ParentNO] [int] NULL,
	[PartName] [varchar](255) NULL,
	[AddDate] [datetime] NULL,
	[Del] [tinyint] NULL,
	[Disable] [tinyint] NULL,
 CONSTRAINT [PK_PART] PRIMARY KEY CLUSTERED 
(
	[PartNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[path]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[path](
	[path1] [varchar](50) NULL,
	[path2] [varchar](50) NULL,
	[path3] [varchar](50) NULL,
	[path4] [varchar](50) NULL,
	[path5] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[phonerecord]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[phonerecord](
	[id] [varchar](50) NULL,
	[phoneno] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[phonerecordout]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[phonerecordout](
	[name] [varchar](50) NULL,
	[phoneno] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[photoprint]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[photoprint](
	[id] [varchar](50) NULL,
	[name] [varchar](100) NULL,
	[count] [varchar](50) NULL,
	[status1] [varchar](50) NULL,
	[status2] [varchar](50) NULL,
	[time1] [varchar](50) NULL,
	[time2] [varchar](50) NULL,
	[area] [varchar](50) NULL,
	[statusOfReWork] [nvarchar](50) NULL,
	[timeOfReWork] [nvarchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[renyuan]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[renyuan](
	[bm] [varchar](50) NULL,
	[id] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[sex] [varchar](50) NULL,
	[phone] [varchar](50) NULL,
	[address] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[base] [varchar](50) NULL,
	[rate1] [varchar](50) NULL,
	[rate2] [varchar](50) NULL,
	[bz2] [varchar](max) NULL,
	[address2] [varchar](50) NULL,
	[idno] [varchar](50) NULL,
	[marry] [varchar](50) NULL,
	[dimission] [varchar](50) NULL,
	[rate3] [varchar](50) NULL,
	[rate4] [varchar](50) NULL,
	[rate5] [varchar](50) NULL,
	[loginno1] [varchar](50) NULL,
	[loginno2] [varchar](50) NULL,
	[photo] [image] NULL,
	[level] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[rewards]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rewards](
	[name] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[execute] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[renyuan] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[salary]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[salary](
	[name] [varchar](50) NULL,
	[year] [varchar](50) NULL,
	[month] [varchar](50) NULL,
	[money] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sale2type]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[sendreg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendreg](
	[timestamp] [varchar](50) NULL,
	[msgcount] [varchar](50) NULL,
	[log] [varchar](50) NULL,
	[status] [varchar](50) NULL,
	[issended] [varchar](50) NULL,
	[isautosend] [varchar](50) NULL,
	[phones] [varchar](max) NULL,
	[content] [varchar](max) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[ren] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sendreg2]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendreg2](
	[price] [varchar](50) NULL,
	[yytime] [varchar](50) NULL,
	[client] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[phones] [varchar](max) NULL,
	[content] [varchar](max) NULL,
	[autoid] [int] IDENTITY(1,1) NOT NULL,
	[ren] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sendregcard]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendregcard](
	[timestamp] [varchar](50) NULL,
	[phones] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sendregdelay]    Script Date: 2014/10/30 11:22:13 ******/
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
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sendregreceive]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sendregreceive](
	[timestamp] [varchar](50) NULL,
	[phones] [varchar](200) NULL,
	[content] [varchar](200) NULL,
	[status] [varchar](200) NULL,
	[getid] [nvarchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[shangpin]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[shangpin](
	[spid] [nvarchar](50) NOT NULL,
	[spname] [varchar](50) NULL,
	[spdanwei] [varchar](50) NULL,
	[spjiaga1] [varchar](50) NULL,
	[spjiage2] [varchar](50) NULL,
	[splb] [varchar](50) NULL,
	[spbz] [varchar](max) NULL,
	[spjiage3] [varchar](50) NULL,
	[hide] [nvarchar](10) NULL,
 CONSTRAINT [PK_shangpin] PRIMARY KEY CLUSTERED 
(
	[spid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[shangpinlb]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[singleincome]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](50) NULL,
	[money] [varchar](50) NULL,
	[dat] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[renyuan1] [varchar](50) NULL,
	[renyuan2] [varchar](50) NULL,
	[renyuan3] [varchar](50) NULL,
	[sale2type] [varchar](50) NULL,
	[paytype] [varchar](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] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[singleincomemoney]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[storeinfo]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[storeinfo](
	[id] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[count] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[clerk] [varchar](50) NULL,
	[remark] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[storeinfo2]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[storeinfo2](
	[id] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[count] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[clerk] [varchar](50) NULL,
	[remark] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[taoxi]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[taoxi](
	[taoxiid] [nvarchar](50) NULL,
	[taoxiname] [varchar](20) NULL,
	[taoxijiage] [varchar](9) NULL,
	[zs] [nvarchar](50) NULL,
	[type] [nvarchar](50) NULL,
	[show] [nvarchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[taoxifg]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[taoxifg](
	[name] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[taoxishangpin1]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](20) NULL,
	[spid1] [varchar](15) NULL,
	[shuliang] [varchar](15) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[taoxishangpin2]    Script Date: 2014/10/30 11:22:13 ******/
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] [varchar](15) NULL,
	[spid2] [varchar](15) NULL,
	[shuliang] [varchar](15) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[todaytake]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[todaytake](
	[name] [varchar](50) NULL,
	[phone] [varchar](50) NULL,
	[date] [varchar](50) NULL,
	[time] [varchar](50) NULL,
	[type] [varchar](50) NULL,
	[price] [varchar](50) NULL,
	[waiter1] [varchar](50) NULL,
	[waiter2] [varchar](50) NULL,
	[receptionist] [varchar](50) NULL,
	[arrearage] [varchar](50) NULL,
	[clerk] [varchar](50) NULL,
	[remark] [varchar](max) NULL,
	[timestamp] [varchar](50) NULL,
	[content] [varchar](50) NULL,
	[mode] [varchar](50) NULL,
	[arrive] [varchar](50) NULL,
	[id] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[txlb]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[txlb](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[txlb2]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[unknownphonerecord]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unknownphonerecord](
	[phone] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[unknownphonerecordout]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[unknownphonerecordout](
	[phoneno] [varchar](50) NULL,
	[datetime] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[update]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  Table [dbo].[user]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user](
	[account] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[psw] [varchar](50) NULL,
	[rights] [nvarchar](80) NULL,
	[rate1] [varchar](50) NULL,
	[rate2] [varchar](50) NULL,
	[base] [varchar](50) NULL,
	[bz] [varchar](max) NULL,
	[rights2] [varchar](max) NULL,
	[discount] [varchar](50) NULL,
	[discount2] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[version]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[version](
	[version] [varchar](50) NULL,
	[curdate] [varchar](50) NULL,
	[check1] [varchar](50) NULL,
	[check2] [varchar](50) NULL,
	[check3] [varchar](50) NULL,
	[check4] [varchar](50) NULL,
	[edit1] [varchar](50) NULL,
	[edit2] [varchar](50) NULL,
	[edit3] [varchar](50) NULL,
	[edit4] [varchar](50) NULL,
	[info1] [varchar](50) NULL,
	[info2] [varchar](50) NULL,
	[info3] [varchar](50) NULL,
	[info4] [varchar](50) NULL,
	[info5] [varchar](50) NULL,
	[bak1] [varchar](50) NULL,
	[bak2] [varchar](50) NULL,
	[bak3] [varchar](50) NULL,
	[bak4] [varchar](50) NULL,
	[bak5] [varchar](50) NULL,
	[bak6] [varchar](50) NULL,
	[baktime] [varchar](50) NULL,
	[bakserver1] [varchar](50) NULL,
	[bakserver2] [varchar](50) NULL,
	[bakserver3] [varchar](50) NULL,
	[bakserver4] [varchar](50) NULL,
	[bakserver5] [varchar](50) NULL,
	[msgaccount] [varchar](50) NULL,
	[msgpsw] [varchar](50) NULL,
	[msgused] [varchar](50) NULL,
	[msgbalance] [varchar](50) NULL,
	[msgcheck1] [varchar](50) NULL,
	[msgcheck2] [varchar](50) NULL,
	[msgdays1] [varchar](50) NULL,
	[msgdays2] [varchar](50) NULL,
	[msgcontent1] [nvarchar](max) NULL,
	[msgcontent2] [nvarchar](max) NULL,
	[remarks] [varchar](max) NULL,
	[rate] [varchar](50) NULL,
	[msgcheck3] [varchar](50) NULL,
	[msgcontent3] [nvarchar](max) NULL,
	[salarycheck1] [varchar](50) NULL,
	[salarycheck2] [varchar](50) NULL,
	[msgcheck4] [varchar](50) NULL,
	[msgtime] [varchar](50) NULL,
	[msgphones] [varchar](max) NULL,
	[info6] [varchar](50) NULL,
	[msgcompanyname] [varchar](50) NULL,
	[msgphones2] [varchar](max) NULL,
	[msgsendtype] [varchar](50) NULL,
	[msgcontent5] [varchar](max) NULL,
	[msgcheck5] [varchar](50) NULL,
	[msgcontent6] [varchar](max) NULL,
	[msgcheck6] [varchar](50) NULL,
	[cardlength] [varchar](50) NULL,
	[salarycheck3] [varchar](50) NULL,
	[salarycheck4] [varchar](50) NULL,
	[setcheck1] [varchar](50) NULL,
	[setcheck2] [varchar](50) NULL,
	[setcheck3] [varchar](50) NULL,
	[setcheck4] [varchar](50) NULL,
	[setcheck5] [varchar](50) NULL,
	[printer1] [varchar](50) NULL,
	[printer2] [varchar](50) NULL,
	[printer3] [varchar](50) NULL,
	[setprintstyle] [varchar](50) NULL,
	[uploadcheck1] [varchar](50) NULL,
	[uploadcheck2] [varchar](50) NULL,
	[uploadcheck3] [varchar](50) NULL,
	[uploadcheck4] [varchar](50) NULL,
	[bak11] [varchar](50) NULL,
	[bak22] [varchar](50) NULL,
	[bak33] [varchar](50) NULL,
	[bak44] [varchar](50) NULL,
	[setprintstyle2] [varchar](50) NULL,
	[setcheck10] [varchar](50) NULL,
	[ziptype1] [varchar](50) NULL,
	[ziptype2] [varchar](50) NULL,
	[ziptype3] [varchar](50) NULL,
	[ziptype4] [varchar](50) NULL,
	[salaryset] [varchar](max) NULL,
	[limitcount1] [varchar](50) NULL,
	[limitcount2] [varchar](50) NULL,
	[limitcount3] [varchar](50) NULL,
	[rate2] [varchar](50) NULL,
	[setcheck11] [varchar](50) NULL,
	[setcheck12] [varchar](50) NULL,
	[setprintstyle3] [varchar](50) NULL,
	[msgcheck7] [varchar](50) NULL,
	[msgcheck8] [varchar](50) NULL,
	[msgcheck9] [varchar](50) NULL,
	[msgcheck10] [varchar](50) NULL,
	[msgcontent8] [varchar](max) NULL,
	[msgcontent9] [varchar](max) NULL,
	[msgcontent10] [varchar](max) NULL,
	[setcheck13] [varchar](50) NULL,
	[time1] [varchar](50) NULL,
	[time2] [varchar](50) NULL,
	[time3] [varchar](50) NULL,
	[setcheck14] [varchar](50) NULL,
	[setcheck15] [varchar](50) NULL,
	[msgcheck11] [varchar](50) NULL,
	[msgcheck12] [varchar](50) NULL,
	[msgcheck13] [varchar](50) NULL,
	[msgcheck14] [varchar](50) NULL,
	[msgcontent11] [varchar](max) NULL,
	[msgcontent12] [varchar](max) NULL,
	[msgcontent13] [varchar](max) NULL,
	[msgcontent14] [varchar](max) NULL,
	[setcheck6] [varchar](50) NULL,
	[msgcheck15] [varchar](50) NULL,
	[msgcontent15] [varchar](max) NULL,
	[logdays] [varchar](50) NULL,
	[setcheck17] [varchar](50) NULL,
	[setcheck18] [varchar](50) NULL,
	[setcheck19] [varchar](50) NULL,
	[uploadrule] [varchar](max) NULL,
	[setcheck20] [varchar](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
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[workrate]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[workrate](
	[type] [varchar](50) NULL,
	[data1] [varchar](50) NULL,
	[data2] [varchar](50) NULL,
	[data3] [varchar](50) NULL,
	[data4] [varchar](50) NULL,
	[data5] [varchar](50) NULL,
	[data6] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[worktype]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[worktype](
	[name] [varchar](50) NULL,
	[id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[xtcs]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[xtcs](
	[csm] [varchar](256) NULL,
	[csz] [varchar](256) NULL,
	[bz] [varchar](256) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  View [dbo].[accountview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[alarmview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[digitalview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanbukuanview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanbukuanview2]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanclient]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanspview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanspview2]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanspview3]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanspview4]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dindanview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[dressview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[hospitalview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[hqview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[memberview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[memberview2]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[memberview3]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[msgview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[photoprintview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[qjview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[singleincomemoneyview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[takeview]    Script Date: 2014/10/30 11:22:13 ******/
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
/****** Object:  View [dbo].[taoxishangpinview]    Script Date: 2014/10/30 11:22:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[taoxishangpinview]
AS
SELECT     dbo.taoxishangpin1.id,dbo.taoxishangpin1.spid1,dbo.shangpin.spname, dbo.shangpin.spjiaga1, dbo.taoxishangpin1.taoxiid,dbo.taoxishangpin1.shuliang 
FROM         dbo.taoxi INNER JOIN
                      dbo.taoxishangpin1 ON dbo.taoxi.taoxiid = dbo.taoxishangpin1.taoxiid INNER JOIN
                      dbo.shangpin ON dbo.taoxishangpin1.spid1 = dbo.shangpin.spid

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[bumen]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [id] ON [dbo].[client]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [id] ON [dbo].[dindan]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [taoxiid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [taoxiid] ON [dbo].[dindan]
(
	[taoxiid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [autoid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [autoid] ON [dbo].[dindanbukuan]
(
	[autoid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[dindanbukuan]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [autoid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [autoid] ON [dbo].[dindanbukuan2]
(
	[autoid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[dindanbukuan2]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [autoid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [autoid] ON [dbo].[dindansp]
(
	[autoid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [spid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [spid] ON [dbo].[dindansp]
(
	[spid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [taoxiid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [taoxiid] ON [dbo].[dindansp]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [gyid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [gyid] ON [dbo].[gongyingshang]
(
	[gyid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [gyname]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [gyname] ON [dbo].[gongyingshang]
(
	[gyname] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [id] ON [dbo].[gudingfeiyong]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[gudingfeiyongxiangmu]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[photoprint]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [id] ON [dbo].[renyuan]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [name]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [name] ON [dbo].[renyuan]
(
	[name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[shangpinlb]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [name]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [name] ON [dbo].[shangpinlb]
(
	[name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [id] ON [dbo].[singleincome]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [id] ON [dbo].[taoxi]
(
	[taoxiid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PrimaryKey]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [PrimaryKey] ON [dbo].[taoxi]
(
	[taoxiid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [taoxiname]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [taoxiname] ON [dbo].[taoxi]
(
	[taoxiname] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[taoxishangpin1]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [spid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [spid] ON [dbo].[taoxishangpin1]
(
	[spid1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [taoxiid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [taoxiid] ON [dbo].[taoxishangpin1]
(
	[taoxiid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [id]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [id] ON [dbo].[taoxishangpin2]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [spid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [spid] ON [dbo].[taoxishangpin2]
(
	[spid2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [taoxiid]    Script Date: 2014/10/30 11:22:13 ******/
CREATE NONCLUSTERED INDEX [taoxiid] ON [dbo].[taoxishangpin2]
(
	[taoxiid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [account]    Script Date: 2014/10/30 11:22:13 ******/
CREATE UNIQUE NONCLUSTERED INDEX [account] ON [dbo].[user]
(
	[account] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dindan] ADD  DEFAULT ((0)) FOR [ImageStatus]
GO
ALTER TABLE [dbo].[files] ADD  DEFAULT ((1)) FOR [FileType]
GO
ALTER TABLE [dbo].[files] ADD  DEFAULT (getdate()) FOR [AddTime]
GO
ALTER TABLE [dbo].[files] ADD  DEFAULT ((0)) FOR [Del]
GO
ALTER TABLE [dbo].[Part] ADD  DEFAULT (getdate()) FOR [AddDate]
GO
ALTER TABLE [dbo].[Part] ADD  DEFAULT ((0)) FOR [Del]
GO
ALTER TABLE [dbo].[Part] ADD  DEFAULT ((1)) FOR [Disable]
GO
ALTER TABLE [dbo].[shangpin] ADD  CONSTRAINT [DF_shangpin_spid]  DEFAULT ('0') FOR [spid]
GO
USE [master]
GO
ALTER DATABASE [dbnull] SET  READ_WRITE 
GO