<?php
require_once __DIR__ . '/include/con_data.php';
try {
    $pdo->exec("ALTER TABLE shops ADD COLUMN price_level TINYINT(1) NOT NULL DEFAULT 1");
    echo "Success: added price_level column to shops table.\n";
} catch (PDOException $e) {
    if ($e->getCode() == '42S21') {
        echo "Success: column already exists.\n";
    } else {
        echo "Error: " . $e->getMessage() . "\n";
    }
}
