[LDate] [smalldatetime] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Character] WITH NOCHECK ADD
CONSTRAINT [DF_Character_cLevel] DEFAULT (1) FOR [cLevel],
CONSTRAINT [DF_Character_LevelUpPoint] DEFAULT (0) FOR [LevelUpPoint],
CONSTRAINT [DF_Character_Experience] DEFAULT (0) FOR [Experience],
CONSTRAINT [DF_Character_Money] DEFAULT (0) FOR [MONEY= ,
CONSTRAINT [DF__Character__MapDi__0AD2A005] DEFAULT (0) FOR [MapDir],
CONSTRAINT [DF__Character__PkCou__0BC6C43E] DEFAULT (0) FOR [PkCount],
CONSTRAINT [DF__Character__PkLev__0CBAE877] DEFAULT (3) FOR [PkLevel],
CONSTRAINT [DF__Character__PkTim__0DAF0CB0] DEFAULT (0) FOR [PkTime],
CONSTRAINT [PK__Character__09DE7BCC] PRIMARY KEY CLUSTERED
(
[Name]
) ON [PRIMARY]
GO

CREATE VIEW vCharacterPreview
AS SELECT Name, cLevel, Class, Inventory FROM Character


CREATE TABLE [dbo].[GameServerInfo] (
[Number] [int] NOT NULL ,
[ItemCount] [int] NULL ,
[ZenCount] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[GameServerInfo] WITH NOCHECK ADD
CONSTRAINT [DF_GameServerInfo_Number] DEFAULT (0) FOR [Number],
CONSTRAINT [DF__GameServe__ItemC__0F975522] DEFAULT (0) FOR [ItemCount],
CONSTRAINT [DF_GameServerInfo_ZenCount] DEFAULT (0) FOR [ZenCount],
CONSTRAINT [PK_GameServerInfo] PRIMARY KEY NONCLUSTERED
(
[Number]
) ON [PRIMARY]
GO

insert GameServerInfo valueS(0,0,0)

CREATE TABLE [Guild] (
[G_Name] [varchar] (8) NOT NULL ,
[G_Mark] [varbinary] (32) NULL ,

[G_Score] [int] NULL ,
[G_Master] [varchar] (10) NULL ,
[G_Count] [int] NULL ,
[G_Notice] [varchar] (60) NULL ,


               上一篇文章：Login Server 设置                                                    下一篇文章: GameServer 中文配置方法