71 lines
3.1 KiB
Transact-SQL
71 lines
3.1 KiB
Transact-SQL
INSERT INTO Sys_Const (ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
VALUES('4F835AC7-9FD8-443D-A5A6-F557AA5A2221','Menu_Transfer','移交管理',12,'MenuType_P')
|
|
GO
|
|
|
|
insert into Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('D0850615-BF32-4CFA-84CA-EEA261676EA8','移交专业设置','BaseInfo/TransferMajor.aspx',180,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('0465EA2B-2F37-4103-A717-4033894108E0','D0850615-BF32-4CFA-84CA-EEA261676EA8','增加',1)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('EF58BDF7-F303-4633-8B83-DB4B151F8EAF','D0850615-BF32-4CFA-84CA-EEA261676EA8','修改',2)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('FC1373E2-D942-4D0E-822F-CE2F16C5D42D','D0850615-BF32-4CFA-84CA-EEA261676EA8','删除',3)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('65427D56-5490-42D7-8F00-EB3A59FAA6B0','D0850615-BF32-4CFA-84CA-EEA261676EA8','保存',4)
|
|
GO
|
|
|
|
|
|
CREATE TABLE [dbo].[Base_TransferMajor](
|
|
[TransferMajorId] [nvarchar](50) NOT NULL,
|
|
[Discipline] [nvarchar](50) NULL,
|
|
[Major] [nvarchar](50) NULL,
|
|
[DisciplineCode] [nvarchar](50) NULL,
|
|
[Remark] [nvarchar](200) NULL,
|
|
CONSTRAINT [PK_BaseInfo_TransferMajor] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TransferMajorId] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'移交专业表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_TransferMajor'
|
|
GO
|
|
|
|
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('7A0CD361-2BF9-466A-A586-3DBA49A7D4A1','Static Equipment','静设备','01',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('3D5FC248-8437-4062-A882-945C077B1910','Equipment','动设备','02',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('B55C034D-057E-4CD3-B09B-75DBDB7D2CDC','Piping','管道','03',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('2DA0AB18-78BD-43A5-BBB0-2BF96E25789E','Instrument','仪表','04','only refer to field instrument')
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('A7C08424-D6B4-40AD-8563-DCD793290ADE','Eletrical','电气','05',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('0A4DE4BE-DE07-41F2-ABB1-FE8B8710BC2A','Structure','结构','06',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('2EE1D310-53DF-43E1-B7A0-F4C1389E4A52','Civil','土建','07',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('2CDA9F7D-2212-4D6F-9E62-14241BA57DF3','Architecture','建筑','08',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('53CB3BF5-517F-4E67-A218-E9A7E1E31A58','FF','消防','09',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('B87322EC-75DA-4BEB-9CED-31B7E89B4FA9','Plumbing','给排水','10',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('D109A3D9-E8CC-46B4-830A-AB2686E6321F','Plot Plan','总图','11',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('DE4904D2-1CD8-4248-8599-AC16995FBDDB','Telecom','电信','12',null)
|
|
GO
|
|
INSERT INTO Base_TransferMajor
|
|
VALUES('82B6666D-1866-4A38-927A-0B2DB60C4D64','HVAC','暖通','13',null)
|
|
GO |