CREATE TABLE

CREATE TABLE payments_transactions (
  id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,

  TYPE enum ('Daily Earning', 'PayOut', 'Hold', 'UnHold', 'Chargeback', 'Bonus') NOT NULL,
  offer_id mediumint(8) UNSIGNED DEFAULT NULL,

  id_payin INT(11) UNSIGNED DEFAULT NULL,
  id_payout INT(11) UNSIGNED DEFAULT NULL,
  id_daily_earning INT(11) UNSIGNED DEFAULT NULL,

  amount INT(11) UNSIGNED NOT NULL DEFAULT 0,

  PRIMARY KEY (id),
  INDEX id_payout (id_payout),
  INDEX to_daily_earning (id_daily_earning),
  INDEX TYPE (TYPE)
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci;

-- дневные заработки
INSERT INTO payments_transactions (id,  TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (1,  'Daily Earning',  736,  NULL, 4, NULL, 132);
INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (2,  'Daily Earning',  736,  NULL, 4, NULL, 36);
INSERT INTO payments_transactions (id, TYPE,  offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (3,  'Daily Earning',  804, NULL, 0, NULL, 560);
-- выплата
INSERT INTO payments_transactions (id, TYPE,  offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (4,  'PayOut', 0, NULL, NULL, NULL, 364);

INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (5,  'Hold',  0, NULL, NULL, 2, 24);
INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (6,  'Hold',  0, NULL, NULL, 2, 41);

INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (7,  'Chargeback',  0, NULL, NULL, 1, 7);
INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (8,  'Chargeback',  0, NULL, NULL, 1, 11);
INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (9,  'Chargeback',  0, NULL, NULL, 1, 23);

INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (10,  'Bonus',  0, NULL, NULL, 3, 50);
INSERT INTO payments_transactions (id, TYPE, offer_id, id_payin, id_payout, id_daily_earning, amount)
  VALUES (11,  'Bonus',  0, NULL, NULL, 3, 10);