text: CREATE TABLE IF NOT EXISTS `PREFIX_gamifications_customer` (
    `id_gamifications_customer` INT(11) UNSIGNED AUTO_INCREMENT,
    `id_customer` INT(11) UNSIGNED NOT NULL,
    `total_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `spent_points` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `referral_code` VARCHAR(16) NOT NULL DEFAULT '',
    `spent_money` DECIMAL(17, 2) UNSIGNED NOT NULL DEFAULT 0.00,
    `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
    `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `date_add` DATETIME NOT NULL,
    `date_upd` DATETIME NOT NULL,
    PRIMARY KEY (`id_gamifications_customer`)
  ) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8;