Need explanation in SQL Skill Table

[imblad3]

Hi there, well maybe I'm too dumb or blind and did not see any document in wiki or doc (server folder).

 

It seems I can't find the docs that explain skill table (I'm currently using latest rathena (git) and sql database)

 

so Here is the question:

 

--
-- Table structure for table `skill`
--

CREATE TABLE IF NOT EXISTS `skill` (
  `char_id` int(11) unsigned NOT NULL default '0',
  `id` smallint(11) unsigned NOT NULL default '0',
  `lv` tinyint(4) unsigned NOT NULL default '0',
  `flag` TINYINT(1) UNSIGNED NOT NULL default 0,
  PRIMARY KEY  (`char_id`,`id`)
) ENGINE=MyISAM;

 

I need to know the function of "flag", because my royal guard has skill heal say lv 5 and when I look at the table the flag say 4

and I can't reset it. So if possible can you guys tell me the number means? like 4 = no reset?

 

Hope you all can help me thanks in advance

 

[Emistry]

doc/script_commands.txt#L5100

Flag is 0 if the skill is given permanently (will get written with the character
data) or 1 if it is temporary (will be lost eventually, this is meant for card
item scripts usage.). The flag parameter is optional, and defaults to 1 in
'skill' and to 2 in 'addtoskill'.

Flag 2 means that the level parameter is to be interpreted as a stackable
additional bonus to the skill level. If the character did not have that skill
previously, they will now at 0+the level given.

Flag 4 is the same as flag 1 in that it saves to the database. However, these skills
are ignored when any action is taken that adjusts the skill tree (reset/job change).