USE FFF_GAME
CREATE TABLE [dbo].[TB_AUTONOTELIST] (
[character_idx] [int] NOT NULL ,
[auto_name] [varchar] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[reg_date] [smalldatetime] NOT NULL ,
[auto_character_idx] [int] NOT NULL ,
[auto_user_idx] [int] NOT NULL
)
GO
CREATE TABLE [dbo].[TB_BUFF] (
[CHARACTER_IDX] [int] NOT NULL ,
[SKILL_IDX] [int] NOT NULL ,
[REMAIN_TIME] [bigint] NOT NULL ,
[REMAIN_COUNT] [int] NOT NULL ,
[END_DATE] [datetime] NULL
)
GO
CREATE TABLE [dbo].[TB_CHALLENGEZONE_ENTER] (
[PlayerID] [int] NOT NULL ,
[EnterFreq] [int] NOT NULL ,
[BonusFreq] [int] NOT NULL ,
[LastEnterDate] [smalldatetime] NOT NULL
)
GO
CREATE TABLE [dbo].[TB_CHALLENGEZONE_SAVEPOS] (
[PlayerID] [int] NOT NULL ,
[BeforeMapNum] [int] NOT NULL ,
[PosX] [int] NOT NULL ,
[PosY] [int] NOT NULL
)
GO
CREATE TABLE [dbo].[TB_CHALLENGEZONE_SUCCESS] (
[PlayerID] [int] NOT NULL ,
[PartnerID] [int] NOT NULL ,
[Section] [int] NOT NULL ,
[SuccessFreq] [int] NOT NULL ,
[ClearTime] [int] NULL
)
GO
CREATE TABLE [dbo].[TB_CHARACTER] (
[CHARACTER_IDX] [int] IDENTITY (**** 1) NOT NULL ,
[USER_IDX] [int] NOT NULL ,
[CHARACTER_NAME] [varchar] (20) COLLATE Thai_CI_AS NOT NULL ,
[CHARACTER_STANDINDEX] [int] NOT NULL ,
[CHARACTER_PARTYIDX] [int] NOT NULL ,
[CHARACTER_STAGE] [tinyint] NOT NULL ,
[CHARACTER_GENDER] [tinyint] NOT NULL ,
[CHARACTER_STR] [int] NULL ,
[CHARACTER_DEX] [int] NOT NULL ,
[CHARACTER_VIT] [int] NOT NULL ,
[CHARACTER_INT] [int] NOT NULL ,
[CHARACTER_WIS] [int] NOT NULL ,
[CHARACTER_LIFE] [int] NOT NULL ,
[CHARACTER_MAXLIFE] [int] NOT NULL ,
[CHARACTER_MANA] [int] NOT NULL ,
[CHARACTER_FAME] [int] NOT NULL ,
[CHARACTER_KARMA] [tinyint] NOT NULL ,
[CHARACTER_REPUTE] [varchar] (16) COLLATE Thai_CI_AS NOT NULL ,
[CHARACTER_GRADE] [tinyint] NOT NULL ,
[CHARACTER_MAXGRADE] [tinyint] NOT NULL ,
[CHARACTER_EXPOINT] [bigint] NULL ,
[CHARACTER_GRADEUPPOINT] [smallint] NOT NULL ,
[CHARACTER_MONEY] [bigint] NOT NULL ,
[CHARACTER_WING] [int] NOT NULL ,
[CHARACTER_VITALITY] [tinyint] NOT NULL ,
[CHARACTER_MAP] [tinyint] NOT NULL ,
[CHARACTER_FACETYPE] [tinyint] NOT NULL ,
[CHARACTER_HEADTYPE] [tinyint] NOT NULL ,
[CHARACTER_WEAPON] [int] NOT NULL ,
[CHARACTER_SHIELD] [int] NOT NULL ,
[CHARACTER_HAT] [int] NOT NULL ,
[CHARACTER_SHOES] [int] NOT NULL ,
[CHARACTER_DRESS] [int] NOT NULL ,
[CHARACTER_GLOVE] [int] NOT NULL ,
[CHARACTER_COSTUME_HAT] [int] NOT NULL ,
[CHARACTER_COSTUME_DRESS] [int] NOT NULL ,
[CHARACTER_COSTUME_SHOES] [int] NOT NULL ,
[CHARACTER_COSTUME_GLOVE] [int] NOT NULL ,
[CHARACTER_MASK] [int] NOT NULL ,
[CHARACTER_GLASSES] [int] NOT NULL ,
[CHARACTER_BAND] [int] NOT NULL ,
[CHARACTER_MUNPAIDX] [int] NOT NULL ,
[CHARACTER_MUNPAJIKCHEK] [tinyint] NOT NULL ,
[CHARACTER_MUNPAENTRYDATE] [smalldatetime] NOT NULL ,
[CHARACTER_MUNPACANENTRYDATE] [smalldatetime] NOT NULL ,
[CHARACTER_MUNPANAME] [varchar] (50) COLLATE Thai_CI_AS NULL ,
[CHARACTER_MUNPAMARKIDX] [int] NOT NULL ,
[CHARACTER_ABILITY1] [tinyint] NOT NULL ,
[CHARACTER_ABILITY2] [tinyint] NOT NULL ,
[CHARACTER_ABILITY3] [tinyint] NOT NULL ,
[CHARACTER_ABILITY4] [tinyint] NOT NULL ,
[CHARACTER_ABILITY5] [tinyint] NOT NULL ,
[CHARACTER_ABILITY6] [tinyint] NOT NULL ,
[CHARACTER_ABILITY7] [tinyint] NOT NULL ,
[CHARACTER_BIRTH] [smalldatetime] NOT NULL ,
[CHARACTER_LASTMODIFIED] [smalldatetime] NOT NULL ,
[CHARACTER_STATE] [tinyint] NOT NULL ,
[Character_MapChangePoint] [int] NOT NULL ,
[Character_LoginPoint] [int] NOT NULL ,
[CHARACTER_ABILITYEXP] [int] NOT NULL ,
[CHARACTER_CURRENTMAP] [tinyint] NOT NULL ,
[CHARACTER_BADFAME] [int] NOT NULL ,
[CHARACTER_POS_X] [int] NOT NULL ,
[CHARACTER_POS_Y] [int] NOT NULL ,
[CHARACTER_PLAYTIME] [int] NOT NULL ,
[CHARACTER_LASTPKENDTIME] [int] NOT NULL ,
[CHARACTER_NICKNAME] [varchar] (20) COLLATE Thai_CI_AS NULL ,
[CHARACTER_ATTR] [int] NOT NULL ,
[CHARACTER_JOB] [tinyint] NOT NULL ,
[CHARACTER_JOB1] [tinyint] NOT NULL ,
[CHARACTER_JOB2] [tinyint] NOT NULL ,
[CHARACTER_JOB3] [tinyint] NOT NULL ,
[CHARACTER_JOB4] [tinyint] NOT NULL ,
[CHARACTER_JOB5] [tinyint] NOT NULL ,
[CHARACTER_JOB6] [tinyint] NOT NULL ,
[CHARACTER_FAMILYIDX] [int] NOT NULL ,
[CHARACTER_FAMILYNAME] [varchar] (30) COLLATE Thai_CI_AS NOT NULL ,
[CHARACTER_FAMILYJIKCHEK] [tinyint] NOT NULL ,
[CHARACTER_FAMILYENTRYDATE] [smalldatetime] NULL ,
[CHARACTER_FAMILYCANENTRYDATE] [smalldatetime] NULL ,
[CHARACTER_FAMILYMARKIDX] [int] NULL ,
[CHARACTER_FAMILYNICKNAME] [varchar] (50) COLLATE Thai_CI_AS NULL ,
[CHARACTER_SKILLPOINT] [int] NOT NULL ,
[CHARACTER_ACCSKILLPOINT] [int] NOT NULL
)
GO