forked from Gitlink/microservices
15 lines
486 B
SQL
15 lines
486 B
SQL
INSERT INTO `ruoyi-gitlink`.zone_partners_type (name, sort, dept_id, del_flag, create_by, create_time, update_by,
|
|
update_time, zone_id)
|
|
SELECT '默认分类',
|
|
1,
|
|
zd.dept_id,
|
|
0,
|
|
'',
|
|
now(),
|
|
'',
|
|
now(),
|
|
zd.id
|
|
FROM `ruoyi-gitlink`.zone_detail zd
|
|
WHERE NOT EXISTS(
|
|
SELECT 1 FROM `ruoyi-gitlink`.zone_partners_type zpt WHERE zpt.name = '默认分类' AND zpt.zone_id = zd.id
|
|
); |