firstblooduk
Member
I get this error when adding this to bliss: #1062 - Duplicate entry 'Land_HBarrier_large' for key 'uq1_building'
When adding this below to instance_buildings how can i stop the duplicate entry if i need to add more of the same building.
INSERT INTO `database`.`building` (`id`, `class_name`) VALUES ('103','Land_HBarrier_large'), ('104','Land_BarGate2'), ('105','FlagCarrierBAF'), ('106','HeliHCivil'), ('107','Land_Misc_deerstand'), ('108','Land_CamoNetB_EAST'), ('109','Land_CamoNetVar_EAST'), ('110','Land_Table_EP1'), ('111','FoodBox1'), ('112','MedBox0'), ('113','Laptop_EP1'), ('114','MASH'), ('115','Land_covering_hut_big_EP1'), ('116','Land_Campfire_burning'), ('117','Barrels'), ('118','Land_Toilet'), ('119','Land_Ind_IlluminantTower'), ('120','Land_radar_EP1'), ('121','76n6ClamShell_EP1'), ('122','Land_Barrack2_EP1'), ('123','Barrack2');
INSERT INTO `database`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('103','1675','[59.92,[1123.06,9184.57,0.06]]'), ('103','1675','[83.39,[1120.35,9192.46,0.11]]'), ('103','1675','[-75.1,[1120.83,9201.04,0.33]]'), ('103','1675','[-94.63,[1121.14,9209.34,0.35]]'), ('103','1675','[47.32,[1117.8,9217.08,0.12]]'), ('103','1675','[42.95,[1111.68,9223.07]]'), ('103','1675','[22.79,[1104.59,9227.29,0.07]]'), ('103','1675','[7.32,[1096.48,9229.49,0.11]]'), ('103','1675','[0,[1088.04,9229.83]]'), ('103','1675','[0,[1079.84,9229.61]]'), ('103','1675','[-9.15,[1071.42,9228.83]]'), ('103','1675','[-31.63,[1063.25,9225.82]]'), ('103','1675','[-24.14,[1055.97,9221.31]]'), ('103','1675','[-11.38,[1047.99,9218.46]]'), ('103','1675','[-22.07,[1039.98,9215.86]]'), ('103','1675','[-75.95,[1035.76,9209.5]]'), ('103','1675','[-54.64,[1032.5,9201.93]]'), ('103','1675','[-68.73,[1028.67,9194.32,0.1]]'), ('103','1675','[-84.51,[1026.85,9185.88]]'), ('103','1675','[-122.85,[1029,9177.76,0.19]]'), ('103','1675','[-100.91,[1032.7,9170.17]]'), ('103','1675','[-122.3,[1035.96,9162.1]]'), ('103','1675','[38.39,[1041.75,9155.79]]'), ('103','1675','[5.1,[1049.61,9152.76]]'), ('103','1675','[-16.28,[1058.02,9153.92]]'), ('103','1675','[-124.82,[1064.13,9150.51]]'), ('103','1675','[34.92,[1070.45,9144.7]]'), ('103','1675','[18.49,[1078.16,9141.04]]'), ('103','1675','[-2.92,[1086.55,9139.9]]'), ('103','1675','[-19.52,[1095.01,9141.86]]'), ('103','1675','[-136.07,[1101.58,9139.12]]'), ('103','1675','[25.27,[1108.8,9134.35]]'), ('103','1675','[19.25,[1116.59,9131.25]]'), ('103','1675','[-139.92,[1123.74,9127.12]]'), ('103','1675','[-4.22,[1131.75,9125.16]]'), ('103','1675','[-61.54,[1138.13,9129.71]]'), ('103','1675','[-27.2,[1143.55,9135.79]]'), ('103','1675','[-51.09,[1149.89,9141.49]]'), ('103','1675','[-69.75,[1153.9,9148.61]]'), ('103','1675','[58.38,[1152.6,9156.46]]'), ('103','1675','[-124.04,[1147.43,9163.28]]'), ('103','1675','[31.44,[1141.2,9169.03]]'), ('103','1675','[-141.1,[1133.88,9173.82]]'), ('104','1675','[-136.82,[1127.52,9180.16]]'), ('103','1675','[-136.77,[1131.73,9175.58]]'), ('105','1675','[0,[1120.31,9191.56,2.44]]'), ('106','1675','[0,[1068.93,9198.2]]'), ('106','1675','[0,[1079.6,9180.36]]'), ('107','1675','[-209.58,[1058.64,9217.86]]'), ('107','1675','[-103.7,[1117.48,9192.89]]'), ('108','1675','[-157.72,[1088.06,9157.13,0.86]]'), ('108','1675','[-184.31,[1113.94,9140.79,0.66]]'), ('108','1675','[-204.61,[1142.24,9154.11,0.63]]'), ('109','1675','[-93.3,[1057.16,9206.43,0.41]]'), ('110','1675','[0,[1056.15,9204.08]]'), ('111','1675','[29.55,[1055.78,9203.59,0.85]]'), ('112','1675','[-6.64,[1055.83,9204.29,0.84]]'), ('113','1675','[-89.94,[1056.3,9203.96,0.84]]'), ('114','1675','[115.47,[1057.62,9208.5,-0.01]]'), ('115','1675','[-105.91,[1056.12,9197.2]]'), ('116','1675','[0,[1058.42,9201.85]]'), ('117','1675','[0,[1055.65,9197.14]]'), ('118','1675','[-86.46,[1050.54,9196.43]]'), ('119','1675','[0,[1078.47,9145.32]]'), ('120','1675','[-72.02,[1052.63,9218.18]]'), ('121','1675','[202.79,[1108.55,9193.58]]'), ('122','1675','[-126.55,[1063.63,9165.81,0.54]]'), ('123','1675','[-145.61,[1055.78,9187.22,0.54]]');
When adding this below to instance_buildings how can i stop the duplicate entry if i need to add more of the same building.
INSERT INTO `database`.`building` (`id`, `class_name`) VALUES ('103','Land_HBarrier_large'), ('104','Land_BarGate2'), ('105','FlagCarrierBAF'), ('106','HeliHCivil'), ('107','Land_Misc_deerstand'), ('108','Land_CamoNetB_EAST'), ('109','Land_CamoNetVar_EAST'), ('110','Land_Table_EP1'), ('111','FoodBox1'), ('112','MedBox0'), ('113','Laptop_EP1'), ('114','MASH'), ('115','Land_covering_hut_big_EP1'), ('116','Land_Campfire_burning'), ('117','Barrels'), ('118','Land_Toilet'), ('119','Land_Ind_IlluminantTower'), ('120','Land_radar_EP1'), ('121','76n6ClamShell_EP1'), ('122','Land_Barrack2_EP1'), ('123','Barrack2');
INSERT INTO `database`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('103','1675','[59.92,[1123.06,9184.57,0.06]]'), ('103','1675','[83.39,[1120.35,9192.46,0.11]]'), ('103','1675','[-75.1,[1120.83,9201.04,0.33]]'), ('103','1675','[-94.63,[1121.14,9209.34,0.35]]'), ('103','1675','[47.32,[1117.8,9217.08,0.12]]'), ('103','1675','[42.95,[1111.68,9223.07]]'), ('103','1675','[22.79,[1104.59,9227.29,0.07]]'), ('103','1675','[7.32,[1096.48,9229.49,0.11]]'), ('103','1675','[0,[1088.04,9229.83]]'), ('103','1675','[0,[1079.84,9229.61]]'), ('103','1675','[-9.15,[1071.42,9228.83]]'), ('103','1675','[-31.63,[1063.25,9225.82]]'), ('103','1675','[-24.14,[1055.97,9221.31]]'), ('103','1675','[-11.38,[1047.99,9218.46]]'), ('103','1675','[-22.07,[1039.98,9215.86]]'), ('103','1675','[-75.95,[1035.76,9209.5]]'), ('103','1675','[-54.64,[1032.5,9201.93]]'), ('103','1675','[-68.73,[1028.67,9194.32,0.1]]'), ('103','1675','[-84.51,[1026.85,9185.88]]'), ('103','1675','[-122.85,[1029,9177.76,0.19]]'), ('103','1675','[-100.91,[1032.7,9170.17]]'), ('103','1675','[-122.3,[1035.96,9162.1]]'), ('103','1675','[38.39,[1041.75,9155.79]]'), ('103','1675','[5.1,[1049.61,9152.76]]'), ('103','1675','[-16.28,[1058.02,9153.92]]'), ('103','1675','[-124.82,[1064.13,9150.51]]'), ('103','1675','[34.92,[1070.45,9144.7]]'), ('103','1675','[18.49,[1078.16,9141.04]]'), ('103','1675','[-2.92,[1086.55,9139.9]]'), ('103','1675','[-19.52,[1095.01,9141.86]]'), ('103','1675','[-136.07,[1101.58,9139.12]]'), ('103','1675','[25.27,[1108.8,9134.35]]'), ('103','1675','[19.25,[1116.59,9131.25]]'), ('103','1675','[-139.92,[1123.74,9127.12]]'), ('103','1675','[-4.22,[1131.75,9125.16]]'), ('103','1675','[-61.54,[1138.13,9129.71]]'), ('103','1675','[-27.2,[1143.55,9135.79]]'), ('103','1675','[-51.09,[1149.89,9141.49]]'), ('103','1675','[-69.75,[1153.9,9148.61]]'), ('103','1675','[58.38,[1152.6,9156.46]]'), ('103','1675','[-124.04,[1147.43,9163.28]]'), ('103','1675','[31.44,[1141.2,9169.03]]'), ('103','1675','[-141.1,[1133.88,9173.82]]'), ('104','1675','[-136.82,[1127.52,9180.16]]'), ('103','1675','[-136.77,[1131.73,9175.58]]'), ('105','1675','[0,[1120.31,9191.56,2.44]]'), ('106','1675','[0,[1068.93,9198.2]]'), ('106','1675','[0,[1079.6,9180.36]]'), ('107','1675','[-209.58,[1058.64,9217.86]]'), ('107','1675','[-103.7,[1117.48,9192.89]]'), ('108','1675','[-157.72,[1088.06,9157.13,0.86]]'), ('108','1675','[-184.31,[1113.94,9140.79,0.66]]'), ('108','1675','[-204.61,[1142.24,9154.11,0.63]]'), ('109','1675','[-93.3,[1057.16,9206.43,0.41]]'), ('110','1675','[0,[1056.15,9204.08]]'), ('111','1675','[29.55,[1055.78,9203.59,0.85]]'), ('112','1675','[-6.64,[1055.83,9204.29,0.84]]'), ('113','1675','[-89.94,[1056.3,9203.96,0.84]]'), ('114','1675','[115.47,[1057.62,9208.5,-0.01]]'), ('115','1675','[-105.91,[1056.12,9197.2]]'), ('116','1675','[0,[1058.42,9201.85]]'), ('117','1675','[0,[1055.65,9197.14]]'), ('118','1675','[-86.46,[1050.54,9196.43]]'), ('119','1675','[0,[1078.47,9145.32]]'), ('120','1675','[-72.02,[1052.63,9218.18]]'), ('121','1675','[202.79,[1108.55,9193.58]]'), ('122','1675','[-126.55,[1063.63,9165.81,0.54]]'), ('123','1675','[-145.61,[1055.78,9187.22,0.54]]');