HJGL_DS/DataBase/SGGL系统名称初始化脚本.sql

15 lines
941 B
Transact-SQL

INSERT INTO dbo.Sys_System (SystemId,SystemName,SystemType,SorIndex,IsEnable,IsMoreProject) VALUES ('1','综合平台系统',0,1,1,0)
GO
INSERT INTO dbo.Sys_System (SystemId,SystemName,SystemType,SorIndex,IsEnable,IsMoreProject) VALUES ('2','本部管道安装焊接管理',1,2,1,0)
GO
INSERT INTO dbo.Sys_System (SystemId,SystemName,SystemType,SorIndex,IsEnable,IsMoreProject) VALUES ('3','现场管道安装焊接管理',1,3,1,1)
GO
INSERT INTO dbo.Sys_System (SystemId,SystemName,SystemType,SorIndex,IsEnable,IsMoreProject) VALUES ('4','本部压力容器焊接管理',1,4,1,0)
GO
INSERT INTO dbo.Sys_System (SystemId,SystemName,SystemType,SorIndex,IsEnable,IsMoreProject) VALUES ('5','现场压力容器焊接管理',1,5,1,1)
GO
INSERT INTO dbo.Sys_System (SystemId,SystemName,SystemType,SorIndex,IsEnable,IsMoreProject) VALUES ('6','焊工管理',1,2,1,0)
GO
INSERT INTO dbo.Sys_System (SystemId,SystemName,SystemType,SorIndex,IsEnable,IsMoreProject) VALUES ('7','焊材管理',1,3,1,0)
GO