-- http://www.phpmyadmin.net
--




--
-- Database: `prankpack_db`
--

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

--
-- Table structure for table `call_log`
--

CREATE TABLE `call_log` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `calling_number` int(11) DEFAULT NULL,
  `called_number` int(11) DEFAULT NULL,
  `start_time` int(11) DEFAULT NULL,
  `end_time` int(11) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `call_cost` double DEFAULT NULL,
  `forwarded_from` int(11) DEFAULT NULL,
  `call_status` int(11) DEFAULT NULL,
  `sound_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `package`
--

CREATE TABLE `package` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `cost` double DEFAULT NULL,
  `duration` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `package`
--

INSERT INTO `package` (`id`, `name`, `description`, `cost`, `duration`) VALUES
(1, '5$ Package', '294 Minutes in just 5$', 5, 294),
(2, '10$ Package', '588 Minutes in just 10$', 10, 588);

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

--
-- 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');

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

--
-- Table structure for table `purchased_no`
--

CREATE TABLE `purchased_no` (
  `id` int(11) NOT NULL,
  `number` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `monthly_rental` double DEFAULT NULL,
  `call_rate_per_min` double DEFAULT NULL,
  `number_type` varchar(50) DEFAULT NULL,
  `added_on` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchased_no`
--

INSERT INTO `purchased_no` (`id`, `number`, `status`, `monthly_rental`, `call_rate_per_min`, `number_type`, `added_on`) VALUES
(16, 18054573143, 1, 0.8, 0.0085, 'local', 1470607200);

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

--
-- Table structure for table `purchased_packages`
--

CREATE TABLE `purchased_packages` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `package_id` int(11) DEFAULT NULL,
  `duration_left` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `receipt` varchar(50) DEFAULT NULL,
  `signature_data` varchar(50) DEFAULT NULL,
  `platform` int(11) DEFAULT NULL,
  `android_id` varchar(50) DEFAULT NULL,
  `ios-id` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchased_packages`
--

INSERT INTO `purchased_packages` (`id`, `user_id`, `package_id`, `duration_left`, `status`, `receipt`, `signature_data`, `platform`, `android_id`, `ios-id`) VALUES
(2, 7, 1, 1176, 1, NULL, NULL, 1, 'AS12DA123', NULL);

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

--
-- Table structure for table `sound`
--

CREATE TABLE `sound` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `length` int(11) DEFAULT NULL,
  `category` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sound`
--

