createtable.sql

此软件是一个 日志服务器

use SysLog_info

if exists (select * from dbo.sysobjects where id = object_id(N'[SysLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [SysLog]
GO

CREATE TABLE [SysLog] (
	[AccTime] [datetime] NULL CONSTRAINT [DF_SysLog_DataTime] DEFAULT (getdate()),
	[HostIp] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HostName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgText] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO