34 lines
1.3 KiB
Transact-SQL
34 lines
1.3 KiB
Transact-SQL
--删除字段
|
|
alter table Running_Operation drop column RunningId;
|
|
alter table Running_Operation drop column InstallationId;
|
|
alter table Running_Operation drop column ProcessesId;
|
|
alter table Running_Operation drop column SystemId;
|
|
alter table Running_Maintenance drop column RunningId;
|
|
alter table Running_Maintenance drop column InstallationId;
|
|
alter table Running_Maintenance drop column ProcessesId;
|
|
alter table Running_Maintenance drop column SystemId;
|
|
|
|
--添加附属字段
|
|
alter table Running_LogManagement add MainId varchar(50) null;
|
|
alter table Running_Operation add MainId varchar(50) null;
|
|
alter table Running_Maintenance add MainId varchar(50) null;
|
|
|
|
|
|
if object_id(N'Running_LogMain',N'U') is not null
|
|
drop table dbo.Running_LogMain
|
|
CREATE TABLE dbo.Running_LogMain(
|
|
MainId varchar(50) NOT NULL,--主键
|
|
ProjectId varchar(50) NULL,--项目主键
|
|
JobNo varchar(50) NULL,--文件号
|
|
ShiftType varchar(50) NULL,--轮班类型1:白班2:夜班
|
|
StartData datetime NULL,--开始日期
|
|
EndData datetime NULL,--结束日期
|
|
AddUser varchar(50) NULL,--添加人
|
|
AddTime datetime NULL,--添加日期
|
|
CONSTRAINT PK_Running_LogMain PRIMARY KEY CLUSTERED
|
|
(
|
|
MainId 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
|