CREATE TABLE IF NOT EXISTS institutions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    website VARCHAR(255),
    address TEXT,
    contact_email VARCHAR(255),
    contact_phone VARCHAR(255),
    description TEXT,
    logo_url VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO institutions (name, website, description) VALUES
('Global Tech University', 'https://globaltech.edu', 'A leading university in technology and innovation.'),
('National Arts College', 'https://nac.edu', 'A premier institution for the arts and humanities.'),
('City Business School', 'https://cbs.edu', 'Fostering the next generation of business leaders.');