003 建立table

Post date: 2014/9/18 上午 11:20:02

USE [LearningKing]

GO

/****** Object: Table [dbo].[UpdateLists] Script Date: 2014/9/9 上午 09:51:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UpdateLists](

[LogNo] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

[UpdateDate] [datetime] NOT NULL,

[UpdateName] [nvarchar](60) NOT NULL,

[UpdateStatus] [nvarchar](1) NOT NULL,

[TotalFiles] [numeric](18, 2) NOT NULL,

[FinishFiles] [numeric](18, 2) NOT NULL,

[Percentage] [numeric](18, 2) NOT NULL,

[StartTime] [datetime] NULL,

[EndTime] [datetime] NULL,

[UpdateType] [nvarchar](2) NOT NULL,

[CourseID] [nvarchar](20) NOT NULL,

[VideoID] [nvarchar](20) NOT NULL,

[PageNo] [numeric](18, 2) NOT NULL,

[DisplayName] [nvarchar](60) NOT NULL,

[FileName] [nvarchar](300) NOT NULL,

[GroupID] [nvarchar](20) NULL,

[VersionID] [nvarchar](20) NULL,

[VerDataY] [nvarchar](1) NOT NULL,

[VerDataB] [nvarchar](1) NOT NULL,

[VerDataS] [nvarchar](1) NOT NULL,

[VerDataN] [nvarchar](1) NOT NULL,

[VerDataP] [nvarchar](1) NOT NULL,

[ExamQty] [numeric](18, 2) NOT NULL,

[SysLogDate] [datetime] NOT NULL,

CONSTRAINT [PK_UpdateLists] PRIMARY KEY NONCLUSTERED

(

[LogNo] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO