<?php
$root = dirname(dirname(__DIR__));
define('APP_PATH', $root . '/application/');
require $root . '/thinkphp/base.php';
\think\App::initCommon();

$prefix = \think\Db::getConfig('prefix');
$table = $prefix . 'ps_workorder';
$rows = \think\Db::query("SHOW COLUMNS FROM `{$table}` LIKE 'spec'");
if ($rows) {
    echo $table . ".spec exists\n";
} else {
    \think\Db::execute("ALTER TABLE `{$table}` ADD COLUMN `spec` varchar(100) NOT NULL DEFAULT '' COMMENT '规格，可不关联产品档案' AFTER `product_name`");
    echo $table . ".spec added\n";
}

$updated = \think\Db::execute(
    "UPDATE `{$table}` w LEFT JOIN `{$prefix}ps_product` p ON p.id = w.product_id SET w.spec = IFNULL(p.spec, '') WHERE w.spec = '' AND w.product_id > 0"
);
echo "backfilled {$updated} rows\n";