Index: pro-violet-viettel/docs/db/violet-viettel-2.3.2015.sql
===================================================================
--- pro-violet-viettel/docs/db/violet-viettel-2.3.2015.sql	(revision 772)
+++ pro-violet-viettel/docs/db/violet-viettel-2.3.2015.sql	(revision 772)
@@ -0,0 +1,584 @@
+-- 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 */;
