40 lines
3.6 KiB
Transact-SQL
40 lines
3.6 KiB
Transact-SQL
|
|
|
|
--项目补充PMP系统项目信息
|
|
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Base_Project' AND COLUMN_NAME = 'PlanStartDate')
|
|
BEGIN
|
|
ALTER TABLE Base_Project ADD ProjectNameEn nvarchar(500);
|
|
ALTER TABLE Base_Project ADD StClientName nvarchar(200);
|
|
ALTER TABLE Base_Project ADD ClientContactor nvarchar(200);
|
|
ALTER TABLE Base_Project ADD MobileTel nvarchar(200);
|
|
ALTER TABLE Base_Project ADD PlanStartDate datetime;
|
|
ALTER TABLE Base_Project ADD PlanEndDate datetime;
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业主名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Project', @level2type=N'COLUMN',@level2name=N'StClientName'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业主联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Project', @level2type=N'COLUMN',@level2name=N'ClientContactor'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业主联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Project', @level2type=N'COLUMN',@level2name=N'MobileTel'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目计划开始日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Project', @level2type=N'COLUMN',@level2name=N'PlanStartDate'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目计划结束日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Project', @level2type=N'COLUMN',@level2name=N'PlanEndDate'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目英文名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Project', @level2type=N'COLUMN',@level2name=N'ProjectNameEn'
|
|
END
|
|
GO
|
|
|
|
|
|
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PMP_Project' AND COLUMN_NAME = 'stClientName')
|
|
BEGIN
|
|
ALTER TABLE PMP_Project ADD stClientName nvarchar(200);
|
|
ALTER TABLE PMP_Project ADD clientContactor nvarchar(200);
|
|
ALTER TABLE PMP_Project ADD mobileTel nvarchar(200);
|
|
ALTER TABLE PMP_Project ADD planStartDate datetime;
|
|
ALTER TABLE PMP_Project ADD planEndDate datetime;
|
|
ALTER TABLE PMP_Project ADD stLocationName nvarchar(20);
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业主名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PMP_Project', @level2type=N'COLUMN',@level2name=N'stClientName'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业主联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PMP_Project', @level2type=N'COLUMN',@level2name=N'clientContactor'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业主联系人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PMP_Project', @level2type=N'COLUMN',@level2name=N'mobileTel'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目计划开始日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PMP_Project', @level2type=N'COLUMN',@level2name=N'planStartDate'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目计划结束日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PMP_Project', @level2type=N'COLUMN',@level2name=N'planEndDate'
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'建设地点名称（境内、境外）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PMP_Project', @level2type=N'COLUMN',@level2name=N'stLocationName'
|
|
END
|
|
GO
|