11 lines
1.3 KiB
MySQL
11 lines
1.3 KiB
MySQL
|
|
||
|
|
-- 初始化菜单
|
||
|
|
INSERT INTO sys_menu (pid, name, url, authority, type, open_style, icon, sort, version, deleted, creator, create_time, updater, update_time) VALUES (1, '书籍订单详情表', 'maku/t_purchase_details/index', NULL, 0, 0, 'icon-menu', 0, 0, 0, 10000, now(), 10000, now());
|
||
|
|
|
||
|
|
SELECT max(id) from sys_menu where name = '评论表';
|
||
|
|
|
||
|
|
INSERT INTO sys_menu (pid, name, url, authority, type, open_style, icon, sort, version, deleted, creator, create_time, updater, update_time) VALUES (81, '查看', '', 'maku:t_purchase_details:page', 1, 0, '', 0, 0, 0, 10000, now(), 10000, now());
|
||
|
|
INSERT INTO sys_menu (pid, name, url, authority, type, open_style, icon, sort, version, deleted, creator, create_time, updater, update_time) VALUES (81, '新增', '', 'maku:t_purchase_details:save', 1, 0, '', 1, 0, 0, 10000, now(), 10000, now());
|
||
|
|
INSERT INTO sys_menu (pid, name, url, authority, type, open_style, icon, sort, version, deleted, creator, create_time, updater, update_time) VALUES (81, '修改', '', 'maku:t_purchase_details:update,maku:t_purchase_details:info', 1, 0, '', 2, 0, 0, 10000, now(), 10000, now());
|
||
|
|
INSERT INTO sys_menu (pid, name, url, authority, type, open_style, icon, sort, version, deleted, creator, create_time, updater, update_time) VALUES (81, '删除', '', 'maku:t_purchase_details:delete', 1, 0, '', 3, 0, 0, 10000, now(), 10000, now());
|