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

CREATE TABLE [dbo].[MonsterCharacter] (
 [Name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [MonsterID] [int] NOT NULL ,
 [Moday] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[SCMT_GC] (
 [ServerID] [int] NOT NULL ,
 [GCName] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [GCMZName] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [GCJF] [int] NOT NULL ,
 [Tye] [int] NOT NULL ,
 [GCtime] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[T_PVPGens] (
 [Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [Rank] [int] NOT NULL ,
 [Contribution] [int] NOT NULL ,
 [Type] [int] NOT NULL
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[T_QUEST_MONSTERKILL] (
 [CHAR_NAME] [varchar] (10) COLLATE Chinese_PRC_CS_AS_KS_WS NOT NULL ,
 [QUEST_INDEX] [smallint] NULL ,
 [MON_INDEX_1] [smallint] NULL ,
 [KILL_COUNT_1] [smallint] NULL ,
 [MON_INDEX_2] [smallint] NULL ,
 [KILL_COUNT_2] [smallint] NULL ,
 [MON_INDEX_3] [smallint] NULL ,
 [KILL_COUNT_3] [smallint] NULL ,
 [MON_INDEX_4] [smallint] NULL ,
 [KILL_COUNT_4] [smallint] NULL ,
 [MON_INDEX_5] [smallint] NULL ,
 [KILL_COUNT_5] [smallint] NULL
) ON [PRIMARY]
GO