1 removed '/home/joshua/Hockey-Test/echl15-16/echl15-16.log'
2 Creating ECHL Database.
3 Creating ECHL Conference Table.
4 Inserting ECHL Conference Data.
5 Conference Name: Eastern
7 Conference Name: Western
9 Creating ECHL Division Table.
10 Inserting ECHL Division Data.
11 Conference Name: Eastern
14 Conference Name: Eastern
17 Conference Name: Eastern
20 Conference Name: Western
21 Division Name: Midwest
23 Conference Name: Western
24 Division Name: Central
26 Conference Name: Western
29 Creating ECHL Team Table.
30 Inserting ECHL Team Data.
31 Inserting ECHL Teams From Eastern Conference.
32 Inserting ECHL Teams From East Division.
35 Arena Name: First Arena
37 Full City Name: Elmira, NY
38 Full Name: Elmira Jackals
43 Arena Name: Santander Arena
45 Full City Name: Reading, PA
46 Full Name: Reading Royals
51 Arena Name: Norfolk Scope
53 Full City Name: Norfolk, VA
54 Full Name: Norfolk Admirals
59 Arena Name: Glens Falls Civic Center
60 City Name: Glens Falls
61 Full City Name: Glens Falls, NY
62 Full Name: Adirondack Thunder
67 Arena Name: Verizon Wireless Arena
69 Full City Name: Manchester, NH
70 Full Name: Manchester Monarchs
74 Inserting ECHL Teams From North Division.
77 Arena Name: Wings Event Center
79 Full City Name: Kalamazoo, MI
80 Full Name: Kalamazoo Wings
85 Arena Name: Huntington Center
87 Full City Name: Toledo, OH
88 Full Name: Toledo Walleye
93 Arena Name: WesBanco Arena
95 Full City Name: Wheeling, WV
96 Full Name: Wheeling Nailers
101 Arena Name: Powerade Centre
103 Full City Name: Brampton, ON
104 Full Name: Brampton Beast
108 Inserting ECHL Teams From South Division.
110 Team Name: Gladiators
111 Arena Name: Infinite Energy Arena
113 Full City Name: Duluth, GA
114 Full Name: Atlanta Gladiators
118 Team Name: Swamp Rabbits
119 Arena Name: Bon Secours Wellness Arena
120 City Name: Greenville
121 Full City Name: Greenville, SC
122 Full Name: Greenville Swamp Rabbits
126 Team Name: Everblades
127 Arena Name: Germain Arena
129 Full City Name: Estero, FL
130 Full Name: Florida Everblades
134 Team Name: Solar Bears
135 Arena Name: Amway Center
137 Full City Name: Orlando, FL
138 Full Name: Orlando Solar Bears
143 Arena Name: North Charleston Coliseum
144 City Name: North Charleston
145 Full City Name: North Charleston, SC
146 Full Name: South Carolina Stingrays
150 Inserting ECHL Teams From Western Conference.
151 Inserting ECHL Teams From Midwest Division.
154 Arena Name: iWireless Center
156 Full City Name: Moline, IL
157 Full Name: Quad City Mallards
162 Arena Name: Ford Center
163 City Name: Evansville
164 Full City Name: Evansville, IN
165 Full Name: Evansville IceMen
170 Arena Name: Indiana Farmers Coliseum
171 City Name: Indianapolis
172 Full City Name: Indianapolis, IN
178 Arena Name: Allen County War Memorial Coliseum
179 City Name: Fort Wayne
180 Full City Name: Fort Wayne, IN
181 Full Name: Fort Wayne Komets
186 Arena Name: US Bank Arena
187 City Name: Cincinnati
188 Full City Name: Cincinnati, OH
189 Full Name: Cincinnati Cyclones
193 Inserting ECHL Teams From Central Division.
196 Arena Name: Intrust Bank Arena
198 Full City Name: Wichita, KS
199 Full Name: Wichita Thunder
204 Arena Name: Allen Event Center
206 Full City Name: Allen, TX
207 Full Name: Allen Americans
212 Arena Name: BOK Center
214 Full City Name: Tulsa, OK
215 Full Name: Tulsa Oilers
220 Arena Name: Silverstein Eye Centers Arena
221 City Name: Independence
222 Full City Name: Independence, MO
223 Full Name: Missouri Mavericks
227 Inserting ECHL Teams From West Division.
230 Arena Name: Sullivan Arena
232 Full City Name: Anchorage, AK
233 Full Name: Alaska Aces
237 Team Name: Steelheads
238 Arena Name: CenturyLink Arena
240 Full City Name: Boise, ID
241 Full Name: Idaho Steelheads
246 Arena Name: Maverik Center
247 City Name: West Valley City
248 Full City Name: West Valley City, UT
249 Full Name: Utah Grizzlies
254 Arena Name: Budweiser Events Center
256 Full City Name: Loveland, CO
257 Full Name: Colorado Eagles
262 Arena Name: Rushmore Plaza Civic Center
263 City Name: Rapid City
264 Full City Name: Rapid City, SD
265 Full Name: Rapid City Rush
269 DONE! All Team Data Inserted.
270 Creating ECHL Game Table.
271 Database Check Return: ok
273 DONE! All Game Data Inserted.
274 DONE! ECHL Database Created.
279 removed '/home/joshua/Hockey-Test/ahl15-16/ahl15-16.log'
280 Creating AHL Database.
281 Creating AHL Conference Table.
282 Inserting AHL Conference Data.
283 Conference Name: Eastern
285 Conference Name: Western
287 Creating AHL Division Table.
288 Inserting AHL Division Data.
289 Conference Name: Eastern
290 Division Name: Atlantic
292 Conference Name: Eastern
295 Conference Name: Western
296 Division Name: Central
298 Conference Name: Western
299 Division Name: Pacific
301 Creating AHL Team Table.
302 Inserting AHL Team Data.
303 Inserting AHL Teams From Eastern Conference.
304 Inserting AHL Teams From Atlantic Division.
306 Team Name: Sound Tigers
307 Arena Name: Webster Bank Arena
308 City Name: Bridgeport
309 Full City Name: Bridgeport, CT
310 Full Name: Bridgeport Sound Tigers
315 Arena Name: XL Center
317 Full City Name: Hartford, CT
318 Full Name: Hartford Wolf Pack
323 Arena Name: Giant Center
325 Full City Name: Hershey, PA
326 Full Name: Hershey Bears
331 Arena Name: PPL Center
333 Full City Name: Allentown, PA
334 Full Name: Lehigh Valley Phantoms
339 Arena Name: Cross Insurance Arena
341 Full City Name: Portland, ME
342 Full Name: Portland Pirates
347 Arena Name: Dunkin' Donuts Center
348 City Name: Providence
349 Full City Name: Providence, RI
350 Full Name: Providence Bruins
355 Arena Name: MassMutual Center
356 City Name: Springfield
357 Full City Name: Springfield, MA
358 Full Name: Springfield Falcons
363 Arena Name: Mohegan Sun Arena
364 City Name: Wilkes-Barre
365 Full City Name: Wilkes-Barre, PA
366 Full Name: Wilkes-Barre/Scranton Penguins
370 Inserting AHL Teams From North Division.
373 Arena Name: Times Union Center
375 Full City Name: Albany, NY
376 Full Name: Albany Devils
381 Arena Name: Floyd L. Maines Veterans Memorial Arena
382 City Name: Binghamton
383 Full City Name: Binghamton, NY
384 Full Name: Binghamton Senators
389 Arena Name: Blue Cross Arena
391 Full City Name: Rochester, NY
392 Full Name: Rochester Americans
397 Arena Name: Mile One Centre
398 City Name: St. John's
399 Full City Name: St. John's, NL
400 Full Name: St. John's IceCaps
405 Arena Name: Oncenter War Memorial Arena
407 Full City Name: Syracuse, NY
408 Full Name: Syracuse Crunch
413 Arena Name: Ricoh Coliseum
415 Full City Name: Toronto, ON
416 Full Name: Toronto Marlies
421 Arena Name: Utica Memorial Auditorium
423 Full City Name: Utica, NY
424 Full Name: Utica Comets
428 Inserting AHL Teams From Western Conference.
429 Inserting AHL Teams From Central Division.
432 Arena Name: Bojangles Coliseum
434 Full City Name: Charlotte, NC
435 Full Name: Charlotte Checkers
440 Arena Name: Allstate Arena
442 Full City Name: Rosemont, IL
443 Full Name: Chicago Wolves
448 Arena Name: Van Andel Arena
449 City Name: Grand Rapids
450 Full City Name: Grand Rapids, MI
451 Full Name: Grand Rapids Griffins
456 Arena Name: Wells Fargo Arena
457 City Name: Des Moines
458 Full City Name: Des Moines, IA
464 Arena Name: Quicken Loans Arena
466 Full City Name: Cleveland, OH
467 Full Name: Lake Erie Monsters
472 Arena Name: MTS Centre
474 Full City Name: Winnipeg, MB
475 Full Name: Manitoba Moose
480 Arena Name: BMO Harris Bradley Center
482 Full City Name: Milwaukee, WI
483 Full Name: Milwaukee Admirals
488 Arena Name: BMO Harris Bank Center
490 Full City Name: Rockford, IL
491 Full Name: Rockford IceHogs
495 Inserting AHL Teams From Pacific Division.
498 Arena Name: Rabobank Arena
499 City Name: Bakersfield
500 Full City Name: Bakersfield, CA
501 Full Name: Bakersfield Condors
506 Arena Name: Citizens Business Bank Arena
508 Full City Name: Ontario, CA
509 Full Name: Ontario Reign
514 Arena Name: AT&T Center
515 City Name: San Antonio
516 Full City Name: San Antonio, TX
517 Full Name: San Antonio Rampage
522 Arena Name: Valley View Casino Center
524 Full City Name: San Diego, CA
525 Full Name: San Diego Gulls
530 Arena Name: SAP Center
532 Full City Name: San Jose, CA
533 Full Name: San Jose Barracuda
538 Arena Name: Stockton Arena
540 Full City Name: Stockton, CA
541 Full Name: Stockton Heat
546 Arena Name: Cedar Park Center
547 City Name: Cedar Park
548 Full City Name: Cedar Park, TX
549 Full Name: Texas Stars
553 Arena Name: Raley Field
554 City Name: West Sacramento
555 Full City Name: West Sacramento, CA
557 DONE! All Team Data Inserted.
558 Creating AHL Game Table.
559 Database Check Return: ok
561 DONE! All Game Data Inserted.
562 DONE! AHL Database Created.
567 removed '/home/joshua/Hockey-Test/nhl15-16/nhl15-16.log'
568 Creating NHL Database.
569 Creating NHL Conference Table.
570 Inserting NHL Conference Data.
571 Conference Name: Eastern
573 Conference Name: Western
575 Creating NHL Division Table.
576 Inserting NHL Division Data.
577 Conference Name: Eastern
578 Division Name: Atlantic
580 Conference Name: Eastern
581 Division Name: Metropolitan
583 Conference Name: Western
584 Division Name: Central
586 Conference Name: Western
587 Division Name: Pacific
589 Creating NHL Team Table.
590 Inserting NHL Team Data.
591 Inserting NHL Teams From Eastern Conference.
592 Inserting NHL Teams From Atlantic Division.
595 Arena Name: TD Garden
597 Full City Name: Boston, MA
598 Full Name: Boston Bruins
603 Arena Name: First Niagara Center
605 Full City Name: Buffalo, NY
606 Full Name: Buffalo Sabres
611 Arena Name: Joe Louis Arena
613 Full City Name: Detroit, MI
614 Full Name: Detroit Red Wings
619 Arena Name: BB&T Center
621 Full City Name: Sunrise, FL
622 Full Name: Florida Panthers
627 Arena Name: Bell Centre
629 Full City Name: Montreal, QC
630 Full Name: Montreal Canadiens
635 Arena Name: Canadian Tire Centre
637 Full City Name: Ottawa, ON
638 Full Name: Ottawa Senators
643 Arena Name: Amalie Arena
645 Full City Name: Tampa Bay, FL
646 Full Name: Tampa Bay Lightning
650 Team Name: Maple Leafs
651 Arena Name: Air Canada Centre
653 Full City Name: Toronto, ON
654 Full Name: Toronto Maple Leafs
658 Inserting NHL Teams From Metropolitan Division.
660 Team Name: Hurricanes
661 Arena Name: PNC Arena
663 Full City Name: Carolina, NC
664 Full Name: Carolina Hurricanes
666 Division: Metropolitan
668 Team Name: Blue Jackets
669 Arena Name: Nationwide Arena
671 Full City Name: Columbus, OH
672 Full Name: Columbus Blue Jackets
674 Division: Metropolitan
677 Arena Name: Prudential Center
678 City Name: New Jersey
679 Full City Name: New Jersey, NJ
680 Full Name: New Jersey Devils
682 Division: Metropolitan
685 Arena Name: Barclays Center
686 City Name: New York City
687 Full City Name: New York City, NY
688 Full Name: New York Islanders
690 Division: Metropolitan
693 Arena Name: Madison Square Garden
694 City Name: New York City
695 Full City Name: New York City, NY
696 Full Name: New York Rangers
698 Division: Metropolitan
701 Arena Name: Wells Fargo Center
702 City Name: Philadelphia
703 Full City Name: Philadelphia, PA
704 Full Name: Philadelphia Flyers
706 Division: Metropolitan
709 Arena Name: Consol Energy Center
710 City Name: Pittsburgh
711 Full City Name: Pittsburgh, PA
712 Full Name: Pittsburgh Penguins
714 Division: Metropolitan
717 Arena Name: Verizon Center
718 City Name: Washington
719 Full City Name: Washington, D.C.
720 Full Name: Washington Capitals
722 Division: Metropolitan
724 Inserting NHL Teams From Western Conference.
725 Inserting NHL Teams From Central Division.
727 Team Name: Blackhawks
728 Arena Name: United Center
730 Full City Name: Chicago, IL
731 Full Name: Chicago Blackhawks
736 Arena Name: Pepsi Center
738 Full City Name: Denver, CO
739 Full Name: Colorado Avalanche
744 Arena Name: American Airlines Center
746 Full City Name: Dallas, TX
747 Full Name: Dallas Stars
752 Arena Name: Xcel Energy Center
754 Full City Name: St. Paul, MN
755 Full Name: Minnesota Wild
760 Arena Name: Bridgestone Arena
762 Full City Name: Nashville, TN
763 Full Name: Nashville Predators
768 Arena Name: Scottrade Center
770 Full City Name: St. Louis, MO
771 Full Name: St. Louis Blues
776 Arena Name: MTS Centre
778 Full City Name: Winnipeg, MB
779 Full Name: Winnipeg Jets
783 Inserting NHL Teams From Pacific Division.
786 Arena Name: Honda Center
788 Full City Name: Anaheim, CA
789 Full Name: Anaheim Ducks
794 Arena Name: Gila River Arena
796 Full City Name: Glendale, AZ
797 Full Name: Arizona Coyotes
802 Arena Name: Scotiabank Saddledome
804 Full City Name: Calgary, AB
805 Full Name: Calgary Flames
810 Arena Name: Rexall Place
812 Full City Name: Edmonton, AB
813 Full Name: Edmonton Oilers
818 Arena Name: Staples Center
819 City Name: Los Angeles
820 Full City Name: Los Angeles, CA
821 Full Name: Los Angeles Kings
826 Arena Name: SAP Center
828 Full City Name: San Jose, CA
829 Full Name: San Jose Sharks
834 Arena Name: Rogers Arena
836 Full City Name: Vancouver, BC
837 Full Name: Vancouver Canucks
841 Arena Name: Gillette Stadium
842 City Name: Foxborough
843 Full City Name: Foxborough, MA
845 Arena Name: TCF Bank Stadium
846 City Name: Minneapolis
847 Full City Name: Minneapolis, MN
849 Arena Name: Coors Field
851 Full City Name: Denver, CO
853 DONE! All Team Data Inserted.
854 Creating NHL Game Table.
855 Database Check Return: ok
857 DONE! All Game Data Inserted.
858 DONE! NHL Database Created.