-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 02, 2015 at 12:46 PM
-- Server version: 5.5.38-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.4

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 utf8 */;

--
-- Database: `violet-viettel`
--
CREATE DATABASE IF NOT EXISTS `violet-viettel` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `violet-viettel`;

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

--
-- Table structure for table `tbladmin`
--

DROP TABLE IF EXISTS `tbladmin`;
CREATE TABLE IF NOT EXISTS `tbladmin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `login_name` varchar(45) NOT NULL,
  `passwd` varchar(65) NOT NULL,
  `full_name` varchar(45) NOT NULL,
  `email` varchar(45) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  `author` int(11) DEFAULT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbladmin`
--

INSERT INTO `tbladmin` (`admin_id`, `login_name`, `passwd`, `full_name`, `email`, `phone`, `created_time`, `updated_time`, `author`) VALUES
(1, 'administrator', 'e10adc3949ba59abbe56e057f20f883e', 'Administrator', 'admin@sbg.vn', NULL, '2014-11-03 15:47:41', NULL, 1);

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

--
-- Table structure for table `tbladminrole`
--

DROP TABLE IF EXISTS `tbladminrole`;
CREATE TABLE IF NOT EXISTS `tbladminrole` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbladminrole`
--

INSERT INTO `tbladminrole` (`role_id`, `admin_id`) VALUES
(1, 1),
(2, 1);

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

--
-- Table structure for table `tblcardlog`
--

DROP TABLE IF EXISTS `tblcardlog`;
CREATE TABLE IF NOT EXISTS `tblcardlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` varchar(255) DEFAULT NULL,
  `us_id` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1' COMMENT '-1:fail;0:locked;1:success',
  `pin_code` varchar(45) DEFAULT NULL,
  `serial_num` varchar(45) DEFAULT NULL,
  `card_value` int(11) DEFAULT NULL,
  `created_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tblcardlog`
--

INSERT INTO `tblcardlog` (`id`, `sender`, `us_id`, `status`, `pin_code`, `serial_num`, `card_value`, `created_time`) VALUES
(1, '0988568786', 116, -1, 'ferwer', 'Æ°ersdfsdgf', 0, '2015-01-15 12:29:22'),
(2, '0988568786', 116, 0, 'Æ°erwerwe', 'rÆ°erwerwer', 0, '2015-01-15 12:30:13'),
(3, '0988568786', 116, 1, '0924647603794', '92594534261', 10000, '2015-01-15 16:59:19');

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

--
-- Table structure for table `tblcollaborator`
--

DROP TABLE IF EXISTS `tblcollaborator`;
CREATE TABLE IF NOT EXISTS `tblcollaborator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(45) NOT NULL,
  `login_name` varchar(45) NOT NULL,
  `cellphone` varchar(15) NOT NULL,
  `passwd` varchar(65) NOT NULL,
  `activated` tinyint(4) NOT NULL DEFAULT '1',
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  `author` int(11) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `district` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `precinct` varchar(255) NOT NULL,
  `province` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20536706 ;

--
-- Dumping data for table `tblcollaborator`
--

INSERT INTO `tblcollaborator` (`id`, `full_name`, `login_name`, `cellphone`, `passwd`, `activated`, `created_time`, `updated_time`, `author`, `address`, `code`, `district`, `email`, `precinct`, `province`) VALUES
(1, 'Truong Hoang Anh', '0982124899', '0982124899', '', 1, NULL, NULL, NULL, '', '', '', '', '', ''),
(2, 'Namta', '01689925260', '01689925260', 'c4ca4238a0b923820dcc509a6f75849b', 1, '2014-11-19 10:21:15', '2014-11-19 10:21:15', NULL, '', '', '', '', '', ''),
(5, 'dungnv', '0988568786', '0988568786', 'c4ca4238a0b923820dcc509a6f75849b', 1, '2014-11-19 18:45:27', '2014-11-19 18:45:27', NULL, '', '', '', '', '', ''),
(20536705, 'Chu ?Ã¬nh Anh', '', '962143096', '', 1, NULL, '2015-01-16 11:48:49', NULL, 'S? nhÃ  01 ???ng 01  ??c XuÃ¢n B?c K?n B?c K?n', '1000004001_00002_GPKHDN', '001', '', '004', 'B281');

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

