Insert_sys_module.sql
517 Bytes
--新增测试工单菜单
DELETE sys_module WHERE NAME IN (N'测试数据',N'测试工单管理')
GO
INSERT INTO sys_module
VALUES
('.0.143.',N'测试数据','','',NULL,N'根节点','556',NULL,NULL,1,GETDATE(),'System',GETDATE(),'System')
GO
DECLARE @MAXID AS INT;
SET @MAXID=(SELECT id FROM sys_module where [name] = N'测试数据')
INSERT INTO sys_module
VALUES
('.0.143.1.',N'测试工单管理','/tickets/BaseWorkOrderTest/Index','',NULL,N'测试数据','1',@MAXID,'BaseWorkOrderTest',1,GETDATE(),'System',GETDATE(),'System')