Dromara Orion Visor

Appearance

v2.3.4 ​

sql 脚本 - DML1 - 修改表创建人和修改人字段 (可以不执行) ​

sql
UPDATE command_snippet cs
LEFT JOIN system_user su_creator ON cs.creator = su_creator.id
LEFT JOIN system_user su_updater ON cs.updater = su_updater.id
SET 
    cs.creator = COALESCE(su_creator.username, cs.creator),
    cs.updater = COALESCE(su_updater.username, cs.updater),
    cs.update_time = cs.update_time;

UPDATE data_extra de
LEFT JOIN system_user su_creator ON de.creator = su_creator.id
LEFT JOIN system_user su_updater ON de.updater = su_updater.id
SET 
    de.creator = COALESCE(su_creator.username, de.creator),
    de.updater = COALESCE(su_updater.username, de.updater),
    de.update_time = de.update_time;

UPDATE data_group dg
LEFT JOIN system_user su_creator ON dg.creator = su_creator.id
LEFT JOIN system_user su_updater ON dg.updater = su_updater.id
SET 
    dg.creator = COALESCE(su_creator.username, dg.creator),
    dg.updater = COALESCE(su_updater.username, dg.updater),
    dg.update_time = dg.update_time;

UPDATE data_group_rel dgr
LEFT JOIN system_user su_creator ON dgr.creator = su_creator.id
LEFT JOIN system_user su_updater ON dgr.updater = su_updater.id
SET 
    dgr.creator = COALESCE(su_creator.username, dgr.creator),
    dgr.updater = COALESCE(su_updater.username, dgr.updater),
    dgr.update_time = dgr.update_time;

UPDATE data_permission dp
LEFT JOIN system_user su_creator ON dp.creator = su_creator.id
LEFT JOIN system_user su_updater ON dp.updater = su_updater.id
SET 
    dp.creator = COALESCE(su_creator.username, dp.creator),
    dp.updater = COALESCE(su_updater.username, dp.updater),
    dp.update_time = dp.update_time;

UPDATE dict_key dk
LEFT JOIN system_user su_creator ON dk.creator = su_creator.id
LEFT JOIN system_user su_updater ON dk.updater = su_updater.id
SET 
    dk.creator = COALESCE(su_creator.username, dk.creator),
    dk.updater = COALESCE(su_updater.username, dk.updater),
    dk.update_time = dk.update_time;

UPDATE dict_value dv
LEFT JOIN system_user su_creator ON dv.creator = su_creator.id
LEFT JOIN system_user su_updater ON dv.updater = su_updater.id
SET 
    dv.creator = COALESCE(su_creator.username, dv.creator),
    dv.updater = COALESCE(su_updater.username, dv.updater),
    dv.update_time = dv.update_time;
	
UPDATE exec_job ej
LEFT JOIN system_user su_creator ON ej.creator = su_creator.id
LEFT JOIN system_user su_updater ON ej.updater = su_updater.id
SET 
    ej.creator = COALESCE(su_creator.username, ej.creator),
    ej.updater = COALESCE(su_updater.username, ej.updater),
    ej.update_time = ej.update_time;

UPDATE exec_job_host ejh
LEFT JOIN system_user su_creator ON ejh.creator = su_creator.id
LEFT JOIN system_user su_updater ON ejh.updater = su_updater.id
SET 
    ejh.creator = COALESCE(su_creator.username, ejh.creator),
    ejh.updater = COALESCE(su_updater.username, ejh.updater),
    ejh.update_time = ejh.update_time;

UPDATE exec_template et
LEFT JOIN system_user su_creator ON et.creator = su_creator.id
LEFT JOIN system_user su_updater ON et.updater = su_updater.id
SET 
    et.creator = COALESCE(su_creator.username, et.creator),
    et.updater = COALESCE(su_updater.username, et.updater),
    et.update_time = et.update_time;

UPDATE exec_template_host eth
LEFT JOIN system_user su_creator ON eth.creator = su_creator.id
LEFT JOIN system_user su_updater ON eth.updater = su_updater.id
SET 
    eth.creator = COALESCE(su_creator.username, eth.creator),
    eth.updater = COALESCE(su_updater.username, eth.updater),
    eth.update_time = eth.update_time;

UPDATE favorite f
LEFT JOIN system_user su_creator ON f.creator = su_creator.id
LEFT JOIN system_user su_updater ON f.updater = su_updater.id
SET 
    f.creator = COALESCE(su_creator.username, f.creator),
    f.updater = COALESCE(su_updater.username, f.updater),
    f.update_time = f.update_time;

UPDATE history_value hv
LEFT JOIN system_user su_creator ON hv.creator = su_creator.id
SET 
    hv.creator = COALESCE(su_creator.username, hv.creator);
		
UPDATE host h
LEFT JOIN system_user su_creator ON h.creator = su_creator.id
LEFT JOIN system_user su_updater ON h.updater = su_updater.id
SET 
    h.creator = COALESCE(su_creator.username, h.creator),
    h.updater = COALESCE(su_updater.username, h.updater),
    h.update_time = h.update_time;

UPDATE host_identity hi
LEFT JOIN system_user su_creator ON hi.creator = su_creator.id
LEFT JOIN system_user su_updater ON hi.updater = su_updater.id
SET 
    hi.creator = COALESCE(su_creator.username, hi.creator),
    hi.updater = COALESCE(su_updater.username, hi.updater),
    hi.update_time = hi.update_time;

UPDATE host_key hk
LEFT JOIN system_user su_creator ON hk.creator = su_creator.id
LEFT JOIN system_user su_updater ON hk.updater = su_updater.id
SET 
    hk.creator = COALESCE(su_creator.username, hk.creator),
    hk.updater = COALESCE(su_updater.username, hk.updater),
    hk.update_time = hk.update_time;

