 --
 
 INSERT INTO `inbox` (`UpdatedInDB`, `ReceivingDateTime`, `Text`, `SenderNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `RecipientID`, `Processed`) VALUES
-('2014-09-02 02:50:36', '2014-08-19 02:59:17', '004B0061006200610072002000670065006D00620069007200610020006B0069006E0069002000490053004900200055004C0041004E0047002000610064006100200062006F006E00750073006E00790061002E002000490053004900200055004C0041004E0047002000520070002000350030005200420020004800410052004900200049004E0049002000310039004100670075007300740031003400200047005200410054004900530020003200300030003000300020006B006500200073006500730061006D006100200049006E0064006F0073006100740020006200650072006C0061006B00750020003300200068006100720069002E00200042006F006E00750073002000680061006E00790061002000310078002E00200049006E0066006F003A003100300030002E002000480052003100370032', 'Indosat', 'Default_No_Compression', '', '+62816124', -1, 'Kabar gembira kini ISI ULANG ada bonusnya. ISI ULANG Rp 50RB HARI INI 19Agust14 GRATIS 20000 ke sesama Indosat berlaku 3 hari. Bonus hanya 1x. Info:100. HR172', 27, '', 'true'),
-('2014-09-03 07:06:42', '2014-08-19 03:03:47', '00790061', '+6281805030211', 'Default_No_Compression', '', '+62818445009', -1, 'Y', 28, '', 'false');
+('2014-09-03 14:31:05', '2014-08-19 02:59:17', '004B0061006200610072002000670065006D00620069007200610020006B0069006E0069002000490053004900200055004C0041004E0047002000610064006100200062006F006E00750073006E00790061002E002000490053004900200055004C0041004E0047002000520070002000350030005200420020004800410052004900200049004E0049002000310039004100670075007300740031003400200047005200410054004900530020003200300030003000300020006B006500200073006500730061006D006100200049006E0064006F0073006100740020006200650072006C0061006B00750020003300200068006100720069002E00200042006F006E00750073002000680061006E00790061002000310078002E00200049006E0066006F003A003100300030002E002000480052003100370032', '+6281578762345', 'Default_No_Compression', '', '+62816124', -1, 'REG john', 27, '', 'true'),
+('2014-09-03 14:33:02', '2014-08-19 03:03:47', '00790061', '+6281805030211', 'Default_No_Compression', '', '+62818445009', -1, 'N', 28, '', 'true');
 
 --
 -- Triggers `inbox`

  `client_name` varchar(30) NOT NULL,
  `status` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `phone_number`, `client_name`, `status`) VALUES
(1, '+6281805030211', 'guntur', '0');

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


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

--
-- Table structure for table `stats`
--

CREATE TABLE IF NOT EXISTS `stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `case_solved` int(11) NOT NULL,
  `sms_count` int(11) NOT NULL,
  `sms_tariff` int(11) NOT NULL,
  `spam_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `stats`
--

INSERT INTO `stats` (`id`, `case_solved`, `sms_count`, `sms_tariff`, `spam_counter`) VALUES
(1, 1, 7, 350, 1);

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

--
-- Table structure for table `users`
--

