-- Insert payment token
INSERT INTO payment_tokens (address, name, symbol, decimals, added_at, added_tx)
VALUES ('0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772', 'Tether USD', 'USDT', 6, 0, '');

-- Insert wine
INSERT INTO wines (id, winery, name, year, image_name, origin)
VALUES (1, 'Château Margaux', 'Grand Vin', 2015, 'margaux_2015.jpg',
        ARRAY['France', 'Bordeaux', 'Margaux']);

-- Insert wine details
INSERT INTO wine_details (wine_id, description, color, size, classification, blend, sweetness, alcohol)
VALUES (1,
        'A remarkable vintage showcasing the epitome of Margaux''s terroir with exceptional balance and complexity.',
        'red',
        '0.75',
        'Premier Cru',
        ARRAY['Cabernet Sauvignon', 'Merlot', 'Petit Verdot', 'Cabernet Franc'],
        'dry',
        13.5);

-- Insert wine analytics
INSERT INTO wine_analytics (wine_id, critic_score, avarage_retail_price)
VALUES (1, 98, 850.00);

-- Insert collection
INSERT INTO collections (id, address, creator, owner, name, whitelisted)
VALUES (1,
        '0x1234567890123456789012345678901234567890',
        '0x2234567890123456789012345678901234567890',
        '0x3234567890123456789012345678901234567890',
        'Premium Bordeaux Collection',
        true);

-- Insert tokens for the wine
INSERT INTO tokens (id, collection_id, wine_id, creator, owner, minted_at, minted_tx, burned)
VALUES
    (1, 1, 1,
     '0x2234567890123456789012345678901234567890',
     '0x4234567890123456789012345678901234567890',
     1699891200,
     '0xabcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234',
     false),
    (2, 1, 1,
     '0x2234567890123456789012345678901234567890',
     '0x5234567890123456789012345678901234567890',
     1699891200,
     '0xefef5678efef5678efef5678efef5678efef5678efef5678efef5678efef5678',
     false),
    (3, 1, 1,
     '0x2234567890123456789012345678901234567890',
     '0x5234567890123456789012345678901234567890',
     1699891200,
     '0xefef5678efef5678efef5678efef5678efef5678efef5678efef5678efef5678',
     true); -- Burned

-- Insert token metadata
INSERT INTO token_metadata (token_id, collection_id, meta_uri)
VALUES
    (1, 1, 'ipfs://QmAbC123...1'),
    (2, 1, 'ipfs://QmAbC123...2'),
    (3, 1, 'ipfs://QmAbC123...2');

-- Insert orders for first token
INSERT INTO orders (id, seller, buyer, collection_id, token_id, price, payment_token, duration, expire_at)
VALUES
    (1,
     '0x4234567890123456789012345678901234567890',
     '0x6234567890123456789012345678901234567890',
     1, 1, 900.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1700496000),
    (2,
     '0x4234567890123456789012345678901234567890',
     NULL,
     1, 1, 950.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701100800), -- November 27, 2024
    (3,
     '0x4234567890123456789012345678901234567890',
     NULL,
     1, 1, 1000.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701705600); -- December 4, 2024

INSERT INTO order_statuses (order_id, state, timestamp)
VALUES
    (1, 1, 1699891200), -- Created
    (1, 3, 1699977600), -- Confirmed
    (1, 7, 1699891200), -- Fulfilled

    (2, 1, 1699977600), -- Created
    (2, 3, 1700064000), -- Confirmed

    (3, 1, 1700150400); -- Created

-- Insert orders for second token
INSERT INTO orders (id, seller, buyer, collection_id, token_id, price, payment_token, duration, expire_at)
VALUES
    (4,
     '0x5234567890123456789012345678901234567890',
     '0x7234567890123456789012345678901234567890',
     1, 2, 880.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1700496000),
    (5,
     '0x5234567890123456789012345678901234567890',
     NULL,
     1, 2, 920.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701100800),
    (6,
     '0x5234567890123456789012345678901234567890',
     NULL,
     1, 2, 975.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701705600);

INSERT INTO order_statuses (order_id, state, timestamp)
VALUES
    (4, 1, 1699891200), -- Created
    (4, 3, 1699977600), -- Confirmed
    (4, 7, 1699891200), -- Fulfilled

    (5, 1, 1699977600), -- Created
    (5, 3, 1700064000), -- Confirmed

    (6, 1, 1700150400); -- Created

-- Insert orders for third(burned) token
INSERT INTO orders (id, seller, buyer, collection_id, token_id, price, payment_token, duration, expire_at)
VALUES
    (7,
     '0x5234567890123456789012345678901234567890',
     NULL,
     1, 3, 69.00,
     '0xbcf39d8616d15fd146dd5db4a86b4f244a9bc772',
     604800,
     1701705600);

INSERT INTO order_statuses (order_id, state, timestamp)
VALUES
    (7, 1, 1699977600), -- Created
    (7, 3, 1700064000); -- Confirmed