| 1 | /*
|
|---|
| 2 | Navicat MySQL Data Transfer
|
|---|
| 3 |
|
|---|
| 4 | Source Server : SBG Online
|
|---|
| 5 | Source Server Version : 50095
|
|---|
| 6 | Source Host : localhost:3306
|
|---|
| 7 | Source Database : sbg
|
|---|
| 8 |
|
|---|
| 9 | Target Server Type : MYSQL
|
|---|
| 10 | Target Server Version : 50095
|
|---|
| 11 | File Encoding : 65001
|
|---|
| 12 |
|
|---|
| 13 | Date: 2015-01-19 12:53:51
|
|---|
| 14 | */
|
|---|
| 15 |
|
|---|
| 16 | SET FOREIGN_KEY_CHECKS=0;
|
|---|
| 17 | -- ----------------------------
|
|---|
| 18 | -- Table structure for `tbladmin`
|
|---|
| 19 | -- ----------------------------
|
|---|
| 20 | DROP TABLE IF EXISTS `tbladmin`;
|
|---|
| 21 | CREATE TABLE `tbladmin` (
|
|---|
| 22 | `admin_id` int(11) NOT NULL auto_increment,
|
|---|
| 23 | `login_name` varchar(45) NOT NULL,
|
|---|
| 24 | `passwd` varchar(65) NOT NULL,
|
|---|
| 25 | `full_name` varchar(45) NOT NULL,
|
|---|
| 26 | `email` varchar(45) default NULL,
|
|---|
| 27 | `phone` varchar(15) default NULL,
|
|---|
| 28 | `created_time` datetime default NULL,
|
|---|
| 29 | `updated_time` datetime default NULL,
|
|---|
| 30 | `author` int(11) default NULL,
|
|---|
| 31 | PRIMARY KEY (`admin_id`)
|
|---|
| 32 | ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
|---|
| 33 |
|
|---|
| 34 | -- ----------------------------
|
|---|
| 35 | -- Records of tbladmin
|
|---|
| 36 | -- ----------------------------
|
|---|
| 37 | INSERT INTO `tbladmin` VALUES ('1', 'administrator', 'e10adc3949ba59abbe56e057f20f883e', 'Administrator', 'admin@sbg.vn', null, '2014-11-03 15:47:41', null, '1');
|
|---|
| 38 |
|
|---|
| 39 | -- ----------------------------
|
|---|
| 40 | -- Table structure for `tbladminrole`
|
|---|
| 41 | -- ----------------------------
|
|---|
| 42 | DROP TABLE IF EXISTS `tbladminrole`;
|
|---|
| 43 | CREATE TABLE `tbladminrole` (
|
|---|
| 44 | `role_id` int(11) NOT NULL auto_increment,
|
|---|
| 45 | `role_name` varchar(45) NOT NULL,
|
|---|
| 46 | PRIMARY KEY (`role_id`)
|
|---|
| 47 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|---|
| 48 |
|
|---|
| 49 | -- ----------------------------
|
|---|
| 50 | -- Records of tbladminrole
|
|---|
| 51 | -- ----------------------------
|
|---|
| 52 |
|
|---|
| 53 | -- ----------------------------
|
|---|
| 54 | -- Table structure for `tblcardlog`
|
|---|
| 55 | -- ----------------------------
|
|---|
| 56 | DROP TABLE IF EXISTS `tblcardlog`;
|
|---|
| 57 | CREATE TABLE `tblcardlog` (
|
|---|
| 58 | `id` int(11) NOT NULL auto_increment,
|
|---|
| 59 | `sender` varchar(255) default NULL,
|
|---|
| 60 | `us_id` int(11) default NULL,
|
|---|
| 61 | `status` tinyint(4) default '1' COMMENT '-1:fail;0:locked;1:success',
|
|---|
| 62 | `pin_code` varchar(45) default NULL,
|
|---|
| 63 | `serial_num` varchar(45) default NULL,
|
|---|
| 64 | `card_value` int(11) default NULL,
|
|---|
| 65 | `created_time` datetime NOT NULL,
|
|---|
| 66 | PRIMARY KEY (`id`)
|
|---|
| 67 | ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
|---|
| 68 |
|
|---|
| 69 | -- ----------------------------
|
|---|
| 70 | -- Records of tblcardlog
|
|---|
| 71 | -- ----------------------------
|
|---|
| 72 | INSERT INTO `tblcardlog` VALUES ('1', '0988568786', '116', '-1', 'ferwer', 'ðersdfsdgf', '0', '2015-01-15 12:29:22');
|
|---|
| 73 | INSERT INTO `tblcardlog` VALUES ('2', '0988568786', '116', '0', 'ðerwerwe', 'rðerwerwer', '0', '2015-01-15 12:30:13');
|
|---|
| 74 | INSERT INTO `tblcardlog` VALUES ('3', '0988568786', '116', '1', '0924647603794', '92594534261', '10000', '2015-01-15 16:59:19');
|
|---|
| 75 |
|
|---|
| 76 | -- ----------------------------
|
|---|
| 77 | -- Table structure for `tblcollaborator`
|
|---|
| 78 | -- ----------------------------
|
|---|
| 79 | DROP TABLE IF EXISTS `tblcollaborator`;
|
|---|
| 80 | CREATE TABLE `tblcollaborator` (
|
|---|
| 81 | `id` int(11) NOT NULL auto_increment,
|
|---|
| 82 | `full_name` varchar(45) NOT NULL,
|
|---|
| 83 | `login_name` varchar(45) NOT NULL,
|
|---|
| 84 | `cellphone` varchar(15) NOT NULL,
|
|---|
| 85 | `passwd` varchar(65) NOT NULL,
|
|---|
| 86 | `activated` tinyint(4) NOT NULL default '1',
|
|---|
| 87 | `created_time` datetime default NULL,
|
|---|
| 88 | `updated_time` datetime default NULL,
|
|---|
| 89 | `author` int(11) default NULL,
|
|---|
| 90 | `address` varchar(255) NOT NULL,
|
|---|
| 91 | `code` varchar(255) NOT NULL,
|
|---|
| 92 | `district` varchar(255) NOT NULL,
|
|---|
| 93 | `email` varchar(255) NOT NULL,
|
|---|
| 94 | `precinct` varchar(255) NOT NULL,
|
|---|
| 95 | `province` varchar(255) NOT NULL,
|
|---|
| 96 | PRIMARY KEY (`id`)
|
|---|
| 97 | ) ENGINE=InnoDB AUTO_INCREMENT=20536706 DEFAULT CHARSET=utf8;
|
|---|
| 98 |
|
|---|
| 99 | -- ----------------------------
|
|---|
| 100 | -- Records of tblcollaborator
|
|---|
| 101 | -- ----------------------------
|
|---|
| 102 | INSERT INTO `tblcollaborator` VALUES ('1', 'Truong Hoang Anh', '0982124899', '0982124899', '', '1', null, null, null, '', '', '', '', '', '');
|
|---|
| 103 | INSERT INTO `tblcollaborator` VALUES ('2', 'Namta', '01689925260', '01689925260', 'c4ca4238a0b923820dcc509a6f75849b', '1', '2014-11-19 10:21:15', '2014-11-19 10:21:15', null, '', '', '', '', '', '');
|
|---|
| 104 | INSERT INTO `tblcollaborator` VALUES ('5', 'dungnv', '0988568786', '0988568786', 'c4ca4238a0b923820dcc509a6f75849b', '1', '2014-11-19 18:45:27', '2014-11-19 18:45:27', null, '', '', '', '', '', '');
|
|---|
| 105 | 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');
|
|---|
| 106 |
|
|---|
| 107 | -- ----------------------------
|
|---|
| 108 | -- Table structure for `tblpaidlog`
|
|---|
| 109 | -- ----------------------------
|
|---|
| 110 | DROP TABLE IF EXISTS `tblpaidlog`;
|
|---|
| 111 | CREATE TABLE `tblpaidlog` (
|
|---|
| 112 | `paid_id` bigint(11) NOT NULL auto_increment,
|
|---|
| 113 | `us_id` int(11) NOT NULL,
|
|---|
| 114 | `paid_type` tinyint(11) NOT NULL default '0' COMMENT '1:SMS; 2:CARD;',
|
|---|
| 115 | `amount` int(11) NOT NULL default '0',
|
|---|
| 116 | `source` varchar(65) NOT NULL,
|
|---|
| 117 | `paid_time` datetime default NULL,
|
|---|
| 118 | PRIMARY KEY (`paid_id`)
|
|---|
| 119 | ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
|
|---|
| 120 |
|
|---|
| 121 | -- ----------------------------
|
|---|
| 122 | -- Records of tblpaidlog
|
|---|
| 123 | -- ----------------------------
|
|---|
| 124 | INSERT INTO `tblpaidlog` VALUES ('1', '100', '2', '10000', 'Thẻ cào', '2014-11-25 15:16:59');
|
|---|
| 125 | INSERT INTO `tblpaidlog` VALUES ('2', '101', '1', '1000', '01692006723', '2014-11-25 16:05:40');
|
|---|
| 126 | INSERT INTO `tblpaidlog` VALUES ('3', '101', '1', '1000', '01692006723', '2014-11-25 16:08:43');
|
|---|
| 127 | INSERT INTO `tblpaidlog` VALUES ('4', '101', '1', '2000', '01692006723', '2014-11-25 16:12:42');
|
|---|
| 128 | INSERT INTO `tblpaidlog` VALUES ('5', '101', '1', '2500', '01692006723', '2014-11-25 16:33:26');
|
|---|
| 129 | INSERT INTO `tblpaidlog` VALUES ('6', '101', '1', '100', '01692006723', '2014-11-25 16:36:38');
|
|---|
| 130 | INSERT INTO `tblpaidlog` VALUES ('7', '101', '1', '2000', '01692006723', '2014-11-25 16:37:49');
|
|---|
| 131 | INSERT INTO `tblpaidlog` VALUES ('8', '102', '1', '6000', '01632002905', '2014-11-25 16:55:44');
|
|---|
| 132 | INSERT INTO `tblpaidlog` VALUES ('9', '102', '1', '6000', '01632002905', '2014-11-25 16:57:56');
|
|---|
| 133 | INSERT INTO `tblpaidlog` VALUES ('10', '80', '2', '10000', 'Thẻ cào', '2014-11-26 17:58:30');
|
|---|
| 134 | INSERT INTO `tblpaidlog` VALUES ('11', '100', '2', '10000', 'Thẻ cào', '2014-11-26 18:00:23');
|
|---|
| 135 | INSERT INTO `tblpaidlog` VALUES ('12', '100', '1', '1', '0979359749', '2014-11-26 18:04:10');
|
|---|
| 136 | INSERT INTO `tblpaidlog` VALUES ('13', '105', '1', '15000', '01692006723', '2014-12-02 11:08:44');
|
|---|
| 137 | INSERT INTO `tblpaidlog` VALUES ('14', '105', '2', '20000', 'Thẻ cào', '2014-12-02 14:27:00');
|
|---|
| 138 | INSERT INTO `tblpaidlog` VALUES ('15', '105', '2', '20000', 'Thẻ cào', '2014-12-04 16:28:36');
|
|---|
| 139 | INSERT INTO `tblpaidlog` VALUES ('16', '139', '1', '15000', '0982199188', '2015-01-13 16:37:20');
|
|---|
| 140 | INSERT INTO `tblpaidlog` VALUES ('17', '61', '1', '500', '0982124899', '2015-01-14 11:21:00');
|
|---|
| 141 | INSERT INTO `tblpaidlog` VALUES ('18', '116', '2', '10000', 'Thẻ cào', '2015-01-14 17:21:11');
|
|---|
| 142 | INSERT INTO `tblpaidlog` VALUES ('19', '61', '2', '10000', 'Thẻ cào', '2015-01-14 17:23:49');
|
|---|
| 143 | INSERT INTO `tblpaidlog` VALUES ('20', '116', '2', '10000', 'Thẻ cào', '2015-01-15 07:51:43');
|
|---|
| 144 | INSERT INTO `tblpaidlog` VALUES ('21', '116', '2', '10000', 'Thẻ cào', '2015-01-15 16:59:21');
|
|---|
| 145 |
|
|---|
| 146 | -- ----------------------------
|
|---|
| 147 | -- Table structure for `tblregisterpackagelog`
|
|---|
| 148 | -- ----------------------------
|
|---|
| 149 | DROP TABLE IF EXISTS `tblregisterpackagelog`;
|
|---|
| 150 | CREATE TABLE `tblregisterpackagelog` (
|
|---|
| 151 | `id` int(11) NOT NULL auto_increment,
|
|---|
| 152 | `username` varchar(15) NOT NULL,
|
|---|
| 153 | `source` varchar(65) NOT NULL,
|
|---|
| 154 | `p_code` varchar(65) NOT NULL,
|
|---|
| 155 | `created_time` datetime NOT NULL,
|
|---|
| 156 | PRIMARY KEY (`id`)
|
|---|
| 157 | ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
|
|---|
| 158 |
|
|---|
| 159 | -- ----------------------------
|
|---|
| 160 | -- Records of tblregisterpackagelog
|
|---|
| 161 | -- ----------------------------
|
|---|
| 162 | INSERT INTO `tblregisterpackagelog` VALUES ('1', '0988568786', 'Web', '1', '2015-01-15 16:59:46');
|
|---|
| 163 | INSERT INTO `tblregisterpackagelog` VALUES ('2', '0979947802', 'Web', '1', '2015-01-19 12:42:38');
|
|---|
| 164 |
|
|---|
| 165 | -- ----------------------------
|
|---|
| 166 | -- Table structure for `tblservicepackage`
|
|---|
| 167 | -- ----------------------------
|
|---|
| 168 | DROP TABLE IF EXISTS `tblservicepackage`;
|
|---|
| 169 | CREATE TABLE `tblservicepackage` (
|
|---|
| 170 | `p_id` int(11) NOT NULL auto_increment,
|
|---|
| 171 | `p_name` varchar(50) NOT NULL,
|
|---|
| 172 | `p_period` int(11) NOT NULL,
|
|---|
| 173 | `p_price` int(11) NOT NULL,
|
|---|
| 174 | `p_code` varchar(15) default NULL,
|
|---|
| 175 | `p_unit` varchar(15) default NULL,
|
|---|
| 176 | `p_dfspace` varchar(15) default '1GB',
|
|---|
| 177 | `p_isextra` tinyint(4) default '0',
|
|---|
| 178 | PRIMARY KEY (`p_id`)
|
|---|
| 179 | ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
|
|---|
| 180 |
|
|---|
| 181 | -- ----------------------------
|
|---|
| 182 | -- Records of tblservicepackage
|
|---|
| 183 | -- ----------------------------
|
|---|
| 184 | INSERT INTO `tblservicepackage` VALUES ('1', 'VIP 1', '1', '15000', '1', 'months', '1GB', '0');
|
|---|
| 185 | INSERT INTO `tblservicepackage` VALUES ('2', 'VIP 3', '3', '40000', '3', 'months', '1GB', '0');
|
|---|
| 186 | INSERT INTO `tblservicepackage` VALUES ('3', 'VIP 6', '6', '70000', '6', 'months', '1GB', '0');
|
|---|
| 187 | INSERT INTO `tblservicepackage` VALUES ('4', 'VIP 12', '12', '130000', '12', 'months', '1GB', '0');
|
|---|
| 188 | INSERT INTO `tblservicepackage` VALUES ('5', 'Trial', '-1', '0', '-1', 'day', '1GB', '0');
|
|---|
| 189 |
|
|---|
| 190 | -- ----------------------------
|
|---|
| 191 | -- Table structure for `tblsmslog`
|
|---|
| 192 | -- ----------------------------
|
|---|
| 193 | DROP TABLE IF EXISTS `tblsmslog`;
|
|---|
| 194 | CREATE TABLE `tblsmslog` (
|
|---|
| 195 | `id` int(11) NOT NULL auto_increment,
|
|---|
| 196 | `request_id` varchar(255) default '',
|
|---|
| 197 | `sender` varchar(255) default NULL,
|
|---|
| 198 | `us_id` int(11) default NULL,
|
|---|
| 199 | `service_id` int(11) default NULL,
|
|---|
| 200 | `commandcode` varchar(255) default NULL,
|
|---|
| 201 | `info` varchar(255) default NULL,
|
|---|
| 202 | `mobody` varchar(255) default NULL,
|
|---|
| 203 | `mtbody` varchar(255) default NULL,
|
|---|
| 204 | `created_time` datetime default NULL,
|
|---|
| 205 | PRIMARY KEY (`id`)
|
|---|
| 206 | ) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8;
|
|---|
| 207 |
|
|---|
| 208 | -- ----------------------------
|
|---|
| 209 | -- Records of tblsmslog
|
|---|
| 210 | -- ----------------------------
|
|---|
| 211 | INSERT INTO `tblsmslog` VALUES ('1', '', '0979359749', null, '8062', 'SBG', 'Sbg vip 1', null, null, '2014-11-25 10:59:14');
|
|---|
| 212 | INSERT INTO `tblsmslog` VALUES ('2', '', '0979359749', '100', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-25 11:08:41');
|
|---|
| 213 | INSERT INTO `tblsmslog` VALUES ('3', '', '0988568786', '68', '8062', 'SBG', 'Sbg nap aaa', null, null, '2014-11-25 12:30:29');
|
|---|
| 214 | INSERT INTO `tblsmslog` VALUES ('4', '', '0979359749', '100', '8062', 'SBG', 'Sbg vip 1', null, null, '2014-11-25 13:27:56');
|
|---|
| 215 | INSERT INTO `tblsmslog` VALUES ('5', '', '01692006723', '101', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-25 14:59:35');
|
|---|
| 216 | INSERT INTO `tblsmslog` VALUES ('6', '', '01692006723', '101', '8062', 'SBG', 'Sbg vip 1', null, null, '2014-11-25 15:50:49');
|
|---|
| 217 | INSERT INTO `tblsmslog` VALUES ('7', '', '01692006723', '101', '8062', 'SBG', 'Sbg nap 1000', null, null, '2014-11-25 15:53:35');
|
|---|
| 218 | INSERT INTO `tblsmslog` VALUES ('8', '', '01692006723', '101', '8062', 'SBG', 'Sbg nap 1000', null, null, '2014-11-25 15:56:43');
|
|---|
| 219 | INSERT INTO `tblsmslog` VALUES ('9', '', '01692006723', '101', '8062', 'SBG', 'Sbg nap 2000', null, null, '2014-11-25 16:00:41');
|
|---|
| 220 | INSERT INTO `tblsmslog` VALUES ('10', '', '01692006723', '101', '8062', 'SBG', 'Sbg nap 2500', null, null, '2014-11-25 16:21:25');
|
|---|
| 221 | INSERT INTO `tblsmslog` VALUES ('11', '', '01692006723', '101', '8062', 'SBG', 'Sbg nap 100', null, null, '2014-11-25 16:24:32');
|
|---|
| 222 | INSERT INTO `tblsmslog` VALUES ('12', '', '01692006723', '101', '8062', 'SBG', 'Sbg nap 2000', null, null, '2014-11-25 16:25:48');
|
|---|
| 223 | INSERT INTO `tblsmslog` VALUES ('13', '', '01632002905', '102', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-25 16:32:44');
|
|---|
| 224 | INSERT INTO `tblsmslog` VALUES ('14', '', '01632002905', '102', '8062', 'SBG', 'Sbg nap 6000', null, null, '2014-11-25 16:43:42');
|
|---|
| 225 | INSERT INTO `tblsmslog` VALUES ('15', '', '01632002905', '102', '8062', 'SBG', 'Sbg nap 6000', null, null, '2014-11-25 16:40:36');
|
|---|
| 226 | INSERT INTO `tblsmslog` VALUES ('16', '', '0988568786', '68', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-26 10:02:48');
|
|---|
| 227 | INSERT INTO `tblsmslog` VALUES ('17', '', '0988568786', '68', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-26 11:07:56');
|
|---|
| 228 | INSERT INTO `tblsmslog` VALUES ('18', '', '0988568786', '68', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-26 11:07:56');
|
|---|
| 229 | INSERT INTO `tblsmslog` VALUES ('19', '', '0988568786', '68', '8062', 'SBG', 'Sbg mk 123456', null, null, '2014-11-26 11:12:00');
|
|---|
| 230 | INSERT INTO `tblsmslog` VALUES ('20', '', '0988568786', '68', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-26 11:13:00');
|
|---|
| 231 | INSERT INTO `tblsmslog` VALUES ('21', '', '0988568786', '68', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-26 11:13:00');
|
|---|
| 232 | INSERT INTO `tblsmslog` VALUES ('22', '', '0983460604', '103', '8062', 'SBG', 'SBG DK', null, null, '2014-11-26 11:42:14');
|
|---|
| 233 | INSERT INTO `tblsmslog` VALUES ('23', '', '0983460604', '103', '8062', 'SBG', 'SBG DK', null, null, '2014-11-26 11:42:14');
|
|---|
| 234 | INSERT INTO `tblsmslog` VALUES ('24', '', '0982124899', '61', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-26 11:43:48');
|
|---|
| 235 | INSERT INTO `tblsmslog` VALUES ('25', '', '01682821813', '99', '8062', 'SBG', 'SBG dk', null, null, '2014-11-18 09:52:35');
|
|---|
| 236 | INSERT INTO `tblsmslog` VALUES ('26', '', '01682821813', '99', '8062', 'SBG', 'SBG nhj', null, null, '2014-11-18 09:52:35');
|
|---|
| 237 | INSERT INTO `tblsmslog` VALUES ('27', '', '0979359749', '100', '8062', 'SBG', 'Sbg vip 1', null, null, '2014-11-26 17:51:29');
|
|---|
| 238 | INSERT INTO `tblsmslog` VALUES ('28', '', '0979359749', '100', '8062', 'SBG', 'Sbg mk', null, null, '2014-11-26 17:51:56');
|
|---|
| 239 | INSERT INTO `tblsmslog` VALUES ('29', '', '0979359749', '100', '8062', 'SBG', 'Sbg nap 001', null, null, '2014-11-26 17:52:03');
|
|---|
| 240 | INSERT INTO `tblsmslog` VALUES ('30', '', '0979947802', '67', '8062', 'SBG', 'SBG MK', null, null, '2014-11-27 01:13:24');
|
|---|
| 241 | INSERT INTO `tblsmslog` VALUES ('31', '', '0979947802', '67', '8062', 'SBG', 'SBG MK', null, null, '2014-11-27 01:13:24');
|
|---|
| 242 | INSERT INTO `tblsmslog` VALUES ('32', '', '01682821813', '99', '8062', 'SBG', 'SBG nhj', null, null, '2014-11-18 09:52:35');
|
|---|
| 243 | INSERT INTO `tblsmslog` VALUES ('33', '', '01682821813', '99', '8062', 'SBG', 'SBG nhj', null, null, '2014-11-18 09:52:35');
|
|---|
| 244 | INSERT INTO `tblsmslog` VALUES ('34', '', '0988568786', '68', '8062', 'SBG', 'Sbg dk', null, null, '2014-11-29 17:59:52');
|
|---|
| 245 | INSERT INTO `tblsmslog` VALUES ('35', '', '01654040214', null, '8062', 'SBG', 'Sbg dk 01692006723', null, null, '2014-12-02 10:04:13');
|
|---|
| 246 | INSERT INTO `tblsmslog` VALUES ('36', '', '01654040214', '105', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-02 10:35:49');
|
|---|
| 247 | INSERT INTO `tblsmslog` VALUES ('37', '', '01682821813', '99', '8062', 'SBG', 'SBG nhj', null, null, '2014-11-18 09:52:35');
|
|---|
| 248 | INSERT INTO `tblsmslog` VALUES ('38', '', '01682821813', '99', '8062', 'SBG', 'SBG dk', null, null, '2014-11-18 09:52:35');
|
|---|
| 249 | INSERT INTO `tblsmslog` VALUES ('39', '', '0988568786', '68', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-02 10:48:26');
|
|---|
| 250 | INSERT INTO `tblsmslog` VALUES ('40', '', '01692006723', '101', '8062', 'SBG', 'Sbg nap 15000 01654040214', null, null, '2014-12-02 10:56:16');
|
|---|
| 251 | INSERT INTO `tblsmslog` VALUES ('41', '', '0978898670', null, '8062', 'SBG', 'SBG HD', null, null, '2014-12-05 16:36:54');
|
|---|
| 252 | INSERT INTO `tblsmslog` VALUES ('42', '', '01699328160', '106', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-05 23:05:05');
|
|---|
| 253 | INSERT INTO `tblsmslog` VALUES ('43', '', '0978898670', null, '8062', 'SBG', 'sbg', null, null, '2014-12-08 16:14:16');
|
|---|
| 254 | INSERT INTO `tblsmslog` VALUES ('44', '', '0985585868', null, '8062', 'SBG', 'SBG MK', null, null, '2014-11-18 09:52:35');
|
|---|
| 255 | INSERT INTO `tblsmslog` VALUES ('45', '', '0988568786', null, '8062', 'SBG', 'SBG MK', null, null, '2014-11-18 09:52:35');
|
|---|
| 256 | INSERT INTO `tblsmslog` VALUES ('46', '', '0988568786', null, '8062', 'SBG', 'SBG DK', null, null, '2014-11-18 09:52:35');
|
|---|
| 257 | INSERT INTO `tblsmslog` VALUES ('47', '', '0988568786', '112', '8062', 'SBG', 'SBG DK', null, null, '2014-11-18 09:52:35');
|
|---|
| 258 | INSERT INTO `tblsmslog` VALUES ('48', '', '0988568786', '113', '8062', 'SBG', 'SBG DK', null, null, '2014-11-18 09:52:35');
|
|---|
| 259 | INSERT INTO `tblsmslog` VALUES ('49', '', '0988568786', '114', '8062', 'SBG', 'SBG DK', null, null, '2014-11-18 09:52:35');
|
|---|
| 260 | INSERT INTO `tblsmslog` VALUES ('50', '', '0985585868', null, '8062', 'SBG', 'Sbg mk', null, null, '2014-12-10 17:00:42');
|
|---|
| 261 | INSERT INTO `tblsmslog` VALUES ('51', '', '0988568786', null, '8062', 'SBG', 'DK SBG', null, null, '2014-11-18 09:52:35');
|
|---|
| 262 | INSERT INTO `tblsmslog` VALUES ('52', '', '0988568786', null, '8062', 'SBG', 'DK SBG', null, null, '2014-11-18 09:52:35');
|
|---|
| 263 | INSERT INTO `tblsmslog` VALUES ('53', '', '0988568786', '115', '8062', 'SBG', 'SBG DK', null, null, '2014-11-18 09:52:35');
|
|---|
| 264 | INSERT INTO `tblsmslog` VALUES ('54', '', '0988568786', '115', '8062', 'SBG', 'SBG DK', null, null, '2014-11-18 09:52:35');
|
|---|
| 265 | INSERT INTO `tblsmslog` VALUES ('55', '', '0988568786', '116', '8062', 'SBG', 'SBG DK', null, null, '2014-11-18 09:52:35');
|
|---|
| 266 | INSERT INTO `tblsmslog` VALUES ('56', '', '0974766688', '117', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-16 16:49:11');
|
|---|
| 267 | INSERT INTO `tblsmslog` VALUES ('57', '', '0987783898', '118', '8062', 'SBG', 'SBG DK', null, null, '2014-12-23 09:49:06');
|
|---|
| 268 | INSERT INTO `tblsmslog` VALUES ('58', '', '0977844844', '119', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-26 15:55:05');
|
|---|
| 269 | INSERT INTO `tblsmslog` VALUES ('59', '', '0986346346', '120', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-26 16:06:45');
|
|---|
| 270 | INSERT INTO `tblsmslog` VALUES ('60', '', '0988911183', '121', '8062', 'SBG', 'SBG DK', null, null, '2014-12-26 16:53:54');
|
|---|
| 271 | INSERT INTO `tblsmslog` VALUES ('61', '', '0965004848', '122', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-26 17:02:25');
|
|---|
| 272 | INSERT INTO `tblsmslog` VALUES ('62', '', '0965755111', '123', '8062', 'SBG', 'SBG DK', null, null, '2014-12-27 08:29:15');
|
|---|
| 273 | INSERT INTO `tblsmslog` VALUES ('63', '', '0974874595', '124', '8062', 'SBG', 'SBG DK', null, null, '2014-12-27 11:58:06');
|
|---|
| 274 | INSERT INTO `tblsmslog` VALUES ('64', '', '0987708777', '125', '8062', 'SBG', 'Sbg dk', null, null, '2014-12-29 17:50:46');
|
|---|
| 275 | INSERT INTO `tblsmslog` VALUES ('65', '', '0965500155', '126', '8062', 'SBG', 'SBG DK', null, null, '2014-12-29 18:47:37');
|
|---|
| 276 | INSERT INTO `tblsmslog` VALUES ('66', '', '0969661456', '127', '8062', 'SBG', 'SBG DK', null, null, '2014-12-30 12:12:55');
|
|---|
| 277 | INSERT INTO `tblsmslog` VALUES ('67', '', '0977060808', '128', '8062', 'SBG', 'SBG DK', null, null, '2014-12-30 18:20:28');
|
|---|
| 278 | INSERT INTO `tblsmslog` VALUES ('68', '', '01656233686', '129', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-01 14:19:25');
|
|---|
| 279 | INSERT INTO `tblsmslog` VALUES ('69', '', '0982339379', '130', '8062', 'SBG', 'SBG DK', null, null, '2015-01-03 10:15:15');
|
|---|
| 280 | INSERT INTO `tblsmslog` VALUES ('70', '', '0967930009', '131', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 08:05:52');
|
|---|
| 281 | INSERT INTO `tblsmslog` VALUES ('71', '', '0977844844', '119', '8062', 'SBG', 'Sbg mk', null, null, '2015-01-05 13:24:49');
|
|---|
| 282 | INSERT INTO `tblsmslog` VALUES ('72', '', '0988693030', '132', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 14:31:13');
|
|---|
| 283 | INSERT INTO `tblsmslog` VALUES ('73', '', '0975377778', '133', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 14:55:53');
|
|---|
| 284 | INSERT INTO `tblsmslog` VALUES ('74', '', '0964497777', '134', '8062', 'SBG', 'sbg dk', null, null, '2015-01-05 15:12:26');
|
|---|
| 285 | INSERT INTO `tblsmslog` VALUES ('75', '', '0965435965', '135', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 15:13:57');
|
|---|
| 286 | INSERT INTO `tblsmslog` VALUES ('76', '', '01632702222', '136', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-05 15:17:26');
|
|---|
| 287 | INSERT INTO `tblsmslog` VALUES ('77', '', '0985979777', '137', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 15:57:40');
|
|---|
| 288 | INSERT INTO `tblsmslog` VALUES ('78', '', '0969283366', '138', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 16:34:55');
|
|---|
| 289 | INSERT INTO `tblsmslog` VALUES ('79', '', '0982199188', '139', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 18:14:27');
|
|---|
| 290 | INSERT INTO `tblsmslog` VALUES ('80', '', '0983365465', '140', '8062', 'SBG', 'SBG DK', null, null, '2015-01-05 19:09:26');
|
|---|
| 291 | INSERT INTO `tblsmslog` VALUES ('81', '', '0965755111', '123', '8062', 'SBG', 'SBG MK', null, null, '2015-01-05 19:09:47');
|
|---|
| 292 | INSERT INTO `tblsmslog` VALUES ('82', '', '0986346346', '120', '8062', 'SBG', 'Sbg vip1', null, null, '2015-01-05 19:31:34');
|
|---|
| 293 | INSERT INTO `tblsmslog` VALUES ('83', '', '0986346346', '120', '8062', 'SBG', 'Sbg vip 1', null, null, '2015-01-05 19:32:00');
|
|---|
| 294 | INSERT INTO `tblsmslog` VALUES ('84', '', '0984091234', '141', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 08:09:13');
|
|---|
| 295 | INSERT INTO `tblsmslog` VALUES ('85', '', '0947700586', '142', '8062', 'SBG', 'sbg dk', null, null, '2015-01-06 08:33:13');
|
|---|
| 296 | INSERT INTO `tblsmslog` VALUES ('86', '', '0966918548', '143', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-06 08:39:25');
|
|---|
| 297 | INSERT INTO `tblsmslog` VALUES ('87', '', '0966918548', '143', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 08:46:06');
|
|---|
| 298 | INSERT INTO `tblsmslog` VALUES ('88', '', '0989131226', '144', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 09:06:17');
|
|---|
| 299 | INSERT INTO `tblsmslog` VALUES ('89', '', '0977488285', '145', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 10:51:15');
|
|---|
| 300 | INSERT INTO `tblsmslog` VALUES ('90', '', '0984189770', '146', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-06 10:55:33');
|
|---|
| 301 | INSERT INTO `tblsmslog` VALUES ('91', '', '0989025522', '147', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-06 11:13:38');
|
|---|
| 302 | INSERT INTO `tblsmslog` VALUES ('92', '', '0983718066', '148', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 11:19:35');
|
|---|
| 303 | INSERT INTO `tblsmslog` VALUES ('93', '', '0989864199', '149', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-06 11:35:10');
|
|---|
| 304 | INSERT INTO `tblsmslog` VALUES ('94', '', '01676665666', '150', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 14:28:06');
|
|---|
| 305 | INSERT INTO `tblsmslog` VALUES ('95', '', '0964868968', '151', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 16:17:44');
|
|---|
| 306 | INSERT INTO `tblsmslog` VALUES ('96', '', '0986869454', '152', '8062', 'SBG', 'sbg dk', null, null, '2015-01-06 19:34:53');
|
|---|
| 307 | INSERT INTO `tblsmslog` VALUES ('97', '', '0977065588', '153', '8062', 'SBG', 'SBG DK', null, null, '2015-01-06 19:43:35');
|
|---|
| 308 | INSERT INTO `tblsmslog` VALUES ('98', '', '0966985805', '154', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-06 21:06:48');
|
|---|
| 309 | INSERT INTO `tblsmslog` VALUES ('99', '', '01666909959', '155', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-06 21:21:17');
|
|---|
| 310 | INSERT INTO `tblsmslog` VALUES ('100', '', '0988569377', '156', '8062', 'SBG', 'SBG DK', null, null, '2015-01-07 08:39:33');
|
|---|
| 311 | INSERT INTO `tblsmslog` VALUES ('101', '', '0976098097', '157', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-07 09:14:47');
|
|---|
| 312 | INSERT INTO `tblsmslog` VALUES ('102', '', '0977841103', '158', '8062', 'SBG', 'SBG DK', null, null, '2015-01-07 10:50:03');
|
|---|
| 313 | INSERT INTO `tblsmslog` VALUES ('103', '', '0974388668', '159', '8062', 'SBG', 'SBG DK', null, null, '2015-01-07 11:52:15');
|
|---|
| 314 | INSERT INTO `tblsmslog` VALUES ('104', '', '0989892792', '160', '8062', 'SBG', 'SBG DK', null, null, '2015-01-07 15:23:29');
|
|---|
| 315 | INSERT INTO `tblsmslog` VALUES ('105', '', '0973702165', '161', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-07 17:11:55');
|
|---|
| 316 | INSERT INTO `tblsmslog` VALUES ('106', '', '0974641010', '162', '8062', 'SBG', 'SBG DK', null, null, '2015-01-08 15:10:03');
|
|---|
| 317 | INSERT INTO `tblsmslog` VALUES ('107', '', '0985461010', '163', '8062', 'SBG', 'SBG DK', null, null, '2015-01-08 21:13:56');
|
|---|
| 318 | INSERT INTO `tblsmslog` VALUES ('108', '', '0989710858', '164', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-09 09:40:53');
|
|---|
| 319 | INSERT INTO `tblsmslog` VALUES ('109', '', '0977750010', '165', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-09 10:22:00');
|
|---|
| 320 | INSERT INTO `tblsmslog` VALUES ('110', '', '0968795757', '166', '8062', 'SBG', 'SBG DK', null, null, '2015-01-09 10:56:11');
|
|---|
| 321 | INSERT INTO `tblsmslog` VALUES ('111', '', '01699242832', '167', '8062', 'SBG', 'SBG DK', null, null, '2015-01-09 11:00:47');
|
|---|
| 322 | INSERT INTO `tblsmslog` VALUES ('112', '', '0989531234', '168', '8062', 'SBG', 'sbg dk', null, null, '2015-01-09 13:52:40');
|
|---|
| 323 | INSERT INTO `tblsmslog` VALUES ('113', '', '0969933399', '169', '8062', 'SBG', 'SBG DK', null, null, '2015-01-10 16:10:49');
|
|---|
| 324 | INSERT INTO `tblsmslog` VALUES ('114', '', '0987908828', '170', '8062', 'SBG', 'SBG DK', null, null, '2015-01-12 09:17:09');
|
|---|
| 325 | INSERT INTO `tblsmslog` VALUES ('115', '', '0983762762', '171', '8062', 'SBG', 'SBG DK', null, null, '2015-01-12 16:30:44');
|
|---|
| 326 | INSERT INTO `tblsmslog` VALUES ('116', '', '0969497497', '172', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-12 20:27:24');
|
|---|
| 327 | INSERT INTO `tblsmslog` VALUES ('117', '', '0974388668', '159', '8062', 'SBG', 'SBG VIP 12', null, null, '2015-01-13 11:22:00');
|
|---|
| 328 | INSERT INTO `tblsmslog` VALUES ('118', '', '0974388668', '159', '8062', 'SBG', 'SBG VIP 1', null, null, '2015-01-13 11:22:44');
|
|---|
| 329 | INSERT INTO `tblsmslog` VALUES ('119', '', '0974388668', '159', '8062', 'SBG', 'SBG MK', null, null, '2015-01-13 14:23:26');
|
|---|
| 330 | INSERT INTO `tblsmslog` VALUES ('120', '', '0974766688', '117', '8062', 'SBG', 'Sbg mk', null, null, '2015-01-13 14:48:53');
|
|---|
| 331 | INSERT INTO `tblsmslog` VALUES ('121', '', '0982199188', '139', '8062', 'SBG', 'SBG NAP 15000', null, null, '2015-01-13 16:35:44');
|
|---|
| 332 | INSERT INTO `tblsmslog` VALUES ('122', '', '0982124899', '61', '8062', 'SBG', 'Sbg nap 500', null, null, '2015-01-14 11:15:38');
|
|---|
| 333 | INSERT INTO `tblsmslog` VALUES ('123', '', '01647579889', '173', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-14 12:45:29');
|
|---|
| 334 | INSERT INTO `tblsmslog` VALUES ('124', '', '0985686726', '174', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-14 12:48:01');
|
|---|
| 335 | INSERT INTO `tblsmslog` VALUES ('125', '', '0978999321', '175', '8062', 'SBG', 'SBG DK', null, null, '2015-01-15 09:58:15');
|
|---|
| 336 | INSERT INTO `tblsmslog` VALUES ('126', '', '0965500155', '126', '8062', 'SBG', 'Sbg mk', null, null, '2015-01-15 12:06:08');
|
|---|
| 337 | INSERT INTO `tblsmslog` VALUES ('127', '', '01637147842', '176', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-15 14:30:14');
|
|---|
| 338 | INSERT INTO `tblsmslog` VALUES ('128', '', '0973425127', null, '8062', 'SBG', 'sbg mk', null, null, '2015-01-15 15:09:59');
|
|---|
| 339 | INSERT INTO `tblsmslog` VALUES ('129', '', '0973425127', '177', '8062', 'SBG', 'sbg dk', null, null, '2015-01-15 15:13:12');
|
|---|
| 340 | INSERT INTO `tblsmslog` VALUES ('130', '', '0973425127', '177', '8062', 'SBG', 'sbg dk', null, null, '2015-01-15 15:20:40');
|
|---|
| 341 | INSERT INTO `tblsmslog` VALUES ('131', '', '0984091234', '141', '8062', 'SBG', 'SBG DK', null, null, '2015-01-15 15:22:02');
|
|---|
| 342 | INSERT INTO `tblsmslog` VALUES ('132', '', '0988568786', '116', '8062', 'SBG', 'SBG DK 0988568786', null, null, '2015-01-13 00:00:00');
|
|---|
| 343 | INSERT INTO `tblsmslog` VALUES ('133', '', '0988568786', '116', '8062', 'SBG', 'SBG DK 0973425127', null, null, '2015-01-13 00:00:00');
|
|---|
| 344 | INSERT INTO `tblsmslog` VALUES ('134', '', '0977006622', '178', '8062', 'SBG', 'SBG DK', null, null, '2015-01-15 15:44:48');
|
|---|
| 345 | INSERT INTO `tblsmslog` VALUES ('135', '', '0977006622', '178', '8062', 'SBG', 'SBG DK', null, null, '2015-01-15 15:51:57');
|
|---|
| 346 | INSERT INTO `tblsmslog` VALUES ('136', '', '0976114933', '179', '8062', 'SBG', 'SBG DK', null, null, '2015-01-15 21:55:16');
|
|---|
| 347 | INSERT INTO `tblsmslog` VALUES ('137', '', '0986278224', '180', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-16 11:19:03');
|
|---|
| 348 | INSERT INTO `tblsmslog` VALUES ('138', '', '0965668669', '181', '8062', 'SBG', 'Sbg dk', null, null, '2015-01-17 07:10:10');
|
|---|
| 349 | INSERT INTO `tblsmslog` VALUES ('139', '', '0984278829', '182', '8062', 'SBG', 'SBG DK', null, null, '2015-01-19 12:42:05');
|
|---|
| 350 |
|
|---|
| 351 | -- ----------------------------
|
|---|
| 352 | -- Table structure for `tblsmstemplate`
|
|---|
| 353 | -- ----------------------------
|
|---|
| 354 | DROP TABLE IF EXISTS `tblsmstemplate`;
|
|---|
| 355 | CREATE TABLE `tblsmstemplate` (
|
|---|
| 356 | `sms_id` int(11) NOT NULL auto_increment,
|
|---|
| 357 | `sms_content` varchar(255) NOT NULL,
|
|---|
| 358 | `sms_reply` varchar(255) default NULL,
|
|---|
| 359 | `reponse_url` varchar(255) default NULL,
|
|---|
| 360 | `service_id` varchar(45) default NULL,
|
|---|
| 361 | `commandcode` varchar(45) default NULL,
|
|---|
| 362 | PRIMARY KEY (`sms_id`)
|
|---|
| 363 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|---|
| 364 |
|
|---|
| 365 | -- ----------------------------
|
|---|
| 366 | -- Records of tblsmstemplate
|
|---|
| 367 | -- ----------------------------
|
|---|
| 368 |
|
|---|
| 369 | -- ----------------------------
|
|---|
| 370 | -- Table structure for `tbluser`
|
|---|
| 371 | -- ----------------------------
|
|---|
| 372 | DROP TABLE IF EXISTS `tbluser`;
|
|---|
| 373 | CREATE TABLE `tbluser` (
|
|---|
| 374 | `us_id` int(11) NOT NULL,
|
|---|
| 375 | `cellphone` varchar(15) NOT NULL,
|
|---|
| 376 | `collaborator` int(11) default NULL,
|
|---|
| 377 | `acc_balanced` bigint(20) NOT NULL default '0',
|
|---|
| 378 | `expire_date` date default NULL,
|
|---|
| 379 | `district` varchar(255) default NULL,
|
|---|
| 380 | `province` varchar(255) default NULL,
|
|---|
| 381 | `p_id` int(11) default NULL,
|
|---|
| 382 | `created_time` datetime NOT NULL,
|
|---|
| 383 | `updated_time` datetime default NULL,
|
|---|
| 384 | PRIMARY KEY (`us_id`)
|
|---|
| 385 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|---|
| 386 |
|
|---|
| 387 | -- ----------------------------
|
|---|
| 388 | -- Records of tbluser
|
|---|
| 389 | -- ----------------------------
|
|---|
| 390 | 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');
|
|---|
| 391 | INSERT INTO `tbluser` VALUES ('66', '01887521818', '982124899', '0', null, null, null, null, '2014-11-15 01:09:42', null);
|
|---|
| 392 | 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');
|
|---|
| 393 | 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');
|
|---|
| 394 | INSERT INTO `tbluser` VALUES ('70', '0985826266', null, '5000', '2016-11-16', null, null, '4', '2014-11-18 15:39:59', null);
|
|---|
| 395 | INSERT INTO `tbluser` VALUES ('71', '0912268437', null, '4500', '2014-12-17', null, null, '1', '2014-11-18 16:02:23', null);
|
|---|
| 396 | INSERT INTO `tbluser` VALUES ('80', '01234788777', null, '10400', null, null, null, null, '2014-11-20 10:36:34', '2014-11-26 17:58:30');
|
|---|
| 397 | INSERT INTO `tbluser` VALUES ('81', '0989562365', '988568786', '0', null, null, null, null, '2014-11-20 11:41:24', null);
|
|---|
| 398 | INSERT INTO `tbluser` VALUES ('85', '01662860000', null, '1500000', null, null, null, null, '2014-11-20 17:26:07', '2014-11-20 17:52:03');
|
|---|
| 399 | INSERT INTO `tbluser` VALUES ('86', '01689925260', null, '0', null, null, null, null, '2014-11-21 09:55:36', '2014-11-21 10:17:31');
|
|---|
| 400 | 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');
|
|---|
| 401 | INSERT INTO `tbluser` VALUES ('89', '01688243590', null, '0', null, null, null, null, '2014-11-21 16:45:26', null);
|
|---|
| 402 | INSERT INTO `tbluser` VALUES ('91', '01685910879', null, '0', null, null, null, null, '2014-11-21 17:01:53', null);
|
|---|
| 403 | INSERT INTO `tbluser` VALUES ('99', '01682821813', null, '0', null, null, null, null, '2014-11-25 10:04:03', null);
|
|---|
| 404 | 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');
|
|---|
| 405 | 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');
|
|---|
| 406 | 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');
|
|---|
| 407 | INSERT INTO `tbluser` VALUES ('103', '0983460604', null, '0', null, null, null, null, '2014-11-26 11:54:15', null);
|
|---|
| 408 | 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');
|
|---|
| 409 | INSERT INTO `tbluser` VALUES ('106', '01699328160', null, '0', null, null, null, null, '2014-12-05 23:05:34', null);
|
|---|
| 410 | 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');
|
|---|
| 411 | INSERT INTO `tbluser` VALUES ('117', '0974766688', null, '0', '2014-12-23', null, null, '5', '2014-12-16 16:49:38', null);
|
|---|
| 412 | INSERT INTO `tbluser` VALUES ('118', '0987783898', null, '0', '2014-12-30', null, null, '5', '2014-12-23 09:49:45', null);
|
|---|
| 413 | 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');
|
|---|
| 414 | INSERT INTO `tbluser` VALUES ('120', '0986346346', null, '0', '2015-01-02', null, null, '5', '2014-12-26 16:07:32', null);
|
|---|
| 415 | INSERT INTO `tbluser` VALUES ('121', '0988911183', null, '0', '2015-01-02', null, null, '5', '2014-12-26 16:54:39', null);
|
|---|
| 416 | INSERT INTO `tbluser` VALUES ('122', '0965004848', null, '0', '2015-01-02', null, null, '5', '2014-12-26 17:03:09', null);
|
|---|
| 417 | 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');
|
|---|
| 418 | INSERT INTO `tbluser` VALUES ('124', '0974874595', null, '0', '2015-01-03', null, null, '5', '2014-12-27 11:58:55', null);
|
|---|
| 419 | INSERT INTO `tbluser` VALUES ('125', '0987708777', null, '0', '2015-01-05', null, null, '5', '2014-12-29 17:51:37', null);
|
|---|
| 420 | 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');
|
|---|
| 421 | INSERT INTO `tbluser` VALUES ('127', '0969661456', null, '0', '2015-01-06', null, null, '5', '2014-12-30 12:13:48', null);
|
|---|
| 422 | INSERT INTO `tbluser` VALUES ('128', '0977060808', null, '0', '2015-01-06', null, null, '5', '2014-12-30 18:21:21', null);
|
|---|
| 423 | INSERT INTO `tbluser` VALUES ('129', '01656233686', null, '0', '2015-01-08', null, null, '5', '2015-01-01 14:20:27', null);
|
|---|
| 424 | INSERT INTO `tbluser` VALUES ('130', '0982339379', null, '0', '2015-01-10', null, null, '5', '2015-01-03 10:16:22', null);
|
|---|
| 425 | INSERT INTO `tbluser` VALUES ('131', '0967930009', null, '0', '2015-01-12', null, null, '5', '2015-01-05 08:07:00', null);
|
|---|
| 426 | INSERT INTO `tbluser` VALUES ('132', '0988693030', null, '0', '2015-01-12', null, null, '5', '2015-01-05 14:32:30', null);
|
|---|
| 427 | INSERT INTO `tbluser` VALUES ('133', '0975377778', null, '0', '2015-01-12', null, null, '5', '2015-01-05 14:57:03', null);
|
|---|
| 428 | INSERT INTO `tbluser` VALUES ('134', '0964497777', null, '0', '2015-01-12', null, null, '5', '2015-01-05 15:13:42', null);
|
|---|
| 429 | INSERT INTO `tbluser` VALUES ('135', '0965435965', null, '0', '2015-01-12', null, null, '5', '2015-01-05 15:15:08', null);
|
|---|
| 430 | INSERT INTO `tbluser` VALUES ('136', '01632702222', null, '0', '2015-01-12', null, null, '5', '2015-01-05 15:18:37', null);
|
|---|
| 431 | INSERT INTO `tbluser` VALUES ('137', '0985979777', null, '0', '2015-01-12', null, null, '5', '2015-01-05 15:58:44', null);
|
|---|
| 432 | INSERT INTO `tbluser` VALUES ('138', '0969283366', null, '0', '2015-01-12', null, null, '5', '2015-01-05 16:35:57', null);
|
|---|
| 433 | 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');
|
|---|
| 434 | INSERT INTO `tbluser` VALUES ('140', '0983365465', null, '0', '2015-01-12', null, null, '5', '2015-01-05 19:10:28', null);
|
|---|
| 435 | INSERT INTO `tbluser` VALUES ('141', '0984091234', null, '0', '2015-01-13', null, null, '5', '2015-01-06 08:10:19', null);
|
|---|
| 436 | INSERT INTO `tbluser` VALUES ('142', '0947700586', null, '0', '2015-01-13', null, null, '5', '2015-01-06 08:35:30', null);
|
|---|
| 437 | INSERT INTO `tbluser` VALUES ('143', '0966918548', null, '0', '2015-01-13', null, null, '5', '2015-01-06 08:41:54', null);
|
|---|
| 438 | INSERT INTO `tbluser` VALUES ('144', '0989131226', null, '0', '2015-01-13', null, null, '5', '2015-01-06 09:20:48', null);
|
|---|
| 439 | INSERT INTO `tbluser` VALUES ('145', '0977488285', null, '0', '2015-01-13', null, null, '5', '2015-01-06 10:56:54', null);
|
|---|
| 440 | INSERT INTO `tbluser` VALUES ('146', '0984189770', null, '0', '2015-01-13', null, null, '5', '2015-01-06 10:57:05', null);
|
|---|
| 441 | INSERT INTO `tbluser` VALUES ('147', '0989025522', null, '0', '2015-01-13', null, null, '5', '2015-01-06 11:14:47', null);
|
|---|
| 442 | INSERT INTO `tbluser` VALUES ('148', '0983718066', null, '0', '2015-01-13', null, null, '5', '2015-01-06 11:20:49', null);
|
|---|
| 443 | INSERT INTO `tbluser` VALUES ('149', '0989864199', null, '0', '2015-01-13', null, null, '5', '2015-01-06 11:36:20', null);
|
|---|
| 444 | INSERT INTO `tbluser` VALUES ('150', '01676665666', null, '0', '2015-01-13', null, null, '5', '2015-01-06 14:29:11', null);
|
|---|
| 445 | INSERT INTO `tbluser` VALUES ('151', '0964868968', null, '0', '2015-01-13', null, null, '5', '2015-01-06 16:18:49', null);
|
|---|
| 446 | INSERT INTO `tbluser` VALUES ('152', '0986869454', null, '0', '2015-01-13', null, null, '5', '2015-01-06 19:36:05', null);
|
|---|
| 447 | INSERT INTO `tbluser` VALUES ('153', '0977065588', null, '0', '2015-01-13', null, null, '5', '2015-01-06 19:44:48', null);
|
|---|
| 448 | INSERT INTO `tbluser` VALUES ('154', '0966985805', null, '0', '2015-01-13', null, null, '5', '2015-01-06 21:08:02', null);
|
|---|
| 449 | INSERT INTO `tbluser` VALUES ('155', '01666909959', null, '0', '2015-01-13', null, null, '5', '2015-01-06 21:22:25', null);
|
|---|
| 450 | INSERT INTO `tbluser` VALUES ('156', '0988569377', null, '0', '2015-01-14', null, null, '5', '2015-01-07 08:40:54', null);
|
|---|
| 451 | INSERT INTO `tbluser` VALUES ('157', '0976098097', null, '0', '2015-01-14', null, null, '5', '2015-01-07 09:15:58', null);
|
|---|
| 452 | INSERT INTO `tbluser` VALUES ('158', '0977841103', null, '0', '2015-01-14', null, null, '5', '2015-01-07 10:51:12', null);
|
|---|
| 453 | 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');
|
|---|
| 454 | INSERT INTO `tbluser` VALUES ('160', '0989892792', null, '0', '2015-01-14', null, null, '5', '2015-01-07 15:24:37', null);
|
|---|
| 455 | 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');
|
|---|
| 456 | INSERT INTO `tbluser` VALUES ('162', '0974641010', null, '0', '2015-01-15', null, null, '5', '2015-01-08 15:11:14', null);
|
|---|
| 457 | INSERT INTO `tbluser` VALUES ('163', '0985461010', null, '0', '2015-01-15', null, null, '5', '2015-01-08 21:15:13', null);
|
|---|
| 458 | INSERT INTO `tbluser` VALUES ('164', '0989710858', null, '0', '2015-01-16', null, null, '5', '2015-01-09 09:42:05', null);
|
|---|
| 459 | INSERT INTO `tbluser` VALUES ('165', '0977750010', null, '0', '2015-01-16', null, null, '5', '2015-01-09 10:23:12', null);
|
|---|
| 460 | INSERT INTO `tbluser` VALUES ('166', '0968795757', null, '0', '2015-01-16', null, null, '5', '2015-01-09 10:57:21', null);
|
|---|
| 461 | INSERT INTO `tbluser` VALUES ('167', '01699242832', null, '0', '2015-01-16', null, null, '5', '2015-01-09 11:02:04', null);
|
|---|
| 462 | INSERT INTO `tbluser` VALUES ('168', '0989531234', null, '0', '2015-01-16', null, null, '5', '2015-01-09 13:53:51', null);
|
|---|
| 463 | INSERT INTO `tbluser` VALUES ('169', '0969933399', null, '0', '2015-01-17', null, null, '5', '2015-01-10 16:12:02', null);
|
|---|
| 464 | INSERT INTO `tbluser` VALUES ('170', '0987908828', null, '0', '2015-01-19', null, null, '5', '2015-01-12 09:18:26', null);
|
|---|
| 465 | 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');
|
|---|
| 466 | INSERT INTO `tbluser` VALUES ('172', '0969497497', null, '0', '2015-01-19', null, null, '5', '2015-01-12 20:28:42', null);
|
|---|
| 467 | INSERT INTO `tbluser` VALUES ('173', '01647579889', null, '0', '2015-01-21', null, null, '5', '2015-01-14 12:46:52', null);
|
|---|
| 468 | 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');
|
|---|
| 469 | 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');
|
|---|
| 470 | 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');
|
|---|
| 471 | 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');
|
|---|
| 472 | INSERT INTO `tbluser` VALUES ('178', '0977006622', null, '0', '2015-01-22', null, null, '5', '2015-01-15 15:46:09', null);
|
|---|
| 473 | 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');
|
|---|
| 474 | 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');
|
|---|
| 475 | 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');
|
|---|
| 476 | 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');
|
|---|
| 477 |
|
|---|
| 478 | -- ----------------------------
|
|---|
| 479 | -- Table structure for `tblwebservice`
|
|---|
| 480 | -- ----------------------------
|
|---|
| 481 | DROP TABLE IF EXISTS `tblwebservice`;
|
|---|
| 482 | CREATE TABLE `tblwebservice` (
|
|---|
| 483 | `service_id` int(11) NOT NULL auto_increment,
|
|---|
| 484 | `service_name` varchar(45) NOT NULL,
|
|---|
| 485 | `address` varchar(255) default NULL,
|
|---|
| 486 | `uri` varchar(255) default NULL,
|
|---|
| 487 | PRIMARY KEY (`service_id`)
|
|---|
| 488 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|---|
| 489 |
|
|---|
| 490 | -- ----------------------------
|
|---|
| 491 | -- Records of tblwebservice
|
|---|
| 492 | -- ----------------------------
|
|---|
![(please configure the [header_logo] section in trac.ini)](/space/chrome/site/your_project_logo.png){kind=logo}
