Skip to content

Instantly share code, notes, and snippets.

@cessien
Created December 8, 2022 21:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cessien/a85cf9e025ca540b0f48fcacc5cc4fba to your computer and use it in GitHub Desktop.
Save cessien/a85cf9e025ca540b0f48fcacc5cc4fba to your computer and use it in GitHub Desktop.
umm wtf
INSERT INTO "retailer_audits" ("created_at","updated_at","deleted_at","site_id","old_site_id","old_dba","old_street_address","old_city","old_county","old_postal_code","old_status","new_site_id","new_dba","new_street_address","new_city","new_county","new_postal_code","new_status","audited","audited_by","approved") VALUES ('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,29277,0,'','','','','','',29277,'Wine Cellar','36 State Route 239 N','Hickman','Fulton','','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,32016,0,'','','','','','',32016,'Redpoint BBQ','356 Jim Smith Road','Rogers','Wolfe','','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,29507,29507,'DOLLAR GENERAL #20954','4801 LAST CHANCE TRAIL','LEXINGTON','LEX','40511','active',29507,'Dollar General Store No. 20954','4801 Last Chance Trl','Lexington','Fayette','','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,30379,0,'','','','','','',30379,'EL BURRITO LOCO MEXICAN GRILL INC','Bullitt County','','Bullitt','','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,14731,0,'','','','','','',14731,'Walgreens #12076','512 W Main St','Lebanon','Marion','40003','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,15446,0,'','','','','','',15446,'All The Way Shoppe','2164 Cedarmore Rd','Bagdad','Shelby','40003','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,24513,0,'','','','','','',24513,'B&N Food Market LLC','5945 Elmburg Rd','Bagdad','Shelby','40003','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,10616,0,'','','','','','',10616,'Kreso\'s Restaurant','216 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,16183,0,'','','','','','',16183,'Primo','120 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,33412,0,'','','','','','',33412,'861344011','2805 Poplar Flat Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,30212,0,'','','','','','',30212,'At Mary\'s','116 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,1760,0,'','','','','','',1760,'Fast Mart','1151 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,12379,0,'','','','','','',12379,'El Jimador','1009 Granite Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,4102,0,'','','','','','',4102,'Heaven Hill Inc','1064 Loretto Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,27795,0,'','','','','','',27795,'Meri Merlo','118 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,4747,0,'','','','','','',4747,'Ballard Inc','128 Banjo St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,7337,0,'','','','','','',7337,'Speedy Mart','603 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,253,0,'','','','','','',253,'Umami Sushi','942 Chambers Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,22648,0,'','','','','','',22648,'La Herradura','959 Morton Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,2458,0,'','','','','','',2458,'Shorty\'s Bar','133 Banjo St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,17131,0,'','','','','','',17131,'On The Go Foods','900 Nutter Drive, Ste B','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,13735,0,'','','','','','',13735,'Whiskeycraft','426 Sutherland Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,16491,0,'','','','','','',16491,'Xavier\'s Pub','169 Mulberry Aly','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,27878,27878,'SHAQ & COCO LLC','111 N 3RD ST. STE 101,105','BARDSTOWN','NLS','40004','active',27878,'Shaq & Coco LLC','111 N 3rd St Ste 101, 105','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,6677,0,'','','','','','',6677,'Bourbon Manor','714 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,115,0,'','','','','','',115,'Sai Petro Inc','450 E Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,6902,0,'','','','','','',6902,'Toogies Table','418 E Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,16872,16872,'BARDSTOWN BOURBON LIQUORS','722 N 3RD ST','BARDSTOWN','NLS','40004','active',16872,'Xpress Liquor','987 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,8962,0,'','','','','','',8962,'FiveStar #1550','2590 Springfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,26695,0,'','','','','','',26695,'Fivestar #1500','1405 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,1646,0,'','','','','','',1646,'Side Trax, LLC','624 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,16330,0,'','','','','','',16330,'Strong Spirits','999 Withrow Ct','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,21965,21965,'3RD STREET TAP HOUSE','112 N 3RD ST','BARDSTOWN','NLS','40004','active',21965,'3rd Street Tap House','112 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,7509,7509,'TODDY\'S LIQUORS','110 S. 4TH ST.','BARDSTOWN','NLS','40004','active',7509,'Toddy\'s Liquors','110 S 4th St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,1007,1007,'TALBOTT TAVERN','107 W STEPHEN FOSTER AVE','BARDSTOWN','NLS','40004','active',1007,'Talbott Tavern','107 W Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,32895,0,'','','','','','',32895,'DB Trucking LLC','4002 Boston Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,7254,0,'','','','','','',7254,'Handy Food Mart','3945 New Shepherdsville Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,24324,0,'','','','','','',24324,'Bardstown Burger','126 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,13437,13437,'KROGER L-408 LIQUOR','102-A W JOHN ROWAN BLVD','BARDSTOWN','NLS','40004','active',13437,'Kroger L-408 Liquor','102-A W John Rowan Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,1825,0,'','','','','','',1825,'Kroger Store #l-408','102 W John Rowan Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,14380,0,'','','','','','',14380,'Bj\'s Bar & Grill','201 Camptown Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,7032,0,'','','','','','',7032,'Bluegrass Tavern','2340 New Haven Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,2988,0,'','','','','','',2988,'East 31 Foodmart','706 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,8117,8117,'WINBURN FRUIT SUPER MERCA','1198 WINBURN DR.','LEXINGTON','LEX','40511','active',8117,'H & S Minit Mart','4598 Springfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,12097,0,'','','','','','',12097,'Keystone Liquors','130 Keystone Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,33998,0,'','','','','','',33998,'Mad Dash Courier','3250 Buchannan Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,14824,0,'','','','','','',14824,'Walgreens #11307','824 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,2500,0,'','','','','','',2500,'Bardstown Express','985 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,753,0,'','','','','','',753,'Circle K #4703332','1085 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,23067,0,'','','','','','',23067,'S&S Packaging LLC','940 Withrow Ct','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,6725,0,'','','','','','',6725,'Mammys Kitchen, LLC','116 W Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,25572,0,'','','','','','',25572,'Lux Row Distillers','3050 E John Rowan Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,12007,0,'','','','','','',12007,'Chili\'s Grill & Bar','3796 E John Rowan Blvd Ste A','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,20768,0,'','','','','','',20768,'Harvest Express Inc','1192 Stoner Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,23053,0,'','','','','','',23053,'Think Packaging LLC','134 Banjo St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,6862,0,'','','','','','',6862,'American Legion #121','206 W Broadway St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,28704,0,'','','','','','',28704,'Family Dollar #21154','632 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,15674,0,'','','','','','',15674,'Harrison-Smith House','103 E Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,8212,0,'','','','','','',8212,'Bart\'s Mart','100 Springfield Rd','Bloomfield','Nelson','40008','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,23781,0,'','','','','','',23781,'My Old Kentucky Home','501 E Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,2987,0,'','','','','','',2987,'Thompson\'s Food Mart','509 W Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,1441,1441,'ANDOVER B.P.','3100 MAPLE LEAF DR.','LEXINGTON','LEX','40509','active',1441,'Andover BP','3100 Mapleleaf Dr','Lexington','Fayette','40509','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,25068,0,'','','','','','',25068,'Preservation Distillery Bottling/Storage','910 W Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,14228,0,'','','','','','',14228,'McIntyre\'s Winery & Berries','585 Mcintyre Ln','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,7812,0,'','','','','','',7812,'Smith Brothers Trucking Inc','Po Box 848','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,34652,0,'','','','','','',34652,'Bardstown Motor Lodge','422 E Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,2508,2508,'THE RICKHOUSE RESTAURANT','112 XAVIER DR.','BARDSTOWN','NLS','40004','active',2508,'The Rickhouse Restaurant & Lounge','112 Xavier Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,35007,0,'','','','','','',35007,'Bourbon Trail Liquors','722 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,14008,0,'','','','','','',14008,'Buffalo Wings & Rings','1012 Granite Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,6895,0,'','','','','','',6895,'Cedar-Fil Golf Course','2330 New Shepherdsville Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,26645,0,'','','','','','',26645,'the volstead bourbon lounge','107 E Flaget St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,7314,0,'','','','','','',7314,'Milantoni Italian Restaurant','1008 Commerce Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,27848,0,'','','','','','',27848,'Mi Lindo Cuernavaca 2','622 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,8607,8607,'MY OLD KY DINNER TRAIN','602 N 3RD ST','BARDSTOWN','NLS','40004','active',8607,'My Old Kentucky Dinner Train','602 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,34292,0,'','','','','','',34292,'The Blind Boar Shanty','204 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,12110,12110,'BARDSTOWN LIQ. WORLD','93 N. SALEM DR.','BARDSTOWN','NLS','40004','active',12110,'Bardstown Liquor World','93 N Salem Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,22955,0,'','','','','','',22955,'Barton 1792 Distillery','924 Withrow Ct','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,4490,0,'','','','','','',4490,'Kentucky Bourbon Distillers, Ltd.','1869 Loretto Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,4086,0,'','','','','','',4086,'Barton 1792 Distillery','300 Barton Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,19339,0,'','','','','','',19339,'Barton 1792 Distillery','1010 Withrow Ct','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,26173,0,'','','','','','',26173,'Brazen Bull Steakhouse','131 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,29654,0,'','','','','','',29654,'County Line Distillers','800 American Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,26451,26451,'THE BLIND PIG BOURBON MAR','212 N 3RD ST','BARDSTOWN','NLS','40004','active',26451,'The Blind Pig Bourbon Market','212 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,1076,0,'','','','','','',1076,'El Patron Mexican Grill','885 Pennsylvania Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,9,0,'','','','','','',9,'Trade Winds Transit Inc','1065 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,16871,16871,'BARDSTOWN WINE & SPIRITS','5201 SPRINGFIELD RD','BARDSTOWN','NLS','40004','active',16871,'Bardstown Wine & Spirits','5201 Springfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,2986,0,'','','','','','',2986,'Bourbon Brick Oven Grill','966 Chambers Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,18277,0,'','','','','','',18277,'Dollar General Store #81','975 Bloomfield Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,33441,0,'','','','','','',33441,'Bardstown Bourbon Company','924 Withrow Court, Suite A','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,29003,0,'','','','','','',29003,'Bullitt\'s Winery & Bistro','124 N 3rd St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,1083,0,'','','','','','',1083,'Five Star Food Mart #1135','1855 New Haven Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,8186,0,'','','','','','',8186,'Five Star Food Mart #1493','207 W John Rowan Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,7702,0,'','','','','','',7702,'Five Star Food Mart #1851','122 E Stephen Foster Ave','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,29679,0,'','','','','','',29679,'The Blind Pig Bourbon B&B','110 E Broadway St','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,10894,0,'','','','','','',10894,'Wal-Mart Supercenter #0729','3795 E John Rowan Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,33965,0,'','','','','','',33965,'BOURBON CITY TRANSPORT INC ','126 Laurel Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,13563,0,'','','','','','',13563,'Cinco De Mayo Mexican Grill','145 Parkway Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,17997,0,'','','','','','',17997,'Dollar General Store #12017','100 W John Rowan Blvd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,24007,0,'','','','','','',24007,'Jacks or Better Express LLC','3288 Bellwood Rd','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false),('2022-12-08 16:33:31.061','2022-12-08 16:33:31.061',NULL,23492,0,'','','','','','',23492,'Coltons Steak House and Grill','1001 Granite Dr','Bardstown','Nelson','40004','','2022-12-08 16:33:31.061','',false) ON CONFLICT ("old_site_id","new_site_id") DO UPDATE SET "updated_at"='2022-12-08 16:33:31.061',"audited"='2022-12-08 16:33:31.061',"deleted_at"="excluded"."deleted_at","site_id"="excluded"."site_id","old_site_id"="excluded"."old_site_id","old_dba"="excluded"."old_dba","old_street_address"="excluded"."old_street_address","old_city"="excluded"."old_city","old_county"="excluded"."old_county","old_postal_code"="excluded"."old_postal_code","old_status"="excluded"."old_status","new_site_id"="excluded"."new_site_id","new_dba"="excluded"."new_dba","new_street_address"="excluded"."new_street_address","new_city"="excluded"."new_city","new_county"="excluded"."new_county","new_postal_code"="excluded"."new_postal_code","new_status"="excluded"."new_status","audited_by"="excluded"."audited_by","approved"="excluded"."approved" RETURNING "id"
2022/12/08 16:33:31 failed to create audit record batch: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification (SQLSTATE 42P10)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment