/*
Navicat MySQL Data Transfer

Source Server         : SBG Online
Source Server Version : 50095
Source Host           : localhost:3306
Source Database       : sbg

Target Server Type    : MYSQL
Target Server Version : 50095
File Encoding         : 65001

Date: 2015-01-19 12:53:51
*/


-- ----------------------------
-- Table structure for `tbladminrole`
-- ----------------------------
CREATE TABLE `tbladminrole` (
  `role_id` int(11) NOT NULL auto_increment,
  `role_name` varchar(45) NOT NULL,
  PRIMARY KEY  (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbladminrole
-- ----------------------------

-- ----------------------------
-- Table structure for `tblcardlog`
-- ----------------------------
CREATE TABLE `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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblcardlog
-- ----------------------------
INSERT INTO `tblcardlog` VALUES ('1', '0988568786', '116', '-1', 'ferwer', 'ưersdfsdgf', '0', '2015-01-15 12:29:22');
INSERT INTO `tblcardlog` VALUES ('2', '0988568786', '116', '0', 'ưerwerwe', 'rưerwerwer', '0', '2015-01-15 12:30:13');
INSERT INTO `tblcardlog` VALUES ('3', '0988568786', '116', '1', '0924647603794', '92594534261', '10000', '2015-01-15 16:59:19');

-- ----------------------------
-- Table structure for `tblpaidlog`
-- ----------------------------
CREATE TABLE `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 AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

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

-- ----------------------------
-- Table structure for `tblregisterpackagelog`
-- ----------------------------
CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblregisterpackagelog
-- ----------------------------
INSERT INTO `tblregisterpackagelog` VALUES ('1', '0988568786', 'Web', '1', '2015-01-15 16:59:46');
INSERT INTO `tblregisterpackagelog` VALUES ('2', '0979947802', 'Web', '1', '2015-01-19 12:42:38');

-- ----------------------------
-- Table structure for `tblservicepackage`
-- ----------------------------
CREATE TABLE `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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblservicepackage
-- ----------------------------
INSERT INTO `tblservicepackage` VALUES ('1', 'VIP 1', '1', '15000', '1', 'months', '1GB', '0');
INSERT INTO `tblservicepackage` VALUES ('2', 'VIP 3', '3', '40000', '3', 'months', '1GB', '0');
INSERT INTO `tblservicepackage` VALUES ('3', 'VIP 6', '6', '70000', '6', 'months', '1GB', '0');
INSERT INTO `tblservicepackage` VALUES ('4', 'VIP 12', '12', '130000', '12', 'months', '1GB', '0');
INSERT INTO `tblservicepackage` VALUES ('5', 'Trial', '-1', '0', '-1', 'day', '1GB', '0');

-- ----------------------------
-- Table structure for `tblsmslog`
-- ----------------------------
CREATE TABLE `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 AUTO_INCREMENT=140 DEFAULT CHARSET=utf8;

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

-- ----------------------------
-- Table structure for `tblsmstemplate`
-- ----------------------------
CREATE TABLE `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;

-- ----------------------------
-- Records of tblsmstemplate
-- ----------------------------

-- ----------------------------
-- Table structure for `tbluser`
-- ----------------------------
CREATE TABLE `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;

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

-- ----------------------------
-- Table structure for `tblwebservice`
-- ----------------------------
CREATE TABLE `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;

-- ----------------------------
-- Records of tblwebservice
-- ----------------------------
