contact0310.sql

本人为公司开发的Flex办公系统web源码,包括数据库脚本文件。

GO

ALTER TABLE [dbo].[PR_Main] WITH NOCHECK ADD 
	CONSTRAINT [PK_PR_Main] PRIMARY KEY  CLUSTERED 
	(
		[PR_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[PR_Sub] WITH NOCHECK ADD 
	CONSTRAINT [PK_PR_Sub] PRIMARY KEY  CLUSTERED 
	(
		[PR_ID],
		[SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Tables] WITH NOCHECK ADD 
	CONSTRAINT [PK_Tables] PRIMARY KEY  CLUSTERED 
	(
		[tabename]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TrueOperate_Log] WITH NOCHECK ADD 
	CONSTRAINT [PK_TrueOperate_Log] PRIMARY KEY  CLUSTERED 
	(
		[AutoRec]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[users] WITH NOCHECK ADD 
	CONSTRAINT [PK_users] PRIMARY KEY  CLUSTERED 
	(
		[uid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ACompany] ADD 
	CONSTRAINT [DF_ACompany_DatabaseName] DEFAULT ('') FOR [DatabaseName]
GO

ALTER TABLE [dbo].[APrdofLine] ADD 
	CONSTRAINT [DF_APrdofLine_BegDate] DEFAULT ('') FOR [BegDate],
	CONSTRAINT [DF_APrdofLine_EndDate] DEFAULT ('') FOR [EndDate],
	CONSTRAINT [DF_APrdofLine_State] DEFAULT ('') FOR [State],
	CONSTRAINT [DF_APrdofLine_createUser] DEFAULT ('') FOR [createUser],
	CONSTRAINT [DF_APrdofLine_createDate] DEFAULT ('') FOR [createDate],
	CONSTRAINT [DF_APrdofLine_memo_1] DEFAULT ('') FOR [memo],
	CONSTRAINT [DF_APrdofLine_Ver] DEFAULT (0) FOR [Ver],
	CONSTRAINT [IX_APrdofLine] UNIQUE  NONCLUSTERED 
	(
		[PrdPlanNO],
		[CompanyCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[APrdofLineSub] ADD 
	CONSTRAINT [DF_APrdofLineSub_BegPrdDate] DEFAULT ('') FOR [BegPrdDate],
	CONSTRAINT [DF_APrdofLineSub_PrdQty] DEFAULT (0) FOR [PrdQty],
	CONSTRAINT [DF_APrdofLine_memo] DEFAULT ('') FOR [memo]
GO

ALTER TABLE [dbo].[ASeloptions] ADD 
	CONSTRAINT [DF_Pul_Seloptions_defvalue1] DEFAULT ('') FOR [defvalue1],
	CONSTRAINT [DF_Pul_Seloptions_defvalue2] DEFAULT ('') FOR [defvalue2],
	CONSTRAINT [DF_Pul_Seloptions_seltable] DEFAULT ('') FOR [seltable],
	CONSTRAINT [DF_Pul_Seloptions_selflds] DEFAULT ('') FOR [selflds],
	CONSTRAINT [DF_Pul_Seloptions_selfilter] DEFAULT ('') FOR [selfilter],
	CONSTRAINT [DF_Pul_Seloptions_apply] DEFAULT (1) FOR [apply],
	CONSTRAINT [DF_Pul_Seloptions_issinglefld] DEFAULT (0) FOR [issinglefld],
	CONSTRAINT [DF_Pul_Seloptions_SubtableName] DEFAULT ('') FOR [SubtableName],
	CONSTRAINT [DF_Pul_Seloptions_SubtableFld] DEFAULT ('') FOR [SubtableFld]
GO

ALTER TABLE [dbo].[AccPeriod] ADD 
	CONSTRAINT [DF_AccPeriod_IsCurrent] DEFAULT (0) FOR [IsCurrent]
GO

ALTER TABLE [dbo].[BakupDocus_s1] ADD 
	CONSTRAINT [DF_BakupDocus_s1_Is_status] DEFAULT (0) FOR [Is_status],
	CONSTRAINT [DF_BakupDocus_s1_status_name] DEFAULT ('') FOR [status_name],
	CONSTRAINT [DF_BakupDocus_s1_IsRequired] DEFAULT (1) FOR [IsRequired],
	CONSTRAINT [DF_BakupDocus_s1_PreOP_Button_name] DEFAULT ('') FOR [PreOP_Button_name]
GO

ALTER TABLE [dbo].[BakupOld_Operate_Log] ADD 
	CONSTRAINT [DF_BakupOld_Operate_Log_Docu_id] DEFAULT (1) FOR [Docu_id],
	CONSTRAINT [DF_BakupOld_Operate_Log_Operate_time] DEFAULT (getdate()) FOR [Operate_time]
GO

ALTER TABLE [dbo].[CR_Main] ADD 
	CONSTRAINT [DF_CR_Main_PLAN_GO_ADDR] DEFAULT ('') FOR [PLAN_GO_ADDR],
	CONSTRAINT [DF_CR_Main_GOODS_WH] DEFAULT ('') FOR [GOODS_WH],
	CONSTRAINT [DF_CR_Main_REQ_CAR_TYPE] DEFAULT ('') FOR [REQ_CAR_TYPE],
	CONSTRAINT [DF_CR_Main_PLAN_COST] DEFAULT (0) FOR [PLAN_COST],
	CONSTRAINT [DF_CR_Main_FACT_COST] DEFAULT (0) FOR [FACT_COST],
	CONSTRAINT [DF_CR_Main_MEMO] DEFAULT ('') FOR [MEMO],
	CONSTRAINT [DF_CR_Main_Make_by] DEFAULT ('') FOR [Make_by],
	CONSTRAINT [DF_CR_Main_Make_Date] DEFAULT ('') FOR [Make_Date],
	CONSTRAINT [DF_CR_Main_Audit_by] DEFAULT ('') FOR [Audit_by],
	CONSTRAINT [DF_CR_Main_Audit_Date] DEFAULT ('') FOR [Audit_Date],
	CONSTRAINT [DF_CR_Main_Author_by] DEFAULT ('') FOR [Author_by],
	CONSTRAINT [DF_CR_Main_Author_Date] DEFAULT ('') FOR [Author_Date]
GO

ALTER TABLE [dbo].[Discuss] ADD 
	CONSTRAINT [DF_Discuss_dis_titile] DEFAULT ('') FOR [Docu_Code],
	CONSTRAINT [DF_Discuss_discussType2] DEFAULT ('') FOR [dis_title],
	CONSTRAINT [DF_Discuss_user_name] DEFAULT ('') FOR [user_name],
	CONSTRAINT [DF_Discuss_dis_content] DEFAULT ('') FOR [dis_content],
	CONSTRAINT [DF_Discuss_dis_time] DEFAULT (getdate()) FOR [dis_time]
GO

ALTER TABLE [dbo].[Docus_s1] ADD 
	CONSTRAINT [DF_Docus_s1_Is_status] DEFAULT (0) FOR [Is_status],
	CONSTRAINT [DF_Docus_s1_status_name] DEFAULT ('') FOR [status_name],
	CONSTRAINT [DF_Docus_s1_IsRequired] DEFAULT (1) FOR [IsRequired],
	CONSTRAINT [DF_Docus_s1_PreOP_Button_name] DEFAULT ('') FOR [PreOP_Button_name]
GO

ALTER TABLE [dbo].[Docus_s2] ADD 
	CONSTRAINT [DF_Docus_s2_operates] DEFAULT ('email') FOR [operates]
GO

ALTER TABLE [dbo].[ECN_Main] ADD 
	CONSTRAINT [DF_ECN_Main_Author_Tech] DEFAULT ('') FOR [Author_Tech],
	CONSTRAINT [DF_ECN_Main_Author_Manager] DEFAULT ('') FOR [Author_Manager],
	CONSTRAINT [DF_ECN_Main_Else_desc] DEFAULT ('') FOR [Else_desc],
	CONSTRAINT [DF_ECN_Main_Else_change] DEFAULT ('') FOR [Else_change]
GO

ALTER TABLE [dbo].[ECN_Sub] ADD 
	CONSTRAINT [DF_ECN_Sub_Change_desc] DEFAULT ('') FOR [Change_desc]
GO

ALTER TABLE [dbo].[EW_Main] ADD 
	CONSTRAINT [DF_EW_Main_Make_by] DEFAULT ('') FOR [Make_by],
	CONSTRAINT [DF_EW_Main_Make_Date] DEFAULT ('') FOR [Make_Date],
	CONSTRAINT [DF_EW_Main_Audit_by] DEFAULT ('') FOR [Audit_by],
	CONSTRAINT [DF_EW_Main_Audit_Date] DEFAULT ('') FOR [Audit_Date],
	CONSTRAINT [DF_EW_Main_Author_by] DEFAULT ('') FOR [Author_by],
	CONSTRAINT [DF_EW_Main_Author_Date] DEFAULT ('') FOR [Author_Date]
GO

ALTER TABLE [dbo].[EW_Sub] ADD 
	CONSTRAINT [DF_EW_Main_MEMO] DEFAULT ('') FOR [MEMO]
GO

ALTER TABLE [dbo].[Emp_Contract] ADD 
	CONSTRAINT [DF_Emp_Contract_orginazeComCode] DEFAULT ('') FOR [orginazeComCode],
	CONSTRAINT [DF_Emp_Contract_orginazeNo1] DEFAULT ('') FOR [orginazeNo1],
	CONSTRAINT [DF_Emp_Contract_orginazeNo2] DEFAULT ('') FOR [orginazeNo2],
	CONSTRAINT [DF_Emp_Contract_orginazeNo3] DEFAULT ('') FOR [orginazeNo3],
	CONSTRAINT [DF_Emp_Contract_user_ename] DEFAULT ('') FOR [user_ename],
	CONSTRAINT [DF_Emp_Contract_user_cname] DEFAULT ('') FOR [user_cname],
	CONSTRAINT [DF_Emp_Contract_is_current] DEFAULT (0) FOR [is_current],
	CONSTRAINT [DF_Emp_Contract_contractState] DEFAULT ('') FOR [contractState],
	CONSTRAINT [DF_Emp_Contract_IDCard] DEFAULT ('') FOR [IDCard],
	CONSTRAINT [DF_Emp_Contract_birthday] DEFAULT ('') FOR [birthday],
	CONSTRAINT [DF_Emp_Contract_degree] DEFAULT ('') FOR [degree],
	CONSTRAINT [DF_Emp_Contract_specialty] DEFAULT ('') FOR [specialty],
	CONSTRAINT [DF_Emp_Contract_graduate_date] DEFAULT ('') FOR [graduate_date],
	CONSTRAINT [DF_Emp_Contract_native_place] DEFAULT ('') FOR [native_place],
	CONSTRAINT [DF_Emp_Contract_registered_place] DEFAULT ('') FOR [registered_place],
	CONSTRAINT [DF_Emp_Contract_current_place] DEFAULT ('') FOR [current_place],
	CONSTRAINT [DF_Emp_Contract_apply_way] DEFAULT ('') FOR [apply_way],
	CONSTRAINT [DF_Emp_Contract_introducer] DEFAULT ('') FOR [introducer],
	CONSTRAINT [DF_Emp_Contract_contract_begin] DEFAULT ('') FOR [contract_begin],
	CONSTRAINT [DF_Emp_Contract_contract_end] DEFAULT ('') FOR [contract_end],
	CONSTRAINT [DF_Emp_Contract_contract_times_af2008] DEFAULT (0) FOR [contract_times_af2008],
	CONSTRAINT [DF_Emp_Contract_arrive_date] DEFAULT ('') FOR [arrive_date],
	CONSTRAINT [DF_Emp_Contract_leave_date] DEFAULT ('') FOR [leave_date],
	CONSTRAINT [DF_Emp_Contract_leave_type] DEFAULT ('') FOR [leave_type],
	CONSTRAINT [DF_Emp_Contract_emp_phone] DEFAULT ('') FOR [emp_phone],
	CONSTRAINT [DF_Emp_Contract_emp_mobile] DEFAULT ('') FOR [emp_mobile],
	CONSTRAINT [DF_Emp_Contract_memo] DEFAULT ('') FOR [memo],
	CONSTRAINT [DF_Emp_Contract_ver] DEFAULT (0) FOR [ver]
GO

ALTER TABLE [dbo].[Fllow_List] ADD 
	CONSTRAINT [DF_Fllow_List_Button_desc] DEFAULT ('') FOR [Button_desc],
	CONSTRAINT [DF_Fllow_List_Is_status] DEFAULT (0) FOR [Is_status],
	CONSTRAINT [DF_Fllow_List_Compstatus_name] DEFAULT ('') FOR [Compstatus_name],
	CONSTRAINT [DF_Fllow_List_IsRequired] DEFAULT (0) FOR [IsRequired],
	CONSTRAINT [DF_Fllow_List_CanOP_ByDocu_Code] DEFAULT ('') FOR [CanOP_ByDocu_Code],
	CONSTRAINT [DF_Fllow_List_CanOP_ByOperator] DEFAULT ('') FOR [CanOP_ByOperator],
	CONSTRAINT [DF_Fllow_List_CanOP_ByElse] DEFAULT ('') FOR [CanOP_ByElse],
	CONSTRAINT [DF_Fllow_List_CanOP_ByElse_Para] DEFAULT ('') FOR [CanOP_ByElse_Para],
	CONSTRAINT [DF_Fllow_List_CanUseButtons] DEFAULT ('') FOR [CanUseButtons]
GO

ALTER TABLE [dbo].[GAPOperate_Log] ADD 
	CONSTRAINT [DF__GAPOperat__Docu___07E124C1] DEFAULT (2) FOR [Docu_id],
	CONSTRAINT [DF__GAPOperat__Opera__08D548FA] DEFAULT (getdate()) FOR [Operate_time]
GO

ALTER TABLE [dbo].[GAP_Main] ADD 
	CONSTRAINT [DF_GAP_GAP_Dep] DEFAULT ('') FOR [GAP_Dep],
	CONSTRAINT [DF_GAP_GAP_Reason] DEFAULT ('') FOR [GAP_Reason],
	CONSTRAINT [DF_GAP_GAP_Date] DEFAULT ('') FOR [GAP_Date],
	CONSTRAINT [DF_GAP_ERP_Code] DEFAULT ('') FOR [ERP_Code],
	CONSTRAINT [DF_GAP_ERP_Name] DEFAULT ('') FOR [ERP_Name],
	CONSTRAINT [DF_GAP_Mat_Class] DEFAULT ('') FOR [Mat_Class],
	CONSTRAINT [DF_GAP_Unit] DEFAULT ('') FOR [Base_Unit],
	CONSTRAINT [DF_GAP_Pic_Code] DEFAULT ('') FOR [Pic_Code],
	CONSTRAINT [DF_GAP_Use_state] DEFAULT ('') FOR [Use_State],
	CONSTRAINT [DF_GAP_Tech_User_name] DEFAULT ('') FOR [Tech_User_Name],
	CONSTRAINT [DF_GAP_Tech_User_Time] DEFAULT ('') FOR [Tech_User_Time],
	CONSTRAINT [DF_GAP_Store_ware] DEFAULT ('') FOR [Store_Ware],
	CONSTRAINT [DF_GAP_ware_unit] DEFAULT ('') FOR [Ware_Unit],
	CONSTRAINT [DF_GAP_Store_Unit] DEFAULT ('') FOR [Store_Unit],
	CONSTRAINT [DF_GAP_Vendor_name] DEFAULT ('') FOR [Vendor_Name],
	CONSTRAINT [DF_GAP_Pur_Period] DEFAULT ('') FOR [Pur_Period],
	CONSTRAINT [DF_GAP_Pur_Unit] DEFAULT ('') FOR [Pur_Unit],
	CONSTRAINT [DF_GAP_Low_Lot] DEFAULT ('') FOR [Low_Lot],
	CONSTRAINT [DF_GAP_Purchaser] DEFAULT ('') FOR [Purchaser],
	CONSTRAINT [DF_GAP_Pur_User_name] DEFAULT ('') FOR [Pur_User_Name],
	CONSTRAINT [DF_GAP_Pur_User_Time] DEFAULT ('') FOR [Pur_User_Time],
	CONSTRAINT [DF_GAP_Plan_Strategy] DEFAULT (0) FOR [Plan_Strategy],
	CONSTRAINT [DF_GAP_Pur_Strategy] DEFAULT ('') FOR [Pur_Strategy],
	CONSTRAINT [DF_GAP_Safe_Qty] DEFAULT (0) FOR [Safe_Qty],
	CONSTRAINT [DF_GAP_MRPMergeRequire] DEFAULT (0) FOR [MRPMergeRequire],
	CONSTRAINT [DF_GAP_Key_Goods] DEFAULT (0) FOR [Key_Goods],
	CONSTRAINT [DF_GAP_Plan_User_name] DEFAULT ('') FOR [Plan_User_Name],
	CONSTRAINT [DF_GAP_QC_Type] DEFAULT (0) FOR [QC_Type],
	CONSTRAINT [DF_GAP_QC_ManageMethod] DEFAULT ('') FOR [QC_ManageMethod],
	CONSTRAINT [DF_GAP_QC_GNT] DEFAULT ('') FOR [QC_GNT],
	CONSTRAINT [DF_GAP_Guarant_days] DEFAULT ('') FOR [Guarant_Days],
	CONSTRAINT [DF_GAP_QC_User_name] DEFAULT ('') FOR [QC_User_Name],
	CONSTRAINT [DF_GAP_QC_User_Time] DEFAULT ('') FOR [QC_User_Time],
	CONSTRAINT [DF_GAP_ERP_User_name] DEFAULT ('') FOR [ERP_User_Name],
	CONSTRAINT [DF_GAP_ERP_Date] DEFAULT ('') FOR [ERP_User_Time],
	CONSTRAINT [DF_GAP_MEMO] DEFAULT ('') FOR [MEMO],
	CONSTRAINT [DF_GAP_Curr_State] DEFAULT ('') FOR [Curr_State],
	CONSTRAINT [DF_GAP_ERP_RegDate] DEFAULT (convert(varchar(30),getdate(),126)) FOR [Row_ID]
GO

ALTER TABLE [dbo].[GAP_Rights] ADD 
	CONSTRAINT [DF_GAP_Rights_State_ID] DEFAULT (0) FOR [State_ID],
	CONSTRAINT [DF_GAP_Rights_State_Name] DEFAULT ('') FOR [State_Name],
	CONSTRAINT [DF_GAP_Rights_Enabled_Btns] DEFAULT ('') FOR [Enabled_Btns],
	CONSTRAINT [DF_GAP_Rights_Enabled_Conts] DEFAULT ('') FOR [Enabled_Conts],
	CONSTRAINT [DF_GAP_Rights_Enabled_User_Dep] DEFAULT (0) FOR [Enabled_User_Dep],
	CONSTRAINT [IX_GAP_Rights] UNIQUE  NONCLUSTERED 
	(
		[State_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[LEAVE_Main] ADD 
	CONSTRAINT [DF_LEAVE_Main_POSIT] DEFAULT ('') FOR [POSIT],
	CONSTRAINT [DF_LEAVE_Main_DATE_FROM] DEFAULT ('') FOR [DATE_FROM],
	CONSTRAINT [DF_LEAVE_Main_TIME_FROM] DEFAULT ('') FOR [TIME_FROM],
	CONSTRAINT [DF_LEAVE_Main_DATE_TO] DEFAULT ('') FOR [DATE_TO],
	CONSTRAINT [DF_LEAVE_Main_TIME_TO] DEFAULT ('') FOR [TIME_TO],
	CONSTRAINT [DF_LEAVE_Main_CR_REASON] DEFAULT ('') FOR [LR_REASON],
	CONSTRAINT [DF_LEAVE_Main_WORK_HAND] DEFAULT ('') FOR [WORK_HAND],
	CONSTRAINT [DF_LEAVE_Main_MEMO] DEFAULT ('') FOR [MEMO],
	CONSTRAINT [DF_LEAVE_Main_Make_by] DEFAULT ('') FOR [Make_by],
	CONSTRAINT [DF_LEAVE_Main_Make_Date] DEFAULT ('') FOR [Make_Date],
	CONSTRAINT [DF_LEAVE_Main_Audit_by] DEFAULT ('') FOR [Audit_by],
	CONSTRAINT [DF_LEAVE_Main_Audit_Date] DEFAULT ('') FOR [Audit_Date],
	CONSTRAINT [DF_LEAVE_Main_Author_by] DEFAULT ('') FOR [Author_by],
	CONSTRAINT [DF_LEAVE_Main_Author_Date] DEFAULT ('') FOR [Author_Date]
GO

ALTER TABLE [dbo].[MailLog] ADD 
	CONSTRAINT [DF_MailLog_msg] DEFAULT ('') FOR [msg],
	CONSTRAINT [DF_MailLog_opdate] DEFAULT (getdate()) FOR [opdate]
GO

ALTER TABLE [dbo].[MoudleSYS] ADD 
	CONSTRAINT [DF_MoudleSYS_MenuName] DEFAULT ('') FOR [MenuName],
	CONSTRAINT [DF_MoudleSYS_BelongtoSubSysID] DEFAULT (1) FOR [BelongtoSubSysID]
GO

ALTER TABLE [dbo].[MyFiles] ADD 
	CONSTRAINT [DF_MyFiles_FTitle] DEFAULT ('') FOR [FTitle],
	CONSTRAINT [DF_MyFiles_create_user] DEFAULT ('') FOR [create_user]
GO

ALTER TABLE [dbo].[OABuild] ADD 
	CONSTRAINT [DF_OABuild_BuildDesc] DEFAULT ('') FOR [Memo]
GO

ALTER TABLE [dbo].[OABuildSub] ADD 
	CONSTRAINT [DF_OABuildSub_Emp01Name] DEFAULT ('') FOR [Emp01Name],
	CONSTRAINT [DF_OABuildSub_Emp02Name] DEFAULT ('') FOR [Emp02Name],
	CONSTRAINT [DF_OABuildSub_Emp03Name] DEFAULT ('') FOR [Emp03Name],
	CONSTRAINT [DF_OABuildSub_Emp04Name] DEFAULT ('') FOR [Emp04Name],
	CONSTRAINT [DF_OABuildSub_Emp05Name] DEFAULT ('') FOR [Emp05Name],
	CONSTRAINT [DF_OABuildSub_Emp06Name] DEFAULT ('') FOR [Emp06Name],
	CONSTRAINT [DF_OABuildSub_Emp07Name] DEFAULT ('') FOR [Emp07Name],
	CONSTRAINT [DF_OABuildSub_Emp08Name] DEFAULT ('') FOR [Emp08Name],
	CONSTRAINT [DF_OABuildSub_Emp01InDate] DEFAULT ('') FOR [Emp01InDate],
	CONSTRAINT [DF_OABuildSub_Emp02InDate] DEFAULT ('') FOR [Emp02InDate],
	CONSTRAINT [DF_OABuildSub_Emp03InDate] DEFAULT ('') FOR [Emp03InDate],
	CONSTRAINT [DF_OABuildSub_Emp04InDate] DEFAULT ('') FOR [Emp04InDate],
	CONSTRAINT [DF_OABuildSub_Emp05InDate] DEFAULT ('') FOR [Emp05InDate],
	CONSTRAINT [DF_OABuildSub_Emp06InDate] DEFAULT ('') FOR [Emp06InDate],
	CONSTRAINT [DF_OABuildSub_Emp07InDate] DEFAULT ('') FOR [Emp07InDate],
	CONSTRAINT [DF_OABuildSub_Emp08InDate] DEFAULT ('') FOR [Emp08InDate]
GO

ALTER TABLE [dbo].[OAFiles] ADD 
	CONSTRAINT [DF_OAFiles_FTitle] DEFAULT ('') FOR [FTitle],
	CONSTRAINT [DF_OAFiles_create_user] DEFAULT ('') FOR [create_user],
	CONSTRAINT [DF_OAFiles_fclass] DEFAULT ('') FOR [fclass]
GO

ALTER TABLE [dbo].[OAMinds] ADD 
	CONSTRAINT [DF_OANote_Note_content] DEFAULT ('') FOR [Mind_content],
	CONSTRAINT [DF_OANote_Note_class] DEFAULT ('') FOR [Mind_class],
	CONSTRAINT [IX_OAMinds] UNIQUE  NONCLUSTERED 
	(
		[Mind_title]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[OANews] ADD 
	CONSTRAINT [DF_OANews_News_brief] DEFAULT ('公告') FOR [News_brief],
	CONSTRAINT [DF_OANews_News_content] DEFAULT ('') FOR [News_content],
	CONSTRAINT [DF_OANews_News_class] DEFAULT ('') FOR [News_class]
GO

ALTER TABLE [dbo].[Operate_Log] ADD 
	CONSTRAINT [DF_Operate_Log_Docu_id] D