mmo-ref/landsandboat
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
landsandboat/sql/blue_traits.sql
WinterSolstice8 6a5f599a07
Add more missing Blu traits (#9290) 
* [sql] Add missing BLU Undead Killer traits

* [sql] Add missing BLU MAB traits

* [sql] Add missing BLU Magic Burst Bonus trait

* [sql] Add missing BLU MDB traits

* [sql] Add missing JP bonus Rapid Shot trait for BLU

* [sql] Add missing JP bonus BLU Resist Gravity traits

* [sql] Add missing BLU Resist Sleep traits

* [sql] Add missing BLU Skillchain Bonus traits
2026-01-29 17:40:30 +01:00

149 lines
11 KiB
SQL
Raw Permalink Blame History

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for blue_traits
-- ----------------------------
DROP TABLE IF EXISTS `blue_traits`;
CREATE TABLE `blue_traits` (
`trait_category` smallint(2) unsigned NOT NULL,
`trait_points_needed` smallint(2) unsigned NOT NULL,
`traitid` tinyint(3) unsigned NOT NULL,
`modifier` smallint(5) unsigned NOT NULL,
`value` smallint(5) NOT NULL,
`tier` tinyint(3) unsigned NOT NULL,
`job_points_only` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`trait_category`,`trait_points_needed`,`modifier`,`tier`)
) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `blue_traits` VALUES (1,2,32,230,8,1,0); -- Beast Killer (1)
INSERT INTO `blue_traits` VALUES (1,4,32,230,10,2,0); -- Beast Killer (2)
INSERT INTO `blue_traits` VALUES (1,6,32,230,12,3,0); -- Beast Killer (3)
INSERT INTO `blue_traits` VALUES (2,2,9,370,1,1,0); -- Auto Regen (1)
INSERT INTO `blue_traits` VALUES (2,4,9,370,2,2,1); -- Auto Regen (2) (JP only)
INSERT INTO `blue_traits` VALUES (2,6,9,370,3,3,1); -- Auto Regen (3) (JP only)
INSERT INTO `blue_traits` VALUES (3,2,35,227,8,1,0); -- Lizard Killer (1)
INSERT INTO `blue_traits` VALUES (3,4,35,227,10,2,0); -- Lizard Killer (2)
INSERT INTO `blue_traits` VALUES (3,6,35,227,12,3,1); -- Lizard Killer (3) (JP only)
INSERT INTO `blue_traits` VALUES (4,2,24,295,3,1,0); -- Clear Mind (1)
INSERT INTO `blue_traits` VALUES (4,4,24,295,6,2,0); -- Clear Mind (2)
INSERT INTO `blue_traits` VALUES (4,6,24,295,9,3,0); -- Clear Mind (3)
INSERT INTO `blue_traits` VALUES (4,6,24,71,1,3,0); -- Clear Mind (3)
INSERT INTO `blue_traits` VALUES (4,8,24,295,12,4,0); -- Clear Mind (4)
INSERT INTO `blue_traits` VALUES (4,8,24,71,1,4,0); -- Clear Mind (4)
INSERT INTO `blue_traits` VALUES (4,10,24,295,12,5,1); -- Clear Mind (5) (JP only)
INSERT INTO `blue_traits` VALUES (4,10,24,71,2,5,1); -- Clear Mind (5) (JP only)
INSERT INTO `blue_traits` VALUES (4,12,24,295,12,6,1); -- Clear Mind (6) (JP only)
INSERT INTO `blue_traits` VALUES (4,12,24,71,3,6,1); -- Clear Mind (6) (JP only)
INSERT INTO `blue_traits` VALUES (5,2,48,240,10,1,0); -- Resist Sleep (1)
INSERT INTO `blue_traits` VALUES (5,4,48,240,15,2,0); -- Resist Sleep (2)
INSERT INTO `blue_traits` VALUES (5,6,48,240,20,3,1); -- Resist Sleep (3) (JP only)
INSERT INTO `blue_traits` VALUES (5,8,48,240,25,4,1); -- Resist Sleep (4) (JP only)
INSERT INTO `blue_traits` VALUES (6,2,5,28,20,1,0); -- Magic Attack Bonus (1)
INSERT INTO `blue_traits` VALUES (6,4,5,28,24,2,0); -- Magic Attack Bonus (2)
INSERT INTO `blue_traits` VALUES (6,6,5,28,28,3,0); -- Magic Attack Bonus (3)
INSERT INTO `blue_traits` VALUES (6,8,5,28,32,4,0); -- Magic Attack Bonus (4)
INSERT INTO `blue_traits` VALUES (6,10,5,28,36,5,1); -- Magic Attack Bonus (5) (JP only)
INSERT INTO `blue_traits` VALUES (6,12,5,28,50,6,1); -- Magic Attack Bonus (6) (JP only)
INSERT INTO `blue_traits` VALUES (7,2,39,231,8,1,0); -- Undead Killer (1)
INSERT INTO `blue_traits` VALUES (7,4,39,231,10,2,1); -- Undead Killer (2) (JP only)
INSERT INTO `blue_traits` VALUES (7,6,39,231,12,3,1); -- Undead Killer (3) (JP only)
INSERT INTO `blue_traits` VALUES (8,2,3,23,10,1,0); -- Attack Bonus (1)
INSERT INTO `blue_traits` VALUES (8,2,3,24,10,1,0); -- Attack Bonus (1)
INSERT INTO `blue_traits` VALUES (8,4,3,23,22,2,0); -- Attack Bonus (2)
INSERT INTO `blue_traits` VALUES (8,4,3,24,22,2,0); -- Attack Bonus (2)
INSERT INTO `blue_traits` VALUES (8,6,3,23,35,3,0); -- Attack Bonus (3)
INSERT INTO `blue_traits` VALUES (8,6,3,24,35,3,0); -- Attack Bonus (3)
INSERT INTO `blue_traits` VALUES (8,8,3,23,48,4,0); -- Attack Bonus (4)
INSERT INTO `blue_traits` VALUES (8,8,3,24,48,4,0); -- Attack Bonus (4)
INSERT INTO `blue_traits` VALUES (8,10,3,23,60,5,1); -- Attack Bonus (5) (JP only)
INSERT INTO `blue_traits` VALUES (8,10,3,24,60,5,1); -- Attack Bonus (5) (JP only)
INSERT INTO `blue_traits` VALUES (8,12,3,23,72,6,1); -- Attack Bonus (6) (JP only)
INSERT INTO `blue_traits` VALUES (8,12,3,24,72,6,1); -- Attack Bonus (6) (JP only)
INSERT INTO `blue_traits` VALUES (9,2,11,359,25,1,0); -- Rapid Shot (1)
INSERT INTO `blue_traits` VALUES (9,4,11,359,30,2,1); -- Rapid Shot (2) (JP only)
INSERT INTO `blue_traits` VALUES (9,6,11,359,35,3,1); -- Rapid Shot (3) (JP only) -- Value is guessed
INSERT INTO `blue_traits` VALUES (10,2,8,5,10,1,0); -- Max MP Boost (1)
INSERT INTO `blue_traits` VALUES (10,4,8,5,20,2,0); -- Max MP Boost (2)
INSERT INTO `blue_traits` VALUES (11,2,4,1,10,1,0); -- Defense Bonus (1)
INSERT INTO `blue_traits` VALUES (11,4,4,1,22,2,0); -- Defense Bonus (2)
INSERT INTO `blue_traits` VALUES (11,6,4,1,35,3,0); -- Defense Bonus (3)
INSERT INTO `blue_traits` VALUES (11,8,4,1,48,4,0); -- Defense Bonus (4)
INSERT INTO `blue_traits` VALUES (11,10,4,1,60,5,1); -- Defense Bonus (5)
INSERT INTO `blue_traits` VALUES (11,12,4,1,72,6,1); -- Defense Bonus (6)
INSERT INTO `blue_traits` VALUES (12,2,33,229,8,1,0); -- Plantoid Killer (1)
INSERT INTO `blue_traits` VALUES (12,4,33,229,10,2,0); -- Plantoid Killer (2)
INSERT INTO `blue_traits` VALUES (12,6,33,229,12,3,1); -- Plantoid Killer (3) (JP only)
INSERT INTO `blue_traits` VALUES (13,2,6,29,10,1,0); -- Magic Defense Bonus (1)
INSERT INTO `blue_traits` VALUES (13,4,6,29,12,2,0); -- Magic Defense Bonus (2)
INSERT INTO `blue_traits` VALUES (13,6,6,29,14,3,0); -- Magic Defense Bonus (3)
INSERT INTO `blue_traits` VALUES (13,8,6,29,16,4,1); -- Magic Defense Bonus (4) (JP only)
INSERT INTO `blue_traits` VALUES (13,10,6,29,18,5,1); -- Magic Defense Bonus (5) (JP only)
INSERT INTO `blue_traits` VALUES (14,2,10,369,1,1,0); -- Auto Refresh (1) -- Only tier available to BLU
INSERT INTO `blue_traits` VALUES (15,2,7,1095,30,1,0); -- Max HP Boost (1)
INSERT INTO `blue_traits` VALUES (15,4,7,1095,60,2,0); -- Max HP Boost (2)
INSERT INTO `blue_traits` VALUES (15,6,7,1095,120,3,0); -- Max HP Boost (3)
INSERT INTO `blue_traits` VALUES (15,8,7,1095,180,4,0); -- Max HP Boost (4)
INSERT INTO `blue_traits` VALUES (15,10,7,1095,240,5,1); -- Max HP Boost (5) (JP only)
INSERT INTO `blue_traits` VALUES (15,12,7,1095,280,6,1); -- Max HP Boost (6) (JP only)
INSERT INTO `blue_traits` VALUES (16,2,1,25,10,1,0); -- Accuracy Bonus (1)
INSERT INTO `blue_traits` VALUES (16,2,1,26,10,1,0); -- Accuracy Bonus (1)
INSERT INTO `blue_traits` VALUES (16,4,1,25,22,2,0); -- Accuracy Bonus (2)
INSERT INTO `blue_traits` VALUES (16,4,1,26,22,2,0); -- Accuracy Bonus (2)
INSERT INTO `blue_traits` VALUES (16,6,1,25,35,3,0); -- Accuracy Bonus (3)
INSERT INTO `blue_traits` VALUES (16,6,1,26,35,3,0); -- Accuracy Bonus (3)
INSERT INTO `blue_traits` VALUES (16,8,1,25,48,4,0); -- Accuracy Bonus (4)
INSERT INTO `blue_traits` VALUES (16,8,1,26,48,4,0); -- Accuracy Bonus (4)
INSERT INTO `blue_traits` VALUES (16,10,1,25,60,5,1); -- Accuracy Bonus (5) (JP only)
INSERT INTO `blue_traits` VALUES (16,10,1,26,60,5,1); -- Accuracy Bonus (5) (JP only)
INSERT INTO `blue_traits` VALUES (16,12,1,25,73,6,1); -- Accuracy Bonus (6) (JP only)
INSERT INTO `blue_traits` VALUES (16,12,1,26,73,6,1); -- Accuracy Bonus (6) (JP only)
INSERT INTO `blue_traits` VALUES (17,2,13,296,25,1,0); -- Conserve MP (1)
INSERT INTO `blue_traits` VALUES (17,4,13,296,28,2,0); -- Conserve MP (2)
INSERT INTO `blue_traits` VALUES (17,6,13,296,31,3,0); -- Conserve MP (3)
INSERT INTO `blue_traits` VALUES (17,8,13,296,34,4,1); -- Conserve MP (4) (JP only)
INSERT INTO `blue_traits` VALUES (17,10,13,296,37,5,1); -- Conserve MP (5) (JP only)
INSERT INTO `blue_traits` VALUES (18,2,2,68,10,1,0); -- Evasion Bonus (1)
INSERT INTO `blue_traits` VALUES (18,4,2,68,22,2,0); -- Evasion Bonus (2)
INSERT INTO `blue_traits` VALUES (18,6,2,68,35,3,0); -- Evasion Bonus (3)
INSERT INTO `blue_traits` VALUES (18,8,2,68,48,4,1); -- Evasion Bonus (4)
INSERT INTO `blue_traits` VALUES (18,10,2,68,60,5,1); -- Evasion Bonus (5)
INSERT INTO `blue_traits` VALUES (19,2,58,249,10,1,0); -- Resist Gravity (1)
INSERT INTO `blue_traits` VALUES (19,3,58,249,15,2,1); -- Resist Gravity (2) (JP only)
INSERT INTO `blue_traits` VALUES (19,4,58,249,20,3,1); -- Resist Gravity (3) (JP only)
INSERT INTO `blue_traits` VALUES (20,2,14,73,10,1,0); -- Store TP (1)
INSERT INTO `blue_traits` VALUES (20,4,14,73,15,2,0); -- Store TP (2)
INSERT INTO `blue_traits` VALUES (20,6,14,73,20,3,0); -- Store TP (3)
INSERT INTO `blue_traits` VALUES (20,8,14,73,25,4,1); -- Store TP (4) (JP onry)
INSERT INTO `blue_traits` VALUES (20,10,14,73,30,5,1); -- Store TP (5) (JP onry)
INSERT INTO `blue_traits` VALUES (21,2,17,291,10,1,0); -- Counter (1)
INSERT INTO `blue_traits` VALUES (21,4,17,291,12,2,0); -- Counter (2)
INSERT INTO `blue_traits` VALUES (21,6,17,291,14,3,1); -- Counter (3) (JP only)
INSERT INTO `blue_traits` VALUES (21,8,17,291,16,4,1); -- Counter (4) (JP only)
INSERT INTO `blue_traits` VALUES (22,2,12,170,5,0,0); -- Fast Cast (0) (Zero, weaker than /RDM.)
INSERT INTO `blue_traits` VALUES (22,4,12,170,10,1,0); -- Fast Cast (1)
INSERT INTO `blue_traits` VALUES (22,6,12,170,15,2,0); -- Fast Cast (2)
INSERT INTO `blue_traits` VALUES (22,8,12,170,20,3,1); -- Fast Cast (3) (JP only)
INSERT INTO `blue_traits` VALUES (22,10,12,170,25,4,1); -- Fast Cast (4) (JP only)
INSERT INTO `blue_traits` VALUES (23,2,106,174,8,1,0); -- Skillchain Bonus (1)
INSERT INTO `blue_traits` VALUES (23,3,106,174,12,2,0); -- Skillchain Bonus (2)
INSERT INTO `blue_traits` VALUES (23,4,106,174,16,3,0); -- Skillchain Bonus (3)
INSERT INTO `blue_traits` VALUES (23,5,106,174,20,4,1); -- Skillchain Bonus (4) (JP only)
INSERT INTO `blue_traits` VALUES (23,6,106,174,23,5,1); -- Skillchain Bonus (5) (JP only)
INSERT INTO `blue_traits` VALUES (24,2,15,288,7,0,0); -- Double Attack (0) -- Tier Zero because this is weaker than WAR double attack (1). It is BLU exclusive
INSERT INTO `blue_traits` VALUES (24,4,16,302,5,1,0); -- Triple Attack (1)
INSERT INTO `blue_traits` VALUES (25,2,18,259,10,1,0); -- Dual Wield (1)
INSERT INTO `blue_traits` VALUES (25,4,18,259,15,2,0); -- Dual Wield (2)
INSERT INTO `blue_traits` VALUES (25,6,18,259,25,3,0); -- Dual Wield (3)
INSERT INTO `blue_traits` VALUES (25,8,18,259,30,4,0); -- Dual Wield (4)
INSERT INTO `blue_traits` VALUES (25,10,18,259,35,5,1); -- Dual Wield (5) (JP only)
INSERT INTO `blue_traits` VALUES (25,12,18,259,40,6,1); -- Dual Wield (6) (JP only)
INSERT INTO `blue_traits` VALUES (26,2,70,306,15,1,0); -- Zanshin (1)
INSERT INTO `blue_traits` VALUES (27,2,110,487,5,1,0); -- Magic Burst Bonus (1)
INSERT INTO `blue_traits` VALUES (27,3,110,487,7,2,0); -- Magic Burst Bonus (2)
INSERT INTO `blue_traits` VALUES (27,4,110,487,9,3,0); -- Magic Burst Bonus (3)
INSERT INTO `blue_traits` VALUES (27,5,110,487,11,4,1); -- Magic Burst Bonus (4)
INSERT INTO `blue_traits` VALUES (27,6,110,487,13,5,1); -- Magic Burst Bonus (5)
INSERT INTO `blue_traits` VALUES (28,2,20,897,1,1,0); -- Gilfinder (1)
INSERT INTO `blue_traits` VALUES (28,3,19,303,1,2,0); -- Treasure Hunter (1)
Reference in a new issue View git blame Copy permalink