import from gamessocial

12 files changed, 2025 insertions, 0 deletions

diff --git a/seeds/BuildSeeder.php b/seeds/BuildSeeder.php
new file mode 100644
index 0000000..2e633f3
--- /dev/null
+++ b/seeds/BuildSeeder.php
@@ -0,0 +1,290 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class BuildSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        DB::table('build')->insert([
+            'id' => 1,
+            'name' => 'all',
+            'dimension_on' => 'global'
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 2,
+            'name' => 'BP TM TM',
+            'dimension_on' => 'global',
+            'item_1' => 9,
+            'item_2' => 64,
+            'item_1_count' => 1,
+            'item_2_count' => 2,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 3,
+            'name' => 'TB BP TM',
+            'dimension_on' => 'global',
+            'item_1' => 61,
+            'item_2' => 9,
+            'item_3' => 64,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 4,
+            'name' => 'SB BP TT',
+            'dimension_on' => 'global',
+            'item_1' => 9,
+            'item_2' => 56,
+            'item_3' => 64,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 5,
+            'name' => 'SM BP TM',
+            'dimension_on' => 'global',
+            'item_1' => 51,
+            'item_2' => 9,
+            'item_3' => 64,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 6,
+            'name' => 'SM BP SB',
+            'dimension_on' => 'global',
+            'item_1' => 51,
+            'item_2' => 9,
+            'item_3' => 56,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 7,
+            'name' => 'SB BP TM',
+            'dimension_on' => 'global',
+            'item_1' => 56,
+            'item_2' => 64,
+            'item_3' => 9,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 8,
+            'name' => 'SB TM TM',
+            'dimension_on' => 'global',
+            'item_1' => 56,
+            'item_2' => 64,
+            'item_1_count' => 1,
+            'item_2_count' => 2,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 9,
+            'name' => 'BP SM PS',
+            'dimension_on' => 'global',
+            'item_1' => 9,
+            'item_2' => 51,
+            'item_3' => 47,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 10,
+            'name' => 'TB SB TM',
+            'dimension_on' => 'global',
+            'item_1' => 61,
+            'item_2' => 56,
+            'item_3' => 64,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 11,
+            'name' => 'SB PS BP',
+            'dimension_on' => 'global',
+            'item_1' => 56,
+            'item_2' => 47,
+            'item_3' => 9,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 12,
+            'name' => 'TB SB SB',
+            'dimension_on' => 'global',
+            'item_1' => 61,
+            'item_2' => 56,
+            'item_1_count' => 1,
+            'item_2_count' => 2,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 13,
+            'name' => 'SB TT TM',
+            'dimension_on' => 'global',
+            'item_1' => 56,
+            'item_2' => 62,
+            'item_3' => 64,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 14,
+            'name' => 'SM TT SB',
+            'dimension_on' => 'global',
+            'item_1' => 51,
+            'item_2' => 62,
+            'item_3' => 56,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 15,
+            'name' => 'AS BM AC',
+            'dimension_on' => 'global',
+            'item_1' => 2,
+            'item_2' => 10,
+            'item_3' => 3,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 16,
+            'name' => 'AS BM Eve',
+            'dimension_on' => 'global',
+            'item_1' => 2,
+            'item_2' => 10,
+            'item_3' => 23,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 17,
+            'name' => 'Eve BM FB',
+            'dimension_on' => 'global',
+            'item_1' => 23,
+            'item_2' => 10,
+            'item_3' => 27,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 18,
+            'name' => 'SG BM Eve',
+            'dimension_on' => 'global',
+            'item_1' => 23,
+            'item_2' => 10,
+            'item_3' => 52,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 19,
+            'name' => 'SG CW BM',
+            'dimension_on' => 'global',
+            'item_1' => 52,
+            'item_2' => 12,
+            'item_3' => 10,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 20,
+            'name' => 'SC AS BM',
+            'dimension_on' => 'global',
+            'item_1' => 58,
+            'item_2' => 2,
+            'item_3' => 10,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 21,
+            'name' => 'AC FB BM',
+            'dimension_on' => 'global',
+            'item_1' => 3,
+            'item_2' => 27,
+            'item_3' => 10,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+        DB::table('build')->insert([
+            'id' => 22,
+            'name' => 'AS SG BM',
+            'dimension_on' => 'global',
+            'item_1' => 2,
+            'item_2' => 52,
+            'item_3' => 10,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 23,
+            'name' => 'AC SG BM',
+            'dimension_on' => 'global',
+            'item_1' => 3,
+            'item_2' => 52,
+            'item_3' => 10,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+        DB::table('build')->insert([
+            'id' => 24,
+            'name' => 'Eve BM AC',
+            'dimension_on' => 'global',
+            'item_1' => 23,
+            'item_2' => 10,
+            'item_3' => 3,
+            'item_1_count' => 1,
+            'item_2_count' => 1,
+            'item_3_count' => 1,
+        ]);
+
+    }
+}
diff --git a/seeds/DatabaseSeeder.php b/seeds/DatabaseSeeder.php
new file mode 100644
index 0000000..cb423b2
--- /dev/null
+++ b/seeds/DatabaseSeeder.php
@@ -0,0 +1,27 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class DatabaseSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        // $this->call(BuildSeeder::class);
+        // $this->call(KeysTableSeeder::class);
+        // $this->call(GameModeSeeder::class);
+        // $this->call(SeriesSeeder::class);
+        // $this->call(RoleSeeder::class);
+        // $this->call(RegionSeeder::class);
+        // $this->call(GamerSeeder::class);
+        // $this->call(ItemsSeeder::class);
+        // $this->call(HeroesSeeder::class);
+        // $this->call(FilterSeeder::class);
+        // $this->call(SkilltierSeeder::class);
+
+    }
+}
diff --git a/seeds/FilterSeeder.php b/seeds/FilterSeeder.php
new file mode 100644
index 0000000..0be216e
--- /dev/null
+++ b/seeds/FilterSeeder.php
@@ -0,0 +1,32 @@
+<?php
+
+use Carbon\Carbon;
+use Illuminate\Database\Seeder;
+
+class FilterSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('filter')->insert([
+            'id' => 1,
+            'name' => 'all',
+            'dimension_on' => 'player',
+            'filter'=> '',
+            'filter_hash'=> ''
+        ]);
+
+        DB::table('filter')->insert([
+            'id' => 2,
+            'name' => 'all',
+            'dimension_on' => 'global',
+            'filter'=> '',
+            'filter_hash'=> ''
+        ]);
+    }
+}
diff --git a/seeds/GameModeSeeder.php b/seeds/GameModeSeeder.php
new file mode 100644
index 0000000..765b739
--- /dev/null
+++ b/seeds/GameModeSeeder.php
@@ -0,0 +1,61 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class GameModeSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('game_mode')->insert([
+         'id' => 1,
+           'name' => 'all',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 2,
+           'name' => 'casual',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 3,
+           'name' => 'ranked',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 4,
+           'name' => 'blitz_pvp_ranked',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 5,
+           'name' => 'casual_aral',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 6,
+           'name' => 'private',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 7,
+           'name' => 'private_ranked',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 8,
+           'name' => 'private_party_blitz_match',
+       ]);
+
+       DB::table('game_mode')->insert([
+           'id' => 9,
+           'name' => 'private_party_aral_match',
+       ]);
+
+    }
+}
diff --git a/seeds/GamerSeeder.php b/seeds/GamerSeeder.php
new file mode 100644
index 0000000..9cff0bc
--- /dev/null
+++ b/seeds/GamerSeeder.php
@@ -0,0 +1,61 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class GamerSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('gamer')->insert([
+            'player_api_id' => '44693bc0-9f02-11e5-ad28-06eb725f8a76',
+            'name' => 'StormCallerSr',
+            'vainsocial_status' => 'developer',
+            'vainglory_ign' => 'StormCallerSr',
+            'vainglory_shard_id' => 'sg',
+            'vainglory_is_pro' => false,
+        ]);
+
+        DB::table('gamer')->insert([
+            'player_api_id' => '8f454688-2fe5-11e6-9433-06d90c28bf1a',
+            'name' => 'shutterfly',
+            'vainsocial_status' => 'developer',
+            'vainglory_ign' => 'shutterfly',
+            'vainglory_shard_id' => 'eu',
+            'vainglory_is_pro' => false,
+        ]);
+
+        DB::table('gamer')->insert([
+            'player_api_id' => 'c865b42e-5b01-11e6-91aa-06fc87f1dd11',
+            'name' => 'HellsByte',
+            'vainsocial_status' => 'supporter',
+            'vainglory_ign' => 'HellsByte',
+            'vainglory_shard_id' => 'eu',
+            'vainglory_is_pro' => false,
+        ]);
+
+        DB::table('gamer')->insert([
+            'player_api_id' => '1314f3f8-c53b-11e4-946e-06eb725f8a76',
+            'name' => 'idmonfish',
+            'vainsocial_status' => 'supporter',
+            'vainglory_ign' => 'idmonfish',
+            'vainglory_shard_id' => 'sg',
+            'vainglory_is_pro' => false,
+        ]);
+
+        DB::table('gamer')->insert([
+            'player_api_id' => '844b66aa-d359-11e6-b4c3-06ab1a16f8e5',
+            'name' => 'kamaelxiii',
+            'vainsocial_status' => 'supporter',
+            'vainglory_ign' => 'kamaelxiii',
+            'vainglory_shard_id' => 'sg',
+            'vainglory_is_pro' => false,
+        ]);
+
+    }
+}
diff --git a/seeds/HeroesSeeder.php b/seeds/HeroesSeeder.php
new file mode 100644
index 0000000..1c906ab
--- /dev/null
+++ b/seeds/HeroesSeeder.php
@@ -0,0 +1,717 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use Carbon\Carbon;
+
+class HeroesSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'all',
+            'api_name' => '*All*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Vox',
+            'api_name' => '*Vox*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Celeste',
+            'api_name' => '*Celeste*',
+            'is_assassin' => false,
+            'is_mage' => true,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Catherine',
+            'api_name' => '*Catherine*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Ringo',
+            'api_name' => '*Ringo*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Adagio',
+            'api_name' => '*Adagio*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Koshka',
+            'api_name' => '*Koshka*',
+            'is_assassin' => true,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Glaive',
+            'api_name' => '*Glaive*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Petal',
+            'api_name' => '*Petal*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'SAW',
+            'api_name' => '*SAW*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Krul',
+            'api_name' => '*Krul*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Taka',
+            'api_name' => '*Taka*',
+            'is_assassin' => true,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Skaarf',
+            'api_name' => '*Skaarf*',
+            'is_assassin' => false,
+            'is_mage' => true,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Ardan',
+            'api_name' => '*Ardan*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Fortress',
+            'api_name' => '*Fortress*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Rona',
+            'api_name' => '*Rona*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Skye',
+            'api_name' => '*Skye*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Phinn',
+            'api_name' => '*Phinn*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Blackfeather',
+            'api_name' => '*Blackfeather*',
+            'is_assassin' => true,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+            DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Kestrel',
+            'api_name' => '*Kestrel*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Reim',
+            'api_name' => '*Reim*',
+            'is_assassin' => false,
+            'is_mage' => true,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Ozo',
+            'api_name' => '*Ozo*',
+            'is_assassin' => true,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Alpha',
+            'api_name' => '*Aplha*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Lance',
+            'api_name' => '*Lance*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Samuel',
+            'api_name' => '*Samuel*',
+            'is_assassin' => false,
+            'is_mage' => true,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Baron',
+            'api_name' => '*Baron*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Gwen',
+            'api_name' => '*Gwen*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => true,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Flicker',
+            'api_name' => '*Flicker*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Idris',
+            'api_name' => '*Idris*',
+            'is_assassin' => true,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Grumpjaw',
+            'api_name' => '*Grumpjaw*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Lyra',
+            'api_name' => '*Lyra*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => true,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => false,
+            'is_captain' => true,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Joule',
+            'api_name' => '*Joule*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => true,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.2',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Baptiste',
+            'api_name' => '*Baptiste*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.4',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Grace',
+            'api_name' => '*Grace*',
+            'is_assassin' => false,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.6',
+            'is_carry' =>  true,
+            'is_jungler' => false,
+            'is_captain' => false,
+        ]);
+
+        DB::table('hero')->insert([
+            'created_at' => Carbon::now(),
+            'updated_at' => Carbon::now(),
+            'name' => 'Reza',
+            'api_name' => '*Reza*',
+            'is_assassin' => true,
+            'is_mage' => false,
+            'is_protector' => false,
+            'is_sniper' => false,
+            'is_warrior' => false,
+            'heroic_perk' => '',
+            'ability_a' => '',
+            'ability_b' => '',
+            'ability_c' => '',
+            'added_in_patch' => '2.7',
+            'is_carry' =>  false,
+            'is_jungler' => true,
+            'is_captain' => false,
+        ]);
+
+    }
+}
diff --git a/seeds/ItemsSeeder.php b/seeds/ItemsSeeder.php
new file mode 100644
index 0000000..eb42ff8
--- /dev/null
+++ b/seeds/ItemsSeeder.php
@@ -0,0 +1,513 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class ItemsSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1063_Item_Aegis*',
+            'name' => 'Aegis',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1050_Item_Aftershock*',
+            'name' => 'Aftershock',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1069_Item_AlternatingCurrent*',
+            'name' => 'Alternating Current',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1057_Item_AtlasPauldron*',
+            'name' => 'Atlas Pauldron',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1060_Item_BarbedNeedle*',
+            'name' => 'Barbed Needle',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1010_Item_BlazingSalvo*',
+            'name' => 'Blazing Salvo',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1039_Item_Bonesaw*',
+            'name' => 'Bonesaw',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1059_Item_BookOfEulogies*',
+            'name' => 'Book of Eulogies',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1067_Item_BreakingPoint*',
+            'name' => 'Breaking Point',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1055_Item_BrokenMyth*',
+            'name' => 'Broken Myth',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1028_Item_Chronograph*',
+            'name' => 'Chronograph',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1029_Item_Clockwork*',
+            'name' => 'Clockwork',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1022_Item_CoatOfPlates*',
+            'name' => 'Coat of Plates',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1079_Item_Contraption*',
+            'name' => 'Contraption',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1046_Item_Crucible*',
+            'name' => 'Crucible',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1003_Item_CrystalBit*',
+            'name' => 'Crystal Bit',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1053_Item_CrystalInfusion*',
+            'name' => 'Crystal Infusion',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1085_Item_DragonbloodContract*',
+            'name' => 'Dragonblood Contract',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1016_Item_Dragonheart*',
+            'name' => 'Dragonheart',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1097_Item_Echo*',
+            'name' => 'Echo',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1009_Item_EclipsePrism*',
+            'name' => 'Eclipse Prism',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1025_Item_EnergyBattery*',
+            'name' => 'Energy Battery',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1071_Item_EveOfHarvest*',
+            'name' => 'Eve of Harvest',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1038_Item_Flare*',
+            'name' => 'Flare',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1088_Item_Flaregun*',
+            'name' => 'Flare Gun',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1045_Item_FountainOfRenewal*',
+            'name' => 'Fountain of Renewal',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1044_Item_Frostburn*',
+            'name' => 'Frostburn',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1087_Item_HalcyonChargers*',
+            'name' => 'Halcyon Chargers',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1000_Item_HalcyonPotion*',
+            'name' => 'Halcyon Potion',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1072_Item_HeavyPrism*',
+            'name' => 'Heavy Prism',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1065_Item_HeavySteel*',
+            'name' => 'Heavy Steel',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1026_Item_Hourglass*',
+            'name' => 'Hourglass',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1073_Item_IronguardContract*',
+            'name' => 'Ironguard Contract',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1047_Item_JourneyBoots*',
+            'name' => 'Journey Boots',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1062_Item_KineticShield*',
+            'name' => 'Kinetic Shield',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1064_Item_Lifespring*',
+            'name' => 'Lifespring',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1017_Item_LightArmor*',
+            'name' => 'Light Armor',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1061_Item_LightShield*',
+            'name' => 'Light Shield',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1068_Item_LuckyStrike*',
+            'name' => 'Lucky Strike',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1024_Item_MetalJacket*',
+            'name' => 'Metal Jacket',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1041_Item_MinionCandy*',
+            'name' => 'Minion Candy',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1080_Item_MinionsFoot*',
+            'name' => 'Minion\'s Foot',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1095_Item_NullwaveGauntlet*',
+            'name' => 'Nullwave Gauntlet',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1015_Item_Oakheart*',
+            'name' => 'Oakheart',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1070_Item_PiercingShard*',
+            'name' => 'Piercing Shard',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1066_Item_PiercingSpear*',
+            'name' => 'Piercing Spear',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1092_Item_PoisonedShiv*',
+            'name' => 'Poisoned Shiv',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1084_Item_ProtectorContract*',
+            'name' => 'Protector Contract',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1043_Item_ReflexBlock*',
+            'name' => 'Reflex Block',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1054_Item_ScoutTrap*',
+            'name' => 'Scout Trap',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1034_Item_SerpentMask*',
+            'name' => 'Serpent Mask',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1013_Item_Shatterglass*',
+            'name' => 'Shatterglass',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1042_Item_Shiversteel*',
+            'name' => 'Shiversteel',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1005_Item_SixSins*',
+            'name' => 'Six Sins',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1105_Item_SlumberingHusk*',
+            'name' => 'Slumbering Husk',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1012_Item_Sorrowblade*',
+            'name' => 'Sorrowblade',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1030_Item_SprintBoots*',
+            'name' => 'Sprint Boots',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1090_Item_Stormcrown*',
+            'name' => 'Stormcrown',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1074_Item_StormguardBanner*',
+            'name' => 'Stormguard Banner',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1004_Item_SwiftShooter*',
+            'name' => 'Swift Shooter',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1035_Item_TensionBow*',
+            'name' => 'Tension Bow',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1014_Item_TornadoTrigger*',
+            'name' => 'Tornado Trigger',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1032_Item_TravelBoots*',
+            'name' => 'Travel Boots',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1049_Item_TyrantsMonocle*',
+            'name' => 'Tyrant\'s Monocle' ,
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1027_Item_VoidBattery*',
+            'name' => 'Void Battery',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1056_Item_WarTreads*',
+            'name' => 'War Treads',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1002_Item_WeaponBlade*',
+            'name' => 'Weapon Blade',
+            'is_activable' => false
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1052_Item_WeaponInfusion*',
+            'name' => 'Weapon Infusion',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1002_Item_CandyShop_Kissy*',
+            'name' => 'Kissy',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1005_Item_CandyShop_Taunt*',
+            'name' => 'Taunt',
+            'is_activable' => true
+        ]);
+
+        DB::table('item')->insert([
+            'series' => '0',
+            'api_id' => '*1007_Item_CandyShop_VOTaunt*',
+            'name' => 'Voice over Taunt',
+            'is_activable' => true
+        ]);
+
+    }
+}
diff --git a/seeds/KeysTableSeeder.php b/seeds/KeysTableSeeder.php
new file mode 100644
index 0000000..feec53d
--- /dev/null
+++ b/seeds/KeysTableSeeder.php
@@ -0,0 +1,27 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class KeysTableSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        // Configs
+        DB::table('keys')->insert([
+            'type' => 'config',
+            'key' => 'page_size',
+            'value' => '10'
+        ]);
+
+        DB::table('keys')->insert([
+            'type' => 'config',
+            'key' => 'hp_fans',
+            'value' => '3'
+        ]);
+    }
+}
diff --git a/seeds/RegionSeeder.php b/seeds/RegionSeeder.php
new file mode 100644
index 0000000..e3b8f61
--- /dev/null
+++ b/seeds/RegionSeeder.php
@@ -0,0 +1,46 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class RegionSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('region')->insert([
+        	'id' => 1,
+            'name' => 'all',
+        ]);
+
+        DB::table('region')->insert([
+            'id' => 2,
+            'name' => 'sg',
+        ]);
+
+        DB::table('region')->insert([
+            'id' => 3,
+            'name' => 'na',
+        ]);
+        DB::table('region')->insert([
+            'id' => 4,
+            'name' => 'ea',
+        ]);
+        DB::table('region')->insert([
+            'id' => 5,
+            'name' => 'sa',
+        ]);
+        DB::table('region')->insert([
+            'id' => 6,
+            'name' => 'chn',
+        ]);
+        DB::table('region')->insert([
+            'id' => 7,
+            'name' => 'eu',
+        ]);
+    }
+}
diff --git a/seeds/RoleSeeder.php b/seeds/RoleSeeder.php
new file mode 100644
index 0000000..41706ad
--- /dev/null
+++ b/seeds/RoleSeeder.php
@@ -0,0 +1,34 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class RoleSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('role')->insert([
+        	'id' => 1,
+            'name' => 'all',
+        ]);
+
+        DB::table('role')->insert([
+            'id' => 2,
+            'name' => 'carry',
+        ]);
+
+        DB::table('role')->insert([
+            'id' => 3,
+            'name' => 'jungler',
+        ]);
+        DB::table('role')->insert([
+            'id' => 4,
+            'name' => 'captain',
+        ]);
+    }
+}
diff --git a/seeds/SeriesSeeder.php b/seeds/SeriesSeeder.php
new file mode 100644
index 0000000..63cd691
--- /dev/null
+++ b/seeds/SeriesSeeder.php
@@ -0,0 +1,130 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use Carbon\Carbon;
+
+class SeriesSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('series')->insert([
+            'name' => 'all',
+            'dimension_on' => 'player',
+            'start'=> Carbon::createFromDate(2017, 1, 1),
+            'end'=> Carbon::createFromDate(2020, 1, 1),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.2',
+            'dimension_on' => 'player',
+            'start'=> Carbon::createFromDate(2017, 1, 1),
+            'end'=> Carbon::createFromDate(2017, 3, 27),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.3',
+            'dimension_on' => 'player',
+            'start'=> Carbon::createFromDate(2017, 3, 28),
+            'end' => Carbon::createFromDate(2017, 4, 26),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'all',
+            'dimension_on' => 'global',
+            'start'=> Carbon::createFromDate(2017, 1, 1),
+            'end'=> Carbon::createFromDate(2020, 1, 1),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.2',
+            'dimension_on' => 'global',
+            'start'=> Carbon::createFromDate(2017, 1, 1),
+            'end'=> Carbon::createFromDate(2017, 3, 27),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.3',
+            'dimension_on' => 'global',
+            'start'=> Carbon::createFromDate(2017, 3, 28),
+            'end' => Carbon::createFromDate(2017, 4, 26),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.4',
+            'dimension_on' => 'player',
+            'start'=> Carbon::createFromDate(2017, 4, 26),
+            'end' => Carbon::createFromDate(2017, 5, 31),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.4',
+            'dimension_on' => 'global',
+            'start'=> Carbon::createFromDate(2017, 4, 26),
+            'end' => Carbon::createFromDate(2017, 5, 31),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.5',
+            'dimension_on' => 'player',
+            'start'=> Carbon::createFromDate(2017, 5, 31),
+            'end' => Carbon::createFromDate(2017, 6, 21),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.5',
+            'dimension_on' => 'global',
+            'start'=> Carbon::createFromDate(2017, 5, 31),
+            'end' => Carbon::createFromDate(2017, 6, 21),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.6',
+            'dimension_on' => 'player',
+            'start'=> Carbon::createFromDate(2017, 6, 21),
+            'end' => Carbon::createFromDate(2017, 8, 8),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.6',
+            'dimension_on' => 'global',
+            'start'=> Carbon::createFromDate(2017, 6, 21),
+            'end' => Carbon::createFromDate(2017, 8, 8),
+            'show_in_web' => true
+        ]);
+
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.7',
+            'dimension_on' => 'player',
+            'start'=> Carbon::now(),
+            'end' => Carbon::createFromDate(2020, 6, 21),
+            'show_in_web' => true
+        ]);
+
+        DB::table('series')->insert([
+            'name' => 'Patch 2.7',
+            'dimension_on' => 'global',
+            'start'=> Carbon::now(),
+            'end' => Carbon::createFromDate(2020, 6, 21),
+            'show_in_web' => true
+        ]);
+
+    }
+}
diff --git a/seeds/SkilltierSeeder.php b/seeds/SkilltierSeeder.php
new file mode 100644
index 0000000..2f68a11
--- /dev/null
+++ b/seeds/SkilltierSeeder.php
@@ -0,0 +1,87 @@
+<?php
+
+use Illuminate\Database\Seeder;
+
+class SkilltierSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     *
+     * @return void
+     */
+    public function run()
+    {
+        //
+        DB::table('skill_tier')->insert([
+            'name' => 'all',
+            'start'=> -1,
+            'end'=> 30,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Unranked',
+            'start'=> -1,
+            'end'=> -1,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Just Beginning',
+            'start'=> 0,
+            'end'=> 2,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Getting There',
+            'start'=> 3,
+            'end'=> 5,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Rock Solid',
+            'start'=> 6,
+            'end'=> 8,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Worthy Foe',
+            'start'=> 9,
+            'end'=> 11,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Got Swagger',
+            'start'=> 12,
+            'end'=> 14,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Credible Threat',
+            'start'=> 15,
+            'end'=> 17,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'The Hotness',
+            'start'=> 18,
+            'end'=> 20,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Simply Amazing',
+            'start'=> 21,
+            'end'=> 23,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Pinnacle Of Awesome',
+            'start'=> 24,
+            'end'=> 26,
+        ]);
+
+        DB::table('skill_tier')->insert([
+            'name' => 'Vainglorious',
+            'start'=> 27,
+            'end'=> 29,
+        ]);
+    }
+}