process_sheet/fastadmin/application/sql/ps_biz_import_run.php

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

function addColumn($table, $column, $ddl)
{
    $prefix = \think\Db::getConfig('prefix');
    $full = $prefix . $table;
    $rows = \think\Db::query('SHOW COLUMNS FROM `' . $full . '` LIKE \'' . addslashes($column) . '\'');
    if ($rows) {
        echo $full . '.' . $column . " exists\n";
        return;
    }
    \think\Db::execute('ALTER TABLE `' . $full . '` ' . $ddl);
    echo $full . '.' . $column . " added\n";
}

addColumn('ps_factory', 'api_key_hash', "ADD COLUMN `api_key_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'Open API Key SHA256' AFTER `owner_user_id`");
addColumn('ps_factory', 'api_key_prefix', "ADD COLUMN `api_key_prefix` varchar(16) NOT NULL DEFAULT '' COMMENT 'Key 前缀展示' AFTER `api_key_hash`");
addColumn('ps_factory', 'api_key_time', "ADD COLUMN `api_key_time` bigint(16) DEFAULT NULL COMMENT 'Key 生成时间' AFTER `api_key_prefix`");
addColumn('ps_product_process', 'code', "ADD COLUMN `code` varchar(64) NOT NULL DEFAULT '' COMMENT '工艺编号' AFTER `seq`");
addColumn('ps_workorder_process', 'code', "ADD COLUMN `code` varchar(64) NOT NULL DEFAULT '' COMMENT '工艺编号' AFTER `seq`");