CREATE TABLE `roles` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `name` VARCHAR(20) NOT NULL,
    `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `roles`(`name`) VALUES ('Administrator');

-- admin, manager, clent, service_provider

-- roles: admin, manager, writer, client, service
INSERT INTO `roles` (`name`) VALUES 
('Admin'),
('Manager'),
('Writer'),
('Client'),
('Service');

-- stub response
/*
{
  "status": "success",
  "data": {
    "items": [
      {
        "id": 1,
        "name": "admin",
        "created_at": "2025-09-10T10:00:00Z",
        "updated_at": "2025-09-10T10:00:00Z"
      },
      {
        "id": 2,
        "name": "manager",
        "created_at": "2025-09-10T10:00:00Z",
        "updated_at": "2025-09-10T10:00:00Z"
      },
      {
        "id": 3,
        "name": "writer",
        "created_at": "2025-09-10T10:00:00Z",
        "updated_at": "2025-09-10T10:00:00Z"
      }
    ],
    "pagination": {
      "total": 5,
      "page": 1,
      "limit": 3,
      "hasMore": true
    }
  }
}
*/