94 lines
4.4 KiB
SQL
94 lines
4.4 KiB
SQL
DROP TABLE IF EXISTS `monstrosity_instinct_mods`;
|
|
CREATE TABLE `monstrosity_instinct_mods` (
|
|
`monstrosity_instinct_id` smallint(5) unsigned NOT NULL,
|
|
`modId` smallint(5) unsigned NOT NULL,
|
|
`value` smallint(5) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`monstrosity_instinct_id`,`modId`)
|
|
) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
|
|
-- Rabbit instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (3,3,2); -- HPP: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (3,11,5); -- AGI: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (3,23,10); -- ATT: 10
|
|
|
|
-- Rabbit instinct II
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (4,3,3); -- HPP: 3
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (4,9,5); -- DEX: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (4,68,10); -- EVA: 15
|
|
|
|
-- Rabbit instinct III
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (5,1,20); -- DEF: 20
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (5,9,5); -- DEX: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (5,11,5); -- AGI: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (5,288,2); -- DOUBLE_ATTACK: 2
|
|
|
|
-- Mandragora instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (54,9,5); -- DEX: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (54,25,10); -- ACC: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (54,384,100); -- HASTE_GEAR: 100
|
|
|
|
-- Mandragora instinct II
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (55,1,10); -- DEF: 10
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (55,13,5); -- MND: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (55,23,10); -- ATT: 10
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (55,288,1); -- DOUBLE_ATTACK: 1
|
|
|
|
-- Mandragora instinct III
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (56,3,3); -- HPP: 3
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (56,289,3); -- SUBTLE_BLOW: 3
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (56,384,300); -- HASTE_GEAR: 300
|
|
|
|
-- Bee instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (81,11,5); -- AGI: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (81,23,10); -- ATT: 10
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (81,68,5); -- EVA: 5
|
|
|
|
-- Bee instinct II
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (82,3,2); -- HPP: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (82,5,50); -- MP: 50
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (82,12,5); -- INT: 5
|
|
|
|
-- Bee instinct III
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (83,8,10); -- STR: 10
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (83,10,5); -- VIT: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (83,384,300); -- HASTE_GEAR: 300
|
|
|
|
-- Lizard instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (129,3,1); -- HPP: 1
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (129,10,5); -- VIT: 5
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (129,1,20); -- DEF: 20
|
|
|
|
-- Lizard instinct II
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (130,8,4); -- STR: 4
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (130,23,14); -- ATT: 14
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (130,73,3); -- STORETP: 3
|
|
|
|
-- Lizard instinct III
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (131,3,10); -- HPP: 10
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (131,62,1); -- ATTP: 1
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (131,1,30); -- DEF: 30
|
|
|
|
-- Hume's instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (768,8,2); -- STR: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (768,9,2); -- DEX: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (768,10,2); -- VIT: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (768,11,2); -- AGI: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (768,12,2); -- INT: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (768,13,2); -- MND: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (768,14,2); -- CHR: 2
|
|
|
|
-- Elvaan's instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (769,8,3); -- STR: 3
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (769,13,3); -- MND: 3
|
|
|
|
-- Tarutaru's instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (770,6,2); -- MPP: 3
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (770,12,3); -- INT: 3
|
|
|
|
-- Mithra's instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (771,9,3); -- DEX: 3
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (771,11,3); -- AGI: 3
|
|
|
|
-- Galka's instinct I
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (772,3,2); -- HPP: 2
|
|
INSERT INTO `monstrosity_instinct_mods` VALUES (772,10,3); -- VIT: 3
|