INSERT INTO `sound` (`id`, `name`, `url`, `length`, `category`) VALUES
(1, '1 Flirt', 'web/sounds/medicated_soundboards/FLIRT/1%20Flirt', NULL, 0),
(2, '2 Flirt', 'web/sounds/medicated_soundboards/FLIRT/2%20Flirt', NULL, 0),
(3, '3 Flirt', 'web/sounds/medicated_soundboards/FLIRT/3%20Flirt', NULL, 0),
(4, '4 Flirt', 'web/sounds/medicated_soundboards/FLIRT/4%20Flirt', NULL, 0),
(5, '5 Flirt', 'web/sounds/medicated_soundboards/FLIRT/5%20Flirt', NULL, 0),
(6, '6 Flirt', 'web/sounds/medicated_soundboards/FLIRT/6%20Flirt', NULL, 0),
(7, '7 Flirt', 'web/sounds/medicated_soundboards/FLIRT/7%20Flirt', NULL, 0),
(8, '8 Flirt', 'web/sounds/medicated_soundboards/FLIRT/8%20Flirt', NULL, 0),
(9, '9 Flirt', 'web/sounds/medicated_soundboards/FLIRT/9%20Flirt', NULL, 0),
(10, '10 Flirt', 'web/sounds/medicated_soundboards/FLIRT/10%20Flirt', NULL, 0),
(11, '11 Flirt', 'web/sounds/medicated_soundboards/FLIRT/11%20Flirt', NULL, 0),
(12, '12 Flirt', 'web/sounds/medicated_soundboards/FLIRT/12%20Flirt', NULL, 0),
(13, '13 Flirt', 'web/sounds/medicated_soundboards/FLIRT/13%20Flirt', NULL, 0),
(14, '14 Flirt', 'web/sounds/medicated_soundboards/FLIRT/14%20Flirt', NULL, 0),
(15, '15 Flirt', 'web/sounds/medicated_soundboards/FLIRT/15%20Flirt', NULL, 0),
(16, '16 Flirt', 'web/sounds/medicated_soundboards/FLIRT/16%20Flirt', NULL, 0),
(17, '17 Flirt', 'web/sounds/medicated_soundboards/FLIRT/17%20Flirt', NULL, 0),
(18, '18 Flirt', 'web/sounds/medicated_soundboards/FLIRT/18%20Flirt', NULL, 0),
(19, '19 Flirt', 'web/sounds/medicated_soundboards/FLIRT/19%20Flirt', NULL, 0),
(20, '20 Flirt', 'web/sounds/medicated_soundboards/FLIRT/20%20Flirt', NULL, 0),
(21, '21 Flirt', 'web/sounds/medicated_soundboards/FLIRT/21%20Flirt', NULL, 0),
(22, '22 Flirt', 'web/sounds/medicated_soundboards/FLIRT/22%20Flirt', NULL, 0),
(23, '23 Flirt', 'web/sounds/medicated_soundboards/FLIRT/23%20Flirt', NULL, 0),
(24, '24 Flirt', 'web/sounds/medicated_soundboards/FLIRT/24%20Flirt', NULL, 0),
(25, '25 Flirt', 'web/sounds/medicated_soundboards/FLIRT/25%20Flirt', NULL, 0),
(26, '26 Flirt', 'web/sounds/medicated_soundboards/FLIRT/26%20Flirt', NULL, 0),
(27, '27 Flirt', 'web/sounds/medicated_soundboards/FLIRT/27%20Flirt', NULL, 0),
(28, '28 Flirt', 'web/sounds/medicated_soundboards/FLIRT/28%20Flirt', NULL, 0),
(29, '29 Flirt', 'web/sounds/medicated_soundboards/FLIRT/29%20Flirt', NULL, 0),
(30, '30 Flirt', 'web/sounds/medicated_soundboards/FLIRT/30%20Flirt', NULL, 0),
(31, '31 Flirt', 'web/sounds/medicated_soundboards/FLIRT/31%20Flirt', NULL, 0),
(32, '32 Flirt', 'web/sounds/medicated_soundboards/FLIRT/32%20Flirt', NULL, 0),
(33, '33 Flirt', 'web/sounds/medicated_soundboards/FLIRT/33%20Flirt', NULL, 0),
(34, '34 Flirt', 'web/sounds/medicated_soundboards/FLIRT/34%20Flirt', NULL, 0),
(35, '35 Flirt', 'web/sounds/medicated_soundboards/FLIRT/35%20Flirt', NULL, 0),
(36, '36 Flirt', 'web/sounds/medicated_soundboards/FLIRT/36%20Flirt', NULL, 0),
(37, '37 Flirt', 'web/sounds/medicated_soundboards/FLIRT/37%20Flirt', NULL, 0),
(38, '38 Flirt', 'web/sounds/medicated_soundboards/FLIRT/38%20Flirt', NULL, 0),
(39, '39 Flirt', 'web/sounds/medicated_soundboards/FLIRT/39%20Flirt', NULL, 0),
(40, '40 Flirt', 'web/sounds/medicated_soundboards/FLIRT/40%20Flirt', NULL, 0),
(41, '41 Flirt', 'web/sounds/medicated_soundboards/FLIRT/41%20Flirt', NULL, 0),
(42, '42 Flirt', 'web/sounds/medicated_soundboards/FLIRT/42%20Flirt', NULL, 0),
(43, '43 Flirt', 'web/sounds/medicated_soundboards/FLIRT/43%20Flirt', NULL, 0),
(44, '44 Flirt', 'web/sounds/medicated_soundboards/FLIRT/44%20Flirt', NULL, 0),
(45, '45 Flirt', 'web/sounds/medicated_soundboards/FLIRT/45%20Flirt', NULL, 0),
(46, '46 Flirt', 'web/sounds/medicated_soundboards/FLIRT/46%20Flirt', NULL, 0),
(47, '1 Job', 'web/sounds/medicated_soundboards/JOB/1%20Job', NULL, 0),
(48, '2 Job', 'web/sounds/medicated_soundboards/JOB/2%20Job', NULL, 0),
(49, '3 Job', 'web/sounds/medicated_soundboards/JOB/3%20Job', NULL, 0),
(50, '4 Job', 'web/sounds/medicated_soundboards/JOB/4%20Job', NULL, 0),
(51, '5 Job', 'web/sounds/medicated_soundboards/JOB/5%20Job', NULL, 0),
(52, '6 Job', 'web/sounds/medicated_soundboards/JOB/6%20Job', NULL, 0),
(53, '7 Job', 'web/sounds/medicated_soundboards/JOB/7%20Job', NULL, 0),
(54, '8 Job', 'web/sounds/medicated_soundboards/JOB/8%20Job', NULL, 0),
(55, '9 Job', 'web/sounds/medicated_soundboards/JOB/9%20Job', NULL, 0),
(56, '10 Job', 'web/sounds/medicated_soundboards/JOB/10%20Job', NULL, 0),
(57, '11 Job', 'web/sounds/medicated_soundboards/JOB/11%20Job', NULL, 0),
(58, '12 Job', 'web/sounds/medicated_soundboards/JOB/12%20Job', NULL, 0),
(59, '13 Job', 'web/sounds/medicated_soundboards/JOB/13%20Job', NULL, 0),
(60, '14 Job', 'web/sounds/medicated_soundboards/JOB/14%20Job', NULL, 0),
(61, '15 Job', 'web/sounds/medicated_soundboards/JOB/15%20Job', NULL, 0),
(62, '16 Job', 'web/sounds/medicated_soundboards/JOB/16%20Job', NULL, 0),
(63, '17 Job', 'web/sounds/medicated_soundboards/JOB/17%20Job', NULL, 0),
(64, '18 Job', 'web/sounds/medicated_soundboards/JOB/18%20Job', NULL, 0),
(65, '19 Job', 'web/sounds/medicated_soundboards/JOB/19%20Job', NULL, 0),
(66, '20 Job', 'web/sounds/medicated_soundboards/JOB/20%20Job', NULL, 0),
(67, '21 Job', 'web/sounds/medicated_soundboards/JOB/21%20Job', NULL, 0),
(68, '22 Job', 'web/sounds/medicated_soundboards/JOB/22%20Job', NULL, 0),
(69, '23 Job', 'web/sounds/medicated_soundboards/JOB/23%20Job', NULL, 0),
(70, '24 Job', 'web/sounds/medicated_soundboards/JOB/24%20Job', NULL, 0),
(71, '25 Job', 'web/sounds/medicated_soundboards/JOB/25%20Job', NULL, 0),
(72, '26 Job', 'web/sounds/medicated_soundboards/JOB/26%20Job', NULL, 0),
(73, '27 Job', 'web/sounds/medicated_soundboards/JOB/27%20Job', NULL, 0),
(74, '28 Job', 'web/sounds/medicated_soundboards/JOB/28%20Job', NULL, 0),
(75, '29 Job', 'web/sounds/medicated_soundboards/JOB/29%20Job', NULL, 0),
(76, '30 Job', 'web/sounds/medicated_soundboards/JOB/30%20Job', NULL, 0),
(77, '31 Job', 'web/sounds/medicated_soundboards/JOB/31%20Job', NULL, 0),
(78, '32 Job', 'web/sounds/medicated_soundboards/JOB/32%20Job', NULL, 0),
(79, '33 Job', 'web/sounds/medicated_soundboards/JOB/33%20Job', NULL, 0),
(80, '1 Order', 'web/sounds/medicated_soundboards/ORDER/1%20Order', NULL, 0),
(81, '2 Order', 'web/sounds/medicated_soundboards/ORDER/2%20Order', NULL, 0),
(82, '3 Order', 'web/sounds/medicated_soundboards/ORDER/3%20Order', NULL, 0),
(83, '4 Order', 'web/sounds/medicated_soundboards/ORDER/4%20Order', NULL, 0),
(84, '5 Order', 'web/sounds/medicated_soundboards/ORDER/5%20Order', NULL, 0),
(85, '6 Order', 'web/sounds/medicated_soundboards/ORDER/6%20Order', NULL, 0),
(86, '7 Order', 'web/sounds/medicated_soundboards/ORDER/7%20Order', NULL, 0),
(87, '8 Order', 'web/sounds/medicated_soundboards/ORDER/8%20Order', NULL, 0),
(88, '9 Order', 'web/sounds/medicated_soundboards/ORDER/9%20Order', NULL, 0),
(89, '10 Order', 'web/sounds/medicated_soundboards/ORDER/10%20Order', NULL, 0),
(90, '11 Order', 'web/sounds/medicated_soundboards/ORDER/11%20Order', NULL, 0),
(91, '12 Order', 'web/sounds/medicated_soundboards/ORDER/12%20Order', NULL, 0),
(92, '13 Order', 'web/sounds/medicated_soundboards/ORDER/13%20Order', NULL, 0),
(93, '14 Order', 'web/sounds/medicated_soundboards/ORDER/14%20Order', NULL, 0),
(94, '15 Order', 'web/sounds/medicated_soundboards/ORDER/15%20Order', NULL, 0),
(95, '16 Order', 'web/sounds/medicated_soundboards/ORDER/16%20Order', NULL, 0),
(96, '17 Order', 'web/sounds/medicated_soundboards/ORDER/17%20Order', NULL, 0),
(97, '18 Order', 'web/sounds/medicated_soundboards/ORDER/18%20Order', NULL, 0),
(98, '19 Order', 'web/sounds/medicated_soundboards/ORDER/19%20Order', NULL, 0),
(99, '20 Order', 'web/sounds/medicated_soundboards/ORDER/20%20Order', NULL, 0),
(100, '21 Order', 'web/sounds/medicated_soundboards/ORDER/21%20Order', NULL, 0),
(101, '22 Order', 'web/sounds/medicated_soundboards/ORDER/22%20Order', NULL, 0),
(102, '23 Order', 'web/sounds/medicated_soundboards/ORDER/23%20Order', NULL, 0),
(103, '24 Order', 'web/sounds/medicated_soundboards/ORDER/24%20Order', NULL, 0),
(104, '25 Order', 'web/sounds/medicated_soundboards/ORDER/25%20Order', NULL, 0),
(105, '26 Order', 'web/sounds/medicated_soundboards/ORDER/26%20Order', NULL, 0),
(106, '27 Order', 'web/sounds/medicated_soundboards/ORDER/27%20Order', NULL, 0),
(107, '28 Order', 'web/sounds/medicated_soundboards/ORDER/28%20Order', NULL, 0),
(108, '29 Order', 'web/sounds/medicated_soundboards/ORDER/29%20Order', NULL, 0),
(109, '30 Order', 'web/sounds/medicated_soundboards/ORDER/30%20Order', NULL, 0),
(110, '31 Order', 'web/sounds/medicated_soundboards/ORDER/31%20Order', NULL, 0),
(111, '32 Order', 'web/sounds/medicated_soundboards/ORDER/32%20Order', NULL, 0),
(112, '33 Order', 'web/sounds/medicated_soundboards/ORDER/33%20Order', NULL, 0),
(113, '34 Order', 'web/sounds/medicated_soundboards/ORDER/34%20Order', NULL, 0),
(114, '35 Order', 'web/sounds/medicated_soundboards/ORDER/35%20Order', NULL, 0),
(115, '36 Order', 'web/sounds/medicated_soundboards/ORDER/36%20Order', NULL, 0),
(116, '37 Order', 'web/sounds/medicated_soundboards/ORDER/37%20Order', NULL, 0),
(117, '38 Order', 'web/sounds/medicated_soundboards/ORDER/38%20Order', NULL, 0),
(118, '39 Order', 'web/sounds/medicated_soundboards/ORDER/39%20Order', NULL, 0),
(119, '40 Order', 'web/sounds/medicated_soundboards/ORDER/40%20Order', NULL, 0),
(120, '41 Order', 'web/sounds/medicated_soundboards/ORDER/41%20Order', NULL, 0),
(121, '42 Order', 'web/sounds/medicated_soundboards/ORDER/42%20Order', NULL, 0),
(122, '43 Order', 'web/sounds/medicated_soundboards/ORDER/43%20Order', NULL, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `call_log`
--
ALTER TABLE `call_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_user_idcl` (`user_id`),
  ADD KEY `fk_forward_fromcl` (`forwarded_from`),
  ADD KEY `fk_call_logcl` (`calling_number`),
  ADD KEY `fk_sound_idcl` (`sound_id`);

--
-- Indexes for table `package`
--
ALTER TABLE `package`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `purchased_no`
--
ALTER TABLE `purchased_no`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchased_packages`
--
ALTER TABLE `purchased_packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_user_idpp` (`user_id`),
  ADD KEY `fk_package_idpp` (`package_id`);

--
-- Indexes for table `sound`
--
ALTER TABLE `sound`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `call_log`
--
ALTER TABLE `call_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `package`
--
ALTER TABLE `package`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `plivo_requests`
--
ALTER TABLE `plivo_requests`
  MODIFY `plivo_request_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT for table `purchased_no`
--
ALTER TABLE `purchased_no`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `purchased_packages`
--
ALTER TABLE `purchased_packages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `sound`
--
ALTER TABLE `sound`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `call_log`
--
ALTER TABLE `call_log`
  ADD CONSTRAINT `fk_sound_idcl` FOREIGN KEY (`sound_id`) REFERENCES `sound` (`id`);

--
-- Constraints for table `purchased_packages`
--
ALTER TABLE `purchased_packages`
  ADD CONSTRAINT `fk_package_idpp` FOREIGN KEY (`package_id`) REFERENCES `package` (`id`),
  ADD CONSTRAINT `fk_user_idpp` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

