table_name	edit_count_field
MobileWebWatching_11761466	event_userEditCount
GatherClicks_11639881	event_userEditCount
GatherClicks_11770314	event_userEditCount
...

"5-99 edits"  -->  5
OR
"5-99 edits"  -->  99

MariaDB EVENTLOGGING m4 localhost log > SHOW CREATE TABLE MobileWebWatching_11761466\G
*************************** 1. row ***************************
       Table: MobileWebWatching_11761466
Create Table: CREATE TABLE `MobileWebWatching_11761466` (
  `uuid` char(32) NOT NULL,
  `clientIp` varchar(191) DEFAULT NULL,
  `timestamp` varchar(14) NOT NULL,
  `userAgent` varchar(191) DEFAULT NULL,
  `webHost` varchar(191) DEFAULT NULL,
  `wiki` varchar(191) NOT NULL,
  `event_funnel` varchar(191) NOT NULL,
  `event_isWatched` tinyint(1) NOT NULL,
  `event_mobileMode` varchar(191) NOT NULL,
  `event_userEditCount` bigint(20) DEFAULT NULL,
  `event_userId` bigint(20) NOT NULL,
  `editCountBucket` enum('0 edits','1-4 edits','5-99 edits','100-999 edits','1000+ edits') DEFAULT NULL, -- ** this is the new column **
  UNIQUE KEY `ix_MobileWebWatching_11761466_uuid` (`uuid`),
  KEY `ix_MobileWebWatching_11761466_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

(in cleanup) 2015-10-23T09:36:38 Error copying rows from 
`log`.`MobileWebClickTracking_5929948` to 
`log`.`_MobileWebClickTracking_5929948_new`: DBD::mysql::st execute failed: 
MySQL server has gone away [for Statement "SHOW GLOBAL STATUS LIKE ?" with 
ParamValues: 0='Threads_running'] at /usr/bin/pt-online-schema-change line 8157

Create Table: CREATE TABLE `MobileWebWatchlistClickTracking_10720361` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` char(32) NOT NULL,
  `clientIp` varchar(191) DEFAULT NULL,
  `clientValidated` tinyint(1) DEFAULT NULL,
  `isTruncated` tinyint(1) DEFAULT NULL,
  `timestamp` varchar(14) NOT NULL,
  `userAgent` varchar(191) DEFAULT NULL,
  `webHost` varchar(191) DEFAULT NULL,
  `wiki` varchar(191) NOT NULL,
  `event_destination` varchar(191) DEFAULT NULL,
  `event_mobileMode` varchar(191) NOT NULL,
  `event_name` varchar(191) DEFAULT NULL,
  `event_userEditCount` bigint(20) DEFAULT NULL,
  `event_username` varchar(191) DEFAULT NULL,
  `editCountBucket` enum('0 edits','1-4 edits','5-99 edits','100-999 edits','1000+ edits') DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_MobileWebWatchlistClickTracking_10720361_uuid` (`uuid`),
  KEY `ix_MobileWebWatchlistClickTracking_10720361_timestamp` (`timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=608312 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

mysql> SELECT editCountBucket FROM MobileWebWatchlistClickTracking_10720361 LIMIT 1\G
*************************** 1. row ***************************
editCountBucket: NULL
1 row in set (0.00 sec)

MobileWebClickTracking_5830671:
ERROR 1146 (42S02) at line 1: Table 'log.MobileWebClickTracking_5830671' doesn't exist
MobileWebClickTracking_5830800:
ERROR 1146 (42S02) at line 1: Table 'log.MobileWebClickTracking_5830800' doesn't exist
MobileWebClickTracking_5929948:

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebWatchlistClickTracking_10720361_editCountBucket_BI
BEFORE INSERT ON MobileWebWatchlistClickTracking_10720361
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

$ ./eventlogging_triggers.sh 

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebWatching_11761466_editCountBucket_BI
BEFORE INSERT ON MobileWebWatching_11761466
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
GatherClicks_11639881_editCountBucket_BI
BEFORE INSERT ON GatherClicks_11639881
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
GatherClicks_11770314_editCountBucket_BI
BEFORE INSERT ON GatherClicks_11770314
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
GatherClicks_12114785_editCountBucket_BI
BEFORE INSERT ON GatherClicks_12114785
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
GatherFlags_11793295_editCountBucket_BI
BEFORE INSERT ON GatherFlags_11793295
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebClickTracking_5830671_editCountBucket_BI
BEFORE INSERT ON MobileWebClickTracking_5830671
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebClickTracking_5830800_editCountBucket_BI
BEFORE INSERT ON MobileWebClickTracking_5830800
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebClickTracking_5929948_editCountBucket_BI
BEFORE INSERT ON MobileWebClickTracking_5929948
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebCta_5972486_editCountBucket_BI
BEFORE INSERT ON MobileWebCta_5972486
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebCta_5972684_editCountBucket_BI
BEFORE INSERT ON MobileWebCta_5972684
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebDiffClickTracking_10720373_editCountBucket_BI
BEFORE INSERT ON MobileWebDiffClickTracking_10720373
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebMainMenuClickTracking_10703095_editCountBucket_BI
BEFORE INSERT ON MobileWebMainMenuClickTracking_10703095
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebMainMenuClickTracking_11568715_editCountBucket_BI
BEFORE INSERT ON MobileWebMainMenuClickTracking_11568715
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebUIClickTracking_10742159_editCountBucket_BI
BEFORE INSERT ON MobileWebUIClickTracking_10742159
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

SET SESSION sql_log_bin = 0;
CREATE TRIGGER
MobileWebWatchlistClickTracking_10720361_editCountBucket_BI
BEFORE INSERT ON MobileWebWatchlistClickTracking_10720361
FOR EACH ROW
  SET NEW.editCountBucket =
      CASE 
          WHEN NEW.event_userEditCount = 0                 THEN '0 edits'
          WHEN NEW.event_userEditCount BETWEEN   1 AND   4 THEN '1-4 edits'
          WHEN NEW.event_userEditCount BETWEEN   5 AND  99 THEN '5-99 edits'
          WHEN NEW.event_userEditCount BETWEEN 100 AND 999 THEN '100-999 edits'
          WHEN NEW.event_userEditCount >= 1000             THEN '1000+ edits'
          ELSE NULL
      END
;

MariaDB  db1046.eqiad.wmnet log > SELECT trigger_name, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.triggers;
+-------------------------------------------------------------+---------------------+------------------------------------------+
| trigger_name                                                | EVENT_OBJECT_SCHEMA | EVENT_OBJECT_TABLE                       |
+-------------------------------------------------------------+---------------------+------------------------------------------+
| GatherClicks_11639881_editCountBucket_BI                    | log                 | GatherClicks_11639881                    |
| GatherClicks_11770314_editCountBucket_BI                    | log                 | GatherClicks_11770314                    |
| GatherClicks_12114785_editCountBucket_BI                    | log                 | GatherClicks_12114785                    |
| GatherFlags_11793295_editCountBucket_BI                     | log                 | GatherFlags_11793295                     |
| MobileWebClickTracking_5929948_editCountBucket_BI           | log                 | MobileWebClickTracking_5929948           |
| MobileWebCta_5972486_editCountBucket_BI                     | log                 | MobileWebCta_5972486                     |
| MobileWebCta_5972684_editCountBucket_BI                     | log                 | MobileWebCta_5972684                     |
| MobileWebDiffClickTracking_10720373_editCountBucket_BI      | log                 | MobileWebDiffClickTracking_10720373      |
| MobileWebMainMenuClickTracking_10703095_editCountBucket_BI  | log                 | MobileWebMainMenuClickTracking_10703095  |
| MobileWebMainMenuClickTracking_11568715_editCountBucket_BI  | log                 | MobileWebMainMenuClickTracking_11568715  |
| MobileWebUIClickTracking_10742159_editCountBucket_BI        | log                 | MobileWebUIClickTracking_10742159        |
| MobileWebWatching_11761466_editCountBucket_BI               | log                 | MobileWebWatching_11761466               |
| MobileWebWatchlistClickTracking_10720361_editCountBucket_BI | log                 | MobileWebWatchlistClickTracking_10720361 |
+-------------------------------------------------------------+---------------------+------------------------------------------+
13 rows in set (0.01 sec)

MariaDB  dbstore1002.eqiad.wmnet log > SELECT event_userEditCount, editCountBucket FROM MobileWebCta_5972684 ORDER BY timestamp DESC LIMIT 10;
+---------------------+-----------------+
| event_userEditCount | editCountBucket |
+---------------------+-----------------+
|                 260 | 100-999 edits   |
|                   1 | 1-4 edits       |
|                   1 | 1-4 edits       |
|                   0 | 0 edits         |
|                   1 | 1-4 edits       |
|                   1 | 1-4 edits       |
|                   0 | 0 edits         |
|                   4 | 1-4 edits       |
|                   1 | 1-4 edits       |
|                   1 | 1-4 edits       |
+---------------------+-----------------+
10 rows in set (0.00 sec)