template.mysql.vm Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of coder Show documentation
The newest version!
-- 菜单初始SQL
INSERT INTO uc_menu(id, pid, name, url, permissions, type, icon, sort, create_id, create_time, update_id, update_time) VALUES (${id0}, 1067246875800000002, '$!comments', '${moduleName}/${pathNameDash}', NULL, 0, 'icon-desktop', 0, NULL, now(), NULL, now());
INSERT INTO uc_menu(id, pid, name, url, permissions, type, icon, sort, create_id, create_time, update_id, update_time) VALUES (${id1}, ${id0}, '查看', NULL, '${moduleName}:${pathName}:list,${moduleName}:${pathName}:page,${moduleName}:${pathName}:info', 1, NULL, 0, NULL, now(), NULL, now());
INSERT INTO uc_menu(id, pid, name, url, permissions, type, icon, sort, create_id, create_time, update_id, update_time) VALUES (${id2}, ${id0}, '新增', NULL, '${moduleName}:${pathName}:save', 1, NULL, 1, NULL, now(), NULL, now());
INSERT INTO uc_menu(id, pid, name, url, permissions, type, icon, sort, create_id, create_time, update_id, update_time) VALUES (${id3}, ${id0}, '修改', NULL, '${moduleName}:${pathName}:update', 1, NULL, 2, NULL, now(), NULL, now());
INSERT INTO uc_menu(id, pid, name, url, permissions, type, icon, sort, create_id, create_time, update_id, update_time) VALUES (${id4}, ${id0}, '删除', NULL, '${moduleName}:${pathName}:delete,${moduleName}:${pathName}:deleteBatch', 1, NULL, 3, NULL, now(), NULL, now());
INSERT INTO uc_menu(id, pid, name, url, permissions, type, icon, sort, create_id, create_time, update_id, update_time) VALUES (${id5}, ${id0}, '导出', NULL, '${moduleName}:${pathName}:export', 1, NULL, 4, NULL, now(), NULL, now());
INSERT INTO uc_menu(id, pid, name, url, permissions, type, icon, sort, create_id, create_time, update_id, update_time) VALUES (${id6}, ${id0}, '导入', NULL, '${moduleName}:${pathName}:import', 1, NULL, 4, NULL, now(), NULL, now());