<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;

class OrderItemsTableSeeder extends Seeder
{

    /**
     * Auto generated seed file
     *
     * @return void
     */
    public function run()
    {
        \DB::table('order_items')->delete();

        \DB::table('order_items')->insert(array(
            0 =>
                array(
                    'id' => 1,
                    'order_id' => 1,
                    'item_id' => 10,
                    'bundle_id' => NULL,
                    'prescription_item_id' => NULL,
                    'has_requested_subscription' => 0,
                    'assessment_id' => 0,
                    'item_name' => 'Sildenafil Tablets (Generic Viagra)',
                    'item_price' => 3.0,
                    'item_price_exvat' => 2.5,
                    'quantity' => 1,
                    'recommended_quantity' => 1,
                    'size' => '4 Pack',
                    'PLU' => '',
                    'tosend' => 0,
                    'reminder_date' => '0000-00-00 00:00:00',
                    'sent' => '0000-00-00 00:00:00',
                    'refund_amount' => '',
                    'discount' => 0.0,
                    'sizeid' => 9,
                    'nhs_prescription' => 0,
                    'timestamp' => '2025-06-30 09:17:23',
                    'sale_item' => 0.0,
                    'vat_deductable' => 0,
                    'price_paid' => 3.0,
                    'price_paid_exvat' => 2.5,
                    'approved' => 0,
                    'clinic_checked' => 0,
                    'pharmacy_label_text' => NULL,
                ),
        ));


    }
}