12 lines
1.3 KiB
SQL
12 lines
1.3 KiB
SQL
|
|
-- 初始化菜单
|
|
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/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 (67, '查看', '', 'maku:t_purchase: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 (67, '新增', '', 'maku:t_purchase: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 (67, '修改', '', 'maku:t_purchase:update,maku:t_purchase: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 (67, '删除', '', 'maku:t_purchase:delete', 1, 0, '', 3, 0, 0, 10000, now(), 10000, now());
|