<?php

class Migration_20250910231815_create_cellular_sims
{
    public static function up(PDO $pdo)
    {
        // Create the table with the specified columns
        $sql = "
            CREATE TABLE IF NOT EXISTS `cellular_sims` (
                `id` INT AUTO_INCREMENT PRIMARY KEY,
                `property_id` INT DEFAULT NULL,
                `user_id` INT NOT NULL,
                `qty` VARCHAR(255) NOT NULL,
                `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
            )
        ";
        $pdo->exec($sql);
    }

    public static function down(PDO $pdo)
    {
        // Drop the table if it exists
        $sql = "
            DROP TABLE IF EXISTS `cellular_sims`
        ";
        $pdo->exec($sql);
    }
}
