CREATE TABLE memberships (
    id CHAR(36) NOT NULL PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    membershipType VARCHAR(100) NOT NULL,
    discount DECIMAL(5,2) DEFAULT 0,
    galleries JSON,
    facility JSON,
    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        ON UPDATE CURRENT_TIMESTAMP
);
INSERT INTO memberships
(
    id,
    title,
    description,
    membershipType,
    discount,
    galleries,
    facility
)
VALUES
(
    UUID(),
    'Lifetime Membership',
    'Lifetime membership benefit',
    'Lifetime',
    10,
    JSON_ARRAY(),
    JSON_ARRAY()
),
(
    UUID(),
    'Part-Time Membership',
    'Part-time membership benefit',
    'Part-Time',
    5,
    JSON_ARRAY(),
    JSON_ARRAY()
);

-- add Membership api body

{
  "title": "Lifetime Membership",
  "description": "Lifetime membership with all benefits",
  "membershipType": "Lifetime",
  "discount": 10,
  "galleries": [
    "94e99f63-5742-49bd-876c-e6f03dc016d3"
  ],
  "facility": [
    "Gym",
    "Swimming Pool",
    "Library"
  ]
}