/* QUERY START */
SET foreign_key_checks = 0;
/* QUERY END */

/* QUERY START */
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';
/* QUERY END */

/* QUERY START */
SET time_zone = '+00:00';
/* QUERY END */

/* QUERY START */
SET NAMES 'utf8';
/* QUERY END */

/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpns_wpsa_coupon_log`; */
/* PRE_TABLE_NAME: `1635170430_wpns_wpsa_coupon_log`; */
/* CUSTOM VARS END */

/* QUERY START */
CREATE TABLE IF NOT EXISTS `1635170430_wpns_wpsa_coupon_log` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `product_details` longtext NOT NULL,
  `total_product_sold` int(11) NOT NULL,
  `payment_date` varchar(200) NOT NULL,
  `txn_id` varchar(100) NOT NULL,
  `gross_sell` varchar(100) NOT NULL,
  `coupon_code` varchar(200) NOT NULL,
  `discount` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/* QUERY END */