· 8 years ago · Jan 01, 2018, 01:42 PM
1-- MySQL dump 10.13 Distrib 5.6.32-78.1, for Linux (x86_64)
2--
3-- Host: localhost Database: jamesbe5_wor0017
4-- ------------------------------------------------------
5-- Server version 5.6.32-78.1-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `wp_quob_authnet_cancellation`
20--
21
22DROP TABLE IF EXISTS `wp_quob_authnet_cancellation`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `wp_quob_authnet_cancellation` (
26 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
27 `user_subscription_id` bigint(20) unsigned NOT NULL,
28 `refId` varchar(255) NOT NULL,
29 `reason` blob,
30 `xSubscriptionId` int(10) NOT NULL,
31 `cancellationDate` datetime NOT NULL,
32 `fullAuthorizeNetResponse` blob NOT NULL,
33 PRIMARY KEY (`ID`) USING BTREE
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='cancellation table is child to user_subscription';
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `wp_quob_authnet_cancellation`
39--
40
41LOCK TABLES `wp_quob_authnet_cancellation` WRITE;
42/*!40000 ALTER TABLE `wp_quob_authnet_cancellation` DISABLE KEYS */;
43/*!40000 ALTER TABLE `wp_quob_authnet_cancellation` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `wp_quob_authnet_cart_items`
48--
49
50DROP TABLE IF EXISTS `wp_quob_authnet_cart_items`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE TABLE `wp_quob_authnet_cart_items` (
54 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
55 `user_subscription_id` bigint(20) unsigned NOT NULL,
56 `subscription_id` int(10) unsigned NOT NULL,
57 `unitPrice` decimal(10,2) DEFAULT NULL,
58 `quantity` int(10) DEFAULT NULL,
59 `totalPrice` decimal(10,2) DEFAULT NULL,
60 `memberwing_transaction_id` varchar(255) NOT NULL,
61 `isAdditionalCharge` int(10) unsigned DEFAULT NULL,
62 `additionalChargeName` varchar(255) DEFAULT NULL,
63 `couponCodeId` int(10) unsigned NOT NULL,
64 `isCouponCode` int(10) unsigned DEFAULT NULL,
65 `couponCodeType` varchar(255) DEFAULT NULL,
66 PRIMARY KEY (`ID`) USING BTREE
67) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=latin1 COMMENT='cart items';
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `wp_quob_authnet_cart_items`
72--
73
74LOCK TABLES `wp_quob_authnet_cart_items` WRITE;
75/*!40000 ALTER TABLE `wp_quob_authnet_cart_items` DISABLE KEYS */;
76INSERT INTO `wp_quob_authnet_cart_items` VALUES (1,1,13,40.00,1,40.00,'000000-0',NULL,NULL,0,NULL,NULL),(2,2,14,40.00,1,40.00,'NCFM7X-0',NULL,NULL,0,NULL,NULL),(3,2,0,35.00,1,-35.00,'',NULL,NULL,1,1,'F'),(4,3,14,40.00,1,40.00,'NJ2C90-0',NULL,NULL,0,NULL,NULL),(5,3,0,35.00,1,-35.00,'',NULL,NULL,1,1,'F'),(6,4,14,40.00,1,40.00,'044935-0',NULL,NULL,0,NULL,NULL),(7,4,15,40.00,1,40.00,'044935-1',NULL,NULL,0,NULL,NULL),(8,5,23,85.00,1,85.00,'099432-0',NULL,NULL,0,NULL,NULL),(9,5,26,85.00,1,85.00,'099432-1',NULL,NULL,0,NULL,NULL),(10,6,40,75.00,1,75.00,'03782Z-0',NULL,NULL,0,NULL,NULL),(11,6,20,80.00,1,80.00,'03782Z-1',NULL,NULL,0,NULL,NULL),(12,7,43,50.00,1,50.00,'04567B-0',NULL,NULL,0,NULL,NULL),(13,8,18,80.00,1,80.00,'033438-0',NULL,NULL,0,NULL,NULL),(14,8,21,60.00,1,60.00,'033438-1',NULL,NULL,0,NULL,NULL),(15,9,12,50.00,1,50.00,'825314-0',NULL,NULL,0,NULL,NULL),(16,10,35,85.00,1,85.00,'183008-0',NULL,NULL,0,NULL,NULL),(17,11,16,60.00,1,60.00,'055454-0',NULL,NULL,0,NULL,NULL),(18,12,37,85.00,1,85.00,'169628-0',NULL,NULL,0,NULL,NULL),(19,12,23,85.00,1,85.00,'169628-1',NULL,NULL,0,NULL,NULL),(20,12,38,85.00,1,85.00,'169628-2',NULL,NULL,0,NULL,NULL),(21,13,20,80.00,1,80.00,'015804-0',NULL,NULL,0,NULL,NULL),(22,13,26,85.00,1,85.00,'015804-1',NULL,NULL,0,NULL,NULL),(23,14,18,80.00,1,80.00,'007380-0',NULL,NULL,0,NULL,NULL),(24,14,25,85.00,1,85.00,'007380-1',NULL,NULL,0,NULL,NULL),(25,15,43,50.00,1,50.00,'133825-0',NULL,NULL,0,NULL,NULL),(26,16,21,60.00,1,60.00,'07531A-0',NULL,NULL,0,NULL,NULL),(27,17,18,80.00,1,80.00,'07203B-0',NULL,NULL,0,NULL,NULL),(28,18,25,85.00,1,85.00,'168696-0',NULL,NULL,0,NULL,NULL),(29,18,27,85.00,1,85.00,'168696-1',NULL,NULL,0,NULL,NULL),(30,18,18,80.00,1,80.00,'168696-2',NULL,NULL,0,NULL,NULL),(31,19,48,85.00,1,85.00,'016622-0',NULL,NULL,0,NULL,NULL),(32,20,16,60.00,1,60.00,'79027B-0',NULL,NULL,0,NULL,NULL),(33,21,40,75.00,1,75.00,'346877-0',NULL,NULL,0,NULL,NULL),(34,22,39,65.00,1,65.00,'605736-0',NULL,NULL,0,NULL,NULL),(35,22,43,50.00,1,50.00,'605736-1',NULL,NULL,0,NULL,NULL),(36,23,48,85.00,1,85.00,'012419-0',NULL,NULL,0,NULL,NULL),(37,23,49,85.00,1,85.00,'012419-1',NULL,NULL,0,NULL,NULL),(38,23,22,85.00,1,85.00,'012419-2',NULL,NULL,0,NULL,NULL),(39,24,28,85.00,1,85.00,'613183-0',NULL,NULL,0,NULL,NULL),(40,24,48,85.00,1,85.00,'613183-1',NULL,NULL,0,NULL,NULL),(41,25,40,75.00,1,75.00,'140332-0',NULL,NULL,0,NULL,NULL),(42,26,46,40.00,1,40.00,'01456B-0',NULL,NULL,0,NULL,NULL),(43,27,36,85.00,1,85.00,'015906-0',NULL,NULL,0,NULL,NULL),(44,27,35,85.00,1,85.00,'015906-1',NULL,NULL,0,NULL,NULL),(45,28,28,85.00,1,85.00,'005928-0',NULL,NULL,0,NULL,NULL),(46,28,19,60.00,1,60.00,'005928-1',NULL,NULL,0,NULL,NULL),(47,29,21,60.00,1,60.00,'625643-0',NULL,NULL,0,NULL,NULL),(48,29,47,40.00,1,40.00,'625643-1',NULL,NULL,0,NULL,NULL),(49,30,33,85.00,1,85.00,'964200-0',NULL,NULL,0,NULL,NULL),(50,30,48,85.00,1,85.00,'964200-1',NULL,NULL,0,NULL,NULL),(51,30,49,85.00,1,85.00,'964200-2',NULL,NULL,0,NULL,NULL),(52,31,27,85.00,1,85.00,'206328-0',NULL,NULL,0,NULL,NULL),(53,32,18,80.00,1,80.00,'064452-0',NULL,NULL,0,NULL,NULL),(54,33,42,60.00,1,60.00,'484720-0',NULL,NULL,0,NULL,NULL),(55,34,22,85.00,1,85.00,'09836F-0',NULL,NULL,0,NULL,NULL),(56,34,49,85.00,1,85.00,'09836F-1',NULL,NULL,0,NULL,NULL),(57,35,26,85.00,1,85.00,'118103-0',NULL,NULL,0,NULL,NULL),(58,35,50,85.00,1,85.00,'118103-1',NULL,NULL,0,NULL,NULL),(59,35,36,85.00,1,85.00,'118103-2',NULL,NULL,0,NULL,NULL),(60,36,46,40.00,1,40.00,'240484-0',NULL,NULL,0,NULL,NULL),(61,37,28,85.00,1,85.00,'601430-0',NULL,NULL,0,NULL,NULL),(62,37,20,80.00,1,80.00,'601430-1',NULL,NULL,0,NULL,NULL),(63,38,22,85.00,1,85.00,'003375-0',NULL,NULL,0,NULL,NULL),(64,39,41,75.00,1,75.00,'T3991B-0',NULL,NULL,0,NULL,NULL),(65,40,33,85.00,1,85.00,'917000-0',NULL,NULL,0,NULL,NULL),(66,41,46,40.00,1,40.00,'189216-0',NULL,NULL,0,NULL,NULL),(67,42,39,50.00,1,50.00,'732907-0',NULL,NULL,0,NULL,NULL),(68,43,33,85.00,1,85.00,'989750-0',NULL,NULL,0,NULL,NULL),(69,43,38,85.00,1,85.00,'989750-1',NULL,NULL,0,NULL,NULL),(70,43,49,85.00,1,85.00,'989750-2',NULL,NULL,0,NULL,NULL),(71,44,39,50.00,1,50.00,'815415-0',NULL,NULL,0,NULL,NULL),(72,45,40,75.00,1,75.00,'089255-0',NULL,NULL,0,NULL,NULL),(73,46,45,40.00,1,40.00,'G7FDNC-0',NULL,NULL,0,NULL,NULL),(74,46,0,35.00,1,-35.00,'',NULL,NULL,2,1,'F'),(75,47,34,85.00,1,85.00,'00435Z-0',NULL,NULL,0,NULL,NULL),(76,48,27,85.00,1,85.00,'089511-0',NULL,NULL,0,NULL,NULL),(77,49,42,60.00,1,60.00,'045490-0',NULL,NULL,0,NULL,NULL),(78,50,39,50.00,1,50.00,'45195P-0',NULL,NULL,0,NULL,NULL),(79,51,36,85.00,1,85.00,'000052-0',NULL,NULL,0,NULL,NULL),(80,51,18,80.00,1,80.00,'000052-1',NULL,NULL,0,NULL,NULL),(81,52,18,80.00,1,80.00,'012245-0',NULL,NULL,0,NULL,NULL),(82,53,39,50.00,1,50.00,'743054-0',NULL,NULL,0,NULL,NULL),(83,53,46,40.00,1,40.00,'743054-1',NULL,NULL,0,NULL,NULL),(84,54,39,50.00,1,50.00,'90577B-0',NULL,NULL,0,NULL,NULL),(85,54,42,60.00,1,60.00,'90577B-1',NULL,NULL,0,NULL,NULL),(86,55,45,40.00,1,40.00,'H8CSCT-0',NULL,NULL,0,NULL,NULL),(87,55,0,35.00,1,-35.00,'',NULL,NULL,3,1,'F'),(88,56,39,50.00,1,50.00,'110214-0',NULL,NULL,0,NULL,NULL),(89,57,46,40.00,1,40.00,'910559-0',NULL,NULL,0,NULL,NULL),(90,57,39,50.00,1,50.00,'910559-1',NULL,NULL,0,NULL,NULL);
77/*!40000 ALTER TABLE `wp_quob_authnet_cart_items` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `wp_quob_authnet_coupon_codes`
82--
83
84DROP TABLE IF EXISTS `wp_quob_authnet_coupon_codes`;
85/*!40101 SET @saved_cs_client = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `wp_quob_authnet_coupon_codes` (
88 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
89 `couponCode` varchar(255) NOT NULL,
90 `dollarAmount` decimal(10,2) DEFAULT NULL,
91 `percentage` decimal(10,2) DEFAULT NULL,
92 `effectiveDate` date NOT NULL DEFAULT '0000-00-00',
93 `dateEnds` date NOT NULL DEFAULT '0000-00-00',
94 `description` varchar(255) DEFAULT NULL,
95 PRIMARY KEY (`ID`) USING BTREE
96) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='this table defines a template for coupon codes';
97/*!40101 SET character_set_client = @saved_cs_client */;
98
99--
100-- Dumping data for table `wp_quob_authnet_coupon_codes`
101--
102
103LOCK TABLES `wp_quob_authnet_coupon_codes` WRITE;
104/*!40000 ALTER TABLE `wp_quob_authnet_coupon_codes` DISABLE KEYS */;
105INSERT INTO `wp_quob_authnet_coupon_codes` VALUES (1,'1st time',35.00,NULL,'2014-10-01','2014-10-02','1st purch'),(2,'ez12',35.00,NULL,'2014-12-04','2014-12-05',''),(3,'disc1',35.00,NULL,'2014-12-09','2014-12-09','');
106/*!40000 ALTER TABLE `wp_quob_authnet_coupon_codes` ENABLE KEYS */;
107UNLOCK TABLES;
108
109--
110-- Table structure for table `wp_quob_authnet_payment`
111--
112
113DROP TABLE IF EXISTS `wp_quob_authnet_payment`;
114/*!40101 SET @saved_cs_client = @@character_set_client */;
115/*!40101 SET character_set_client = utf8 */;
116CREATE TABLE `wp_quob_authnet_payment` (
117 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
118 `user_subscription_id` bigint(20) unsigned NOT NULL,
119 `xAuthCode` varchar(255) NOT NULL,
120 `xTransId` varchar(255) NOT NULL,
121 `xAmount` decimal(10,2) NOT NULL,
122 `xMethod` varchar(255) NOT NULL,
123 `xType` varchar(255) NOT NULL,
124 `xSubscriptionId` varchar(255) DEFAULT NULL,
125 `xSubscriptionPaynum` int(10) DEFAULT NULL,
126 `paymentDate` datetime NOT NULL,
127 `expiryDate` datetime DEFAULT NULL,
128 `xTransStatus` varchar(255) DEFAULT NULL,
129 `fullAuthorizeNetResponse` blob,
130 PRIMARY KEY (`ID`) USING BTREE
131) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COMMENT='payment table is child to user_subscription';
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping data for table `wp_quob_authnet_payment`
136--
137
138LOCK TABLES `wp_quob_authnet_payment` WRITE;
139/*!40000 ALTER TABLE `wp_quob_authnet_payment` DISABLE KEYS */;
140INSERT INTO `wp_quob_authnet_payment` VALUES (1,1,'000000','0',40.00,'CC','auth_capture',NULL,NULL,'2014-10-01 23:05:50','0000-00-00 00:00:00','','1|1|1|(TESTMODE) This transaction has been approved.|000000|P|0|ORDER-6|Sub-1: Jubilation Haze|40.00|CC|auth_capture||James|Buckley||300 Angier Ave|CASHMERE|Washington|98815|US|||jebandfam@yahoo.com|James|Buckley||300 Angier Ave|CASHMERE|Washington|98815|US||||||41509AFE7523D75827BBE9AB0ACF33D2|||||||||||||XXXX5793|MasterCard||||||||||||||||'),(2,2,'NCFM7X','6544054642',5.00,'CC','auth_capture',NULL,NULL,'2014-10-01 23:29:27','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|NCFM7X|Y|6544054642|ORDER-6|Sub-1: Asian 3-Way , Sub-2: 1st purch-1st time|5.00|CC|auth_capture||james|buckley||300 Angier ave|cashmere|wa|98815|US|||jebandfam@yahoo.com|james|buckley||300 Angier ave|cashmere|wa|98815|US||||||4C8D17AD2E3E055044623BB6D797CF62|M||||||||||||XXXX5793|MasterCard||||||||||||||||'),(3,3,'NJ2C90','6547129733',5.00,'CC','auth_capture',NULL,NULL,'2014-10-02 23:33:55','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|NJ2C90|Y|6547129733|ORDER-7|Sub-1: Asian 3-Way , Sub-2: 1st purch-1st time|5.00|CC|auth_capture||james|buckley||300 angier ave|cashmere|wa|98815|US|||bhort509@aol.com|james|buckley||300 angier ave|cashmere|wa|98815|US||||||8052CB57CE503E79B41D472F2F9661BF|M||||||||||||XXXX5793|MasterCard||||||||||||||||'),(4,4,'044935','6560194369',80.00,'CC','auth_capture',NULL,NULL,'2014-10-07 21:49:37','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|044935|Y|6560194369|ORDER-8|Sub-1: Asian 3-Way , Sub-2: Colombian Bastard|80.00|CC|auth_capture||justin|madsen||2734 NE Twin Spits RD|Hansville|Washington|98340|US|(360)-638-2934||wabubaby@hotmail.com|justin|madsen||2734 NE Twin Spits RD|Hansville|Washington|98340|US||||||BA70C20B94A935997D729677CFCB1AAC|M||||||||||||XXXX9749|Visa||||||||||||||||'),(5,5,'099432','6572862166',170.00,'CC','auth_capture',NULL,NULL,'2014-10-12 16:45:21','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|099432|Y|6572862166|ORDER-9|Sub-1: Chernobyl , Sub-2: Dr. Who|170.00|CC|auth_capture||Craig|Still||212 5th #13|Wenatchee|WA|98801|US|5098841707||craigs@nwi.net|Craig|Still||212 5th #13|Wenatchee|WA|98801|US||||||99B0B6717489F79E43BCD27EA030D23C|M||||||||||||XXXX7853|MasterCard||||||||||||||||'),(6,6,'03782Z','6579895395',155.00,'CC','auth_capture',NULL,NULL,'2014-10-15 02:54:59','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|03782Z|Y|6579895395|ORDER-10|Sub-1: Kushmatic , Sub-2: Cinderella 99 \\"f3\\"|155.00|CC|auth_capture||Norman|Lanier||3405 Elder Mountain rd|Chattanooga|TN|37419|US|423-400-4032||Sailtn@gmail.com|Norman|Lanier||3405 Elder Mountain rd|Chattanooga|TN|37419|US||||||C824A78DD5A0511F9C1BF4A078739C5D|M||||||||||||XXXX5165|MasterCard||||||||||||||||'),(7,7,'04567B','6587170755',50.00,'CC','auth_capture',NULL,NULL,'2014-10-16 20:51:52','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|04567B|Y|6587170755|ORDER-11|Sub-1: Towerful|50.00|CC|auth_capture||Dave|Nevarez||12 pacifica|Los lunas|NM|87031|US|5056041434||davebalderete@hotmail.com|Dave|Nevarez||8620 Northeastern Blvd ne.\\r\\nApt#49|Albuquerque|NM|87112|US||||||D0944B64B3050F9DF22B32FA7727C708|M||||||||||||XXXX9944|MasterCard||||||||||||||||'),(8,8,'033438','6591749008',140.00,'CC','auth_capture',NULL,NULL,'2014-10-18 16:37:13','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|033438|Y|6591749008|ORDER-12|Sub-1: Boggle Dragon , Sub-2: Black Forrest|140.00|CC|auth_capture||James|Ward||35031 Queens way|Fruitland Park|Fl.|34731|US|352 593 6524||beardiebadass@gmail.com|James|Ward||35031 Queens way|Fruitland Park|Fl.|34731|US||||||718E8390421DB921153AA02076BD2ABB|M||||||||||||XXXX2549|MasterCard||||||||||||||||'),(9,9,'825314','6606851408',50.00,'CC','auth_capture',NULL,NULL,'2014-10-24 01:19:50','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|825314|Y|6606851408|ORDER-13|Sub-1: Glove Love|50.00|CC|auth_capture||francis|coates||4401 Montgomery ne # 146|albuquerque|new mexico|87109|US|505-385-8177||fpcoates@msn.com|francis|coates||4401 Montgomery ne # 146|albuquerque|new mexico|87109|US||||||7A730C6D1FC463B57CC41F352C7FDED2|M||||||||||||XXXX7423|Visa||||||||||||||||'),(10,10,'183008','6611743404',85.00,'CC','auth_capture',NULL,NULL,'2014-10-26 00:44:29','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|183008|Z|6611743404|ORDER-14|Sub-1: Quantum Kush|85.00|CC|auth_capture||gift|card||1602 w st rt 18|tiffin|ohio|44883|US|||joewade825@yahoo.com|crazy joes|trading post||po box 102|old fort|ohio|44883|US||||||DAB9CEDCE98B4452F877A3A0F1C3B76C|M||||||||||||XXXX9555|Visa||||||||||||||||'),(11,11,'055454','6619022636',60.00,'CC','auth_capture',NULL,NULL,'2014-10-28 21:54:06','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|055454|Y|6619022636|ORDER-15|Sub-1: Rusty Haze|60.00|CC|auth_capture||carl|hilman||8 dolge ct|oxford|Massachusetts|01540|US|4138960799||carlthilman@yahoo.com|carl|hilman||8 dolge ct|oxford|Massachusetts|01540|US||||||4CA56A4F31EB99200023F3DAB8F9DC76|M||||||||||||XXXX9836|Visa||||||||||||||||'),(12,12,'169628','6630896446',255.00,'CC','auth_capture',NULL,NULL,'2014-11-01 23:40:57','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|169628|Z|6630896446|ORDER-14|Sub-1: The Third Dimension , Sub-2: Chernobyl , Sub-3: Time Wreck|255.00|CC|auth_capture||gift|card||1600 w st rt 18|tiffin|ohio|44883|US|||joewade825@yahoo.com|c joes|trading post||po box 102|old fort|ohio|44861|US||||||2F97B8B5860021D2B99080544E3DD227|M||||||||||||XXXX0502|Visa||||||||||||||||'),(13,13,'015804','6634736206',165.00,'CC','auth_capture',NULL,NULL,'2014-11-03 17:18:20','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|015804|Y|6634736206|ORDER-16|Sub-1: Cinderella 99 \\"f3\\" , Sub-2: Dr. Who|165.00|CC|auth_capture||William|Reilly||2335 se 44th ave|Portland|OR|97215|US|5036798030||typesmooth@hotmail.com|William|Reilly||2335 se 44th ave|Portland|OR|97215|US||||||884EB2312BD1076D5AAFC836CFE1566C|M||||||||||||XXXX7856|Visa||||||||||||||||'),(14,14,'007380','6644824183',165.00,'CC','auth_capture',NULL,NULL,'2014-11-06 20:07:44','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|007380|Y|6644824183|ORDER-17|Sub-1: Boggle Dragon , Sub-2: Deep Purple|165.00|CC|auth_capture||Keith|Carrig||5238 w 64th pl|Chicago|illinois|60638|US|7732552136||dimebonics1980@gmail.com|Keith|Carrig||5238 w 64th pl|Chicago|illinois|60638|US||||||65ADC1646E8B1D27FE0CE7926567BD7B|M||||||||||||XXXX1985|MasterCard||||||||||||||||'),(15,15,'133825','6645453466',50.00,'CC','auth_capture',NULL,NULL,'2014-11-06 23:26:16','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|133825|Y|6645453466|ORDER-13|Sub-1: Towerful|50.00|CC|auth_capture||francis|coates|mine|4401 Montgomery ne # 146|albuquerque|new mexico|87109|US|505-385-8177||fpcoates@msn.com|francis|coates|mine|4401 Montgomery ne # 146|albuquerque|new mexico|87109|US||||||C02EC1D82227323E60F39A1115E9CF7A|M||||||||||||XXXX7423|Visa||||||||||||||||'),(16,16,'07531A','6646037771',60.00,'CC','auth_capture',NULL,NULL,'2014-11-07 05:09:18','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|07531A|Y|6646037771|ORDER-18|Sub-1: Black Forrest|60.00|CC|auth_capture||Donald|Lovell||po box 1250|Crestone|Colorado|81131|US|719-937-3316||gnometownherosrock@gmail.com|Donald|Lovell||po box 1250|Crestone|Colorado|81131|US||||||523E9B122CE50116D7C31B5D429D640C|M||||||||||||XXXX1967|Visa||||||||||||||||'),(17,17,'07203B','6648741043',80.00,'CC','auth_capture',NULL,NULL,'2014-11-08 00:52:40','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|07203B|Y|6648741043|ORDER-19|Sub-1: Boggle Dragon|80.00|CC|auth_capture||Nicolas|Williams||212 Forest Hill Dr.|Anderson|SC|29621|US|||N.onasis4@gmail.com|Nicolas|Williams||212 Forest Hill Dr.|Anderson|SC|29621|US||||||B08C7DA4C39B388474AE32E143E46FE2|M||||||||||||XXXX6908|Visa||||||||||||||||'),(18,18,'168696','6650613881',250.00,'CC','auth_capture',NULL,NULL,'2014-11-09 00:36:27','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|168696|Z|6650613881|ORDER-14|Sub-1: Deep Purple , Sub-2: Jacks Cleaner 2 , Sub-3: Boggle Dragon|250.00|CC|auth_capture||gift|card||1714 west market st|tiffin|ohio|44883|US|||joewade825@yahoo.com|c joes|trading post||po box 102|old fort|ohio|44861|US||||||8E63744BADA69E3DBA99AC5C93391C78|M||||||||||||XXXX0132|Visa||||||||||||||||'),(19,19,'016622','6652228447',85.00,'CC','auth_capture',NULL,NULL,'2014-11-10 00:45:54','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|016622|Y|6652228447|ORDER-20|Sub-1: Brians Berry Cough|85.00|CC|auth_capture||Frankie|Fitch||3660 Hammond rd|Paintsville|Kentucky|41240|US|606-792-7894||ffitch02@yahoo.com|Frankie|Fitch||3660 Hammond rd|Paintsville|Kentucky|41240|US||||||DC044BAAFC2EC3F0834E3A47FF6965A8|M||||||||||||XXXX2437|Visa||||||||||||||||'),(20,20,'79027B','6654840658',60.00,'CC','auth_capture',NULL,NULL,'2014-11-10 21:07:51','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|79027B|Y|6654840658|ORDER-21|Sub-1: Rusty Haze|60.00|CC|auth_capture||John|Blaugrund|--|102 Ocean Vista|Newport Beach|CA|92660|US|9493226593||johnb@jsbholdings.com|John|Blaugrund|--|102 Ocean Vista|Newport Beach|CA|92660|US||||||BC427DA3C7E7032F8D3688B072E44EB2|M||||||||||||XXXX9801|MasterCard||||||||||||||||'),(21,21,'346877','6655853365',75.00,'CC','auth_capture',NULL,NULL,'2014-11-11 03:44:53','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|346877|Y|6655853365|ORDER-22|Sub-1: Kushmatic|75.00|CC|auth_capture||Dylan|Sheets||6605 west argent rd|pasco|washington|99301|US|5093029552||dylansheet@hotmail.com|Dylan|Sheets||6605 west argent rd|pasco|washington|99301|US||||||8B60A722B34748270E7DC58AA746F6BE|M||||||||||||XXXX4012|Visa||||||||||||||||'),(22,22,'605736','6656918071',115.00,'CC','auth_capture',NULL,NULL,'2014-11-11 16:42:37','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|605736|Y|6656918071|ORDER-23|Sub-1: Blue Power , Sub-2: Towerful|115.00|CC|auth_capture||Alejandro \\\\\\"AL\\\\\\"|Aguilar||362 highland st|Pasadena|California|91104-1039|US|||Flyboy11@sbcglobal.net|Alejandro \\\\\\"AL\\\\\\"|Aguilar||362 highland st|Pasadena|California|91104-1039|US||||||82A72EF6920ADC5CBC4B5544AD5AC106|M||||||||||||XXXX0492|Visa||||||||||||||||'),(23,23,'012419','6659209511',255.00,'CC','auth_capture',NULL,NULL,'2014-11-12 13:02:37','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|012419|Y|6659209511|ORDER-24|Sub-1: Brians Berry Cough , Sub-2: CheeseQuake , Sub-3: Agent Orange|255.00|CC|auth_capture||Ryan|Middleton||10660 Stuart Street|Westminster|CO|80031|US|||slightlystoopid50@gmail.com|Ryan|Middleton||10660 Stuart Street|Westminster|CO|80031|US||||||2A7A6376D5681E4F50C6E9FC38E9CADF|M||||||||||||XXXX6434|Visa||||||||||||||||'),(24,24,'613183','6663816535',170.00,'CC','auth_capture',NULL,NULL,'2014-11-13 22:38:31','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|613183|Y|6663816535|ORDER-25|Sub-1: Jilly Bean , Sub-2: Brians Berry Cough|170.00|CC|auth_capture||Mark|Schlei||N9807 deer lake rd|Crivitz|Wisconsin|54114|US|414-870-4760||Markschlei@centurylink.net|Mark|Schlei||N9807 deer lake rd|Crivitz|Wisconsin|54114|US||||||C548A85485FD6C8373559D1E9AAAA3EB|M||||||||||||XXXX4868|Visa||||||||||||||||'),(25,25,'140332','6666809561',75.00,'CC','auth_capture',NULL,NULL,'2014-11-14 21:28:00','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|140332|Y|6666809561|ORDER-26|Sub-1: Kushmatic|75.00|CC|auth_capture||fred|williams||7602 17th ave.w. trailer # 10|bradenton|florida|34209-0000|US|9415926043||welmore12320@gmail.com|fred|williams||7602 17th ave.w. trailer # 10|bradenton|florida|34209-0000|US||||||389B9A01233D06E468E75058A9604685|M||||||||||||XXXX8274|MasterCard||||||||||||||||'),(26,26,'01456B','6667789282',40.00,'CC','auth_capture',NULL,NULL,'2014-11-15 05:30:48','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|01456B|Z|6667789282|ORDER-27|Sub-1: Vashon Kush|40.00|CC|auth_capture||Jassen|Bowman||305 W Magnolia St #243|Fort Collins|CO|80521|US|||jassenbowman@gmail.com|Jassen|Bowman||1800 Sidney Ave Apt 13-250|Port Orchard|WA|98366|US||||||2C9E3ABDFB91267226E0949408CE17B1|M||||||||||||XXXX3631|MasterCard||||||||||||||||'),(27,27,'015906','6668382420',170.00,'CC','auth_capture',NULL,NULL,'2014-11-15 12:35:43','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|015906|Y|6668382420|ORDER-24|Sub-1: The Flav , Sub-2: Quantum Kush|170.00|CC|auth_capture||Ryan|Middleton||10660 Stuart Street|Westminster|CO|80031|US|||slightlystoopid50@gmail.com|Ryan|Middleton||10660 Stuart Street|Westminster|CO|80031|US||||||EED1DCD10124FDDD589336C538173F60|M||||||||||||XXXX6434|Visa||||||||||||||||'),(28,28,'005928','6670100481',145.00,'CC','auth_capture',NULL,NULL,'2014-11-16 05:09:06','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|005928|Y|6670100481|ORDER-28|Sub-1: Jilly Bean , Sub-2: Iron Cindy|145.00|CC|auth_capture||michael|dalzell||po box 1251|girdwood|ak|99587|US|||mdalzell@gci.net|michael|dalzell||po box 1251|girdwood|ak|99587|US||||||D3091C25881C57E62A331565EB0DA4BD|M||||||||||||XXXX6357|Visa||||||||||||||||'),(29,29,'625643','6670565716',100.00,'CC','auth_capture',NULL,NULL,'2014-11-16 14:58:03','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|625643|Z|6670565716|ORDER-32|Sub-1: Black Forrest , Sub-2: Lighthouse|100.00|CC|auth_capture||Donald|Solomon||2474 Paris St Apt 3|Cincinnati|OH|45219|US|5133070697||Dsolomon1125@gmail.com|Donald|Solomon||2474 Paris St Apt 3|Cincinnati|OH|45219|US||||||60CE55E00EA9CD5CADBFB95F4B9A0D4D|M||||||||||||XXXX5427|MasterCard||||||||||||||||'),(30,30,'964200','6670762849',255.00,'CC','auth_capture',NULL,NULL,'2014-11-16 17:08:55','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|964200|Z|6670762849|ORDER-14|Sub-1: Pennywise , Sub-2: Brians Berry Cough , Sub-3: CheeseQuake|255.00|CC|auth_capture||gift|card||1714 west market st|tiffin|ohio|44883|US|||joewade825@yahoo.com|c joes|trading post||po box 102|old fort|ohio|44861|US||||||57A2B39C05E0129497713719E22FB40A|M||||||||||||XXXX3224|Visa||||||||||||||||'),(31,31,'206328','6674269338',85.00,'CC','auth_capture',NULL,NULL,'2014-11-17 20:44:42','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|206328|Y|6674269338|ORDER-33|Sub-1: Jacks Cleaner 2|85.00|CC|auth_capture||Craig|Vines||719 w main st 202|Aspen|Co|81611|US|9703791654||Cvwaterfalls@msn.com|Craig|Vines||719 w main st 202|Aspen|Co|81611|US||||||B60C4B6B1EE37400F44CBE6C07E59B1D|M||||||||||||XXXX9601|Visa||||||||||||||||'),(32,32,'064452','6680796258',80.00,'CC','auth_capture',NULL,NULL,'2014-11-19 22:44:57','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|064452|Y|6680796258|ORDER-34|Sub-1: Boggle Dragon|80.00|CC|auth_capture||Bob|Antini||469 Smith Ridge Smith Rd. B|South Salem|N.Y.|10590|US|||tunes_guy@hotmail.com|Bob|Antini||469 Smith Ridge Smith Rd. B|South Salem|N.Y.|10590|US||||||A98D2DEB6D74F473241BF2C9A8408E1C|M||||||||||||XXXX1309|Visa||||||||||||||||'),(33,33,'484720','6684555782',60.00,'CC','auth_capture',NULL,NULL,'2014-11-21 04:06:21','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|484720|Y|6684555782|ORDER-13|Sub-1: Bishop Purple|60.00|CC|auth_capture||francis|coates||4401 Montgomery ne # 146|albuquerque|new mexico|87109|US|505-387-8177||fpcoates@msn.com|francis|coates||4401 Montgomery ne # 146|albuquerque|new mexico|87109|US||||||D7DA4C1A887B778401C19A861772D1E9|M||||||||||||XXXX1112|Visa||||||||||||||||'),(34,34,'09836F','6687200643',170.00,'CC','auth_capture',NULL,NULL,'2014-11-21 23:08:57','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|09836F|Y|6687200643|ORDER-35|Sub-1: Agent Orange , Sub-2: CheeseQuake|170.00|CC|auth_capture||pete|dooley||856 59th st s.e.|grand rapids|MI|49508|US|616-427-2376||dtzp2000@hotmail.com|pete|dooley||856 59th st s.e.|grand rapids|MI|49508|US||||||2405F71D69799F8C33C61EDFCCB5B546|M||||||||||||XXXX7824|Visa||||||||||||||||'),(35,35,'118103','6688814645',255.00,'CC','auth_capture',NULL,NULL,'2014-11-22 19:25:23','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|118103|Z|6688814645|ORDER-14|Sub-1: Dr. Who , Sub-2: Apollo 13 BX , Sub-3: The Flav|255.00|CC|auth_capture||gift|card||1714 w market st|tiffin|ohio|44883|US|||joewade825@yahoo.com|c joes|trading post||po box 102|old fort|ohio|44861|US||||||6825165B5E6CDB0CBCCFA984E63228D7|M||||||||||||XXXX7286|Visa||||||||||||||||'),(36,36,'240484','6689533232',40.00,'CC','auth_capture',NULL,NULL,'2014-11-23 02:14:55','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|240484|Y|6689533232|ORDER-37|Sub-1: Vashon Kush|40.00|CC|auth_capture||Charles|Hinton||3732 Tierra Alamo|El Paso|Tx|79938|US|||charles.j.hinton@gmail.com|Charles|Hinton||3732 Tierra Alamo|El Paso|Tx|79938|US||||||8C10EDEC48E08963548ECE4CB9C9CEA3|M||||||||||||XXXX1358|MasterCard||||||||||||||||'),(37,37,'601430','6690097792',165.00,'CC','auth_capture',NULL,NULL,'2014-11-23 14:18:20','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|601430|Y|6690097792|ORDER-38|Sub-1: Jilly Bean , Sub-2: Cinderella 99 \\"f3\\"|165.00|CC|auth_capture||Jeffrey|Trancoso||13513 Smyth\\\\\\\'s trek|Weston|Colorado|81091|US|7196802523||jefftrancoso@ymail.com|Jeffrey|Trancoso||13513 Smyth\\\\\\\'s trek|Weston|Colorado|81091|US||||||8551AD8F122C96504615FB762617CA2C|M||||||||||||XXXX4237|Visa||||||||||||||||'),(38,38,'003375','6698082294',85.00,'CC','auth_capture',NULL,NULL,'2014-11-26 13:19:33','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|003375|Y|6698082294|ORDER-20|Sub-1: Agent Orange|85.00|CC|auth_capture||Frankie|Fitch||3660 Hammond Rd|Paintsville|Kentucky|41240|US|606-297-2836||ffitch02@yahoo.com|Frankie|Fitch||3660 Hammond Rd|Paintsville|Kentucky|41240|US||||||4931CC43DE50FDE041F59B1E3D7BAACA|M||||||||||||XXXX1469|Visa||||||||||||||||'),(39,39,'T3991B','6699404323',75.00,'CC','auth_capture',NULL,NULL,'2014-11-26 20:19:16','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|T3991B|Y|6699404323|ORDER-39|Sub-1: Mazarmatic|75.00|CC|auth_capture||Richard|Rains||6140 W. Ralston Rd.|Indianapolis|Indiana|46221|US|3174186983||rainsgolf@gmail.com|Richard|Rains||6140 W. Ralston Rd.|Indianapolis|Indiana|46221|US||||||AB49D26C47235078861C97BA79AAEEB5|M||||||||||||XXXX2240|MasterCard||||||||||||||||'),(40,40,'917000','6701710300',85.00,'CC','auth_capture',NULL,NULL,'2014-11-28 03:28:22','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|917000|Y|6701710300|ORDER-40|Sub-1: Pennywise|85.00|CC|auth_capture||George|Sylvestre||1234 E Jewel st|Santa Maria|california|93454|US|8057390685||georgegsylvestrejr@gmail.com|George|Sylvestre||1234 E Jewel st|Santa Maria|california|93454|US||||||DDB0E3163A6A657CFDC7E2BB4286A5F6|M||||||||||||XXXX4843|Visa||||||||||||||||'),(41,41,'189216','6705163988',40.00,'CC','auth_capture',NULL,NULL,'2014-11-29 02:51:51','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|189216|Z|6705163988|ORDER-41|Sub-1: Vashon Kush|40.00|CC|auth_capture||mark|hackett||655 lockhaven ct.|newark|delaware|19702|US|3023676487||hackettm@rocketmail.com|mark|hackett||655 lockhaven ct.|newark|delaware|19702|US||||||F829DD5CF684C28EC8343D92C4E8A267|M||||||||||||XXXX0084|Visa||||||||||||||||'),(42,42,'732907','6706183403',50.00,'CC','auth_capture',NULL,NULL,'2014-11-29 16:23:22','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|732907|Y|6706183403|ORDER-43|Sub-1: Blue Power|50.00|CC|auth_capture||Kevin|Carrig||7747 Parkside Ave|Burbank|Illinois|60459|US|773-480-4733||carrigkevin@yahoo.com|Kevin|Carrig||7747 Parkside Ave|Burbank|Illinois|60459|US||||||A3D4740F031BD4185D42E9351DCED8CF|M||||||||||||XXXX9876|MasterCard||||||||||||||||'),(43,43,'989750','6706343108',255.00,'CC','auth_capture',NULL,NULL,'2014-11-29 17:34:08','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|989750|Z|6706343108|ORDER-14|Sub-1: Pennywise , Sub-2: Time Wreck , Sub-3: CheeseQuake|255.00|CC|auth_capture||gift|card||1714 w. market st|tiffin|ohio|44883|US|||joewade825@yahoo.com|c joes|trading post||po box 102|old fort|ohio|44861|US||||||1B8DB51F856FD538AB511CEC1E7118B9|M||||||||||||XXXX5610|Visa||||||||||||||||'),(44,44,'815415','6714080346',50.00,'CC','auth_capture',NULL,NULL,'2014-12-01 21:01:39','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|815415|Y|6714080346|ORDER-44|Sub-1: Blue Power|50.00|CC|auth_capture||John|Martin||405 maple drive|Linden|Michigan|48451|US|8108753880||capnteal@yahoo.com|John|Martin||405 maple drive|Linden|Michigan|48451|US||||||F7EF19A1B3CCDF262D6B12C492F15753|M||||||||||||XXXX2351|Visa||||||||||||||||'),(45,45,'089255','6714670365',75.00,'CC','auth_capture',NULL,NULL,'2014-12-01 22:41:58','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|089255|Y|6714670365|ORDER-45|Sub-1: Kushmatic|75.00|CC|auth_capture||Robert|Mackey||696 state highway 7 lot 50|unadilla|ny|13849|US|||fatesdesign15@gmail.com|Robert|Mackey||696 state highway 7 lot 50|unadilla|ny|13849|US||||||AD2703157AFA60196D7177DF117F96D2|M||||||||||||XXXX8092|Visa||||||||||||||||'),(46,46,'G7FDNC','6725526827',5.00,'CC','auth_capture',NULL,NULL,'2014-12-04 16:33:37','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|G7FDNC|Y|6725526827|ORDER-6|Sub-1: Boggle Rama , Sub-2: -ez12|5.00|CC|auth_capture||james|buckley||300 Angier Ave|Cashmere|Washington|98815|US|||jebandfam@yahoo.com|james|buckley||300 Angier Ave|Cashmere|Washington|98815|US||||||E415E30F8AFE1926AA42A71640244FEB|M||||||||||||XXXX5793|MasterCard||||||||||||||||'),(47,47,'00435Z','6725590229',85.00,'CC','auth_capture',NULL,NULL,'2014-12-04 16:50:04','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|00435Z|Y|6725590229|ORDER-46|Sub-1: Qrazy Train|85.00|CC|auth_capture||Juan|lopez||5900 dalton rd|fayetteville|nc|28314|US|||jp.lopez15@yahoo.com|Juan|lopez||5900 dalton rd|fayetteville|nc|28314|US||||||2C13D2041369194D5AE3F815AC19811F|M||||||||||||XXXX7928|MasterCard||||||||||||||||'),(48,48,'089511','6730799875',85.00,'CC','auth_capture',NULL,NULL,'2014-12-05 23:59:13','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|089511|Y|6730799875|ORDER-47|Sub-1: Jacks Cleaner 2|85.00|CC|auth_capture||Thomas|Miller|Scorpio Designs|3440 Tuscarawas Road|Beaver|Pennsylvania|15009-9118|US|7247747447||twmillerjr@comcast.net|Thomas|Miller|Scorpio Designs|3440 Tuscarawas Road|Beaver|Pennsylvania|15009-9118|US||||||1C0297CEEFA27C394410C4E640A3CC6F|M||||||||||||XXXX5100|Visa||||||||||||||||'),(49,49,'045490','6732521652',60.00,'CC','auth_capture',NULL,NULL,'2014-12-06 19:28:18','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|045490|Y|6732521652|ORDER-48|Sub-1: Bishop Purple|60.00|CC|auth_capture||Brenden|Blank||801 meadow acres lane|St.louis|Missouri|63125|US|3142230989||Brendeniskwl@hotmail.com|Brenden|Blank||801 meadow acres lane|St.louis|Missouri|63125|US||||||1AD857C6ABE09A4A1BE234B7F2F1EACD|M||||||||||||XXXX5271|Visa||||||||||||||||'),(50,50,'45195P','6733354483',50.00,'CC','auth_capture',NULL,NULL,'2014-12-07 01:57:01','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|45195P|Y|6733354483|ORDER-49|Sub-1: Blue Power|50.00|CC|auth_capture||Richard W.|Blankenshp|Retired|4501 East Warren Ave.|Denver|Colo.|80222|US|303-756-5244||rickwblank@aol.com|Richard W.|Blankenshp|Retired|4501 East Warren Ave.|Denver|Colo.|80222|US||||||3E5B509D51A3479007E2157B11AAA908|M||||||||||||XXXX0637|MasterCard||||||||||||||||'),(51,51,'000052','6733464295',165.00,'CC','auth_capture',NULL,NULL,'2014-12-07 03:17:13','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|000052|Y|6733464295|ORDER-38|Sub-1: The Flav , Sub-2: Boggle Dragon|165.00|CC|auth_capture||Jeff|Trancoso||13513 Smyth\\\\\\\'s trek|weston|CO|81091|US|||jefftrancoso@ymail.com|Jeff|Trancoso||13513 Smyth\\\\\\\'s trek|weston|CO|81091|US||||||9152E6302EADA8B157B9C466FD780EE4|M||||||||||||XXXX4237|Visa||||||||||||||||'),(52,52,'012245','6733471269',80.00,'CC','auth_capture',NULL,NULL,'2014-12-07 03:22:46','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|012245|Y|6733471269|ORDER-50|Sub-1: Boggle Dragon|80.00|CC|auth_capture||Jacob|Prusinski||17925 W. Roosevelt Ave.|New Berlin|Wisconsin|53146|US|||Jpru87@yahoo.com|Jacob|Prusinski||17925 W. Roosevelt Ave.|New Berlin|Wisconsin|53146|US||||||F4D84213B490DD6B4E95821C12CA461A|M||||||||||||XXXX5818|MasterCard||||||||||||||||'),(53,53,'743054','6733629321',90.00,'CC','auth_capture',NULL,NULL,'2014-12-07 06:10:59','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|743054|Z|6733629321|ORDER-51|Sub-1: Blue Power , Sub-2: Vashon Kush|90.00|CC|auth_capture||Patrick M.|Boyd||09441 Quarterline Rd.|Charlevoix|Michigan|49720|US|||nitelife1000@yahoo.com|Patrick M.|Boyd||09441 Quarterline Rd.|Charlevoix|Michigan|49720|US||||||9CE73949974A683F6DDDBFF26D9AA11A|M||||||||||||XXXX3645|MasterCard||||||||||||||||'),(54,54,'90577B','6733918185',110.00,'CC','auth_capture',NULL,NULL,'2014-12-07 12:24:53','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|90577B|Y|6733918185|ORDER-52|Sub-1: Blue Power , Sub-2: Bishop Purple|110.00|CC|auth_capture||daniel|desrochers||385 east shore road|burlington|maine|04417|US|2079753016||desrochersdan@hotmail.com|daniel|desrochers||385 east shore road|burlington|maine|04417|US||||||AC7782DEB4A1900E1E26C9D19DB198F7|M||||||||||||XXXX8566|MasterCard||||||||||||||||'),(55,55,'H8CSCT','6740497982',5.00,'CC','auth_capture',NULL,NULL,'2014-12-09 17:23:38','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|H8CSCT|Y|6740497982|ORDER-6|Sub-1: Boggle Rama , Sub-2: -disc1|5.00|CC|auth_capture||james|buckley||300 Angier Ave|Cashmere|Washington|98815|US|||jebandfam@yahoo.com|james|buckley||300 Angier Ave|Cashmere|Washington|98815|US||||||7CBF3D66F74C6B68E16A9818FE073380|M||||||||||||XXXX5793|MasterCard||||||||||||||||'),(56,56,'110214','6740845240',50.00,'CC','auth_capture',NULL,NULL,'2014-12-09 18:51:49','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|110214|Z|6740845240|ORDER-53|Sub-1: Blue Power|50.00|CC|auth_capture||Nikki|Floyd||40 Ozone School Rd|Rockwood|Tennessee|37854|US|||nikkiamber85@gmail.com|Nikki|Floyd||40 Ozone School Rd|Rockwood|Tennessee|37854|US||||||4FC4FC812ABDB08FDFA00D78B861F93B|M||||||||||||XXXX1659|Visa||||||||||||||||'),(57,57,'910559','6741656190',90.00,'CC','auth_capture',NULL,NULL,'2014-12-09 22:17:06','0000-00-00 00:00:00','','1|1|1|This transaction has been approved.|910559|Z|6741656190|ORDER-51|Sub-1: Vashon Kush , Sub-2: Blue Power|90.00|CC|auth_capture||Patrick M.|Boyd||09441 Quarterline Rd.|Charlevoix|Michigan|49720|US|||nitelife1000@yahoo.com|Patrick M.|Boyd||09441 Quarterline Rd.|Charlevoix|Michigan|49720|US||||||947DBDD555546E228A43051A465FC326|M||||||||||||XXXX3645|MasterCard||||||||||||||||');
141/*!40000 ALTER TABLE `wp_quob_authnet_payment` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `wp_quob_authnet_refund`
146--
147
148DROP TABLE IF EXISTS `wp_quob_authnet_refund`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `wp_quob_authnet_refund` (
152 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
153 `user_subscription_id` bigint(20) unsigned NOT NULL,
154 `xTransId` varchar(255) DEFAULT NULL,
155 `refTransId` varchar(255) NOT NULL,
156 `refTransStatus` varchar(255) NOT NULL,
157 `refundDate` datetime NOT NULL,
158 PRIMARY KEY (`ID`) USING BTREE
159) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='redfund table is child to user_subscription';
160/*!40101 SET character_set_client = @saved_cs_client */;
161
162--
163-- Dumping data for table `wp_quob_authnet_refund`
164--
165
166LOCK TABLES `wp_quob_authnet_refund` WRITE;
167/*!40000 ALTER TABLE `wp_quob_authnet_refund` DISABLE KEYS */;
168/*!40000 ALTER TABLE `wp_quob_authnet_refund` ENABLE KEYS */;
169UNLOCK TABLES;
170
171--
172-- Table structure for table `wp_quob_authnet_subscription`
173--
174
175DROP TABLE IF EXISTS `wp_quob_authnet_subscription`;
176/*!40101 SET @saved_cs_client = @@character_set_client */;
177/*!40101 SET character_set_client = utf8 */;
178CREATE TABLE `wp_quob_authnet_subscription` (
179 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
180 `processSinglePayment` int(10) unsigned NOT NULL,
181 `processRecurringPayment` int(10) unsigned NOT NULL,
182 `variablePaymentTemplate` int(10) unsigned NOT NULL,
183 `additionalChargeTemplate` int(10) unsigned NOT NULL,
184 `name` varchar(255) NOT NULL,
185 `initialAmount` decimal(10,2) DEFAULT NULL,
186 `initialDescription` varchar(255) DEFAULT NULL,
187 `initialInvoiceNum` varchar(255) DEFAULT NULL,
188 `recurringRefId` varchar(255) DEFAULT NULL,
189 `recurringIntervalLength` int(10) unsigned DEFAULT NULL,
190 `recurringIntervalUnit` varchar(255) DEFAULT NULL,
191 `recurringTotalOccurrences` int(10) unsigned DEFAULT NULL,
192 `recurringTrialOccurrences` int(10) unsigned NOT NULL DEFAULT '0',
193 `recurringConcealTrial` int(10) unsigned DEFAULT NULL,
194 `recurringAmount` decimal(10,2) DEFAULT NULL,
195 `recurringTrialAmount` decimal(10,2) NOT NULL DEFAULT '0.00',
196 `wishlistLevel` varchar(255) NOT NULL,
197 `specificStartDate` date NOT NULL DEFAULT '0000-00-00',
198 `xDaysDelayStartDate` int(10) NOT NULL DEFAULT '0',
199 `thankyou_page` varchar(255) DEFAULT '',
200 `survey` varchar(255) DEFAULT '',
201 PRIMARY KEY (`ID`) USING BTREE
202) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1 COMMENT='this table defines a template for subscription processing';
203/*!40101 SET character_set_client = @saved_cs_client */;
204
205--
206-- Dumping data for table `wp_quob_authnet_subscription`
207--
208
209LOCK TABLES `wp_quob_authnet_subscription` WRITE;
210/*!40000 ALTER TABLE `wp_quob_authnet_subscription` DISABLE KEYS */;
211INSERT INTO `wp_quob_authnet_subscription` VALUES (1,1,0,0,1,'additional-charge',0.00,'additional charge',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0.00,'','0000-00-00',0,'',''),(2,1,0,1,0,'One-time',0.00,'one-time subscription',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0.00,'','0000-00-00',0,'',''),(3,0,1,1,0,'Monthly',NULL,'monthly subscription',NULL,NULL,1,'months',9999,0,NULL,0.00,0.00,'','0000-00-00',0,'',''),(4,0,1,1,0,'Quarterly',NULL,'quarterly subscription',NULL,NULL,3,'months',9999,0,NULL,0.00,0.00,'','0000-00-00',0,'',''),(7,1,0,0,0,'test ',5.00,'','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(8,1,0,0,0,'Mail Order Bride Seed Info.',50.00,'Mail Order Bride 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(9,1,0,0,0,'Double Poway Doja',55.55,'Double Poway Doja 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(10,1,0,0,0,'P91 BX2',50.00,'P91 BX2 10 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(11,1,0,0,0,'Panex',50.00,'Panex 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(12,1,0,0,0,'Glove Love',50.00,'Glove Love 10 page strain page.','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(13,1,0,0,0,'Jubilation Haze',40.00,'Jubilation Haze 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(14,1,0,0,0,'Asian 3-Way',40.00,'Asian 3-Way 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(15,1,0,0,0,'Colombian Bastard',40.00,'Colombian Bastard 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(16,1,0,0,0,'Rusty Haze',60.00,'Rusty Haze 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(17,1,0,0,0,'Cap Peeler',60.00,'Cap Peeler 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(18,1,0,0,0,'Boggle Dragon',80.00,'Boggle Dragon 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(19,1,0,0,0,'Iron Cindy',60.00,'Iron Cindy 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(20,1,0,0,0,'Cinderella 99 \\\"f3\\\"',80.00,'Cinderella 99 \\\"f3\\\" 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(21,1,0,0,0,'Black Forrest',60.00,'','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'',''),(22,1,0,0,0,'Agent Orange ',85.00,'Agent Orange 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(23,1,0,0,0,'Chernobyl',85.00,'Chernobyl 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(24,1,0,0,0,'Dairy Queen',85.00,'Dairy Queen 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(25,1,0,0,0,'Deep Purple',85.00,'','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(26,1,0,0,0,'Dr. Who',85.00,'Dr. Who 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(27,1,0,0,0,'Jacks Cleaner 2',85.00,'Jacks Cleaner 2, 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(28,1,0,0,0,'Jilly Bean',85.00,'','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(29,1,0,0,0,'Kaboom',85.00,'Kaboom 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(30,1,0,0,0,'Marion Berry Kush',85.00,'Marion Berry Kush 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(31,1,0,0,0,'Micky Kush',85.00,'Micky Kush 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(32,1,0,0,0,'Nurse Jackie',85.00,'Nurse Jackie 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(33,1,0,0,0,'Pennywise',85.00,'Pennywise 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(34,1,0,0,0,'Qrazy Train',85.00,'Qrazy Trian 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(35,1,0,0,0,'Quantum Kush',85.00,'Quantum Kush 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(36,1,0,0,0,'The Flav',85.00,'The Flav 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(37,1,0,0,0,'The Third Dimension',85.00,'The Third Dimension 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(38,1,0,0,0,'Time Wreck',85.00,'Time Wreck 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(39,1,0,0,0,'Blue Power',50.00,'Blue Power 7 page fem strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(40,1,0,0,0,'Kushmatic',75.00,'Kushmatic 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(41,1,0,0,0,'Mazarmatic',75.00,'Mazarmatic 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(42,1,0,0,0,'Bishop Purple',60.00,'Bishop Purple 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(43,1,0,0,0,'Towerful',50.00,'Towerful 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(44,1,0,0,0,'Afro Kush',80.00,'Afro Kush 10 page strain reports','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(45,1,0,0,0,'Boggle Rama',40.00,'Boggle Rama page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(46,1,0,0,0,'Vashon Kush',40.00,'Vashon Kush 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(47,1,0,0,0,'Lighthouse',40.00,'Lighthouse 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(48,1,0,0,0,'Brians Berry Cough',85.00,'Brians Berry Cough 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(49,1,0,0,0,'CheeseQuake',85.00,'Cheese Quake 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(50,1,0,0,0,'Apollo 13 BX',85.00,'Apollo13 BX 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(51,1,0,0,0,'Ghost Train Haze #1',100.00,'Ghost Train Haze #1 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(52,1,0,0,0,'Long Peak Blue ',100.00,'Long Peak Blue 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(53,1,0,0,0,'Rugburn',100.00,'Rugburn 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(54,1,0,0,0,'Scotts OG',100.00,'Scotts OG 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(55,1,0,0,0,'9 Lb. Hammer',85.00,'10 page strain report 9 Pound Hammer','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(56,1,0,0,0,'American Kush',65.00,'American Kush 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(57,1,0,0,0,'Cheddarhead',80.00,'Cheddarhead 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(58,1,0,0,0,'Dawgfather',65.00,'Dawgfather 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(59,1,0,0,0,'Steven Hawking Kush',100.00,'Steven Hawking Kush 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(60,1,0,0,0,'Rawdawg',80.00,'Rawdawg 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(61,1,0,0,0,'Snowdawg 3 ',90.00,'Snowdawg 3 10 Page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(62,1,0,0,0,'Purple Heart ',65.00,'Purple Heart 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(63,1,0,0,0,'Chunky Cherry Malawi',60.00,'Chunky Cherry Malawi 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(64,1,0,0,0,'Dark Matter ',60.00,'Dark Matter 10 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(65,1,0,0,0,'Fat Tuesday ',80.00,'Fat Tuesday 10 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(66,1,0,0,0,'Cherry Thai',90.00,'Cherry Thai 10 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(67,1,0,0,0,'Brian Berry Cough',85.00,'Brian Berry Cough 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'',''),(68,1,0,0,0,'Jack the Ripper ',85.00,'Jack the Ripper 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(69,1,0,0,0,'Jesus OG',85.00,'Jesus OG 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(70,1,0,0,0,'Ripped Budda',85.00,'Ripped Budda 10 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(71,1,0,0,0,'Vortex',85.00,'Vortex 10 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(72,1,0,0,0,'Harlox',100.00,'Harlox 12 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(73,1,0,0,0,'Bubba Train Wreck Haze #1 ',100.00,'Bubba Train Wreck Haze #1 12 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(74,1,0,0,0,'Lee Roy ',100.00,'Lee Roy 12 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(75,1,0,0,0,'Cuvée',85.00,'Cuvée 10 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(76,1,0,0,0,'Locomotion ',85.00,'Locomotion 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(77,1,0,0,0,'Afghanistan Hashplant',85.00,'Afghanistan Hashplant 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(78,1,0,0,0,'Olden Lemon Haze',85.00,'Olden Lemon Haze 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(79,1,0,0,0,'Star Killer',100.00,'Star Killer 12 page strain report ','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You',''),(80,1,0,0,0,'Southend Freeze',40.00,'Southend Freeze 10 page strain report','','',0,'',0,0,0,0.00,0.00,'','0000-00-00',0,'Thank You','');
212/*!40000 ALTER TABLE `wp_quob_authnet_subscription` ENABLE KEYS */;
213UNLOCK TABLES;
214
215--
216-- Table structure for table `wp_quob_authnet_user_subscription`
217--
218
219DROP TABLE IF EXISTS `wp_quob_authnet_user_subscription`;
220/*!40101 SET @saved_cs_client = @@character_set_client */;
221/*!40101 SET character_set_client = utf8 */;
222CREATE TABLE `wp_quob_authnet_user_subscription` (
223 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
224 `user_id` bigint(20) unsigned NOT NULL,
225 `billingFirstName` varchar(255) NOT NULL,
226 `billingLastName` varchar(255) NOT NULL,
227 `billingCompany` varchar(255) NOT NULL,
228 `billingAddress` varchar(255) NOT NULL,
229 `billingCity` varchar(255) NOT NULL,
230 `billingState` varchar(255) NOT NULL,
231 `billingZip` varchar(45) NOT NULL,
232 `billingCountry` varchar(255) NOT NULL DEFAULT 'United States',
233 `billingPhone` varchar(45) NOT NULL,
234 `shippingFirstName` varchar(255) DEFAULT NULL,
235 `shippingLastName` varchar(255) DEFAULT NULL,
236 `shippingCompany` varchar(255) DEFAULT NULL,
237 `shippingAddress` varchar(255) DEFAULT NULL,
238 `shippingCity` varchar(255) DEFAULT NULL,
239 `shippingState` varchar(255) DEFAULT NULL,
240 `shippingZip` varchar(45) DEFAULT NULL,
241 `shippingCountry` varchar(255) DEFAULT 'United States',
242 `shippingPhone` varchar(45) DEFAULT NULL,
243 `emailAddress` varchar(255) NOT NULL,
244 `xSubscriptionId` varchar(255) DEFAULT NULL,
245 `lastFourDigitsOfCreditCard` char(4) DEFAULT NULL,
246 `lastFourDigitsOfBankAccountNumber` char(4) DEFAULT NULL,
247 `startDate` datetime DEFAULT NULL,
248 `MWXAccountLinked` datetime DEFAULT NULL,
249 `isRecurring` int(10) DEFAULT NULL,
250 `endRecurringDate` datetime DEFAULT NULL,
251 `subscriptionNotes` text,
252 `userIP` varchar(255) DEFAULT NULL,
253 PRIMARY KEY (`ID`) USING BTREE
254) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COMMENT='this table corresponds to user in wordpress';
255/*!40101 SET character_set_client = @saved_cs_client */;
256
257--
258-- Dumping data for table `wp_quob_authnet_user_subscription`
259--
260
261LOCK TABLES `wp_quob_authnet_user_subscription` WRITE;
262/*!40000 ALTER TABLE `wp_quob_authnet_user_subscription` DISABLE KEYS */;
263INSERT INTO `wp_quob_authnet_user_subscription` VALUES (1,6,'James','Buckley','','300 Angier Ave','CASHMERE','Washington','98815','US','','James','Buckley','','300 Angier Ave','CASHMERE','Washington','98815','US',NULL,'jebandfam@yahoo.com',NULL,'5793',NULL,NULL,NULL,NULL,NULL,'','68.119.8.81'),(2,6,'james','buckley','','300 Angier ave ','cashmere','wa','98815','US','','james','buckley','','300 Angier ave ','cashmere','wa','98815','US',NULL,'jebandfam@yahoo.com',NULL,'5793',NULL,NULL,NULL,NULL,NULL,'','68.119.8.81'),(3,7,'james','buckley','','300 angier ave','cashmere','wa','98815','US','','james','buckley','','300 angier ave','cashmere','wa','98815','US',NULL,'bhort509@aol.com',NULL,'5793',NULL,NULL,NULL,NULL,NULL,'','68.119.8.81'),(4,8,'justin','madsen','','2734 NE Twin Spits RD','Hansville','Washington','98340','US','(360)-638-2934','justin','madsen','','2734 NE Twin Spits RD','Hansville','Washington','98340','US',NULL,'wabubaby@hotmail.com',NULL,'9749',NULL,NULL,NULL,NULL,NULL,'','98.125.158.169'),(5,9,'Craig','Still','','212 5th #13','Wenatchee','WA','98801','US','5098841707','Craig','Still','','212 5th #13','Wenatchee','WA','98801','US',NULL,'craigs@nwi.net',NULL,'7853',NULL,NULL,NULL,NULL,NULL,'','50.34.64.49'),(6,10,'Norman','Lanier','','3405 Elder Mountain rd','Chattanooga','TN','37419','US','423-400-4032','Norman','Lanier','','3405 Elder Mountain rd','Chattanooga','TN','37419','US',NULL,'Sailtn@gmail.com',NULL,'5165',NULL,NULL,NULL,NULL,NULL,'','23.251.68.195'),(7,11,'Dave','Nevarez','','12 pacifica','Los lunas','NM','87031','US','5056041434','Dave','Nevarez','','8620 Northeastern Blvd ne.\r\nApt#49','Albuquerque ','NM','87112','US',NULL,'davebalderete@hotmail.com',NULL,'9944',NULL,NULL,NULL,NULL,NULL,'','68.35.183.193'),(8,12,'James','Ward','','35031 Queens way','Fruitland Park','Fl.','34731','US','352 593 6524','James','Ward','','35031 Queens way','Fruitland Park','Fl.','34731','US',NULL,'beardiebadass@gmail.com',NULL,'2549',NULL,NULL,NULL,NULL,NULL,'','184.4.159.58'),(9,13,'francis','coates','','4401 Montgomery ne # 146','albuquerque','new mexico','87109','US','505-385-8177','francis','coates','','4401 Montgomery ne # 146','albuquerque','new mexico','87109','US',NULL,'fpcoates@msn.com',NULL,'7423',NULL,NULL,NULL,NULL,NULL,'','68.35.66.55'),(10,14,'gift','card','','1602 w st rt 18','tiffin','ohio','44883','US','','crazy joes','trading post','','po box 102','old fort','ohio','44883','US',NULL,'joewade825@yahoo.com',NULL,'9555',NULL,NULL,NULL,NULL,NULL,'','98.28.105.185'),(11,15,'carl','hilman','','8 dolge ct','oxford','Massachusetts','01540','US','4138960799','carl','hilman','','8 dolge ct','oxford','Massachusetts','01540','US',NULL,'carlthilman@yahoo.com',NULL,'9836',NULL,NULL,NULL,NULL,NULL,'','75.130.103.182'),(12,14,'gift','card','','1600 w st rt 18','tiffin','ohio','44883','US','','c joes','trading post','','po box 102','old fort','ohio','44861','US',NULL,'joewade825@yahoo.com',NULL,'0502',NULL,NULL,NULL,NULL,NULL,'','108.86.166.153'),(13,16,'William','Reilly','','2335 se 44th ave','Portland','OR','97215','US','5036798030','William','Reilly','','2335 se 44th ave','Portland','OR','97215','US',NULL,'typesmooth@hotmail.com',NULL,'7856',NULL,NULL,NULL,NULL,NULL,'Comments: thanks!','50.139.125.9'),(14,17,'Keith','Carrig','','5238 w 64th pl','Chicago','illinois','60638','US','7732552136','Keith','Carrig','','5238 w 64th pl','Chicago','illinois','60638','US',NULL,'dimebonics1980@gmail.com',NULL,'1985',NULL,NULL,NULL,NULL,NULL,'','166.175.60.53'),(15,13,'francis','coates','mine','4401 Montgomery ne # 146','albuquerque','new mexico','87109','US','505-385-8177','francis','coates','mine','4401 Montgomery ne # 146','albuquerque','new mexico','87109','US',NULL,'fpcoates@msn.com',NULL,'7423',NULL,NULL,NULL,NULL,NULL,'','68.35.66.55'),(16,18,'Donald','Lovell','','po box 1250','Crestone','Colorado','81131','US','719-937-3316','Donald','Lovell','','po box 1250','Crestone','Colorado','81131','US',NULL,'gnometownherosrock@gmail.com',NULL,'1967',NULL,NULL,NULL,NULL,NULL,'','162.255.157.10'),(17,19,'Nicolas','Williams','','212 Forest Hill Dr.','Anderson','SC','29621','US','','Nicolas','Williams','','212 Forest Hill Dr.','Anderson','SC','29621','US',NULL,'N.onasis4@gmail.com',NULL,'6908',NULL,NULL,NULL,NULL,NULL,'','75.136.141.209'),(18,14,'gift','card','','1714 west market st','tiffin','ohio','44883','US','','c joes','trading post','','po box 102','old fort','ohio','44861','US',NULL,'joewade825@yahoo.com',NULL,'0132',NULL,NULL,NULL,NULL,NULL,'','108.86.166.153'),(19,20,'Frankie','Fitch','','3660 Hammond rd','Paintsville','Kentucky','41240','US','606-792-7894','Frankie','Fitch','','3660 Hammond rd','Paintsville','Kentucky','41240','US',NULL,'ffitch02@yahoo.com',NULL,'2437',NULL,NULL,NULL,NULL,NULL,'','76.8.181.108'),(20,21,'John','Blaugrund','--','102 Ocean Vista','Newport Beach','CA','92660','US','9493226593','John','Blaugrund','--','102 Ocean Vista','Newport Beach','CA','92660','US',NULL,'johnb@jsbholdings.com',NULL,'9801',NULL,NULL,NULL,NULL,NULL,'','12.132.200.154'),(21,22,'Dylan','Sheets','','6605 west argent rd','pasco','washington','99301','US','5093029552','Dylan','Sheets','','6605 west argent rd','pasco','washington','99301','US',NULL,'dylansheet@hotmail.com',NULL,'4012',NULL,NULL,NULL,NULL,NULL,'','184.78.207.93'),(22,23,'Alejandro \\\"AL\\\"','Aguilar','','362 highland st','Pasadena','California ','91104-1039','US','','Alejandro \\\"AL\\\"','Aguilar','','362 highland st','Pasadena','California ','91104-1039','US',NULL,'Flyboy11@sbcglobal.net',NULL,'0492',NULL,NULL,NULL,NULL,NULL,'Comments: Thanks for your response Jim.','75.142.63.26'),(23,24,'Ryan','Middleton','','10660 Stuart Street','Westminster','CO','80031','US','','Ryan','Middleton','','10660 Stuart Street','Westminster','CO','80031','US',NULL,'slightlystoopid50@gmail.com',NULL,'6434',NULL,NULL,NULL,NULL,NULL,'','174.29.191.164'),(24,25,'Mark','Schlei','','N9807 deer lake rd','Crivitz ','Wisconsin ','54114','US','414-870-4760','Mark','Schlei','','N9807 deer lake rd','Crivitz ','Wisconsin ','54114','US',NULL,'Markschlei@centurylink.net',NULL,'4868',NULL,NULL,NULL,NULL,NULL,'','184.158.62.157'),(25,26,'fred','williams','','7602 17th ave.w. trailer # 10','bradenton','florida','34209-0000','US','9415926043','fred','williams','','7602 17th ave.w. trailer # 10','bradenton','florida','34209-0000','US',NULL,'welmore12320@gmail.com',NULL,'8274',NULL,NULL,NULL,NULL,NULL,'Comments: Trailer 10 is behind the first trailer on 17th st.w. you come to after turning off 75th st.','72.184.76.176'),(26,27,'Jassen','Bowman','','305 W Magnolia St #243','Fort Collins','CO','80521','US','','Jassen','Bowman','','1800 Sidney Ave Apt 13-250','Port Orchard','WA','98366','US',NULL,'jassenbowman@gmail.com',NULL,'3631',NULL,NULL,NULL,NULL,NULL,'','24.56.193.226'),(27,24,'Ryan','Middleton','','10660 Stuart Street','Westminster','CO','80031','US','','Ryan','Middleton','','10660 Stuart Street','Westminster','CO','80031','US',NULL,'slightlystoopid50@gmail.com',NULL,'6434',NULL,NULL,NULL,NULL,NULL,'','184.96.173.4'),(28,28,'michael','dalzell','','po box 1251','girdwood','ak','99587','US','','michael','dalzell','','po box 1251','girdwood','ak','99587','US',NULL,'mdalzell@gci.net',NULL,'6357',NULL,NULL,NULL,NULL,NULL,'','24.237.206.15'),(29,32,'Donald','Solomon','','2474 Paris St Apt 3','Cincinnati','OH','45219','US','5133070697','Donald','Solomon','','2474 Paris St Apt 3','Cincinnati','OH','45219','US',NULL,'Dsolomon1125@gmail.com',NULL,'5427',NULL,NULL,NULL,NULL,NULL,'','208.54.40.171'),(30,14,'gift','card','','1714 west market st','tiffin','ohio','44883','US','','c joes','trading post','','po box 102','old fort','ohio','44861','US',NULL,'joewade825@yahoo.com',NULL,'3224',NULL,NULL,NULL,NULL,NULL,'','108.86.166.153'),(31,33,'Craig','Vines','','719 w main st 202','Aspen','Co','81611','US','9703791654','Craig','Vines','','719 w main st 202','Aspen','Co','81611','US',NULL,'Cvwaterfalls@msn.com',NULL,'9601',NULL,NULL,NULL,NULL,NULL,'','24.9.10.116'),(32,34,'Bob','Antini','','469 Smith Ridge Smith Rd. B','South Salem','N.Y.','10590','US','','Bob','Antini','','469 Smith Ridge Smith Rd. B','South Salem','N.Y.','10590','US',NULL,'tunes_guy@hotmail.com',NULL,'1309',NULL,NULL,NULL,NULL,NULL,'Comments: To JBC.& The Rev.wrote to you previously and you were kind enough to mention a few extra gifted reports from a different stain, WOULD BE APPRECIATE