/* 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 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `tbladmin` -- ---------------------------- DROP TABLE IF EXISTS `tbladmin`; CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tbladmin -- ---------------------------- INSERT INTO `tbladmin` VALUES ('1', 'administrator', 'e10adc3949ba59abbe56e057f20f883e', 'Administrator', 'admin@sbg.vn', null, '2014-11-03 15:47:41', null, '1'); -- ---------------------------- -- Table structure for `tbladminrole` -- ---------------------------- DROP TABLE IF EXISTS `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` -- ---------------------------- DROP TABLE IF EXISTS `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 `tblcollaborator` -- ---------------------------- DROP TABLE IF EXISTS `tblcollaborator`; CREATE TABLE `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 AUTO_INCREMENT=20536706 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tblcollaborator -- ---------------------------- INSERT INTO `tblcollaborator` VALUES ('1', 'Truong Hoang Anh', '0982124899', '0982124899', '', '1', null, null, null, '', '', '', '', '', ''); INSERT INTO `tblcollaborator` VALUES ('2', 'Namta', '01689925260', '01689925260', 'c4ca4238a0b923820dcc509a6f75849b', '1', '2014-11-19 10:21:15', '2014-11-19 10:21:15', null, '', '', '', '', '', ''); INSERT INTO `tblcollaborator` VALUES ('5', 'dungnv', '0988568786', '0988568786', 'c4ca4238a0b923820dcc509a6f75849b', '1', '2014-11-19 18:45:27', '2014-11-19 18:45:27', null, '', '', '', '', '', ''); INSERT INTO `tblcollaborator` VALUES ('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 `tblpaidlog` -- ---------------------------- DROP TABLE IF EXISTS `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` -- ---------------------------- DROP TABLE IF EXISTS `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` -- ---------------------------- DROP TABLE IF EXISTS `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` -- ---------------------------- DROP TABLE IF EXISTS `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` -- ---------------------------- DROP TABLE IF EXISTS `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` -- ---------------------------- DROP TABLE IF EXISTS `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` -- ---------------------------- DROP TABLE IF EXISTS `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 -- ----------------------------