CREATE TABLE IF NOT EXISTS `badges` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL UNIQUE,
    `description` TEXT,
    `icon` TEXT,
    `condition` VARCHAR(255) NOT NULL COMMENT 'Ex: checkins_count >= 10',
    `createdAt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

    PRIMARY KEY (id)
);