UPDATE path_bookmark pb
LEFT JOIN system_user su_creator ON pb.creator = su_creator.id
LEFT JOIN system_user su_updater ON pb.updater = su_updater.id
SET 
    pb.creator = COALESCE(su_creator.username, pb.creator),
    pb.updater = COALESCE(su_updater.username, pb.updater),
    pb.update_time = pb.update_time;

UPDATE preference p
LEFT JOIN system_user su_creator ON p.creator = su_creator.id
LEFT JOIN system_user su_updater ON p.updater = su_updater.id
SET 
    p.creator = COALESCE(su_creator.username, p.creator),
    p.updater = COALESCE(su_updater.username, p.updater),
    p.update_time = p.update_time;

UPDATE system_menu sm
LEFT JOIN system_user su_creator ON sm.creator = su_creator.id
LEFT JOIN system_user su_updater ON sm.updater = su_updater.id
SET 
    sm.creator = COALESCE(su_creator.username, sm.creator),
    sm.updater = COALESCE(su_updater.username, sm.updater),
    sm.update_time = sm.update_time;

UPDATE system_role sr
LEFT JOIN system_user su_creator ON sr.creator = su_creator.id
LEFT JOIN system_user su_updater ON sr.updater = su_updater.id
SET 
    sr.creator = COALESCE(su_creator.username, sr.creator),
    sr.updater = COALESCE(su_updater.username, sr.updater),
    sr.update_time = sr.update_time;

UPDATE system_role_menu srm
LEFT JOIN system_user su_creator ON srm.creator = su_creator.id
LEFT JOIN system_user su_updater ON srm.updater = su_updater.id
SET 
    srm.creator = COALESCE(su_creator.username, srm.creator),
    srm.updater = COALESCE(su_updater.username, srm.updater),
    srm.update_time = srm.update_time;

UPDATE system_setting ss
LEFT JOIN system_user su_creator ON ss.creator = su_creator.id
LEFT JOIN system_user su_updater ON ss.updater = su_updater.id
SET 
    ss.creator = COALESCE(su_creator.username, ss.creator),
    ss.updater = COALESCE(su_updater.username, ss.updater),
    ss.update_time = ss.update_time;

UPDATE system_user su1
LEFT JOIN system_user su2_creator ON su1.creator = su2_creator.id
LEFT JOIN system_user su2_updater ON su1.updater = su2_updater.id
SET 
    su1.creator = COALESCE(su2_creator.username, su1.creator),
    su1.updater = COALESCE(su2_updater.username, su1.updater),
    su1.update_time = su1.update_time;

UPDATE system_user_role sur
LEFT JOIN system_user su_creator ON sur.creator = su_creator.id
LEFT JOIN system_user su_updater ON sur.updater = su_updater.id
SET 
    sur.creator = COALESCE(su_creator.username, sur.creator),
    sur.updater = COALESCE(su_updater.username, sur.updater),
    sur.update_time = sur.update_time;

UPDATE tag t
LEFT JOIN system_user su_creator ON t.creator = su_creator.id
LEFT JOIN system_user su_updater ON t.updater = su_updater.id
SET 
    t.creator = COALESCE(su_creator.username, t.creator),
    t.updater = COALESCE(su_updater.username, t.updater),
    t.update_time = t.update_time;

UPDATE tag_rel tr
LEFT JOIN system_user su_creator ON tr.creator = su_creator.id
LEFT JOIN system_user su_updater ON tr.updater = su_updater.id
SET 
    tr.creator = COALESCE(su_creator.username, tr.creator),
    tr.updater = COALESCE(su_updater.username, tr.updater),
    tr.update_time = tr.update_time;

sql 脚本 - DML2 - 修改日志表创建人和修改人字段 (可以不执行) ​

sql
UPDATE exec_host_log ehl
LEFT JOIN system_user su_creator ON ehl.creator = su_creator.id
LEFT JOIN system_user su_updater ON ehl.updater = su_updater.id
SET 
    ehl.creator = COALESCE(su_creator.username, ehl.creator),
    ehl.updater = COALESCE(su_updater.username, ehl.updater),
    ehl.update_time = ehl.update_time;

UPDATE exec_log el
LEFT JOIN system_user su_creator ON el.creator = su_creator.id
LEFT JOIN system_user su_updater ON el.updater = su_updater.id
SET 
    el.creator = COALESCE(su_creator.username, el.creator),
    el.updater = COALESCE(su_updater.username, el.updater),
    el.update_time = el.update_time;

UPDATE upload_task ut
LEFT JOIN system_user su_creator ON ut.creator = su_creator.id
LEFT JOIN system_user su_updater ON ut.updater = su_updater.id
SET 
    ut.creator = COALESCE(su_creator.username, ut.creator),
    ut.updater = COALESCE(su_updater.username, ut.updater),
    ut.update_time = ut.update_time;

UPDATE upload_task_file utf
LEFT JOIN system_user su_creator ON utf.creator = su_creator.id
LEFT JOIN system_user su_updater ON utf.updater = su_updater.id
SET 
    utf.creator = COALESCE(su_creator.username, utf.creator),
    utf.updater = COALESCE(su_updater.username, utf.updater),
    utf.update_time = utf.update_time;

sql 脚本 - DML3 ​

sql
-- 添加字典值
INSERT INTO `dict_value`(`id`, `key_id`, `key_name`, `value`, `label`, `extra`, `sort`, `create_time`, `update_time`, `creator`, `updater`, `deleted`) 
VALUES (443, 21, 'terminalFontFamily', 'Cascadia Mono', 'Cascadia Mono', '{}', 50, '2023-12-11 16:48:03', '2024-05-15 15:26:42', 'admin', 'admin', 0);

最后更新: