/* 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`; */
/* PRE_TABLE_NAME: `1635170430_wpns_wpsa_coupon`; */
/* CUSTOM VARS END */

/* QUERY START */
CREATE TABLE IF NOT EXISTS `1635170430_wpns_wpsa_coupon` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `coupon_code` varchar(200) NOT NULL,
  `validity` datetime NOT NULL,
  `purchase_limit` varchar(200) DEFAULT NULL,
  `discount_type` enum('cur','per','fre') NOT NULL DEFAULT 'cur',
  `discount` float(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/* QUERY END */