if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarHR_Pay]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarHR_Pay]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarHR_PayType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarHR_PayType]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarHR_Porf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarHR_Porf]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarHR_ProfType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarHR_ProfType]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Ad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Ad]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Adlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Adlog]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Case]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Case]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Download]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Download]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Feedback]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Feedback]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Link]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Link]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_NewType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_NewType]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_News]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_News]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Review]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Review]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Sitelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Sitelog]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Skin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Skin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_User]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_VoteItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_VoteItem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_VoteTitle]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_VoteTitle]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StarSite_Votelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StarSite_Votelog]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Action]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Action]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Advise]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Advise]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Agent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Agent]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Bargain]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Bargain]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_BargainEm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_BargainEm]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_BuyOrder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_BuyOrder]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_BuyOrderDetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_BuyOrderDetail]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_CATEGORIES]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_CATEGORIES]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_ChairTalk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_ChairTalk]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Chart]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Chart]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_City]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_City]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Client]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Client]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Communion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Communion]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Company]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Company]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Compete]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Compete]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Config]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_ConfigType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_ConfigType]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Country]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Country]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_DepartMent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_DepartMent]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_DepartTask]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_DepartTask]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Employee]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Employee]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Field]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Field]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_FieldInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_FieldInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_FieldType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_FieldType]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_File]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_File]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Id]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Id]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Image]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Image]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Knowledge]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Knowledge]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Leave]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Leave]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Linkman]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Linkman]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_LogDo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_LogDo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_LogLogin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_LogLogin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Meeting]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Meeting]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Message]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_MoneyLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_MoneyLog]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_NeedMoney]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_NeedMoney]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_NeedReimb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_NeedReimb]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Note]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Note]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Notes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Notes]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Object]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Object]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_ObjectLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_ObjectLog]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Orders]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_OutSide]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_OutSide]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_PayPre]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_PayPre]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_PriceReport]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_PriceReport]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_PriceReportDetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_PriceReportDetail]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Product]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Product]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Project]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Project]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Provide]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Provide]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Province]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Province]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_RepairCard]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_RepairCard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Repine]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Repine]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Sale]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Sale]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_SaleDetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_SaleDetail]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_SaleProduct]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_SaleProduct]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_SaleProductCancel]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_SaleProductCancel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Service]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Service]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_ShortBoard]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_ShortBoard]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_StoreProduct]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_StoreProduct]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_StoreProductCancel]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_StoreProductCancel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Storehouse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Storehouse]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Task]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Task]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_Url]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_Url]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_WNL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_WNL]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_WorkForm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_WorkForm]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Wsdn_StarCRM_WorkLogs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Wsdn_StarCRM_WorkLogs]
GO

