E测试管理系统（Excel + SQL Server）

--脚本日期:2012-09-24(添加用例执行记录表版本) --脚本日期：2013-06-09 (添加测试用例修改记录表) SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --创建测试环境基础数据表 CREATE TABLE [dbo].[T_TESTENVIRONMENT]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_T_TESTENVIRONMENT] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建用户表 CREATE TABLE [dbo].[T_USER]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FUSERNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FPASSWORD] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [FPOST] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [FITEMID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FLASTUPDATETIME] [datetime] NULL, [FLASTUPDATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_T_USER] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建模块表 CREATE TABLE [dbo].[T_MOUDLE]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FTASKID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS not NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS not NULL, CONSTRAINT [PK_T_MOUDLE] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建语言版本基础数据表 CREATE TABLE [dbo].[T_LANGUAGE]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_T_LANGUAGE] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建任务序列表 CREATE TABLE [dbo].[T_ITEMLIST]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCODE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Fname] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_T_ITEMLIST] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建项目版本表 CREATE TABLE [dbo].[T_ITEMVERSION]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FTaskID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FVersion] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNow] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [FCreateTime] [datetime] NOT NULL, [FCreateUserID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_T_ITEMVERSION] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建BUG类型基础数据表 CREATE TABLE [dbo].[T_BUGTYPE]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_T_BUGTYPE] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建处理日志表 CREATE TABLE [dbo].[T_BUGTRANSACTLOG]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FBUGID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FBEFORESTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FAFTERSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FTRANSACTUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FTRANSACTTIME] [datetime] NOT NULL, [FTRANSACT] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNEXTTRANSACTUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_T_BUGTRANSACTLOG] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建BUG优先级基础数据表 CREATE TABLE [dbo].[T_BUGPRI]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_T_BUGPRI] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建发现阶段基础数据表 CREATE TABLE [dbo].[T_BUGFINDPHASE]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FNAME] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCREATETIME] [datetime] NOT NULL, [FCREATEUSERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_T_BUGFINDPHASE] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建BUG记录表 CREATE TABLE [dbo].[T_BUGDESCRIPTION]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FBUGDESCRIPTION] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NOT NULL, [FTASKID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FMOUDLENAMEID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FBUGPRIID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FBUGTYPEID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FBUGFINDPHASEID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FSTATE] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FTESTENVIRONMENTID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [FBUGFVersion] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [FTESTTIME] [datetime] NOT NULL, [FTESTERID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FREFERTIME] [datetime] NULL, [FBUGXVersion] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [FREMARK] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_T_BUGDESCRIPTION] PRIMARY KEY CLUSTERED ( [FID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] --创建附件记录表 CREATE TABLE [dbo].[T_BUGACCESSORY]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FBUGID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FACCESSORYPATH] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NOT NULL, [FUPLOADUSER] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FUPLOADDATE] [datetime] NOT NULL ) ON [PRIMARY] --创建用例列表 CREATE TABLE [dbo].[T_TestCase]( [FID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FTaskID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FMoudleID] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCaseName] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCaseBefore] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL, [FCaseData] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL, [FCaseStep] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL, [FExpectResult] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NOT NULL, [FRemark] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [Fstate] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Flock] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [FCreateTime] [datetime] NOT NULL, [FCreateUserID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [