ratkosrb
130 lines
2.0 KiB
SQL
130 lines
2.0 KiB
SQL
DROP PROCEDURE IF EXISTS add_migration;
|
|
DELIMITER ??
|
|
CREATE PROCEDURE `add_migration`()
|
|
BEGIN
|
|
DECLARE v INT DEFAULT 1;
|
|
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20260104051009');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20260104051009');
|
|
-- Add your query below.
|
|
|
|
|
|
DROP TABLE IF EXISTS `spell_cone`;
|
|
CREATE TABLE IF NOT EXISTS `spell_cone` (
|
|
`entry` smallint(5) unsigned NOT NULL,
|
|
`cone_degrees` smallint(6) NOT NULL COMMENT '0 to 360',
|
|
PRIMARY KEY (`entry`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
INSERT INTO `spell_cone` (`entry`, `cone_degrees`) VALUES
|
|
(5708, 90),
|
|
(8374, 90),
|
|
(9457, 90),
|
|
(11019, 90),
|
|
(12882, 90),
|
|
(12887, 90),
|
|
(15529, 359),
|
|
(15847, -120),
|
|
(16094, 90),
|
|
(16099, 90),
|
|
(16169, 90),
|
|
(16340, 90),
|
|
(16350, 90),
|
|
(16359, 90),
|
|
(16390, 90),
|
|
(16396, 120),
|
|
(18144, 90),
|
|
(18435, 120),
|
|
(18500, 120),
|
|
(19630, 120),
|
|
(19641, 120),
|
|
(19813, 180),
|
|
(20667, 90),
|
|
(20712, 120),
|
|
(20716, 90),
|
|
(20717, 90),
|
|
(21071, 120),
|
|
(21099, 120),
|
|
(21189, 90),
|
|
(21333, 180),
|
|
(22479, 90),
|
|
(22539, 120),
|
|
(22558, 90),
|
|
(22559, 90),
|
|
(22560, 90),
|
|
(22561, 90),
|
|
(22600, 120),
|
|
(22642, 90),
|
|
(22682, 120),
|
|
(22833, 120),
|
|
(22945, 120),
|
|
(22993, 120),
|
|
(23187, 120),
|
|
(23189, 120),
|
|
(23308, 120),
|
|
(23309, 120),
|
|
(23310, 120),
|
|
(23311, 120),
|
|
(23312, 120),
|
|
(23313, 120),
|
|
(23314, 120),
|
|
(23315, 120),
|
|
(23316, 120),
|
|
(23339, 120),
|
|
(23364, -120),
|
|
(23461, 120),
|
|
(23618, 90),
|
|
(23919, 120),
|
|
(24192, 120),
|
|
(24682, 120),
|
|
(24818, 120),
|
|
(24821, 45),
|
|
(24822, 135),
|
|
(24823, 90),
|
|
(24835, 180),
|
|
(24836, 225),
|
|
(24837, 270),
|
|
(24838, 315),
|
|
(24839, 120),
|
|
(24933, 7),
|
|
(25024, 45),
|
|
(25026, 45),
|
|
(25027, 30),
|
|
(25030, 90),
|
|
(25031, 45),
|
|
(25032, 10),
|
|
(25060, 90),
|
|
(25145, 90),
|
|
(25149, 90),
|
|
(25150, 90),
|
|
(25322, 90),
|
|
(25653, -120),
|
|
(25993, 120),
|
|
(26025, 180),
|
|
(26027, 180),
|
|
(26029, 5),
|
|
(27766, 90),
|
|
(27807, 90),
|
|
(28127, 90),
|
|
(28157, 45),
|
|
(28168, 120),
|
|
(28405, 180),
|
|
(28438, 180),
|
|
(28459, 90),
|
|
(28460, 90),
|
|
(28469, 360),
|
|
(28741, 120),
|
|
(28783, 30),
|
|
(29998, 180),
|
|
(30043, 90),
|
|
(30056, 180),
|
|
(30732, 180);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|