final_bug_test_pushes.txt

mysql> select * from push_message_campaigns where game_id = 2511 and push_message_campaigns.name like 'Final Bug%'\G
*************************** 1. row ***************************
                      id: )x;LGe
                    slug: 0329783b-c54c-47c0-9007-65c3a10fb987
                 game_id: 2511
                    name: Final Bug Test
             description: NULL
          scheduled_time: NULL
         global_schedule: 1
                platform: gcm
audience_filter_url_path: /apps/2511/audience_filters/9d954fc6-a1ab-4977-aaa5-82f38e84e11a
              created_by: 7048
                archived: 0
                 deleted: 0
           track_engaged: 0
              created_at: 2015-05-18 09:04:40
              updated_at: 2015-05-18 09:04:40
               recurring: 0
       recurring_ends_at: NULL
             cohort_type: NULL
             cohort_days: NULL
 single_user_push_active: 0
                 api_key: NULL
      is_single_user_api: 0
*************************** 2. row ***************************
                      id: u
<0A-;
                    slug: 75ba0ae2-3c30-4195-a3e0-97b0fc2dcb3b
                 game_id: 2511
                    name: Final Bug Test (copy)
             description: NULL
          scheduled_time: NULL
         global_schedule: 1
                platform: gcm
audience_filter_url_path: /apps/2511/audience_filters/79e8c471-cb72-4691-b1c8-67f636d90b50
              created_by: 7048
                archived: 0
                 deleted: 0
           track_engaged: 0
              created_at: 2015-05-18 09:04:48
              updated_at: 2015-05-18 09:04:48
               recurring: 0
       recurring_ends_at: NULL
             cohort_type: NULL
             cohort_days: NULL
 single_user_push_active: 0
                 api_key: NULL
      is_single_user_api: 0
2 rows in set (0.00 sec)

mysql> select HEX(id),name from push_message_campaigns where game_id = 2511 and push_message_campaigns.name like 'Final Bug%'\G
*************************** 1. row ***************************
HEX(id): 0329783BC54C47C0900765C3A10FB987
   name: Final Bug Test
*************************** 2. row ***************************
HEX(id): 75BA0AE23C304195A3E097B0FC2DCB3B
   name: Final Bug Test (copy)

mysql> select * from push_message_campaign_variants where push_message_campaign_id=UNHEX("0329783BC54C47C0900765C3A10FB987")\G
*************************** 1. row ***************************
                      id: _4@4d Z
push_message_campaign_id: )x;LGe
        push_campaign_id: 14527
                    name: NULL
                 payload: {}
                    body: Final Bug Testing
                   sound: NULL
           variant_index: 0
        track_segment_id: 76494
                category: NULL
                   title: NULL
1 row in set (0.00 sec)

mysql> select * from push_message_campaign_variants where push_message_campaign_id=UNHEX("75BA0AE23C304195A3E097B0FC2DCB3B")\G
*************************** 1. row ***************************
                      id: /BS&}+
push_message_campaign_id: u
<0A-;
        push_campaign_id: 14526
                    name: NULL
                 payload: {}
                    body: Final Bug Testing 2
                   sound: NULL
           variant_index: 0
        track_segment_id: 76493
                category: NULL
                   title: NULL
1 row in set (0.00 sec)