DELETE FROM [BMS].[LKPTWearCoatType]
GO
DELETE FROM [BMS].[LKPTSupStructType]
GO
DELETE FROM [BMS].[LKPTStructureType]
GO
DELETE FROM [BMS].[LKPTRailType]
GO
DELETE FROM [BMS].[LKPTHeadWallType]
GO
DELETE FROM [BMS].[LKPTFPType]
GO
DELETE FROM [BMS].[LKPTFoundType]
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 (5, N'3', N'Rocker- Roller')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (6, N'4', N'Metallic')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (7, N'5', N'Plate')
INSERT [BMS].[LKPTAbutBearType] ([AbutBearTypeId], [AbutBearType], [Description]) VALUES (8, 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')
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].[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')
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].[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].[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].[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