· 8 years ago · Feb 14, 2018, 10:44 AM
1/* -----------------------------------------------------
2 chtoplist.sql
3
4 This script completely sets up the chtoplist database including all tables,
5 attributes, indexes and inserts. ÃŒt can be used for an automatic deployment.
6
7 Author: Keiahnig and Punchy
8 Date: 06.02.2018
9
10 History:
11 Version Date Who Changes
12 1.12 10.03.2017 Keiahnig added inserts
13 1.11 09.03.2017 Keiahnig added inserts
14 1.10 08.03.2017 Keiahnig added inserts
15 1.0 06.02.2017 Keiahnig created
16
17 Copyright © 2017 Keiahnig and Punchy, Switzerland. All rights reserved.
18 ----------------------------------------------------*/
19
20-- -----------------------------------------------------
21-- Schema chtoplist
22-- -----------------------------------------------------
23CREATE DATABASE IF NOT EXISTS chtoplist DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;
24USE chtoplist;
25
26-- Debug
27-- drop database chtoplist;
28-- select * from TPlayers;
29
30-- -----------------------------------------------------
31-- Table TPlayers
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS TPlayers (
34 PId INT PRIMARY KEY,
35 PAlias VARCHAR(45) NOT NULL,
36 PRole enum('Top', 'Jungle', 'Mid', 'Adc', 'Support') NOT NULL,
37 PTeam enum('AG', 'eLS', 'RodG', 'SPG', 'mYI', 'XEN', 'noetic', 'AR', 'Varg', 'SCG', 'ELV',
38 'NOX', 'eRazed', 'THF', 'THFA', 'SPGA', 'XENA', 'LFT', '-') NOT NULL,
39 PTwitter VARCHAR(45) NOT NULL)
40ENGINE = InnoDB;
41
42-- -----------------------------------------------------
43-- Inserts TPlayers
44-- -----------------------------------------------------
45-- - = not looking for team
46INSERT INTO TPlayers VALUES (36716172, 'Keiahnig', 'Support', '-', 'kei_ahnig1');
47INSERT INTO TPlayers VALUES (21268676, 'Akashi F', 'Mid', '-', '-');
48INSERT INTO TPlayers VALUES (25897853, 'Steinway', 'Mid', '-', '-');
49INSERT INTO TPlayers VALUES (31219746, 'Vango', 'Mid', '-', 'lolVango');
50INSERT INTO TPlayers VALUES (44629853, 'MasterSoda', 'Jungle', '-', '-');
51INSERT INTO TPlayers VALUES (19005629, 'Elite Player', 'Adc', '-', '-');
52INSERT INTO TPlayers VALUES (21353959, 'Bâsoromyû Kuma', 'Support', '-', 'RociEduan');
53INSERT INTO TPlayers VALUES (28323219, 'Flyboy', 'Top', '-', 'noahflyboy');
54INSERT INTO TPlayers VALUES (18995929, 'Heal and Protect', 'Support', '-', '-');
55INSERT INTO TPlayers VALUES (40928922, 'NuEtaDa', 'Jungle', '-', '-');
56INSERT INTO TPlayers VALUES (31161417, 'Stroser', 'Mid', '-', '-');
57INSERT INTO TPlayers VALUES (29397001, 'Tziz', 'Mid', '-', 'Tzizzzz');
58INSERT INTO TPlayers VALUES (19952738, 'Uncle Bence', 'Jungle', '-', '-');
59INSERT INTO TPlayers VALUES (39525628, 'Luke', 'Mid', '-', 'Luuc_ii');
60INSERT INTO TPlayers VALUES (24566737, 'XXXNico', 'Adc', '-', '-');
61INSERT INTO TPlayers VALUES (63834505, 'Allmaron', 'Top', '-', '-');
62INSERT INTO TPlayers VALUES (53400057, 'Fill or Feed', 'Support', '-', 'rammuslover69');
63INSERT INTO TPlayers VALUES (21157986, 'Quadralift', 'Top', '-', '-');
64INSERT INTO TPlayers VALUES (66652600, 'FadeAway', 'Adc', '-', '-');
65INSERT INTO TPlayers VALUES (19360695, 'Fakespears', 'Mid', '-', '-');
66INSERT INTO TPlayers VALUES (46549675, 'Inodawae', 'Jungle', '-', '-');
67INSERT INTO TPlayers VALUES (48976966, 'Firestrain', 'Jungle', '-', '-');
68INSERT INTO TPlayers VALUES (41798762, 'Wobba', 'Top', '-', '-');
69INSERT INTO TPlayers VALUES (38539633, 'Funky Senpai', 'Adc', '-', '-');
70INSERT INTO TPlayers VALUES (33635821, 'Merok', 'Mid', '-', '-');
71INSERT INTO TPlayers VALUES (39361011, 'Arcturon', 'Support', '-', '-');
72INSERT INTO TPlayers VALUES (32859255, 'Blank', 'Top', '-', '-');
73INSERT INTO TPlayers VALUES (22220945, 'Kgerie', 'Support', '-', 'kgerie');
74INSERT INTO TPlayers VALUES (30166969, 'Insomnia', 'Jungle', '-', '-');
75INSERT INTO TPlayers VALUES (38611358, 'Flawless Support', 'Support', '-', '-');
76INSERT INTO TPlayers VALUES (19372857, 'Airwaks', 'Jungle', '-', 'Airwaks');
77INSERT INTO TPlayers VALUES (56740421, 'Montazz', 'Mid', '-', '-');
78INSERT INTO TPlayers VALUES (105466934, 'Alban', 'Mid', '-', 'Z_Albigoni_');
79INSERT INTO TPlayers VALUES (88877635, 'Emote', 'Jungle', '-', 'xEm0te');
80INSERT INTO TPlayers VALUES (102861219, 'Arber', 'Jungle', '-', 'ArberZogjani');
81
82-- LFT = Looking for team
83INSERT INTO TPlayers VALUES (22068890, 'Capputimo', 'Jungle', 'LFT', 'CappuTimo');
84INSERT INTO TPlayers VALUES (44633681, 'FridaHansdotter', 'Support', 'LFT', 'Philipp_Roman');
85
86-- AG = Arctic Gaming
87INSERT INTO TPlayers VALUES (21862231, 'Punchy', 'Adc', 'AG', 'freedom4punchy');
88INSERT INTO TPlayers VALUES (53389654, 'AgonZ', 'Jungle', 'AG', 'AgonZumeri');
89INSERT INTO TPlayers VALUES (29402065, 'Sleety', 'Top', 'AG', 'sleety_gecko');
90INSERT INTO TPlayers VALUES (104879735, 'Django', 'Mid', 'AG', 'DjanGobadalli');
91INSERT INTO TPlayers VALUES (22028849, 'MotoMoto', 'Support', 'AG', 'Grouuikk');
92
93-- eLS = Lausanne eSports
94INSERT INTO TPlayers VALUES (21283161, 'Fro10Soul', 'Top', 'eLS', 'Fro10Soul');
95INSERT INTO TPlayers VALUES (42777691, 'Kee', 'Jungle', 'eLS', 'Gkeveee17');
96INSERT INTO TPlayers VALUES (23531139, 'Sakrod', 'Mid', 'eLS', '-');
97INSERT INTO TPlayers VALUES (26937195, 'Plusle', 'Adc', 'eLS', 'PlusleLoL');
98INSERT INTO TPlayers VALUES (25894907, 'Tirizio', 'Support', 'eLS', 'Tiriziolol');
99
100-- RodG = Romandy Gaming
101INSERT INTO TPlayers VALUES (31507262, 'Bando', 'Top', 'RodG', 'Bando_lol');
102INSERT INTO TPlayers VALUES (43698257, 'Asha', 'Jungle', 'RodG', 'ashanome');
103INSERT INTO TPlayers VALUES (105440036, 'Unleash', 'Mid', 'RodG', 'iunleash1');
104INSERT INTO TPlayers VALUES (42866635, 'Tiborg', 'Adc', 'RodG', 'tiborglol');
105INSERT INTO TPlayers VALUES (23306564, 'Sengleur', 'Support', 'RodG', 'Sengleur');
106
107-- SPG = Swiss Prime Gaming
108INSERT INTO TPlayers VALUES (20202800, 'Pride', 'Top', 'SPG', 'pride__lol');
109INSERT INTO TPlayers VALUES (20183165, 'Koala with a hat', 'Jungle', 'SPG', 'KoalaWithaHat1');
110INSERT INTO TPlayers VALUES (21158361, 'GoldenGod', 'Mid', 'SPG', 'LoLGoldenGod');
111INSERT INTO TPlayers VALUES (37953023, 'Lagily', 'Mid', 'SPG', 'Lagily_');
112INSERT INTO TPlayers VALUES (85349708, 'Visa', 'Adc', 'SPG', 'SPG_Visa');
113INSERT INTO TPlayers VALUES (49552970, 'Sefi', 'Adc', 'SPG', 'seeefii');
114INSERT INTO TPlayers VALUES (21196565, 'Wild Joshy', 'Support', 'SPG', '-');
115
116-- mYI = mYInsanity
117INSERT INTO TPlayers VALUES (31771403, 'Sioser', 'Top', 'mYI', 'real_sioser');
118INSERT INTO TPlayers VALUES (24387527, 'Greenfire', 'Jungle', 'mYI', 'Green_EUW');
119INSERT INTO TPlayers VALUES (44402851, 'Polo', 'Adc', 'mYI', 'ughPolo');
120INSERT INTO TPlayers VALUES (24276647, 'Loolil', 'Support', 'mYI', 'Loolil_lol');
121
122-- XEN = Xention ESports
123INSERT INTO TPlayers VALUES (35462250, 'Maxiethunder', 'Support', 'XEN', 'Maxiethunder');
124INSERT INTO TPlayers VALUES (19364856, 'Marth', 'Adc', 'XEN', '-');
125INSERT INTO TPlayers VALUES (23513353, 'Valerio', 'Top', 'XEN', '-');
126INSERT INTO TPlayers VALUES (41718709, 'Lelouch', 'Mid', 'XEN', '-');
127INSERT INTO TPlayers VALUES (22448746, 'Allisrem', 'Jungle', 'XEN', 'Allisrem');
128
129-- noetic = Noetic
130INSERT INTO TPlayers VALUES (91617, 'Slice', 'Top', 'noetic', '-');
131INSERT INTO TPlayers VALUES (20496369, 'Kaziko', 'Jungle', 'noetic', '-');
132INSERT INTO TPlayers VALUES (20938282, 'Eliogal', 'Mid', 'noetic', 'EliogalLoL');
133INSERT INTO TPlayers VALUES (40690501, 'Navy', 'Adc', 'noetic', '-');
134INSERT INTO TPlayers VALUES (19100682, 'J0k3r', 'Support', 'noetic', '-');
135
136-- AR = Aeros Restia
137INSERT INTO TPlayers VALUES (24645199, 'Keikowah', 'Top', 'AR', '-');
138INSERT INTO TPlayers VALUES (20181953, 'Hitokuro', 'Adc', 'AR', '-');
139INSERT INTO TPlayers VALUES (21619149, 'Sly', 'Mid', 'AR', '-');
140
141-- VarG = Varg Gaming
142INSERT INTO TPlayers VALUES (33661988, 'Hermi', 'Adc', 'VarG', '-');
143INSERT INTO TPlayers VALUES (41595451, 'Reformed', 'Mid', 'VarG', '-');
144INSERT INTO TPlayers VALUES (24648723, 'Goosi', 'Support', 'VarG', '-');
145INSERT INTO TPlayers VALUES (40218582, 'RedB', 'Jungle', 'VarG', '-');
146INSERT INTO TPlayers VALUES (184328, 'Koala', 'Jungle', 'VarG', 'Koalaficated');
147INSERT INTO TPlayers VALUES (22715621, 'Sir bostitch', 'Top', 'VarG', '-');
148
149-- SCG = Small Cat Gaming
150INSERT INTO TPlayers VALUES (31531684, 'Xenium', 'Adc', 'SCG', '-');
151INSERT INTO TPlayers VALUES (37596871, 'Twaily', 'Top', 'SCG', '-');
152INSERT INTO TPlayers VALUES (28018158, 'Nicolaion', 'Jungle', 'SCG', '-');
153INSERT INTO TPlayers VALUES (37623673, 'Hallow', 'Mid', 'SCG', '-');
154
155-- ELV = Elvets Huelva
156INSERT INTO TPlayers VALUES (19328689, 'Talosin', 'Top', 'ELV', 'Talosin_lol');
157INSERT INTO TPlayers VALUES (51827557, 'Krüppi', 'Mid', 'ELV', 'KruppiLoL');
158INSERT INTO TPlayers VALUES (102169937, 'Raz', 'Adc', 'ELV', 'ELVRaz');
159
160-- NOX = Equinox
161INSERT INTO TPlayers VALUES (19036982, 'Aractosa', 'Jungle', 'NOX', '-');
162INSERT INTO TPlayers VALUES (18984559, 'Sonndo', 'Mid', 'NOX', '-');
163INSERT INTO TPlayers VALUES (19192102, 'Kaycon', 'Adc', 'NOX', '-');
164INSERT INTO TPlayers VALUES (19237139, 'Chefe', 'Support', 'NOX', '-');
165INSERT INTO TPlayers VALUES (25836259, 'Freeze', 'Top', 'NOX', '-');
166
167-- eRazed = eRazed
168INSERT INTO TPlayers VALUES (22614467, 'Alwhity', 'Adc', 'eRazed', '-');
169INSERT INTO TPlayers VALUES (24168440, 'Legit', 'Support', 'eRazed', '-');
170INSERT INTO TPlayers VALUES (25294877, 'Aconite', 'Mid', 'eRazed', '-');
171INSERT INTO TPlayers VALUES (63810177, 'Dranici', 'Jungle', 'eRazed', '-');
172INSERT INTO TPlayers VALUES (46860429, 'Alucard', 'Top', 'eRazed', '-');
173
174-- THF = Team Happy Feet
175INSERT INTO TPlayers VALUES (53882332, 'Vame', 'Jungle', 'THF', '-');
176INSERT INTO TPlayers VALUES (60534814, 'Jaene8383', 'Mid', 'THF', '-');
177INSERT INTO TPlayers VALUES (42187230, 'Lolztrel', 'Support', 'THF', '-');
178INSERT INTO TPlayers VALUES (66833784, 'Melo', 'Adc', 'THF', '-');
179INSERT INTO TPlayers VALUES (53727079, 'Nando', 'Top', 'THF', '-');
180
181-- THFA = Team Happy Feet Academy
182INSERT INTO TPlayers VALUES (54236875, 'Daarsc', 'Support', 'THFA', '-');
183INSERT INTO TPlayers VALUES (71117348, 'Sayaa', 'Jungle', 'THFA', '-');
184INSERT INTO TPlayers VALUES (71907717, 'Scratch', 'Top', 'THFA', '-');
185INSERT INTO TPlayers VALUES (40074190, 'Frigo', 'Adc', 'THFA', '-');
186INSERT INTO TPlayers VALUES (72373859, 'Skorm', 'Mid', 'THFA', '-');
187
188-- SPGA = Swiss Prime Gaming Academy
189INSERT INTO TPlayers VALUES (63767737, 'Gunfire', 'Jungle', 'SPGA', '-');
190INSERT INTO TPlayers VALUES (22396903, 'Titdody', 'Adc', 'SPGA', '-');
191INSERT INTO TPlayers VALUES (61639464, 'Miyoki', 'Mid', 'SPGA', '-');
192INSERT INTO TPlayers VALUES (27768948, 'Sunkinn', 'Top', 'SPGA', '-');
193INSERT INTO TPlayers VALUES (51330828, 'Lamora', 'Support', 'SPGA', '-');
194
195-- XENA = Xention eSports Academy
196INSERT INTO TPlayers VALUES (26997134, 'Shatter', 'Mid', 'XENA', '-');
197INSERT INTO TPlayers VALUES (94418558, 'Allchack', 'Support', 'XENA', '-');
198INSERT INTO TPlayers VALUES (39530438, 'Noob with Cookie', 'Jungle', 'XENA', '-');
199INSERT INTO TPlayers VALUES (35082594, 'Super Xahya Jhin', 'Adc', 'XENA', '-');
200INSERT INTO TPlayers VALUES (26188382, 'Finn', 'Top', 'XENA', '-');