CREATE TABLE `plans` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `points` INT(11) NOT NULL,
  `bonus_points` INT(11) DEFAULT '0',
  `price` INT(11) NOT NULL,
  `stripe_plan_id` VARCHAR(100) DEFAULT NULL,
  `period` VARCHAR(100) DEFAULT NULL,
  `tagline` VARCHAR(100) DEFAULT NULL,
  `is_active` INT(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;


id  points  bonus_points    price   stripe_plan_id  period  tagline is_active
1   10000   0   19  NULL    NULL    Most Popular    1
2   25000   0   74  NULL    NULL    Good VALUE  1
3   100000  0   200 NULL    NULL    Most Savings    1
4   10000   2000    19  Month_19_10000  MONTH   NULL    1
5   25000   5000    74  Month_74_25000  MONTH   NULL    1
6   100000  25000   200 Month_200_100000    MONTH   NULL    1
7   500000  0   500 NULL    NULL    NULL    0
8   500000  0   500 monthly_500 MONTH   NULL    0
9   10000   0   0   monthly12   MONTH   Legacy Plan 0
10  1000    0   5   NULL    NULL    Quick Buy   1
11  10000   0   0   monthly MONTH   Legacy Plan 0




CREATE TABLE `paypal_payments` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT(32) DEFAULT NULL,
  `plan_id` INT(11) DEFAULT NULL,
  `txn_id` VARCHAR(200) DEFAULT NULL,
  `txn_type` VARCHAR(200) DEFAULT NULL,
  `subscr_id` VARCHAR(200) DEFAULT NULL,
  `payment_status` VARCHAR(200) DEFAULT NULL,
  `amount` VARCHAR(200) DEFAULT NULL,
  `currency` VARCHAR(200) DEFAULT NULL,
  `email` VARCHAR(200) DEFAULT NULL,
  `first_name` VARCHAR(200) DEFAULT NULL,
  `last_name` VARCHAR(200) DEFAULT NULL,
  `timestamp` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `paypal_payments_index` (`user_id`,`plan_id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;


id  user_id plan_id txn_id  txn_type    subscr_id   payment_status  amount  currency    email   first_name  last_name   TIMESTAMP
48  338258416   2   531025225   web_accept  NULL    Completed   12  USD buyer@paypalsandbox.com John    Smith   2012-10-25 22:41:19
49  338258416   5   0GT37955M4962470N   subscr_payment  I-D3MF2FP1TWXC  Completed   74  USD twitcl_1349301170_per@gmail.com Jason   Gendron 2012-10-25 22:42:54
50  338258416   5   NULL    subscr_signup   I-D3MF2FP1TWXC  NULL    0   USD twitcl_1349301170_per@gmail.com Jason   Gendron 2012-10-25 22:43:06
51  338258416   5   NULL    subscr_cancel   I-D3MF2FP1TWXC  NULL    0   USD twitcl_1349301170_per@gmail.com Jason   Gendron 2012-10-25 22:43:35
52  338258416   5   NULL    subscr_signup   I-HD125UU8VSVF  NULL    0   USD twitcl_1349301170_per@gmail.com Jason   Gendron 2012-10-25 22:59:01
53  338258416   5   9F1999022M9737809   subscr_payment  I-HD125UU8VSVF  Completed   74  USD twitcl_1349301170_per@gmail.com Jason   Gendron 2012-10-25 22:59:01



CREATE TABLE `subscriptions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT(32) NOT NULL,
  `plan_id` INT(11) NOT NULL,
  `type` VARCHAR(100) NOT NULL DEFAULT '',
  `customer_id` VARCHAR(100) NOT NULL DEFAULT '',
  `next_billing` BIGINT(32) NOT NULL,
  `is_active` INT(1) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

id  user_id     plan_id TYPE    customer_id next_billing    is_active   created
33  338258416   5   paypal  I-HD125UU8VSVF  1353797941  1   2012-10-25 22:59:01
32  338258416   5   paypal  I-D3MF2FP1TWXC  1353796974  0   2012-10-25 22:42:54



CREATE TABLE `transactions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `source_user_id` BIGINT(32) DEFAULT NULL,
  `source_points` INT(11) DEFAULT NULL,
  `source_xp` INT(11) DEFAULT NULL,
  `target_user_id` BIGINT(32) DEFAULT NULL,
  `target_points` INT(11) DEFAULT NULL,
  `target_xp` INT(11) DEFAULT NULL,
  `action_id` INT(11) DEFAULT NULL,
  `action_specific_id` VARCHAR(100) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `reversed_transactions_index` (`source_user_id`,`target_user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=133 DEFAULT CHARSET=utf8;


id  source_user_id  source_points   source_xp   target_user_id  target_points   target_xp   action_id   action_specific_id  created
132 338258416   30000   NULL    NULL    NULL    NULL    99  9F1999022M9737809   2012-10-25 22:59:01
131 338258416   25000   NULL    NULL    NULL    NULL    99  0GT37955M4962470N   2012-10-25 22:42:54
130 338258416   25000   NULL    NULL    NULL    NULL    99  531025225   2012-10-25 22:41:19