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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[Intercourse] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Department] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Seq] [int] NULL ,
	[Handler] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Date] [datetime] NULL ,
	[Content] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Target] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[CompanyName] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Person] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Position] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[OtherCount] [int] NULL ,
	[OurCount] [int] NULL ,
	[Times] [int] NULL ,
	[Time] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Location] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShouldMoney] [money] NULL ,
	[ActualMoney] [money] NULL ,
	[InsertDate] [datetime] NULL ,
	[Note] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[IntercourseDetail] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[pId] [int] NULL ,
	[Seq] [int] NULL ,
	[UserId] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Date] [datetime] NULL ,
	[Note] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[UserInfo1] (
	[id] [int] NOT NULL ,
	[name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[native] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[position] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[born] [datetime] NULL ,
	[academic] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[folk] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[indentity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[political] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[date] [datetime] NULL ,
	[regist] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[marry] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[nowaddr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dept] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[audmit] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[audmit_man] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[awoke] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[registe] [datetime] NULL ,
	[first_time] [datetime] NULL ,
	[last_time] [datetime] NULL ,
	[title] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[back] [varchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[memo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[book_borrow] (
	[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[book_name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[borrow_man] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[borrow_time] [datetime] NULL ,
	[sign] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[book_main] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[author] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[publishment_date] [datetime] NULL ,
	[book_concern] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[price] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[detail] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[borrow] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[input_time] [datetime] NULL ,
	[number] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[sign] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[book_manage] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[man] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[input_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[c_eatmain] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[lunch] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[supper] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[price1] [money] NULL ,
	[price2] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[c_eattext] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[eatname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[price] [money] NULL ,
	[dname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[car_main] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[describe] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[car_use] (
	[idd] [int] IDENTITY (1, 1) NOT NULL ,
	[id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[man] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[excuse] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[first_date] [datetime] NULL ,
	[last_date] [datetime] NULL ,
	[sign] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[client_l] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[client_new] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[com_sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[number] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[registe] [datetime] NULL ,
	[com_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[client_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[client_model] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[client_address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[character] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[com_email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[postcode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[client_sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[product] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[net] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[net_function] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[con_name1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel_call1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[remark1] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[con_name2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel_call2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[remark2] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[con_name3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel_call3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[remark3] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sign] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[idea] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[opinion1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[del_sign] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[opinion2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[situation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[s_date] [datetime] NULL ,
	[audmit_man] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[a_situation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[client_s] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[situation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[client_sort] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sortid] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[linktime] [datetime] NULL ,
	[info] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[code_all] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[codename] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[itid] [int] NULL ,
	[register] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[code_main] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[maincode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[brief] [varchar] (800) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[reman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[retime] [datetime] NULL ,
	[sort] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum_44] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum_45] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum_46] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum_47] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum_48] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum_50] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forum_51] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL ,
	[face] [int] NULL ,
	[amount] [int] NULL ,
	[date] [datetime] NULL ,
	[redate] [datetime] NULL ,
	[writerid] [int] NULL ,
	[forumid] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forumclass] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[classname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_forumsinfo] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[forumname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[owner] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[classid] [int] NULL ,
	[reader] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_login] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[date] [datetime] NULL ,
	[state] [int] NULL ,
	[userid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_placard] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[date] [datetime] NULL ,
	[tdate] [datetime] NULL ,
	[deptid] [int] NULL ,
	[writerid] [int] NULL ,
	[poll1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[poll2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[poll3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userid] [int] NULL ,
	[annex] [int] NULL ,
	[filename] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_poll] (
	[placardid] [int] NULL ,
	[state] [int] NULL ,
	[userid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_rest] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[userid] [int] NULL ,
	[examineid] [int] NULL ,
	[cause] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL ,
	[sdate] [datetime] NULL ,
	[edate] [datetime] NULL ,
	[date] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_workday] (
	[wyear] [int] NULL ,
	[wmonth] [int] NULL ,
	[workday] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[community_worktime] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[shour] [int] NULL ,
	[sminute] [int] NULL ,
	[ehour] [int] NULL ,
	[eminute] [int] NULL ,
	[mhour] [int] NULL ,
	[mminute] [int] NULL ,
	[thour] [int] NULL ,
	[tminute] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[d_image] (
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [int] NULL ,
	[register] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[fastlink] (
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[url] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[file_main] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[file_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[reader] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[memo] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[expose] [int] NULL ,
	[input_date] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[file_sort] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[i_plistpda] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[relation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sex] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[company] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cellphone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[oicq] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[picture] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[brief] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[userid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[imail_chit] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[body] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[url] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[date] [datetime] NULL ,
	[isread] [int] NULL ,
	[udate] [datetime] NULL ,
	[tuserid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[imail_message] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[isread] [int] NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[body] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[date] [datetime] NULL ,
	[annex] [int] NULL ,
	[fuserid] [int] NULL ,
	[tuserid] [int] NULL ,
	[filename] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[issend] [int] NULL ,
	[state] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[imail_sort] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[statename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[info] (
	[infoid] [int] IDENTITY (1, 1) NOT NULL ,
	[nameid] [int] NULL ,
	[linktime] [datetime] NULL ,
	[info] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[m_compact] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[userid] [int] NULL ,
	[statetime] [datetime] NULL ,
	[overtime] [datetime] NULL ,
	[register] [datetime] NULL ,
	[mode1] [int] NULL ,
	[state] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[notice] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[brief] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[annex] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[m_wage] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[wage] [money] NULL ,
	[pay] [money] NULL ,
	[house] [money] NULL ,
	[lunch] [money] NULL ,
	[outpay] [money] NULL ,
	[bonus] [money] NULL ,
	[card] [money] NULL ,
	[ratal] [money] NULL ,
	[safe] [money] NULL ,
	[other] [money] NULL ,
	[givetime] [datetime] NULL ,
	[dotime] [datetime] NULL ,
	[registar] [datetime] NULL ,
	[userid] [int] NULL ,
	[brief] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_dept] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[deptname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[groupid] [int] NULL ,
	[deptid] [int] NULL ,
	[parent] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_group] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[groupname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[parent] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_mark] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sourceid] [int] NULL ,
	[object] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[object2] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[object3] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[operationid] [int] NULL ,
	[date] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_operation] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[action] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_page] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[pagename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_pagegroup] (
	[pageid] [int] NULL ,
	[groupid] [int] NULL ,
	[sort] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_user] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptid] [int] NULL ,
	[sex] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[folk] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[polity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[marry] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[diploma] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[native] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[addr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[job] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[indentity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[born] [datetime] NULL ,
	[date] [datetime] NULL ,
	[leave] [int] NULL ,
	[title] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[oicq] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[college] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[graduation_time] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[major] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[picture] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[domanid] [int] NULL ,
	[kincall1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kincall2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kinname1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kinname2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kin1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kin2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kindept1] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[kindept2] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[workname1] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[workname2] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[worktime1] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[worktime2] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[workdept1] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[workdept2] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[workduty1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[workduty2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[workman1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[workman2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[special] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[talkman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[okman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[color] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[manage_usergroup] (
	[userid] [int] NULL ,
	[groupid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[meeting_main] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[describe] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[meeting_use] (
	[id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[man] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[excuse] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[first_date] [datetime] NULL ,
	[last_date] [datetime] NULL ,
	[sign] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[idd] [int] IDENTITY (1, 1) NOT NULL ,
	[doman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[office_deptdo] (
	[main_id] [int] NOT NULL ,
	[okname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[state] [int] NULL ,
	[readtime] [datetime] NULL ,
	[pass] [int] NULL ,
	[retime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[office_deptlist] (
	[main_id] [int] NOT NULL ,
	[setup_id] [int] NOT NULL ,
	[s_quantity] [int] NULL ,
	[d_quantity] [int] NULL ,
	[price] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[office_deptmain] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[deptid] [int] NULL ,
	[doman] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL ,
	[register] [datetime] NULL ,
	[dodate] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[brief] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[office_deptpath] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[deptid] [int] NULL ,
	[manager] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[doname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[okname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[office_deptsome] (
	[deptid] [int] NULL ,
	[setup_id] [int] NULL ,
	[quantity] [int] NULL ,
	[dodate] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[office_manpath] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[deptid] [int] NULL ,
	[manager] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[doname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[okname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[office_setup] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[unit] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[price] [money] NULL ,
	[brief] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[process] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[clientid] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[link_time] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[r_date] [datetime] NULL ,
	[man] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[detail] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[contact] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[remark] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_add] (
	[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_memo] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_chit] (
	[userid] [int] NULL ,
	[body] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[udate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_dospan] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sid] [int] NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[brief] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_eexpose] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[expose] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[input_time] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_expose] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[expose] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_main] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[man] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[first_time] [datetime] NULL ,
	[last_time] [datetime] NULL ,
	[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[memo] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[important] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[awoke] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[expose] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[awoke_man] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[awoke_time] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[do_time] [datetime] NULL ,
	[dept] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[situation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_menu] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[importance] [int] NULL ,
	[doman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[expose] [int] NULL ,
	[code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[codename] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [bit] NULL ,
	[register] [datetime] NULL ,
	[leave] [int] NULL ,
	[setman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_respan] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sid] [int] NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[brief] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_sort] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sort] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_span] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[mmid] [int] NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[callman] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[dohour] [int] NULL ,
	[firsttime] [datetime] NULL ,
	[lasttime] [datetime] NULL ,
	[brief] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[menu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[annex] [int] NULL ,
	[filename] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[awoke] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fuserid] [int] NULL ,
	[register] [datetime] NULL ,
	[number] [int] NULL ,
	[state] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[schedule_tospan] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sid] [int] NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[brief] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[setdate] (
	[id] [int] NOT NULL ,
	[setdate] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[system_skin] (
	[skin_name] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[skin_cname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_empowen] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[doman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[sortname] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[toman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[startdate] [datetime] NULL ,
	[overdate] [datetime] NULL ,
	[brief] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[flag] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_main] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[number] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[header] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[danwei] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[grade] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[secret] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[text] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[brief] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL ,
	[statex] [int] NULL ,
	[statename] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[pathid] [int] NULL ,
	[annex] [int] NULL ,
	[userid] [int] NULL ,
	[filename] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_muniment] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[state] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[number] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[directory] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[category] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[header] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[wid] [int] NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[reader] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[readtime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_path] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[pathname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[userid] [int] NULL ,
	[lasttime] [int] NULL ,
	[registrar] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[proofreader] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[give] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[filing] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[leave] [int] NULL ,
	[statenumber] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[pathnumber] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_pathtemp] (
	[userid] [int] NULL ,
	[number] [int] NULL ,
	[doman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[domanid] [int] NULL ,
	[deptid] [int] NULL ,
	[duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_pathtext] (
	[pathid] [int] NULL ,
	[number] [int] NULL ,
	[doman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[domanid] [int] NULL ,
	[deptid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_set] (
	[spyu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[nbyu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmjb] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[jjcd] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[swfs] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbyu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[dbyu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[txyu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_shouwen] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[header] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[danwei] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[grade] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[secret] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL ,
	[text] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL ,
	[userid] [int] NULL ,
	[annex] [int] NULL ,
	[filename] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_sort] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[brief] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[doman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[register] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[workflow_state] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[mid] [int] NULL ,
	[reader] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL ,
	[readtime] [datetime] NULL ,
	[pass] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[answer] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[retime] [datetime] NULL ,
	[orderlist] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

