CREATE TABLE IF NOT EXISTS clients (
    slug VARCHAR(42) CHARACTER SET ascii COLLATE ascii_bin NOT NULL PRIMARY KEY,
    name VARCHAR(80) NOT NULL,
    bio VARCHAR(180) NOT NULL,
    instagram TEXT NOT NULL,
    whatsapp TEXT NOT NULL,
    google TEXT NOT NULL,
    color CHAR(7) NOT NULL,
    logo MEDIUMBLOB NULL,
    logo_type VARCHAR(16) NULL,
    active TINYINT UNSIGNED NOT NULL,
    updated_at DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS login_limits (
    address CHAR(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL PRIMARY KEY,
    attempts INT UNSIGNED NOT NULL,
    reset_at INT UNSIGNED NOT NULL,
    INDEX (reset_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
