ASP.NET MVC 项目管理系统（VS2010）

create database Project USE [Project] GO /****** 对象: Table [dbo].[CV] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CV]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[CV]( [id] [int] IDENTITY(1,1) NOT NULL, [FileName] [nvarchar](40) NULL, [FileType] [nvarchar](40) NULL, [File] [ntext] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO /****** 对象: Table [dbo].[grade] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[grade]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[grade]( [grade] [int] NOT NULL, CONSTRAINT [PK_grade] PRIMARY KEY CLUSTERED ( [grade] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[skill] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[skill]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[skill]( [skill] [varchar](50) NOT NULL, CONSTRAINT [PK_skill] PRIMARY KEY CLUSTERED ( [skill] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[User_Function] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User_Function]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[User_Function]( [f_id] [int] identity(1,1) NOT NULL, [f_name] [varchar](50) NULL, [f_des] [varchar](100) NULL, PRIMARY KEY CLUSTERED ( [f_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[User_Group] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User_Group]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[User_Group]( [group_id] [int] identity(1,1) NOT NULL, [group_name] [varchar](20) NOT NULL, [group_power] [varchar](100) NOT NULL, PRIMARY KEY CLUSTERED ( [group_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[position] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[position]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[position]( [position] [varchar](30) NOT NULL, CONSTRAINT [PK_position] PRIMARY KEY CLUSTERED ( [position] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[news] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[news]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[news]( [id] [int] IDENTITY(1,1) NOT NULL, [title] [varchar](50) NOT NULL, [type] [smallint] NULL, [content] [text] NULL, [time_at] [char](8) NOT NULL, [keyw] [varchar](50) NULL, [write] [varchar](50) NULL, CONSTRAINT [PK_news] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO /****** 对象: Table [dbo].[Client] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Client]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Client]( [client_id] [int] identity(1,1) NOT NULL, [client_name] [varchar](30) NOT NULL, [client_address] [varchar](100) NOT NULL, [client_phone] [varchar](15) NOT NULL, PRIMARY KEY CLUSTERED ( [client_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[mskill] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[mskill]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[mskill]( [id] [int] IDENTITY(1,1) NOT NULL, [skill] [varchar](50) NOT NULL, [grade] [int] NOT NULL, [employee_id] [char](8) NULL, CONSTRAINT [PK_mskill] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[EmployeeExperience] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EmployeeExperience]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[EmployeeExperience]( [experience_id] [int] IDENTITY(1,1) NOT NULL, [employee_id] [char](8) NULL, [project_id] [char](10) NULL, [project_name] [varchar](50) NOT NULL, [project_starttime] [char](8) NOT NULL, [project_endtime] [char](8) NOT NULL, [position] [varchar](30) NOT NULL, [work_content] [text] NOT NULL, CONSTRAINT [PK_EmployeeExperience] PRIMARY KEY CLUSTERED ( [experience_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO /****** 对象: Table [dbo].[Technology] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Technology]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Technology]( [employee_id] [char](8) NOT NULL, [Linux] [char](10) NULL, [Solaris] [char](10) NULL, [Java] [char](10) NULL, [CandCPlusPlus] [char](10) NULL, [Net] [char](10) NULL, [SqlServer] [char](10) NULL, [Oracle] [char](10) NULL, PRIMARY KEY CLUSTERED ( [employee_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[User_Login] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User_Login]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[User_Login]( [employee_id] [char](8) NOT NULL, [user_name] [varchar](15) NOT NULL, [user_password] [varchar](15) NOT NULL, [group_ids] [varchar](30) NOT NULL, PRIMARY KEY CLUSTERED ( [employee_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[ProjectDetails] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProjectDetails]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[ProjectDetails]( [project_id] [int] identity(1,1) NOT NULL, [project_name] [char](30) not null, [project_type] [varchar](20) NOT NULL, [importance] [char](1) NOT NULL, [main_technology] [varchar](20) NOT NULL, [starttime] [char](8) NOT NULL, [endtime] [char](8) NULL, [business_field] [varchar](30) NULL, [client_id] [int] NULL, [department] [varchar](20) NOT NULL, [manager_id] [char](8) NULL, [number_of_people] [int] NULL, [project_status] [varchar](20) NULL, CONSTRAINT [PK__ProjectDetails__0519C6AF] PRIMARY KEY CLUSTERED ( [project_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /****** 对象: Table [dbo].[Employee] 脚本日期: 04/27/2011 09:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Employee]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Employee]