-- MySQL dump 10.13  Distrib 5.5.42, for Linux (x86_64)
--
-- Host: localhost    Database: yooblycr_sendgrid
-- ------------------------------------------------------
-- Server version	5.5.42-cll

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `sg_message_id` varchar(250) NOT NULL,
  `sg_event_id` varchar(250) NOT NULL,
  `useragent` text NOT NULL,
  `event` varchar(200) NOT NULL,
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
INSERT INTO `transactions` VALUES (1,0,'125.60.240.231','14bc6d7137a.703f.ff41a.filter-374.20722.54EF51AE48.0','Mjk0NjI5ODQtMTJlZS00YjkzLWI2NmMtMTBkZjE5ZGE4YjU4','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.115 Safari/537.36','open','2015-02-26 17:08:38'),(2,2,'125.60.240.231','14bc6e05b0a.5576.b830f.filter-160.21869.54EF54082C.0','OTU2MTY3NDItMmQ4NS00MDBhLWJlODAtMWZmMTMyZTczYjhh','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.115 Safari/537.36','open','2015-02-26 17:13:28'),(3,30851,'66.249.82.190','14bc6e439da.7041.bd038.filter-291.12031.54EF550C2.0','NThhZTUzMGQtNzI5YS00NDRhLWE2Y2YtZjlhMjJlZGM5NWIy','Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy)','open','2015-02-26 17:17:53'),(4,34608,'125.60.240.231','14bc6e7ca86.655f.ba357.filter-387.25229.54EF55F520.0','YTg3ZGFjZWUtYmI0ZC00MmVlLTkwMjAtNjk5NjVlM2MxODM3','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.115 Safari/537.36','open','2015-02-26 17:21:39'),(5,0,'72.186.251.14','14bc70ed798.2f87.9f3e1.filter-331.13097.54EF5FF526.0','Y2EyZGIwODctY2M1Mi00Zjc2LThjZDYtZjgwYjJjMzZiNTQ2','Mozilla/5.0 (iPod touch; CPU iPhone OS 8_1_3 like Mac OS X) AppleWebKit/600.1.4 (KHTML, like Gecko) Mobile/12B466','open','2015-02-26 18:04:15'),(6,0,'50.82.31.157','14bc742f88f.5d28.7dbfd.filter-287.19035.54EF6D4D25.0','OGZjMGRhODQtYTEyYi00ZWZmLWEzYjAtN2FlMzc0ZGFiNTg4','Mozilla/5.0 (Linux; U; Android 4.4.2; en-us; SCH-R970 Build/KOT49H) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30','open','2015-02-26 19:39:06'),(7,0,'50.82.31.157','14bc742f88f.5d28.7dbfd.filter-287.19035.54EF6D4D25.0','NDJjODE2ZmItYTlkNy00NjZkLTg1ZDctM2NmYjJhYzQ0MzMy','Mozilla/5.0 (Linux; U; Android 4.4.2; en-us; SCH-R970 Build/KOT49H) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30','open','2015-02-26 19:39:06'),(8,0,'50.82.31.157','14bc742f88f.5d28.7dbfd.filter-287.19035.54EF6D4D25.0','ZTBlOTg3NGEtYTUzOC00MzczLWIxZGEtODBhZDM2Y2M0MzI1','Mozilla/5.0 (Linux; U; Android 4.4.2; en-us; SCH-R970 Build/KOT49H) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30','open','2015-02-26 19:48:08'),(9,0,'66.249.88.130','14bc70ed798.2f87.9f3e1.filter-331.13097.54EF5FF526.0','ZDJhODI5ZmEtNGYwZi00NTRiLThiYTgtNGQ2Y2ZiOWQwMDYw','Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy)','open','2015-02-26 20:12:06');
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2015-02-26 17:55:20
