CREATE TABLE `transactions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` VARCHAR(255) DEFAULT NULL,
  `user_id` INT(11) NOT NULL,
  `product_id` VARCHAR(50) DEFAULT NULL,
  `product_name` VARCHAR(255) DEFAULT NULL,
  `pay_key` VARCHAR(50) DEFAULT NULL,
  `sender_email` VARCHAR(255) DEFAULT NULL,
  `amount` DECIMAL(10,2) DEFAULT NULL,
  `currency` VARCHAR(10) DEFAULT NULL,
  `discount` INT(11) DEFAULT '0',
  `typediscount` VARCHAR(20) DEFAULT 'none',
  `status` VARCHAR(50) DEFAULT NULL,
  `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=530211 DEFAULT CHARSET=latin1