7 lines
416 B
SQL
7 lines
416 B
SQL
-- 补充 material_verify_log 表缺失的 SQLBaseDO 列
|
|
ALTER TABLE material_verify_log
|
|
ADD COLUMN IF NOT EXISTS creator VARCHAR(100) DEFAULT '' NOT NULL,
|
|
ADD COLUMN IF NOT EXISTS updater VARCHAR(100) DEFAULT '' NOT NULL,
|
|
ADD COLUMN IF NOT EXISTS updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
|
|
ADD COLUMN IF NOT EXISTS deleted_at TIMESTAMP WITH TIME ZONE DEFAULT NULL;
|