CREATE TABLE [dbo].[StarHR_Pay] (
	[StarHR_id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarHR_Eid] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_year] [int] NULL ,
	[StarHR_month] [int] NULL ,
	[StarHR_week] [int] NULL ,
	[StarHR_fromtime] [datetime] NULL ,
	[StarHR_totime] [datetime] NULL ,
	[StarHR_writeman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_date] [datetime] NULL ,
	[StarHR_time] [datetime] NULL ,
	[StarHR_base] [money] NULL ,
	[StarHR_bonus] [money] NULL ,
	[StarHR_plus1] [money] NULL ,
	[StarHR_plus2] [money] NULL ,
	[StarHR_plus3] [money] NULL ,
	[StarHR_plus4] [money] NULL ,
	[StarHR_plus5] [money] NULL ,
	[StarHR_plus6] [money] NULL ,
	[StarHR_plus7] [money] NULL ,
	[StarHR_plus8] [money] NULL ,
	[StarHR_plus9] [money] NULL ,
	[StarHR_reduce1] [money] NULL ,
	[StarHR_reduce2] [money] NULL ,
	[StarHR_reduce3] [money] NULL ,
	[StarHR_reduce4] [money] NULL ,
	[StarHR_reduce5] [money] NULL ,
	[StarHR_reduce6] [money] NULL ,
	[StarHR_reduce7] [money] NULL ,
	[StarHR_reduce8] [money] NULL ,
	[StarHR_reduce9] [money] NULL ,
	[StarHR_real] [money] NULL ,
	[isget] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarHR_PayType] (
	[StarHR_plus1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus4] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus5] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus6] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus7] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus8] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_plus9] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce4] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce5] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce6] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce7] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce8] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_reduce9] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarHR_Porf] (
	[StarHR_id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarHR_Eid] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_year] [int] NULL ,
	[StarHR_month] [int] NULL ,
	[StarHR_week] [int] NULL ,
	[StarHR_fromtime] [datetime] NULL ,
	[StarHR_totime] [datetime] NULL ,
	[StarHR_rate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_writeman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_time] [datetime] NULL ,
	[StarHR_main] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_mainrate] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex1rate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex2rate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex3] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex3rate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex4] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex4rate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex5] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex5rate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex6] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_ex6rate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_good] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_bad] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarHR_ProfType] (
	[StarHR_Ex1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_Ex2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_Ex3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_Ex4] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_Ex5] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarHR_Ex6] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Ad] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[StarSite_url] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_num] [int] NULL ,
	[StarSite_image] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Istop] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Adlog] (
	[StarSite_Id] [int] NOT NULL ,
	[StarSite_Fid] [int] NULL ,
	[StarSite_ip] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Case] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[StarSite_near] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_num] [int] NULL ,
	[StarSite_keyword] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_poster] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Download] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_size] [int] NULL ,
	[StarSite_import] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_url] [char] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_url2] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_url3] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_comurl] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_num] [int] NULL ,
	[StarSite_poster] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Feedback] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_poster] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[StarSite_info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_Email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Link] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_url] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_num] [int] NULL ,
	[StarSite_poster] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_NewType] (
	[StarSite_id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_order] [int] NULL ,
	[StarSite_info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_News] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[StarSite_type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_import] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_num] [int] NULL ,
	[StarSite_keyword] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_near] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_poster] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Review] (
	[StarSite_id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_fid] [int] NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_info] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Sitelog] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[StarSite_from] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_to] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Skin] (
	[StarSite_Skin] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_SiteName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_Right] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_Intro] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_Welcome] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_Image] [image] NULL ,
	[StarSite_ImageUrl] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_User] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_sex] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_company] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_cphone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_address] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_postnum] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_mobile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_regtime] [datetime] NULL ,
	[StarSite_logtime] [datetime] NULL ,
	[StarSite_num] [int] NULL ,
	[StarSite_info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_VoteItem] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_Fid] [int] NULL ,
	[StarSite_name] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_num] [int] NULL ,
	[AnswerPercent] [int] NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[checkORradio] [char] (6) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_VoteTitle] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_name] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[checkORradio] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[ListOrder] [int] NULL ,
	[IsInput] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[StartDate] [datetime] NULL ,
	[EndDate] [datetime] NULL ,
	[Active] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StarSite_Votelog] (
	[StarSite_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[StarSite_Fid] [int] NULL ,
	[StarSite_ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StarSite_time] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Action] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_CoName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Way] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_FromTime] [datetime] NULL ,
	[Wsdn_StarCRM_ToTime] [datetime] NULL ,
	[Wsdn_StarCRM_Rate] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Project] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsNotify] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[BeforeMinute] [int] NULL ,
	[BeforeHour] [int] NULL ,
	[BeforeDay] [int] NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_FromTime1] [datetime] NULL ,
	[Wsdn_StarCRM_ToTime1] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Advise] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[IsAccept] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Agent] (
	[Wsdn_StarCRM_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_TimeLimit] [datetime] NULL ,
	[Wsdn_StarCRM_Linkman] [int] NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_City] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Region] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Province] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Bank] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BankAccount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_URL] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mail] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Bargain] (
	[Wsdn_StarCRM_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Project] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_subscribe] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_A] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_B] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Aagent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Bagent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ASignDate] [datetime] NULL ,
	[Wsdn_StarCRM_BSginDate] [datetime] NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_BargainEm] (
	[Wsdn_StarCRM_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Project] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_subscribe] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_A] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_B] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Aagent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Bagent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ASignDate] [datetime] NULL ,
	[Wsdn_StarCRM_BSginDate] [datetime] NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_BuyOrder] (
	[Wsdn_StarCRM_Id] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Oldid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SEmployee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OEmployee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SDepartment] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ODepartment] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Storehouse] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_STime] [datetime] NULL ,
	[Wsdn_StarCRM_OTime] [datetime] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Number] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Checked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsBuyPre] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsOrderIn] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsBuyOrder] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_BuyOrderDetail] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_FId] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Productid] [int] NULL ,
	[Wsdn_StarCRM_Unit] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Price] [money] NULL ,
	[Wsdn_StarCRM_Num] [decimal](10, 2) NULL ,
	[Wsdn_StarCRM_InNum] [decimal](10, 0) NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_PayAmount] [money] NULL ,
	[Wsdn_StarCRM_UnAmount] [money] NULL ,
	[Wsdn_StarCRM_ThisAmount] [money] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsInStorehouse] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsPay] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_CATEGORIES] (
	[CategoryID] [int] NOT NULL ,
	[ParentCategoryID] [int] NULL ,
	[CategoryName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[URL] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Model] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightCode] [int] NULL ,
	[Serial] [int] NULL ,
	[TARGET] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[IMAGEURL] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_ChairTalk] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ChairMan] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_JionMan] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Pay] [decimal](19, 2) NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Chart] (
	[ProductID] [int] NOT NULL ,
	[CategoryID] [int] NULL ,
	[ProductName] [nvarchar] (75) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaleAmount] [money] NOT NULL ,
	[Times] [int] NULL ,
	[Ename] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_City] (
	[ID] [float] NULL ,
	[City] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ProvinceID] [int] NULL ,
	[PYCoding] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[AreaCoding] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZIP] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Client] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ClinetType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Character] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Vocation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Relation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_FirstTime] [datetime] NULL ,
	[Wsdn_StarCRM_LatelyTime] [datetime] NULL ,
	[Wsdn_StarCRM_Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Provine] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Region] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_City] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Email] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_URL] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mproduct] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Muser] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Pdetp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mdept] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Corporation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Manager] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Peoples] [int] NULL ,
	[Wsdn_StarCRM_Turnover] [money] NULL ,
	[Wsdn_StarCRM_RegTime] [datetime] NULL ,
	[Wsdn_StarCRM_Bank] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BankAccount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fstatus] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Farea] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Tax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Recorder] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[strA] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strB] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strD] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strE] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strF] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strG] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strH] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[decA] [decimal](18, 4) NULL ,
	[decB] [decimal](18, 4) NULL ,
	[decC] [decimal](18, 4) NULL ,
	[decD] [decimal](18, 4) NULL ,
	[intA] [int] NULL ,
	[intB] [int] NULL ,
	[dateA] [datetime] NULL ,
	[dateB] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Communion] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_OId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OTime] [datetime] NULL ,
	[Wsdn_StarCRM_Address1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum1] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OTime1] [datetime] NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Company] (
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Director] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Manager] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BuildTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_URL] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Email] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_EmployeeNum] [int] NULL ,
	[Wsdn_StarCRM_RegMoney] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Corporation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Smtp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SmtpPassword] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Compete] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_City] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Region] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Province] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Bank] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BankAccount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_URL] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mail] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_JionTime] [datetime] NULL ,
	[Wsdn_StarCRM_LimitTime] [datetime] NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Config] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Ctype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Num] [decimal](18, 4) NULL ,
	[Wsdn_StarCRM_info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_ConfigType] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Ctype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Country] (
	[ID] [float] NULL ,
	[Country] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[PYCoding] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Coding] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_DepartMent] (
	[DepartMentCode] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Manager] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Postnum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Btime] [datetime] NULL ,
	[Info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_DepartTask] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_TO] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Percent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Problem] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Employee] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[PassWord] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightCode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RoleCode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageSizeB] [int] NULL ,
	[PageSizeS] [int] NULL ,
	[Css] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[NavType] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_EngageType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SalaryType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Salary] [money] NULL ,
	[Wsdn_StarCRM_Postion] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Tech] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_JoinCompanyTime] [datetime] NULL ,
	[Wsdn_StarCRM_FirstWorkTime] [datetime] NULL ,
	[Wsdn_StarCRM_Politi] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Ismerry] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OfficePlace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BargainBeginTime] [datetime] NULL ,
	[Wsdn_StarCRM_BargainEndTime] [datetime] NULL ,
	[Wsdn_StarCRM_GoodAt] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_LeaveTime] [datetime] NULL ,
	[Wsdn_StarCRM_School] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Speciality] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Degree] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Graduate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_EduLanguage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_EduLangLevel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_EduComputer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_EduInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OldName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Ename] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Cphone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mobile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Email] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ICQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OICQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_MSN] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_LT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_CreatedTime] [datetime] NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_RegPlace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_NationPlace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Nation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fphone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Birthday] [datetime] NULL ,
	[Wsdn_StarCRM_Bank] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BankAccount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_MateName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ContactName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ContactPhone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Identity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SocietyNO] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_MedicaNO] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsStay] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Image] [image] NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsOnline] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Status] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[right1] [int] NULL ,
	[right2] [int] NULL ,
	[right3] [int] NULL ,
	[right4] [int] NULL ,
	[right5] [int] NULL ,
	[right6] [int] NULL ,
	[right7] [int] NULL ,
	[right8] [int] NULL ,
	[right9] [int] NULL ,
	[rightnumber] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Field] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_FId] [int] NULL ,
	[Atype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[strA] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[strB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[strC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[strD] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[strH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[strG] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[strF] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[strE] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[intB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateA] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[decD] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[decC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[decB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[decA] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[intA] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str2] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str3] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str4] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str5] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str6] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str7] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str8] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str9] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str10] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str11] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[str12] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec2] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec3] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec4] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec5] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec6] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec7] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec8] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec9] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec10] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec11] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec12] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[date1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[date2] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[date3] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[date4] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[money1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[money2] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[money3] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[money4] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[int1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[int2] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[int3] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[int4] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_FieldInfo] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_FId] [int] NOT NULL ,
	[Atype] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strA] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strB] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[strD] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[intA] [int] NULL ,
	[str1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str3] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str4] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str5] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str6] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str7] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str8] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str9] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str10] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str11] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[str12] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[dec1] [decimal](18, 4) NULL ,
	[dec2] [decimal](18, 4) NULL ,
	[dec3] [decimal](18, 4) NULL ,
	[dec4] [decimal](18, 4) NULL ,
	[dec5] [decimal](18, 4) NULL ,
	[dec6] [decimal](18, 4) NULL ,
	[dec7] [decimal](18, 4) NULL ,
	[dec8] [decimal](18, 4) NULL ,
	[dec9] [decimal](18, 4) NULL ,
	[dec10] [decimal](18, 4) NULL ,
	[dec11] [decimal](18, 4) NULL ,
	[dec12] [decimal](18, 4) NULL ,
	[date1] [datetime] NULL ,
	[date2] [datetime] NULL ,
	[date3] [datetime] NULL ,
	[date4] [datetime] NULL ,
	[money1] [money] NULL ,
	[money2] [money] NULL ,
	[money3] [money] NULL ,
	[money4] [money] NULL ,
	[int1] [int] NULL ,
	[int2] [int] NULL ,
	[int3] [int] NULL ,
	[int4] [int] NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_FieldType] (
	[Wsdn_StarCRM_id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_File] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ContentType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Size] [int] NULL ,
	[Wsdn_StarCRM_Ole] [image] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Uploader] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Project] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Id] (
	[Oid_bj] [int] NULL ,
	[TheDay_bj] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Image] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ContentType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Size] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Uploader] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Project] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Knowledge] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Leave] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OKTime] [datetime] NULL ,
	[Wsdn_StarCRM_OKMan] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsChecked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Linkman] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Dept] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Work] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postion] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Tech] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mobile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Email] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Birthday] [datetime] NULL ,
	[Wsdn_StarCRM_Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_City] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_URL] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Like] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_FirstTime] [datetime] NULL ,
	[Wsdn_StarCRM_LatelyTime] [datetime] NULL ,
	[Wsdn_StarCRM_Image] [image] NULL ,
	[Wsdn_StarCRM_Salary] [money] NULL ,
	[Wsdn_StarCRM_NationPlace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Nation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ContactName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ContactPhone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Identity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Bank] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ATM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ICQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OICQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_MSN] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_LT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsMailList] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsWeb] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_LastLoginTime] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Recorder] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_LogDo] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_LogLogin] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Ip] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Meeting] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_People] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Chair] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[sfsdf] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Message] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_From] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_To] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_ReadTime] [datetime] NULL ,
	[Wsdn_StarCRM_IsChecked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Status] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Email] [nvarchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_MoneyLog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_TType] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_TNumber] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_NeedMoney] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OKTime] [datetime] NULL ,
	[Wsdn_StarCRM_OKMan] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsChecked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_money] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_NeedReimb] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OKTime] [datetime] NULL ,
	[Wsdn_StarCRM_OKMan] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsChecked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_money] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Note] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_ObjectId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Status] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Notes] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsChecked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[NotifyTime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Object] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Ser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_DepartMent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Num] [decimal](18, 4) NULL ,
	[Wsdn_StarCRM_Price] [money] NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_ObjectLog] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_ObjectId] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_DepartMent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Num] [decimal](18, 4) NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Rate] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_State] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Orders] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BookTime] [datetime] NOT NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_CarrTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_CarrType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_CarrMoney] [money] NULL ,
	[Wsdn_StarCRM_Tax] [decimal](18, 4) NULL ,
	[Wsdn_StarCRM_Status] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_OutSide] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OKTime] [datetime] NULL ,
	[Wsdn_StarCRM_OKMan] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsChecked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_PayPre] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Storehouseid] [int] NULL ,
	[Wsdn_StarCRM_Storehouse] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Productid] [int] NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Num] [int] NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_TType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_TNumber] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Departmentid] [int] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_PriceReport] (
	[Wsdn_StarCRM_Id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Info] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_PriceReportDetail] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_FId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Unit] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_MarketPrice] [money] NULL ,
	[Wsdn_StarCRM_AgentPrice] [money] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Product] (
	[Wsdn_StarCRM_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Sname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Unit] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_From] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Provide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Company] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_St] [int] NULL ,
	[Wsdn_StarCRM_StTop] [int] NULL ,
	[Wsdn_StarCRM_StBottom] [int] NULL ,
	[Wsdn_StarCRM_CostPrice] [money] NULL ,
	[Wsdn_StarCRM_MarketPrice] [money] NULL ,
	[Wsdn_StarCRM_AgentPrice] [money] NULL ,
	[Wsdn_StarCRM_Price1] [money] NULL ,
	[Wsdn_StarCRM_Price2] [money] NULL ,
	[Wsdn_StarCRM_Price3] [money] NULL ,
	[Wsdn_StarCRM_Price4] [money] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsService] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Project] (
	[ProjectId] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Project] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Order] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SumCount] [money] NULL ,
	[StartTime] [datetime] NULL ,
	[EndTime] [datetime] NULL ,
	[Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[add_x] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_w] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Provide] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [int] NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_City] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Region] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Postnum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Province] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Bank] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BankAccount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_URL] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Mail] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_TimeLimit] [datetime] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Province] (
	[ID] [float] NULL ,
	[Province] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CountryID] [float] NULL ,
	[PYCoding] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_RepairCard] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ProductSer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Money] [money] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_CheckMan] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Factory] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Long] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BuyTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_FeedBack] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Repine] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Reason] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Way] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Rate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ProductSer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BuyTime] [datetime] NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_FeedBack] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Sale] (
	[Wsdn_StarCRM_Id] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Oldid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SEmployee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OEmployee] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SDepartment] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ODepartment] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Storehouse] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_TranType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OutType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_STime] [datetime] NULL ,
	[Wsdn_StarCRM_OTime] [datetime] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Number] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Checked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsPre] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsOut] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsSale] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_SaleDetail] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_FId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Productid] [int] NULL ,
	[Wsdn_StarCRM_Unit] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Price] [money] NULL ,
	[Wsdn_StarCRM_Num] [decimal](10, 2) NULL ,
	[Wsdn_StarCRM_InNum] [decimal](10, 0) NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_PayAmount] [money] NULL ,
	[Wsdn_StarCRM_UnAmount] [money] NULL ,
	[Wsdn_StarCRM_ThisAmount] [money] NULL ,
	[Wsdn_StarCRM_NoTax] [money] NULL ,
	[Wsdn_StarCRM_GoodAmount] [money] NULL ,
	[Wsdn_StarCRM_Tax] [money] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_SInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsInStorehouse] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsPay] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_SaleProduct] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[DetailID] [int] NULL ,
	[Wsdn_StarCRM_Storehouseid] [int] NULL ,
	[Wsdn_StarCRM_Storehouse] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Productid] [int] NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Num] [decimal](10, 2) NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_TType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_TNumber] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Departmentid] [int] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_SaleProductCancel] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[DetailID] [int] NULL ,
	[Wsdn_StarCRM_Storehouseid] [int] NULL ,
	[Wsdn_StarCRM_Storehouse] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Productid] [int] NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Num] [decimal](10, 2) NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_TType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_TNumber] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Departmentid] [int] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Service] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_CoName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Way] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Rate] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_FromTime] [datetime] NULL ,
	[Wsdn_StarCRM_ToTime] [datetime] NULL ,
	[Wsdn_StarCRM_Money] [money] NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Project] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_ShortBoard] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Title] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Rate] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsCompany] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_StoreProduct] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[BuyOrderDetailID] [int] NULL ,
	[Wsdn_StarCRM_Storehouseid] [int] NULL ,
	[Wsdn_StarCRM_Storehouse] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Productid] [int] NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Num] [decimal](10, 2) NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Departmentid] [int] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_StoreProductCancel] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[BuyOrderDetailID] [int] NULL ,
	[Wsdn_StarCRM_Storehouseid] [int] NULL ,
	[Wsdn_StarCRM_Storehouse] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Productid] [int] NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Spec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_OId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Num] [decimal](10, 2) NULL ,
	[Wsdn_StarCRM_Amount] [money] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Clientid] [int] NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Departmentid] [int] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Storehouse] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Task] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_From] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_TO] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Percent] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Prior] [nvarchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Value] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Problem] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_WriteTime] [datetime] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsChecked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_StartTime1] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime1] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_Url] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_ObjectId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_URL] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Status] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_WNL] (
	[DATE] [smalldatetime] NULL ,
	[NL] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_STR] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_YEAR] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_MONTH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_DAY] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ANIMAL] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[FESTIVE] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_FESTIVE] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_JQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_Run] [bit] NOT NULL ,
	[WEEK] [int] NULL ,
	[WEEKDAY] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_MONTH_B] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NL_YEAR_B] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_WorkForm] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Id] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Reason] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Way] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_StartTime] [datetime] NULL ,
	[Wsdn_StarCRM_EndTime] [datetime] NULL ,
	[Wsdn_StarCRM_Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Employee] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_PerTime] [datetime] NULL ,
	[Wsdn_StarCRM_Product] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ProductSer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_BuyTime] [datetime] NULL ,
	[Wsdn_StarCRM_ProductInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Money] [money] NULL ,
	[Wsdn_StarCRM_MoneyInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Isback] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsComplete] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_FeedBack] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Deleteflag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Locked] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Wsdn_StarCRM_WorkLogs] (
	[Wsdn_StarCRM_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Wsdn_StarCRM_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_CoName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Time] [datetime] NULL ,
	[Wsdn_StarCRM_Info] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Result] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Way] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_From] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_FromTime] [datetime] NULL ,
	[Wsdn_StarCRM_To] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_ToTime] [datetime] NULL ,
	[Wsdn_StarCRM_Client] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Linkman] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_Money] [money] NULL ,
	[Wsdn_StarCRM_Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wsdn_StarCRM_IsPublic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeleteFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_x] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_y] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_z] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[StarHR_Pay] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarHR_Pay] PRIMARY KEY  CLUSTERED 
	(
		[StarHR_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_Ad] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_Ad] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_Adlog] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_Adlog] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_Case] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_Case] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_Download] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_Download] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_Feedback] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_Feedback] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_Link] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_Link] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_NewType] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_NewType] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarSite_News] WITH NOCHECK ADD 
	CONSTRAINT [PK_StarSite_News] PRIMARY KEY  CLUSTERED 
	(
		[StarSite_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Action] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Action] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Advise] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Advise] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Agent] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Agent] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_BuyOrder] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_BuyOrder] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_BuyOrderDetail] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_BuyOrderDetail] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Communion] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Communion] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_ConfigType] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_ConfigType] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Ctype]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_DepartMent] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_DepartMent] PRIMARY KEY  CLUSTERED 
	(
		[DepartMentCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_DepartTask] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_DepartTask] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Employee] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Employee] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Leave] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Leave] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_LogDo] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_LogDo] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_LogLogin] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_LogLogin] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_MoneyLog] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_MoneyLog] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_NeedMoney] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_NeedMoney] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_NeedReimb] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_NeedReimb] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Note] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Note] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Notes] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Notes] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Object] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Object] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_ObjectLog] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_ObjectLog] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_OutSide] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_OutSide] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_PayPre] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_PayPre] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_PriceReport] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_PriceReport] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_PriceReportDetail] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_PriceReportDetail] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Product] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Product] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_RepairCard] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_RepairCard] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Repine] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Repine] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Sale] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Sale] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_SaleProduct] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_SaleProduct] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_SaleProductCancel] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_SaleProductCancel] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Service] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Service] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_ShortBoard] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_ShortBoard] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_StoreProduct] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_StoreProduct] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_StoreProductCancel] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_StoreProductCancel] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Storehouse] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Storehouse] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Task] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_Task] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_WorkForm] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_WorkForm] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_WorkLogs] WITH NOCHECK ADD 
	CONSTRAINT [PK_Wsdn_StarCRM_WorkLogs] PRIMARY KEY  CLUSTERED 
	(
		[Wsdn_StarCRM_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[StarHR_Pay] ADD 
	CONSTRAINT [DF_StarHR_Pay_StarHR_base] DEFAULT (0) FOR [StarHR_base],
	CONSTRAINT [DF_StarHR_Pay_StarHR_bonus] DEFAULT (0) FOR [StarHR_bonus],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus1] DEFAULT (0) FOR [StarHR_plus1],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus2] DEFAULT (0) FOR [StarHR_plus2],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus3] DEFAULT (0) FOR [StarHR_plus3],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus42] DEFAULT (0) FOR [StarHR_plus4],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus41] DEFAULT (0) FOR [StarHR_plus5],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus63] DEFAULT (0) FOR [StarHR_plus6],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus62] DEFAULT (0) FOR [StarHR_plus7],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus61] DEFAULT (0) FOR [StarHR_plus8],
	CONSTRAINT [DF_StarHR_Pay_StarHR_plus4] DEFAULT (0) FOR [StarHR_plus9],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce1] DEFAULT (0) FOR [StarHR_reduce1],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce2] DEFAULT (0) FOR [StarHR_reduce2],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce3] DEFAULT (0) FOR [StarHR_reduce3],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce43] DEFAULT (0) FOR [StarHR_reduce4],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce42] DEFAULT (0) FOR [StarHR_reduce5],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce63] DEFAULT (0) FOR [StarHR_reduce6],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce62] DEFAULT (0) FOR [StarHR_reduce7],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce61] DEFAULT (0) FOR [StarHR_reduce8],
	CONSTRAINT [DF_StarHR_Pay_StarHR_reduce41] DEFAULT (0) FOR [StarHR_reduce9],
	CONSTRAINT [DF_StarHR_Pay_StarHR_real] DEFAULT (0) FOR [StarHR_real],
	CONSTRAINT [DF_StarHR_Pay_isget] DEFAULT ('N') FOR [isget],
	CONSTRAINT [DF_StarHR_Pay_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_StarHR_Pay_Locked] DEFAULT ('N') FOR [Locked]
