[Help Thread] Please post your questions here.

USE [Arcadia62]
GO

/****** Object: Table [dbo].[SkillResource] Script Date: 04.09.2018 11:45:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SkillResource](
[id] [int] NOT NULL,
[text_id] [int] NOT NULL,
[desc_id] [int] NOT NULL,
[tooltip_id] [int] NOT NULL,
[is_valid] [tinyint] NOT NULL,
[elemental] [char](1) NOT NULL,
[is_passive] [char](1) NOT NULL,
[is_physical_act] [char](1) NOT NULL,
[is_harmful] [char](1) NOT NULL,
[is_need_target] [char](1) NOT NULL,
[is_corpse] [char](1) NOT NULL,
[is_toggle] [char](1) NOT NULL,
[toggle_group] [int] NOT NULL,
[casting_type] [char](1) NOT NULL,
[casting_level] [char](1) NOT NULL,
[cast_range] [int] NOT NULL,
[valid_range] [int] NOT NULL,
[cost_hp] [int] NOT NULL,
[cost_hp_per_skl] [int] NOT NULL,
[cost_mp] [int] NOT NULL,
[cost_mp_per_skl] [int] NOT NULL,
[cost_mp_per_enhance] [int] NOT NULL,
[cost_hp_per] [decimal](10, 2) NOT NULL,
[cost_hp_per_skl_per] [decimal](10, 2) NOT NULL,
[cost_mp_per] [decimal](10, 2) NOT NULL,
[cost_mp_per_skl_per] [decimal](10, 2) NOT NULL,
[cost_havoc] [int] NOT NULL,
[cost_havoc_per_skl] [int] NOT NULL,
[cost_energy] [decimal](10, 2) NOT NULL,
[cost_energy_per_skl] [decimal](10, 2) NOT NULL,
[cost_exp] [int] NOT NULL,
[cost_exp_per_enhance] [int] NOT NULL,
[cost_jp] [int] NOT NULL,
[cost_jp_per_enhance] [int] NOT NULL,
[cost_item] [int] NOT NULL,
[cost_item_count] [int] NOT NULL,
[cost_item_count_per_skl] [int] NOT NULL,
[need_level] [int] NOT NULL,
[need_hp] [int] NOT NULL,
[need_mp] [int] NOT NULL,
[need_havoc] [int] NOT NULL,
[need_havoc_burst] [int] NOT NULL,
[need_state_id] [int] NOT NULL,
[need_state_level] [tinyint] NOT NULL,
[need_state_exhaust] [tinyint] NOT NULL,
[vf_one_hand_sword] [char](1) NOT NULL,
[vf_two_hand_sword] [char](1) NOT NULL,
[vf_double_sword] [char](1) NOT NULL,
[vf_dagger] [char](1) NOT NULL,
[vf_double_dagger] [char](1) NOT NULL,
[vf_spear] [char](1) NOT NULL,
[vf_axe] [char](1) NOT NULL,
[vf_one_hand_axe] [char](1) NOT NULL,
[vf_double_axe] [char](1) NOT NULL,
[vf_one_hand_mace] [char](1) NOT NULL,
[vf_two_hand_mace] [char](1) NOT NULL,
[vf_lightbow] [char](1) NOT NULL,
[vf_heavybow] [char](1) NOT NULL,
[vf_crossbow] [char](1) NOT NULL,
[vf_one_hand_staff] [char](1) NOT NULL,
[vf_two_hand_staff] [char](1) NOT NULL,
[vf_shield_only] [char](1) NOT NULL,
[vf_is_not_need_weapon] [char](1) NOT NULL,
[delay_cast] [decimal](10, 2) NOT NULL,
[delay_cast_per_skl] [decimal](10, 2) NOT NULL,
[delay_cast_mode_per_enhance] [decimal](10, 2) NOT NULL,
[delay_common] [decimal](10, 2) NOT NULL,
[delay_cooltime] [decimal](10, 2) NOT NULL,
[delay_cooltime_mode_per_enhance] [decimal](10, 2) NOT NULL,
[cool_time_group_id] [int] NOT NULL,
[uf_self] [char](1) NOT NULL,
[uf_party] [char](1) NOT NULL,
[uf_guild] [char](1) NOT NULL,
[uf_neutral] [char](1) NOT NULL,
[uf_purple] [char](1) NOT NULL,
[uf_enemy] [char](1) NOT NULL,
[tf_avatar] [char](1) NOT NULL,
[tf_summon] [char](1) NOT NULL,
[tf_monster] [char](1) NOT NULL,
[target] [smallint] NOT NULL,
[effect_type] [smallint] NOT NULL,
[state_id] [int] NOT NULL,
[state_level_base] [int] NOT NULL,
[state_level_per_skl] [decimal](10, 2) NOT NULL,
[state_level_per_enhance] [decimal](10, 2) NOT NULL,
[state_second] [decimal](10, 2) NOT NULL,
[state_second_per_level] [decimal](10, 2) NOT NULL,
[state_second_per_enhance] [decimal](10, 2) NOT NULL,
[state_type] [char](1) NOT NULL,
[probability_on_hit] [int] NOT NULL,
[probability_inc_by_slv] [int] NOT NULL,
[hit_bonus] [smallint] NOT NULL,
[hit_bonus_per_enhance] [smallint] NOT NULL,
[percentage] [smallint] NOT NULL,
[hate_mod] [decimal](10, 2) NOT NULL,
[hate_basic] [smallint] NOT NULL,
[hate_per_skl] [decimal](10, 2) NOT NULL,
[hate_per_enhance] [decimal](10, 2) NOT NULL,
[critical_bonus] [int] NOT NULL,
[critical_bonus_per_skl] [int] NOT NULL,
[var1] [decimal](12, 4) NOT NULL,
[var2] [decimal](12, 4) NOT NULL,
[var3] [decimal](12, 4) NOT NULL,
[var4] [decimal](12, 4) NOT NULL,
[var5] [decimal](12, 4) NOT NULL,
[var6] [decimal](12, 4) NOT NULL,
[var7] [decimal](12, 4) NOT NULL,
[var8] [decimal](12, 4) NOT NULL,
[var9] [decimal](12, 4) NOT NULL,
[var10] [decimal](12, 4) NOT NULL,
[var11] [decimal](12, 4) NOT NULL,
[var12] [decimal](12, 4) NOT NULL,
[var13] [decimal](12, 4) NOT NULL,
[var14] [decimal](12, 4) NOT NULL,
[var15] [decimal](12, 4) NOT NULL,
[var16] [decimal](12, 4) NOT NULL,
[var17] [decimal](12, 4) NOT NULL,
[var18] [decimal](12, 4) NOT NULL,
[var19] [decimal](12, 4) NOT NULL,
[var20] [decimal](12, 4) NOT NULL,
[icon_id] [int] NOT NULL,
[icon_file_name] [varchar](256) NULL,
[is_projectile] [tinyint] NOT NULL,
[projectile_speed] [decimal](10, 2) NOT NULL,
[projectile_acceleration] [decimal](10, 2) NOT NULL,
CONSTRAINT [UQ__SkillResource__6225902D] UNIQUE NONCLUSTERED
(
[id] 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