7 lines
465 B
SQL
7 lines
465 B
SQL
-- ⑤ 砧木字典扩列：矮化类 + 砧穗亲和性（选配决策信息）
|
||
-- 幂等：可重复执行（ADD COLUMN IF NOT EXISTS）
|
||
ALTER TABLE bre_rootstock ADD COLUMN IF NOT EXISTS dwarf_class varchar(32);
|
||
ALTER TABLE bre_rootstock ADD COLUMN IF NOT EXISTS compatibility varchar(16);
|
||
COMMENT ON COLUMN bre_rootstock.dwarf_class IS '矮化类(矮化/半矮化/乔化/柱状)';
|
||
COMMENT ON COLUMN bre_rootstock.compatibility IS '砧穗亲和性(强/中/弱)';
|