'use strict';

module.exports = {
  up: async (queryInterface) => {
    const opportunities = [
      {
        id: '10000000-0000-0000-0000-000000000001',
        name: 'Sequoia Capital',
        focus: 'Enterprise, AI, Consumer',
        stage: 'Seed to IPO',
        contact_type: 'VC',
        description: 'Global venture capital firm helping daring founders build legendary companies.',
        website: 'https://www.sequoiacap.com',
        amount_min: 500000,
        amount_max: 100000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000002',
        name: 'Andreessen Horowitz (a16z)',
        focus: 'Fintech, Crypto, AI, Games',
        stage: 'All stages',
        contact_type: 'VC',
        description: 'Venture capital firm that backs bold entrepreneurs building the future through technology.',
        website: 'https://a16z.com',
        amount_min: 1000000,
        amount_max: 500000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000003',
        name: 'Index Ventures',
        focus: 'Global SaaS, Commerce',
        stage: 'Early to Growth',
        contact_type: 'VC',
        description: 'Partnering with exceptional entrepreneurs from seed to IPO.',
        website: 'https://www.indexventures.com',
        amount_min: 2000000,
        amount_max: 50000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000004',
        name: 'Naval Ravikant',
        focus: 'Deep Tech, AI, Crypto',
        stage: 'Seed',
        contact_type: 'Angel',
        description: 'Founding CEO of AngelList, investor in 200+ companies including Uber, Twitter, and Wish.',
        website: 'https://twitter.com/naval',
        amount_min: 50000,
        amount_max: 500000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000005',
        name: 'Tiger Global',
        focus: 'Hyper-growth, Consumer, SaaS',
        stage: 'Growth',
        contact_type: 'Institutional',
        description: 'Investment firm focused on public and private companies in the global Internet, software, consumer, and financial technology industries.',
        website: 'https://www.tigerglobal.com',
        amount_min: 10000000,
        amount_max: 1000000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000006',
        name: 'Goldman Sachs Principal',
        focus: 'Late Stage, Fintech, Infrastructure',
        stage: 'Pre-IPO',
        contact_type: 'Bank/Institutional',
        description: 'Principal investment arm of Goldman Sachs.',
        website: 'https://www.goldmansachs.com',
        amount_min: 50000000,
        amount_max: 500000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000007',
        name: 'First Round Capital',
        focus: 'Tech, SaaS, Mobile',
        stage: 'Seed',
        contact_type: 'VC',
        description: 'Seed-stage venture capital firm focused on building community.',
        website: 'https://firstround.com',
        amount_min: 250000,
        amount_max: 2000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000008',
        name: 'SV Angel',
        focus: 'Consumer, Enterprise',
        stage: 'Seed',
        contact_type: 'Angel Group',
        description: 'Early-stage venture capital firm based in San Francisco.',
        website: 'https://svangel.com',
        amount_min: 50000,
        amount_max: 1000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000009',
        name: 'Benchmark',
        focus: 'Consumer, Mobile, SaaS',
        stage: 'Early',
        contact_type: 'VC',
        description: 'Venture capital firm that focuses on early-stage startups.',
        website: 'https://www.benchmark.com',
        amount_min: 1000000,
        amount_max: 20000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      },
      {
        id: '10000000-0000-0000-0000-000000000010',
        name: 'General Catalyst',
        focus: 'Fintech, Healthcare, AI',
        stage: 'Seed to Growth',
        contact_type: 'VC',
        description: 'Venture capital firm that invests in powerful, positive change.',
        website: 'https://www.generalcatalyst.com',
        amount_min: 1000000,
        amount_max: 100000000,
        createdAt: new Date(),
        updatedAt: new Date(),
      }
    ];

    await queryInterface.bulkInsert('funding_opportunities', opportunities, {});
  },

  down: async (queryInterface) => {
    await queryInterface.bulkDelete('funding_opportunities', null, {});
  }
};