ECS / ECS_EquipmentMangaSystem_BingChengTaiGuang · Files

数据库修改记录.txt 1.4 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 

-- equipment  code 新增唯一非聚合索引
CREATE  UNIQUE NONCLUSTERED INDEX NonClusteredIndex_code ON dbo.equipment (  Code ASC  )  
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ];


-- equipmenttype  code 新增唯一非聚合索引
CREATE  UNIQUE NONCLUSTERED INDEX NonClusteredIndex_code ON dbo.equipmenttype (  Code ASC  )  
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ];

-- EquipmentTypePart  PartCode 新增唯一非聚合索引
CREATE  UNIQUE NONCLUSTERED INDEX NonClusteredIndex_PartCode ON dbo.EquipmentTypePart (  PartCode ASC  )  
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ];


-- equipmentmaintainrule code 新增唯一非聚合索引
CREATE  UNIQUE NONCLUSTERED INDEX NonClusteredIndex_Code ON dbo.equipmentmaintainrule (  Code ASC  )  
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ];