-- create a table for blood bank 

CREATE TABLE blood_banks (
    id CHAR(36) PRIMARY KEY,
    bloodGroupId CHAR(36) NOT NULL,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    location VARCHAR(255),
    contactNo VARCHAR(50),
    galleries JSON,
    sorting INT DEFAULT 0,
    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);