Skip to content

Instantly share code, notes, and snippets.

@esttorhe
Forked from bgreenlee/dash_emoji_snippets.sql
Created October 8, 2015 17:23

Revisions

  1. @bgreenlee bgreenlee revised this gist Oct 26, 2013. 1 changed file with 849 additions and 849 deletions.
    1,698 changes: 849 additions & 849 deletions dash_emoji_snippets.sql
    Original file line number Diff line number Diff line change
    @@ -1,849 +1,849 @@
    INSERT INTO 'snippets'
    select 487 as 'sid', ':musical_note:' as 'title', '🎵' as 'body', 'None' as 'syntax', 0 as 'usageCount'
    union select 488, ':musical_score:', '🎼', 'None', 0
    union select 489, ':mute:', '🔇', 'None', 0
    union select 490, ':nail_care:', '💅', 'None', 0
    union select 491, ':name_badge:', '📛', 'None', 0
    union select 492, ':necktie:', '👔', 'None', 0
    union select 493, ':negative_squared_cross_mark:', '', 'None', 0
    union select 494, ':neutral_face:', '😐', 'None', 0
    union select 495, ':new:', '🆕', 'None', 0
    union select 496, ':new_moon:', '🌑', 'None', 0
    union select 497, ':new_moon_with_face:', '🌚', 'None', 0
    union select 498, ':newspaper:', '📰', 'None', 0
    union select 499, ':ng:', '🆖', 'None', 0
    union select 500, ':no_bell:', '🔕', 'None', 0
    union select 501, ':no_bicycles:', '🚳', 'None', 0
    union select 502, ':no_entry:', '', 'None', 0
    union select 503, ':no_entry_sign:', '🚫', 'None', 0
    union select 504, ':no_good:', '🙅', 'None', 0
    union select 505, ':no_mobile_phones:', '📵', 'None', 0
    union select 506, ':no_mouth:', '😶', 'None', 0
    union select 507, ':no_pedestrians:', '🚷', 'None', 0
    union select 508, ':no_smoking:', '🚭', 'None', 0
    union select 509, ':non-potable_water:', '🚱', 'None', 0
    union select 510, ':nose:', '👃', 'None', 0
    union select 511, ':notebook:', '📓', 'None', 0
    union select 512, ':notebook_with_decorative_cover:', '📔', 'None', 0
    union select 513, ':notes:', '🎶', 'None', 0
    union select 514, ':nut_and_bolt:', '🔩', 'None', 0
    union select 515, ':o:', '', 'None', 0
    union select 516, ':o2:', '🅾', 'None', 0
    union select 517, ':ocean:', '🌊', 'None', 0
    union select 518, ':octopus:', '🐙', 'None', 0
    union select 519, ':oden:', '🍢', 'None', 0
    union select 520, ':office:', '🏢', 'None', 0
    union select 521, ':ok:', '🆗', 'None', 0
    union select 522, ':ok_hand:', '👌', 'None', 0
    union select 523, ':ok_woman:', '🙆', 'None', 0
    union select 524, ':older_man:', '👴', 'None', 0
    union select 525, ':older_woman:', '👵', 'None', 0
    union select 526, ':on:', '🔛', 'None', 0
    union select 527, ':oncoming_automobile:', '🚘', 'None', 0
    union select 528, ':oncoming_bus:', '🚍', 'None', 0
    union select 529, ':oncoming_police_car:', '🚔', 'None', 0
    union select 530, ':oncoming_taxi:', '🚖', 'None', 0
    union select 531, ':open_book:', '📖', 'None', 0
    union select 532, ':open_file_folder:', '📂', 'None', 0
    union select 533, ':open_hands:', '👐', 'None', 0
    union select 534, ':open_mouth:', '😮', 'None', 0
    union select 535, ':ophiuchus:', '', 'None', 0
    union select 536, ':orange_book:', '📙', 'None', 0
    union select 537, ':outbox_tray:', '📤', 'None', 0
    union select 538, ':ox:', '🐂', 'None', 0
    union select 539, ':package:', '📦', 'None', 0
    union select 540, ':page_facing_up:', '📄', 'None', 0
    union select 541, ':page_with_curl:', '📃', 'None', 0
    union select 542, ':pager:', '📟', 'None', 0
    union select 543, ':palm_tree:', '🌴', 'None', 0
    union select 544, ':panda_face:', '🐼', 'None', 0
    union select 545, ':paperclip:', '📎', 'None', 0
    union select 546, ':parking:', '🅿', 'None', 0
    union select 547, ':part_alternation_mark:', '', 'None', 0
    union select 548, ':partly_sunny:', '', 'None', 0
    union select 549, ':passport_control:', '🛂', 'None', 0
    union select 550, ':paw_prints:', '🐾', 'None', 0
    union select 551, ':peach:', '🍑', 'None', 0
    union select 552, ':pear:', '🍐', 'None', 0
    union select 553, ':pencil:', '📝', 'None', 0
    union select 554, ':pencil2:', '', 'None', 0
    union select 555, ':penguin:', '🐧', 'None', 0
    union select 556, ':pensive:', '😔', 'None', 0
    union select 557, ':performing_arts:', '🎭', 'None', 0
    union select 558, ':persevere:', '😣', 'None', 0
    union select 559, ':person_frowning:', '🙍', 'None', 0
    union select 560, ':person_with_blond_hair:', '👱', 'None', 0
    union select 561, ':person_with_pouting_face:', '🙎', 'None', 0
    union select 562, ':phone:', '', 'None', 0
    union select 563, ':pig:', '🐷', 'None', 0
    union select 564, ':pig2:', '🐖', 'None', 0
    union select 565, ':pig_nose:', '🐽', 'None', 0
    union select 566, ':pill:', '💊', 'None', 0
    union select 567, ':pineapple:', '🍍', 'None', 0
    union select 568, ':pisces:', '', 'None', 0
    union select 569, ':pizza:', '🍕', 'None', 0
    union select 570, ':point_down:', '👇', 'None', 0
    union select 571, ':point_left:', '👈', 'None', 0
    union select 572, ':point_right:', '👉', 'None', 0
    union select 573, ':point_up:', '', 'None', 0
    union select 574, ':point_up_2:', '👆', 'None', 0
    union select 575, ':police_car:', '🚓', 'None', 0
    union select 576, ':poodle:', '🐩', 'None', 0
    union select 577, ':poop:', '💩', 'None', 0
    union select 578, ':post_office:', '🏣', 'None', 0
    union select 579, ':postal_horn:', '📯', 'None', 0
    union select 580, ':postbox:', '📮', 'None', 0
    union select 581, ':potable_water:', '🚰', 'None', 0
    union select 582, ':pouch:', '👝', 'None', 0
    union select 583, ':poultry_leg:', '🍗', 'None', 0
    union select 584, ':pound:', '💷', 'None', 0
    union select 585, ':pouting_cat:', '😾', 'None', 0
    union select 586, ':pray:', '🙏', 'None', 0
    union select 587, ':princess:', '👸', 'None', 0
    union select 588, ':punch:', '👊', 'None', 0
    union select 589, ':purple_heart:', '💜', 'None', 0
    union select 590, ':purse:', '👛', 'None', 0
    union select 591, ':pushpin:', '📌', 'None', 0
    union select 592, ':put_litter_in_its_place:', '🚮', 'None', 0
    union select 593, ':question:', '', 'None', 0
    union select 594, ':rabbit:', '🐰', 'None', 0
    union select 595, ':rabbit2:', '🐇', 'None', 0
    union select 596, ':racehorse:', '🐎', 'None', 0
    union select 597, ':radio:', '📻', 'None', 0
    union select 598, ':radio_button:', '🔘', 'None', 0
    union select 599, ':rage:', '😡', 'None', 0
    union select 600, ':railway_car:', '🚃', 'None', 0
    union select 601, ':rainbow:', '🌈', 'None', 0
    union select 602, ':raised_hand:', '', 'None', 0
    union select 603, ':raised_hands:', '🙌', 'None', 0
    union select 604, ':raising_hand:', '🙋', 'None', 0
    union select 605, ':ram:', '🐏', 'None', 0
    union select 606, ':ramen:', '🍜', 'None', 0
    union select 607, ':rat:', '🐀', 'None', 0
    union select 608, ':recycle:', '', 'None', 0
    union select 609, ':red_car:', '🚗', 'None', 0
    union select 610, ':red_circle:', '🔴', 'None', 0
    union select 611, ':registered:', '®', 'None', 0
    union select 612, ':relaxed:', '', 'None', 0
    union select 613, ':relieved:', '😌', 'None', 0
    union select 614, ':repeat:', '🔁', 'None', 0
    union select 615, ':repeat_one:', '🔂', 'None', 0
    union select 616, ':restroom:', '🚻', 'None', 0
    union select 617, ':revolving_hearts:', '💞', 'None', 0
    union select 618, ':rewind:', '', 'None', 0
    union select 619, ':ribbon:', '🎀', 'None', 0
    union select 620, ':rice:', '🍚', 'None', 0
    union select 621, ':rice_ball:', '🍙', 'None', 0
    union select 622, ':rice_cracker:', '🍘', 'None', 0
    union select 623, ':rice_scene:', '🎑', 'None', 0
    union select 624, ':ring:', '💍', 'None', 0
    union select 625, ':rocket:', '🚀', 'None', 0
    union select 626, ':roller_coaster:', '🎢', 'None', 0
    union select 627, ':rooster:', '🐓', 'None', 0
    union select 628, ':rose:', '🌹', 'None', 0
    union select 629, ':rotating_light:', '🚨', 'None', 0
    union select 630, ':round_pushpin:', '📍', 'None', 0
    union select 631, ':rowboat:', '🚣', 'None', 0
    union select 632, ':rugby_football:', '🏉', 'None', 0
    union select 633, ':runner:', '🏃', 'None', 0
    union select 634, ':running:', '🏃', 'None', 0
    union select 635, ':running_shirt_with_sash:', '🎽', 'None', 0
    union select 636, ':sa:', '🈂', 'None', 0
    union select 637, ':sagittarius:', '', 'None', 0
    union select 638, ':sailboat:', '', 'None', 0
    union select 639, ':sake:', '🍶', 'None', 0
    union select 640, ':sandal:', '👡', 'None', 0
    union select 641, ':santa:', '🎅', 'None', 0
    union select 642, ':satellite:', '📡', 'None', 0
    union select 643, ':satisfied:', '😆', 'None', 0
    union select 644, ':saxophone:', '🎷', 'None', 0
    union select 645, ':school:', '🏫', 'None', 0
    union select 646, ':school_satchel:', '🎒', 'None', 0
    union select 647, ':scissors:', '', 'None', 0
    union select 648, ':scorpius:', '', 'None', 0
    union select 649, ':scream:', '😱', 'None', 0
    union select 650, ':scream_cat:', '🙀', 'None', 0
    union select 651, ':scroll:', '📜', 'None', 0
    union select 652, ':seat:', '💺', 'None', 0
    union select 653, ':secret:', '', 'None', 0
    union select 654, ':see_no_evil:', '🙈', 'None', 0
    union select 655, ':seedling:', '🌱', 'None', 0
    union select 656, ':shaved_ice:', '🍧', 'None', 0
    union select 657, ':sheep:', '🐑', 'None', 0
    union select 658, ':shell:', '🐚', 'None', 0
    union select 659, ':ship:', '🚢', 'None', 0
    union select 660, ':shirt:', '👕', 'None', 0
    union select 661, ':shit:', '💩', 'None', 0
    union select 662, ':shoe:', '👞', 'None', 0
    union select 663, ':shower:', '🚿', 'None', 0
    union select 664, ':signal_strength:', '📶', 'None', 0
    union select 665, ':six_pointed_star:', '🔯', 'None', 0
    union select 666, ':ski:', '🎿', 'None', 0
    union select 667, ':skull:', '💀', 'None', 0
    union select 668, ':sleeping:', '😴', 'None', 0
    union select 669, ':sleepy:', '😪', 'None', 0
    union select 670, ':slot_machine:', '🎰', 'None', 0
    union select 671, ':small_blue_diamond:', '🔹', 'None', 0
    union select 672, ':small_orange_diamond:', '🔸', 'None', 0
    union select 673, ':small_red_triangle:', '🔺', 'None', 0
    union select 674, ':small_red_triangle_down:', '🔻', 'None', 0
    union select 675, ':smile:', '😄', 'None', 0
    union select 676, ':smile_cat:', '😸', 'None', 0
    union select 677, ':smiley:', '😃', 'None', 0
    union select 678, ':smiley_cat:', '😺', 'None', 0
    union select 679, ':smiling_imp:', '😈', 'None', 0
    union select 680, ':smirk:', '😏', 'None', 0
    union select 681, ':smirk_cat:', '😼', 'None', 0
    union select 682, ':smoking:', '🚬', 'None', 0
    union select 683, ':snail:', '🐌', 'None', 0
    union select 684, ':snake:', '🐍', 'None', 0
    union select 685, ':snowboarder:', '🏂', 'None', 0
    union select 686, ':snowflake:', '', 'None', 0
    union select 687, ':snowman:', '', 'None', 0
    union select 688, ':sob:', '😭', 'None', 0
    union select 689, ':soccer:', '', 'None', 0
    union select 690, ':soon:', '🔜', 'None', 0
    union select 691, ':sos:', '🆘', 'None', 0
    union select 692, ':sound:', '🔉', 'None', 0
    union select 693, ':space_invader:', '👾', 'None', 0
    union select 694, ':spades:', '', 'None', 0
    union select 695, ':spaghetti:', '🍝', 'None', 0
    union select 696, ':sparkle:', '', 'None', 0
    union select 697, ':sparkler:', '🎇', 'None', 0
    union select 698, ':sparkles:', '', 'None', 0
    union select 699, ':sparkling_heart:', '💖', 'None', 0
    union select 700, ':speak_no_evil:', '🙊', 'None', 0
    union select 701, ':speaker:', '🔊', 'None', 0
    union select 702, ':speech_balloon:', '💬', 'None', 0
    union select 703, ':speedboat:', '🚤', 'None', 0
    union select 704, ':star:', '', 'None', 0
    union select 705, ':star2:', '🌟', 'None', 0
    union select 706, ':stars:', '🌃', 'None', 0
    union select 707, ':station:', '🚉', 'None', 0
    union select 708, ':statue_of_liberty:', '🗽', 'None', 0
    union select 709, ':steam_locomotive:', '🚂', 'None', 0
    union select 710, ':stew:', '🍲', 'None', 0
    union select 711, ':straight_ruler:', '📏', 'None', 0
    union select 712, ':strawberry:', '🍓', 'None', 0
    union select 713, ':stuck_out_tongue:', '😛', 'None', 0
    union select 714, ':stuck_out_tongue_closed_eyes:', '😝', 'None', 0
    union select 715, ':stuck_out_tongue_winking_eye:', '😜', 'None', 0
    union select 716, ':sun_with_face:', '🌞', 'None', 0
    union select 717, ':sunflower:', '🌻', 'None', 0
    union select 718, ':sunglasses:', '😎', 'None', 0
    union select 719, ':sunny:', '', 'None', 0
    union select 720, ':sunrise:', '🌅', 'None', 0
    union select 721, ':sunrise_over_mountains:', '🌄', 'None', 0
    union select 722, ':surfer:', '🏄', 'None', 0
    union select 723, ':sushi:', '🍣', 'None', 0
    union select 724, ':suspension_railway:', '🚟', 'None', 0
    union select 725, ':sweat:', '😓', 'None', 0
    union select 726, ':sweat_drops:', '💦', 'None', 0
    union select 727, ':sweat_smile:', '😅', 'None', 0
    union select 728, ':sweet_potato:', '🍠', 'None', 0
    union select 729, ':swimmer:', '🏊', 'None', 0
    union select 730, ':symbols:', '🔣', 'None', 0
    union select 731, ':syringe:', '💉', 'None', 0
    union select 732, ':tada:', '🎉', 'None', 0
    union select 733, ':tanabata_tree:', '🎋', 'None', 0
    union select 734, ':tangerine:', '🍊', 'None', 0
    union select 735, ':taurus:', '', 'None', 0
    union select 736, ':taxi:', '🚕', 'None', 0
    union select 737, ':tea:', '🍵', 'None', 0
    union select 738, ':telephone:', '', 'None', 0
    union select 739, ':telephone_receiver:', '📞', 'None', 0
    union select 740, ':telescope:', '🔭', 'None', 0
    union select 741, ':tennis:', '🎾', 'None', 0
    union select 742, ':tent:', '', 'None', 0
    union select 743, ':thought_balloon:', '💭', 'None', 0
    union select 744, ':thumbsdown:', '👎', 'None', 0
    union select 745, ':thumbsup:', '👍', 'None', 0
    union select 746, ':ticket:', '🎫', 'None', 0
    union select 747, ':tiger:', '🐯', 'None', 0
    union select 748, ':tiger2:', '🐅', 'None', 0
    union select 749, ':tired_face:', '😫', 'None', 0
    union select 750, ':tm:', '', 'None', 0
    union select 751, ':toilet:', '🚽', 'None', 0
    union select 752, ':tokyo_tower:', '🗼', 'None', 0
    union select 753, ':tomato:', '🍅', 'None', 0
    union select 754, ':tongue:', '👅', 'None', 0
    union select 755, ':top:', '🔝', 'None', 0
    union select 756, ':tophat:', '🎩', 'None', 0
    union select 757, ':tractor:', '🚜', 'None', 0
    union select 758, ':traffic_light:', '🚥', 'None', 0
    union select 759, ':train:', '🚃', 'None', 0
    union select 760, ':train2:', '🚆', 'None', 0
    union select 761, ':tram:', '🚊', 'None', 0
    union select 762, ':triangular_flag_on_post:', '🚩', 'None', 0
    union select 763, ':triangular_ruler:', '📐', 'None', 0
    union select 764, ':trident:', '🔱', 'None', 0
    union select 765, ':triumph:', '😤', 'None', 0
    union select 766, ':trolleybus:', '🚎', 'None', 0
    union select 767, ':trophy:', '🏆', 'None', 0
    union select 768, ':tropical_drink:', '🍹', 'None', 0
    union select 769, ':tropical_fish:', '🐠', 'None', 0
    union select 770, ':truck:', '🚚', 'None', 0
    union select 771, ':trumpet:', '🎺', 'None', 0
    union select 772, ':tshirt:', '👕', 'None', 0
    union select 773, ':tulip:', '🌷', 'None', 0
    union select 774, ':turtle:', '🐢', 'None', 0
    union select 775, ':tv:', '📺', 'None', 0
    union select 776, ':twisted_rightwards_arrows:', '🔀', 'None', 0
    union select 777, ':two_hearts:', '💕', 'None', 0
    union select 778, ':two_men_holding_hands:', '👬', 'None', 0
    union select 779, ':two_women_holding_hands:', '👭', 'None', 0
    union select 780, ':u5272:', '🈹', 'None', 0
    union select 781, ':u5408:', '🈴', 'None', 0
    union select 782, ':u55b6:', '🈺', 'None', 0
    union select 783, ':u6307:', '🈯', 'None', 0
    union select 784, ':u6708:', '🈷', 'None', 0
    union select 785, ':u6709:', '🈶', 'None', 0
    union select 786, ':u6e80:', '🈵', 'None', 0
    union select 787, ':u7121:', '🈚', 'None', 0
    union select 788, ':u7533:', '🈸', 'None', 0
    union select 789, ':u7981:', '🈲', 'None', 0
    union select 790, ':u7a7a:', '🈳', 'None', 0
    union select 791, ':umbrella:', '', 'None', 0
    union select 792, ':unamused:', '😒', 'None', 0
    union select 793, ':underage:', '🔞', 'None', 0
    union select 794, ':unlock:', '🔓', 'None', 0
    union select 795, ':up:', '🆙', 'None', 0
    union select 796, ':v:', '', 'None', 0
    union select 797, ':vertical_traffic_light:', '🚦', 'None', 0
    union select 798, ':vhs:', '📼', 'None', 0
    union select 799, ':vibration_mode:', '📳', 'None', 0
    union select 800, ':video_camera:', '📹', 'None', 0
    union select 801, ':video_game:', '🎮', 'None', 0
    union select 802, ':violin:', '🎻', 'None', 0
    union select 803, ':virgo:', '', 'None', 0
    union select 804, ':volcano:', '🌋', 'None', 0
    union select 805, ':vs:', '🆚', 'None', 0
    union select 806, ':walking:', '🚶', 'None', 0
    union select 807, ':waning_crescent_moon:', '🌘', 'None', 0
    union select 808, ':waning_gibbous_moon:', '🌖', 'None', 0
    union select 809, ':warning:', '', 'None', 0
    union select 810, ':watch:', '', 'None', 0
    union select 811, ':water_buffalo:', '🐃', 'None', 0
    union select 812, ':watermelon:', '🍉', 'None', 0
    union select 813, ':wave:', '👋', 'None', 0
    union select 814, ':wavy_dash:', '', 'None', 0
    union select 815, ':waxing_crescent_moon:', '🌒', 'None', 0
    union select 816, ':waxing_gibbous_moon:', '🌔', 'None', 0
    union select 817, ':wc:', '🚾', 'None', 0
    union select 818, ':weary:', '😩', 'None', 0
    union select 819, ':wedding:', '💒', 'None', 0
    union select 820, ':whale:', '🐳', 'None', 0
    union select 821, ':whale2:', '🐋', 'None', 0
    union select 822, ':wheelchair:', '', 'None', 0
    union select 823, ':white_check_mark:', '', 'None', 0
    union select 824, ':white_circle:', '', 'None', 0
    union select 825, ':white_flower:', '💮', 'None', 0
    union select 826, ':white_large_square:', '', 'None', 0
    union select 827, ':white_medium_small_square:', '', 'None', 0
    union select 828, ':white_medium_square:', '', 'None', 0
    union select 829, ':white_small_square:', '', 'None', 0
    union select 830, ':white_square_button:', '🔳', 'None', 0
    union select 831, ':wind_chime:', '🎐', 'None', 0
    union select 832, ':wine_glass:', '🍷', 'None', 0
    union select 833, ':wink:', '😉', 'None', 0
    union select 834, ':wolf:', '🐺', 'None', 0
    union select 835, ':woman:', '👩', 'None', 0
    union select 836, ':womans_clothes:', '👚', 'None', 0
    union select 837, ':womans_hat:', '👒', 'None', 0
    union select 838, ':womens:', '🚺', 'None', 0
    union select 839, ':worried:', '😟', 'None', 0
    union select 840, ':wrench:', '🔧', 'None', 0
    union select 841, ':x:', '', 'None', 0
    union select 842, ':yellow_heart:', '💛', 'None', 0
    union select 843, ':yen:', '💴', 'None', 0
    union select 844, ':yum:', '😋', 'None', 0
    union select 845, ':zap:', '', 'None', 0
    union select 846, ':zzz:', '💤', 'None', 0;


    INSERT INTO 'snippets'
    select 2 as 'sid', ':+1:' as 'title', '👍' as 'body', 'None' as 'syntax', 0 as 'usageCount'
    union select 3, ':-1:', '👎', 'None', 0
    union select 4, ':100:', '💯', 'None', 0
    union select 5, ':1234:', '🔢', 'None', 0
    union select 6, ':8ball:', '🎱', 'None', 0
    union select 7, ':a:', '🅰', 'None', 0
    union select 8, ':ab:', '🆎', 'None', 0
    union select 9, ':abc:', '🔤', 'None', 0
    union select 10, ':abcd:', '🔡', 'None', 0
    union select 11, ':accept:', '🉑', 'None', 0
    union select 12, ':aerial_tramway:', '🚡', 'None', 0
    union select 13, ':airplane:', '', 'None', 0
    union select 14, ':alarm_clock:', '', 'None', 0
    union select 15, ':alien:', '👽', 'None', 0
    union select 16, ':ambulance:', '🚑', 'None', 0
    union select 17, ':anchor:', '', 'None', 0
    union select 18, ':angel:', '👼', 'None', 0
    union select 19, ':anger:', '💢', 'None', 0
    union select 20, ':angry:', '😠', 'None', 0
    union select 21, ':anguished:', '😧', 'None', 0
    union select 22, ':ant:', '🐜', 'None', 0
    union select 23, ':apple:', '🍎', 'None', 0
    union select 24, ':aquarius:', '', 'None', 0
    union select 25, ':aries:', '', 'None', 0
    union select 26, ':arrow_backward:', '', 'None', 0
    union select 27, ':arrow_double_down:', '', 'None', 0
    union select 28, ':arrow_double_up:', '', 'None', 0
    union select 29, ':arrow_down:', '', 'None', 0
    union select 30, ':arrow_down_small:', '🔽', 'None', 0
    union select 31, ':arrow_forward:', '', 'None', 0
    union select 32, ':arrow_heading_down:', '', 'None', 0
    union select 33, ':arrow_heading_up:', '', 'None', 0
    union select 34, ':arrow_left:', '', 'None', 0
    union select 35, ':arrow_lower_left:', '', 'None', 0
    union select 36, ':arrow_lower_right:', '', 'None', 0
    union select 37, ':arrow_right:', '', 'None', 0
    union select 38, ':arrow_right_hook:', '', 'None', 0
    union select 39, ':arrow_up:', '', 'None', 0
    union select 40, ':arrow_up_down:', '', 'None', 0
    union select 41, ':arrow_up_small:', '🔼', 'None', 0
    union select 42, ':arrow_upper_left:', '', 'None', 0
    union select 43, ':arrow_upper_right:', '', 'None', 0
    union select 44, ':arrows_clockwise:', '🔃', 'None', 0
    union select 45, ':arrows_counterclockwise:', '🔄', 'None', 0
    union select 46, ':art:', '🎨', 'None', 0
    union select 47, ':articulated_lorry:', '🚛', 'None', 0
    union select 48, ':astonished:', '😲', 'None', 0
    union select 49, ':athletic_shoe:', '👟', 'None', 0
    union select 50, ':atm:', '🏧', 'None', 0
    union select 51, ':b:', '🅱', 'None', 0
    union select 52, ':baby:', '👶', 'None', 0
    union select 53, ':baby_bottle:', '🍼', 'None', 0
    union select 54, ':baby_chick:', '🐤', 'None', 0
    union select 55, ':baby_symbol:', '🚼', 'None', 0
    union select 56, ':back:', '🔙', 'None', 0
    union select 57, ':baggage_claim:', '🛄', 'None', 0
    union select 58, ':balloon:', '🎈', 'None', 0
    union select 59, ':ballot_box_with_check:', '', 'None', 0
    union select 60, ':bamboo:', '🎍', 'None', 0
    union select 61, ':banana:', '🍌', 'None', 0
    union select 62, ':bangbang:', '', 'None', 0
    union select 63, ':bank:', '🏦', 'None', 0
    union select 64, ':bar_chart:', '📊', 'None', 0
    union select 65, ':barber:', '💈', 'None', 0
    union select 66, ':baseball:', '', 'None', 0
    union select 67, ':basketball:', '🏀', 'None', 0
    union select 68, ':bath:', '🛀', 'None', 0
    union select 69, ':bathtub:', '🛁', 'None', 0
    union select 70, ':battery:', '🔋', 'None', 0
    union select 71, ':bear:', '🐻', 'None', 0
    union select 72, ':bee:', '🐝', 'None', 0
    union select 73, ':beer:', '🍺', 'None', 0
    union select 74, ':beers:', '🍻', 'None', 0
    union select 75, ':beetle:', '🐞', 'None', 0
    union select 76, ':beginner:', '🔰', 'None', 0
    union select 77, ':bell:', '🔔', 'None', 0
    union select 78, ':bento:', '🍱', 'None', 0
    union select 79, ':bicyclist:', '🚴', 'None', 0
    union select 80, ':bike:', '🚲', 'None', 0
    union select 81, ':bikini:', '👙', 'None', 0
    union select 82, ':bird:', '🐦', 'None', 0
    union select 83, ':birthday:', '🎂', 'None', 0
    union select 84, ':black_circle:', '', 'None', 0
    union select 85, ':black_joker:', '🃏', 'None', 0
    union select 86, ':black_large_square:', '', 'None', 0
    union select 87, ':black_medium_small_square:', '', 'None', 0
    union select 88, ':black_medium_square:', '', 'None', 0
    union select 89, ':black_nib:', '', 'None', 0
    union select 90, ':black_small_square:', '', 'None', 0
    union select 91, ':black_square_button:', '🔲', 'None', 0
    union select 92, ':blossom:', '🌼', 'None', 0
    union select 93, ':blowfish:', '🐡', 'None', 0
    union select 94, ':blue_book:', '📘', 'None', 0
    union select 95, ':blue_car:', '🚙', 'None', 0
    union select 96, ':blue_heart:', '💙', 'None', 0
    union select 97, ':blush:', '😊', 'None', 0
    union select 98, ':boar:', '🐗', 'None', 0
    union select 99, ':boat:', '', 'None', 0
    union select 100, ':bomb:', '💣', 'None', 0
    union select 101, ':book:', '📖', 'None', 0
    union select 102, ':bookmark:', '🔖', 'None', 0
    union select 103, ':bookmark_tabs:', '📑', 'None', 0
    union select 104, ':books:', '📚', 'None', 0
    union select 105, ':boom:', '💥', 'None', 0
    union select 106, ':boot:', '👢', 'None', 0
    union select 107, ':bouquet:', '💐', 'None', 0
    union select 108, ':bow:', '🙇', 'None', 0
    union select 109, ':bowling:', '🎳', 'None', 0
    union select 110, ':boy:', '👦', 'None', 0
    union select 111, ':bread:', '🍞', 'None', 0
    union select 112, ':bride_with_veil:', '👰', 'None', 0
    union select 113, ':bridge_at_night:', '🌉', 'None', 0
    union select 114, ':briefcase:', '💼', 'None', 0
    union select 115, ':broken_heart:', '💔', 'None', 0
    union select 116, ':bug:', '🐛', 'None', 0
    union select 117, ':bulb:', '💡', 'None', 0
    union select 118, ':bullettrain_front:', '🚅', 'None', 0
    union select 119, ':bullettrain_side:', '🚄', 'None', 0
    union select 120, ':bus:', '🚌', 'None', 0
    union select 121, ':busstop:', '🚏', 'None', 0
    union select 122, ':bust_in_silhouette:', '👤', 'None', 0
    union select 123, ':busts_in_silhouette:', '👥', 'None', 0
    union select 124, ':cactus:', '🌵', 'None', 0
    union select 125, ':cake:', '🍰', 'None', 0
    union select 126, ':calendar:', '📆', 'None', 0
    union select 127, ':calling:', '📲', 'None', 0
    union select 128, ':camel:', '🐫', 'None', 0
    union select 129, ':camera:', '📷', 'None', 0
    union select 130, ':cancer:', '', 'None', 0
    union select 131, ':candy:', '🍬', 'None', 0
    union select 132, ':capital_abcd:', '🔠', 'None', 0
    union select 133, ':capricorn:', '', 'None', 0
    union select 134, ':car:', '🚗', 'None', 0
    union select 135, ':card_index:', '📇', 'None', 0
    union select 136, ':carousel_horse:', '🎠', 'None', 0
    union select 137, ':cat:', '🐱', 'None', 0
    union select 138, ':cat2:', '🐈', 'None', 0
    union select 139, ':cd:', '💿', 'None', 0
    union select 140, ':chart:', '💹', 'None', 0
    union select 141, ':chart_with_downwards_trend:', '📉', 'None', 0
    union select 142, ':chart_with_upwards_trend:', '📈', 'None', 0
    union select 143, ':checkered_flag:', '🏁', 'None', 0
    union select 144, ':cherries:', '🍒', 'None', 0
    union select 145, ':cherry_blossom:', '🌸', 'None', 0
    union select 146, ':chestnut:', '🌰', 'None', 0
    union select 147, ':chicken:', '🐔', 'None', 0
    union select 148, ':children_crossing:', '🚸', 'None', 0
    union select 149, ':chocolate_bar:', '🍫', 'None', 0
    union select 150, ':christmas_tree:', '🎄', 'None', 0
    union select 151, ':church:', '', 'None', 0
    union select 152, ':cinema:', '🎦', 'None', 0
    union select 153, ':circus_tent:', '🎪', 'None', 0
    union select 154, ':city_sunrise:', '🌇', 'None', 0
    union select 155, ':city_sunset:', '🌆', 'None', 0
    union select 156, ':cl:', '🆑', 'None', 0
    union select 157, ':clap:', '👏', 'None', 0
    union select 158, ':clapper:', '🎬', 'None', 0
    union select 159, ':clipboard:', '📋', 'None', 0
    union select 160, ':clock1:', '🕐', 'None', 0
    union select 161, ':clock10:', '🕙', 'None', 0
    union select 162, ':clock1030:', '🕥', 'None', 0
    union select 163, ':clock11:', '🕚', 'None', 0
    union select 164, ':clock1130:', '🕦', 'None', 0
    union select 165, ':clock12:', '🕛', 'None', 0
    union select 166, ':clock1230:', '🕧', 'None', 0
    union select 167, ':clock130:', '🕜', 'None', 0
    union select 168, ':clock2:', '🕑', 'None', 0
    union select 169, ':clock230:', '🕝', 'None', 0
    union select 170, ':clock3:', '🕒', 'None', 0
    union select 171, ':clock330:', '🕞', 'None', 0
    union select 172, ':clock4:', '🕓', 'None', 0
    union select 173, ':clock430:', '🕟', 'None', 0
    union select 174, ':clock5:', '🕔', 'None', 0
    union select 175, ':clock530:', '🕠', 'None', 0
    union select 176, ':clock6:', '🕕', 'None', 0
    union select 177, ':clock630:', '🕡', 'None', 0
    union select 178, ':clock7:', '🕖', 'None', 0
    union select 179, ':clock730:', '🕢', 'None', 0
    union select 180, ':clock8:', '🕗', 'None', 0
    union select 181, ':clock830:', '🕣', 'None', 0
    union select 182, ':clock9:', '🕘', 'None', 0
    union select 183, ':clock930:', '🕤', 'None', 0
    union select 184, ':closed_book:', '📕', 'None', 0
    union select 185, ':closed_lock_with_key:', '🔐', 'None', 0
    union select 186, ':closed_umbrella:', '🌂', 'None', 0
    union select 187, ':cloud:', '', 'None', 0
    union select 188, ':clubs:', '', 'None', 0
    union select 189, ':cocktail:', '🍸', 'None', 0
    union select 190, ':coffee:', '', 'None', 0
    union select 191, ':cold_sweat:', '😰', 'None', 0
    union select 192, ':collision:', '💥', 'None', 0
    union select 193, ':computer:', '💻', 'None', 0
    union select 194, ':confetti_ball:', '🎊', 'None', 0
    union select 195, ':confounded:', '😖', 'None', 0
    union select 196, ':confused:', '😕', 'None', 0
    union select 197, ':congratulations:', '', 'None', 0
    union select 198, ':construction:', '🚧', 'None', 0
    union select 199, ':construction_worker:', '👷', 'None', 0
    union select 200, ':convenience_store:', '🏪', 'None', 0
    union select 201, ':cookie:', '🍪', 'None', 0
    union select 202, ':cool:', '🆒', 'None', 0
    union select 203, ':cop:', '👮', 'None', 0
    union select 204, ':copyright:', '©', 'None', 0
    union select 205, ':corn:', '🌽', 'None', 0
    union select 206, ':couple:', '👫', 'None', 0
    union select 207, ':couple_with_heart:', '💑', 'None', 0
    union select 208, ':couplekiss:', '💏', 'None', 0
    union select 209, ':cow:', '🐮', 'None', 0
    union select 210, ':cow2:', '🐄', 'None', 0
    union select 211, ':credit_card:', '💳', 'None', 0
    union select 212, ':crescent_moon:', '🌙', 'None', 0
    union select 213, ':crocodile:', '🐊', 'None', 0
    union select 214, ':crossed_flags:', '🎌', 'None', 0
    union select 215, ':crown:', '👑', 'None', 0
    union select 216, ':cry:', '😢', 'None', 0
    union select 217, ':crying_cat_face:', '😿', 'None', 0
    union select 218, ':crystal_ball:', '🔮', 'None', 0
    union select 219, ':cupid:', '💘', 'None', 0
    union select 220, ':curly_loop:', '', 'None', 0
    union select 221, ':currency_exchange:', '💱', 'None', 0
    union select 222, ':curry:', '🍛', 'None', 0
    union select 223, ':custard:', '🍮', 'None', 0
    union select 224, ':customs:', '🛃', 'None', 0
    union select 225, ':cyclone:', '🌀', 'None', 0
    union select 226, ':dancer:', '💃', 'None', 0
    union select 227, ':dancers:', '👯', 'None', 0
    union select 228, ':dango:', '🍡', 'None', 0
    union select 229, ':dart:', '🎯', 'None', 0
    union select 230, ':dash:', '💨', 'None', 0
    union select 231, ':date:', '📅', 'None', 0
    union select 232, ':deciduous_tree:', '🌳', 'None', 0
    union select 233, ':department_store:', '🏬', 'None', 0
    union select 234, ':diamond_shape_with_a_dot_inside:', '💠', 'None', 0
    union select 235, ':diamonds:', '', 'None', 0
    union select 236, ':disappointed:', '😞', 'None', 0
    union select 237, ':disappointed_relieved:', '😥', 'None', 0
    union select 238, ':dizzy:', '💫', 'None', 0
    union select 239, ':dizzy_face:', '😵', 'None', 0
    union select 240, ':do_not_litter:', '🚯', 'None', 0
    union select 241, ':dog:', '🐶', 'None', 0
    union select 242, ':dog2:', '🐕', 'None', 0
    union select 243, ':dollar:', '💵', 'None', 0
    union select 244, ':dolls:', '🎎', 'None', 0
    union select 245, ':dolphin:', '🐬', 'None', 0
    union select 246, ':door:', '🚪', 'None', 0
    union select 247, ':doughnut:', '🍩', 'None', 0
    union select 248, ':dragon:', '🐉', 'None', 0
    union select 249, ':dragon_face:', '🐲', 'None', 0
    union select 250, ':dress:', '👗', 'None', 0
    union select 251, ':dromedary_camel:', '🐪', 'None', 0
    union select 252, ':droplet:', '💧', 'None', 0
    union select 253, ':dvd:', '📀', 'None', 0
    union select 254, ':e-mail:', '📧', 'None', 0
    union select 255, ':ear:', '👂', 'None', 0
    union select 256, ':ear_of_rice:', '🌾', 'None', 0
    union select 257, ':earth_africa:', '🌍', 'None', 0
    union select 258, ':earth_americas:', '🌎', 'None', 0
    union select 259, ':earth_asia:', '🌏', 'None', 0
    union select 260, ':egg:', '🍳', 'None', 0
    union select 261, ':eggplant:', '🍆', 'None', 0
    union select 262, ':eight_pointed_black_star:', '', 'None', 0
    union select 263, ':eight_spoked_asterisk:', '', 'None', 0
    union select 264, ':electric_plug:', '🔌', 'None', 0
    union select 265, ':elephant:', '🐘', 'None', 0
    union select 266, ':email:', '', 'None', 0
    union select 267, ':end:', '🔚', 'None', 0
    union select 268, ':envelope:', '', 'None', 0
    union select 269, ':envelope_with_arrow:', '📩', 'None', 0
    union select 270, ':euro:', '💶', 'None', 0
    union select 271, ':european_castle:', '🏰', 'None', 0
    union select 272, ':european_post_office:', '🏤', 'None', 0
    union select 273, ':evergreen_tree:', '🌲', 'None', 0
    union select 274, ':exclamation:', '', 'None', 0
    union select 275, ':expressionless:', '😑', 'None', 0
    union select 276, ':eyeglasses:', '👓', 'None', 0
    union select 277, ':eyes:', '👀', 'None', 0
    union select 278, ':facepunch:', '👊', 'None', 0
    union select 279, ':factory:', '🏭', 'None', 0
    union select 280, ':fallen_leaf:', '🍂', 'None', 0
    union select 281, ':family:', '👪', 'None', 0
    union select 282, ':fast_forward:', '', 'None', 0
    union select 283, ':fax:', '📠', 'None', 0
    union select 284, ':fearful:', '😨', 'None', 0
    union select 285, ':feet:', '🐾', 'None', 0
    union select 286, ':ferris_wheel:', '🎡', 'None', 0
    union select 287, ':file_folder:', '📁', 'None', 0
    union select 288, ':fire:', '🔥', 'None', 0
    union select 289, ':fire_engine:', '🚒', 'None', 0
    union select 290, ':fireworks:', '🎆', 'None', 0
    union select 291, ':first_quarter_moon:', '🌓', 'None', 0
    union select 292, ':first_quarter_moon_with_face:', '🌛', 'None', 0
    union select 293, ':fish:', '🐟', 'None', 0
    union select 294, ':fish_cake:', '🍥', 'None', 0
    union select 295, ':fishing_pole_and_fish:', '🎣', 'None', 0
    union select 296, ':fist:', '', 'None', 0
    union select 297, ':flags:', '🎏', 'None', 0
    union select 298, ':flashlight:', '🔦', 'None', 0
    union select 299, ':flipper:', '🐬', 'None', 0
    union select 300, ':floppy_disk:', '💾', 'None', 0
    union select 301, ':flower_playing_cards:', '🎴', 'None', 0
    union select 302, ':flushed:', '😳', 'None', 0
    union select 303, ':foggy:', '🌁', 'None', 0
    union select 304, ':football:', '🏈', 'None', 0
    union select 305, ':footprints:', '👣', 'None', 0
    union select 306, ':fork_and_knife:', '🍴', 'None', 0
    union select 307, ':fountain:', '', 'None', 0
    union select 308, ':four_leaf_clover:', '🍀', 'None', 0
    union select 309, ':free:', '🆓', 'None', 0
    union select 310, ':fried_shrimp:', '🍤', 'None', 0
    union select 311, ':fries:', '🍟', 'None', 0
    union select 312, ':frog:', '🐸', 'None', 0
    union select 313, ':frowning:', '😦', 'None', 0
    union select 314, ':fuelpump:', '', 'None', 0
    union select 315, ':full_moon:', '🌕', 'None', 0
    union select 316, ':full_moon_with_face:', '🌝', 'None', 0
    union select 317, ':game_die:', '🎲', 'None', 0
    union select 318, ':gem:', '💎', 'None', 0
    union select 319, ':gemini:', '', 'None', 0
    union select 320, ':ghost:', '👻', 'None', 0
    union select 321, ':gift:', '🎁', 'None', 0
    union select 322, ':gift_heart:', '💝', 'None', 0
    union select 323, ':girl:', '👧', 'None', 0
    union select 324, ':globe_with_meridians:', '🌐', 'None', 0
    union select 325, ':goat:', '🐐', 'None', 0
    union select 326, ':golf:', '', 'None', 0
    union select 327, ':grapes:', '🍇', 'None', 0
    union select 328, ':green_apple:', '🍏', 'None', 0
    union select 329, ':green_book:', '📗', 'None', 0
    union select 330, ':green_heart:', '💚', 'None', 0
    union select 331, ':grey_exclamation:', '', 'None', 0
    union select 332, ':grey_question:', '', 'None', 0
    union select 333, ':grimacing:', '😬', 'None', 0
    union select 334, ':grin:', '😁', 'None', 0
    union select 335, ':grinning:', '😀', 'None', 0
    union select 336, ':guardsman:', '💂', 'None', 0
    union select 337, ':guitar:', '🎸', 'None', 0
    union select 338, ':gun:', '🔫', 'None', 0
    union select 339, ':haircut:', '💇', 'None', 0
    union select 340, ':hamburger:', '🍔', 'None', 0
    union select 341, ':hammer:', '🔨', 'None', 0
    union select 342, ':hamster:', '🐹', 'None', 0
    union select 343, ':hand:', '', 'None', 0
    union select 344, ':handbag:', '👜', 'None', 0
    union select 345, ':hankey:', '💩', 'None', 0
    union select 346, ':hatched_chick:', '🐥', 'None', 0
    union select 347, ':hatching_chick:', '🐣', 'None', 0
    union select 348, ':headphones:', '🎧', 'None', 0
    union select 349, ':hear_no_evil:', '🙉', 'None', 0
    union select 350, ':heart:', '', 'None', 0
    union select 351, ':heart_decoration:', '💟', 'None', 0
    union select 352, ':heart_eyes:', '😍', 'None', 0
    union select 353, ':heart_eyes_cat:', '😻', 'None', 0
    union select 354, ':heartbeat:', '💓', 'None', 0
    union select 355, ':heartpulse:', '💗', 'None', 0
    union select 356, ':hearts:', '', 'None', 0
    union select 357, ':heavy_check_mark:', '', 'None', 0
    union select 358, ':heavy_division_sign:', '', 'None', 0
    union select 359, ':heavy_dollar_sign:', '💲', 'None', 0
    union select 360, ':heavy_exclamation_mark:', '', 'None', 0
    union select 361, ':heavy_minus_sign:', '', 'None', 0
    union select 362, ':heavy_multiplication_x:', '', 'None', 0
    union select 363, ':heavy_plus_sign:', '', 'None', 0
    union select 364, ':helicopter:', '🚁', 'None', 0
    union select 365, ':herb:', '🌿', 'None', 0
    union select 366, ':hibiscus:', '🌺', 'None', 0
    union select 367, ':high_brightness:', '🔆', 'None', 0
    union select 368, ':high_heel:', '👠', 'None', 0
    union select 369, ':hocho:', '🔪', 'None', 0
    union select 370, ':honey_pot:', '🍯', 'None', 0
    union select 371, ':honeybee:', '🐝', 'None', 0
    union select 372, ':horse:', '🐴', 'None', 0
    union select 373, ':horse_racing:', '🏇', 'None', 0
    union select 374, ':hospital:', '🏥', 'None', 0
    union select 375, ':hotel:', '🏨', 'None', 0
    union select 376, ':hotsprings:', '', 'None', 0
    union select 377, ':hourglass:', '', 'None', 0
    union select 378, ':hourglass_flowing_sand:', '', 'None', 0
    union select 379, ':house:', '🏠', 'None', 0
    union select 380, ':house_with_garden:', '🏡', 'None', 0
    union select 381, ':hushed:', '😯', 'None', 0
    union select 382, ':ice_cream:', '🍨', 'None', 0
    union select 383, ':icecream:', '🍦', 'None', 0
    union select 384, ':id:', '🆔', 'None', 0
    union select 385, ':ideograph_advantage:', '🉐', 'None', 0
    union select 386, ':imp:', '👿', 'None', 0
    union select 387, ':inbox_tray:', '📥', 'None', 0
    union select 388, ':incoming_envelope:', '📨', 'None', 0
    union select 389, ':information_desk_person:', '💁', 'None', 0
    union select 390, ':information_source:', '', 'None', 0
    union select 391, ':innocent:', '😇', 'None', 0
    union select 392, ':interrobang:', '', 'None', 0
    union select 393, ':iphone:', '📱', 'None', 0
    union select 394, ':izakaya_lantern:', '🏮', 'None', 0
    union select 395, ':jack_o_lantern:', '🎃', 'None', 0
    union select 396, ':japan:', '🗾', 'None', 0
    union select 397, ':japanese_castle:', '🏯', 'None', 0
    union select 398, ':japanese_goblin:', '👺', 'None', 0
    union select 399, ':japanese_ogre:', '👹', 'None', 0
    union select 400, ':jeans:', '👖', 'None', 0
    union select 401, ':joy:', '😂', 'None', 0
    union select 402, ':joy_cat:', '😹', 'None', 0
    union select 403, ':key:', '🔑', 'None', 0
    union select 404, ':keycap_ten:', '🔟', 'None', 0
    union select 405, ':kimono:', '👘', 'None', 0
    union select 406, ':kiss:', '💋', 'None', 0
    union select 407, ':kissing:', '😗', 'None', 0
    union select 408, ':kissing_cat:', '😽', 'None', 0
    union select 409, ':kissing_closed_eyes:', '😚', 'None', 0
    union select 410, ':kissing_heart:', '😘', 'None', 0
    union select 411, ':kissing_smiling_eyes:', '😙', 'None', 0
    union select 412, ':koala:', '🐨', 'None', 0
    union select 413, ':koko:', '🈁', 'None', 0
    union select 414, ':lantern:', '🏮', 'None', 0
    union select 415, ':large_blue_circle:', '🔵', 'None', 0
    union select 416, ':large_blue_diamond:', '🔷', 'None', 0
    union select 417, ':large_orange_diamond:', '🔶', 'None', 0
    union select 418, ':last_quarter_moon:', '🌗', 'None', 0
    union select 419, ':last_quarter_moon_with_face:', '🌜', 'None', 0
    union select 420, ':laughing:', '😆', 'None', 0
    union select 421, ':leaves:', '🍃', 'None', 0
    union select 422, ':ledger:', '📒', 'None', 0
    union select 423, ':left_luggage:', '🛅', 'None', 0
    union select 424, ':left_right_arrow:', '', 'None', 0
    union select 425, ':leftwards_arrow_with_hook:', '', 'None', 0
    union select 426, ':lemon:', '🍋', 'None', 0
    union select 427, ':leo:', '', 'None', 0
    union select 428, ':leopard:', '🐆', 'None', 0
    union select 429, ':libra:', '', 'None', 0
    union select 430, ':light_rail:', '🚈', 'None', 0
    union select 431, ':link:', '🔗', 'None', 0
    union select 432, ':lips:', '👄', 'None', 0
    union select 433, ':lipstick:', '💄', 'None', 0
    union select 434, ':lock:', '🔒', 'None', 0
    union select 435, ':lock_with_ink_pen:', '🔏', 'None', 0
    union select 436, ':lollipop:', '🍭', 'None', 0
    union select 437, ':loop:', '', 'None', 0
    union select 438, ':loudspeaker:', '📢', 'None', 0
    union select 439, ':love_hotel:', '🏩', 'None', 0
    union select 440, ':love_letter:', '💌', 'None', 0
    union select 441, ':low_brightness:', '🔅', 'None', 0
    union select 442, ':m:', '', 'None', 0
    union select 443, ':mag:', '🔍', 'None', 0
    union select 444, ':mag_right:', '🔎', 'None', 0
    union select 445, ':mahjong:', '🀄', 'None', 0
    union select 446, ':mailbox:', '📫', 'None', 0
    union select 447, ':mailbox_closed:', '📪', 'None', 0
    union select 448, ':mailbox_with_mail:', '📬', 'None', 0
    union select 449, ':mailbox_with_no_mail:', '📭', 'None', 0
    union select 450, ':man:', '👨', 'None', 0
    union select 451, ':man_with_gua_pi_mao:', '👲', 'None', 0
    union select 452, ':man_with_turban:', '👳', 'None', 0
    union select 453, ':mans_shoe:', '👞', 'None', 0
    union select 454, ':maple_leaf:', '🍁', 'None', 0
    union select 455, ':mask:', '😷', 'None', 0
    union select 456, ':massage:', '💆', 'None', 0
    union select 457, ':meat_on_bone:', '🍖', 'None', 0
    union select 458, ':mega:', '📣', 'None', 0
    union select 459, ':melon:', '🍈', 'None', 0
    union select 460, ':memo:', '📝', 'None', 0
    union select 461, ':mens:', '🚹', 'None', 0
    union select 462, ':metro:', '🚇', 'None', 0
    union select 463, ':microphone:', '🎤', 'None', 0
    union select 464, ':microscope:', '🔬', 'None', 0
    union select 465, ':milky_way:', '🌌', 'None', 0
    union select 466, ':minibus:', '🚐', 'None', 0
    union select 467, ':minidisc:', '💽', 'None', 0
    union select 468, ':mobile_phone_off:', '📴', 'None', 0
    union select 469, ':money_with_wings:', '💸', 'None', 0
    union select 470, ':moneybag:', '💰', 'None', 0
    union select 471, ':monkey:', '🐒', 'None', 0
    union select 472, ':monkey_face:', '🐵', 'None', 0
    union select 473, ':monorail:', '🚝', 'None', 0
    union select 474, ':moon:', '🌔', 'None', 0
    union select 475, ':mortar_board:', '🎓', 'None', 0
    union select 476, ':mount_fuji:', '🗻', 'None', 0
    union select 477, ':mountain_bicyclist:', '🚵', 'None', 0
    union select 478, ':mountain_cableway:', '🚠', 'None', 0
    union select 479, ':mountain_railway:', '🚞', 'None', 0
    union select 480, ':mouse:', '🐭', 'None', 0
    union select 481, ':mouse2:', '🐁', 'None', 0
    union select 482, ':movie_camera:', '🎥', 'None', 0
    union select 483, ':moyai:', '🗿', 'None', 0
    union select 484, ':muscle:', '💪', 'None', 0
    union select 485, ':mushroom:', '🍄', 'None', 0
    union select 486, ':musical_keyboard:', '🎹', 'None', 0;
    INSERT INTO 'snippets' ('title', 'body') VALUES
    (':+1:', '👍'),
    (':-1:', '👎'),
    (':100:', '💯'),
    (':1234:', '🔢'),
    (':8ball:', '🎱'),
    (':a:', '🅰'),
    (':ab:', '🆎'),
    (':abc:', '🔤'),
    (':abcd:', '🔡'),
    (':accept:', '🉑'),
    (':aerial_tramway:', '🚡'),
    (':airplane:', ''),
    (':alarm_clock:', ''),
    (':alien:', '👽'),
    (':ambulance:', '🚑'),
    (':anchor:', ''),
    (':angel:', '👼'),
    (':anger:', '💢'),
    (':angry:', '😠'),
    (':anguished:', '😧'),
    (':ant:', '🐜'),
    (':apple:', '🍎'),
    (':aquarius:', ''),
    (':aries:', ''),
    (':arrow_backward:', ''),
    (':arrow_double_down:', ''),
    (':arrow_double_up:', ''),
    (':arrow_down:', ''),
    (':arrow_down_small:', '🔽'),
    (':arrow_forward:', ''),
    (':arrow_heading_down:', ''),
    (':arrow_heading_up:', ''),
    (':arrow_left:', ''),
    (':arrow_lower_left:', ''),
    (':arrow_lower_right:', ''),
    (':arrow_right:', ''),
    (':arrow_right_hook:', ''),
    (':arrow_up:', ''),
    (':arrow_up_down:', ''),
    (':arrow_up_small:', '🔼'),
    (':arrow_upper_left:', ''),
    (':arrow_upper_right:', ''),
    (':arrows_clockwise:', '🔃'),
    (':arrows_counterclockwise:', '🔄'),
    (':art:', '🎨'),
    (':articulated_lorry:', '🚛'),
    (':astonished:', '😲'),
    (':athletic_shoe:', '👟'),
    (':atm:', '🏧'),
    (':b:', '🅱'),
    (':baby:', '👶'),
    (':baby_bottle:', '🍼'),
    (':baby_chick:', '🐤'),
    (':baby_symbol:', '🚼'),
    (':back:', '🔙'),
    (':baggage_claim:', '🛄'),
    (':balloon:', '🎈'),
    (':ballot_box_with_check:', ''),
    (':bamboo:', '🎍'),
    (':banana:', '🍌'),
    (':bangbang:', ''),
    (':bank:', '🏦'),
    (':bar_chart:', '📊'),
    (':barber:', '💈'),
    (':baseball:', ''),
    (':basketball:', '🏀'),
    (':bath:', '🛀'),
    (':bathtub:', '🛁'),
    (':battery:', '🔋'),
    (':bear:', '🐻'),
    (':bee:', '🐝'),
    (':beer:', '🍺'),
    (':beers:', '🍻'),
    (':beetle:', '🐞'),
    (':beginner:', '🔰'),
    (':bell:', '🔔'),
    (':bento:', '🍱'),
    (':bicyclist:', '🚴'),
    (':bike:', '🚲'),
    (':bikini:', '👙'),
    (':bird:', '🐦'),
    (':birthday:', '🎂'),
    (':black_circle:', ''),
    (':black_joker:', '🃏'),
    (':black_large_square:', ''),
    (':black_medium_small_square:', ''),
    (':black_medium_square:', ''),
    (':black_nib:', ''),
    (':black_small_square:', ''),
    (':black_square_button:', '🔲'),
    (':blossom:', '🌼'),
    (':blowfish:', '🐡'),
    (':blue_book:', '📘'),
    (':blue_car:', '🚙'),
    (':blue_heart:', '💙'),
    (':blush:', '😊'),
    (':boar:', '🐗'),
    (':boat:', ''),
    (':bomb:', '💣'),
    (':book:', '📖'),
    (':bookmark:', '🔖'),
    (':bookmark_tabs:', '📑'),
    (':books:', '📚'),
    (':boom:', '💥'),
    (':boot:', '👢'),
    (':bouquet:', '💐'),
    (':bow:', '🙇'),
    (':bowling:', '🎳'),
    (':boy:', '👦'),
    (':bread:', '🍞'),
    (':bride_with_veil:', '👰'),
    (':bridge_at_night:', '🌉'),
    (':briefcase:', '💼'),
    (':broken_heart:', '💔'),
    (':bug:', '🐛'),
    (':bulb:', '💡'),
    (':bullettrain_front:', '🚅'),
    (':bullettrain_side:', '🚄'),
    (':bus:', '🚌'),
    (':busstop:', '🚏'),
    (':bust_in_silhouette:', '👤'),
    (':busts_in_silhouette:', '👥'),
    (':cactus:', '🌵'),
    (':cake:', '🍰'),
    (':calendar:', '📆'),
    (':calling:', '📲'),
    (':camel:', '🐫'),
    (':camera:', '📷'),
    (':cancer:', ''),
    (':candy:', '🍬'),
    (':capital_abcd:', '🔠'),
    (':capricorn:', ''),
    (':car:', '🚗'),
    (':card_index:', '📇'),
    (':carousel_horse:', '🎠'),
    (':cat:', '🐱'),
    (':cat2:', '🐈'),
    (':cd:', '💿'),
    (':chart:', '💹'),
    (':chart_with_downwards_trend:', '📉'),
    (':chart_with_upwards_trend:', '📈'),
    (':checkered_flag:', '🏁'),
    (':cherries:', '🍒'),
    (':cherry_blossom:', '🌸'),
    (':chestnut:', '🌰'),
    (':chicken:', '🐔'),
    (':children_crossing:', '🚸'),
    (':chocolate_bar:', '🍫'),
    (':christmas_tree:', '🎄'),
    (':church:', ''),
    (':cinema:', '🎦'),
    (':circus_tent:', '🎪'),
    (':city_sunrise:', '🌇'),
    (':city_sunset:', '🌆'),
    (':cl:', '🆑'),
    (':clap:', '👏'),
    (':clapper:', '🎬'),
    (':clipboard:', '📋'),
    (':clock1:', '🕐'),
    (':clock10:', '🕙'),
    (':clock1030:', '🕥'),
    (':clock11:', '🕚'),
    (':clock1130:', '🕦'),
    (':clock12:', '🕛'),
    (':clock1230:', '🕧'),
    (':clock130:', '🕜'),
    (':clock2:', '🕑'),
    (':clock230:', '🕝'),
    (':clock3:', '🕒'),
    (':clock330:', '🕞'),
    (':clock4:', '🕓'),
    (':clock430:', '🕟'),
    (':clock5:', '🕔'),
    (':clock530:', '🕠'),
    (':clock6:', '🕕'),
    (':clock630:', '🕡'),
    (':clock7:', '🕖'),
    (':clock730:', '🕢'),
    (':clock8:', '🕗'),
    (':clock830:', '🕣'),
    (':clock9:', '🕘'),
    (':clock930:', '🕤'),
    (':closed_book:', '📕'),
    (':closed_lock_with_key:', '🔐'),
    (':closed_umbrella:', '🌂'),
    (':cloud:', ''),
    (':clubs:', ''),
    (':cocktail:', '🍸'),
    (':coffee:', ''),
    (':cold_sweat:', '😰'),
    (':collision:', '💥'),
    (':computer:', '💻'),
    (':confetti_ball:', '🎊'),
    (':confounded:', '😖'),
    (':confused:', '😕'),
    (':congratulations:', ''),
    (':construction:', '🚧'),
    (':construction_worker:', '👷'),
    (':convenience_store:', '🏪'),
    (':cookie:', '🍪'),
    (':cool:', '🆒'),
    (':cop:', '👮'),
    (':copyright:', '©'),
    (':corn:', '🌽'),
    (':couple:', '👫'),
    (':couple_with_heart:', '💑'),
    (':couplekiss:', '💏'),
    (':cow:', '🐮'),
    (':cow2:', '🐄'),
    (':credit_card:', '💳'),
    (':crescent_moon:', '🌙'),
    (':crocodile:', '🐊'),
    (':crossed_flags:', '🎌'),
    (':crown:', '👑'),
    (':cry:', '😢'),
    (':crying_cat_face:', '😿'),
    (':crystal_ball:', '🔮'),
    (':cupid:', '💘'),
    (':curly_loop:', ''),
    (':currency_exchange:', '💱'),
    (':curry:', '🍛'),
    (':custard:', '🍮'),
    (':customs:', '🛃'),
    (':cyclone:', '🌀'),
    (':dancer:', '💃'),
    (':dancers:', '👯'),
    (':dango:', '🍡'),
    (':dart:', '🎯'),
    (':dash:', '💨'),
    (':date:', '📅'),
    (':deciduous_tree:', '🌳'),
    (':department_store:', '🏬'),
    (':diamond_shape_with_a_dot_inside:', '💠'),
    (':diamonds:', ''),
    (':disappointed:', '😞'),
    (':disappointed_relieved:', '😥'),
    (':dizzy:', '💫'),
    (':dizzy_face:', '😵'),
    (':do_not_litter:', '🚯'),
    (':dog:', '🐶'),
    (':dog2:', '🐕'),
    (':dollar:', '💵'),
    (':dolls:', '🎎'),
    (':dolphin:', '🐬'),
    (':door:', '🚪'),
    (':doughnut:', '🍩'),
    (':dragon:', '🐉'),
    (':dragon_face:', '🐲'),
    (':dress:', '👗'),
    (':dromedary_camel:', '🐪'),
    (':droplet:', '💧'),
    (':dvd:', '📀'),
    (':e-mail:', '📧'),
    (':ear:', '👂'),
    (':ear_of_rice:', '🌾'),
    (':earth_africa:', '🌍'),
    (':earth_americas:', '🌎'),
    (':earth_asia:', '🌏'),
    (':egg:', '🍳'),
    (':eggplant:', '🍆'),
    (':eight_pointed_black_star:', ''),
    (':eight_spoked_asterisk:', ''),
    (':electric_plug:', '🔌'),
    (':elephant:', '🐘'),
    (':email:', ''),
    (':end:', '🔚'),
    (':envelope:', ''),
    (':envelope_with_arrow:', '📩'),
    (':euro:', '💶'),
    (':european_castle:', '🏰'),
    (':european_post_office:', '🏤'),
    (':evergreen_tree:', '🌲'),
    (':exclamation:', ''),
    (':expressionless:', '😑'),
    (':eyeglasses:', '👓'),
    (':eyes:', '👀'),
    (':facepunch:', '👊'),
    (':factory:', '🏭'),
    (':fallen_leaf:', '🍂'),
    (':family:', '👪'),
    (':fast_forward:', ''),
    (':fax:', '📠'),
    (':fearful:', '😨'),
    (':feet:', '🐾'),
    (':ferris_wheel:', '🎡'),
    (':file_folder:', '📁'),
    (':fire:', '🔥'),
    (':fire_engine:', '🚒'),
    (':fireworks:', '🎆'),
    (':first_quarter_moon:', '🌓'),
    (':first_quarter_moon_with_face:', '🌛'),
    (':fish:', '🐟'),
    (':fish_cake:', '🍥'),
    (':fishing_pole_and_fish:', '🎣'),
    (':fist:', ''),
    (':flags:', '🎏'),
    (':flashlight:', '🔦'),
    (':flipper:', '🐬'),
    (':floppy_disk:', '💾'),
    (':flower_playing_cards:', '🎴'),
    (':flushed:', '😳'),
    (':foggy:', '🌁'),
    (':football:', '🏈'),
    (':footprints:', '👣'),
    (':fork_and_knife:', '🍴'),
    (':fountain:', ''),
    (':four_leaf_clover:', '🍀'),
    (':free:', '🆓'),
    (':fried_shrimp:', '🍤'),
    (':fries:', '🍟'),
    (':frog:', '🐸'),
    (':frowning:', '😦'),
    (':fuelpump:', ''),
    (':full_moon:', '🌕'),
    (':full_moon_with_face:', '🌝'),
    (':game_die:', '🎲'),
    (':gem:', '💎'),
    (':gemini:', ''),
    (':ghost:', '👻'),
    (':gift:', '🎁'),
    (':gift_heart:', '💝'),
    (':girl:', '👧'),
    (':globe_with_meridians:', '🌐'),
    (':goat:', '🐐'),
    (':golf:', ''),
    (':grapes:', '🍇'),
    (':green_apple:', '🍏'),
    (':green_book:', '📗'),
    (':green_heart:', '💚'),
    (':grey_exclamation:', ''),
    (':grey_question:', ''),
    (':grimacing:', '😬'),
    (':grin:', '😁'),
    (':grinning:', '😀'),
    (':guardsman:', '💂'),
    (':guitar:', '🎸'),
    (':gun:', '🔫'),
    (':haircut:', '💇'),
    (':hamburger:', '🍔'),
    (':hammer:', '🔨'),
    (':hamster:', '🐹'),
    (':hand:', ''),
    (':handbag:', '👜'),
    (':hankey:', '💩'),
    (':hatched_chick:', '🐥'),
    (':hatching_chick:', '🐣'),
    (':headphones:', '🎧'),
    (':hear_no_evil:', '🙉'),
    (':heart:', ''),
    (':heart_decoration:', '💟'),
    (':heart_eyes:', '😍'),
    (':heart_eyes_cat:', '😻'),
    (':heartbeat:', '💓'),
    (':heartpulse:', '💗'),
    (':hearts:', ''),
    (':heavy_check_mark:', ''),
    (':heavy_division_sign:', ''),
    (':heavy_dollar_sign:', '💲'),
    (':heavy_exclamation_mark:', ''),
    (':heavy_minus_sign:', ''),
    (':heavy_multiplication_x:', ''),
    (':heavy_plus_sign:', ''),
    (':helicopter:', '🚁'),
    (':herb:', '🌿'),
    (':hibiscus:', '🌺'),
    (':high_brightness:', '🔆'),
    (':high_heel:', '👠'),
    (':hocho:', '🔪'),
    (':honey_pot:', '🍯'),
    (':honeybee:', '🐝'),
    (':horse:', '🐴'),
    (':horse_racing:', '🏇'),
    (':hospital:', '🏥'),
    (':hotel:', '🏨'),
    (':hotsprings:', ''),
    (':hourglass:', ''),
    (':hourglass_flowing_sand:', ''),
    (':house:', '🏠'),
    (':house_with_garden:', '🏡'),
    (':hushed:', '😯'),
    (':ice_cream:', '🍨'),
    (':icecream:', '🍦'),
    (':id:', '🆔'),
    (':ideograph_advantage:', '🉐'),
    (':imp:', '👿'),
    (':inbox_tray:', '📥'),
    (':incoming_envelope:', '📨'),
    (':information_desk_person:', '💁'),
    (':information_source:', ''),
    (':innocent:', '😇'),
    (':interrobang:', ''),
    (':iphone:', '📱'),
    (':izakaya_lantern:', '🏮'),
    (':jack_o_lantern:', '🎃'),
    (':japan:', '🗾'),
    (':japanese_castle:', '🏯'),
    (':japanese_goblin:', '👺'),
    (':japanese_ogre:', '👹'),
    (':jeans:', '👖'),
    (':joy:', '😂'),
    (':joy_cat:', '😹'),
    (':key:', '🔑'),
    (':keycap_ten:', '🔟'),
    (':kimono:', '👘'),
    (':kiss:', '💋'),
    (':kissing:', '😗'),
    (':kissing_cat:', '😽'),
    (':kissing_closed_eyes:', '😚'),
    (':kissing_heart:', '😘'),
    (':kissing_smiling_eyes:', '😙'),
    (':koala:', '🐨'),
    (':koko:', '🈁'),
    (':lantern:', '🏮'),
    (':large_blue_circle:', '🔵'),
    (':large_blue_diamond:', '🔷'),
    (':large_orange_diamond:', '🔶'),
    (':last_quarter_moon:', '🌗'),
    (':last_quarter_moon_with_face:', '🌜'),
    (':laughing:', '😆'),
    (':leaves:', '🍃'),
    (':ledger:', '📒'),
    (':left_luggage:', '🛅'),
    (':left_right_arrow:', ''),
    (':leftwards_arrow_with_hook:', ''),
    (':lemon:', '🍋'),
    (':leo:', ''),
    (':leopard:', '🐆'),
    (':libra:', ''),
    (':light_rail:', '🚈'),
    (':link:', '🔗'),
    (':lips:', '👄'),
    (':lipstick:', '💄'),
    (':lock:', '🔒'),
    (':lock_with_ink_pen:', '🔏'),
    (':lollipop:', '🍭'),
    (':loop:', ''),
    (':loudspeaker:', '📢'),
    (':love_hotel:', '🏩'),
    (':love_letter:', '💌'),
    (':low_brightness:', '🔅'),
    (':m:', ''),
    (':mag:', '🔍'),
    (':mag_right:', '🔎'),
    (':mahjong:', '🀄'),
    (':mailbox:', '📫'),
    (':mailbox_closed:', '📪'),
    (':mailbox_with_mail:', '📬'),
    (':mailbox_with_no_mail:', '📭'),
    (':man:', '👨'),
    (':man_with_gua_pi_mao:', '👲'),
    (':man_with_turban:', '👳'),
    (':mans_shoe:', '👞'),
    (':maple_leaf:', '🍁'),
    (':mask:', '😷'),
    (':massage:', '💆'),
    (':meat_on_bone:', '🍖'),
    (':mega:', '📣'),
    (':melon:', '🍈'),
    (':memo:', '📝'),
    (':mens:', '🚹'),
    (':metro:', '🚇'),
    (':microphone:', '🎤'),
    (':microscope:', '🔬'),
    (':milky_way:', '🌌'),
    (':minibus:', '🚐'),
    (':minidisc:', '💽'),
    (':mobile_phone_off:', '📴'),
    (':money_with_wings:', '💸'),
    (':moneybag:', '💰'),
    (':monkey:', '🐒'),
    (':monkey_face:', '🐵'),
    (':monorail:', '🚝'),
    (':moon:', '🌔'),
    (':mortar_board:', '🎓'),
    (':mount_fuji:', '🗻'),
    (':mountain_bicyclist:', '🚵'),
    (':mountain_cableway:', '🚠'),
    (':mountain_railway:', '🚞'),
    (':mouse:', '🐭'),
    (':mouse2:', '🐁'),
    (':movie_camera:', '🎥'),
    (':moyai:', '🗿'),
    (':muscle:', '💪'),
    (':mushroom:', '🍄'),
    (':musical_keyboard:', '🎹'),
    (':musical_note:', '🎵'),
    (':musical_score:', '🎼'),
    (':mute:', '🔇'),
    (':nail_care:', '💅'),
    (':name_badge:', '📛'),
    (':necktie:', '👔'),
    (':negative_squared_cross_mark:', ''),
    (':neutral_face:', '😐'),
    (':new:', '🆕'),
    (':new_moon:', '🌑'),
    (':new_moon_with_face:', '🌚'),
    (':newspaper:', '📰'),
    (':ng:', '🆖'),
    (':no_bell:', '🔕');
    INSERT INTO 'snippets' ('title', 'body') VALUES
    (':no_bicycles:', '🚳'),
    (':no_entry:', ''),
    (':no_entry_sign:', '🚫'),
    (':no_good:', '🙅'),
    (':no_mobile_phones:', '📵'),
    (':no_mouth:', '😶'),
    (':no_pedestrians:', '🚷'),
    (':no_smoking:', '🚭'),
    (':non-potable_water:', '🚱'),
    (':nose:', '👃'),
    (':notebook:', '📓'),
    (':notebook_with_decorative_cover:', '📔'),
    (':notes:', '🎶'),
    (':nut_and_bolt:', '🔩'),
    (':o:', ''),
    (':o2:', '🅾'),
    (':ocean:', '🌊'),
    (':octopus:', '🐙'),
    (':oden:', '🍢'),
    (':office:', '🏢'),
    (':ok:', '🆗'),
    (':ok_hand:', '👌'),
    (':ok_woman:', '🙆'),
    (':older_man:', '👴'),
    (':older_woman:', '👵'),
    (':on:', '🔛'),
    (':oncoming_automobile:', '🚘'),
    (':oncoming_bus:', '🚍'),
    (':oncoming_police_car:', '🚔'),
    (':oncoming_taxi:', '🚖'),
    (':open_book:', '📖'),
    (':open_file_folder:', '📂'),
    (':open_hands:', '👐'),
    (':open_mouth:', '😮'),
    (':ophiuchus:', ''),
    (':orange_book:', '📙'),
    (':outbox_tray:', '📤'),
    (':ox:', '🐂'),
    (':package:', '📦'),
    (':page_facing_up:', '📄'),
    (':page_with_curl:', '📃'),
    (':pager:', '📟'),
    (':palm_tree:', '🌴'),
    (':panda_face:', '🐼'),
    (':paperclip:', '📎'),
    (':parking:', '🅿'),
    (':part_alternation_mark:', ''),
    (':partly_sunny:', ''),
    (':passport_control:', '🛂'),
    (':paw_prints:', '🐾'),
    (':peach:', '🍑'),
    (':pear:', '🍐'),
    (':pencil:', '📝'),
    (':pencil2:', ''),
    (':penguin:', '🐧'),
    (':pensive:', '😔'),
    (':performing_arts:', '🎭'),
    (':persevere:', '😣'),
    (':person_frowning:', '🙍'),
    (':person_with_blond_hair:', '👱'),
    (':person_with_pouting_face:', '🙎'),
    (':phone:', ''),
    (':pig:', '🐷'),
    (':pig2:', '🐖'),
    (':pig_nose:', '🐽'),
    (':pill:', '💊'),
    (':pineapple:', '🍍'),
    (':pisces:', ''),
    (':pizza:', '🍕'),
    (':point_down:', '👇'),
    (':point_left:', '👈'),
    (':point_right:', '👉'),
    (':point_up:', ''),
    (':point_up_2:', '👆'),
    (':police_car:', '🚓'),
    (':poodle:', '🐩'),
    (':poop:', '💩'),
    (':post_office:', '🏣'),
    (':postal_horn:', '📯'),
    (':postbox:', '📮'),
    (':potable_water:', '🚰'),
    (':pouch:', '👝'),
    (':poultry_leg:', '🍗'),
    (':pound:', '💷'),
    (':pouting_cat:', '😾'),
    (':pray:', '🙏'),
    (':princess:', '👸'),
    (':punch:', '👊'),
    (':purple_heart:', '💜'),
    (':purse:', '👛'),
    (':pushpin:', '📌'),
    (':put_litter_in_its_place:', '🚮'),
    (':question:', ''),
    (':rabbit:', '🐰'),
    (':rabbit2:', '🐇'),
    (':racehorse:', '🐎'),
    (':radio:', '📻'),
    (':radio_button:', '🔘'),
    (':rage:', '😡'),
    (':railway_car:', '🚃'),
    (':rainbow:', '🌈'),
    (':raised_hand:', ''),
    (':raised_hands:', '🙌'),
    (':raising_hand:', '🙋'),
    (':ram:', '🐏'),
    (':ramen:', '🍜'),
    (':rat:', '🐀'),
    (':recycle:', ''),
    (':red_car:', '🚗'),
    (':red_circle:', '🔴'),
    (':registered:', '®'),
    (':relaxed:', ''),
    (':relieved:', '😌'),
    (':repeat:', '🔁'),
    (':repeat_one:', '🔂'),
    (':restroom:', '🚻'),
    (':revolving_hearts:', '💞'),
    (':rewind:', ''),
    (':ribbon:', '🎀'),
    (':rice:', '🍚'),
    (':rice_ball:', '🍙'),
    (':rice_cracker:', '🍘'),
    (':rice_scene:', '🎑'),
    (':ring:', '💍'),
    (':rocket:', '🚀'),
    (':roller_coaster:', '🎢'),
    (':rooster:', '🐓'),
    (':rose:', '🌹'),
    (':rotating_light:', '🚨'),
    (':round_pushpin:', '📍'),
    (':rowboat:', '🚣'),
    (':rugby_football:', '🏉'),
    (':runner:', '🏃'),
    (':running:', '🏃'),
    (':running_shirt_with_sash:', '🎽'),
    (':sa:', '🈂'),
    (':sagittarius:', ''),
    (':sailboat:', ''),
    (':sake:', '🍶'),
    (':sandal:', '👡'),
    (':santa:', '🎅'),
    (':satellite:', '📡'),
    (':satisfied:', '😆'),
    (':saxophone:', '🎷'),
    (':school:', '🏫'),
    (':school_satchel:', '🎒'),
    (':scissors:', ''),
    (':scorpius:', ''),
    (':scream:', '😱'),
    (':scream_cat:', '🙀'),
    (':scroll:', '📜'),
    (':seat:', '💺'),
    (':secret:', ''),
    (':see_no_evil:', '🙈'),
    (':seedling:', '🌱'),
    (':shaved_ice:', '🍧'),
    (':sheep:', '🐑'),
    (':shell:', '🐚'),
    (':ship:', '🚢'),
    (':shirt:', '👕'),
    (':shit:', '💩'),
    (':shoe:', '👞'),
    (':shower:', '🚿'),
    (':signal_strength:', '📶'),
    (':six_pointed_star:', '🔯'),
    (':ski:', '🎿'),
    (':skull:', '💀'),
    (':sleeping:', '😴'),
    (':sleepy:', '😪'),
    (':slot_machine:', '🎰'),
    (':small_blue_diamond:', '🔹'),
    (':small_orange_diamond:', '🔸'),
    (':small_red_triangle:', '🔺'),
    (':small_red_triangle_down:', '🔻'),
    (':smile:', '😄'),
    (':smile_cat:', '😸'),
    (':smiley:', '😃'),
    (':smiley_cat:', '😺'),
    (':smiling_imp:', '😈'),
    (':smirk:', '😏'),
    (':smirk_cat:', '😼'),
    (':smoking:', '🚬'),
    (':snail:', '🐌'),
    (':snake:', '🐍'),
    (':snowboarder:', '🏂'),
    (':snowflake:', ''),
    (':snowman:', ''),
    (':sob:', '😭'),
    (':soccer:', ''),
    (':soon:', '🔜'),
    (':sos:', '🆘'),
    (':sound:', '🔉'),
    (':space_invader:', '👾'),
    (':spades:', ''),
    (':spaghetti:', '🍝'),
    (':sparkle:', ''),
    (':sparkler:', '🎇'),
    (':sparkles:', ''),
    (':sparkling_heart:', '💖'),
    (':speak_no_evil:', '🙊'),
    (':speaker:', '🔊'),
    (':speech_balloon:', '💬'),
    (':speedboat:', '🚤'),
    (':star:', ''),
    (':star2:', '🌟'),
    (':stars:', '🌃'),
    (':station:', '🚉'),
    (':statue_of_liberty:', '🗽'),
    (':steam_locomotive:', '🚂'),
    (':stew:', '🍲'),
    (':straight_ruler:', '📏'),
    (':strawberry:', '🍓'),
    (':stuck_out_tongue:', '😛'),
    (':stuck_out_tongue_closed_eyes:', '😝'),
    (':stuck_out_tongue_winking_eye:', '😜'),
    (':sun_with_face:', '🌞'),
    (':sunflower:', '🌻'),
    (':sunglasses:', '😎'),
    (':sunny:', ''),
    (':sunrise:', '🌅'),
    (':sunrise_over_mountains:', '🌄'),
    (':surfer:', '🏄'),
    (':sushi:', '🍣'),
    (':suspension_railway:', '🚟'),
    (':sweat:', '😓'),
    (':sweat_drops:', '💦'),
    (':sweat_smile:', '😅'),
    (':sweet_potato:', '🍠'),
    (':swimmer:', '🏊'),
    (':symbols:', '🔣'),
    (':syringe:', '💉'),
    (':tada:', '🎉'),
    (':tanabata_tree:', '🎋'),
    (':tangerine:', '🍊'),
    (':taurus:', ''),
    (':taxi:', '🚕'),
    (':tea:', '🍵'),
    (':telephone:', ''),
    (':telephone_receiver:', '📞'),
    (':telescope:', '🔭'),
    (':tennis:', '🎾'),
    (':tent:', ''),
    (':thought_balloon:', '💭'),
    (':thumbsdown:', '👎'),
    (':thumbsup:', '👍'),
    (':ticket:', '🎫'),
    (':tiger:', '🐯'),
    (':tiger2:', '🐅'),
    (':tired_face:', '😫'),
    (':tm:', ''),
    (':toilet:', '🚽'),
    (':tokyo_tower:', '🗼'),
    (':tomato:', '🍅'),
    (':tongue:', '👅'),
    (':top:', '🔝'),
    (':tophat:', '🎩'),
    (':tractor:', '🚜'),
    (':traffic_light:', '🚥'),
    (':train:', '🚃'),
    (':train2:', '🚆'),
    (':tram:', '🚊'),
    (':triangular_flag_on_post:', '🚩'),
    (':triangular_ruler:', '📐'),
    (':trident:', '🔱'),
    (':triumph:', '😤'),
    (':trolleybus:', '🚎'),
    (':trophy:', '🏆'),
    (':tropical_drink:', '🍹'),
    (':tropical_fish:', '🐠'),
    (':truck:', '🚚'),
    (':trumpet:', '🎺'),
    (':tshirt:', '👕'),
    (':tulip:', '🌷'),
    (':turtle:', '🐢'),
    (':tv:', '📺'),
    (':twisted_rightwards_arrows:', '🔀'),
    (':two_hearts:', '💕'),
    (':two_men_holding_hands:', '👬'),
    (':two_women_holding_hands:', '👭'),
    (':u5272:', '🈹'),
    (':u5408:', '🈴'),
    (':u55b6:', '🈺'),
    (':u6307:', '🈯'),
    (':u6708:', '🈷'),
    (':u6709:', '🈶'),
    (':u6e80:', '🈵'),
    (':u7121:', '🈚'),
    (':u7533:', '🈸'),
    (':u7981:', '🈲'),
    (':u7a7a:', '🈳'),
    (':umbrella:', ''),
    (':unamused:', '😒'),
    (':underage:', '🔞'),
    (':unlock:', '🔓'),
    (':up:', '🆙'),
    (':v:', ''),
    (':vertical_traffic_light:', '🚦'),
    (':vhs:', '📼'),
    (':vibration_mode:', '📳'),
    (':video_camera:', '📹'),
    (':video_game:', '🎮'),
    (':violin:', '🎻'),
    (':virgo:', ''),
    (':volcano:', '🌋'),
    (':vs:', '🆚'),
    (':walking:', '🚶'),
    (':waning_crescent_moon:', '🌘'),
    (':waning_gibbous_moon:', '🌖'),
    (':warning:', ''),
    (':watch:', ''),
    (':water_buffalo:', '🐃'),
    (':watermelon:', '🍉'),
    (':wave:', '👋'),
    (':wavy_dash:', ''),
    (':waxing_crescent_moon:', '🌒'),
    (':waxing_gibbous_moon:', '🌔'),
    (':wc:', '🚾'),
    (':weary:', '😩'),
    (':wedding:', '💒'),
    (':whale:', '🐳'),
    (':whale2:', '🐋'),
    (':wheelchair:', ''),
    (':white_check_mark:', ''),
    (':white_circle:', ''),
    (':white_flower:', '💮'),
    (':white_large_square:', ''),
    (':white_medium_small_square:', ''),
    (':white_medium_square:', ''),
    (':white_small_square:', ''),
    (':white_square_button:', '🔳'),
    (':wind_chime:', '🎐'),
    (':wine_glass:', '🍷'),
    (':wink:', '😉'),
    (':wolf:', '🐺'),
    (':woman:', '👩'),
    (':womans_clothes:', '👚'),
    (':womans_hat:', '👒'),
    (':womens:', '🚺'),
    (':worried:', '😟'),
    (':wrench:', '🔧'),
    (':x:', ''),
    (':yellow_heart:', '💛'),
    (':yen:', '💴'),
    (':yum:', '😋'),
    (':zap:', ''),
    (':zzz:', '💤');
    UPDATE snippets SET syntax='None' WHERE syntax IS NULL;
    UPDATE snippets SET usageCount=0 WHERE usageCount IS NULL;
  2. @mneorr mneorr revised this gist Sep 10, 2013. 1 changed file with 14 additions and 0 deletions.
    14 changes: 14 additions & 0 deletions instructions.markdown
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    # Importing emoji snippets

    - Download this script and save it locally
    - First, locate your snippets file from inside Dash.app (most likely dash.dash)
    - Open up terminal and:

    ``` shell

    $ sqlite3 dash.dash
    sqlite3> .read /absolute/path/to/this/script.sql

    ```

    Restart Dash.app and that's it.
  3. @mneorr mneorr created this gist Sep 10, 2013.
    849 changes: 849 additions & 0 deletions dash_emoji_snippets.sql
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,849 @@
    INSERT INTO 'snippets'
    select 487 as 'sid', ':musical_note:' as 'title', '🎵' as 'body', 'None' as 'syntax', 0 as 'usageCount'
    union select 488, ':musical_score:', '🎼', 'None', 0
    union select 489, ':mute:', '🔇', 'None', 0
    union select 490, ':nail_care:', '💅', 'None', 0
    union select 491, ':name_badge:', '📛', 'None', 0
    union select 492, ':necktie:', '👔', 'None', 0
    union select 493, ':negative_squared_cross_mark:', '', 'None', 0
    union select 494, ':neutral_face:', '😐', 'None', 0
    union select 495, ':new:', '🆕', 'None', 0
    union select 496, ':new_moon:', '🌑', 'None', 0
    union select 497, ':new_moon_with_face:', '🌚', 'None', 0
    union select 498, ':newspaper:', '📰', 'None', 0
    union select 499, ':ng:', '🆖', 'None', 0
    union select 500, ':no_bell:', '🔕', 'None', 0
    union select 501, ':no_bicycles:', '🚳', 'None', 0
    union select 502, ':no_entry:', '', 'None', 0
    union select 503, ':no_entry_sign:', '🚫', 'None', 0
    union select 504, ':no_good:', '🙅', 'None', 0
    union select 505, ':no_mobile_phones:', '📵', 'None', 0
    union select 506, ':no_mouth:', '😶', 'None', 0
    union select 507, ':no_pedestrians:', '🚷', 'None', 0
    union select 508, ':no_smoking:', '🚭', 'None', 0
    union select 509, ':non-potable_water:', '🚱', 'None', 0
    union select 510, ':nose:', '👃', 'None', 0
    union select 511, ':notebook:', '📓', 'None', 0
    union select 512, ':notebook_with_decorative_cover:', '📔', 'None', 0
    union select 513, ':notes:', '🎶', 'None', 0
    union select 514, ':nut_and_bolt:', '🔩', 'None', 0
    union select 515, ':o:', '', 'None', 0
    union select 516, ':o2:', '🅾', 'None', 0
    union select 517, ':ocean:', '🌊', 'None', 0
    union select 518, ':octopus:', '🐙', 'None', 0
    union select 519, ':oden:', '🍢', 'None', 0
    union select 520, ':office:', '🏢', 'None', 0
    union select 521, ':ok:', '🆗', 'None', 0
    union select 522, ':ok_hand:', '👌', 'None', 0
    union select 523, ':ok_woman:', '🙆', 'None', 0
    union select 524, ':older_man:', '👴', 'None', 0
    union select 525, ':older_woman:', '👵', 'None', 0
    union select 526, ':on:', '🔛', 'None', 0
    union select 527, ':oncoming_automobile:', '🚘', 'None', 0
    union select 528, ':oncoming_bus:', '🚍', 'None', 0
    union select 529, ':oncoming_police_car:', '🚔', 'None', 0
    union select 530, ':oncoming_taxi:', '🚖', 'None', 0
    union select 531, ':open_book:', '📖', 'None', 0
    union select 532, ':open_file_folder:', '📂', 'None', 0
    union select 533, ':open_hands:', '👐', 'None', 0
    union select 534, ':open_mouth:', '😮', 'None', 0
    union select 535, ':ophiuchus:', '', 'None', 0
    union select 536, ':orange_book:', '📙', 'None', 0
    union select 537, ':outbox_tray:', '📤', 'None', 0
    union select 538, ':ox:', '🐂', 'None', 0
    union select 539, ':package:', '📦', 'None', 0
    union select 540, ':page_facing_up:', '📄', 'None', 0
    union select 541, ':page_with_curl:', '📃', 'None', 0
    union select 542, ':pager:', '📟', 'None', 0
    union select 543, ':palm_tree:', '🌴', 'None', 0
    union select 544, ':panda_face:', '🐼', 'None', 0
    union select 545, ':paperclip:', '📎', 'None', 0
    union select 546, ':parking:', '🅿', 'None', 0
    union select 547, ':part_alternation_mark:', '', 'None', 0
    union select 548, ':partly_sunny:', '', 'None', 0
    union select 549, ':passport_control:', '🛂', 'None', 0
    union select 550, ':paw_prints:', '🐾', 'None', 0
    union select 551, ':peach:', '🍑', 'None', 0
    union select 552, ':pear:', '🍐', 'None', 0
    union select 553, ':pencil:', '📝', 'None', 0
    union select 554, ':pencil2:', '', 'None', 0
    union select 555, ':penguin:', '🐧', 'None', 0
    union select 556, ':pensive:', '😔', 'None', 0
    union select 557, ':performing_arts:', '🎭', 'None', 0
    union select 558, ':persevere:', '😣', 'None', 0
    union select 559, ':person_frowning:', '🙍', 'None', 0
    union select 560, ':person_with_blond_hair:', '👱', 'None', 0
    union select 561, ':person_with_pouting_face:', '🙎', 'None', 0
    union select 562, ':phone:', '', 'None', 0
    union select 563, ':pig:', '🐷', 'None', 0
    union select 564, ':pig2:', '🐖', 'None', 0
    union select 565, ':pig_nose:', '🐽', 'None', 0
    union select 566, ':pill:', '💊', 'None', 0
    union select 567, ':pineapple:', '🍍', 'None', 0
    union select 568, ':pisces:', '', 'None', 0
    union select 569, ':pizza:', '🍕', 'None', 0
    union select 570, ':point_down:', '👇', 'None', 0
    union select 571, ':point_left:', '👈', 'None', 0
    union select 572, ':point_right:', '👉', 'None', 0
    union select 573, ':point_up:', '', 'None', 0
    union select 574, ':point_up_2:', '👆', 'None', 0
    union select 575, ':police_car:', '🚓', 'None', 0
    union select 576, ':poodle:', '🐩', 'None', 0
    union select 577, ':poop:', '💩', 'None', 0
    union select 578, ':post_office:', '🏣', 'None', 0
    union select 579, ':postal_horn:', '📯', 'None', 0
    union select 580, ':postbox:', '📮', 'None', 0
    union select 581, ':potable_water:', '🚰', 'None', 0
    union select 582, ':pouch:', '👝', 'None', 0
    union select 583, ':poultry_leg:', '🍗', 'None', 0
    union select 584, ':pound:', '💷', 'None', 0
    union select 585, ':pouting_cat:', '😾', 'None', 0
    union select 586, ':pray:', '🙏', 'None', 0
    union select 587, ':princess:', '👸', 'None', 0
    union select 588, ':punch:', '👊', 'None', 0
    union select 589, ':purple_heart:', '💜', 'None', 0
    union select 590, ':purse:', '👛', 'None', 0
    union select 591, ':pushpin:', '📌', 'None', 0
    union select 592, ':put_litter_in_its_place:', '🚮', 'None', 0
    union select 593, ':question:', '', 'None', 0
    union select 594, ':rabbit:', '🐰', 'None', 0
    union select 595, ':rabbit2:', '🐇', 'None', 0
    union select 596, ':racehorse:', '🐎', 'None', 0
    union select 597, ':radio:', '📻', 'None', 0
    union select 598, ':radio_button:', '🔘', 'None', 0
    union select 599, ':rage:', '😡', 'None', 0
    union select 600, ':railway_car:', '🚃', 'None', 0
    union select 601, ':rainbow:', '🌈', 'None', 0
    union select 602, ':raised_hand:', '', 'None', 0
    union select 603, ':raised_hands:', '🙌', 'None', 0
    union select 604, ':raising_hand:', '🙋', 'None', 0
    union select 605, ':ram:', '🐏', 'None', 0
    union select 606, ':ramen:', '🍜', 'None', 0
    union select 607, ':rat:', '🐀', 'None', 0
    union select 608, ':recycle:', '', 'None', 0
    union select 609, ':red_car:', '🚗', 'None', 0
    union select 610, ':red_circle:', '🔴', 'None', 0
    union select 611, ':registered:', '®', 'None', 0
    union select 612, ':relaxed:', '', 'None', 0
    union select 613, ':relieved:', '😌', 'None', 0
    union select 614, ':repeat:', '🔁', 'None', 0
    union select 615, ':repeat_one:', '🔂', 'None', 0
    union select 616, ':restroom:', '🚻', 'None', 0
    union select 617, ':revolving_hearts:', '💞', 'None', 0
    union select 618, ':rewind:', '', 'None', 0
    union select 619, ':ribbon:', '🎀', 'None', 0
    union select 620, ':rice:', '🍚', 'None', 0
    union select 621, ':rice_ball:', '🍙', 'None', 0
    union select 622, ':rice_cracker:', '🍘', 'None', 0
    union select 623, ':rice_scene:', '🎑', 'None', 0
    union select 624, ':ring:', '💍', 'None', 0
    union select 625, ':rocket:', '🚀', 'None', 0
    union select 626, ':roller_coaster:', '🎢', 'None', 0
    union select 627, ':rooster:', '🐓', 'None', 0
    union select 628, ':rose:', '🌹', 'None', 0
    union select 629, ':rotating_light:', '🚨', 'None', 0
    union select 630, ':round_pushpin:', '📍', 'None', 0
    union select 631, ':rowboat:', '🚣', 'None', 0
    union select 632, ':rugby_football:', '🏉', 'None', 0
    union select 633, ':runner:', '🏃', 'None', 0
    union select 634, ':running:', '🏃', 'None', 0
    union select 635, ':running_shirt_with_sash:', '🎽', 'None', 0
    union select 636, ':sa:', '🈂', 'None', 0
    union select 637, ':sagittarius:', '', 'None', 0
    union select 638, ':sailboat:', '', 'None', 0
    union select 639, ':sake:', '🍶', 'None', 0
    union select 640, ':sandal:', '👡', 'None', 0
    union select 641, ':santa:', '🎅', 'None', 0
    union select 642, ':satellite:', '📡', 'None', 0
    union select 643, ':satisfied:', '😆', 'None', 0
    union select 644, ':saxophone:', '🎷', 'None', 0
    union select 645, ':school:', '🏫', 'None', 0
    union select 646, ':school_satchel:', '🎒', 'None', 0
    union select 647, ':scissors:', '', 'None', 0
    union select 648, ':scorpius:', '', 'None', 0
    union select 649, ':scream:', '😱', 'None', 0
    union select 650, ':scream_cat:', '🙀', 'None', 0
    union select 651, ':scroll:', '📜', 'None', 0
    union select 652, ':seat:', '💺', 'None', 0
    union select 653, ':secret:', '', 'None', 0
    union select 654, ':see_no_evil:', '🙈', 'None', 0
    union select 655, ':seedling:', '🌱', 'None', 0
    union select 656, ':shaved_ice:', '🍧', 'None', 0
    union select 657, ':sheep:', '🐑', 'None', 0
    union select 658, ':shell:', '🐚', 'None', 0
    union select 659, ':ship:', '🚢', 'None', 0
    union select 660, ':shirt:', '👕', 'None', 0
    union select 661, ':shit:', '💩', 'None', 0
    union select 662, ':shoe:', '👞', 'None', 0
    union select 663, ':shower:', '🚿', 'None', 0
    union select 664, ':signal_strength:', '📶', 'None', 0
    union select 665, ':six_pointed_star:', '🔯', 'None', 0
    union select 666, ':ski:', '🎿', 'None', 0
    union select 667, ':skull:', '💀', 'None', 0
    union select 668, ':sleeping:', '😴', 'None', 0
    union select 669, ':sleepy:', '😪', 'None', 0
    union select 670, ':slot_machine:', '🎰', 'None', 0
    union select 671, ':small_blue_diamond:', '🔹', 'None', 0
    union select 672, ':small_orange_diamond:', '🔸', 'None', 0
    union select 673, ':small_red_triangle:', '🔺', 'None', 0
    union select 674, ':small_red_triangle_down:', '🔻', 'None', 0
    union select 675, ':smile:', '😄', 'None', 0
    union select 676, ':smile_cat:', '😸', 'None', 0
    union select 677, ':smiley:', '😃', 'None', 0
    union select 678, ':smiley_cat:', '😺', 'None', 0
    union select 679, ':smiling_imp:', '😈', 'None', 0
    union select 680, ':smirk:', '😏', 'None', 0
    union select 681, ':smirk_cat:', '😼', 'None', 0
    union select 682, ':smoking:', '🚬', 'None', 0
    union select 683, ':snail:', '🐌', 'None', 0
    union select 684, ':snake:', '🐍', 'None', 0
    union select 685, ':snowboarder:', '🏂', 'None', 0
    union select 686, ':snowflake:', '', 'None', 0
    union select 687, ':snowman:', '', 'None', 0
    union select 688, ':sob:', '😭', 'None', 0
    union select 689, ':soccer:', '', 'None', 0
    union select 690, ':soon:', '🔜', 'None', 0
    union select 691, ':sos:', '🆘', 'None', 0
    union select 692, ':sound:', '🔉', 'None', 0
    union select 693, ':space_invader:', '👾', 'None', 0
    union select 694, ':spades:', '', 'None', 0
    union select 695, ':spaghetti:', '🍝', 'None', 0
    union select 696, ':sparkle:', '', 'None', 0
    union select 697, ':sparkler:', '🎇', 'None', 0
    union select 698, ':sparkles:', '', 'None', 0
    union select 699, ':sparkling_heart:', '💖', 'None', 0
    union select 700, ':speak_no_evil:', '🙊', 'None', 0
    union select 701, ':speaker:', '🔊', 'None', 0
    union select 702, ':speech_balloon:', '💬', 'None', 0
    union select 703, ':speedboat:', '🚤', 'None', 0
    union select 704, ':star:', '', 'None', 0
    union select 705, ':star2:', '🌟', 'None', 0
    union select 706, ':stars:', '🌃', 'None', 0
    union select 707, ':station:', '🚉', 'None', 0
    union select 708, ':statue_of_liberty:', '🗽', 'None', 0
    union select 709, ':steam_locomotive:', '🚂', 'None', 0
    union select 710, ':stew:', '🍲', 'None', 0
    union select 711, ':straight_ruler:', '📏', 'None', 0
    union select 712, ':strawberry:', '🍓', 'None', 0
    union select 713, ':stuck_out_tongue:', '😛', 'None', 0
    union select 714, ':stuck_out_tongue_closed_eyes:', '😝', 'None', 0
    union select 715, ':stuck_out_tongue_winking_eye:', '😜', 'None', 0
    union select 716, ':sun_with_face:', '🌞', 'None', 0
    union select 717, ':sunflower:', '🌻', 'None', 0
    union select 718, ':sunglasses:', '😎', 'None', 0
    union select 719, ':sunny:', '', 'None', 0
    union select 720, ':sunrise:', '🌅', 'None', 0
    union select 721, ':sunrise_over_mountains:', '🌄', 'None', 0
    union select 722, ':surfer:', '🏄', 'None', 0
    union select 723, ':sushi:', '🍣', 'None', 0
    union select 724, ':suspension_railway:', '🚟', 'None', 0
    union select 725, ':sweat:', '😓', 'None', 0
    union select 726, ':sweat_drops:', '💦', 'None', 0
    union select 727, ':sweat_smile:', '😅', 'None', 0
    union select 728, ':sweet_potato:', '🍠', 'None', 0
    union select 729, ':swimmer:', '🏊', 'None', 0
    union select 730, ':symbols:', '🔣', 'None', 0
    union select 731, ':syringe:', '💉', 'None', 0
    union select 732, ':tada:', '🎉', 'None', 0
    union select 733, ':tanabata_tree:', '🎋', 'None', 0
    union select 734, ':tangerine:', '🍊', 'None', 0
    union select 735, ':taurus:', '', 'None', 0
    union select 736, ':taxi:', '🚕', 'None', 0
    union select 737, ':tea:', '🍵', 'None', 0
    union select 738, ':telephone:', '', 'None', 0
    union select 739, ':telephone_receiver:', '📞', 'None', 0
    union select 740, ':telescope:', '🔭', 'None', 0
    union select 741, ':tennis:', '🎾', 'None', 0
    union select 742, ':tent:', '', 'None', 0
    union select 743, ':thought_balloon:', '💭', 'None', 0
    union select 744, ':thumbsdown:', '👎', 'None', 0
    union select 745, ':thumbsup:', '👍', 'None', 0
    union select 746, ':ticket:', '🎫', 'None', 0
    union select 747, ':tiger:', '🐯', 'None', 0
    union select 748, ':tiger2:', '🐅', 'None', 0
    union select 749, ':tired_face:', '😫', 'None', 0
    union select 750, ':tm:', '', 'None', 0
    union select 751, ':toilet:', '🚽', 'None', 0
    union select 752, ':tokyo_tower:', '🗼', 'None', 0
    union select 753, ':tomato:', '🍅', 'None', 0
    union select 754, ':tongue:', '👅', 'None', 0
    union select 755, ':top:', '🔝', 'None', 0
    union select 756, ':tophat:', '🎩', 'None', 0
    union select 757, ':tractor:', '🚜', 'None', 0
    union select 758, ':traffic_light:', '🚥', 'None', 0
    union select 759, ':train:', '🚃', 'None', 0
    union select 760, ':train2:', '🚆', 'None', 0
    union select 761, ':tram:', '🚊', 'None', 0
    union select 762, ':triangular_flag_on_post:', '🚩', 'None', 0
    union select 763, ':triangular_ruler:', '📐', 'None', 0
    union select 764, ':trident:', '🔱', 'None', 0
    union select 765, ':triumph:', '😤', 'None', 0
    union select 766, ':trolleybus:', '🚎', 'None', 0
    union select 767, ':trophy:', '🏆', 'None', 0
    union select 768, ':tropical_drink:', '🍹', 'None', 0
    union select 769, ':tropical_fish:', '🐠', 'None', 0
    union select 770, ':truck:', '🚚', 'None', 0
    union select 771, ':trumpet:', '🎺', 'None', 0
    union select 772, ':tshirt:', '👕', 'None', 0
    union select 773, ':tulip:', '🌷', 'None', 0
    union select 774, ':turtle:', '🐢', 'None', 0
    union select 775, ':tv:', '📺', 'None', 0
    union select 776, ':twisted_rightwards_arrows:', '🔀', 'None', 0
    union select 777, ':two_hearts:', '💕', 'None', 0
    union select 778, ':two_men_holding_hands:', '👬', 'None', 0
    union select 779, ':two_women_holding_hands:', '👭', 'None', 0
    union select 780, ':u5272:', '🈹', 'None', 0
    union select 781, ':u5408:', '🈴', 'None', 0
    union select 782, ':u55b6:', '🈺', 'None', 0
    union select 783, ':u6307:', '🈯', 'None', 0
    union select 784, ':u6708:', '🈷', 'None', 0
    union select 785, ':u6709:', '🈶', 'None', 0
    union select 786, ':u6e80:', '🈵', 'None', 0
    union select 787, ':u7121:', '🈚', 'None', 0
    union select 788, ':u7533:', '🈸', 'None', 0
    union select 789, ':u7981:', '🈲', 'None', 0
    union select 790, ':u7a7a:', '🈳', 'None', 0
    union select 791, ':umbrella:', '', 'None', 0
    union select 792, ':unamused:', '😒', 'None', 0
    union select 793, ':underage:', '🔞', 'None', 0
    union select 794, ':unlock:', '🔓', 'None', 0
    union select 795, ':up:', '🆙', 'None', 0
    union select 796, ':v:', '', 'None', 0
    union select 797, ':vertical_traffic_light:', '🚦', 'None', 0
    union select 798, ':vhs:', '📼', 'None', 0
    union select 799, ':vibration_mode:', '📳', 'None', 0
    union select 800, ':video_camera:', '📹', 'None', 0
    union select 801, ':video_game:', '🎮', 'None', 0
    union select 802, ':violin:', '🎻', 'None', 0
    union select 803, ':virgo:', '', 'None', 0
    union select 804, ':volcano:', '🌋', 'None', 0
    union select 805, ':vs:', '🆚', 'None', 0
    union select 806, ':walking:', '🚶', 'None', 0
    union select 807, ':waning_crescent_moon:', '🌘', 'None', 0
    union select 808, ':waning_gibbous_moon:', '🌖', 'None', 0
    union select 809, ':warning:', '', 'None', 0
    union select 810, ':watch:', '', 'None', 0
    union select 811, ':water_buffalo:', '🐃', 'None', 0
    union select 812, ':watermelon:', '🍉', 'None', 0
    union select 813, ':wave:', '👋', 'None', 0
    union select 814, ':wavy_dash:', '', 'None', 0
    union select 815, ':waxing_crescent_moon:', '🌒', 'None', 0
    union select 816, ':waxing_gibbous_moon:', '🌔', 'None', 0
    union select 817, ':wc:', '🚾', 'None', 0
    union select 818, ':weary:', '😩', 'None', 0
    union select 819, ':wedding:', '💒', 'None', 0
    union select 820, ':whale:', '🐳', 'None', 0
    union select 821, ':whale2:', '🐋', 'None', 0
    union select 822, ':wheelchair:', '', 'None', 0
    union select 823, ':white_check_mark:', '', 'None', 0
    union select 824, ':white_circle:', '', 'None', 0
    union select 825, ':white_flower:', '💮', 'None', 0
    union select 826, ':white_large_square:', '', 'None', 0
    union select 827, ':white_medium_small_square:', '', 'None', 0
    union select 828, ':white_medium_square:', '', 'None', 0
    union select 829, ':white_small_square:', '', 'None', 0
    union select 830, ':white_square_button:', '🔳', 'None', 0
    union select 831, ':wind_chime:', '🎐', 'None', 0
    union select 832, ':wine_glass:', '🍷', 'None', 0
    union select 833, ':wink:', '😉', 'None', 0
    union select 834, ':wolf:', '🐺', 'None', 0
    union select 835, ':woman:', '👩', 'None', 0
    union select 836, ':womans_clothes:', '👚', 'None', 0
    union select 837, ':womans_hat:', '👒', 'None', 0
    union select 838, ':womens:', '🚺', 'None', 0
    union select 839, ':worried:', '😟', 'None', 0
    union select 840, ':wrench:', '🔧', 'None', 0
    union select 841, ':x:', '', 'None', 0
    union select 842, ':yellow_heart:', '💛', 'None', 0
    union select 843, ':yen:', '💴', 'None', 0
    union select 844, ':yum:', '😋', 'None', 0
    union select 845, ':zap:', '', 'None', 0
    union select 846, ':zzz:', '💤', 'None', 0;


    INSERT INTO 'snippets'
    select 2 as 'sid', ':+1:' as 'title', '👍' as 'body', 'None' as 'syntax', 0 as 'usageCount'
    union select 3, ':-1:', '👎', 'None', 0
    union select 4, ':100:', '💯', 'None', 0
    union select 5, ':1234:', '🔢', 'None', 0
    union select 6, ':8ball:', '🎱', 'None', 0
    union select 7, ':a:', '🅰', 'None', 0
    union select 8, ':ab:', '🆎', 'None', 0
    union select 9, ':abc:', '🔤', 'None', 0
    union select 10, ':abcd:', '🔡', 'None', 0
    union select 11, ':accept:', '🉑', 'None', 0
    union select 12, ':aerial_tramway:', '🚡', 'None', 0
    union select 13, ':airplane:', '', 'None', 0
    union select 14, ':alarm_clock:', '', 'None', 0
    union select 15, ':alien:', '👽', 'None', 0
    union select 16, ':ambulance:', '🚑', 'None', 0
    union select 17, ':anchor:', '', 'None', 0
    union select 18, ':angel:', '👼', 'None', 0
    union select 19, ':anger:', '💢', 'None', 0
    union select 20, ':angry:', '😠', 'None', 0
    union select 21, ':anguished:', '😧', 'None', 0
    union select 22, ':ant:', '🐜', 'None', 0
    union select 23, ':apple:', '🍎', 'None', 0
    union select 24, ':aquarius:', '', 'None', 0
    union select 25, ':aries:', '', 'None', 0
    union select 26, ':arrow_backward:', '', 'None', 0
    union select 27, ':arrow_double_down:', '', 'None', 0
    union select 28, ':arrow_double_up:', '', 'None', 0
    union select 29, ':arrow_down:', '', 'None', 0
    union select 30, ':arrow_down_small:', '🔽', 'None', 0
    union select 31, ':arrow_forward:', '', 'None', 0
    union select 32, ':arrow_heading_down:', '', 'None', 0
    union select 33, ':arrow_heading_up:', '', 'None', 0
    union select 34, ':arrow_left:', '', 'None', 0
    union select 35, ':arrow_lower_left:', '', 'None', 0
    union select 36, ':arrow_lower_right:', '', 'None', 0
    union select 37, ':arrow_right:', '', 'None', 0
    union select 38, ':arrow_right_hook:', '', 'None', 0
    union select 39, ':arrow_up:', '', 'None', 0
    union select 40, ':arrow_up_down:', '', 'None', 0
    union select 41, ':arrow_up_small:', '🔼', 'None', 0
    union select 42, ':arrow_upper_left:', '', 'None', 0
    union select 43, ':arrow_upper_right:', '', 'None', 0
    union select 44, ':arrows_clockwise:', '🔃', 'None', 0
    union select 45, ':arrows_counterclockwise:', '🔄', 'None', 0
    union select 46, ':art:', '🎨', 'None', 0
    union select 47, ':articulated_lorry:', '🚛', 'None', 0
    union select 48, ':astonished:', '😲', 'None', 0
    union select 49, ':athletic_shoe:', '👟', 'None', 0
    union select 50, ':atm:', '🏧', 'None', 0
    union select 51, ':b:', '🅱', 'None', 0
    union select 52, ':baby:', '👶', 'None', 0
    union select 53, ':baby_bottle:', '🍼', 'None', 0
    union select 54, ':baby_chick:', '🐤', 'None', 0
    union select 55, ':baby_symbol:', '🚼', 'None', 0
    union select 56, ':back:', '🔙', 'None', 0
    union select 57, ':baggage_claim:', '🛄', 'None', 0
    union select 58, ':balloon:', '🎈', 'None', 0
    union select 59, ':ballot_box_with_check:', '', 'None', 0
    union select 60, ':bamboo:', '🎍', 'None', 0
    union select 61, ':banana:', '🍌', 'None', 0
    union select 62, ':bangbang:', '', 'None', 0
    union select 63, ':bank:', '🏦', 'None', 0
    union select 64, ':bar_chart:', '📊', 'None', 0
    union select 65, ':barber:', '💈', 'None', 0
    union select 66, ':baseball:', '', 'None', 0
    union select 67, ':basketball:', '🏀', 'None', 0
    union select 68, ':bath:', '🛀', 'None', 0
    union select 69, ':bathtub:', '🛁', 'None', 0
    union select 70, ':battery:', '🔋', 'None', 0
    union select 71, ':bear:', '🐻', 'None', 0
    union select 72, ':bee:', '🐝', 'None', 0
    union select 73, ':beer:', '🍺', 'None', 0
    union select 74, ':beers:', '🍻', 'None', 0
    union select 75, ':beetle:', '🐞', 'None', 0
    union select 76, ':beginner:', '🔰', 'None', 0
    union select 77, ':bell:', '🔔', 'None', 0
    union select 78, ':bento:', '🍱', 'None', 0
    union select 79, ':bicyclist:', '🚴', 'None', 0
    union select 80, ':bike:', '🚲', 'None', 0
    union select 81, ':bikini:', '👙', 'None', 0
    union select 82, ':bird:', '🐦', 'None', 0
    union select 83, ':birthday:', '🎂', 'None', 0
    union select 84, ':black_circle:', '', 'None', 0
    union select 85, ':black_joker:', '🃏', 'None', 0
    union select 86, ':black_large_square:', '', 'None', 0
    union select 87, ':black_medium_small_square:', '', 'None', 0
    union select 88, ':black_medium_square:', '', 'None', 0
    union select 89, ':black_nib:', '', 'None', 0
    union select 90, ':black_small_square:', '', 'None', 0
    union select 91, ':black_square_button:', '🔲', 'None', 0
    union select 92, ':blossom:', '🌼', 'None', 0
    union select 93, ':blowfish:', '🐡', 'None', 0
    union select 94, ':blue_book:', '📘', 'None', 0
    union select 95, ':blue_car:', '🚙', 'None', 0
    union select 96, ':blue_heart:', '💙', 'None', 0
    union select 97, ':blush:', '😊', 'None', 0
    union select 98, ':boar:', '🐗', 'None', 0
    union select 99, ':boat:', '', 'None', 0
    union select 100, ':bomb:', '💣', 'None', 0
    union select 101, ':book:', '📖', 'None', 0
    union select 102, ':bookmark:', '🔖', 'None', 0
    union select 103, ':bookmark_tabs:', '📑', 'None', 0
    union select 104, ':books:', '📚', 'None', 0
    union select 105, ':boom:', '💥', 'None', 0
    union select 106, ':boot:', '👢', 'None', 0
    union select 107, ':bouquet:', '💐', 'None', 0
    union select 108, ':bow:', '🙇', 'None', 0
    union select 109, ':bowling:', '🎳', 'None', 0
    union select 110, ':boy:', '👦', 'None', 0
    union select 111, ':bread:', '🍞', 'None', 0
    union select 112, ':bride_with_veil:', '👰', 'None', 0
    union select 113, ':bridge_at_night:', '🌉', 'None', 0
    union select 114, ':briefcase:', '💼', 'None', 0
    union select 115, ':broken_heart:', '💔', 'None', 0
    union select 116, ':bug:', '🐛', 'None', 0
    union select 117, ':bulb:', '💡', 'None', 0
    union select 118, ':bullettrain_front:', '🚅', 'None', 0
    union select 119, ':bullettrain_side:', '🚄', 'None', 0
    union select 120, ':bus:', '🚌', 'None', 0
    union select 121, ':busstop:', '🚏', 'None', 0
    union select 122, ':bust_in_silhouette:', '👤', 'None', 0
    union select 123, ':busts_in_silhouette:', '👥', 'None', 0
    union select 124, ':cactus:', '🌵', 'None', 0
    union select 125, ':cake:', '🍰', 'None', 0
    union select 126, ':calendar:', '📆', 'None', 0
    union select 127, ':calling:', '📲', 'None', 0
    union select 128, ':camel:', '🐫', 'None', 0
    union select 129, ':camera:', '📷', 'None', 0
    union select 130, ':cancer:', '', 'None', 0
    union select 131, ':candy:', '🍬', 'None', 0
    union select 132, ':capital_abcd:', '🔠', 'None', 0
    union select 133, ':capricorn:', '', 'None', 0
    union select 134, ':car:', '🚗', 'None', 0
    union select 135, ':card_index:', '📇', 'None', 0
    union select 136, ':carousel_horse:', '🎠', 'None', 0
    union select 137, ':cat:', '🐱', 'None', 0
    union select 138, ':cat2:', '🐈', 'None', 0
    union select 139, ':cd:', '💿', 'None', 0
    union select 140, ':chart:', '💹', 'None', 0
    union select 141, ':chart_with_downwards_trend:', '📉', 'None', 0
    union select 142, ':chart_with_upwards_trend:', '📈', 'None', 0
    union select 143, ':checkered_flag:', '🏁', 'None', 0
    union select 144, ':cherries:', '🍒', 'None', 0
    union select 145, ':cherry_blossom:', '🌸', 'None', 0
    union select 146, ':chestnut:', '🌰', 'None', 0
    union select 147, ':chicken:', '🐔', 'None', 0
    union select 148, ':children_crossing:', '🚸', 'None', 0
    union select 149, ':chocolate_bar:', '🍫', 'None', 0
    union select 150, ':christmas_tree:', '🎄', 'None', 0
    union select 151, ':church:', '', 'None', 0
    union select 152, ':cinema:', '🎦', 'None', 0
    union select 153, ':circus_tent:', '🎪', 'None', 0
    union select 154, ':city_sunrise:', '🌇', 'None', 0
    union select 155, ':city_sunset:', '🌆', 'None', 0
    union select 156, ':cl:', '🆑', 'None', 0
    union select 157, ':clap:', '👏', 'None', 0
    union select 158, ':clapper:', '🎬', 'None', 0
    union select 159, ':clipboard:', '📋', 'None', 0
    union select 160, ':clock1:', '🕐', 'None', 0
    union select 161, ':clock10:', '🕙', 'None', 0
    union select 162, ':clock1030:', '🕥', 'None', 0
    union select 163, ':clock11:', '🕚', 'None', 0
    union select 164, ':clock1130:', '🕦', 'None', 0
    union select 165, ':clock12:', '🕛', 'None', 0
    union select 166, ':clock1230:', '🕧', 'None', 0
    union select 167, ':clock130:', '🕜', 'None', 0
    union select 168, ':clock2:', '🕑', 'None', 0
    union select 169, ':clock230:', '🕝', 'None', 0
    union select 170, ':clock3:', '🕒', 'None', 0
    union select 171, ':clock330:', '🕞', 'None', 0
    union select 172, ':clock4:', '🕓', 'None', 0
    union select 173, ':clock430:', '🕟', 'None', 0
    union select 174, ':clock5:', '🕔', 'None', 0
    union select 175, ':clock530:', '🕠', 'None', 0
    union select 176, ':clock6:', '🕕', 'None', 0
    union select 177, ':clock630:', '🕡', 'None', 0
    union select 178, ':clock7:', '🕖', 'None', 0
    union select 179, ':clock730:', '🕢', 'None', 0
    union select 180, ':clock8:', '🕗', 'None', 0
    union select 181, ':clock830:', '🕣', 'None', 0
    union select 182, ':clock9:', '🕘', 'None', 0
    union select 183, ':clock930:', '🕤', 'None', 0
    union select 184, ':closed_book:', '📕', 'None', 0
    union select 185, ':closed_lock_with_key:', '🔐', 'None', 0
    union select 186, ':closed_umbrella:', '🌂', 'None', 0
    union select 187, ':cloud:', '', 'None', 0
    union select 188, ':clubs:', '', 'None', 0
    union select 189, ':cocktail:', '🍸', 'None', 0
    union select 190, ':coffee:', '', 'None', 0
    union select 191, ':cold_sweat:', '😰', 'None', 0
    union select 192, ':collision:', '💥', 'None', 0
    union select 193, ':computer:', '💻', 'None', 0
    union select 194, ':confetti_ball:', '🎊', 'None', 0
    union select 195, ':confounded:', '😖', 'None', 0
    union select 196, ':confused:', '😕', 'None', 0
    union select 197, ':congratulations:', '', 'None', 0
    union select 198, ':construction:', '🚧', 'None', 0
    union select 199, ':construction_worker:', '👷', 'None', 0
    union select 200, ':convenience_store:', '🏪', 'None', 0
    union select 201, ':cookie:', '🍪', 'None', 0
    union select 202, ':cool:', '🆒', 'None', 0
    union select 203, ':cop:', '👮', 'None', 0
    union select 204, ':copyright:', '©', 'None', 0
    union select 205, ':corn:', '🌽', 'None', 0
    union select 206, ':couple:', '👫', 'None', 0
    union select 207, ':couple_with_heart:', '💑', 'None', 0
    union select 208, ':couplekiss:', '💏', 'None', 0
    union select 209, ':cow:', '🐮', 'None', 0
    union select 210, ':cow2:', '🐄', 'None', 0
    union select 211, ':credit_card:', '💳', 'None', 0
    union select 212, ':crescent_moon:', '🌙', 'None', 0
    union select 213, ':crocodile:', '🐊', 'None', 0
    union select 214, ':crossed_flags:', '🎌', 'None', 0
    union select 215, ':crown:', '👑', 'None', 0
    union select 216, ':cry:', '😢', 'None', 0
    union select 217, ':crying_cat_face:', '😿', 'None', 0
    union select 218, ':crystal_ball:', '🔮', 'None', 0
    union select 219, ':cupid:', '💘', 'None', 0
    union select 220, ':curly_loop:', '', 'None', 0
    union select 221, ':currency_exchange:', '💱', 'None', 0
    union select 222, ':curry:', '🍛', 'None', 0
    union select 223, ':custard:', '🍮', 'None', 0
    union select 224, ':customs:', '🛃', 'None', 0
    union select 225, ':cyclone:', '🌀', 'None', 0
    union select 226, ':dancer:', '💃', 'None', 0
    union select 227, ':dancers:', '👯', 'None', 0
    union select 228, ':dango:', '🍡', 'None', 0
    union select 229, ':dart:', '🎯', 'None', 0
    union select 230, ':dash:', '💨', 'None', 0
    union select 231, ':date:', '📅', 'None', 0
    union select 232, ':deciduous_tree:', '🌳', 'None', 0
    union select 233, ':department_store:', '🏬', 'None', 0
    union select 234, ':diamond_shape_with_a_dot_inside:', '💠', 'None', 0
    union select 235, ':diamonds:', '', 'None', 0
    union select 236, ':disappointed:', '😞', 'None', 0
    union select 237, ':disappointed_relieved:', '😥', 'None', 0
    union select 238, ':dizzy:', '💫', 'None', 0
    union select 239, ':dizzy_face:', '😵', 'None', 0
    union select 240, ':do_not_litter:', '🚯', 'None', 0
    union select 241, ':dog:', '🐶', 'None', 0
    union select 242, ':dog2:', '🐕', 'None', 0
    union select 243, ':dollar:', '💵', 'None', 0
    union select 244, ':dolls:', '🎎', 'None', 0
    union select 245, ':dolphin:', '🐬', 'None', 0
    union select 246, ':door:', '🚪', 'None', 0
    union select 247, ':doughnut:', '🍩', 'None', 0
    union select 248, ':dragon:', '🐉', 'None', 0
    union select 249, ':dragon_face:', '🐲', 'None', 0
    union select 250, ':dress:', '👗', 'None', 0
    union select 251, ':dromedary_camel:', '🐪', 'None', 0
    union select 252, ':droplet:', '💧', 'None', 0
    union select 253, ':dvd:', '📀', 'None', 0
    union select 254, ':e-mail:', '📧', 'None', 0
    union select 255, ':ear:', '👂', 'None', 0
    union select 256, ':ear_of_rice:', '🌾', 'None', 0
    union select 257, ':earth_africa:', '🌍', 'None', 0
    union select 258, ':earth_americas:', '🌎', 'None', 0
    union select 259, ':earth_asia:', '🌏', 'None', 0
    union select 260, ':egg:', '🍳', 'None', 0
    union select 261, ':eggplant:', '🍆', 'None', 0
    union select 262, ':eight_pointed_black_star:', '', 'None', 0
    union select 263, ':eight_spoked_asterisk:', '', 'None', 0
    union select 264, ':electric_plug:', '🔌', 'None', 0
    union select 265, ':elephant:', '🐘', 'None', 0
    union select 266, ':email:', '', 'None', 0
    union select 267, ':end:', '🔚', 'None', 0
    union select 268, ':envelope:', '', 'None', 0
    union select 269, ':envelope_with_arrow:', '📩', 'None', 0
    union select 270, ':euro:', '💶', 'None', 0
    union select 271, ':european_castle:', '🏰', 'None', 0
    union select 272, ':european_post_office:', '🏤', 'None', 0
    union select 273, ':evergreen_tree:', '🌲', 'None', 0
    union select 274, ':exclamation:', '', 'None', 0
    union select 275, ':expressionless:', '😑', 'None', 0
    union select 276, ':eyeglasses:', '👓', 'None', 0
    union select 277, ':eyes:', '👀', 'None', 0
    union select 278, ':facepunch:', '👊', 'None', 0
    union select 279, ':factory:', '🏭', 'None', 0
    union select 280, ':fallen_leaf:', '🍂', 'None', 0
    union select 281, ':family:', '👪', 'None', 0
    union select 282, ':fast_forward:', '', 'None', 0
    union select 283, ':fax:', '📠', 'None', 0
    union select 284, ':fearful:', '😨', 'None', 0
    union select 285, ':feet:', '🐾', 'None', 0
    union select 286, ':ferris_wheel:', '🎡', 'None', 0
    union select 287, ':file_folder:', '📁', 'None', 0
    union select 288, ':fire:', '🔥', 'None', 0
    union select 289, ':fire_engine:', '🚒', 'None', 0
    union select 290, ':fireworks:', '🎆', 'None', 0
    union select 291, ':first_quarter_moon:', '🌓', 'None', 0
    union select 292, ':first_quarter_moon_with_face:', '🌛', 'None', 0
    union select 293, ':fish:', '🐟', 'None', 0
    union select 294, ':fish_cake:', '🍥', 'None', 0
    union select 295, ':fishing_pole_and_fish:', '🎣', 'None', 0
    union select 296, ':fist:', '', 'None', 0
    union select 297, ':flags:', '🎏', 'None', 0
    union select 298, ':flashlight:', '🔦', 'None', 0
    union select 299, ':flipper:', '🐬', 'None', 0
    union select 300, ':floppy_disk:', '💾', 'None', 0
    union select 301, ':flower_playing_cards:', '🎴', 'None', 0
    union select 302, ':flushed:', '😳', 'None', 0
    union select 303, ':foggy:', '🌁', 'None', 0
    union select 304, ':football:', '🏈', 'None', 0
    union select 305, ':footprints:', '👣', 'None', 0
    union select 306, ':fork_and_knife:', '🍴', 'None', 0
    union select 307, ':fountain:', '', 'None', 0
    union select 308, ':four_leaf_clover:', '🍀', 'None', 0
    union select 309, ':free:', '🆓', 'None', 0
    union select 310, ':fried_shrimp:', '🍤', 'None', 0
    union select 311, ':fries:', '🍟', 'None', 0
    union select 312, ':frog:', '🐸', 'None', 0
    union select 313, ':frowning:', '😦', 'None', 0
    union select 314, ':fuelpump:', '', 'None', 0
    union select 315, ':full_moon:', '🌕', 'None', 0
    union select 316, ':full_moon_with_face:', '🌝', 'None', 0
    union select 317, ':game_die:', '🎲', 'None', 0
    union select 318, ':gem:', '💎', 'None', 0
    union select 319, ':gemini:', '', 'None', 0
    union select 320, ':ghost:', '👻', 'None', 0
    union select 321, ':gift:', '🎁', 'None', 0
    union select 322, ':gift_heart:', '💝', 'None', 0
    union select 323, ':girl:', '👧', 'None', 0
    union select 324, ':globe_with_meridians:', '🌐', 'None', 0
    union select 325, ':goat:', '🐐', 'None', 0
    union select 326, ':golf:', '', 'None', 0
    union select 327, ':grapes:', '🍇', 'None', 0
    union select 328, ':green_apple:', '🍏', 'None', 0
    union select 329, ':green_book:', '📗', 'None', 0
    union select 330, ':green_heart:', '💚', 'None', 0
    union select 331, ':grey_exclamation:', '', 'None', 0
    union select 332, ':grey_question:', '', 'None', 0
    union select 333, ':grimacing:', '😬', 'None', 0
    union select 334, ':grin:', '😁', 'None', 0
    union select 335, ':grinning:', '😀', 'None', 0
    union select 336, ':guardsman:', '💂', 'None', 0
    union select 337, ':guitar:', '🎸', 'None', 0
    union select 338, ':gun:', '🔫', 'None', 0
    union select 339, ':haircut:', '💇', 'None', 0
    union select 340, ':hamburger:', '🍔', 'None', 0
    union select 341, ':hammer:', '🔨', 'None', 0
    union select 342, ':hamster:', '🐹', 'None', 0
    union select 343, ':hand:', '', 'None', 0
    union select 344, ':handbag:', '👜', 'None', 0
    union select 345, ':hankey:', '💩', 'None', 0
    union select 346, ':hatched_chick:', '🐥', 'None', 0
    union select 347, ':hatching_chick:', '🐣', 'None', 0
    union select 348, ':headphones:', '🎧', 'None', 0
    union select 349, ':hear_no_evil:', '🙉', 'None', 0
    union select 350, ':heart:', '', 'None', 0
    union select 351, ':heart_decoration:', '💟', 'None', 0
    union select 352, ':heart_eyes:', '😍', 'None', 0
    union select 353, ':heart_eyes_cat:', '😻', 'None', 0
    union select 354, ':heartbeat:', '💓', 'None', 0
    union select 355, ':heartpulse:', '💗', 'None', 0
    union select 356, ':hearts:', '', 'None', 0
    union select 357, ':heavy_check_mark:', '', 'None', 0
    union select 358, ':heavy_division_sign:', '', 'None', 0
    union select 359, ':heavy_dollar_sign:', '💲', 'None', 0
    union select 360, ':heavy_exclamation_mark:', '', 'None', 0
    union select 361, ':heavy_minus_sign:', '', 'None', 0
    union select 362, ':heavy_multiplication_x:', '', 'None', 0
    union select 363, ':heavy_plus_sign:', '', 'None', 0
    union select 364, ':helicopter:', '🚁', 'None', 0
    union select 365, ':herb:', '🌿', 'None', 0
    union select 366, ':hibiscus:', '🌺', 'None', 0
    union select 367, ':high_brightness:', '🔆', 'None', 0
    union select 368, ':high_heel:', '👠', 'None', 0
    union select 369, ':hocho:', '🔪', 'None', 0
    union select 370, ':honey_pot:', '🍯', 'None', 0
    union select 371, ':honeybee:', '🐝', 'None', 0
    union select 372, ':horse:', '🐴', 'None', 0
    union select 373, ':horse_racing:', '🏇', 'None', 0
    union select 374, ':hospital:', '🏥', 'None', 0
    union select 375, ':hotel:', '🏨', 'None', 0
    union select 376, ':hotsprings:', '', 'None', 0
    union select 377, ':hourglass:', '', 'None', 0
    union select 378, ':hourglass_flowing_sand:', '', 'None', 0
    union select 379, ':house:', '🏠', 'None', 0
    union select 380, ':house_with_garden:', '🏡', 'None', 0
    union select 381, ':hushed:', '😯', 'None', 0
    union select 382, ':ice_cream:', '🍨', 'None', 0
    union select 383, ':icecream:', '🍦', 'None', 0
    union select 384, ':id:', '🆔', 'None', 0
    union select 385, ':ideograph_advantage:', '🉐', 'None', 0
    union select 386, ':imp:', '👿', 'None', 0
    union select 387, ':inbox_tray:', '📥', 'None', 0
    union select 388, ':incoming_envelope:', '📨', 'None', 0
    union select 389, ':information_desk_person:', '💁', 'None', 0
    union select 390, ':information_source:', '', 'None', 0
    union select 391, ':innocent:', '😇', 'None', 0
    union select 392, ':interrobang:', '', 'None', 0
    union select 393, ':iphone:', '📱', 'None', 0
    union select 394, ':izakaya_lantern:', '🏮', 'None', 0
    union select 395, ':jack_o_lantern:', '🎃', 'None', 0
    union select 396, ':japan:', '🗾', 'None', 0
    union select 397, ':japanese_castle:', '🏯', 'None', 0
    union select 398, ':japanese_goblin:', '👺', 'None', 0
    union select 399, ':japanese_ogre:', '👹', 'None', 0
    union select 400, ':jeans:', '👖', 'None', 0
    union select 401, ':joy:', '😂', 'None', 0
    union select 402, ':joy_cat:', '😹', 'None', 0
    union select 403, ':key:', '🔑', 'None', 0
    union select 404, ':keycap_ten:', '🔟', 'None', 0
    union select 405, ':kimono:', '👘', 'None', 0
    union select 406, ':kiss:', '💋', 'None', 0
    union select 407, ':kissing:', '😗', 'None', 0
    union select 408, ':kissing_cat:', '😽', 'None', 0
    union select 409, ':kissing_closed_eyes:', '😚', 'None', 0
    union select 410, ':kissing_heart:', '😘', 'None', 0
    union select 411, ':kissing_smiling_eyes:', '😙', 'None', 0
    union select 412, ':koala:', '🐨', 'None', 0
    union select 413, ':koko:', '🈁', 'None', 0
    union select 414, ':lantern:', '🏮', 'None', 0
    union select 415, ':large_blue_circle:', '🔵', 'None', 0
    union select 416, ':large_blue_diamond:', '🔷', 'None', 0
    union select 417, ':large_orange_diamond:', '🔶', 'None', 0
    union select 418, ':last_quarter_moon:', '🌗', 'None', 0
    union select 419, ':last_quarter_moon_with_face:', '🌜', 'None', 0
    union select 420, ':laughing:', '😆', 'None', 0
    union select 421, ':leaves:', '🍃', 'None', 0
    union select 422, ':ledger:', '📒', 'None', 0
    union select 423, ':left_luggage:', '🛅', 'None', 0
    union select 424, ':left_right_arrow:', '', 'None', 0
    union select 425, ':leftwards_arrow_with_hook:', '', 'None', 0
    union select 426, ':lemon:', '🍋', 'None', 0
    union select 427, ':leo:', '', 'None', 0
    union select 428, ':leopard:', '🐆', 'None', 0
    union select 429, ':libra:', '', 'None', 0
    union select 430, ':light_rail:', '🚈', 'None', 0
    union select 431, ':link:', '🔗', 'None', 0
    union select 432, ':lips:', '👄', 'None', 0
    union select 433, ':lipstick:', '💄', 'None', 0
    union select 434, ':lock:', '🔒', 'None', 0
    union select 435, ':lock_with_ink_pen:', '🔏', 'None', 0
    union select 436, ':lollipop:', '🍭', 'None', 0
    union select 437, ':loop:', '', 'None', 0
    union select 438, ':loudspeaker:', '📢', 'None', 0
    union select 439, ':love_hotel:', '🏩', 'None', 0
    union select 440, ':love_letter:', '💌', 'None', 0
    union select 441, ':low_brightness:', '🔅', 'None', 0
    union select 442, ':m:', '', 'None', 0
    union select 443, ':mag:', '🔍', 'None', 0
    union select 444, ':mag_right:', '🔎', 'None', 0
    union select 445, ':mahjong:', '🀄', 'None', 0
    union select 446, ':mailbox:', '📫', 'None', 0
    union select 447, ':mailbox_closed:', '📪', 'None', 0
    union select 448, ':mailbox_with_mail:', '📬', 'None', 0
    union select 449, ':mailbox_with_no_mail:', '📭', 'None', 0
    union select 450, ':man:', '👨', 'None', 0
    union select 451, ':man_with_gua_pi_mao:', '👲', 'None', 0
    union select 452, ':man_with_turban:', '👳', 'None', 0
    union select 453, ':mans_shoe:', '👞', 'None', 0
    union select 454, ':maple_leaf:', '🍁', 'None', 0
    union select 455, ':mask:', '😷', 'None', 0
    union select 456, ':massage:', '💆', 'None', 0
    union select 457, ':meat_on_bone:', '🍖', 'None', 0
    union select 458, ':mega:', '📣', 'None', 0
    union select 459, ':melon:', '🍈', 'None', 0
    union select 460, ':memo:', '📝', 'None', 0
    union select 461, ':mens:', '🚹', 'None', 0
    union select 462, ':metro:', '🚇', 'None', 0
    union select 463, ':microphone:', '🎤', 'None', 0
    union select 464, ':microscope:', '🔬', 'None', 0
    union select 465, ':milky_way:', '🌌', 'None', 0
    union select 466, ':minibus:', '🚐', 'None', 0
    union select 467, ':minidisc:', '💽', 'None', 0
    union select 468, ':mobile_phone_off:', '📴', 'None', 0
    union select 469, ':money_with_wings:', '💸', 'None', 0
    union select 470, ':moneybag:', '💰', 'None', 0
    union select 471, ':monkey:', '🐒', 'None', 0
    union select 472, ':monkey_face:', '🐵', 'None', 0
    union select 473, ':monorail:', '🚝', 'None', 0
    union select 474, ':moon:', '🌔', 'None', 0
    union select 475, ':mortar_board:', '🎓', 'None', 0
    union select 476, ':mount_fuji:', '🗻', 'None', 0
    union select 477, ':mountain_bicyclist:', '🚵', 'None', 0
    union select 478, ':mountain_cableway:', '🚠', 'None', 0
    union select 479, ':mountain_railway:', '🚞', 'None', 0
    union select 480, ':mouse:', '🐭', 'None', 0
    union select 481, ':mouse2:', '🐁', 'None', 0
    union select 482, ':movie_camera:', '🎥', 'None', 0
    union select 483, ':moyai:', '🗿', 'None', 0
    union select 484, ':muscle:', '💪', 'None', 0
    union select 485, ':mushroom:', '🍄', 'None', 0
    union select 486, ':musical_keyboard:', '🎹', 'None', 0;