-- Create the paidandleft table
CREATE TABLE paidandleft (
    id INT AUTO_INCREMENT PRIMARY KEY, -- Unique identifier for each record
    date_of_submission DATE NOT NULL, -- Date of form submission
    number_of_items INT NOT NULL, -- Number of items left
    number_of_bags INT NOT NULL, -- Number of bags left
    item_dpcis TEXT NOT NULL, -- Item DPCI's (stored as a comma-separated string)
    found_location VARCHAR(255) NOT NULL, -- Location where items were found
    found_by VARCHAR(255) NOT NULL -- Person who found the items
);

-- Add an example entry to test the table
INSERT INTO paidandleft (date_of_submission, number_of_items, number_of_bags, item_dpcis, found_location, found_by)
VALUES ('2024-11-15', 3, 2, '123456, 234567, 345678', 'Register 5', 'John Doe');
