-- Drop the existing table if it exists
DROP TABLE IF EXISTS businesses;

-- Create the new businesses table
CREATE TABLE businesses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    business_name VARCHAR(255) NOT NULL,
    framework_job_name VARCHAR(255) NOT NULL,
    initial_business_value DECIMAL(10, 2) NOT NULL,
    postal_location VARCHAR(255) NOT NULL,
    business_type VARCHAR(255) NOT NULL,
    developer VARCHAR(255) NOT NULL,
    date_of_establishment DATE NOT NULL
);

-- Example data insertion (optional)
INSERT INTO businesses (business_name, framework_job_name, initial_business_value, postal_location, business_type, developer, date_of_establishment) 
VALUES 
('Example Business', 'example_job', 100000.00, '1234 Example St', 'Entertainment', 'John Doe', '2024-06-15');
