· 8 years ago · Mar 13, 2018, 12:08 AM
1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `champions`;
9CREATE TABLE `champions` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `name` varchar(100) NOT NULL,
12 `role` enum('marksman','support') NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15
16INSERT INTO `champions` (`id`, `name`, `role`) VALUES
17(1, 'Ashe', 'marksman'),
18(2, 'Caitlyn', 'marksman'),
19(3, 'Corki', 'marksman'),
20(4, 'Draven', 'marksman'),
21(5, 'Ezreal', 'marksman'),
22(6, 'Graves', 'marksman'),
23(7, 'Jhin', 'marksman'),
24(8, 'Jinx', 'marksman'),
25(9, 'Kaisa', 'marksman'),
26(10, 'Kalista', 'marksman'),
27(11, 'Kennen', 'marksman'),
28(12, 'Kindred', 'marksman'),
29(13, 'KogMaw', 'marksman'),
30(14, 'Lucian', 'marksman'),
31(15, 'MissFortune', 'marksman'),
32(16, 'Quinn', 'marksman'),
33(17, 'Sivir', 'marksman'),
34(18, 'Teemo', 'marksman'),
35(19, 'Tristana', 'marksman'),
36(20, 'Twitch', 'marksman'),
37(21, 'Varus', 'marksman'),
38(22, 'Vayne', 'marksman'),
39(23, 'Alistar', 'support'),
40(24, 'Bard', 'support'),
41(25, 'Braum', 'support'),
42(26, 'Fiddlesticks', 'support'),
43(27, 'Janna', 'support'),
44(28, 'Karma', 'support'),
45(29, 'Leona', 'support'),
46(30, 'Lulu', 'support'),
47(31, 'Lux', 'support'),
48(32, 'Morgana', 'support'),
49(33, 'Name', 'support'),
50(34, 'Nunu', 'support'),
51(35, 'Rakan', 'support'),
52(36, 'Sona', 'support'),
53(37, 'Soraka', 'support'),
54(38, 'TahmKench', 'support'),
55(39, 'Taric', 'support'),
56(40, 'Thresh', 'support'),
57(41, 'Zilean', 'support'),
58(42, 'Zyra', 'support');
59
60-- 2018-03-13 00:05:35