CREATE TABLE IF NOT EXISTS wp_luman_plus_login_patterns (
    id BIGINT(20) NOT NULL AUTO_INCREMENT,
    name VARCHAR(128) DEFAULT NULL,
    title VARCHAR(255) DEFAULT NULL,
    pattern VARCHAR(255) NOT NULL,
    service VARCHAR(128) NOT NULL DEFAULT '',
    variables TEXT DEFAULT NULL,
    status ENUM('Active','Deactive') DEFAULT 'Active',
    created_at DATETIME DEFAULT current_timestamp(),
    updated_at DATETIME DEFAULT NULL ON UPDATE current_timestamp(),
    PRIMARY KEY (id),
    UNIQUE KEY pattern (pattern)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO wp_luman_plus_login_patterns (name, title, pattern, service, variables, status, created_at)
VALUES
    ('faraz_otp_code', 'پترن کد ورود فراز اسمس', '7duic3llh7sovjz', 'FarazSms', '[]', 'Active', NOW()),
    ('melli_otp_code', 'پترن کد ورود ملی پیامک', '338293', 'MelliPayamak', '[]', 'Active', NOW()),
    ('kaveh_otp_code', 'پترن کد ورود کاوه نگار', 'VerificationLogin', 'KavehNegar', '[]', 'Active', NOW());

CREATE TABLE IF NOT EXISTS wp_luman_plus_login_settings (
                                                            id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                                                            meta_key TEXT NOT NULL,
                                                            meta_value LONGTEXT,
                                                            UNIQUE KEY unique_meta_key (meta_key(191))
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS wp_luman_plus_login_notification_history (
                                                                        id INT AUTO_INCREMENT PRIMARY KEY,
                                                                        driver ENUM('SMS', 'Email') DEFAULT 'SMS',
    message VARCHAR(255) NOT NULL,
    service VARCHAR(100) NOT NULL,
    identifier VARCHAR(255) NOT NULL,
    meta LONGTEXT DEFAULT NULL,
    status ENUM('Fail', 'Success') DEFAULT 'Fail',
    expired_at DATETIME DEFAULT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;