Project

General

Profile

Data Services #1857 » Gujrams_Lkpt Changes.sql

Sindhuja Kadari, 28/03/2025 12:21 PM

 
??DELETE FROM [BMS].[LKPTWearCoatType]
GO
DELETE FROM [BMS].[LKPTSupStructType]
GO
DELETE FROM [BMS].[LKPTStructureType]
GO
DELETE FROM [BMS].[LKPTStrmErod]
GO
DELETE FROM [BMS].[LKPTStrmCatg]
GO
DELETE FROM [BMS].[LKPTSrvcLoc]
GO
DELETE FROM [BMS].[LKPTRailType]
GO
DELETE FROM [BMS].[LKPTPitchingType]
GO
DELETE FROM [BMS].[LKPTHeadWallType]
GO
DELETE FROM [BMS].[LKPTFuncBrdg]
GO
DELETE FROM [BMS].[LKPTFPType]
GO
DELETE FROM [BMS].[LKPTFoundType]
GO
DELETE FROM [BMS].[LKPTFlowDir]
GO
DELETE FROM [BMS].[LKPTFloorPrtctType]
GO
DELETE FROM [BMS].[LKPTExpjtType]
GO
DELETE FROM [BMS].[LKPTDsgnLoad]
GO
DELETE FROM [BMS].[LKPTDrainPipe]
GO
DELETE FROM [BMS].[LKPTCutWtrType]
GO
DELETE FROM [BMS].[LKPTBedMaterType]
GO
DELETE FROM [BMS].[LKPTAbutWallrailType]
GO
DELETE FROM [BMS].[LKPTAbutType]
GO
DELETE FROM [BMS].[LKPTAbutMaterial]
GO
DELETE FROM [BMS].[LKPTAbutBearType]
GO
SET IDENTITY_INSERT [BMS].[LKPTAbutBearType] ON
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (1, N'1', N'Elastomeric')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (2, N'2', N'Pot - PTFE')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (3, N'3', N'Rocker- Roller')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (4, N'4', N'Metallic')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (5, N'5', N'Plate')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (6, N'6', N'Not Visible')
SET IDENTITY_INSERT [BMS].[LKPTAbutBearType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTAbutMaterial] ON
INSERT [BMS].[LKPTAbutMaterial] ([AbutMaterialTypeId], [AbutMaterialType], [Description]) VALUES (1, N'1', N'Stone?Masonry ')
INSERT [BMS].[LKPTAbutMaterial] ([AbutMaterialTypeId], [AbutMaterialType], [Description]) VALUES (2, N'2', N'Brick Masonry ')
INSERT [BMS].[LKPTAbutMaterial] ([AbutMaterialTypeId], [AbutMaterialType], [Description]) VALUES (3, N'3', N'PCC ')
INSERT [BMS].[LKPTAbutMaterial] ([AbutMaterialTypeId], [AbutMaterialType], [Description]) VALUES (4, N'4', N'RCC ')
SET IDENTITY_INSERT [BMS].[LKPTAbutMaterial] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTAbutType] ON
INSERT [BMS].[LKPTAbutType] ([AbutTypeId], [AbutType], [Description]) VALUES (1, N'1', N'Plate Wall')
INSERT [BMS].[LKPTAbutType] ([AbutTypeId], [AbutType], [Description]) VALUES (2, N'2', N'Circular')
INSERT [BMS].[LKPTAbutType] ([AbutTypeId], [AbutType], [Description]) VALUES (3, N'3', N'Counter fort')
INSERT [BMS].[LKPTAbutType] ([AbutTypeId], [AbutType], [Description]) VALUES (4, N'4', N'Spill Through')
INSERT [BMS].[LKPTAbutType] ([AbutTypeId], [AbutType], [Description]) VALUES (5, N'5', N'Abutment Pier')
INSERT [BMS].[LKPTAbutType] ([AbutTypeId], [AbutType], [Description]) VALUES (6, N'6', N'Frame Type')
INSERT [BMS].[LKPTAbutType] ([AbutTypeId], [AbutType], [Description]) VALUES (7, N'7', N'Others')
SET IDENTITY_INSERT [BMS].[LKPTAbutType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTAbutWallrailType] ON
INSERT [BMS].[LKPTAbutWallrailType] ([AbutWallrailTypeId], [AbutWallrailType], [Description]) VALUES (1, N'1', N'SSM Parapet')
INSERT [BMS].[LKPTAbutWallrailType] ([AbutWallrailTypeId], [AbutWallrailType], [Description]) VALUES (2, N'2', N'BM Parapet')
INSERT [BMS].[LKPTAbutWallrailType] ([AbutWallrailTypeId], [AbutWallrailType], [Description]) VALUES (3, N'3', N'CC Parapet')
INSERT [BMS].[LKPTAbutWallrailType] ([AbutWallrailTypeId], [AbutWallrailType], [Description]) VALUES (4, N'4', N'RC Railing')
INSERT [BMS].[LKPTAbutWallrailType] ([AbutWallrailTypeId], [AbutWallrailType], [Description]) VALUES (5, N'5', N'MS Railing')
INSERT [BMS].[LKPTAbutWallrailType] ([AbutWallrailTypeId], [AbutWallrailType], [Description]) VALUES (6, N'6', N'RC Crash Barrier')
SET IDENTITY_INSERT [BMS].[LKPTAbutWallrailType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTBedMaterType] ON
INSERT [BMS].[LKPTBedMaterType] ([BedMaterTypeId], [BedMaterType], [Description]) VALUES (1, N'1', N'Soil')
INSERT [BMS].[LKPTBedMaterType] ([BedMaterTypeId], [BedMaterType], [Description]) VALUES (2, N'2', N'Boulder')
INSERT [BMS].[LKPTBedMaterType] ([BedMaterTypeId], [BedMaterType], [Description]) VALUES (3, N'3', N'Rock')
INSERT [BMS].[LKPTBedMaterType] ([BedMaterTypeId], [BedMaterType], [Description]) VALUES (4, N'4', N'Not Visible')
INSERT [BMS].[LKPTBedMaterType] ([BedMaterTypeId], [BedMaterType], [Description]) VALUES (5, N'5', N'Not Applicable')
SET IDENTITY_INSERT [BMS].[LKPTBedMaterType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTCutWtrType] ON
INSERT [BMS].[LKPTCutWtrType] ([CutWtrTypeId], [CutWtrType], [Description]) VALUES (1, N'1', N'Circular')
INSERT [BMS].[LKPTCutWtrType] ([CutWtrTypeId], [CutWtrType], [Description]) VALUES (2, N'2', N'Triangular')
SET IDENTITY_INSERT [BMS].[LKPTCutWtrType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTDrainPipe] ON
INSERT [BMS].[LKPTDrainPipe] ([DrainPipeId], [DrainPipeType], [Description]) VALUES (1, N'1', N'Horizontal')
INSERT [BMS].[LKPTDrainPipe] ([DrainPipeId], [DrainPipeType], [Description]) VALUES (2, N'2', N'Vertical')
SET IDENTITY_INSERT [BMS].[LKPTDrainPipe] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTDsgnLoad] ON
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (1, N'1', N'1L ClA')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (2, N'2', N'2L ClA')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (3, N'3', N'1L ClB')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (4, N'4', N'2L ClB')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (5, N'5', N'70R')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (6, N'6', N'60R')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (7, N'7', N'50R')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (8, N'8', N'40R')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (9, N'9', N'30R')
INSERT [BMS].[LKPTDsgnLoad] ([DsgnLoadId], [DsgnLoadType], [Description]) VALUES (10, N'10', N'Not Avaliable')
SET IDENTITY_INSERT [BMS].[LKPTDsgnLoad] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTExpjtType] ON
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (1, N'1', N'Filler')
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (2, N'2', N'Asphaltic Plug')
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (3, N'3', N'Strip Seal')
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (4, N'4', N'Finger Plate')
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (5, N'5', N'Modular')
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (6, N'6', N'Compression Seal')
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (7, N'7', N'Not Visible')
INSERT [BMS].[LKPTExpjtType] ([ExpjtTypeId], [ExpjtType], [Description]) VALUES (8, N'8', N'Not Provided')
SET IDENTITY_INSERT [BMS].[LKPTExpjtType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTFloorPrtctType] ON
INSERT [BMS].[LKPTFloorPrtctType] ([FloorPrtctId], [FloorPrtctType], [Description]) VALUES (1, N'1', N'Stone Pitching')
INSERT [BMS].[LKPTFloorPrtctType] ([FloorPrtctId], [FloorPrtctType], [Description]) VALUES (2, N'2', N'Concrete Block')
INSERT [BMS].[LKPTFloorPrtctType] ([FloorPrtctId], [FloorPrtctType], [Description]) VALUES (3, N'3', N'Gabions')
INSERT [BMS].[LKPTFloorPrtctType] ([FloorPrtctId], [FloorPrtctType], [Description]) VALUES (4, N'4', N'Not Visible')
INSERT [BMS].[LKPTFloorPrtctType] ([FloorPrtctId], [FloorPrtctType], [Description]) VALUES (5, N'5', N'Not Applicable')
SET IDENTITY_INSERT [BMS].[LKPTFloorPrtctType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTFlowDir] ON
INSERT [BMS].[LKPTFlowDir] ([FlowDirId], [FlowDirType], [Description]) VALUES (1, N'LR', N'L to R')
INSERT [BMS].[LKPTFlowDir] ([FlowDirId], [FlowDirType], [Description]) VALUES (2, N'RL', N'R to L')
SET IDENTITY_INSERT [BMS].[LKPTFlowDir] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTFoundType] ON
INSERT [BMS].[LKPTFoundType] ([FoundTypeId], [FoundType], [Description]) VALUES (1, N'1', N'Open')
INSERT [BMS].[LKPTFoundType] ([FoundTypeId], [FoundType], [Description]) VALUES (2, N'2', N'Pile')
INSERT [BMS].[LKPTFoundType] ([FoundTypeId], [FoundType], [Description]) VALUES (3, N'3', N'Well')
INSERT [BMS].[LKPTFoundType] ([FoundTypeId], [FoundType], [Description]) VALUES (4, N'4', N'Raft')
INSERT [BMS].[LKPTFoundType] ([FoundTypeId], [FoundType], [Description]) VALUES (5, N'5', N'Not Visible')
SET IDENTITY_INSERT [BMS].[LKPTFoundType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTFPType] ON
INSERT [BMS].[LKPTFPType] ([FPTypeId], [FPType], [Description]) VALUES (1, N'1', N'Hollow')
INSERT [BMS].[LKPTFPType] ([FPTypeId], [FPType], [Description]) VALUES (2, N'2', N'Solid')
SET IDENTITY_INSERT [BMS].[LKPTFPType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTFuncBrdg] ON
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (1, N'1', N'Bridge Over River')
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (2, N'2', N'Viaduct')
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (3, N'3', N'Fly Over')
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (4, N'4', N'Vehicular Underpass')
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (5, N'5', N'Pedestrian / Cattle Underpass')
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (6, N'6', N'ROB')
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (7, N'7', N'RUB')
INSERT [BMS].[LKPTFuncBrdg] ([FuncBrdgId], [FuncBrdgType], [Description]) VALUES (8, N'8', N'Others')
SET IDENTITY_INSERT [BMS].[LKPTFuncBrdg] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTHeadWallType] ON
INSERT [BMS].[LKPTHeadWallType] ([HeadWallTypeId], [HeadWallType], [Description]) VALUES (1, N'1', N'Stone Masonry')
INSERT [BMS].[LKPTHeadWallType] ([HeadWallTypeId], [HeadWallType], [Description]) VALUES (2, N'2', N'Brick Masonry')
INSERT [BMS].[LKPTHeadWallType] ([HeadWallTypeId], [HeadWallType], [Description]) VALUES (3, N'3', N'Plain Cement Concrete')
INSERT [BMS].[LKPTHeadWallType] ([HeadWallTypeId], [HeadWallType], [Description]) VALUES (4, N'4', N'Reinforced Concrete')
INSERT [BMS].[LKPTHeadWallType] ([HeadWallTypeId], [HeadWallType], [Description]) VALUES (5, N'5', N'Others')
SET IDENTITY_INSERT [BMS].[LKPTHeadWallType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTPitchingType] ON
INSERT [BMS].[LKPTPitchingType] ([PitchingTypeCondId], [PitchingTypeCondType], [Description]) VALUES (1, N'1', N'Stone Pitching')
INSERT [BMS].[LKPTPitchingType] ([PitchingTypeCondId], [PitchingTypeCondType], [Description]) VALUES (2, N'2', N'Concrete Block')
INSERT [BMS].[LKPTPitchingType] ([PitchingTypeCondId], [PitchingTypeCondType], [Description]) VALUES (3, N'3', N'Gabions')
INSERT [BMS].[LKPTPitchingType] ([PitchingTypeCondId], [PitchingTypeCondType], [Description]) VALUES (4, N'4', N'Not Visible')
INSERT [BMS].[LKPTPitchingType] ([PitchingTypeCondId], [PitchingTypeCondType], [Description]) VALUES (5, N'5', N'Not Applicable')
SET IDENTITY_INSERT [BMS].[LKPTPitchingType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTRailType] ON
INSERT [BMS].[LKPTRailType] ([RailTypeId], [RailType], [Description]) VALUES (1, N'1', N'Stone Masonry Parapet')
INSERT [BMS].[LKPTRailType] ([RailTypeId], [RailType], [Description]) VALUES (2, N'2', N'Brick Masonry Parapet')
INSERT [BMS].[LKPTRailType] ([RailTypeId], [RailType], [Description]) VALUES (3, N'3', N'RCC Parapet')
INSERT [BMS].[LKPTRailType] ([RailTypeId], [RailType], [Description]) VALUES (4, N'4', N'RC Railings')
INSERT [BMS].[LKPTRailType] ([RailTypeId], [RailType], [Description]) VALUES (5, N'5', N'Crash Barrier')
INSERT [BMS].[LKPTRailType] ([RailTypeId], [RailType], [Description]) VALUES (6, N'6', N'Guard Posts')
INSERT [BMS].[LKPTRailType] ([RailTypeId], [RailType], [Description]) VALUES (7, N'7', N'Steel Railings')
SET IDENTITY_INSERT [BMS].[LKPTRailType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTSrvcLoc] ON
INSERT [BMS].[LKPTSrvcLoc] ([SrvcLocId], [SrvcLocType], [Description]) VALUES (1, N'1', N'Attached to railing')
INSERT [BMS].[LKPTSrvcLoc] ([SrvcLocId], [SrvcLocType], [Description]) VALUES (2, N'2', N'Inside the footpath')
INSERT [BMS].[LKPTSrvcLoc] ([SrvcLocId], [SrvcLocType], [Description]) VALUES (3, N'3', N'Over the footpath')
INSERT [BMS].[LKPTSrvcLoc] ([SrvcLocId], [SrvcLocType], [Description]) VALUES (4, N'4', N'supported on bracket projected from bridge')
INSERT [BMS].[LKPTSrvcLoc] ([SrvcLocId], [SrvcLocType], [Description]) VALUES (5, N'5', N'Inside Kerb')
SET IDENTITY_INSERT [BMS].[LKPTSrvcLoc] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTStrmCatg] ON
INSERT [BMS].[LKPTStrmCatg] ([StrmCatgId], [StrmCatgType], [Description]) VALUES (1, N'1', N'Perennial')
INSERT [BMS].[LKPTStrmCatg] ([StrmCatgId], [StrmCatgType], [Description]) VALUES (2, N'2', N'Seasonal')
INSERT [BMS].[LKPTStrmCatg] ([StrmCatgId], [StrmCatgType], [Description]) VALUES (3, N'3', N'Navigable')
INSERT [BMS].[LKPTStrmCatg] ([StrmCatgId], [StrmCatgType], [Description]) VALUES (4, N'4', N'Not Applicable')
SET IDENTITY_INSERT [BMS].[LKPTStrmCatg] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTStrmErod] ON
INSERT [BMS].[LKPTStrmErod] ([StrmErodId], [StrmErodType], [Description]) VALUES (1, N'1', N'Alluvial')
INSERT [BMS].[LKPTStrmErod] ([StrmErodId], [StrmErodType], [Description]) VALUES (2, N'2', N'Quasi Alluvial')
INSERT [BMS].[LKPTStrmErod] ([StrmErodId], [StrmErodType], [Description]) VALUES (3, N'3', N'Rigid')
INSERT [BMS].[LKPTStrmErod] ([StrmErodId], [StrmErodType], [Description]) VALUES (4, N'4', N'Not Applicable')
SET IDENTITY_INSERT [BMS].[LKPTStrmErod] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTStructureType] ON
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (1, N'1', N'Hume Pipe', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (2, N'2', N'Mass Concrete Pipe', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (3, N'3', N'Stone Slab', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (4, N'4', N'RC Slab
', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (5, N'5', N'RC Box', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (6, N'6', N'Stone Arch', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (7, N'7', N'Brick Arch', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (8, N'8', N'RC Arch', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (9, N'9', N'RC Girder', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (10, N'10', N'Steel Girder', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (11, N'11', N'Irish Causeway', NULL, NULL)
INSERT [BMS].[LKPTStructureType] ([StructureTypeId], [StructureType], [Description], [color], [imagepath]) VALUES (12, N'12', N'Others', NULL, NULL)
SET IDENTITY_INSERT [BMS].[LKPTStructureType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTSupStructType] ON
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (1, N'1', N'Hume Pipe', N'1')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (2, N'2', N'Mass Concrete Pipe Culvert', N'1')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (3, N'3', N'Stone Slab', N'2')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (4, N'4', N'RC Multicell Box', N'2')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (5, N'5', N'RC Solid Slab', N'2')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (6, N'6', N'RC Voided Slab', N'2')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (7, N'7', N'PSC Voided Slab', N'2')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (8, N'8', N'RC Girder', N'3')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (9, N'9', N'RC Box Girder', N'3')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (10, N'10', N'PSC Girder', N'3')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (11, N'11', N'PSC Box Girder', N'3')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (12, N'12', N'Balanced Cantilever Bridge', N'3')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (13, N'13', N'Stone Masonry Arch', N'4')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (14, N'14', N'Brick Masonry Arch', N'4')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (15, N'15', N'RC Arch', N'4')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (16, N'16', N'Bow String Arch', N'5')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (17, N'17', N'Steel Truss', N'5')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (18, N'18', N'Steel Girder', N'5')
INSERT [BMS].[LKPTSupStructType] ([SupStructTypeId], [SupStructType], [Description], [ParentCode]) VALUES (19, N'19', N'Cable Stayed', N'5')
SET IDENTITY_INSERT [BMS].[LKPTSupStructType] OFF
GO
SET IDENTITY_INSERT [BMS].[LKPTWearCoatType] ON
INSERT [BMS].[LKPTWearCoatType] ([WearCoatTypeId], [WearCoatType], [Description]) VALUES (1, N'1', N'Asphaltic')
INSERT [BMS].[LKPTWearCoatType] ([WearCoatTypeId], [WearCoatType], [Description]) VALUES (2, N'2', N'Concrete')
SET IDENTITY_INSERT [BMS].[LKPTWearCoatType] OFF
GO
(2-2/2)