lyfz_repos/铂金版源码/K考勤模块/考勤Sql/lonindata.sql


/*
***** 对象:  Table [dbo].[lonindata]  打卡记录  脚本日期: 04/27/2015 14:23:00 *****
*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE lonindata(
	[no] [nvarchar](100)  NOT NULL,				--指纹ID
	[datetime] [nvarchar](50) NOT NULL		--日期
 CONSTRAINT [PK_lonindata] PRIMARY KEY CLUSTERED 
(
	[no] ASC,
	[datetime] 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
SET ANSI_PADDING OFF