if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BotPet]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BotPet]
GO
CREATE TABLE [dbo].[BotPet] (
[AccountID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cLevel] [int] NOT NULL ,
[Class] [tinyint] NULL ,
[Experience] [bigint] NULL ,
[Power] [smallint] NULL ,
[Defense] [smallint] NULL ,
[Inventory] [varbinary] (1728) NULL ,
[MagicList] [varbinary] (180) NULL ,
[Life] [real] NOT NULL ,
[MaxLife] [real] NOT NULL ,
[Mana] [real] NOT NULL ,
[MaxMana] [real] NOT NULL ,
[MapNumber] [smallint] NULL ,
[MapPosX] [smallint] NULL ,
[MapPosY] [smallint] NULL ,
[CDate] [smalldatetime] NULL ,
[BotLife] [int] NOT NULL ,
[BotMaxLife] [int] NOT NULL ,
[BotLvlUpDefense] [int] NOT NULL ,
[BotLvlUpPower] [int] NOT NULL ,
[BotLvlUpLife] [int] NOT NULL ,
[BotLvlUpMana] [int] NOT NULL ,
[BotLvlUpExp] [int] NOT NULL ,
[BotLvlUpMaxLevel] [int] NOT NULL
) ON [PRIMARY]
GO