contact0310.sql

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

	[FID] [int] IDENTITY (1, 1) NOT NULL ,
	[fclass] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OAMinds] (
	[Mind_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Mind_title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Mind_content] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Mind_class] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_user] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_dm] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OANews] (
	[News_id] [int] NOT NULL ,
	[News_brief] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[News_title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[News_content] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[News_class] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_userid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[create_dm] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Operate_Log] (
	[AutoRec] [int] IDENTITY (1, 1) NOT NULL ,
	[Docu_id] [int] NOT NULL ,
	[Docu_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Operate_uid] [int] NOT NULL ,
	[Button_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Operate_time] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PR_Main] (
	[PR_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PR_DEP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PR_EMP] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PR_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[REQ_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MEMO] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Make_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Make_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Audit_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Audit_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author_by] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author_Date] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PR_Sub] (
	[PR_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SEQ] [int] NOT NULL ,
	[STOCK_CODE] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[STOCK_NAME] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[STOCK_RULE] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[STOCK_UNIT] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PR_QTY] [numeric](18, 3) NOT NULL ,
	[MEMO] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tables] (
	[tabename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tabcname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tabdesc] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Preword] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TrueOperate_Log] (
	[AutoRec] [int] IDENTITY (1, 1) NOT NULL ,
	[Docu_id] [int] NOT NULL ,
	[Docu_Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Operate_uid] [int] NOT NULL ,
	[Button_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Operate_time] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ttemp] (
	[f1] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[users] (
	[uid] [int] NOT NULL ,
	[user_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_details] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pass] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[last_logon] [smalldatetime] NOT NULL ,
	[depid] [int] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ACompany] WITH NOCHECK ADD 
	CONSTRAINT [PK_ACompany] PRIMARY KEY  CLUSTERED 
	(
		[CompanyCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[APrdofLine] WITH NOCHECK ADD 
	CONSTRAINT [PK_APrdofLine] PRIMARY KEY  CLUSTERED 
	(
		[PrdPlanNO]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[APrdofLineSub] WITH NOCHECK ADD 
	CONSTRAINT [PK_APrdofLineSub] PRIMARY KEY  CLUSTERED 
	(
		[PrdPlanNO],
		[Seq]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ASeloptions] WITH NOCHECK ADD 
	CONSTRAINT [PK_Pul_Seloptions] PRIMARY KEY  CLUSTERED 
	(
		[Userid],
		[formid],
		[Line]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AccPeriod] WITH NOCHECK ADD 
	CONSTRAINT [PK_AccPeriod] PRIMARY KEY  CLUSTERED 
	(
		[CompanyCode],
		[AccPeriodCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[BakupDocus_s1] WITH NOCHECK ADD 
	CONSTRAINT [PK_BakupDocus_s1] PRIMARY KEY  CLUSTERED 
	(
		[Docu_id],
		[Button_name]
	)  ON [PRIMARY] 
GO

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

ALTER TABLE [dbo].[CR_Main] WITH NOCHECK ADD 
	CONSTRAINT [PK_CR_Main] PRIMARY KEY  CLUSTERED 
	(
		[CR_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Depart] WITH NOCHECK ADD 
	CONSTRAINT [PK_Depart] PRIMARY KEY  CLUSTERED 
	(
		[Depart_code]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Discuss] WITH NOCHECK ADD 
	CONSTRAINT [PK_Discuss] PRIMARY KEY  CLUSTERED 
	(
		[rec]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Docus] WITH NOCHECK ADD 
	CONSTRAINT [PK_Docus] PRIMARY KEY  CLUSTERED 
	(
		[Docu_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Docus_s1] WITH NOCHECK ADD 
	CONSTRAINT [PK_Docus_s1] PRIMARY KEY  CLUSTERED 
	(
		[Docu_id],
		[Button_name]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Docus_s2] WITH NOCHECK ADD 
	CONSTRAINT [PK_Docus_s2] PRIMARY KEY  CLUSTERED 
	(
		[Docu_id],
		[button_name],
		[uid_seq]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ECN_Main] WITH NOCHECK ADD 
	CONSTRAINT [PK_ECN_Main] PRIMARY KEY  CLUSTERED 
	(
		[ECN_Code]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ECN_Sub] WITH NOCHECK ADD 
	CONSTRAINT [PK_ECN_Sub] PRIMARY KEY  CLUSTERED 
	(
		[ECN_Code],
		[seq]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[EW_Main] WITH NOCHECK ADD 
	CONSTRAINT [PK_EW_Main_1] PRIMARY KEY  CLUSTERED 
	(
		[EW_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[EW_Sub] WITH NOCHECK ADD 
	CONSTRAINT [PK_EW_Main] PRIMARY KEY  CLUSTERED 
	(
		[EW_ID],
		[SEQ]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Emp_Contract] WITH NOCHECK ADD 
	CONSTRAINT [PK_Emp_Contract] PRIMARY KEY  CLUSTERED 
	(
		[contractNo]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Fllow_List] WITH NOCHECK ADD 
	CONSTRAINT [PK_Fllow_List] PRIMARY KEY  CLUSTERED 
	(
		[Docu_id],
		[Button_name]
	)  ON [PRIMARY] 
GO

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

ALTER TABLE [dbo].[GAP_Main] WITH NOCHECK ADD 
	CONSTRAINT [PK_GAP] PRIMARY KEY  CLUSTERED 
	(
		[GAP_Code]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[GAP_Rights] WITH NOCHECK ADD 
	CONSTRAINT [PK_GAP_Rights] PRIMARY KEY  CLUSTERED 
	(
		[State_Name]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[LEAVE_Main] WITH NOCHECK ADD 
	CONSTRAINT [PK_LEAVE_Main] PRIMARY KEY  CLUSTERED 
	(
		[LR_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[MoudleSYS] WITH NOCHECK ADD 
	CONSTRAINT [PK_MoudleSYS] PRIMARY KEY  CLUSTERED 
	(
		[MoudleName],
		[MenuName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[MyFiles] WITH NOCHECK ADD 
	CONSTRAINT [PK_MyFiles] PRIMARY KEY  CLUSTERED 
	(
		[FID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[OABuild] WITH NOCHECK ADD 
	CONSTRAINT [PK_OABuild] PRIMARY KEY  CLUSTERED 
	(
		[BuildID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[OABuildSub] WITH NOCHECK ADD 
	CONSTRAINT [PK_OABuildSub] PRIMARY KEY  CLUSTERED 
	(
		[BuildID],
		[RoomID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[OAFiles] WITH NOCHECK ADD 
	CONSTRAINT [PK_OAFiles] PRIMARY KEY  CLUSTERED 
	(
		[FID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[OAMinds] WITH NOCHECK ADD 
	CONSTRAINT [PK_OANotes] PRIMARY KEY  CLUSTERED 
	(
		[Mind_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[OANews] WITH NOCHECK ADD 
	CONSTRAINT [PK_OANews] PRIMARY KEY  CLUSTERED 
	(
		[News_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Operate_Log] WITH NOCHECK ADD 
	CONSTRAINT [PK_Operate_Log] PRIMARY KEY  CLUSTERED 
	(
		[AutoRec]
	)  ON [PRIMARY]