--
-- Table structure for table `tblpaidlog`
--

DROP TABLE IF EXISTS `tblpaidlog`;
CREATE TABLE IF NOT EXISTS `tblpaidlog` (
  `paid_id` bigint(11) NOT NULL AUTO_INCREMENT,
  `us_id` int(11) NOT NULL,
  `paid_type` tinyint(11) NOT NULL DEFAULT '0' COMMENT '1:SMS; 2:CARD;',
  `amount` int(11) NOT NULL DEFAULT '0',
  `source` varchar(65) NOT NULL,
  `paid_time` datetime DEFAULT NULL,
  PRIMARY KEY (`paid_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `tblpaidlog`
--

INSERT INTO `tblpaidlog` (`paid_id`, `us_id`, `paid_type`, `amount`, `source`, `paid_time`) VALUES
(1, 100, 2, 10000, 'Tháº» cÃ o', '2014-11-25 15:16:59'),
(2, 101, 1, 1000, '01692006723', '2014-11-25 16:05:40'),
(3, 101, 1, 1000, '01692006723', '2014-11-25 16:08:43'),
(4, 101, 1, 2000, '01692006723', '2014-11-25 16:12:42'),
(5, 101, 1, 2500, '01692006723', '2014-11-25 16:33:26'),
(6, 101, 1, 100, '01692006723', '2014-11-25 16:36:38'),
(7, 101, 1, 2000, '01692006723', '2014-11-25 16:37:49'),
(8, 102, 1, 6000, '01632002905', '2014-11-25 16:55:44'),
(9, 102, 1, 6000, '01632002905', '2014-11-25 16:57:56'),
(10, 80, 2, 10000, 'Tháº» cÃ o', '2014-11-26 17:58:30'),
(11, 100, 2, 10000, 'Tháº» cÃ o', '2014-11-26 18:00:23'),
(12, 100, 1, 1, '0979359749', '2014-11-26 18:04:10'),
(13, 105, 1, 15000, '01692006723', '2014-12-02 11:08:44'),
(14, 105, 2, 20000, 'Tháº» cÃ o', '2014-12-02 14:27:00'),
(15, 105, 2, 20000, 'Tháº» cÃ o', '2014-12-04 16:28:36'),
(16, 139, 1, 15000, '0982199188', '2015-01-13 16:37:20'),
(17, 61, 1, 500, '0982124899', '2015-01-14 11:21:00'),
(18, 116, 2, 10000, 'Tháº» cÃ o', '2015-01-14 17:21:11'),
(19, 61, 2, 10000, 'Tháº» cÃ o', '2015-01-14 17:23:49'),
(20, 116, 2, 10000, 'Tháº» cÃ o', '2015-01-15 07:51:43'),
(21, 116, 2, 10000, 'Tháº» cÃ o', '2015-01-15 16:59:21');

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

--
-- Table structure for table `tblproduct`
--

DROP TABLE IF EXISTS `tblproduct`;
CREATE TABLE IF NOT EXISTS `tblproduct` (
  `product_id` int(11) NOT NULL DEFAULT '0',
  `product_name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tblregisterpackagelog`
--

DROP TABLE IF EXISTS `tblregisterpackagelog`;
CREATE TABLE IF NOT EXISTS `tblregisterpackagelog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL,
  `source` varchar(65) NOT NULL,
  `p_code` varchar(65) NOT NULL,
  `created_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tblregisterpackagelog`
--

INSERT INTO `tblregisterpackagelog` (`id`, `username`, `source`, `p_code`, `created_time`) VALUES
(1, '0988568786', 'Web', '1', '2015-01-15 16:59:46'),
(2, '0979947802', 'Web', '1', '2015-01-19 12:42:38');

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

--
-- Table structure for table `tblrole`
--

DROP TABLE IF EXISTS `tblrole`;
CREATE TABLE IF NOT EXISTS `tblrole` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(45) NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tblrole`
--

INSERT INTO `tblrole` (`role_id`, `role_name`) VALUES
(1, 'editUserInfo'),
(2, 'editAdminInfor');

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

--
-- Table structure for table `tblservicepackage`
--

DROP TABLE IF EXISTS `tblservicepackage`;
CREATE TABLE IF NOT EXISTS `tblservicepackage` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_name` varchar(50) NOT NULL,
  `p_period` int(11) NOT NULL,
  `p_price` int(11) NOT NULL,
  `p_code` varchar(15) DEFAULT NULL,
  `p_unit` varchar(15) DEFAULT NULL,
  `p_dfspace` varchar(15) DEFAULT '1GB',
  `p_isextra` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tblservicepackage`
--

INSERT INTO `tblservicepackage` (`p_id`, `p_name`, `p_period`, `p_price`, `p_code`, `p_unit`, `p_dfspace`, `p_isextra`) VALUES
(1, 'VIP 1', 1, 15000, '1', 'months', '1GB', 0),
(2, 'VIP 3', 3, 40000, '3', 'months', '1GB', 0),
(3, 'VIP 6', 6, 70000, '6', 'months', '1GB', 0),
(4, 'VIP 12', 12, 130000, '12', 'months', '1GB', 0),
(5, 'Trial', -1, 0, '-1', 'day', '1GB', 0);

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

--
-- Table structure for table `tblsmslog`
--

DROP TABLE IF EXISTS `tblsmslog`;
CREATE TABLE IF NOT EXISTS `tblsmslog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `request_id` varchar(255) DEFAULT '',
  `sender` varchar(255) DEFAULT NULL,
  `us_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `commandcode` varchar(255) DEFAULT NULL,
  `info` varchar(255) DEFAULT NULL,
  `mobody` varchar(255) DEFAULT NULL,
  `mtbody` varchar(255) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=140 ;

--
-- Dumping data for table `tblsmslog`
--

INSERT INTO `tblsmslog` (`id`, `request_id`, `sender`, `us_id`, `service_id`, `commandcode`, `info`, `mobody`, `mtbody`, `created_time`) VALUES
(1, '', '0979359749', NULL, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-25 10:59:14'),
(2, '', '0979359749', 100, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-25 11:08:41'),
(3, '', '0988568786', 68, 8062, 'SBG', 'Sbg nap aaa', NULL, NULL, '2014-11-25 12:30:29'),
(4, '', '0979359749', 100, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-25 13:27:56'),
(5, '', '01692006723', 101, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-25 14:59:35'),
(6, '', '01692006723', 101, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-25 15:50:49'),
(7, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 1000', NULL, NULL, '2014-11-25 15:53:35'),
(8, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 1000', NULL, NULL, '2014-11-25 15:56:43'),
(9, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 2000', NULL, NULL, '2014-11-25 16:00:41'),
(10, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 2500', NULL, NULL, '2014-11-25 16:21:25'),
(11, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 100', NULL, NULL, '2014-11-25 16:24:32'),
(12, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 2000', NULL, NULL, '2014-11-25 16:25:48'),
(13, '', '01632002905', 102, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-25 16:32:44'),
(14, '', '01632002905', 102, 8062, 'SBG', 'Sbg nap 6000', NULL, NULL, '2014-11-25 16:43:42'),
(15, '', '01632002905', 102, 8062, 'SBG', 'Sbg nap 6000', NULL, NULL, '2014-11-25 16:40:36'),
(16, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 10:02:48'),
(17, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:07:56'),
(18, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:07:56'),
(19, '', '0988568786', 68, 8062, 'SBG', 'Sbg mk 123456', NULL, NULL, '2014-11-26 11:12:00'),
(20, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:13:00'),
(21, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:13:00'),
(22, '', '0983460604', 103, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-26 11:42:14'),
(23, '', '0983460604', 103, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-26 11:42:14'),
(24, '', '0982124899', 61, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:43:48'),
(25, '', '01682821813', 99, 8062, 'SBG', 'SBG dk', NULL, NULL, '2014-11-18 09:52:35'),
(26, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
(27, '', '0979359749', 100, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-26 17:51:29'),
(28, '', '0979359749', 100, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2014-11-26 17:51:56'),
(29, '', '0979359749', 100, 8062, 'SBG', 'Sbg nap 001', NULL, NULL, '2014-11-26 17:52:03'),
(30, '', '0979947802', 67, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-27 01:13:24'),
(31, '', '0979947802', 67, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-27 01:13:24'),
(32, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
(33, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
(34, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-29 17:59:52'),
(35, '', '01654040214', NULL, 8062, 'SBG', 'Sbg dk 01692006723', NULL, NULL, '2014-12-02 10:04:13'),
(36, '', '01654040214', 105, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-02 10:35:49'),
(37, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
(38, '', '01682821813', 99, 8062, 'SBG', 'SBG dk', NULL, NULL, '2014-11-18 09:52:35'),
(39, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-02 10:48:26'),
(40, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 15000 01654040214', NULL, NULL, '2014-12-02 10:56:16'),
(41, '', '0978898670', NULL, 8062, 'SBG', 'SBG HD', NULL, NULL, '2014-12-05 16:36:54'),
(42, '', '01699328160', 106, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-05 23:05:05'),
(43, '', '0978898670', NULL, 8062, 'SBG', 'sbg', NULL, NULL, '2014-12-08 16:14:16'),
(44, '', '0985585868', NULL, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-18 09:52:35'),
(45, '', '0988568786', NULL, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-18 09:52:35'),
(46, '', '0988568786', NULL, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
(47, '', '0988568786', 112, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
(48, '', '0988568786', 113, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
(49, '', '0988568786', 114, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
(50, '', '0985585868', NULL, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2014-12-10 17:00:42'),
(51, '', '0988568786', NULL, 8062, 'SBG', 'DK SBG', NULL, NULL, '2014-11-18 09:52:35'),
(52, '', '0988568786', NULL, 8062, 'SBG', 'DK SBG', NULL, NULL, '2014-11-18 09:52:35'),
(53, '', '0988568786', 115, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
(54, '', '0988568786', 115, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
(55, '', '0988568786', 116, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
(56, '', '0974766688', 117, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-16 16:49:11'),
(57, '', '0987783898', 118, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-23 09:49:06'),
(58, '', '0977844844', 119, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-26 15:55:05'),
(59, '', '0986346346', 120, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-26 16:06:45'),
(60, '', '0988911183', 121, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-26 16:53:54'),
(61, '', '0965004848', 122, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-26 17:02:25'),
(62, '', '0965755111', 123, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-27 08:29:15'),
(63, '', '0974874595', 124, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-27 11:58:06'),
(64, '', '0987708777', 125, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-29 17:50:46'),
(65, '', '0965500155', 126, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-29 18:47:37'),
(66, '', '0969661456', 127, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-30 12:12:55'),
(67, '', '0977060808', 128, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-30 18:20:28'),
(68, '', '01656233686', 129, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-01 14:19:25'),
(69, '', '0982339379', 130, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-03 10:15:15'),
(70, '', '0967930009', 131, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 08:05:52'),
(71, '', '0977844844', 119, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2015-01-05 13:24:49'),
(72, '', '0988693030', 132, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 14:31:13'),
(73, '', '0975377778', 133, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 14:55:53'),
(74, '', '0964497777', 134, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-05 15:12:26'),
(75, '', '0965435965', 135, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 15:13:57'),
(76, '', '01632702222', 136, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-05 15:17:26'),
(77, '', '0985979777', 137, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 15:57:40'),
(78, '', '0969283366', 138, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 16:34:55'),
(79, '', '0982199188', 139, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 18:14:27'),
(80, '', '0983365465', 140, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 19:09:26'),
(81, '', '0965755111', 123, 8062, 'SBG', 'SBG MK', NULL, NULL, '2015-01-05 19:09:47'),
(82, '', '0986346346', 120, 8062, 'SBG', 'Sbg vip1', NULL, NULL, '2015-01-05 19:31:34'),
(83, '', '0986346346', 120, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2015-01-05 19:32:00'),
(84, '', '0984091234', 141, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 08:09:13'),
(85, '', '0947700586', 142, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-06 08:33:13'),
(86, '', '0966918548', 143, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 08:39:25'),
(87, '', '0966918548', 143, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 08:46:06'),
(88, '', '0989131226', 144, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 09:06:17'),
(89, '', '0977488285', 145, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 10:51:15'),
(90, '', '0984189770', 146, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 10:55:33'),
(91, '', '0989025522', 147, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 11:13:38'),
(92, '', '0983718066', 148, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 11:19:35'),
(93, '', '0989864199', 149, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 11:35:10'),
(94, '', '01676665666', 150, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 14:28:06'),
(95, '', '0964868968', 151, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 16:17:44'),
(96, '', '0986869454', 152, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-06 19:34:53'),
(97, '', '0977065588', 153, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 19:43:35'),
(98, '', '0966985805', 154, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 21:06:48'),
(99, '', '01666909959', 155, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 21:21:17'),
(100, '', '0988569377', 156, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 08:39:33'),
(101, '', '0976098097', 157, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-07 09:14:47'),
(102, '', '0977841103', 158, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 10:50:03'),
(103, '', '0974388668', 159, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 11:52:15'),
(104, '', '0989892792', 160, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 15:23:29'),
(105, '', '0973702165', 161, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-07 17:11:55'),
(106, '', '0974641010', 162, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-08 15:10:03'),
(107, '', '0985461010', 163, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-08 21:13:56'),
(108, '', '0989710858', 164, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-09 09:40:53'),
(109, '', '0977750010', 165, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-09 10:22:00'),
(110, '', '0968795757', 166, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-09 10:56:11'),
(111, '', '01699242832', 167, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-09 11:00:47'),
(112, '', '0989531234', 168, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-09 13:52:40'),
(113, '', '0969933399', 169, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-10 16:10:49'),
(114, '', '0987908828', 170, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-12 09:17:09'),
(115, '', '0983762762', 171, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-12 16:30:44'),
(116, '', '0969497497', 172, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-12 20:27:24'),
(117, '', '0974388668', 159, 8062, 'SBG', 'SBG VIP 12', NULL, NULL, '2015-01-13 11:22:00'),
(118, '', '0974388668', 159, 8062, 'SBG', 'SBG VIP 1', NULL, NULL, '2015-01-13 11:22:44'),
(119, '', '0974388668', 159, 8062, 'SBG', 'SBG MK', NULL, NULL, '2015-01-13 14:23:26'),
(120, '', '0974766688', 117, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2015-01-13 14:48:53'),
(121, '', '0982199188', 139, 8062, 'SBG', 'SBG NAP 15000', NULL, NULL, '2015-01-13 16:35:44'),
(122, '', '0982124899', 61, 8062, 'SBG', 'Sbg nap 500', NULL, NULL, '2015-01-14 11:15:38'),
(123, '', '01647579889', 173, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-14 12:45:29'),
(124, '', '0985686726', 174, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-14 12:48:01'),
(125, '', '0978999321', 175, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 09:58:15'),
(126, '', '0965500155', 126, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2015-01-15 12:06:08'),
(127, '', '01637147842', 176, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-15 14:30:14'),
(128, '', '0973425127', NULL, 8062, 'SBG', 'sbg mk', NULL, NULL, '2015-01-15 15:09:59'),
(129, '', '0973425127', 177, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-15 15:13:12'),
(130, '', '0973425127', 177, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-15 15:20:40'),
(131, '', '0984091234', 141, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 15:22:02'),
(132, '', '0988568786', 116, 8062, 'SBG', 'SBG DK 0988568786', NULL, NULL, '2015-01-13 00:00:00'),
(133, '', '0988568786', 116, 8062, 'SBG', 'SBG DK 0973425127', NULL, NULL, '2015-01-13 00:00:00'),
(134, '', '0977006622', 178, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 15:44:48'),
(135, '', '0977006622', 178, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 15:51:57'),
(136, '', '0976114933', 179, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 21:55:16'),
(137, '', '0986278224', 180, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-16 11:19:03'),
(138, '', '0965668669', 181, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-17 07:10:10'),
(139, '', '0984278829', 182, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-19 12:42:05');

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

--
-- Table structure for table `tblsmstemplate`
--

DROP TABLE IF EXISTS `tblsmstemplate`;
CREATE TABLE IF NOT EXISTS `tblsmstemplate` (
  `sms_id` int(11) NOT NULL AUTO_INCREMENT,
  `sms_content` varchar(255) NOT NULL,
  `sms_reply` varchar(255) DEFAULT NULL,
  `reponse_url` varchar(255) DEFAULT NULL,
  `service_id` varchar(45) DEFAULT NULL,
  `commandcode` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`sms_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tbluser`
--

DROP TABLE IF EXISTS `tbluser`;
CREATE TABLE IF NOT EXISTS `tbluser` (
  `us_id` int(11) NOT NULL,
  `cellphone` varchar(15) NOT NULL,
  `collaborator` int(11) DEFAULT NULL,
  `acc_balanced` bigint(20) NOT NULL DEFAULT '0',
  `expire_date` date DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `p_id` int(11) DEFAULT NULL,
  `created_time` datetime NOT NULL,
  `updated_time` datetime DEFAULT NULL,
  PRIMARY KEY (`us_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbluser`
--

INSERT INTO `tbluser` (`us_id`, `cellphone`, `collaborator`, `acc_balanced`, `expire_date`, `district`, `province`, `p_id`, `created_time`, `updated_time`) VALUES
(61, '0982124899', NULL, 26500, '2016-02-18', NULL, NULL, 1, '2014-11-14 21:15:17', '2015-01-14 17:23:49'),
(66, '01887521818', 982124899, 0, NULL, NULL, NULL, NULL, '2014-11-15 01:09:42', NULL),
(67, '0979947802', 982124899, 20000, '2015-02-19', NULL, '', 1, '2014-11-15 01:10:56', '2015-01-19 12:42:38'),
(69, '0943479095', NULL, 78500, '2015-02-15', NULL, NULL, 1, '2014-11-18 09:53:00', '2014-11-18 17:39:35'),
(70, '0985826266', NULL, 5000, '2016-11-16', NULL, NULL, 4, '2014-11-18 15:39:59', NULL),
(71, '0912268437', NULL, 4500, '2014-12-17', NULL, NULL, 1, '2014-11-18 16:02:23', NULL),
(80, '01234788777', NULL, 10400, NULL, NULL, NULL, NULL, '2014-11-20 10:36:34', '2014-11-26 17:58:30'),
(81, '0989562365', 988568786, 0, NULL, NULL, NULL, NULL, '2014-11-20 11:41:24', NULL),
(85, '01662860000', NULL, 1500000, NULL, NULL, NULL, NULL, '2014-11-20 17:26:07', '2014-11-20 17:52:03'),
(86, '01689925260', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-21 09:55:36', '2014-11-21 10:17:31'),
(87, '01649529632', NULL, 7503, '2015-11-21', NULL, NULL, 3, '2014-11-21 13:59:10', '2014-11-24 17:15:06'),
(89, '01688243590', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-21 16:45:26', NULL),
(91, '01685910879', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-21 17:01:53', NULL),
(99, '01682821813', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-25 10:04:03', NULL),
(100, '0979359749', NULL, 17001, '2015-12-25', NULL, NULL, 1, '2014-11-25 11:20:43', '2014-11-26 18:04:10'),
(101, '01692006723', NULL, 2100, '2016-10-25', NULL, NULL, 4, '2014-11-25 15:11:37', '2014-11-25 16:37:49'),
(102, '01632002905', NULL, 0, '2018-12-25', NULL, NULL, 2, '2014-11-25 16:44:46', '2014-11-25 16:57:56'),
(103, '0983460604', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-26 11:54:15', NULL),
(105, '01654040214', NULL, 10000, '2015-03-02', NULL, NULL, 1, '2014-12-02 10:48:06', '2014-12-04 16:28:36'),
(106, '01699328160', NULL, 0, NULL, NULL, NULL, NULL, '2014-12-05 23:05:34', NULL),
(116, '0988568786', NULL, 60000, '2014-12-18', 'Äá»‘ng Äa', 'HÃ  Ná»™i', 5, '2014-12-11 14:53:44', '2015-01-15 16:59:19'),
(117, '0974766688', NULL, 0, '2014-12-23', NULL, NULL, 5, '2014-12-16 16:49:38', NULL),
(118, '0987783898', NULL, 0, '2014-12-30', NULL, NULL, 5, '2014-12-23 09:49:45', NULL),
(119, '0977844844', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 15:57:20', '2015-01-05 13:25:54'),
(120, '0986346346', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 16:07:32', NULL),
(121, '0988911183', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 16:54:39', NULL),
(122, '0965004848', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 17:03:09', NULL),
(123, '0965755111', NULL, 0, '2015-01-03', NULL, NULL, 5, '2014-12-27 08:30:03', '2015-01-05 19:10:51'),
(124, '0974874595', NULL, 0, '2015-01-03', NULL, NULL, 5, '2014-12-27 11:58:55', NULL),
(125, '0987708777', NULL, 0, '2015-01-05', NULL, NULL, 5, '2014-12-29 17:51:37', NULL),
(126, '0965500155', NULL, 0, '2015-01-05', NULL, NULL, 5, '2014-12-29 18:48:31', '2015-01-16 07:51:53'),
(127, '0969661456', NULL, 0, '2015-01-06', NULL, NULL, 5, '2014-12-30 12:13:48', NULL),
(128, '0977060808', NULL, 0, '2015-01-06', NULL, NULL, 5, '2014-12-30 18:21:21', NULL),
(129, '01656233686', NULL, 0, '2015-01-08', NULL, NULL, 5, '2015-01-01 14:20:27', NULL),
(130, '0982339379', NULL, 0, '2015-01-10', NULL, NULL, 5, '2015-01-03 10:16:22', NULL),
(131, '0967930009', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 08:07:00', NULL),
(132, '0988693030', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 14:32:30', NULL),
(133, '0975377778', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 14:57:03', NULL),
(134, '0964497777', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:13:42', NULL),
(135, '0965435965', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:15:08', NULL),
(136, '01632702222', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:18:37', NULL),
(137, '0985979777', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:58:44', NULL),
(138, '0969283366', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 16:35:57', NULL),
(139, '0982199188', NULL, 15000, '2015-01-12', 'Ba ÄÃ¬nh', 'HÃ  Ná»™i', 5, '2015-01-05 18:15:31', '2015-01-13 16:37:20'),
(140, '0983365465', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 19:10:28', NULL),
(141, '0984091234', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 08:10:19', NULL),
(142, '0947700586', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 08:35:30', NULL),
(143, '0966918548', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 08:41:54', NULL),
(144, '0989131226', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 09:20:48', NULL),
(145, '0977488285', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 10:56:54', NULL),
(146, '0984189770', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 10:57:05', NULL),
(147, '0989025522', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 11:14:47', NULL),
(148, '0983718066', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 11:20:49', NULL),
(149, '0989864199', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 11:36:20', NULL),
(150, '01676665666', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 14:29:11', NULL),
(151, '0964868968', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 16:18:49', NULL),
(152, '0986869454', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 19:36:05', NULL),
(153, '0977065588', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 19:44:48', NULL),
(154, '0966985805', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 21:08:02', NULL),
(155, '01666909959', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 21:22:25', NULL),
(156, '0988569377', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 08:40:54', NULL),
(157, '0976098097', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 09:15:58', NULL),
(158, '0977841103', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 10:51:12', NULL),
(159, '0974388668', NULL, 0, '2015-01-14', 'ThÃ nh phá»‘ SÆ¡n La', 'SÆ¡n La', 5, '2015-01-07 11:53:27', '2015-01-13 16:01:38'),
(160, '0989892792', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 15:24:37', NULL),
(161, '0973702165', NULL, 0, '2015-01-14', 'Phá»§ LÃ½', 'HÃ  Nam', 5, '2015-01-07 17:13:02', '2015-01-13 17:36:04'),
(162, '0974641010', NULL, 0, '2015-01-15', NULL, NULL, 5, '2015-01-08 15:11:14', NULL),
(163, '0985461010', NULL, 0, '2015-01-15', NULL, NULL, 5, '2015-01-08 21:15:13', NULL),
(164, '0989710858', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 09:42:05', NULL),
(165, '0977750010', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 10:23:12', NULL),
(166, '0968795757', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 10:57:21', NULL),
(167, '01699242832', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 11:02:04', NULL),
(168, '0989531234', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 13:53:51', NULL),
(169, '0969933399', NULL, 0, '2015-01-17', NULL, NULL, 5, '2015-01-10 16:12:02', NULL),
(170, '0987908828', NULL, 0, '2015-01-19', NULL, NULL, 5, '2015-01-12 09:18:26', NULL),
(171, '0983762762', NULL, 0, '2015-01-19', NULL, '', 5, '2015-01-12 16:32:04', '2015-01-15 08:35:12'),
(172, '0969497497', NULL, 0, '2015-01-19', NULL, NULL, 5, '2015-01-12 20:28:42', NULL),
(173, '01647579889', NULL, 0, '2015-01-21', NULL, NULL, 5, '2015-01-14 12:46:52', NULL),
(174, '0985686726', NULL, 0, '2015-01-21', NULL, '', 5, '2015-01-14 12:49:27', '2015-01-14 12:54:59'),
(175, '0978999321', NULL, 0, '2015-01-22', NULL, '', 5, '2015-01-15 09:59:38', '2015-01-16 09:43:24'),
(176, '01637147842', NULL, 0, '2015-01-22', 'Vinh', 'Nghá»‡ An', 5, '2015-01-15 14:31:36', '2015-01-15 14:39:06'),
(177, '0973425127', NULL, 0, '2015-01-22', 'Má»™c CHÃ¢u', 'SÆ¡n La', 5, '2015-01-15 15:14:35', '2015-01-15 15:34:35'),
(178, '0977006622', NULL, 0, '2015-01-22', NULL, NULL, 5, '2015-01-15 15:46:09', NULL),
(179, '0976114933', NULL, 0, '2015-01-22', NULL, NULL, 5, '2015-01-15 21:56:40', '2015-01-15 21:59:32'),
(180, '0986278224', NULL, 0, '2015-01-23', 'Nam ÄÃ n', 'Nghá»‡ An', 5, '2015-01-16 11:20:26', '2015-01-16 11:24:09'),
(181, '0965668669', NULL, 0, '2015-01-24', NULL, '', 5, '2015-01-17 07:11:52', '2015-01-17 07:15:57'),
(182, '0984278829', NULL, 0, '2015-01-26', '', 'Bà Rịa - Vũng Tàu', 5, '2015-01-19 12:43:36', '2015-03-02 12:45:44');

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

--
-- Table structure for table `tblwebservice`
--

DROP TABLE IF EXISTS `tblwebservice`;
CREATE TABLE IF NOT EXISTS `tblwebservice` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(45) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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