source: pro-violet-viettel/docs/db/violet-viettel-2.3.2015.sql @ 772

Last change on this file since 772 was 772, checked in by quyenla, 10 years ago

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