# Dump of table BULK_CODES
# ------------------------------------------------------------

CREATE TABLE `BULK_CODES` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `CODE` varchar(128) NOT NULL,
  `BULK_ORDER_ID` bigint(5) DEFAULT NULL,
  `REDEEMED_ORDER_NUM` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `SUBSCRIPTION_ID` (`BULK_ORDER_ID`),
  CONSTRAINT `bulk_codes_ibfk_1` FOREIGN KEY (`BULK_ORDER_ID`) REFERENCES `CUSTOMER_SUBSCRIPTIONS` (`SUBSCRIPTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table CUSTOMER_SUBSCRIPTIONS
# ------------------------------------------------------------

CREATE TABLE `CUSTOMER_SUBSCRIPTIONS` (
  `SUBSCRIPTION_ID` bigint(5) NOT NULL AUTO_INCREMENT,
  `CID` mediumint(9) NOT NULL DEFAULT '0',
  `ordnum` varchar(128) NOT NULL DEFAULT '',
  `chargeid` varchar(36) DEFAULT NULL,
  `SKU` varchar(20) NOT NULL DEFAULT '',
  `qty` tinyint(4) NOT NULL DEFAULT '1',
  `price` varchar(10) NOT NULL DEFAULT '0',
  `total` varchar(10) NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  `tstamp` varchar(10) DEFAULT NULL,
  `form_id` varchar(36) DEFAULT NULL,
  `curncy` varchar(3) DEFAULT NULL,
  `pmt_type` varchar(20) DEFAULT NULL,
  `ipa` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`SUBSCRIPTION_ID`),
  KEY `CUSTOMER_ID` (`CID`),
  CONSTRAINT `CUSTOMER_SUBSCRIPTIONS_ibfk_1` FOREIGN KEY (`CID`) REFERENCES `CUSTOMERS` (`CID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table CUSTOMERS
# ------------------------------------------------------------

CREATE TABLE `CUSTOMERS` (
  `ROW` mediumint(5) NOT NULL AUTO_INCREMENT,
  `CID` mediumint(9) NOT NULL DEFAULT '0',
  `firstname` varchar(30) DEFAULT NULL,
  `lastname` varchar(30) DEFAULT NULL,
  `fullname` varchar(60) DEFAULT NULL,
  `address` varchar(30) DEFAULT NULL,
  `city` varchar(30) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  `postal` varchar(10) DEFAULT NULL,
  `country` varchar(25) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ROW`),
  KEY `CUSTOMER_ID` (`CID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;