195 lines
5.8 KiB
SQL
195 lines
5.8 KiB
SQL
DROP TABLE IF EXISTS starting_skills;
|
|
CREATE TABLE starting_skills (
|
|
id INTEGER PRIMARY KEY,
|
|
class_id INTEGER NOT NULL DEFAULT 255,
|
|
race_id INTEGER NOT NULL DEFAULT 255,
|
|
skill_id INTEGER NOT NULL DEFAULT 0,
|
|
current_val INTEGER NOT NULL DEFAULT 1,
|
|
max_val INTEGER NOT NULL DEFAULT 1,
|
|
progress INTEGER NOT NULL DEFAULT 0,
|
|
UNIQUE(race_id, class_id, skill_id),
|
|
FOREIGN KEY (skill_id) REFERENCES skills(id) ON UPDATE CASCADE
|
|
);
|
|
CREATE INDEX idx_starting_skills_skill_id ON starting_skills(skill_id);
|
|
|
|
INSERT INTO starting_skills VALUES
|
|
(1,255,255,4250045746,5,5,0),
|
|
(2,255,255,4037812502,1,1,0),
|
|
(3,255,255,3539032716,1,1,0),
|
|
(5,255,255,609880714,5,5,0),
|
|
(6,255,255,2319450178,5,5,0),
|
|
(7,5,255,3177806075,5,5,0),
|
|
(8,255,255,2638198038,5,5,0),
|
|
(9,255,255,688591146,5,5,0),
|
|
(10,255,255,1048513601,5,5,0),
|
|
(11,255,255,1553857724,1,1,0),
|
|
(12,255,255,2072844078,1,1,0),
|
|
(13,255,255,3659699625,5,5,0),
|
|
(14,255,255,3429135390,1,1,0),
|
|
(15,255,255,4253456353,1,1,0),
|
|
(16,255,255,2383540775,1,1,0),
|
|
(17,255,255,2037831821,5,5,0),
|
|
(18,255,255,1970131346,5,5,0),
|
|
(19,255,255,4158365743,5,5,0),
|
|
(20,1,255,723762198,5,5,0),
|
|
(21,1,255,2246237129,1,1,0),
|
|
(22,1,255,3421494576,5,5,0),
|
|
(23,1,255,1408356869,1,1,0),
|
|
(24,1,255,1653482350,1,1,0),
|
|
(25,1,255,554333641,1,1,0),
|
|
(26,1,255,2897193374,1,1,0),
|
|
(27,1,255,770311065,1,1,0),
|
|
(28,1,255,540022425,5,5,0),
|
|
(29,1,255,3180399725,1,1,0),
|
|
(30,11,255,3421494576,5,5,0),
|
|
(31,11,255,613995491,5,5,0),
|
|
(32,11,255,1653482350,1,1,0),
|
|
(33,11,255,554333641,1,1,0),
|
|
(34,11,255,2897193374,1,1,0),
|
|
(35,11,255,770311065,1,1,0),
|
|
(36,11,255,366253016,5,5,0),
|
|
(37,11,255,3587918036,5,5,0),
|
|
(38,11,255,2463145248,1,1,0),
|
|
(39,11,255,3180399725,1,1,0),
|
|
(40,11,255,882983852,5,5,0),
|
|
(41,21,255,3421494576,5,5,0),
|
|
(42,21,255,887279616,1,1,0),
|
|
(43,21,255,613995491,5,5,0),
|
|
(44,21,255,554333641,1,1,0),
|
|
(45,21,255,770311065,1,1,0),
|
|
(46,21,255,3820670534,1,1,0),
|
|
(47,21,255,366253016,5,5,0),
|
|
(48,21,255,3587918036,5,5,0),
|
|
(49,21,255,3048574950,5,5,0),
|
|
(50,21,255,3180399725,1,1,0),
|
|
(51,21,255,882983852,5,5,0),
|
|
(52,21,255,545043066,1,1,0),
|
|
(53,31,255,2476073427,1,1,0),
|
|
(54,31,255,1743366740,1,1,0),
|
|
(55,31,255,2246237129,1,1,0),
|
|
(56,31,255,887279616,1,1,0),
|
|
(57,31,255,2200201799,5,5,0),
|
|
(58,31,255,1852383242,1,1,0),
|
|
(59,31,255,2897193374,1,1,0),
|
|
(60,31,255,540022425,5,5,0),
|
|
(61,31,255,3048574950,5,5,0),
|
|
(62,31,255,3694382619,5,5,0),
|
|
(63,31,255,641561514,1,1,0),
|
|
(64,31,255,3173504370,1,1,0),
|
|
(65,31,255,3232294366,5,5,0),
|
|
(66,31,255,1921433074,1,1,0),
|
|
(67,31,255,418532101,5,5,0),
|
|
(68,31,255,1616998748,1,1,0),
|
|
(69,31,255,1696217328,1,1,0),
|
|
(70,31,255,2650425026,1,1,0),
|
|
(71,31,255,1468243427,5,5,0),
|
|
(72,2,255,2476073427,1,1,0),
|
|
(73,2,255,1743366740,1,1,0),
|
|
(74,2,255,2954459351,1,1,0),
|
|
(75,2,255,2380184628,1,1,0),
|
|
(76,2,255,2292577688,1,1,0),
|
|
(77,2,255,2608320658,1,1,0),
|
|
(78,2,255,3048574950,5,5,0),
|
|
(79,2,255,241174330,1,1,0),
|
|
(80,2,255,1756482397,5,5,0),
|
|
(81,2,255,641561514,1,1,0),
|
|
(82,2,255,3173504370,1,1,0),
|
|
(83,2,255,418532101,5,5,0),
|
|
(84,2,255,1616998748,1,1,0),
|
|
(85,2,255,1696217328,1,1,0),
|
|
(86,2,255,2650425026,1,1,0),
|
|
(87,2,255,570458645,1,1,0),
|
|
(88,2,255,1124719197,1,1,0),
|
|
(89,2,255,887279616,1,1,0),
|
|
(90,2,255,1852383242,1,1,0),
|
|
(91,3,255,1209716810,1,1,0),
|
|
(92,4,255,1433335062,1,1,0),
|
|
(93,5,255,3856706740,1,1,0),
|
|
(94,5,255,3850377186,5,5,0),
|
|
(95,5,255,3232294366,5,5,0),
|
|
(96,5,255,2650425026,1,1,0),
|
|
(97,6,255,2011726342,1,1,0),
|
|
(98,7,255,3067436248,1,1,0),
|
|
(99,8,255,2476073427,1,1,0),
|
|
(100,8,255,1743366740,1,1,0),
|
|
(101,8,255,3809066846,1,1,0),
|
|
(102,8,255,887279616,1,1,0),
|
|
(103,8,255,613995491,5,5,0),
|
|
(104,8,255,2954459351,1,1,0),
|
|
(105,8,255,2380184628,1,1,0),
|
|
(106,8,255,2292577688,1,1,0),
|
|
(107,8,255,2608320658,1,1,0),
|
|
(108,8,255,366253016,5,5,0),
|
|
(109,8,255,3587918036,5,5,0),
|
|
(110,8,255,241174330,1,1,0),
|
|
(111,8,255,3173504370,1,1,0),
|
|
(112,8,255,418532101,5,5,0),
|
|
(113,8,255,1616998748,1,1,0),
|
|
(114,8,255,1696217328,1,1,0),
|
|
(115,8,255,570458645,1,1,0),
|
|
(116,9,255,2741805322,1,1,0),
|
|
(117,10,255,90523872,1,1,0),
|
|
(118,12,255,2246237129,1,1,0),
|
|
(119,12,255,3341842907,1,1,0),
|
|
(120,12,255,241174330,1,1,0),
|
|
(121,13,255,2581053277,1,1,0),
|
|
(122,14,255,1829443087,1,1,0),
|
|
(123,15,255,3282420779,1,1,0),
|
|
(124,15,255,641561514,1,1,0),
|
|
(125,15,255,1616998748,1,1,0),
|
|
(126,16,255,1040683335,1,1,0),
|
|
(127,17,255,1624274802,1,1,0),
|
|
(128,18,255,2246237129,1,1,0),
|
|
(129,18,255,2380184628,1,1,0),
|
|
(130,18,255,3343700951,1,1,0),
|
|
(131,18,255,1616998748,1,1,0),
|
|
(132,19,255,3467160477,1,1,0),
|
|
(133,20,255,3191839982,1,1,0),
|
|
(134,22,255,2533124061,1,1,0),
|
|
(135,23,255,2662430630,1,1,0),
|
|
(136,24,255,193411854,1,1,0),
|
|
(137,25,255,287643040,1,1,0),
|
|
(138,26,255,2898101972,1,1,0),
|
|
(139,27,255,2950599749,1,1,0),
|
|
(140,28,255,2120065377,1,1,0),
|
|
(141,28,255,2398950520,1,1,0),
|
|
(142,29,255,2042842194,1,1,0),
|
|
(143,30,255,2894715199,1,1,0),
|
|
(144,32,255,1514256692,1,1,0),
|
|
(145,33,255,2663054519,1,1,0),
|
|
(146,34,255,1519965519,1,1,0),
|
|
(147,35,255,1311635100,1,1,0),
|
|
(148,35,255,613995491,5,5,0),
|
|
(149,35,255,366253016,5,5,0),
|
|
(150,35,255,3587918036,5,5,0),
|
|
(151,35,255,1756482397,5,5,0),
|
|
(152,36,255,296246391,1,1,0),
|
|
(153,37,255,340921594,1,1,0),
|
|
(154,38,255,3167106577,1,1,0),
|
|
(155,38,255,1756482397,5,5,0),
|
|
(156,39,255,1400160844,1,1,0),
|
|
(157,40,255,2711101135,1,1,0),
|
|
(158,8,255,1756482397,5,5,0),
|
|
(159,255,255,3421494576,1,5,0),
|
|
(160,255,255,1653482350,1,5,0),
|
|
(165,11,255,545043066,1,1,0),
|
|
(166,42,255,3177806075,5,5,0),
|
|
(168,31,255,1756482397,5,5,0),
|
|
(169,32,255,1756482397,5,5,0),
|
|
(170,33,255,1756482397,5,5,0),
|
|
(171,34,255,1756482397,5,5,0),
|
|
(172,37,255,1756482397,5,5,0),
|
|
(173,36,255,1756482397,5,5,0),
|
|
(177,39,255,1756482397,5,5,0),
|
|
(178,40,255,1756482397,5,5,0),
|
|
(180,32,255,1743366740,5,5,0),
|
|
(181,33,255,1743366740,5,5,0),
|
|
(182,34,255,1743366740,5,5,0),
|
|
(183,35,255,1743366740,5,5,0),
|
|
(184,36,255,1743366740,5,5,0),
|
|
(185,37,255,1743366740,5,5,0),
|
|
(186,38,255,1743366740,5,5,0),
|
|
(187,39,255,1743366740,5,5,0),
|
|
(188,40,255,1743366740,5,5,0),
|
|
(189,255,0,1,100,100,0);
|