lpf
/
SGGL_SHJ
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
SGGL_SHJ/DataBase/版本日志/SGGLDB_V2026-03-12-xiaj.sql

89 lines
5.2 KiB
MySQL
Raw Permalink Normal View History

1
2026-03-23 14:33:54 +08:00
--Σ<EFBFBD>󹤳̷<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֶΡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬ 0<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ˡ<EFBFBD>1<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>С<EFBFBD>2<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɡ<EFBFBD>
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Solution_LargerHazard' AND COLUMN_NAME = 'ApprovalState')
BEGIN
ALTER TABLE Solution_LargerHazard ADD ApprovalState char(1);
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬(0<><30><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ˡ<EFBFBD>1<EFBFBD><31><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>С<EFBFBD>2<EFBFBD><32><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>)','SCHEMA', N'dbo','TABLE', N'Solution_LargerHazard','COLUMN', N'ApprovalState'
END
GO
--Σ<EFBFBD>󹤳̷<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʷ<EFBFBD><EFBFBD><EFBFBD>ݡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>߼<EFBFBD><EFBFBD><EFBFBD>
--<EFBFBD><EFBFBD>ҵ״̬Ϊδ<EFBFBD><EFBFBD>ʼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬Ĭ<EFBFBD><EFBFBD>Ϊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ˣ<EFBFBD><EFBFBD><EFBFBD>ҵ״̬Ϊ<EFBFBD><EFBFBD>ҵ<EFBFBD>к<EFBFBD><EFBFBD><EFBFBD><EFBFBD>깤<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬Ĭ<EFBFBD><EFBFBD>Ϊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
update Solution_LargerHazard set ApprovalState='0' where ApprovalState is null and States = '1'
GO
update Solution_LargerHazard set ApprovalState='2' where ApprovalState is null and States in ('2','3')
GO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'HSSEData_HSSE' AND COLUMN_NAME = 'AwaitApprovalNum')
BEGIN
ALTER TABLE HSSEData_HSSE ADD AwaitApprovalNum int;
ALTER TABLE HSSEData_HSSE ADD PendingApprovalNum int;
ALTER TABLE HSSEData_HSSE ADD CompletedApprovalNum int;
ALTER TABLE HSSEData_HSSE ADD SuperAwaitApprovalNum int;
ALTER TABLE HSSEData_HSSE ADD SuperPendingApprovalNum int;
ALTER TABLE HSSEData_HSSE ADD SuperCompletedApprovalNum int;
EXEC sp_addextendedproperty 'MS_Description', N'Σ<EFBFBD>󹤳̴<EFBFBD><EFBFBD><EFBFBD><EFBFBD>˸<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'AwaitApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>и<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'PendingApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɸ<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'CompletedApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD>Σ<EFBFBD>󹤳̴<EFBFBD><EFBFBD><EFBFBD><EFBFBD>˸<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'SuperAwaitApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD>Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>и<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'SuperPendingApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD>Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɸ<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'SuperCompletedApprovalNum';
END
GO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Project_HSSEData_HSSE' AND COLUMN_NAME = 'AwaitApprovalNum')
BEGIN
ALTER TABLE Project_HSSEData_HSSE ADD AwaitApprovalNum int;
ALTER TABLE Project_HSSEData_HSSE ADD PendingApprovalNum int;
ALTER TABLE Project_HSSEData_HSSE ADD CompletedApprovalNum int;
ALTER TABLE Project_HSSEData_HSSE ADD SuperAwaitApprovalNum int;
ALTER TABLE Project_HSSEData_HSSE ADD SuperPendingApprovalNum int;
ALTER TABLE Project_HSSEData_HSSE ADD SuperCompletedApprovalNum int;
EXEC sp_addextendedproperty 'MS_Description', N'Σ<EFBFBD>󹤳̴<EFBFBD><EFBFBD><EFBFBD><EFBFBD>˸<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'AwaitApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>и<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'PendingApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɸ<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'CompletedApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD>Σ<EFBFBD>󹤳̴<EFBFBD><EFBFBD><EFBFBD><EFBFBD>˸<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'SuperAwaitApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD>Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>и<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'SuperPendingApprovalNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD>Σ<EFBFBD>󹤳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɸ<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'SuperCompletedApprovalNum';
END
GO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'HSSEData_HSSE' AND COLUMN_NAME = 'LargerClosedNum')
BEGIN
ALTER TABLE HSSEData_HSSE ADD LargerClosedNum int;
ALTER TABLE HSSEData_HSSE ADD LargerNotClosedNum int;
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD>ϴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'LargerClosedNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD>ϴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'HSSEData_HSSE','COLUMN', N'LargerNotClosedNum';
END
GO
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Project_HSSEData_HSSE' AND COLUMN_NAME = 'LargerClosedNum')
BEGIN
ALTER TABLE Project_HSSEData_HSSE ADD LargerClosedNum int;
ALTER TABLE Project_HSSEData_HSSE ADD LargerNotClosedNum int;
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD>ϴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'LargerClosedNum';
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD>ϴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','SCHEMA', N'dbo','TABLE', N'Project_HSSEData_HSSE','COLUMN', N'LargerNotClosedNum';
END
GO
--ȥ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>
ALTER TABLE [Supervise_UnitHazardRegister]
DROP CONSTRAINT [FK_UnitHazardRegister_Project];
GO
--<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>鲹<EFBFBD><EFBFBD><EFBFBD>ֶΡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>鵥λ<EFBFBD><EFBFBD>
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Supervise_UnitHazardRegister' AND COLUMN_NAME = 'InspectionUnit')
BEGIN
ALTER TABLE Supervise_UnitHazardRegister ADD InspectionUnit nvarchar(50);
EXEC sp_addextendedproperty 'MS_Description', N'<EFBFBD><EFBFBD><EFBFBD>鵥λ','SCHEMA', N'dbo','TABLE', N'Supervise_UnitHazardRegister','COLUMN', N'InspectionUnit'
END
GO