328 lines
8.0 KiB
SQL
328 lines
8.0 KiB
SQL
DROP TABLE IF EXISTS item_details_thrown;
|
|
CREATE TABLE item_details_thrown (
|
|
id INTEGER PRIMARY KEY,
|
|
item_id INTEGER NOT NULL DEFAULT 0 UNIQUE,
|
|
range_bonus INTEGER NOT NULL DEFAULT 0,
|
|
damage_bonus INTEGER NOT NULL DEFAULT 0,
|
|
hit_bonus REAL NOT NULL DEFAULT 0,
|
|
damage_type INTEGER NOT NULL DEFAULT 0,
|
|
FOREIGN KEY (item_id) REFERENCES items(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
INSERT INTO item_details_thrown VALUES
|
|
(1,20544,5,125,1.2,0),
|
|
(2,10020544,5,125,1.2,0),
|
|
(3,20407,0,52,1.1,2),
|
|
(4,10020407,0,52,1.1,2),
|
|
(5,20402,5,107,1.1,1),
|
|
(6,10020402,5,107,1.1,1),
|
|
(7,20543,5,156,1.1,1),
|
|
(8,10020543,5,156,1.1,1),
|
|
(9,20408,0,128,1.1,2),
|
|
(10,10020408,0,128,1.1,2),
|
|
(11,20536,0,3,1.1,2),
|
|
(12,10020536,0,3,1.1,2),
|
|
(13,20479,0,53,1,0),
|
|
(14,10020479,0,53,1,0),
|
|
(15,20488,5,19,1.2,2),
|
|
(16,10020488,5,19,1.2,2),
|
|
(17,20498,-5,38,0.95,2),
|
|
(18,10020498,-5,38,0.95,2),
|
|
(19,20436,5,138,1.15,2),
|
|
(20,10020436,5,138,1.15,2),
|
|
(21,20464,5,24,1.2,2),
|
|
(22,10020464,5,24,1.2,2),
|
|
(23,20432,5,53,1.2,2),
|
|
(24,10020432,5,53,1.2,2),
|
|
(25,20465,5,57,1.2,2),
|
|
(26,10020465,5,57,1.2,2),
|
|
(27,20540,-5,5,0.9,1),
|
|
(28,10020540,-5,5,0.9,1),
|
|
(29,20463,5,71,1.1,1),
|
|
(30,10020463,5,71,1.1,1),
|
|
(31,20409,-5,214,0.9,1),
|
|
(32,10020409,-5,214,0.9,1),
|
|
(33,20410,-5,100,0.9,1),
|
|
(34,10020410,-5,100,0.9,1),
|
|
(35,20484,-5,83,0.9,1),
|
|
(36,10020484,-5,83,0.9,1),
|
|
(37,20469,0,35,1.1,2),
|
|
(38,10020469,0,35,1.1,2),
|
|
(39,20420,0,65,1,2),
|
|
(40,10020420,0,65,1,2),
|
|
(41,20541,0,265,1,2),
|
|
(42,10020541,0,265,1,2),
|
|
(43,20440,0,220,1,2),
|
|
(44,10020440,0,220,1,2),
|
|
(45,20419,5,120,1.15,2),
|
|
(46,10020419,5,120,1.15,2),
|
|
(47,20545,0,234,1,0),
|
|
(48,10020545,0,234,1,0),
|
|
(49,20422,5,38,1.1,1),
|
|
(50,10020422,5,38,1.1,1),
|
|
(51,20485,0,41,1.1,2),
|
|
(52,10020485,0,41,1.1,2),
|
|
(53,20424,5,13,1.2,2),
|
|
(54,10020424,5,13,1.2,2),
|
|
(55,20496,-5,27,0.95,2),
|
|
(56,10020496,-5,27,0.95,2),
|
|
(57,20518,-5,27,0.95,1),
|
|
(58,10020518,-5,27,0.95,1),
|
|
(59,20412,-5,2,0.95,2),
|
|
(60,10020412,-5,2,0.95,2),
|
|
(61,20415,0,80,1.15,1),
|
|
(62,10020415,0,80,1.15,1),
|
|
(63,20428,0,19,1.1,2),
|
|
(64,10020428,0,19,1.1,2),
|
|
(65,20556,0,128,1.15,2),
|
|
(66,10020556,0,128,1.15,2),
|
|
(67,20521,0,374,1.05,2),
|
|
(68,10020521,0,374,1.05,2),
|
|
(69,20450,5,53,1.1,1),
|
|
(70,10020450,5,53,1.1,1),
|
|
(71,20433,0,94,1,0),
|
|
(72,10020433,0,94,1,0),
|
|
(73,20513,5,177,1.1,1),
|
|
(74,10020513,5,177,1.1,1),
|
|
(75,20404,5,36,1.2,2),
|
|
(76,10020404,5,36,1.2,2),
|
|
(77,20542,-5,3,0.9,0),
|
|
(78,10020542,-5,3,0.9,0),
|
|
(79,20455,0,1,1.1,2),
|
|
(80,10020455,0,1,1.1,2),
|
|
(81,20437,5,4,1.1,0),
|
|
(82,10020437,5,4,1.1,0),
|
|
(83,20453,0,2,1,0),
|
|
(84,10020453,0,2,1,0),
|
|
(85,20425,0,2,1,0),
|
|
(86,10020425,0,2,1,0),
|
|
(87,20533,0,4,1,0),
|
|
(88,10020533,0,4,1,0),
|
|
(89,20448,0,2,1,2),
|
|
(90,10020448,0,2,1,2),
|
|
(91,20509,-5,2,1,2),
|
|
(92,10020509,-5,2,1,2),
|
|
(93,20454,0,1,1,0),
|
|
(94,10020454,0,1,1,0),
|
|
(95,20514,5,1,1.2,0),
|
|
(96,10020514,5,1,1.2,0),
|
|
(97,20445,0,1,1.1,2),
|
|
(98,10020445,0,1,1.1,2),
|
|
(99,20427,0,1,1.1,2),
|
|
(100,10020427,0,1,1.1,2),
|
|
(101,20495,-5,1,0.95,2),
|
|
(102,10020495,-5,1,0.95,2),
|
|
(103,20401,-5,3,0.9,0),
|
|
(104,10020401,-5,3,0.9,0),
|
|
(105,20457,-5,2,0.9,1),
|
|
(106,10020457,-5,2,0.9,1),
|
|
(107,20515,0,2,1,0),
|
|
(108,10020515,0,2,1,0),
|
|
(109,20522,-5,4,0.95,0),
|
|
(110,10020522,-5,4,0.95,0),
|
|
(111,20443,5,1,1.2,0),
|
|
(112,10020443,5,1,1.2,0),
|
|
(113,20446,-5,2,0.9,1),
|
|
(114,10020446,-5,2,0.9,1),
|
|
(115,20460,-5,53,0.95,2),
|
|
(116,10020460,-5,53,0.95,2),
|
|
(117,20444,0,2,1,0),
|
|
(118,10020444,0,2,1,0),
|
|
(119,20503,-5,1,1,2),
|
|
(120,10020503,-5,1,1,2),
|
|
(121,20429,-5,2,0.9,1),
|
|
(122,10020429,-5,2,0.9,1),
|
|
(123,20400,0,2,1,2),
|
|
(124,10020400,0,2,1,2),
|
|
(125,20507,-5,1,1,2),
|
|
(126,10020507,-5,1,1,2),
|
|
(127,20466,0,1,1,0),
|
|
(128,10020466,0,1,1,0),
|
|
(129,20470,-5,2,0.9,1),
|
|
(130,10020470,-5,2,0.9,1),
|
|
(131,20439,0,1,1,2),
|
|
(132,10020439,0,1,1,2),
|
|
(133,20416,0,2,1.02,2),
|
|
(134,10020416,0,2,1.02,2),
|
|
(135,20489,0,2,1,0),
|
|
(136,10020489,0,2,1,0),
|
|
(137,20506,-5,1,1,2),
|
|
(138,10020506,-5,1,1,2),
|
|
(139,20435,-5,1,0.9,1),
|
|
(140,10020435,-5,1,0.9,1),
|
|
(141,20549,0,1,1.25,2),
|
|
(142,10020549,0,1,1.25,2),
|
|
(143,20512,-5,3,0.9,0),
|
|
(144,10020512,-5,3,0.9,0),
|
|
(145,20430,-5,1,0.9,1),
|
|
(146,10020430,-5,1,0.9,1),
|
|
(147,20449,-5,3,0.9,0),
|
|
(148,10020449,-5,3,0.9,0),
|
|
(149,20405,0,1,1,0),
|
|
(150,10020405,0,1,1,0),
|
|
(151,20508,-5,1,1,2),
|
|
(152,10020508,-5,1,1,2),
|
|
(153,20417,-5,4,0.92,0),
|
|
(154,10020417,-5,4,0.92,0),
|
|
(155,20468,0,1,1.1,2),
|
|
(156,10020468,0,1,1.1,2),
|
|
(157,20441,-5,3,0.9,0),
|
|
(158,10020441,-5,3,0.9,0),
|
|
(159,20476,5,1,1.1,1),
|
|
(160,10020476,5,1,1.1,1),
|
|
(161,20413,0,1,1,2),
|
|
(162,10020413,0,1,1,2),
|
|
(163,20550,-5,1,1,2),
|
|
(164,10020550,-5,1,1,2),
|
|
(165,20487,5,0,1.2,2),
|
|
(166,10020487,5,0,1.2,2),
|
|
(167,20434,0,1,1.1,2),
|
|
(168,10020434,0,1,1.1,2),
|
|
(169,20547,-5,2,0.9,1),
|
|
(170,10020547,-5,2,0.9,1),
|
|
(171,20458,-5,1,0.9,1),
|
|
(172,10020458,-5,1,0.9,1),
|
|
(173,20442,5,1,1.1,1),
|
|
(174,10020442,5,1,1.1,1),
|
|
(175,20423,5,1,1.2,2),
|
|
(176,10020423,5,1,1.2,2),
|
|
(177,20438,0,0,1,2),
|
|
(178,10020438,0,0,1,2),
|
|
(179,20471,-5,1,0.9,1),
|
|
(180,10020471,-5,1,0.9,1),
|
|
(181,20481,0,1,1.1,2),
|
|
(182,10020481,0,1,1.1,2),
|
|
(183,20418,5,1,1.12,1),
|
|
(184,10020418,5,1,1.12,1),
|
|
(185,20500,-5,50,0.95,2),
|
|
(186,10020500,-5,50,0.95,2),
|
|
(187,20551,5,0,1.2,2),
|
|
(188,10020551,5,0,1.2,2),
|
|
(189,20467,0,2,1,0),
|
|
(190,10020467,0,2,1,0),
|
|
(191,20456,0,1,1.1,2),
|
|
(192,10020456,0,1,1.1,2),
|
|
(193,20447,-5,38,0.95,2),
|
|
(194,10020447,-5,38,0.95,2),
|
|
(195,20459,0,1,1,2),
|
|
(196,10020459,0,1,1,2),
|
|
(197,20472,3,2,1.15,0),
|
|
(198,10020472,3,2,1.15,0),
|
|
(199,20505,-5,1,1,2),
|
|
(200,10020505,-5,1,1,2),
|
|
(201,20473,-5,71,0.95,2),
|
|
(202,10020473,-5,71,0.95,2),
|
|
(203,20431,0,1,1,2),
|
|
(204,10020431,0,1,1,2),
|
|
(205,20406,0,2,1,0),
|
|
(206,10020406,0,2,1,0),
|
|
(207,20554,-5,1,0.9,1),
|
|
(208,10020554,-5,1,0.9,1),
|
|
(209,20526,3,2,1.15,2),
|
|
(210,10020526,3,2,1.15,2),
|
|
(211,20421,-5,3,0.9,0),
|
|
(212,10020421,-5,3,0.9,0),
|
|
(213,20535,0,2,1,2),
|
|
(214,10020535,0,2,1,2),
|
|
(215,20546,0,1,1.1,2),
|
|
(216,10020546,0,1,1.1,2),
|
|
(217,20462,-5,3,0.9,0),
|
|
(218,10020462,-5,3,0.9,0),
|
|
(219,20426,0,1,1,0),
|
|
(220,10020426,0,1,1,0),
|
|
(221,20461,0,2,1,2),
|
|
(222,10020461,0,2,1,2),
|
|
(223,20527,0,4,1,2),
|
|
(224,10020527,0,4,1,2),
|
|
(225,20528,0,2,1,2),
|
|
(226,10020528,0,2,1,2),
|
|
(227,20519,-5,38,0.95,1),
|
|
(228,10020519,-5,38,0.95,1),
|
|
(229,20475,-5,3,0.9,0),
|
|
(230,10020475,-5,3,0.9,0),
|
|
(231,20477,5,0,1.2,2),
|
|
(232,10020477,5,0,1.2,2),
|
|
(233,20523,5,265,1.15,1),
|
|
(234,10020523,5,265,1.15,1),
|
|
(235,20534,0,1,1,0),
|
|
(236,10020534,0,1,1,0),
|
|
(237,20524,0,44,1,2),
|
|
(238,10020524,0,44,1,2),
|
|
(239,20525,0,84,1.1,2),
|
|
(240,10020525,0,84,1.1,2),
|
|
(241,20497,-5,92,0.95,2),
|
|
(242,10020497,-5,92,0.95,2),
|
|
(243,20491,0,29,1.1,2),
|
|
(244,10020491,0,29,1.1,2),
|
|
(245,20486,-5,62,0.9,0),
|
|
(246,10020486,-5,62,0.9,0),
|
|
(247,20504,-5,97,1,2),
|
|
(248,10020504,-5,97,1,2),
|
|
(249,20502,-5,80,1,2),
|
|
(250,10020502,-5,80,1,2),
|
|
(251,20538,0,2,1,1),
|
|
(252,10020538,0,2,1,1),
|
|
(253,20510,-5,117,1,2),
|
|
(254,10020510,-5,117,1,2),
|
|
(255,20414,0,128,1.15,2),
|
|
(256,10020414,0,128,1.15,2),
|
|
(257,20553,0,63,1.1,2),
|
|
(258,10020553,0,63,1.1,2),
|
|
(259,20530,5,2,1.2,2),
|
|
(260,10020530,5,2,1.2,2),
|
|
(261,20493,-5,23,0.9,1),
|
|
(262,10020493,-5,23,0.9,1),
|
|
(263,20490,0,14,1,0),
|
|
(264,10020490,0,14,1,0),
|
|
(265,20451,5,42,1.2,2),
|
|
(266,10020451,5,42,1.2,2),
|
|
(267,20403,5,85,1.2,0),
|
|
(268,10020403,5,85,1.2,0),
|
|
(269,20511,0,289,1,2),
|
|
(270,10020511,0,289,1,2),
|
|
(271,20474,0,151,1,2),
|
|
(272,10020474,0,151,1,2),
|
|
(273,20552,0,78,1,0),
|
|
(274,10020552,0,78,1,0),
|
|
(275,20492,0,12,1.1,2),
|
|
(276,10020492,0,12,1.1,2),
|
|
(277,20494,-5,48,0.9,1),
|
|
(278,10020494,-5,48,0.9,1),
|
|
(279,20501,0,118,1.2,2),
|
|
(280,10020501,0,118,1.2,2),
|
|
(281,20531,0,2,1,2),
|
|
(282,10020531,0,2,1,2),
|
|
(283,20529,-5,6,0.9,0),
|
|
(284,10020529,-5,6,0.9,0),
|
|
(285,20482,0,107,1.1,2),
|
|
(286,10020482,0,107,1.1,2),
|
|
(287,20539,-5,2,0.9,1),
|
|
(288,10020539,-5,2,0.9,1),
|
|
(289,20516,0,209,1.1,2),
|
|
(290,10020516,0,209,1.1,2),
|
|
(291,20499,-5,63,0.95,2),
|
|
(292,10020499,-5,63,0.95,2),
|
|
(293,20517,-5,338,0.9,1),
|
|
(294,10020517,-5,338,0.9,1),
|
|
(295,20537,0,1,1.1,2),
|
|
(296,10020537,0,1,1.1,2),
|
|
(297,20483,-5,178,0.9,1),
|
|
(298,10020483,-5,178,0.9,1),
|
|
(299,20480,0,133,1,0),
|
|
(300,10020480,0,133,1,0),
|
|
(301,20411,-5,67,0.95,2),
|
|
(302,10020411,-5,67,0.95,2),
|
|
(303,20555,0,128,1.15,2),
|
|
(304,10020555,0,128,1.15,2),
|
|
(305,20520,0,78,1,2),
|
|
(306,10020520,0,78,1,2),
|
|
(307,20548,-1,259,1,2),
|
|
(308,10020548,-1,259,1,2),
|
|
(309,20478,5,71,1.2,2),
|
|
(310,10020478,5,71,1.2,2),
|
|
(311,20532,5,1,1.2,2),
|
|
(312,10020532,5,1,1.2,2),
|
|
(313,20452,5,18,1.2,2),
|
|
(314,10020452,5,18,1.2,2),
|
|
(315,1020400,0,0,0,0);
|