text: exports.seed = function(knex, Promise) {
    // Deletes ALL existing entries
    return knex('spaceships')
      .truncate()
      .then(function() {
        // Inserts seed entries
        return knex('spaceships').insert([
          {
            name: 'Executor',
            model: 'Executor-class star dreadnought',
            manufacturer: 'Kuat Drive Yards, Fondor Shipyards',
            cost_in_credits: '1143350000',
            length: '19000',
            max_atmosphering_speed: '100',
            crew: '279144',
            passengers: '38000',
            cargo_capacity: '250000000',
            consumables: '6 years',
            hyperdrive_rating: '2.0',
            starship_class: 'Star Dreadnought',
            imageUrl:
              'https://vignette.wikia.nocookie.net/starwars/images/3/30/Executor_BF2.png/revision/latest?cb=20180903230846',
            pilots: 'no data',
          },
          {
            name: 'Sentinel-class landing craft',
            model: 'Sentinel-class landing craft',
            manufacturer: 'Sienar Fleet Systems, Cyngus Spaceworks ',
            cost_in_credits: '240000',
            length: '38',
            max_atmosphering_speed: '1000',
            crew: '5',
            passengers: '75',
            cargo_capacity: '180000',
            consumables: '1 month',
            hyperdrive_rating: '1.0',
            starship_class: 'Landing Craft',
            imageUrl:
              'https://lumiere-a.akamaihd.net/v1/images/veh_ia_1752_040381b2.jpeg?region=100%2C0%2C983%2C981&width=960',
            pilots: 'no data',
          },
          {
            name: 'Death Star',
            model: 'DS-1 Orbital Battle Station',
            manufacturer:
              'Imperial Department of Military Research, Sienar Fleet Systems',
            cost_in_credits: '1000000000000',
            length: '120000',
            max_atmosphering_speed: '<100',
            crew: '342953',
            passengers: '843342',
            cargo_capacity: '1000000000000',
            consumables: '3 years',
            hyperdrive_rating: '4.0',
            starship_class: 'Deep Space Mobile Battlestation',
            imageUrl:
              'https://lumiere-a.akamaihd.net/v1/images/Death-Star-I-copy_36ad2500.jpeg?region=0%2C0%2C1600%2C900&width=960',
            pilots: 'no data',
          },
          {
            name: 'Millennium Falcon',
            model: 'YT-1300 light freighter',
            manufacturer: 'Corellian Engineering Corporation',
            cost_in_credits: '100000',
            length: '34.37',
            max_atmosphering_speed: '1050',
            crew: '4',
            passengers: '6',
            cargo_capacity: '100000',
            consumables: '2 months',
            hyperdrive_rating: '0.5',
            starship_class: 'Light Freighter',
            imageUrl:
              'https://gemr.com/wp-content/uploads/2018/05/3653334524001_5703541606001_5703529855001-vs-1024x576.jpg',
            pilots: [
              {
                name: 'Chewbacca',
                height: '228',
                mass: '112',
                hair_color: 'brown',
                skin_color: 'unknown',
                eye_color: 'blue',
                birth_year: '200BBY',
                gender: 'male',
                species: 'Wookiee',
                homeworld: 'Kashyyyk',
                imageUrl: '',
              },
              {
                name: 'Han Solo',
                height: '180',
                mass: '80',
                hair_color: 'brown',
                skin_color: 'fair',
                eye_color: 'brown',
                birth_year: '29BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Corellia',
                imageUrl: '',
              },
              {
                name: 'Lando Calrissian',
                height: '177',
                mass: '79',
                hair_color: 'black',
                skin_color: 'dark',
                eye_color: 'brown',
                birth_year: '31BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Socorro',
                imageUrl: '',
              },
              {
                name: 'Nien Nunb',
                height: '160',
                mass: '68',
                hair_color: 'none',
                skin_color: 'grey',
                eye_color: 'black',
                birth_year: 'unknown',
                gender: 'male',
                species: 'Sullustan',
                homeworld: 'Sullust',
                imageUrl: '',
              },
            ],
          },
          {
            name: 'Y-wing',
            model: 'BTL Y-wing',
            manufacturer: 'Koensayr Manufacturing',
            cost_in_credits: '134999',
            length: '14',
            max_atmosphering_speed: '1000',
            crew: '2',
            passengers: '0',
            cargo_capacity: '110',
            consumables: '1 week',
            hyperdrive_rating: '1.0',
            starship_class: 'Assault Starfighter',
            imageUrl:
              'https://lumiere-a.akamaihd.net/v1/images/Y-Wing-Fighter_0e78c9ae.jpeg?region=0%2C0%2C1536%2C864&width=960',
            pilots: 'no data',
          },
          {
            name: 'X-wing',
            model: 'T-65 X-wing',
            manufacturer: 'Incom Corporation',
            cost_in_credits: '149999',
            length: '12.5',
            max_atmosphering_speed: '1050',
            crew: '1',
            passengers: '0',
            cargo_capacity: '110',
            consumables: '1 week',
            hyperdrive_rating: '1.0',
            starship_class: 'Starfighter',
            imageUrl: 'no data',
            pilots: [
              {
                name: 'Luke Skywalker',
                height: '172',
                mass: '77',
                hair_color: 'blond',
                skin_color: 'fair',
                eye_color: 'blue',
                birth_year: '19BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Tatooine',
                imageUrl: '',
              },
              {
                name: 'Biggs Darklighter',
                height: '183',
                mass: '84',
                hair_color: 'black',
                skin_color: 'light',
                eye_color: 'brown',
                birth_year: '24BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Tatooine',
                imageUrl: '',
              },
              {
                name: 'Wedge Antilles',
                height: '170',
                mass: '77',
                hair_color: 'brown',
                skin_color: 'fair',
                eye_color: 'hazel',
                birth_year: '21BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Corellia',
                imageUrl: '',
              },
              {
                name: 'Jek Tono Porkins',
                height: '180',
                mass: '110',
                hair_color: 'brown',
                skin_color: 'fair',
                eye_color: 'blue',
                birth_year: 'unknown',
                gender: 'male',
                species: 'Human',
                homeworld: 'Bestine IV',
                imageUrl: '',
              },
            ],
          },
          {
            name: 'TIE Advanced x1',
            model: 'Twin Ion Engine Advanced x1',
            manufacturer: 'Sienar Fleet Systems',
            cost_in_credits: 'unknown',
            length: '9.2',
            max_atmosphering_speed: '1200',
            crew: '1',
            passengers: '0',
            cargo_capacity: '150',
            consumables: '5 days',
            hyperdrive_rating: '1.0',
            starship_class: 'Starfighter',
            imageUrl: 'no data',
            pilots: [
              {
                name: 'Darth Vader',
                height: '202',
                mass: '136',
                hair_color: 'none',
                skin_color: 'white',
                eye_color: 'yellow',
                birth_year: '41.9BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Tatooine',
                imageUrl: '',
              },
            ],
          },
          {
            name: 'Slave 1',
            model: 'Firespray-31-class patrol and attack',
            manufacturer: 'Kuat Systems Engineering',
            cost_in_credits: 'unknown',
            length: '21.5',
            max_atmosphering_speed: '1000',
            crew: '1',
            passengers: '6',
            cargo_capacity: '70000',
            consumables: '1 month',
            hyperdrive_rating: '3.0',
            starship_class: 'Patrol craft',
            imageUrl: 'no data',
            pilots: [
              {
                name: 'Boba Fett',
                height: '183',
                mass: '78.2',
                hair_color: 'black',
                skin_color: 'fair',
                eye_color: 'brown',
                birth_year: '31.9BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Kamino',
                imageUrl: '',
              },
            ],
          },
          {
            name: 'Imperial shuttle',
            model: 'Lambda-class T-4a shuttle',
            manufacturer: 'Sienar Fleet Systems',
            cost_in_credits: '240000',
            length: '20',
            max_atmosphering_speed: '850',
            crew: '6',
            passengers: '20',
            cargo_capacity: '80000',
            consumables: '2 months',
            hyperdrive_rating: '1.0',
            starship_class: 'Armed government transport',
            imageUrl: 'no data',
            pilots: [
              {
                name: 'Luke Skywalker',
                height: '172',
                mass: '77',
                hair_color: 'blond',
                skin_color: 'fair',
                eye_color: 'blue',
                birth_year: '19BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Tatooine',
                imageUrl: '',
              },
              {
                name: 'Chewbacca',
                height: '228',
                mass: '112',
                hair_color: 'brown',
                skin_color: 'unknown',
                eye_color: 'blue',
                birth_year: '200BBY',
                gender: 'male',
                species: 'Wookiee',
                homeworld: 'Kashyyyk',
                imageUrl: '',
              },
              {
                name: 'Han Solo',
                height: '180',
                mass: '80',
                hair_color: 'brown',
                skin_color: 'fair',
                eye_color: 'brown',
                birth_year: '29BBY',
                gender: 'male',
                species: 'Human',
                homeworld: 'Corellia',
                imageUrl: '',
              },
            ],
          },
          {
            name: 'EF76 Nebulon-B escort frigate',
            model: 'EF76 Nebulon-B escort frigate',
            manufacturer: 'Kuat Drive Yards',
            cost_in_credits: '8500000',
            length: '300',
            max_atmosphering_speed: '800',
            crew: '854',
            passengers: '75',
            cargo_capacity: '6000000',
            consumables: '2 years',
            hyperdrive_rating: '2.0',
            starship_class: 'Escort ship',
            imageUrl: 'no data',
            pilots: [],
          },
        ]);
      });
  };
  
  //************** */
  