Advertisement
viettiennguyen029

Update BSC Template ID value

Dec 3rd, 2021
2,959
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.84 KB | None | 0 0
  1. UPDATE templates SET id = CASE
  2.     WHEN name = 'succeeded_purchase_buyer' THEN 'd-33dce308b853406ead9f70ad30f7155e'
  3.     WHEN name = 'succeeded_purchase_seller' THEN 'd-f698754910f448b8b32f1a0ecdc529ba'
  4.     WHEN name = 'auction_winner_buyer' THEN 'd-9667ccec3bec4c2b9075b000584a9f5c'
  5.     WHEN name = 'auction_winner_seller' THEN 'd-68b5e82bbdfa47bcbb3d96a2ec202e78'
  6.     WHEN name = 'auction_has_no_bids_seller' THEN 'd-c9fd609a5dbe406ab4ff23f2fdb80ce2'
  7.     WHEN name = 'auction_bid_is_not_the_highest_buyer' THEN 'd-49ae3a3e2739430d9c2047e5720d3be2'
  8.     WHEN name = 'auction_reserved_price_not_met_buyer' THEN 'd-faeb61996b624d2693f885a8a58615db'
  9.     WHEN name = 'auction_reserved_price_not_met_seller' THEN 'd-6fa14bb647124a64a36022593a8bf761'
  10.     WHEN name = 'auction_no_winner_payed' THEN 'd-4bdecbd113ac4b3ea7e0e506c99ae7fa'
  11. END
  12. WHERE name <> '';
  13.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement