CREATE DATABASE IF NOT EXISTS whatsapp_panel
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE whatsapp_panel;

CREATE TABLE IF NOT EXISTS whatsapp_numbers (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    phone VARCHAR(30) NOT NULL,
    verification_code VARCHAR(20) DEFAULT NULL,
    status ENUM('pending','verified','connected','disconnected')
        NOT NULL DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_phone (phone),
    INDEX idx_status (status)
);