-- 驾驶舱数据管理
-- delete from base.sys_menu where menu_id=3000;
-- delete from base.sys_menu where menu_id=3001;
-- delete from base.sys_menu where menu_id=3002;
-- delete from base.sys_menu where menu_id=3003;
-- delete from base.sys_menu where menu_id=3004;
-- delete from base.sys_menu where menu_id=3005;

-- 菜单 SQL
insert into base.sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(3000,'驾驶舱数据管理', '1065', '9', 'sql', 'system/jsc/data/index', 1, 0, 'C', '0', '0', 'system:jsc:data:list', 'edit', 'admin', now(), '', null, '驾驶舱数据管理菜单');

-- 按钮 SQL
insert into base.sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(3001,'数据查询', 3000, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:query',        '#', 'admin', now(), '', null, '');

insert into base.sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(3002,'数据新增', 3000, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:add',          '#', 'admin', now(), '', null, '');

insert into base.sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(3003,'数据修改', 3000, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:edit',         '#', 'admin', now(), '', null, '');

insert into base.sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(3004,'数据删除', 3000, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:remove',       '#', 'admin', now(), '', null, '');

insert into base.sys_menu (menu_id,menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(3005,'数据导出', 3000, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:export',       '#', 'admin', now(), '', null, '');

-- 土地卫片执法遥感监测分类表
-- delete from base.business_dic where "type"='土地卫片执法遥感监测分类表';
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增线性地物','11', '土地卫片执法遥感监测分类表', '新增线性地物', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增公路','111', '土地卫片执法遥感监测分类表', '新增公路', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增铁路','112', '土地卫片执法遥感监测分类表', '新增铁路', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增建（构）筑物','12', '土地卫片执法遥感监测分类表', '新增建（构）筑物', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增建筑物','121', '土地卫片执法遥感监测分类表', '新增建筑物', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增构筑物','122', '土地卫片执法遥感监测分类表', '新增构筑物', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增高尔夫运动用地','13', '土地卫片执法遥感监测分类表', '新增高尔夫运动用地', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增推堆土','21', '土地卫片执法遥感监测分类表', '新增推堆土', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增其他道路','22', '土地卫片执法遥感监测分类表', '新增其他道路', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增点状地物','23', '土地卫片执法遥感监测分类表', '新增点状地物', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增其他线形地物','31', '土地卫片执法遥感监测分类表', '新增其他线形地物', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增库塘','32', '土地卫片执法遥感监测分类表', '新增库塘', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增林业园地','33', '土地卫片执法遥感监测分类表', '新增林业园地', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('建筑物翻建、续建','34', '土地卫片执法遥感监测分类表', '建筑物翻建、续建', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('新增光伏方阵用地','35', '土地卫片执法遥感监测分类表', '新增光伏方阵用地', '1');
INSERT INTO base.business_dic ("name", value, "type", title, status) VALUES('年度内续建','41', '土地卫片执法遥感监测分类表', '年度内续建', '1');
