23 lines
691 B
Transact-SQL
23 lines
691 B
Transact-SQL
--安全月报增加本月隐患总数、年度隐患总数
|
|
alter table Manager_MonthReportC
|
|
add MonthHdangerCount int null;
|
|
|
|
alter table Manager_MonthReportC
|
|
add YearHdangerCount int null;
|
|
|
|
--增加Manager_HiddenDanger表本月隐患整改情况
|
|
CREATE TABLE [dbo].[Manager_HiddenDanger](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[MonthReportId] [nvarchar](50) NULL,
|
|
[UnitId] [nvarchar](50) NULL,
|
|
[CommonlyNum] [int] NULL,
|
|
[MajorNum] [int] NULL,
|
|
[ReRate] [nvarchar](50) NULL,
|
|
[SortIndex] [int] NULL,
|
|
CONSTRAINT [PK_Manager_HiddenDanger] PRIMARY KEY CLUSTERED
|
|
(
|
|
[Id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY];
|
|
|