Changeset 776


Ignore:
Timestamp:
Mar 3, 2015 11:26:04 AM (10 years ago)
Author:
quyenla
Message:

db

File:
1 edited

Legend:

Unmodified
Added
Removed

  • pro-violet-viettel/docs/db/violet-viettel-2.3.2015.sql

    r772 r776  
    1 -- phpMyAdmin SQL Dump
    2 -- version 4.0.10deb1
    3 -- http://www.phpmyadmin.net
    4 --
    5 -- Host: localhost
    6 -- Generation Time: Mar 02, 2015 at 12:46 PM
    7 -- Server version: 5.5.38-0ubuntu0.14.04.1
    8 -- PHP Version: 5.5.9-1ubuntu4.4
    9 
    10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    11 SET time_zone = "+00:00";
    121
    132
    14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    17 /*!40101 SET NAMES utf8 */;
    18 
    193--
    20 -- Database: `violet-viettel`
    21 --
    22 CREATE DATABASE IF NOT EXISTS `violet-viettel` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
    23 USE `violet-viettel`;
    24 
    25 -- --------------------------------------------------------
    26 
    27 --
    28 -- Table structure for table `tbladmin`
    29 --
    30 
    31 DROP TABLE IF EXISTS `tbladmin`;
    32 CREATE TABLE IF NOT EXISTS `tbladmin` (
    33   `admin_id` int(11) NOT NULL AUTO_INCREMENT,
    34   `login_name` varchar(45) NOT NULL,
    35   `passwd` varchar(65) NOT NULL,
    36   `full_name` varchar(45) NOT NULL,
    37   `email` varchar(45) DEFAULT NULL,
    38   `phone` varchar(15) DEFAULT NULL,
    39   `created_time` datetime DEFAULT NULL,
    40   `updated_time` datetime DEFAULT NULL,
    41   `author` int(11) DEFAULT NULL,
    42   PRIMARY KEY (`admin_id`)
    43 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
    44 
    45 --
    46 -- Dumping data for table `tbladmin`
    47 --
    48 
    49 INSERT INTO `tbladmin` (`admin_id`, `login_name`, `passwd`, `full_name`, `email`, `phone`, `created_time`, `updated_time`, `author`) VALUES
    50 (1, 'administrator', 'e10adc3949ba59abbe56e057f20f883e', 'Administrator', 'admin@sbg.vn', NULL, '2014-11-03 15:47:41', NULL, 1);
    51 
    52 -- --------------------------------------------------------
    53 
    54 --
    55 -- Table structure for table `tbladminrole`
     4-- `tbladminrole` - admin roles relations
    565--
    576
    … …  
    7423
    7524--
    76 -- Table structure for table `tblcardlog`
    77 --
    78 
    79 DROP TABLE IF EXISTS `tblcardlog`;
    80 CREATE TABLE IF NOT EXISTS `tblcardlog` (
    81   `id` int(11) NOT NULL AUTO_INCREMENT,
    82   `sender` varchar(255) DEFAULT NULL,
    83   `us_id` int(11) DEFAULT NULL,
    84   `status` tinyint(4) DEFAULT '1' COMMENT '-1:fail;0:locked;1:success',
    85   `pin_code` varchar(45) DEFAULT NULL,
    86   `serial_num` varchar(45) DEFAULT NULL,
    87   `card_value` int(11) DEFAULT NULL,
    88   `created_time` datetime NOT NULL,
    89   PRIMARY KEY (`id`)
    90 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
    91 
    92 --
    93 -- Dumping data for table `tblcardlog`
    94 --
    95 
    96 INSERT INTO `tblcardlog` (`id`, `sender`, `us_id`, `status`, `pin_code`, `serial_num`, `card_value`, `created_time`) VALUES
    97 (1, '0988568786', 116, -1, 'ferwer', 'Æ°ersdfsdgf', 0, '2015-01-15 12:29:22'),
    98 (2, '0988568786', 116, 0, 'Æ°erwerwe', 'rÆ°erwerwer', 0, '2015-01-15 12:30:13'),
    99 (3, '0988568786', 116, 1, '0924647603794', '92594534261', 10000, '2015-01-15 16:59:19');
    100 
    101 -- --------------------------------------------------------
    102 
    103 --
    104 -- Table structure for table `tblcollaborator`
    105 --
    106 
    107 DROP TABLE IF EXISTS `tblcollaborator`;
    108 CREATE TABLE IF NOT EXISTS `tblcollaborator` (
    109   `id` int(11) NOT NULL AUTO_INCREMENT,
    110   `full_name` varchar(45) NOT NULL,
    111   `login_name` varchar(45) NOT NULL,
    112   `cellphone` varchar(15) NOT NULL,
    113   `passwd` varchar(65) NOT NULL,
    114   `activated` tinyint(4) NOT NULL DEFAULT '1',
    115   `created_time` datetime DEFAULT NULL,
    116   `updated_time` datetime DEFAULT NULL,
    117   `author` int(11) DEFAULT NULL,
    118   `address` varchar(255) NOT NULL,
    119   `code` varchar(255) NOT NULL,
    120   `district` varchar(255) NOT NULL,
    121   `email` varchar(255) NOT NULL,
    122   `precinct` varchar(255) NOT NULL,
    123   `province` varchar(255) NOT NULL,
    124   PRIMARY KEY (`id`)
    125 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20536706 ;
    126 
    127 --
    128 -- Dumping data for table `tblcollaborator`
    129 --
    130 
    131 INSERT INTO `tblcollaborator` (`id`, `full_name`, `login_name`, `cellphone`, `passwd`, `activated`, `created_time`, `updated_time`, `author`, `address`, `code`, `district`, `email`, `precinct`, `province`) VALUES
    132 (1, 'Truong Hoang Anh', '0982124899', '0982124899', '', 1, NULL, NULL, NULL, '', '', '', '', '', ''),
    133 (2, 'Namta', '01689925260', '01689925260', 'c4ca4238a0b923820dcc509a6f75849b', 1, '2014-11-19 10:21:15', '2014-11-19 10:21:15', NULL, '', '', '', '', '', ''),
    134 (5, 'dungnv', '0988568786', '0988568786', 'c4ca4238a0b923820dcc509a6f75849b', 1, '2014-11-19 18:45:27', '2014-11-19 18:45:27', NULL, '', '', '', '', '', ''),
    135 (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');
    136 
    137 -- --------------------------------------------------------
    138 
    139 --
    140 -- Table structure for table `tblpaidlog`
    141 --
    142 
    143 DROP TABLE IF EXISTS `tblpaidlog`;
    144 CREATE TABLE IF NOT EXISTS `tblpaidlog` (
    145   `paid_id` bigint(11) NOT NULL AUTO_INCREMENT,
    146   `us_id` int(11) NOT NULL,
    147   `paid_type` tinyint(11) NOT NULL DEFAULT '0' COMMENT '1:SMS; 2:CARD;',
    148   `amount` int(11) NOT NULL DEFAULT '0',
    149   `source` varchar(65) NOT NULL,
    150   `paid_time` datetime DEFAULT NULL,
    151   PRIMARY KEY (`paid_id`)
    152 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
    153 
    154 --
    155 -- Dumping data for table `tblpaidlog`
    156 --
    157 
    158 INSERT INTO `tblpaidlog` (`paid_id`, `us_id`, `paid_type`, `amount`, `source`, `paid_time`) VALUES
    159 (1, 100, 2, 10000, 'Thẻ cào', '2014-11-25 15:16:59'),
    160 (2, 101, 1, 1000, '01692006723', '2014-11-25 16:05:40'),
    161 (3, 101, 1, 1000, '01692006723', '2014-11-25 16:08:43'),
    162 (4, 101, 1, 2000, '01692006723', '2014-11-25 16:12:42'),
    163 (5, 101, 1, 2500, '01692006723', '2014-11-25 16:33:26'),
    164 (6, 101, 1, 100, '01692006723', '2014-11-25 16:36:38'),
    165 (7, 101, 1, 2000, '01692006723', '2014-11-25 16:37:49'),
    166 (8, 102, 1, 6000, '01632002905', '2014-11-25 16:55:44'),
    167 (9, 102, 1, 6000, '01632002905', '2014-11-25 16:57:56'),
    168 (10, 80, 2, 10000, 'Thẻ cào', '2014-11-26 17:58:30'),
    169 (11, 100, 2, 10000, 'Thẻ cào', '2014-11-26 18:00:23'),
    170 (12, 100, 1, 1, '0979359749', '2014-11-26 18:04:10'),
    171 (13, 105, 1, 15000, '01692006723', '2014-12-02 11:08:44'),
    172 (14, 105, 2, 20000, 'Thẻ cào', '2014-12-02 14:27:00'),
    173 (15, 105, 2, 20000, 'Thẻ cào', '2014-12-04 16:28:36'),
    174 (16, 139, 1, 15000, '0982199188', '2015-01-13 16:37:20'),
    175 (17, 61, 1, 500, '0982124899', '2015-01-14 11:21:00'),
    176 (18, 116, 2, 10000, 'Thẻ cào', '2015-01-14 17:21:11'),
    177 (19, 61, 2, 10000, 'Thẻ cào', '2015-01-14 17:23:49'),
    178 (20, 116, 2, 10000, 'Thẻ cào', '2015-01-15 07:51:43'),
    179 (21, 116, 2, 10000, 'Thẻ cào', '2015-01-15 16:59:21');
    180 
    181 -- --------------------------------------------------------
    182 
    183 --
    184 -- Table structure for table `tblproduct`
    185 --
    186 
    187 DROP TABLE IF EXISTS `tblproduct`;
    188 CREATE TABLE IF NOT EXISTS `tblproduct` (
    189   `product_id` int(11) NOT NULL DEFAULT '0',
    190   `product_name` varchar(255) DEFAULT NULL,
    191   `description` varchar(255) DEFAULT NULL,
    192   PRIMARY KEY (`product_id`)
    193 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    194 
    195 -- --------------------------------------------------------
    196 
    197 --
    198 -- Table structure for table `tblregisterpackagelog`
    199 --
    200 
    201 DROP TABLE IF EXISTS `tblregisterpackagelog`;
    202 CREATE TABLE IF NOT EXISTS `tblregisterpackagelog` (
    203   `id` int(11) NOT NULL AUTO_INCREMENT,
    204   `username` varchar(15) NOT NULL,
    205   `source` varchar(65) NOT NULL,
    206   `p_code` varchar(65) NOT NULL,
    207   `created_time` datetime NOT NULL,
    208   PRIMARY KEY (`id`)
    209 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
    210 
    211 --
    212 -- Dumping data for table `tblregisterpackagelog`
    213 --
    214 
    215 INSERT INTO `tblregisterpackagelog` (`id`, `username`, `source`, `p_code`, `created_time`) VALUES
    216 (1, '0988568786', 'Web', '1', '2015-01-15 16:59:46'),
    217 (2, '0979947802', 'Web', '1', '2015-01-19 12:42:38');
    218 
    219 -- --------------------------------------------------------
    220 
    221 --
    222 -- Table structure for table `tblrole`
     25--  `tblrole` - roles table
    22326--
    22427
    … …  
    23639INSERT INTO `tblrole` (`role_id`, `role_name`) VALUES
    23740(1, 'editUserInfo'),
    238 (2, 'editAdminInfor');
     41(2, 'editAdminInfo');
    23942
    24043-- --------------------------------------------------------
    241 
    242 --
    243 -- Table structure for table `tblservicepackage`
    244 --
    245 
    246 DROP TABLE IF EXISTS `tblservicepackage`;
    247 CREATE TABLE IF NOT EXISTS `tblservicepackage` (
    248   `p_id` int(11) NOT NULL AUTO_INCREMENT,
    249   `p_name` varchar(50) NOT NULL,
    250   `p_period` int(11) NOT NULL,
    251   `p_price` int(11) NOT NULL,
    252   `p_code` varchar(15) DEFAULT NULL,
    253   `p_unit` varchar(15) DEFAULT NULL,
    254   `p_dfspace` varchar(15) DEFAULT '1GB',
    255   `p_isextra` tinyint(4) DEFAULT '0',
    256   PRIMARY KEY (`p_id`)
    257 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
    258 
    259 --
    260 -- Dumping data for table `tblservicepackage`
    261 --
    262 
    263 INSERT INTO `tblservicepackage` (`p_id`, `p_name`, `p_period`, `p_price`, `p_code`, `p_unit`, `p_dfspace`, `p_isextra`) VALUES
    264 (1, 'VIP 1', 1, 15000, '1', 'months', '1GB', 0),
    265 (2, 'VIP 3', 3, 40000, '3', 'months', '1GB', 0),
    266 (3, 'VIP 6', 6, 70000, '6', 'months', '1GB', 0),
    267 (4, 'VIP 12', 12, 130000, '12', 'months', '1GB', 0),
    268 (5, 'Trial', -1, 0, '-1', 'day', '1GB', 0);
    269 
    270 -- --------------------------------------------------------
    271 
    272 --
    273 -- Table structure for table `tblsmslog`
    274 --
    275 
    276 DROP TABLE IF EXISTS `tblsmslog`;
    277 CREATE TABLE IF NOT EXISTS `tblsmslog` (
    278   `id` int(11) NOT NULL AUTO_INCREMENT,
    279   `request_id` varchar(255) DEFAULT '',
    280   `sender` varchar(255) DEFAULT NULL,
    281   `us_id` int(11) DEFAULT NULL,
    282   `service_id` int(11) DEFAULT NULL,
    283   `commandcode` varchar(255) DEFAULT NULL,
    284   `info` varchar(255) DEFAULT NULL,
    285   `mobody` varchar(255) DEFAULT NULL,
    286   `mtbody` varchar(255) DEFAULT NULL,
    287   `created_time` datetime DEFAULT NULL,
    288   PRIMARY KEY (`id`)
    289 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=140 ;
    290 
    291 --
    292 -- Dumping data for table `tblsmslog`
    293 --
    294 
    295 INSERT INTO `tblsmslog` (`id`, `request_id`, `sender`, `us_id`, `service_id`, `commandcode`, `info`, `mobody`, `mtbody`, `created_time`) VALUES
    296 (1, '', '0979359749', NULL, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-25 10:59:14'),
    297 (2, '', '0979359749', 100, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-25 11:08:41'),
    298 (3, '', '0988568786', 68, 8062, 'SBG', 'Sbg nap aaa', NULL, NULL, '2014-11-25 12:30:29'),
    299 (4, '', '0979359749', 100, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-25 13:27:56'),
    300 (5, '', '01692006723', 101, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-25 14:59:35'),
    301 (6, '', '01692006723', 101, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-25 15:50:49'),
    302 (7, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 1000', NULL, NULL, '2014-11-25 15:53:35'),
    303 (8, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 1000', NULL, NULL, '2014-11-25 15:56:43'),
    304 (9, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 2000', NULL, NULL, '2014-11-25 16:00:41'),
    305 (10, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 2500', NULL, NULL, '2014-11-25 16:21:25'),
    306 (11, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 100', NULL, NULL, '2014-11-25 16:24:32'),
    307 (12, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 2000', NULL, NULL, '2014-11-25 16:25:48'),
    308 (13, '', '01632002905', 102, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-25 16:32:44'),
    309 (14, '', '01632002905', 102, 8062, 'SBG', 'Sbg nap 6000', NULL, NULL, '2014-11-25 16:43:42'),
    310 (15, '', '01632002905', 102, 8062, 'SBG', 'Sbg nap 6000', NULL, NULL, '2014-11-25 16:40:36'),
    311 (16, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 10:02:48'),
    312 (17, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:07:56'),
    313 (18, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:07:56'),
    314 (19, '', '0988568786', 68, 8062, 'SBG', 'Sbg mk 123456', NULL, NULL, '2014-11-26 11:12:00'),
    315 (20, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:13:00'),
    316 (21, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:13:00'),
    317 (22, '', '0983460604', 103, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-26 11:42:14'),
    318 (23, '', '0983460604', 103, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-26 11:42:14'),
    319 (24, '', '0982124899', 61, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-26 11:43:48'),
    320 (25, '', '01682821813', 99, 8062, 'SBG', 'SBG dk', NULL, NULL, '2014-11-18 09:52:35'),
    321 (26, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
    322 (27, '', '0979359749', 100, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2014-11-26 17:51:29'),
    323 (28, '', '0979359749', 100, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2014-11-26 17:51:56'),
    324 (29, '', '0979359749', 100, 8062, 'SBG', 'Sbg nap 001', NULL, NULL, '2014-11-26 17:52:03'),
    325 (30, '', '0979947802', 67, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-27 01:13:24'),
    326 (31, '', '0979947802', 67, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-27 01:13:24'),
    327 (32, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
    328 (33, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
    329 (34, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-11-29 17:59:52'),
    330 (35, '', '01654040214', NULL, 8062, 'SBG', 'Sbg dk 01692006723', NULL, NULL, '2014-12-02 10:04:13'),
    331 (36, '', '01654040214', 105, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-02 10:35:49'),
    332 (37, '', '01682821813', 99, 8062, 'SBG', 'SBG nhj', NULL, NULL, '2014-11-18 09:52:35'),
    333 (38, '', '01682821813', 99, 8062, 'SBG', 'SBG dk', NULL, NULL, '2014-11-18 09:52:35'),
    334 (39, '', '0988568786', 68, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-02 10:48:26'),
    335 (40, '', '01692006723', 101, 8062, 'SBG', 'Sbg nap 15000 01654040214', NULL, NULL, '2014-12-02 10:56:16'),
    336 (41, '', '0978898670', NULL, 8062, 'SBG', 'SBG HD', NULL, NULL, '2014-12-05 16:36:54'),
    337 (42, '', '01699328160', 106, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-05 23:05:05'),
    338 (43, '', '0978898670', NULL, 8062, 'SBG', 'sbg', NULL, NULL, '2014-12-08 16:14:16'),
    339 (44, '', '0985585868', NULL, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-18 09:52:35'),
    340 (45, '', '0988568786', NULL, 8062, 'SBG', 'SBG MK', NULL, NULL, '2014-11-18 09:52:35'),
    341 (46, '', '0988568786', NULL, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
    342 (47, '', '0988568786', 112, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
    343 (48, '', '0988568786', 113, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
    344 (49, '', '0988568786', 114, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
    345 (50, '', '0985585868', NULL, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2014-12-10 17:00:42'),
    346 (51, '', '0988568786', NULL, 8062, 'SBG', 'DK SBG', NULL, NULL, '2014-11-18 09:52:35'),
    347 (52, '', '0988568786', NULL, 8062, 'SBG', 'DK SBG', NULL, NULL, '2014-11-18 09:52:35'),
    348 (53, '', '0988568786', 115, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
    349 (54, '', '0988568786', 115, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
    350 (55, '', '0988568786', 116, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-11-18 09:52:35'),
    351 (56, '', '0974766688', 117, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-16 16:49:11'),
    352 (57, '', '0987783898', 118, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-23 09:49:06'),
    353 (58, '', '0977844844', 119, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-26 15:55:05'),
    354 (59, '', '0986346346', 120, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-26 16:06:45'),
    355 (60, '', '0988911183', 121, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-26 16:53:54'),
    356 (61, '', '0965004848', 122, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-26 17:02:25'),
    357 (62, '', '0965755111', 123, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-27 08:29:15'),
    358 (63, '', '0974874595', 124, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-27 11:58:06'),
    359 (64, '', '0987708777', 125, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2014-12-29 17:50:46'),
    360 (65, '', '0965500155', 126, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-29 18:47:37'),
    361 (66, '', '0969661456', 127, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-30 12:12:55'),
    362 (67, '', '0977060808', 128, 8062, 'SBG', 'SBG DK', NULL, NULL, '2014-12-30 18:20:28'),
    363 (68, '', '01656233686', 129, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-01 14:19:25'),
    364 (69, '', '0982339379', 130, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-03 10:15:15'),
    365 (70, '', '0967930009', 131, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 08:05:52'),
    366 (71, '', '0977844844', 119, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2015-01-05 13:24:49'),
    367 (72, '', '0988693030', 132, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 14:31:13'),
    368 (73, '', '0975377778', 133, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 14:55:53'),
    369 (74, '', '0964497777', 134, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-05 15:12:26'),
    370 (75, '', '0965435965', 135, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 15:13:57'),
    371 (76, '', '01632702222', 136, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-05 15:17:26'),
    372 (77, '', '0985979777', 137, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 15:57:40'),
    373 (78, '', '0969283366', 138, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 16:34:55'),
    374 (79, '', '0982199188', 139, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 18:14:27'),
    375 (80, '', '0983365465', 140, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-05 19:09:26'),
    376 (81, '', '0965755111', 123, 8062, 'SBG', 'SBG MK', NULL, NULL, '2015-01-05 19:09:47'),
    377 (82, '', '0986346346', 120, 8062, 'SBG', 'Sbg vip1', NULL, NULL, '2015-01-05 19:31:34'),
    378 (83, '', '0986346346', 120, 8062, 'SBG', 'Sbg vip 1', NULL, NULL, '2015-01-05 19:32:00'),
    379 (84, '', '0984091234', 141, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 08:09:13'),
    380 (85, '', '0947700586', 142, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-06 08:33:13'),
    381 (86, '', '0966918548', 143, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 08:39:25'),
    382 (87, '', '0966918548', 143, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 08:46:06'),
    383 (88, '', '0989131226', 144, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 09:06:17'),
    384 (89, '', '0977488285', 145, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 10:51:15'),
    385 (90, '', '0984189770', 146, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 10:55:33'),
    386 (91, '', '0989025522', 147, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 11:13:38'),
    387 (92, '', '0983718066', 148, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 11:19:35'),
    388 (93, '', '0989864199', 149, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 11:35:10'),
    389 (94, '', '01676665666', 150, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 14:28:06'),
    390 (95, '', '0964868968', 151, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 16:17:44'),
    391 (96, '', '0986869454', 152, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-06 19:34:53'),
    392 (97, '', '0977065588', 153, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-06 19:43:35'),
    393 (98, '', '0966985805', 154, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 21:06:48'),
    394 (99, '', '01666909959', 155, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-06 21:21:17'),
    395 (100, '', '0988569377', 156, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 08:39:33'),
    396 (101, '', '0976098097', 157, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-07 09:14:47'),
    397 (102, '', '0977841103', 158, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 10:50:03'),
    398 (103, '', '0974388668', 159, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 11:52:15'),
    399 (104, '', '0989892792', 160, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-07 15:23:29'),
    400 (105, '', '0973702165', 161, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-07 17:11:55'),
    401 (106, '', '0974641010', 162, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-08 15:10:03'),
    402 (107, '', '0985461010', 163, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-08 21:13:56'),
    403 (108, '', '0989710858', 164, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-09 09:40:53'),
    404 (109, '', '0977750010', 165, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-09 10:22:00'),
    405 (110, '', '0968795757', 166, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-09 10:56:11'),
    406 (111, '', '01699242832', 167, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-09 11:00:47'),
    407 (112, '', '0989531234', 168, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-09 13:52:40'),
    408 (113, '', '0969933399', 169, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-10 16:10:49'),
    409 (114, '', '0987908828', 170, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-12 09:17:09'),
    410 (115, '', '0983762762', 171, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-12 16:30:44'),
    411 (116, '', '0969497497', 172, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-12 20:27:24'),
    412 (117, '', '0974388668', 159, 8062, 'SBG', 'SBG VIP 12', NULL, NULL, '2015-01-13 11:22:00'),
    413 (118, '', '0974388668', 159, 8062, 'SBG', 'SBG VIP 1', NULL, NULL, '2015-01-13 11:22:44'),
    414 (119, '', '0974388668', 159, 8062, 'SBG', 'SBG MK', NULL, NULL, '2015-01-13 14:23:26'),
    415 (120, '', '0974766688', 117, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2015-01-13 14:48:53'),
    416 (121, '', '0982199188', 139, 8062, 'SBG', 'SBG NAP 15000', NULL, NULL, '2015-01-13 16:35:44'),
    417 (122, '', '0982124899', 61, 8062, 'SBG', 'Sbg nap 500', NULL, NULL, '2015-01-14 11:15:38'),
    418 (123, '', '01647579889', 173, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-14 12:45:29'),
    419 (124, '', '0985686726', 174, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-14 12:48:01'),
    420 (125, '', '0978999321', 175, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 09:58:15'),
    421 (126, '', '0965500155', 126, 8062, 'SBG', 'Sbg mk', NULL, NULL, '2015-01-15 12:06:08'),
    422 (127, '', '01637147842', 176, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-15 14:30:14'),
    423 (128, '', '0973425127', NULL, 8062, 'SBG', 'sbg mk', NULL, NULL, '2015-01-15 15:09:59'),
    424 (129, '', '0973425127', 177, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-15 15:13:12'),
    425 (130, '', '0973425127', 177, 8062, 'SBG', 'sbg dk', NULL, NULL, '2015-01-15 15:20:40'),
    426 (131, '', '0984091234', 141, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 15:22:02'),
    427 (132, '', '0988568786', 116, 8062, 'SBG', 'SBG DK 0988568786', NULL, NULL, '2015-01-13 00:00:00'),
    428 (133, '', '0988568786', 116, 8062, 'SBG', 'SBG DK 0973425127', NULL, NULL, '2015-01-13 00:00:00'),
    429 (134, '', '0977006622', 178, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 15:44:48'),
    430 (135, '', '0977006622', 178, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 15:51:57'),
    431 (136, '', '0976114933', 179, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-15 21:55:16'),
    432 (137, '', '0986278224', 180, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-16 11:19:03'),
    433 (138, '', '0965668669', 181, 8062, 'SBG', 'Sbg dk', NULL, NULL, '2015-01-17 07:10:10'),
    434 (139, '', '0984278829', 182, 8062, 'SBG', 'SBG DK', NULL, NULL, '2015-01-19 12:42:05');
    435 
    436 -- --------------------------------------------------------
    437 
    438 --
    439 -- Table structure for table `tblsmstemplate`
    440 --
    441 
    442 DROP TABLE IF EXISTS `tblsmstemplate`;
    443 CREATE TABLE IF NOT EXISTS `tblsmstemplate` (
    444   `sms_id` int(11) NOT NULL AUTO_INCREMENT,
    445   `sms_content` varchar(255) NOT NULL,
    446   `sms_reply` varchar(255) DEFAULT NULL,
    447   `reponse_url` varchar(255) DEFAULT NULL,
    448   `service_id` varchar(45) DEFAULT NULL,
    449   `commandcode` varchar(45) DEFAULT NULL,
    450   PRIMARY KEY (`sms_id`)
    451 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    452 
    453 -- --------------------------------------------------------
    454 
    455 --
    456 -- Table structure for table `tbluser`
    457 --
    458 
    459 DROP TABLE IF EXISTS `tbluser`;
    460 CREATE TABLE IF NOT EXISTS `tbluser` (
    461   `us_id` int(11) NOT NULL,
    462   `cellphone` varchar(15) NOT NULL,
    463   `collaborator` int(11) DEFAULT NULL,
    464   `acc_balanced` bigint(20) NOT NULL DEFAULT '0',
    465   `expire_date` date DEFAULT NULL,
    466   `district` varchar(255) DEFAULT NULL,
    467   `province` varchar(255) DEFAULT NULL,
    468   `p_id` int(11) DEFAULT NULL,
    469   `created_time` datetime NOT NULL,
    470   `updated_time` datetime DEFAULT NULL,
    471   PRIMARY KEY (`us_id`)
    472 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    473 
    474 --
    475 -- Dumping data for table `tbluser`
    476 --
    477 
    478 INSERT INTO `tbluser` (`us_id`, `cellphone`, `collaborator`, `acc_balanced`, `expire_date`, `district`, `province`, `p_id`, `created_time`, `updated_time`) VALUES
    479 (61, '0982124899', NULL, 26500, '2016-02-18', NULL, NULL, 1, '2014-11-14 21:15:17', '2015-01-14 17:23:49'),
    480 (66, '01887521818', 982124899, 0, NULL, NULL, NULL, NULL, '2014-11-15 01:09:42', NULL),
    481 (67, '0979947802', 982124899, 20000, '2015-02-19', NULL, '', 1, '2014-11-15 01:10:56', '2015-01-19 12:42:38'),
    482 (69, '0943479095', NULL, 78500, '2015-02-15', NULL, NULL, 1, '2014-11-18 09:53:00', '2014-11-18 17:39:35'),
    483 (70, '0985826266', NULL, 5000, '2016-11-16', NULL, NULL, 4, '2014-11-18 15:39:59', NULL),
    484 (71, '0912268437', NULL, 4500, '2014-12-17', NULL, NULL, 1, '2014-11-18 16:02:23', NULL),
    485 (80, '01234788777', NULL, 10400, NULL, NULL, NULL, NULL, '2014-11-20 10:36:34', '2014-11-26 17:58:30'),
    486 (81, '0989562365', 988568786, 0, NULL, NULL, NULL, NULL, '2014-11-20 11:41:24', NULL),
    487 (85, '01662860000', NULL, 1500000, NULL, NULL, NULL, NULL, '2014-11-20 17:26:07', '2014-11-20 17:52:03'),
    488 (86, '01689925260', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-21 09:55:36', '2014-11-21 10:17:31'),
    489 (87, '01649529632', NULL, 7503, '2015-11-21', NULL, NULL, 3, '2014-11-21 13:59:10', '2014-11-24 17:15:06'),
    490 (89, '01688243590', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-21 16:45:26', NULL),
    491 (91, '01685910879', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-21 17:01:53', NULL),
    492 (99, '01682821813', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-25 10:04:03', NULL),
    493 (100, '0979359749', NULL, 17001, '2015-12-25', NULL, NULL, 1, '2014-11-25 11:20:43', '2014-11-26 18:04:10'),
    494 (101, '01692006723', NULL, 2100, '2016-10-25', NULL, NULL, 4, '2014-11-25 15:11:37', '2014-11-25 16:37:49'),
    495 (102, '01632002905', NULL, 0, '2018-12-25', NULL, NULL, 2, '2014-11-25 16:44:46', '2014-11-25 16:57:56'),
    496 (103, '0983460604', NULL, 0, NULL, NULL, NULL, NULL, '2014-11-26 11:54:15', NULL),
    497 (105, '01654040214', NULL, 10000, '2015-03-02', NULL, NULL, 1, '2014-12-02 10:48:06', '2014-12-04 16:28:36'),
    498 (106, '01699328160', NULL, 0, NULL, NULL, NULL, NULL, '2014-12-05 23:05:34', NULL),
    499 (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'),
    500 (117, '0974766688', NULL, 0, '2014-12-23', NULL, NULL, 5, '2014-12-16 16:49:38', NULL),
    501 (118, '0987783898', NULL, 0, '2014-12-30', NULL, NULL, 5, '2014-12-23 09:49:45', NULL),
    502 (119, '0977844844', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 15:57:20', '2015-01-05 13:25:54'),
    503 (120, '0986346346', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 16:07:32', NULL),
    504 (121, '0988911183', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 16:54:39', NULL),
    505 (122, '0965004848', NULL, 0, '2015-01-02', NULL, NULL, 5, '2014-12-26 17:03:09', NULL),
    506 (123, '0965755111', NULL, 0, '2015-01-03', NULL, NULL, 5, '2014-12-27 08:30:03', '2015-01-05 19:10:51'),
    507 (124, '0974874595', NULL, 0, '2015-01-03', NULL, NULL, 5, '2014-12-27 11:58:55', NULL),
    508 (125, '0987708777', NULL, 0, '2015-01-05', NULL, NULL, 5, '2014-12-29 17:51:37', NULL),
    509 (126, '0965500155', NULL, 0, '2015-01-05', NULL, NULL, 5, '2014-12-29 18:48:31', '2015-01-16 07:51:53'),
    510 (127, '0969661456', NULL, 0, '2015-01-06', NULL, NULL, 5, '2014-12-30 12:13:48', NULL),
    511 (128, '0977060808', NULL, 0, '2015-01-06', NULL, NULL, 5, '2014-12-30 18:21:21', NULL),
    512 (129, '01656233686', NULL, 0, '2015-01-08', NULL, NULL, 5, '2015-01-01 14:20:27', NULL),
    513 (130, '0982339379', NULL, 0, '2015-01-10', NULL, NULL, 5, '2015-01-03 10:16:22', NULL),
    514 (131, '0967930009', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 08:07:00', NULL),
    515 (132, '0988693030', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 14:32:30', NULL),
    516 (133, '0975377778', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 14:57:03', NULL),
    517 (134, '0964497777', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:13:42', NULL),
    518 (135, '0965435965', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:15:08', NULL),
    519 (136, '01632702222', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:18:37', NULL),
    520 (137, '0985979777', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 15:58:44', NULL),
    521 (138, '0969283366', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 16:35:57', NULL),
    522 (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'),
    523 (140, '0983365465', NULL, 0, '2015-01-12', NULL, NULL, 5, '2015-01-05 19:10:28', NULL),
    524 (141, '0984091234', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 08:10:19', NULL),
    525 (142, '0947700586', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 08:35:30', NULL),
    526 (143, '0966918548', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 08:41:54', NULL),
    527 (144, '0989131226', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 09:20:48', NULL),
    528 (145, '0977488285', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 10:56:54', NULL),
    529 (146, '0984189770', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 10:57:05', NULL),
    530 (147, '0989025522', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 11:14:47', NULL),
    531 (148, '0983718066', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 11:20:49', NULL),
    532 (149, '0989864199', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 11:36:20', NULL),
    533 (150, '01676665666', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 14:29:11', NULL),
    534 (151, '0964868968', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 16:18:49', NULL),
    535 (152, '0986869454', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 19:36:05', NULL),
    536 (153, '0977065588', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 19:44:48', NULL),
    537 (154, '0966985805', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 21:08:02', NULL),
    538 (155, '01666909959', NULL, 0, '2015-01-13', NULL, NULL, 5, '2015-01-06 21:22:25', NULL),
    539 (156, '0988569377', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 08:40:54', NULL),
    540 (157, '0976098097', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 09:15:58', NULL),
    541 (158, '0977841103', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 10:51:12', NULL),
    542 (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'),
    543 (160, '0989892792', NULL, 0, '2015-01-14', NULL, NULL, 5, '2015-01-07 15:24:37', NULL),
    544 (161, '0973702165', NULL, 0, '2015-01-14', 'Phủ LÜ', 'Hà Nam', 5, '2015-01-07 17:13:02', '2015-01-13 17:36:04'),
    545 (162, '0974641010', NULL, 0, '2015-01-15', NULL, NULL, 5, '2015-01-08 15:11:14', NULL),
    546 (163, '0985461010', NULL, 0, '2015-01-15', NULL, NULL, 5, '2015-01-08 21:15:13', NULL),
    547 (164, '0989710858', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 09:42:05', NULL),
    548 (165, '0977750010', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 10:23:12', NULL),
    549 (166, '0968795757', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 10:57:21', NULL),
    550 (167, '01699242832', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 11:02:04', NULL),
    551 (168, '0989531234', NULL, 0, '2015-01-16', NULL, NULL, 5, '2015-01-09 13:53:51', NULL),
    552 (169, '0969933399', NULL, 0, '2015-01-17', NULL, NULL, 5, '2015-01-10 16:12:02', NULL),
    553 (170, '0987908828', NULL, 0, '2015-01-19', NULL, NULL, 5, '2015-01-12 09:18:26', NULL),
    554 (171, '0983762762', NULL, 0, '2015-01-19', NULL, '', 5, '2015-01-12 16:32:04', '2015-01-15 08:35:12'),
    555 (172, '0969497497', NULL, 0, '2015-01-19', NULL, NULL, 5, '2015-01-12 20:28:42', NULL),
    556 (173, '01647579889', NULL, 0, '2015-01-21', NULL, NULL, 5, '2015-01-14 12:46:52', NULL),
    557 (174, '0985686726', NULL, 0, '2015-01-21', NULL, '', 5, '2015-01-14 12:49:27', '2015-01-14 12:54:59'),
    558 (175, '0978999321', NULL, 0, '2015-01-22', NULL, '', 5, '2015-01-15 09:59:38', '2015-01-16 09:43:24'),
    559 (176, '01637147842', NULL, 0, '2015-01-22', 'Vinh', 'Nghệ An', 5, '2015-01-15 14:31:36', '2015-01-15 14:39:06'),
    560 (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'),
    561 (178, '0977006622', NULL, 0, '2015-01-22', NULL, NULL, 5, '2015-01-15 15:46:09', NULL),
    562 (179, '0976114933', NULL, 0, '2015-01-22', NULL, NULL, 5, '2015-01-15 21:56:40', '2015-01-15 21:59:32'),
    563 (180, '0986278224', NULL, 0, '2015-01-23', 'Nam Đàn', 'Nghệ An', 5, '2015-01-16 11:20:26', '2015-01-16 11:24:09'),
    564 (181, '0965668669', NULL, 0, '2015-01-24', NULL, '', 5, '2015-01-17 07:11:52', '2015-01-17 07:15:57'),
    565 (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');
    566 
    567 -- --------------------------------------------------------
    568 
    569 --
    570 -- Table structure for table `tblwebservice`
    571 --
    572 
    573 DROP TABLE IF EXISTS `tblwebservice`;
    574 CREATE TABLE IF NOT EXISTS `tblwebservice` (
    575   `service_id` int(11) NOT NULL AUTO_INCREMENT,
    576   `service_name` varchar(45) NOT NULL,
    577   `address` varchar(255) DEFAULT NULL,
    578   `uri` varchar(255) DEFAULT NULL,
    579   PRIMARY KEY (`service_id`)
    580 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    581 
    582 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    583 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    584 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Note: See TracChangeset for help on using the changeset viewer.