GO

ALTER TABLE [dbo].[StarHR_Porf] ADD 
	CONSTRAINT [DF_StarHR_Porf_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_Ad] ADD 
	CONSTRAINT [DF_StarSite_Ad_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_StarSite_Ad_Istop] DEFAULT ('N') FOR [Istop]
GO

ALTER TABLE [dbo].[StarSite_Case] ADD 
	CONSTRAINT [DF_StarSite_Case_StarSite_num] DEFAULT (0) FOR [StarSite_num],
	CONSTRAINT [DF_StarSite_Case_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_Download] ADD 
	CONSTRAINT [DF_StarSite_Download_StarSite_size] DEFAULT (0) FOR [StarSite_size],
	CONSTRAINT [DF_StarSite_Download_StarSite_num] DEFAULT (0) FOR [StarSite_num],
	CONSTRAINT [DF_StarSite_Download_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_Feedback] ADD 
	CONSTRAINT [DF_StarSite_Feedback_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_Link] ADD 
	CONSTRAINT [DF_StarSite_Link_StarSite_num] DEFAULT (0) FOR [StarSite_num],
	CONSTRAINT [DF_StarSite_Link_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_NewType] ADD 
	CONSTRAINT [DF_StarSite_NewType_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_News] ADD 
	CONSTRAINT [DF_StarSite_News_StarSite_num] DEFAULT (0) FOR [StarSite_num],
	CONSTRAINT [DF_StarSite_News_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_Review] ADD 
	CONSTRAINT [DF_StarSite_Review_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_User] ADD 
	CONSTRAINT [DF_StarSite_User_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_VoteItem] ADD 
	CONSTRAINT [DF_StarSite_VoteItem_StarSite_num] DEFAULT (0) FOR [StarSite_num],
	CONSTRAINT [DF_StarSite_VoteItem_AnswerPercent] DEFAULT (0) FOR [AnswerPercent],
	CONSTRAINT [DF_StarSite_VoteItem_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[StarSite_VoteTitle] ADD 
	CONSTRAINT [DF_StarSite_VoteTitle_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_StarSite_VoteTitle_listorder] DEFAULT (0) FOR [ListOrder],
	CONSTRAINT [DF_StarSite_VoteTitle_IsInput] DEFAULT ('N') FOR [IsInput],
	CONSTRAINT [DF_StarSite_VoteTitle_Active] DEFAULT (0) FOR [Active]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Action] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Action_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Action_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Action_IsNotify] DEFAULT ('N') FOR [IsNotify],
	CONSTRAINT [DF_Wsdn_StarCRM_Action_BeforeMinute] DEFAULT (0) FOR [BeforeMinute],
	CONSTRAINT [DF_Wsdn_StarCRM_Action_BeforeHour] DEFAULT (0) FOR [BeforeHour],
	CONSTRAINT [DF_Wsdn_StarCRM_Action_BeforeDay] DEFAULT (0) FOR [BeforeDay]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Advise] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Advise_IsAccept] DEFAULT ('N') FOR [IsAccept],
	CONSTRAINT [DF_Wsdn_StarCRM_Advise_Deleteflag] DEFAULT ('N') FOR [Deleteflag],
	CONSTRAINT [DF_Wsdn_StarCRM_Advise_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Agent] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Agent_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Bargain] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Bargain_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Bargain_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_BargainEm] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_BargainEm_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_BargainEm_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_BuyOrder] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrder_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrder_Checked] DEFAULT ('N') FOR [Checked],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrder_IsBuyPre] DEFAULT ('Y') FOR [IsBuyPre],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrder_IsOrderIn] DEFAULT ('N') FOR [IsOrderIn],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrder_IsBuyOrder] DEFAULT ('N') FOR [IsBuyOrder]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_BuyOrderDetail] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_Wsdn_StarCRM_Price] DEFAULT (0) FOR [Wsdn_StarCRM_Price],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_Wsdn_StarCRM_Num] DEFAULT (0) FOR [Wsdn_StarCRM_Num],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_Wsdn_StarCRM_InNum] DEFAULT (0) FOR [Wsdn_StarCRM_InNum],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_Wsdn_StarCRM_Amount] DEFAULT (0) FOR [Wsdn_StarCRM_Amount],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_Wsdn_StarCRM_PayAmount] DEFAULT (0) FOR [Wsdn_StarCRM_PayAmount],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_Wsdn_StarCRM_UnAmount] DEFAULT (0) FOR [Wsdn_StarCRM_UnAmount],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_Wsdn_StarCRM_ThisAmount] DEFAULT (0) FOR [Wsdn_StarCRM_ThisAmount],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_IsInStorehouse] DEFAULT ('N') FOR [IsInStorehouse],
	CONSTRAINT [DF_Wsdn_StarCRM_BuyOrderDetail_IsPay] DEFAULT ('N') FOR [IsPay]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_ChairTalk] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_ChairTalk_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_ChairTalk_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Client] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Client_Wsdn_StarCRM_Peoples] DEFAULT (0) FOR [Wsdn_StarCRM_Peoples],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_Wsdn_StarCRM_Turnover] DEFAULT (0) FOR [Wsdn_StarCRM_Turnover],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_Deleteflag] DEFAULT ('N') FOR [Deleteflag],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_Wsdn_StarCRM_IsPublic] DEFAULT ('N') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_Locked] DEFAULT ('N') FOR [Locked],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_decA] DEFAULT (0) FOR [decA],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_decB] DEFAULT (0) FOR [decB],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_decC] DEFAULT (0) FOR [decC],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_decD] DEFAULT (0) FOR [decD],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_intA] DEFAULT (0) FOR [intA],
	CONSTRAINT [DF_Wsdn_StarCRM_Client_intB] DEFAULT (0) FOR [intB]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Communion] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Communion_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Communion_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Compete] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Compete_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Config] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Config_Wsdn_StarCRM_Num] DEFAULT (0) FOR [Wsdn_StarCRM_Num],
	CONSTRAINT [DF_Wsdn_StarCRM_Config_Wsdn_StarCRM_info] DEFAULT (N'-') FOR [Wsdn_StarCRM_info],
	CONSTRAINT [DF_Wsdn_StarCRM_Config_Deleteflag] DEFAULT ('N') FOR [Deleteflag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_DepartMent] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_DepartMent_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_DepartTask] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_DepartTask_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_DepartTask_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Employee] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_Wsdn_StarCRM_Sex] DEFAULT ('男') FOR [Wsdn_StarCRM_Sex],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_PassWord] DEFAULT (1) FOR [PassWord],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_RightCode] DEFAULT (N'人事,办公') FOR [RightCode],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_RoleCode] DEFAULT (N'只读用户') FOR [RoleCode],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_PageSizeB] DEFAULT (18) FOR [PageSizeB],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_PageSizeS] DEFAULT (6) FOR [PageSizeS],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_Css] DEFAULT (N'../css/wsdnorgstd1.css') FOR [Css],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_NavType] DEFAULT (N'menu') FOR [NavType],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_Locked] DEFAULT ('N') FOR [Locked],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_IsOnline] DEFAULT ('N') FOR [IsOnline],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_Status] DEFAULT (N'新建员工尚未登陆') FOR [Status],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right1] DEFAULT (0) FOR [right1],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right2] DEFAULT (0) FOR [right2],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right3] DEFAULT (1999) FOR [right3],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right4] DEFAULT (0) FOR [right4],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right5] DEFAULT (0) FOR [right5],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right6] DEFAULT (0) FOR [right6],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right7] DEFAULT (0) FOR [right7],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right8] DEFAULT (0) FOR [right8],
	CONSTRAINT [DF_Wsdn_StarCRM_Employee_right9] DEFAULT (0) FOR [right9]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_FieldInfo] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_decA] DEFAULT (0) FOR [strB],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_moneyA] DEFAULT (0) FOR [strD],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec1] DEFAULT (0) FOR [dec1],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec2] DEFAULT (0) FOR [dec2],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec3] DEFAULT (0) FOR [dec3],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec4] DEFAULT (0) FOR [dec4],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec5] DEFAULT (0) FOR [dec5],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec6] DEFAULT (0) FOR [dec6],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec7] DEFAULT (0) FOR [dec7],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec8] DEFAULT (0) FOR [dec8],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec9] DEFAULT (0) FOR [dec9],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec10] DEFAULT (0) FOR [dec10],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec11] DEFAULT (0) FOR [dec11],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_dec12] DEFAULT (0) FOR [dec12],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_money1] DEFAULT (0) FOR [money1],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_money2] DEFAULT (0) FOR [money2],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_money3] DEFAULT (0) FOR [money3],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_money4] DEFAULT (0) FOR [money4],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_int1] DEFAULT (0) FOR [int1],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_int2] DEFAULT (0) FOR [int2],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_int3] DEFAULT (0) FOR [int3],
	CONSTRAINT [DF_Wsdn_StarCRM_FieldInfo_int4] DEFAULT (0) FOR [int4]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_File] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_File_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_File_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Image] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Image_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Image_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Knowledge] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Knowledge_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Knowledge_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Knowledge_Locked] DEFAULT ('N') FOR [Locked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Leave] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Leave_Wsdn_StarCRM_IsNPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Leave_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Leave_Wsdn_StarCRM_IsChecked] DEFAULT ('N') FOR [Wsdn_StarCRM_IsChecked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Linkman] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Linkman_Wsdn_StarCRM_IsPublic] DEFAULT ('N') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Linkman_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Linkman_Locked] DEFAULT ('N') FOR [Locked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Meeting] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Meeting_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Meeting_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Meeting_Locked] DEFAULT ('N') FOR [Locked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Message] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Message_Wsdn_StarCRM_IsChecked] DEFAULT ('N') FOR [Wsdn_StarCRM_IsChecked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_NeedMoney] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_NeedMoney_Wsdn_StarCRM_IsNPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_NeedMoney_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_NeedMoney_Wsdn_StarCRM_IsChecked] DEFAULT ('N') FOR [Wsdn_StarCRM_IsChecked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_NeedReimb] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_NeedReimb_Wsdn_StarCRM_IsNPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_NeedReimb_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_NeedReimb_Wsdn_StarCRM_IsChecked] DEFAULT ('N') FOR [Wsdn_StarCRM_IsChecked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Note] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Note_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Notes] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Notes_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Notes_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Notes_Wsdn_StarCRM_IsChecked] DEFAULT ('N') FOR [Wsdn_StarCRM_IsChecked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Object] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Object_Wsdn_StarCRM_Num] DEFAULT (0) FOR [Wsdn_StarCRM_Num],
	CONSTRAINT [DF_Wsdn_StarCRM_Object_Wsdn_StarCRM_Price] DEFAULT (0) FOR [Wsdn_StarCRM_Price],
	CONSTRAINT [DF_Wsdn_StarCRM_Object_Deleteflag] DEFAULT ('N') FOR [Deleteflag],
	CONSTRAINT [DF_Wsdn_StarCRM_Object_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_ObjectLog] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_ObjectLog_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Orders] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Orders_Deleteflag] DEFAULT ('N') FOR [Deleteflag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_OutSide] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_OutSide_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_OutSide_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_OutSide_Wsdn_StarCRM_IsChecked] DEFAULT ('N') FOR [Wsdn_StarCRM_IsChecked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_PayPre] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_PayPre_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_PayPre_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_PriceReport] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_PriceReport_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_PriceReport_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_PriceReportDetail] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_PriceReportDetail_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Product] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Product_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Product_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Project] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Project_SumCount] DEFAULT (0) FOR [SumCount],
	CONSTRAINT [DF_Wsdn_StarCRM_Project_StartTime] DEFAULT (getdate()) FOR [StartTime],
	CONSTRAINT [DF_Wsdn_StarCRM_Project_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_RepairCard] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_RepairCard_Wsdn_StarCRM_Money] DEFAULT (0) FOR [Wsdn_StarCRM_Money],
	CONSTRAINT [DF_Wsdn_StarCRM_RepairCard_Deleteflag] DEFAULT ('N') FOR [Deleteflag],
	CONSTRAINT [DF_Wsdn_StarCRM_RepairCard_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Repine] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Repine_Deleteflag] DEFAULT ('N') FOR [Deleteflag],
	CONSTRAINT [DF_Wsdn_StarCRM_Repine_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Sale] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Sale_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_Sale_Checked] DEFAULT ('N') FOR [Checked],
	CONSTRAINT [DF_Wsdn_StarCRM_Sale_IsPre] DEFAULT ('Y') FOR [IsPre],
	CONSTRAINT [DF_Wsdn_StarCRM_Sale_IsOut] DEFAULT ('N') FOR [IsOut],
	CONSTRAINT [DF_Wsdn_StarCRM_Sale_IsSale] DEFAULT ('N') FOR [IsSale]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_SaleDetail] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_Price] DEFAULT (0) FOR [Wsdn_StarCRM_Price],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_Num] DEFAULT (0) FOR [Wsdn_StarCRM_Num],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_InNum] DEFAULT (0) FOR [Wsdn_StarCRM_InNum],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_Amount] DEFAULT (0) FOR [Wsdn_StarCRM_Amount],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_PayAmount] DEFAULT (0) FOR [Wsdn_StarCRM_PayAmount],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_UnAmount] DEFAULT (0) FOR [Wsdn_StarCRM_UnAmount],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_ThisAmount] DEFAULT (0) FOR [Wsdn_StarCRM_ThisAmount],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_NoTax] DEFAULT (0) FOR [Wsdn_StarCRM_NoTax],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_GoodAmount] DEFAULT (0) FOR [Wsdn_StarCRM_GoodAmount],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_Tax] DEFAULT (0) FOR [Wsdn_StarCRM_Tax],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_Wsdn_StarCRM_Info] DEFAULT (N'-') FOR [Wsdn_StarCRM_Info],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_IsInStorehouse] DEFAULT ('N') FOR [IsInStorehouse],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleDetail_IsPay] DEFAULT ('N') FOR [IsPay]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_SaleProduct] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_SaleProduct_Wsdn_StarCRM_Num] DEFAULT (0) FOR [Wsdn_StarCRM_Num],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleProduct_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleProduct_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_SaleProductCancel] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_SaleProductCancel_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_SaleProductCancel_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Service] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Service_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Service_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_ShortBoard] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_ShortBoard_Wsdn_StarCRM_IsCompany] DEFAULT ('N') FOR [Wsdn_StarCRM_IsCompany],
	CONSTRAINT [DF_Wsdn_StarCRM_ShortBoard_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_ShortBoard_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_StoreProduct] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_StoreProduct_Wsdn_StarCRM_Num] DEFAULT (0) FOR [Wsdn_StarCRM_Num],
	CONSTRAINT [DF_Wsdn_StarCRM_StoreProduct_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_StoreProduct_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_StoreProductCancel] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_StoreProductCancel_Wsdn_StarCRM_Num] DEFAULT (0) FOR [Wsdn_StarCRM_Num],
	CONSTRAINT [DF_Wsdn_StarCRM_StoreProductCancel_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_StoreProductCancel_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Storehouse] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Storehouse_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Task] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Task_Wsdn_StarCRM_IsChecked] DEFAULT ('N') FOR [Wsdn_StarCRM_IsChecked],
	CONSTRAINT [DF_Wsdn_StarCRM_Task_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_Task_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_Url] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_Url_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_WorkForm] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_WorkForm_Wsdn_StarCRM_Money] DEFAULT (0) FOR [Wsdn_StarCRM_Money],
	CONSTRAINT [DF_Wsdn_StarCRM_WorkForm_Isback] DEFAULT ('N') FOR [Isback],
	CONSTRAINT [DF_Wsdn_StarCRM_WorkForm_IsComplete] DEFAULT ('N') FOR [IsComplete],
	CONSTRAINT [DF_Wsdn_StarCRM_WorkForm_Deleteflag] DEFAULT ('N') FOR [Deleteflag],
	CONSTRAINT [DF_Wsdn_StarCRM_WorkForm_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_WorkForm_Locked] DEFAULT ('N') FOR [Locked]
GO

ALTER TABLE [dbo].[Wsdn_StarCRM_WorkLogs] ADD 
	CONSTRAINT [DF_Wsdn_StarCRM_WorkLogs_Wsdn_StarCRM_Money] DEFAULT (0) FOR [Wsdn_StarCRM_Money],
	CONSTRAINT [DF_Wsdn_StarCRM_WorkLogs_Wsdn_StarCRM_IsPublic] DEFAULT ('Y') FOR [Wsdn_StarCRM_IsPublic],
	CONSTRAINT [DF_Wsdn_StarCRM_WorkLogs_DeleteFlag] DEFAULT ('N') FOR [DeleteFlag]
GO

