Code:
USE [MuOnline]
GO
drop table Character
go
/****** Object: Table [dbo].[Character] Script Date: 02/18/2016 21:27:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NOT NULL,
[cLevel] [int] NULL,
[LevelUpPoint] [int] NULL,
[Class] [tinyint] NULL,
[Experience] [int] NULL,
[Strength] [int] NULL,
[Dexterity] [int] NULL,
[Vitality] [int] NULL,
[Energy] [int] NULL,
[Leadership] [int] NULL,
[Inventory] [varbinary](3792) NULL,
[MagicList] [varbinary](180) NULL,
[Money] [int] NULL,
[Life] [real] NULL,
[MaxLife] [real] NULL,
[Mana] [real] NULL,
[MaxMana] [real] NULL,
[BP] [real] NULL,
[MaxBP] [real] NULL,
[Shield] [real] NULL,
[MaxShield] [real] NULL,
[MapNumber] [smallint] NULL,
[MapPosX] [smallint] NULL,
[MapPosY] [smallint] NULL,
[MapDir] [tinyint] NULL,
[PkCount] [int] NULL,
[PkLevel] [int] NULL,
[PkTime] [int] NULL,
[MDate] [smalldatetime] NULL,
[LDate] [smalldatetime] NULL,
[CtlCode] [tinyint] NULL,
[DbVersion] [tinyint] NULL,
[Quest] [varbinary](50) NULL,
[ChatLimitTime] [smallint] NULL,
[FruitPoint] [int] NULL,
[EffectList] [varbinary](416) NULL,
[FruitAddPoint] [int] NOT NULL,
[FruitSubPoint] [int] NOT NULL,
[ResetCount] [int] NOT NULL,
[MasterResetCount] [int] NOT NULL,
[ExtInventory] [int] NOT NULL,
[Resets] [int] NOT NULL,
[ResetNBB] [int] NOT NULL,
[ResetVIP] [int] NOT NULL,
[Resets_Time] [int] NOT NULL,
[NoResetInDay] [int] NOT NULL,
[DGT_Time] [int] NOT NULL,
[reset_total] [int] NOT NULL,
[Top50] [int] NOT NULL,
[NBB_Resets_0h] [int] NOT NULL,
[NBB_Relifes_0h] [int] NOT NULL,
[Relifes] [int] NOT NULL,
[khoado] [tinyint] NOT NULL,
[makhoado] [varchar](50) NULL,
[IsThuePoint] [tinyint] NOT NULL,
[TimeThuePoint] [int] NOT NULL,
[PointThue] [int] NOT NULL,
[ErrorSubBlock] [tinyint] NOT NULL,
[pointdutru] [int] NOT NULL,
[UyThac] [tinyint] NOT NULL,
[uythacoffline_stat] [int] NOT NULL,
[uythacoffline_time] [int] NOT NULL,
[UyThacOffline_Daily] [int] NOT NULL,
[PointUyThac] [int] NOT NULL,
[PointUyThac_Event] [bigint] NOT NULL,
[Onlinetime] [int] NOT NULL,
[event1_type1] [int] NOT NULL,
[event1_type2] [int] NOT NULL,
[event1_type3] [int] NOT NULL,
[nbbtuluyen_str] [int] NOT NULL,
[nbbtuluyen_str_point] [int] NOT NULL,
[nbbtuluyen_str_exp] [int] NOT NULL,
[nbbtuluyen_str_cp] [int] NOT NULL,
[nbbtuluyen_agi] [int] NOT NULL,
[nbbtuluyen_agi_point] [int] NOT NULL,
[nbbtuluyen_agi_exp] [int] NOT NULL,
[nbbtuluyen_agi_cp] [int] NOT NULL,
[nbbtuluyen_vit] [int] NOT NULL,
[nbbtuluyen_vit_point] [int] NOT NULL,
[nbbtuluyen_vit_exp] [int] NOT NULL,
[nbbtuluyen_vit_cp] [int] NOT NULL,
[nbbtuluyen_ene] [int] NOT NULL,
[nbbtuluyen_ene_point] [int] NOT NULL,
[nbbtuluyen_ene_exp] [int] NOT NULL,
[nbbtuluyen_ene_cp] [int] NOT NULL,
[nbbtuluyen_point] [int] NOT NULL,
[nbbsongtu_lv] [tinyint] NOT NULL,
[nbbsongtu_point] [int] NOT NULL,
[nbbsongtu_exp] [int] NOT NULL,
[nbbsongtu_cp] [int] NOT NULL,
[nbbhoanhao_point] [int] NOT NULL,
[nbbcuonghoa_point] [int] NOT NULL,
[point_event] [int] NOT NULL,
CONSTRAINT [PK_Character] PRIMARY KEY NONCLUSTERED
(
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_cLevel] DEFAULT ((1)) FOR [cLevel]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_LevelUpPoint] DEFAULT ((0)) FOR [LevelUpPoint]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_Experience] DEFAULT ((0)) FOR [Experience]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__Leade__7A672E12] DEFAULT ((0)) FOR [Leadership]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_Money] DEFAULT ((0)) FOR [Money]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_MapDir] DEFAULT ((0)) FOR [MapDir]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_PkCount] DEFAULT ((0)) FOR [PkCount]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_PkLevel] DEFAULT ((3)) FOR [PkLevel]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_PkTime] DEFAULT ((0)) FOR [PkTime]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_CtlCode] DEFAULT ((0)) FOR [CtlCode]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__DbVer__787EE5A0] DEFAULT ((0)) FOR [DbVersion]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__Quest__797309D9] DEFAULT ((0)) FOR [Quest]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__ChatL__7B5B524B] DEFAULT ((0)) FOR [ChatLimitTime]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_FruitPoint] DEFAULT ((0)) FOR [FruitPoint]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__Fruit__4F67C174] DEFAULT ((0)) FOR [FruitAddPoint]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__Fruit__505BE5AD] DEFAULT ((0)) FOR [FruitSubPoint]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__Reset__515009E6] DEFAULT ((0)) FOR [ResetCount]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__Maste__7CF981FA] DEFAULT ((0)) FOR [MasterResetCount]
GO
ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character__ExtIn__40E497F3] DEFAULT ((0)) FOR [ExtInventory]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [Resets]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [ResetNBB]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [ResetVIP]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [Resets_Time]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [NoResetInDay]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [DGT_Time]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [reset_total]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [Top50]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [NBB_Resets_0h]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [NBB_Relifes_0h]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [Relifes]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [khoado]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [IsThuePoint]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [TimeThuePoint]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [PointThue]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [ErrorSubBlock]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [pointdutru]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [UyThac]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [uythacoffline_stat]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [uythacoffline_time]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [UyThacOffline_Daily]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [PointUyThac]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [PointUyThac_Event]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [Onlinetime]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [event1_type1]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [event1_type2]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [event1_type3]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_str]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_str_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_str_exp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_str_cp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_agi]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_agi_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_agi_exp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_agi_cp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_vit]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_vit_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_vit_exp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_vit_cp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_ene]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_ene_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_ene_exp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_ene_cp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbtuluyen_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbsongtu_lv]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbsongtu_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbsongtu_exp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbsongtu_cp]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbhoanhao_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [nbbcuonghoa_point]
GO
ALTER TABLE [dbo].[Character] ADD DEFAULT ((0)) FOR [point_event]
GO
delete character
Delete AccountCharacter
Delete GuildMember
Delete Guild
Delete MEMB_STAT
Delete T_CGuid
Delete T_FriendList
Delete T_FriendMail
Delete T_FriendMain
Delete MasterSkillTree
Delete warehouse