CREATE TABLE IF NOT EXISTS `#__ggprovider_subscribers` (
  `id`         BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id`    INT(11)         NOT NULL,
  `msisdn`     VARCHAR(15)     NOT NULL,
  `content`    VARCHAR(32)     NOT NULL,
  `guid`       VARCHAR(36)     NOT NULL,
  `operator`   VARCHAR(16)     NOT NULL,
  `updated_at` TIMESTAMP       NOT NULL,
  `created_at` TIMESTAMP       DEFAULT CURRENT_TIMESTAMP,
  `closed_at`  TIMESTAMP       NULL,
  PRIMARY KEY (`id`),
  UNIQUE uniq_guid (`guid`),
  KEY idx_user_id (user_id),
  KEY idx_msisdn (msisdn),
  KEY idx_created_at (created_at),
  KEY idx_updated_at (updated_at),
  KEY idx_closed_at (closed_at)
)
  ENGINE = InnoDB
  AUTO_INCREMENT = 0
  DEFAULT CHARSET = utf8;