process_sheet/fastadmin/application/sql/ps_template_paper_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_template', 'paper_size', "ADD COLUMN `paper_size` varchar(20) NOT NULL DEFAULT 'A4' COMMENT 'A4/A5/custom' AFTER `cover`");
addColumn('ps_template', 'page_w', "ADD COLUMN `page_w` decimal(8,2) NOT NULL DEFAULT '210.00' COMMENT '纸宽毫米' AFTER `paper_size`");
addColumn('ps_template', 'page_h', "ADD COLUMN `page_h` decimal(8,2) NOT NULL DEFAULT '297.00' COMMENT '纸高毫米' AFTER `page_w`");
addColumn('ps_template', 'mark_cover', "ADD COLUMN `mark_cover` varchar(255) NOT NULL DEFAULT '' COMMENT '色块标注图' AFTER `page_h`");