CREATE TABLE [dbo].[TblRestraintChar] (
	[tinyServerID] [tinyint] NOT NULL ,
	[UID] [int] NOT NULL ,
	[strClientID] [varchar] (20) NOT NULL ,
	[strCharName] [varchar] (20) NOT NULL ,
	[tinyType] [tinyint] NOT NULL ,
	[tinyKind] [tinyint] NOT NULL ,
	[tinyBlocked] [tinyint] NOT NULL ,
	[dateStartTime] [smalldatetime] NOT NULL ,
	[dateEndTime] [smalldatetime] NOT NULL ,
	[intEndTime] [int] NOT NULL ,
	[strAdminID] [varchar] (20) NULL ,
	[strDescription] [varchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TblGMLogMsg] (
	[LogID] [int] IDENTITY (1, 1) NOT NULL ,
	[UID] [int] NULL ,
	[CID] [int] NULL ,
	[ServerGroupID] [tinyint] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[LogMsg] [varchar] (200)  NULL ,
	[AdminID] [varchar] (20)  NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TblGMLogMsg_Log] (
	[LogID] [int] NOT NULL ,
	[UID] [int] NULL ,
	[CID] [int] NULL ,
	[ServerGroupID] [tinyint] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[LogMsg] [varchar] (200)  NULL ,
	[AdminID] [varchar] (20)  NOT NULL ,
	[InsertTime] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO