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