41 lines
1.3 KiB
Transact-SQL
41 lines
1.3 KiB
Transact-SQL
|
|
--修改字段长度
|
|
ALTER TABLE PreRun_TechnologySysPiping ALTER Column NameSpecifications varchar(max) null;
|
|
ALTER TABLE PreRun_TechnologySysPiping ALTER Column Materials varchar(max) null;
|
|
GO
|
|
--删除工作包设置中的编码
|
|
ALTER TABLE PreRun_WorkPackage DROP COLUMN WorkPackCode
|
|
GO
|
|
--清除子系统工作包管理表
|
|
truncate table PreRun_SubSysWorkPackage
|
|
--子系统工作包管理添加系统主键
|
|
alter table PreRun_SubSysWorkPackage add SystemId varchar(50) NULL
|
|
GO
|
|
|
|
IF object_id(N'PreRun_TechnologySysPiping',N'U') is not null
|
|
drop table dbo.PreRun_TechnologySysPiping
|
|
CREATE TABLE [dbo].[PreRun_TechnologySysPiping](
|
|
[TechnologyId] [varchar](50) NOT NULL,
|
|
[SystemId] [varchar](50) NULL,
|
|
[ProjectId] [varchar](50) NULL,
|
|
[TagNumber] [varchar](50) NULL,
|
|
[NameSpecifications] [varchar](max) NULL,
|
|
[DrawingNo] [varchar](50) NULL,
|
|
[Materials] [varchar](max) NULL,
|
|
[NumOperate] [varchar](50) NULL,
|
|
[NumStandby] [varchar](50) NULL,
|
|
[WeightSingle] [varchar](50) NULL,
|
|
[WeightTotal] [varchar](50) NULL,
|
|
[Remark] [nvarchar](150) NULL,
|
|
[AddUser] [varchar](50) NULL,
|
|
[AddTime] [datetime] NULL,
|
|
[Sort] [int] NULL,
|
|
CONSTRAINT [PK_PreRun_TechnologySysPiping] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TechnologyId] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|
GO
|
|
|
|
|