-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 10, 2016 at 11:13 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.5.37

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `prankpack_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `plivo_requests`
--

CREATE TABLE `plivo_requests` (
  `plivo_request_id` int(11) NOT NULL,
  `plivo_total_cost` double NOT NULL DEFAULT '0',
  `plivo_hangupcause` varchar(255) NOT NULL DEFAULT '',
  `plivo_from` varchar(255) NOT NULL DEFAULT '',
  `plivo_callername` varchar(255) NOT NULL DEFAULT '',
  `plivo_billduration` float NOT NULL DEFAULT '0',
  `plivo_billrate` float NOT NULL DEFAULT '0',
  `plivo_to` varchar(255) NOT NULL DEFAULT '',
  `plivo_forwarded_from` varchar(255) NOT NULL DEFAULT '',
  `plivo_callid` varchar(255) NOT NULL DEFAULT '',
  `plivo_answertime` varchar(255) NOT NULL DEFAULT '',
  `plivo_sip_h_to` varchar(255) NOT NULL DEFAULT '',
  `plivo_callstatus` varchar(100) NOT NULL DEFAULT '',
  `plivo_direction` varchar(80) NOT NULL DEFAULT '',
  `plivo_endtime` varchar(100) NOT NULL DEFAULT '',
  `plivo_dialmusic` varchar(60) NOT NULL DEFAULT '',
  `plivo_startime` varchar(100) NOT NULL DEFAULT '',
  `plivo_duration` int(11) NOT NULL DEFAULT '0',
  `plivo_calluuid` varchar(255) NOT NULL DEFAULT '',
  `plivo_event` varchar(60) NOT NULL DEFAULT '',
  `plivo_createdat` datetime DEFAULT NULL,
  `plivo_updatedat` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `plivo_requests`
--

INSERT INTO `plivo_requests` (`plivo_request_id`, `plivo_total_cost`, `plivo_hangupcause`, `plivo_from`, `plivo_callername`, `plivo_billduration`, `plivo_billrate`, `plivo_to`, `plivo_forwarded_from`, `plivo_callid`, `plivo_answertime`, `plivo_sip_h_to`, `plivo_callstatus`, `plivo_direction`, `plivo_endtime`, `plivo_dialmusic`, `plivo_startime`, `plivo_duration`, `plivo_calluuid`, `plivo_event`, `plivo_createdat`, `plivo_updatedat`) VALUES
(1, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923226353730', '', '18054573143', '', '<sip:923226353730@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '5380f914-7c7e-44e6-9360-fba5deb4cba6', 'StartApp', '2016-08-17 12:42:59', '2016-08-17 12:42:59'),
(2, 0, 'NORMAL_CLEARING', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923226353730', '', '18054573143', '', '<sip:923226353730@phone.plivo.com>', 'completed', 'inbound', '2016-08-17 06:43:13', 'real', '2016-08-17 06:43:01', 0, '5380f914-7c7e-44e6-9360-fba5deb4cba6', 'Hangup', '2016-08-17 12:43:10', '2016-08-17 12:43:10'),
(3, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '188b260d-b3cd-4c9e-9769-f462413ef154', 'StartApp', '2016-09-02 14:31:32', '2016-09-02 14:31:32'),
(4, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'dd929d5e-6292-499a-be97-47460061eb34', 'StartApp', '2016-09-02 14:37:00', '2016-09-02 14:37:00'),
(5, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'b9f26066-f554-44fa-9c94-89ed19c87f20', 'StartApp', '2016-09-02 14:37:15', '2016-09-02 14:37:15'),
(6, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'a59be038-05ae-44d9-9c18-569a3a569306', 'StartApp', '2016-09-02 14:40:38', '2016-09-02 14:40:38'),
(7, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '08aa480c-8d29-4838-8ed5-b89499c0481b', 'StartApp', '2016-09-02 14:43:54', '2016-09-02 14:43:54'),
(8, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '56cf2009-03f4-45e1-a1b6-cd2ed2df9264', 'StartApp', '2016-09-02 14:44:56', '2016-09-02 14:44:56'),
(9, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 3, 'b578b364-6894-4b74-9cad-8921e39d5dfa', 'StartApp', '2016-09-02 14:46:19', '2016-09-02 14:46:19'),
(10, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 4, 'a892e050-6696-4b38-98f8-69de3fb051c2', 'StartApp', '2016-09-02 14:46:51', '2016-09-02 14:46:51'),
(11, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'c7ae0dd0-09e6-4991-82ec-075d5098bec8', 'StartApp', '2016-09-02 15:21:32', '2016-09-02 15:21:32'),
(12, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'ddef3b9d-a60a-4000-a86e-59eead23ab60', 'StartApp', '2016-09-02 15:22:53', '2016-09-02 15:22:53'),
(13, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '27e6d944-e9bb-4cc4-a1d8-b6720f7a11c9', 'StartApp', '2016-09-08 08:37:35', '2016-09-08 08:37:35'),
(14, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'f2d3f5ce-0030-4275-9007-a142d8e11439', 'StartApp', '2016-09-08 08:39:55', '2016-09-08 08:39:55'),
(15, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '3ef72533-8eb9-44f4-abc8-72b41cffcb3d', 'StartApp', '2016-09-08 08:40:45', '2016-09-08 08:40:45'),
(16, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '5bd5b1bc-455a-479b-9320-98130add6129', 'StartApp', '2016-09-08 08:43:27', '2016-09-08 08:43:27'),
(17, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '0aa680dd-bc3f-471b-b9a2-dba7cc57f341', 'StartApp', '2016-09-08 08:44:23', '2016-09-08 08:44:23'),
(18, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '5f67f013-7c6e-43b8-a89e-37b55f9839ac', 'StartApp', '2016-09-08 08:48:09', '2016-09-08 08:48:09'),
(19, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '06a64a33-24e1-492b-8d1b-1b6648ed3971', 'StartApp', '2016-09-08 08:49:33', '2016-09-08 08:49:33'),
(20, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '928d0e3b-c16e-4f3c-933d-58e6bec66e3f', 'StartApp', '2016-09-08 08:50:03', '2016-09-08 08:50:03'),
(21, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'b44e57da-7b1f-43dc-b432-45fe85bc66f9', 'StartApp', '2016-09-08 08:54:19', '2016-09-08 08:54:19'),
(22, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'c1651810-8e8e-4030-a6d7-d6679bcccdec', 'StartApp', '2016-09-08 08:54:48', '2016-09-08 08:54:48'),
(23, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '042a750d-e466-4173-beec-a55351176f83', 'StartApp', '2016-09-08 09:03:02', '2016-09-08 09:03:02'),
(24, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '874637c7-a4f6-48dd-a441-ca86ed1f30d7', 'StartApp', '2016-09-08 09:26:04', '2016-09-08 09:26:04'),
(25, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '742ca571-fed3-4f3b-9679-95b790ed8673', 'StartApp', '2016-09-08 09:26:40', '2016-09-08 09:26:40'),
(26, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '05530acf-99eb-41cd-a45f-8e69ef700072', 'StartApp', '2016-09-08 09:56:48', '2016-09-08 09:56:48'),
(27, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'c12131b2-3158-43fd-addc-7e92f4795af9', 'StartApp', '2016-09-08 09:57:13', '2016-09-08 09:57:13'),
(28, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '0a89a173-9774-44b8-b318-ad076ba3637e', 'StartApp', '2016-09-08 09:58:15', '2016-09-08 09:58:15'),
(29, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, 'df69d77c-aa00-40ce-a70f-1e3d8d869f2c', 'StartApp', '2016-09-08 09:58:35', '2016-09-08 09:58:35'),
(30, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '9a6ab8df-5eac-4971-ab08-890680b72cce', 'StartApp', '2016-09-08 09:59:01', '2016-09-08 09:59:01'),
(31, 0, '', 'sip:Ijaz160812103105@phone.plivo.com', 'Ijaz', 0, 0.003, '923248846361', '', '18054573143', '', '<sip:923248846361@phone.plivo.com>', 'ringing', 'inbound', '', 'real', '', 0, '8ee477d5-7efa-41a2-9a2a-53cbf2f6dabe', 'StartApp', '2016-09-08 09:59:30', '2016-09-08 09:59:30');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `plivo_requests`
--
ALTER TABLE `plivo_requests`
  ADD PRIMARY KEY (`plivo_request_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `plivo_requests`
--
ALTER TABLE `plivo_requests`
  MODIFY `plivo_request_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
/*!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 */;
