if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_CHARACTER_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TBL_CHARACTER_INFO]
GO
CREATE TABLE [dbo].[TBL_CHARACTER_INFO] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ACCOUNT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[POSX] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_POSX] DEFAULT (300),
[POSY] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_POSY] DEFAULT (300),
[MAPNAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAPNAME] DEFAULT ('0'),
[CLASS] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_CLASS] DEFAULT (0),
[SEX] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_SEX] DEFAULT (0),
[VLEVEL] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_BLEVEL] DEFAULT (0),
[HAIR] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_HAIR] DEFAULT (0),
[SERVER] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_SERVER] DEFAULT (''),
[ODATE] [datetime] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_ODATE] DEFAULT (getdate()),
[DELFLAG] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_DELFLAG] DEFAULT (0),
[DELDATE] [datetime] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_DELDATE] DEFAULT (''),
[CREATEDATE] [datetime] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_CREATEDATE] DEFAULT (getdate()),
[CUREXP] [int] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_CUREXP] DEFAULT (0),
[HP] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_HP] DEFAULT (0),
[MP] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MP] DEFAULT (0),
[MAXHP] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXHP] DEFAULT (0),
[MAXMP] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXMP] DEFAULT (0),
[MINDC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MINDC] DEFAULT (0),
[MAXDC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXDC] DEFAULT (0),
[MINMC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MINMC] DEFAULT (0),
[MAXMC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXMC] DEFAULT (0),
[MINSC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MINSC] DEFAULT (0),
[MAXSC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXSC] DEFAULT (0),
[MINAC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MINAC] DEFAULT (0),
[MAXAC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXAC] DEFAULT (0),
[MINMAC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MINMAC] DEFAULT (0),
[MAXMAC] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAXMAC] DEFAULT (0),
[WEIGHT] [smallint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_WEIGHT] DEFAULT (0),
[HANDWEIGHT] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_HANDWEIGHT] DEFAULT (0),
[BODYWEIGHT] [tinyint] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_BODYWEIGHT] DEFAULT (0),
[GOLD] [int] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_GOLD] DEFAULT (0),
[MAPID] [int] NOT NULL CONSTRAINT [DF_TBL_CHARACTER_INFO_MAPID] DEFAULT (0)
) ON [PRIMARY]
GO