/
db_xhotel.sql
751 lines (730 loc) · 127 KB
/
db_xhotel.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
/*
Navicat Premium Data Transfer
Source Server : aliyun
Source Server Type : MySQL
Source Server Version : 50725
Source Host : 47.102.139.183:3306
Source Schema : db_xhotel
Target Server Type : MySQL
Target Server Version : 50725
File Encoding : 65001
Date: 25/04/2019 22:47:58
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_hotel
-- ----------------------------
DROP TABLE IF EXISTS `t_hotel`;
CREATE TABLE `t_hotel` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '酒店编号',
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '酒店名称',
`site` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '酒店地点',
`type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '酒店类型',
`area` decimal(20, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '占地面积',
`star` decimal(20, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '酒店星级',
`score` decimal(20, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '酒店评分',
`introduction` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '酒店介绍',
`photo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '酒店图片',
`status` smallint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '酒店状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_hotel
-- ----------------------------
INSERT INTO `t_hotel` VALUES ('0', '', 'xhotel', 'gdut', 'best', 1001, 5, 5, 'this is xhotel', 'no photo', 0, '2019-04-11 22:03:31', '2019-04-16 22:23:16');
INSERT INTO `t_hotel` VALUES ('007b530f46ab4e8385465f7cf4c2a595', '010208', '广州精品酒店第8号酒店', '', '', 118, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('03ef568a04e74ab886e5be6633aca141', '0102024', '广州精品酒店第24号酒店', '', '', 134, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('069129962e294ce58d51104d5807a9f5', '0102021', '广州精品酒店第21号酒店', '', '', 131, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('085016ef42c941efa70d1f89d969769a', '0102014', '广州精品酒店第14号酒店', '', '', 124, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('09e8e95416554e64a24a0de8585c0934', '0102010', '广州精品酒店第10号酒店', '', '', 120, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('0ba89fed5e7a4bc4ba59636cc26bc716', '0102014', '广州精品酒店第14号酒店', '', '', 124, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('12e42daeae4a40b5bf6abacb5282d145', '010207', '广州精品酒店第7号酒店', '', '', 117, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('15685346eac444c5940b51a815a781bd', '0102025', '广州精品酒店第25号酒店', '', '', 135, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('195628e1b25c4059979da1637428b04c', '010205', '广州精品酒店第5号酒店', '', '', 115, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('1b70c94ef3594962aa4693dbfe434122', '0102023', '广州精品酒店第23号酒店', '', '', 133, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('1c2ecdbeed8a4568b90351b9b19569e0', '0102018', '广州精品酒店第18号酒店', '', '', 128, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('1d45633718244e00bfe5f2a4f4bee0b9', '0102029', '广州精品酒店第29号酒店', '', '', 139, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('1f7dff2c9a7a4cecad9191d54029ce46', '0102013', '广州精品酒店第13号酒店', '', '', 123, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('212aed0bcff34928b3c542d166f76363', '0102011', '广州精品酒店第11号酒店', '', '', 121, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('2622e23d4fd54bf1a55ed0f654ddd185', '0102013', '广州精品酒店第13号酒店', '', '', 123, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('279bb990f7bb46a1b7e8665f15e4b0eb', '0102022', '广州精品酒店第22号酒店', '', '', 132, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('27badbfed36641deb388a723f13f8af8', '0102026', '广州精品酒店第26号酒店', '', '', 136, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('2bad3545d6694114b391332cda8366d8', '010203', '广州精品酒店第3号酒店', '', '', 113, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('2e925692e767416399e0a62c2749274b', '010201', '广州精品酒店第1号酒店', '', '', 111, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('340282baa3994872b88c970f58cf6001', '010206', '广州精品酒店第6号酒店', '', '', 116, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('38be850635a04912b7a52cca114b762d', '010209', '广州精品酒店第9号酒店', '', '', 119, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('3d006016d0974224a7399681fa7ec9ea', '010202', '广州精品酒店第2号酒店', '', '', 112, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('3f452448293d4f8fb5ce994f239c4123', '010203', '广州精品酒店第3号酒店', '', '', 113, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('40d56bf3a2d94e33a13f175bf6d86735', '0102025', '广州精品酒店第25号酒店', '', '', 135, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('414ee1ecbe704458b931654362f99b70', '0102014', '广州精品酒店第14号酒店', '', '', 124, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('4448573ff7c6476e990c3b4363941175', '0102026', '广州精品酒店第26号酒店', '', '', 136, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('4c779066791446d18535bb212e95382a', '010207', '广州精品酒店第7号酒店', '', '', 117, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('4e0ec025231444f89241f2c658356804', '0102022', '广州精品酒店第22号酒店', '', '', 132, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('4e1c1c85a6fb4c0cb406613d6782f0ec', '0102020', '广州精品酒店第20号酒店', '', '', 130, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('4e9fd404d42b4dc48d4dbe73dc1837d8', '0102016', '广州精品酒店第16号酒店', '', '', 126, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('525fbf75acf44ebdaf980ebb0449cddf', '0102015', '广州精品酒店第15号酒店', '', '', 125, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('52819461d802446789e942ab1c96c8da', '010206', '广州精品酒店第6号酒店', '', '', 116, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('52fa292e5e6f46a7802ce39163da8292', '010202', '广州精品酒店第2号酒店', '', '', 112, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('547151842bb84f8e83c244fc9fb35f82', '010205', '广州精品酒店第5号酒店', '', '', 115, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('574b664cb6de4ab2ad300d103afc0b34', '0102017', '广州精品酒店第17号酒店', '', '', 127, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('58a7c7e9dc344757a81c626f6be3cb68', '010200', '广州精品酒店第0号酒店', '', '', 110, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('5958b4e86ada4cb7ae34fe36488ea847', '0102015', '广州精品酒店第15号酒店', '', '', 125, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('5a65f9aaf6f243e5be182f9c550447af', '0102011', '广州精品酒店第11号酒店', '', '', 121, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('5b08ab03559d4586988ea96ae45edda6', '0102029', '广州精品酒店第29号酒店', '', '', 139, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('5c0eb271549549db9fdef3f90e9a8153', '0102010', '广州精品酒店第10号酒店', '', '', 120, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('5ddb5c0471a440c6830d3797029e9089', '0102021', '广州精品酒店第21号酒店', '', '', 131, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('60f6b95f27b44465b94e279f60db8c40', '0102016', '广州精品酒店第16号酒店', '', '', 126, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('631ec4e27566412a993cd8f84ba01bba', '0102020', '广州精品酒店第20号酒店', '', '', 130, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('661cfddc6da7469f8235d90ac1ea8702', '010207', '广州精品酒店第7号酒店', '', '', 117, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('671002977eaf48c0983182da9a3db108', '0102012', '广州精品酒店第12号酒店', '', '', 122, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('6ab1fbf8cc794ac3b6e91f41cb855314', '0102015', '广州精品酒店第15号酒店', '', '', 125, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('6d7d68937a6a4ee6b32106d8f508f48d', '0102028', '广州精品酒店第28号酒店', '', '', 138, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('6e8247b455a2485986501d9b7c543fe4', '010202', '广州精品酒店第2号酒店', '', '', 112, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('6f16309d5b504d4b941bf4afb3279696', '0102014', '广州精品酒店第14号酒店', '', '', 124, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('7207a97e45c7489f8e6c8550f29200cf', '0102019', '广州精品酒店第19号酒店', '', '', 129, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('739ffaa3457d485bbf0feb30e67f9dc9', '0102012', '广州精品酒店第12号酒店', '', '', 122, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('7e3aed9b2069497fb191ddad614a7caf', '010203', '广州精品酒店第3号酒店', '', '', 113, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('7fa63e4dc6b14324b1cdbb802687ea81', '0102021', '广州精品酒店第21号酒店', '', '', 131, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('8093d48f18c74327acb3b67b78a1bba5', '0102013', '广州精品酒店第13号酒店', '', '', 123, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('815ce0bc765e46fdbf73d556fc626b8f', '0102025', '广州精品酒店第25号酒店', '', '', 135, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('82e46ddde2c34ead9ef17e87d02cfd35', '010209', '广州精品酒店第9号酒店', '', '', 119, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('870808ca941442d8b5b7a4a30fd95100', '0102023', '广州精品酒店第23号酒店', '', '', 133, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('88f7f7c0a97c442ba5bee68a77bfac44', '0102020', '广州精品酒店第20号酒店', '', '', 130, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('89c068d94a064f158947a7f1dc30890c', '0102026', '广州精品酒店第26号酒店', '', '', 136, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('89e9c90753b8483cb793a102762f0db1', '010209', '广州精品酒店第9号酒店', '', '', 119, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('8cb482026eac4ab289e573ce196d3181', '010200', '广州精品酒店第0号酒店', '', '', 110, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('90f047753033448c88b999ef7df979e6', '0102019', '广州精品酒店第19号酒店', '', '', 129, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('9390dc8b677e4d3782857532c0094e65', '0102027', '广州精品酒店第27号酒店', '', '', 137, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('940478b774e541cb8f0ce483844a7d34', '010208', '广州精品酒店第8号酒店', '', '', 118, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('9414fec454034dbc81de6e9e1b5903a0', '010208', '广州精品酒店第8号酒店', '', '', 118, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('94f83adb35b549a2b8a451ceb6f069ab', '010205', '广州精品酒店第5号酒店', '', '', 115, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('960fc018c55d4503814664bdd681320c', '0102016', '广州精品酒店第16号酒店', '', '', 126, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('975bfe4d21b5483bb37650461bb12e8d', '0102027', '广州精品酒店第27号酒店', '', '', 137, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('9e759848f61343cca4eef9a7208fd0c8', '0102024', '广州精品酒店第24号酒店', '', '', 134, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('a22f67db55454449bd3093b3e154590f', '0102013', '广州精品酒店第13号酒店', '', '', 123, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('a2ac0009398a43888737871126ef14fb', '0102023', '广州精品酒店第23号酒店', '', '', 133, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('a457fe3613c24e3695ecfcc0e3c02f72', '0102010', '广州精品酒店第10号酒店', '', '', 120, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('a4fa3c7971fa45158e589c0e66d334a0', '0102016', '广州精品酒店第16号酒店', '', '', 126, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('a542d297c5024c65b10ebb3c128a83f9', '0102011', '广州精品酒店第11号酒店', '', '', 121, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('a5e4ff20febe47abb3a9c5092dbe1f79', '0102017', '广州精品酒店第17号酒店', '', '', 127, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('a6b89bebec7244878e7922c7bcfbbbf2', '010209', '广州精品酒店第9号酒店', '', '', 119, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('a8f1f867448c4c2f98df97332de5bedb', '010203', '广州精品酒店第3号酒店', '', '', 113, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('aa1e4ac882fb4c82bb6a3aba90ab85b3', '0102022', '广州精品酒店第22号酒店', '', '', 132, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('ac10b892465843bda47ed80ea9666f04', '0102027', '广州精品酒店第27号酒店', '', '', 137, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('b263b53e7db840d1a9b7a35d0acb5ea7', '0102023', '广州精品酒店第23号酒店', '', '', 133, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('b5b3bbcb2a3345dd818841510205053d', '0102028', '广州精品酒店第28号酒店', '', '', 138, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('b7172d6c5cf44249957f7ffefc1ab6ef', '0102026', '广州精品酒店第26号酒店', '', '', 136, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('bb09e383a64d4094808ba435e990ee74', '010200', '广州精品酒店第0号酒店', '', '', 110, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('bb0c519de85a45a78d77d4fdf8de7f72', '010201', '广州精品酒店第1号酒店', '', '', 111, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('bf681460cccb4809b3ebfc2ed46d96a1', '0102025', '广州精品酒店第25号酒店', '', '', 135, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('c175674678de49cfa89704940d7ea363', '0102018', '广州精品酒店第18号酒店', '', '', 128, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('c27e34c1306d45c784b3afbd0ce4c289', '0102029', '广州精品酒店第29号酒店', '', '', 139, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('c344f1f68e95449cb4bbf8927989c06f', '010201', '广州精品酒店第1号酒店', '', '', 111, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('c3999a712f8c487a88e0856430d8b65f', '0102012', '广州精品酒店第12号酒店', '', '', 122, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('c489cd0d83b24acaa48320866950e959', '010207', '广州精品酒店第7号酒店', '', '', 117, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('c79c31e54bcf4cbeb63581afb0d9a6cc', '0102019', '广州精品酒店第19号酒店', '', '', 129, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('c7ab7f35c3024fff85ac7fb702e7d8be', '010204', '广州精品酒店第4号酒店', '', '', 114, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('c8a0ba93d57c4c4d929425684778c23e', '0102024', '广州精品酒店第24号酒店', '', '', 134, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('cdb527a3aafa4b9ea4ea22791f79b11e', '0102018', '广州精品酒店第18号酒店', '', '', 128, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('d0bc6dbe766c4e89a005ca19b3cd3265', '010205', '广州精品酒店第5号酒店', '', '', 115, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('d3546fe17cd64b97ab0a8ffba1c9a439', '010200', '广州精品酒店第0号酒店', '', '', 110, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('d35e85bf2c6e48ff853ec85739e91b9c', '010204', '广州精品酒店第4号酒店', '', '', 114, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('d3b3c2db8e4842ed97b12df051010f52', '010201', '广州精品酒店第1号酒店', '', '', 111, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('d3dfab07b1b54b8fb7bb1a5094f70e81', '0102028', '广州精品酒店第28号酒店', '', '', 138, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('d65c4b29538a40bcb1be1cc8775ac280', '0102028', '广州精品酒店第28号酒店', '', '', 138, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('d731b549db0541dbbd9be40abe3a9a88', '0102029', '广州精品酒店第29号酒店', '', '', 139, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('dc8cbe4b171d41738e4be9461e213a7e', '010202', '广州精品酒店第2号酒店', '', '', 112, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('dc9b28c7c04240a0b6e848ec18300a94', '0102022', '广州精品酒店第22号酒店', '', '', 132, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('dd3a87afb8c345eab66abe478b1aefa1', '0102019', '广州精品酒店第19号酒店', '', '', 129, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('df1bf916b3c045cab5d1372030ce48c5', '0102015', '广州精品酒店第15号酒店', '', '', 125, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('e0854de92a9f4232b4e6e9bd06161956', '0102027', '广州精品酒店第27号酒店', '', '', 137, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('e09fe4e8858b4a8ab31f1cb86146d010', '010204', '广州精品酒店第4号酒店', '', '', 114, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('e1f5a98c1d1b4426a6aaabaeed67ce40', '010206', '广州精品酒店第6号酒店', '', '', 116, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('e316b76c2fa443d1a5f6aea32adc12a8', '0102018', '广州精品酒店第18号酒店', '', '', 128, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('e3ed7864ca5a4776879d00bd2231dd50', '0102024', '广州精品酒店第24号酒店', '', '', 134, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('e5b45f8d405a4bd0ab17c08e38bcb853', '0102020', '广州精品酒店第20号酒店', '', '', 130, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('e8834a5364e8493a914e8a5dacb39cbf', '0102017', '广州精品酒店第17号酒店', '', '', 127, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('ebc99f7d440f415b87a42f8635485bf7', '0102011', '广州精品酒店第11号酒店', '', '', 121, 0, 0, '', '', 0, '2019-04-18 03:13:46', '2019-04-18 03:13:46');
INSERT INTO `t_hotel` VALUES ('ebdc7a1d067044c78be0b8cfc68975e2', '0102021', '广州精品酒店第21号酒店', '', '', 131, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('ec2489895a4245d0abde526d4e92f559', '0102012', '广州精品酒店第12号酒店', '', '', 122, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('f0b187f3ac9f4dc9b44f008df4d5dc54', '0102017', '广州精品酒店第17号酒店', '', '', 127, 0, 0, '', '', 0, '2019-04-18 03:18:36', '2019-04-18 03:18:36');
INSERT INTO `t_hotel` VALUES ('f251929e713b4fa59056e3b70f3e2662', '0102010', '广州精品酒店第10号酒店', '', '', 120, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('f2b5737706774d1e986b5ba851306132', '010208', '广州精品酒店第8号酒店', '', '', 118, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
INSERT INTO `t_hotel` VALUES ('f6d0c52afac74aec96d28e1fa277f1b6', '010206', '广州精品酒店第6号酒店', '', '', 116, 0, 0, '', '', 0, '2019-04-18 03:15:48', '2019-04-18 03:15:48');
INSERT INTO `t_hotel` VALUES ('f79577892ed44aaea232419bcafe5921', '010204', '广州精品酒店第4号酒店', '', '', 114, 0, 0, '', '', 0, '2019-04-18 03:19:55', '2019-04-18 03:19:55');
-- ----------------------------
-- Table structure for t_order_room
-- ----------------------------
DROP TABLE IF EXISTS `t_order_room`;
CREATE TABLE `t_order_room` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自增主键',
`number` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
`user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '用户id',
`room_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '房间id',
`start_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '入住时间',
`end_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '离开时间',
`amount` decimal(20, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '交易金额',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`status` smallint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_order_room
-- ----------------------------
INSERT INTO `t_order_room` VALUES ('02362214982242e8adf167c41296d8cf', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-27', 0, '反对撒', 0, '2019-04-21 21:46:29', '2019-04-21 21:46:29');
INSERT INTO `t_order_room` VALUES ('071322ea2f114bb1984541caddb4a66f', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-04', '2019-04-21', 0, '', 0, '2019-04-21 22:02:24', '2019-04-21 22:02:24');
INSERT INTO `t_order_room` VALUES ('0c43ec8947a346b08bf2cdbfc9a90d65', '1020', 'dac00243234949e185370902c636f578', 'c020afd4659947d183c8129049e49f51', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:37:57', '2019-04-21 20:47:53');
INSERT INTO `t_order_room` VALUES ('0d27c365b8454531b7e8fb8c49dafc66', '90907668', '', '4403e023cf5a4379a1dadf58fe5da58a', '2019-04-13', '2019-04-21', 0, '反对撒', 0, '2019-04-21 21:53:07', '2019-04-21 21:53:07');
INSERT INTO `t_order_room` VALUES ('0d9ca8d329084933aeaec3d4552eaad6', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:31:39', '2019-04-16 22:31:39');
INSERT INTO `t_order_room` VALUES ('1329d102b5434f98a73336b02acce1c3', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:44:39', '2019-04-16 22:44:39');
INSERT INTO `t_order_room` VALUES ('1de2f5ff345846e6b85c13929dfff56b', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-12', '2019-04-14', 0, '吧v', 0, '2019-04-21 21:56:55', '2019-04-21 21:56:55');
INSERT INTO `t_order_room` VALUES ('252612613c2042aa89148ebdb56e61ab', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-26', 0, '反对撒', 0, '2019-04-21 21:43:59', '2019-04-21 21:43:59');
INSERT INTO `t_order_room` VALUES ('268d25375eda48b4a17870d588a3f683', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-20', 0, '反对撒', 0, '2019-04-21 21:59:27', '2019-04-21 21:59:27');
INSERT INTO `t_order_room` VALUES ('2c0d6d298963478abadf5fdf835e59e5', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:30:51', '2019-04-16 22:30:51');
INSERT INTO `t_order_room` VALUES ('3777702bd6ef4b27b23c0e3de3547c42', '0.9049778303555669', 'c8fa6515088d4bc1872082458b281ec3', '07b184b88a7445d1929383b8eca1cbbc', '2019-04-06', '2019-04-20', 6199, 'f', 0, '2019-04-24 17:56:38', '2019-04-24 17:56:38');
INSERT INTO `t_order_room` VALUES ('3944995315ce475797bd23dbae5954a8', '0.13786334871681105', '66c5c05305d3445cb32e71afdeedaa23', '20425a3bb42c40f6bd5a687aaf212356', '2019-04-24', '2019-04-26', 5599, '', 0, '2019-04-25 00:52:11', '2019-04-25 00:52:11');
INSERT INTO `t_order_room` VALUES ('52aae8fbc05a493492ab97eeddc12a82', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-27', 0, '反对撒', 0, '2019-04-21 21:45:53', '2019-04-21 21:45:53');
INSERT INTO `t_order_room` VALUES ('54d0c4a2b1ce44b7bf2f36bf43b1c3f0', '0.28564133128011604', '2d14f3e43c604805a9c3b18a1ba92c75', '0ae1e0cb4a2e41a68feb8aa8a2dc5f90', '2019-04-25', '2019-04-25', 8199, 'insert*', 0, '2019-04-25 06:56:49', '2019-04-25 06:56:49');
INSERT INTO `t_order_room` VALUES ('592e27e7b242468099ca71b866967742', '0.6202344427843813', 'e830a36cf81048bfb3648c479e4b3ccd', '07b184b88a7445d1929383b8eca1cbbc', '2019-04-25', '2021-05-29', 6199, '我要住一年', 0, '2019-04-25 00:40:13', '2019-04-25 00:40:13');
INSERT INTO `t_order_room` VALUES ('5d29e849204642049d7ddc140bc761bb', '0.4425312139819423', 'c8fa6515088d4bc1872082458b281ec3', '38ed6a1a562d4343954eb99756474f9c', '2019-04-27', '2019-04-13', 4999, '备注一下', 0, '2019-04-24 17:21:01', '2019-04-24 17:21:01');
INSERT INTO `t_order_room` VALUES ('667fa732127b454498d3aac4890aafac', '0.5154666949359069', '556e52b747c04f628d9a396195789c75', '07b184b88a7445d1929383b8eca1cbbc', '2019-04-11', '2019-04-13', 6199, '', 0, '2019-04-25 18:56:07', '2019-04-25 18:56:07');
INSERT INTO `t_order_room` VALUES ('737b85d8e6a34e5380e2d3b323819433', '0.3577077615276961', 'a39dca5ab0ee49d2861c8b3bd238ea43', '07b184b88a7445d1929383b8eca1cbbc', '2016-12-29', '2019-12-31', 6199, 'hgkhjgb,', 0, '2019-04-25 01:01:59', '2019-04-25 01:01:59');
INSERT INTO `t_order_room` VALUES ('78de6b5b3c0a46cd801e4eecd237b589', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-27', '2019-04-28', 0, '反对撒', 0, '2019-04-21 22:00:40', '2019-04-21 22:00:40');
INSERT INTO `t_order_room` VALUES ('793f219dd27c4d50a5d8a35d722a703e', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-12', '2019-04-14', 0, '吧v', 0, '2019-04-21 21:54:53', '2019-04-21 21:54:53');
INSERT INTO `t_order_room` VALUES ('7acb521630a246d5af363a3b23526d1e', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-05', '2019-04-14', 0, '反对撒', 0, '2019-04-21 21:58:13', '2019-04-21 21:58:13');
INSERT INTO `t_order_room` VALUES ('7b81632a3dfd4ece9231c92cf7fd8b9e', '0.8470651381976871', 'ca402850b37841048552763ee086c5e0', '07b184b88a7445d1929383b8eca1cbbc', '2019-04-19', '2019-04-06', 6199, '', 0, '2019-04-25 17:29:23', '2019-04-25 17:29:23');
INSERT INTO `t_order_room` VALUES ('7c9a2ec738c34818b8ffabcfec2859b8', '0.913710065992266', 'e9761b5333c04bc88730b891873f6f3c', '07b184b88a7445d1929383b8eca1cbbc', '2019-04-01', '2019-03-16', 6199, '', 0, '2019-04-25 00:16:43', '2019-04-25 00:16:43');
INSERT INTO `t_order_room` VALUES ('7c9cee6b37374c33a0a051fb17961b34', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:42:27', '2019-04-16 22:42:27');
INSERT INTO `t_order_room` VALUES ('830bc8b34e1a43de9b8a155e4a1c21ac', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-20', 0, '反对撒', 0, '2019-04-21 22:00:26', '2019-04-21 22:00:26');
INSERT INTO `t_order_room` VALUES ('8ee4ef0109df489194e4ce31d92e270f', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:28:02', '2019-04-16 22:28:02');
INSERT INTO `t_order_room` VALUES ('8fb6ddef5828455b84bbbd73ccd00e91', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-26', 0, '反对撒', 0, '2019-04-21 21:43:56', '2019-04-21 21:43:56');
INSERT INTO `t_order_room` VALUES ('9a6e9ef68507418cb3365f2370a7785e', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-13', '2019-04-21', 0, '吧v', 0, '2019-04-21 21:53:42', '2019-04-21 21:53:42');
INSERT INTO `t_order_room` VALUES ('9ba199934b894b7ab752c223b413e027', '0.2997983979832678', '66c5c05305d3445cb32e71afdeedaa23', '13eda81a106c43929ff83c3f38ae0036', '2018-04-25', '2017-04-25', 5499, '', 0, '2019-04-25 00:50:52', '2019-04-25 00:50:52');
INSERT INTO `t_order_room` VALUES ('9d8cee0d45444bfc89f2294bd1eb8fd9', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-05-02', '2019-04-11', 0, '反对撒', 0, '2019-04-21 21:57:28', '2019-04-21 21:57:28');
INSERT INTO `t_order_room` VALUES ('a45c7f1f95bb4d988f4e79424e454e13', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:27:47', '2019-04-16 22:27:47');
INSERT INTO `t_order_room` VALUES ('a5158839b47f47739584628570e2719e', '0.37211703413698616', '5b86d6ffe8fd43c6afad55147134d50d', '0ae1e0cb4a2e41a68feb8aa8a2dc5f90', '2019-04-25', '2019-04-26', 8199, '', 0, '2019-04-25 08:48:30', '2019-04-25 08:48:30');
INSERT INTO `t_order_room` VALUES ('a738ab42dfcc44759c7eaaff73950ed2', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:27:21', '2019-04-16 22:27:21');
INSERT INTO `t_order_room` VALUES ('a9f55e9afc024a3d9c806681ddb98d01', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:27:36', '2019-04-16 22:27:36');
INSERT INTO `t_order_room` VALUES ('b17c47884de84fd9b0ccb9cf8cce5f8d', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:31:02', '2019-04-16 22:31:02');
INSERT INTO `t_order_room` VALUES ('bb0b5763a73d4fd3acf018bee8bf60b3', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-20', 0, '反对撒', 0, '2019-04-21 21:59:53', '2019-04-21 21:59:53');
INSERT INTO `t_order_room` VALUES ('bc4fde14ab094a3c9d1400704eabc20b', '0.3562957006653874', 'c7cb031100da4f11923aac94c57d8a91', '07b184b88a7445d1929383b8eca1cbbc', '123123-12-12', '123123-12-23', 6199, '123123', 0, '2019-04-25 22:22:00', '2019-04-25 22:22:00');
INSERT INTO `t_order_room` VALUES ('bde25b0e6f774a949775ddc501e2ef1b', '0.5488831042266691', '556e52b747c04f628d9a396195789c75', '07b184b88a7445d1929383b8eca1cbbc', '2019-04-06', '2019-04-06', 6199, '', 0, '2019-04-25 19:57:14', '2019-04-25 19:57:14');
INSERT INTO `t_order_room` VALUES ('be34ef9ec58b41d5b5ffa0fa4578c1b5', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:30:44', '2019-04-16 22:30:44');
INSERT INTO `t_order_room` VALUES ('c069cdb3a1b04386aac7f1c72536979f', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-12', '2019-04-10', 0, '反对撒', 0, '2019-04-21 21:54:19', '2019-04-21 21:54:19');
INSERT INTO `t_order_room` VALUES ('c3dcd1a87394429c9190281b53b74efb', '0.7223806484793669', '3cfe4868ee0742499e44c816ac77467d', '2fb0d35466d64d7e92f4b735e2ebe5ba', '2019-04-14', '2019-04-14', 8799, '12345', 0, '2019-04-25 00:41:19', '2019-04-25 00:41:19');
INSERT INTO `t_order_room` VALUES ('c49dc44a007d4eb59236bf74bb47e89c', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-27', '2019-04-21', 0, '', 0, '2019-04-21 23:13:00', '2019-04-21 23:13:00');
INSERT INTO `t_order_room` VALUES ('c528fa3bb15f456e89e5f47c19b60a3a', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-27', 0, '反对撒', 0, '2019-04-21 21:44:19', '2019-04-21 21:44:19');
INSERT INTO `t_order_room` VALUES ('da1ecaf17d234715a07fc6b5c5699abc', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:29:39', '2019-04-16 22:29:39');
INSERT INTO `t_order_room` VALUES ('dda5af5dd8be42678b90660943d7ae67', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:26:36', '2019-04-16 22:26:36');
INSERT INTO `t_order_room` VALUES ('e6845e89535944b9b51d6df844cdb347', '9096776', 'dac00243234949e185370902c636f578', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-20', 0, '测试用户账号', 0, '2019-04-22 21:50:54', '2019-04-22 21:50:54');
INSERT INTO `t_order_room` VALUES ('ec22635e7a2045179a9dcd20d6e2626e', '9096776', 'dac00243234949e185370902c636f578', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-20', 0, '反对撒', 0, '2019-04-22 21:50:36', '2019-04-22 21:50:36');
INSERT INTO `t_order_room` VALUES ('ed53f460da9f495e8e8577410cba27a2', '1020', '0', '0', '2019-04-16', '2019-04-16', 100, '', 0, '2019-04-16 22:08:59', '2019-04-16 22:08:59');
INSERT INTO `t_order_room` VALUES ('f2ba2b2cd0e54e46a0f531b33f499c44', '0.07710069484702797', '139e1cc8c6bd4fa1a2d01ee2b6ef5ff5', '07b184b88a7445d1929383b8eca1cbbc', '2019-04-26', '2019-04-26', 6199, '', 0, '2019-04-25 00:54:52', '2019-04-25 00:54:52');
INSERT INTO `t_order_room` VALUES ('f5f9c83df44843a4a60bd8cb4824b6f6', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-28', 0, '反对撒', 0, '2019-04-21 21:47:49', '2019-04-21 21:47:49');
INSERT INTO `t_order_room` VALUES ('f66fe85eff7e41d58a6ffead7d27aaab', '90907668', '', '4403e023cf5a4379a1dadf58fe5da58a', '2019-04-07', '2019-04-21', 0, '第三个订单', 0, '2019-04-22 21:35:15', '2019-04-22 21:35:15');
INSERT INTO `t_order_room` VALUES ('f80dac69de004402a858f48ca437d788', '9096776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-20', '2019-04-18', 0, '第二个订单', 0, '2019-04-22 21:34:59', '2019-04-22 21:34:59');
INSERT INTO `t_order_room` VALUES ('fb302efc1c8d421aba7ee9ccafdd0f42', '9092776', '', '38ed6a1a562d4343954eb99756474f9c', '2019-04-21', '2019-04-26', 0, '反对撒', 0, '2019-04-21 21:42:13', '2019-04-21 21:42:13');
INSERT INTO `t_order_room` VALUES ('fe3f2c8175104e47b3702c48cd805f24', '9096776', 'dac00243234949e185370902c636f578', '38ed6a1a562d4343954eb99756474f9c', '2019-04-05', '2019-04-21', 4999, '反对撒', 0, '2019-04-23 05:24:25', '2019-04-23 05:24:25');
-- ----------------------------
-- Table structure for t_order_serv
-- ----------------------------
DROP TABLE IF EXISTS `t_order_serv`;
CREATE TABLE `t_order_serv` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`number` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
`serv_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '服务id',
`user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '服务用户id',
`room_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '服务房间id',
`start_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '服务开始时间',
`end_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '服务结束时间',
`status` smallint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`remark` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE,
INDEX `fk`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_pictrue
-- ----------------------------
DROP TABLE IF EXISTS `t_pictrue`;
CREATE TABLE `t_pictrue` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`status` smallint(1) UNSIGNED NOT NULL COMMENT '状态',
`pictrue` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`author_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_pictrue
-- ----------------------------
INSERT INTO `t_pictrue` VALUES ('1', 1, '', '', '2019-04-19 18:28:18', '2019-04-19 18:28:18');
-- ----------------------------
-- Table structure for t_remark
-- ----------------------------
DROP TABLE IF EXISTS `t_remark`;
CREATE TABLE `t_remark` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主键',
`user_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '用户名',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论',
`status` smallint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_remark
-- ----------------------------
INSERT INTO `t_remark` VALUES ('', '黄钰朝', '第一条留言', 0, '2019-04-23 05:17:59', '2019-04-24 16:20:53');
INSERT INTO `t_remark` VALUES ('00df4ae8e7bf4565a61aa0465e3468c9', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:03', '2019-04-25 22:31:03');
INSERT INTO `t_remark` VALUES ('011eb6281c1b4881ad45b63f6a86a165', 'xiaopan(默认昵称)', '实现', 0, '2019-04-25 20:39:42', '2019-04-25 20:39:42');
INSERT INTO `t_remark` VALUES ('0312bbe907024a3688810508ca3ee3c1', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:53', '2019-04-25 22:30:53');
INSERT INTO `t_remark` VALUES ('04d1ef2049324ca3939023249fffd8d7', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:06', '2019-04-25 22:31:06');
INSERT INTO `t_remark` VALUES ('0771e082e71a4385a6cfafe83af82231', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:53', '2019-04-25 22:30:53');
INSERT INTO `t_remark` VALUES ('07b7c090ec8a44e4a7c8cc89bd145942', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:45', '2019-04-25 22:39:45');
INSERT INTO `t_remark` VALUES ('07d0337f4049450c947116e6841f1c7b', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:04', '2019-04-25 22:31:04');
INSERT INTO `t_remark` VALUES ('08dd3c4c7e37411384a879d71c276394', 'xiaopan(默认昵称)', '全明制作人的影迷大家好，我是练习时长两年半的个人练习生曾彦祖，喜欢唱、跳、rap、篮球。music', 0, '2019-04-25 18:55:45', '2019-04-25 18:55:45');
INSERT INTO `t_remark` VALUES ('08fc7656f6e343c9bb1485281e17114c', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:30:48', '2019-04-25 22:30:48');
INSERT INTO `t_remark` VALUES ('096bd642ba44494e9f8076b69a514db9', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:06', '2019-04-25 22:31:06');
INSERT INTO `t_remark` VALUES ('0bf5e6cd63a0420a94f05ae98afc4a5e', '123112(biger)', '.', 0, '2019-04-25 22:37:20', '2019-04-25 22:37:20');
INSERT INTO `t_remark` VALUES ('0bff6bd4b2af42d392611d7623bafb42', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:32:24', '2019-04-25 22:32:24');
INSERT INTO `t_remark` VALUES ('0e937fd191e2438b90453e36da452de6', '123112(biger)', '.', 0, '2019-04-25 22:38:11', '2019-04-25 22:38:11');
INSERT INTO `t_remark` VALUES ('0edd5cf805c446be95caa5c79a7aadbd', '123112(biger)', '101220', 0, '2019-04-25 22:47:17', '2019-04-25 22:47:17');
INSERT INTO `t_remark` VALUES ('1', 'cxk(徐坤粉丝团)', '牛逼，看到陈宇大佬了', 0, '2019-04-25 00:24:04', '2019-04-25 00:24:04');
INSERT INTO `t_remark` VALUES ('10474519c49f43ab85d0fb0ab1dfde20', '222222(默认昵称)', '', 0, '2019-04-25 01:16:39', '2019-04-25 01:16:39');
INSERT INTO `t_remark` VALUES ('109090758bce4f619b3c791d891d254b', '123112(biger)', '1', 0, '2019-04-25 22:45:01', '2019-04-25 22:45:01');
INSERT INTO `t_remark` VALUES ('114c2ee4b0784b99afca3f29e6f314b3', '123112(biger)', '1', 0, '2019-04-25 22:45:11', '2019-04-25 22:45:11');
INSERT INTO `t_remark` VALUES ('157d78e87b704f71844b668fc15165f6', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:33:53', '2019-04-25 22:33:53');
INSERT INTO `t_remark` VALUES ('1793faff5f6d42f79b0f9ec8ca28da0b', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:36:32', '2019-04-25 22:36:32');
INSERT INTO `t_remark` VALUES ('1846947ce7e448f6a51c60de235774e7', '123112(biger)', '.', 0, '2019-04-25 22:30:47', '2019-04-25 22:30:47');
INSERT INTO `t_remark` VALUES ('1888b7628b894552b73d2414d6a650a9', '123112(biger)', '.', 0, '2019-04-25 22:36:22', '2019-04-25 22:36:22');
INSERT INTO `t_remark` VALUES ('18fe595529164af091a55b1f26d1bb26', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:05', '2019-04-25 22:31:05');
INSERT INTO `t_remark` VALUES ('19c3a92bb5d54bcab3352a58b7becdf9', '123112(biger)', '.', 0, '2019-04-25 22:37:30', '2019-04-25 22:37:30');
INSERT INTO `t_remark` VALUES ('19e2235db7964f6cbf96846f04a0b558', 'ikun9527(默认昵称)', '律师函警告。。。', 0, '2019-04-25 22:15:03', '2019-04-25 22:15:03');
INSERT INTO `t_remark` VALUES ('1c021838269b4f73ba367d66c734fd07', '123112(biger)', '.', 0, '2019-04-25 22:28:01', '2019-04-25 22:28:01');
INSERT INTO `t_remark` VALUES ('1cbe392831854bdab6c360256a248993', '222222(默认昵称)', 'wwww', 0, '2019-04-25 01:15:35', '2019-04-25 01:15:35');
INSERT INTO `t_remark` VALUES ('1d8c1aa8744a452ca2b95daca01a019b', '123112(biger)', '.', 0, '2019-04-25 22:26:19', '2019-04-25 22:26:19');
INSERT INTO `t_remark` VALUES ('1f243831490d443aaf846dbed9f6a2b3', 'caixukun123(默认昵称)', '{remark:手机虎扑|虎扑客户端|关注虎扑欢迎访问虎扑，请先注册或者登录NBA虎扑首页|NBA|CBA|电竞|国际足球|中国足球|赛车|装备|识货|社区|步行街|路人王|更多首页|新闻|比赛中心|赛程|球队|选秀|百科|街球|NBA论坛利拉德，已经是世界第一等！利拉德被低估了的实力和决心。勇士的傲慢让自己坐实了反派角色勇士为什么就能被揍成这样？利拉德，', 0, '2019-04-25 22:34:33', '2019-04-25 22:34:33');
INSERT INTO `t_remark` VALUES ('2', '黄钰朝', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2049-04-25 00:30:42', '2019-04-25 01:08:57');
INSERT INTO `t_remark` VALUES ('202de34611bd427d866bc9ccfe8aca90', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:38:36', '2019-04-25 22:38:36');
INSERT INTO `t_remark` VALUES ('20cb9dbe71224eb0b860e8a7fce68b2d', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:07', '2019-04-25 22:31:07');
INSERT INTO `t_remark` VALUES ('20e43bb7577f4154afb863b4b4e616c5', 'caixukun123(默认昵称)', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:26:30', '2019-04-25 22:26:30');
INSERT INTO `t_remark` VALUES ('20e966c4ced74d6ebebad81445ec4cb8', '123112(biger)', '.', 0, '2019-04-25 22:26:28', '2019-04-25 22:26:28');
INSERT INTO `t_remark` VALUES ('228bb8586b8e4b2e938eca135e034e73', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:37:37', '2019-04-25 22:37:37');
INSERT INTO `t_remark` VALUES ('2609ab95392040a6b64831bdee55a0e6', '123112(biger)', '.', 0, '2019-04-25 22:26:11', '2019-04-25 22:26:11');
INSERT INTO `t_remark` VALUES ('262886309b87461db89f1a2256f479c8', '123112(biger)', '1', 0, '2019-04-25 22:47:10', '2019-04-25 22:47:10');
INSERT INTO `t_remark` VALUES ('28d2fb47d3a345e08e05646aaf6db2fd', 'huangyuchao123(默认昵称)', '留言警告', 0, '2019-04-25 00:43:04', '2019-04-25 00:43:04');
INSERT INTO `t_remark` VALUES ('2a45e1ba090e43448d55db0b4052652c', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:04', '2019-04-25 22:31:04');
INSERT INTO `t_remark` VALUES ('2a924a7e8e2b4d569d119aef2ad2fd47', '123112(biger)', '.', 0, '2019-04-25 22:38:01', '2019-04-25 22:38:01');
INSERT INTO `t_remark` VALUES ('2c0bff5126e2465db21268f0027a8cce', '123112(biger)', '1', 0, '2019-04-25 22:44:59', '2019-04-25 22:44:59');
INSERT INTO `t_remark` VALUES ('2d1198d207584f22b27a2e457aabe148', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:38:45', '2019-04-25 22:38:45');
INSERT INTO `t_remark` VALUES ('2e0201e2097a4563a43b23766c90a94d', 'xiaopan(默认昵称)', '实现', 0, '2019-04-25 20:32:29', '2019-04-25 20:32:29');
INSERT INTO `t_remark` VALUES ('2e9d8b4bfbf04166acb341e8e90daab4', '123112(biger)', '.', 0, '2019-04-25 22:26:25', '2019-04-25 22:26:25');
INSERT INTO `t_remark` VALUES ('2f3326372bef435ebcc961fa0fadd62b', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:37:36', '2019-04-25 22:37:36');
INSERT INTO `t_remark` VALUES ('30beacafdbbe4dbe880d3e6fa40c8d42', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:42', '2019-04-25 22:39:42');
INSERT INTO `t_remark` VALUES ('32f7fca585ca449382b8210664cf0b61', 'caixukun123(默认昵称)', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:25:42', '2019-04-25 22:25:42');
INSERT INTO `t_remark` VALUES ('33f7665fd3974b38a334a21fa4cc1bbd', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:55', '2019-04-25 22:30:55');
INSERT INTO `t_remark` VALUES ('36e71d4079104625848ee60d6de44cac', '123112(biger)', '1', 0, '2019-04-25 22:45:07', '2019-04-25 22:45:07');
INSERT INTO `t_remark` VALUES ('396f88f2976f4e849901aa437c07579d', 'woshichenyu(默认昵称)', '我是陈宇，前排留名', 0, '2019-04-25 00:16:06', '2019-04-25 00:16:06');
INSERT INTO `t_remark` VALUES ('3b57fa61347940f8a82d54b249b3a0e8', 'Cerbur(默认昵称)', 'cerbur.club', 0, '2019-04-25 00:22:04', '2019-04-25 00:22:04');
INSERT INTO `t_remark` VALUES ('3b9c13f4acc7412e978d86e7d4dc214e', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:02', '2019-04-25 22:31:02');
INSERT INTO `t_remark` VALUES ('3ea6f49474dd48c69ab36e8252d7814d', '123112(biger)', '.', 0, '2019-04-25 22:26:07', '2019-04-25 22:26:07');
INSERT INTO `t_remark` VALUES ('3f57b8a6a04540218fc9bead446112dd', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:38:40', '2019-04-25 22:38:40');
INSERT INTO `t_remark` VALUES ('41a955b65a3c4831a446fa943741e887', 'caixukun123(默认昵称)', '{remark:手机虎扑|虎扑客户端|关注虎扑欢迎访问虎扑，请先注册或者登录NBA虎扑首页|NBA|CBA|电竞|国际足球|中国足球|赛车|装备|识货|社区|步行街|路人王|更多首页|新闻|比赛中心|赛程|球队|选秀|百科|街球|NBA论坛利拉德，已经是世界第一等！利拉德被低估了的实力和决心。勇士的傲慢让自己坐实了反派角色勇士为什么就能被揍成这样？利拉德，', 0, '2019-04-25 22:36:23', '2019-04-25 22:36:23');
INSERT INTO `t_remark` VALUES ('41f378ef5ea149caa1cfda747b1b67d1', '123112(biger)', '.', 0, '2019-04-25 22:26:21', '2019-04-25 22:26:21');
INSERT INTO `t_remark` VALUES ('424a71b4ff0741f5a17863b9e7eb97b0', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:38:19', '2019-04-25 22:38:19');
INSERT INTO `t_remark` VALUES ('4716dd938f564757a025e2e4b35bb470', '123112(biger)', '1', 0, '2019-04-25 22:44:58', '2019-04-25 22:44:58');
INSERT INTO `t_remark` VALUES ('47c3daa8ded84978b5612e7be4932944', 'xiaopan(默认昵称)', '？？？？', 0, '2019-04-25 20:35:23', '2019-04-25 20:35:23');
INSERT INTO `t_remark` VALUES ('4a4511b578c64080b18f18c5e6e40f2f', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:54', '2019-04-25 22:30:54');
INSERT INTO `t_remark` VALUES ('4ea82579a0a34b408068aa844d0a73eb', '123112(biger)', '.', 0, '2019-04-25 22:26:18', '2019-04-25 22:26:18');
INSERT INTO `t_remark` VALUES ('50ca2c80c1f746b68790ee92d06bb107', '123112(biger)', '.', 0, '2019-04-25 22:36:56', '2019-04-25 22:36:56');
INSERT INTO `t_remark` VALUES ('529c7c029b63413aa72ee1430c259359', '123112(biger)', '1', 0, '2019-04-25 22:44:54', '2019-04-25 22:44:54');
INSERT INTO `t_remark` VALUES ('5392159238d94391907fec4898314565', '123112(biger)', '1', 0, '2019-04-25 22:43:41', '2019-04-25 22:43:41');
INSERT INTO `t_remark` VALUES ('55034ff7c84c438ea3f3dfe4248c6314', '123112(biger)', '.', 0, '2019-04-25 22:31:02', '2019-04-25 22:31:02');
INSERT INTO `t_remark` VALUES ('57685f8b25f34c168deb3e123cb3d31e', '222222(默认昵称)', '', 0, '2019-04-25 01:16:48', '2019-04-25 01:16:48');
INSERT INTO `t_remark` VALUES ('5873e848a2b74587892bbbbb356c1ca4', 'caixukun123(默认昵称)', '{remark:手机虎扑|虎扑客户端|关注虎扑欢迎访问虎扑，请先注册或者登录NBA虎扑首页|NBA|CBA|电竞|国际足球|中国足球|赛车|装备|识货|社区|步行街|路人王|更多首页|新闻|比赛中心|赛程|球队|选秀|百科|街球|NBA论坛利拉德，已经是世界第一等！利拉德被低估了的实力和决心。勇士的傲慢让自己坐实了反派角色勇士为什么就能被揍成这样？利拉德，', 0, '2019-04-25 22:34:38', '2019-04-25 22:34:38');
INSERT INTO `t_remark` VALUES ('5cc5a7b491854dc4892293607ec94526', '123112(biger)', '.', 0, '2019-04-25 22:26:08', '2019-04-25 22:26:08');
INSERT INTO `t_remark` VALUES ('5df79fa383d0460b97765d5cfecbf84c', '123112(biger)', '.', 0, '2019-04-25 22:37:52', '2019-04-25 22:37:52');
INSERT INTO `t_remark` VALUES ('60ec558bcc384be48c0e0e878fb97cd0', 'xiaopan(默认昵称)', '实现', 0, '2019-04-25 20:46:15', '2019-04-25 20:46:15');
INSERT INTO `t_remark` VALUES ('61c4f6ce1c454cbbb5b2271d6d6cfd17', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:42', '2019-04-25 22:39:42');
INSERT INTO `t_remark` VALUES ('637c24bb165a431d9a511eeca5b747bf', '123112(biger)', '.', 0, '2019-04-25 22:26:22', '2019-04-25 22:26:22');
INSERT INTO `t_remark` VALUES ('64d209f9586f40298283d353cd69532a', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:57', '2019-04-25 22:30:57');
INSERT INTO `t_remark` VALUES ('64e54a2ace724805a46ec100bf468673', '123112(biger)', '.', 0, '2019-04-25 22:26:05', '2019-04-25 22:26:05');
INSERT INTO `t_remark` VALUES ('6699216f44314e2291f74b96488a3581', 'caixukun123(默认昵称)', '{remark:手机虎扑|虎扑客户端|关注虎扑欢迎访问虎扑，请先注册或者登录NBA虎扑首页|NBA|CBA|电竞|国际足球|中国足球|赛车|装备|识货|社区|步行街|路人王|更多首页|新闻|比赛中心|赛程|球队|选秀|百科|街球|NBA论坛利拉德，已经是世界第一等！利拉德被低估了的实力和决心。勇士的傲慢让自己坐实了反派角色勇士为什么就能被揍成这样？利拉德，', 0, '2019-04-25 22:36:19', '2019-04-25 22:36:19');
INSERT INTO `t_remark` VALUES ('674ea0da4311472aace304fafbd6d93c', '123112(biger)', '1', 0, '2019-04-25 22:45:04', '2019-04-25 22:45:04');
INSERT INTO `t_remark` VALUES ('6805fffbe9c64036b44b20762b7c4a80', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:36:43', '2019-04-25 22:36:43');
INSERT INTO `t_remark` VALUES ('6a6b54eee4924df087d24906f739e6a7', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:07', '2019-04-25 22:31:07');
INSERT INTO `t_remark` VALUES ('6d9c6e87661b49c69520873bb6d09283', '123112(biger)', '.', 0, '2019-04-25 22:26:15', '2019-04-25 22:26:15');
INSERT INTO `t_remark` VALUES ('6e448430a62d4250a24d62ad8bc24a24', '123112(biger)', '.', 0, '2019-04-25 22:36:19', '2019-04-25 22:36:19');
INSERT INTO `t_remark` VALUES ('6e88bc9d86cf4bba8654d077b8076edb', '123112(biger)', '.', 0, '2019-04-25 22:30:49', '2019-04-25 22:30:49');
INSERT INTO `t_remark` VALUES ('6e9032d61f06439bbec245cfa4279ca0', 'wzm1742415101(默认昵称)', 'hyc真帅。', 0, '2019-04-25 22:42:12', '2019-04-25 22:42:12');
INSERT INTO `t_remark` VALUES ('6f83a3d5ab21446f9c60c7233ec14ef6', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:01', '2019-04-25 22:31:01');
INSERT INTO `t_remark` VALUES ('6fbdf901254346f99ab7d0ef12dac916', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:04', '2019-04-25 22:31:04');
INSERT INTO `t_remark` VALUES ('7108f5e9b5994659892bf30e5f5ded3c', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:03', '2019-04-25 22:31:03');
INSERT INTO `t_remark` VALUES ('722465ddefb7401385192dc96304ac85', '123112(biger)', '.', 0, '2019-04-25 22:31:09', '2019-04-25 22:31:09');
INSERT INTO `t_remark` VALUES ('72f5e4eabebd49f59e228e0af577a9b3', '123112(biger)', '1', 0, '2019-04-25 22:47:00', '2019-04-25 22:47:00');
INSERT INTO `t_remark` VALUES ('749bef7efaf94f2380a848cfcd6a6bbd', '123112(biger)', '.', 0, '2019-04-25 22:26:03', '2019-04-25 22:26:03');
INSERT INTO `t_remark` VALUES ('7536539bd22a438480de08d696fa810c', '123112(biger)', '.', 0, '2019-04-25 22:26:20', '2019-04-25 22:26:20');
INSERT INTO `t_remark` VALUES ('756405a96197444ba20a19e831610717', '123112(biger)', '.', 0, '2019-04-25 22:30:59', '2019-04-25 22:30:59');
INSERT INTO `t_remark` VALUES ('7d76791122e24fbc946f5f967a991cac', 'xiaopan(默认昵称)', '？？？', 0, '2019-04-25 12:12:22', '2019-04-25 12:12:22');
INSERT INTO `t_remark` VALUES ('7d9d2d86dc23450d86a77515066dce14', 'caixukun123(默认昵称)', '1大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:30:45', '2019-04-25 22:30:45');
INSERT INTO `t_remark` VALUES ('7ee4a334a2404f219388e2ec1fe492c0', '987654(朗朗)', '123', 0, '2019-04-25 00:38:23', '2019-04-25 00:38:23');
INSERT INTO `t_remark` VALUES ('7efd6d682cdb42d8a1a677d6a6dc750c', 'caixukun(默认昵称)', '666', 0, '2019-04-25 21:45:56', '2019-04-25 21:45:56');
INSERT INTO `t_remark` VALUES ('802ec79107f342809a4c41519153e9b3', 'xiaopan(默认昵称)', '实现', 0, '2019-04-25 20:39:21', '2019-04-25 20:39:21');
INSERT INTO `t_remark` VALUES ('835743a6b1104332b3d20946f42c260c', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:54', '2019-04-25 22:30:54');
INSERT INTO `t_remark` VALUES ('84153648327948c7904029e7ce89a0e1', 'caixukun123(默认昵称)', '{remark:手机虎扑|虎扑客户端|关注虎扑欢迎访问虎扑，请先注册或者登录NBA虎扑首页|NBA|CBA|电竞|国际足球|中国足球|赛车|装备|识货|社区|步行街|路人王|更多首页|新闻|比赛中心|赛程|球队|选秀|百科|街球|NBA论坛利拉德，已经是世界第一等！利拉德被低估了的实力和决心。勇士的傲慢让自己坐实了反派角色勇士为什么就能被揍成这样？利拉德，', 0, '2019-04-25 22:34:24', '2019-04-25 22:34:24');
INSERT INTO `t_remark` VALUES ('860e6e55a65644d79b4bec9d9920341e', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:37:52', '2019-04-25 22:37:52');
INSERT INTO `t_remark` VALUES ('8636c9067c3b4959926d8727c257bfbd', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:46', '2019-04-25 22:30:46');
INSERT INTO `t_remark` VALUES ('866a4d56bebd40dc82ef2518a9c52eda', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:06', '2019-04-25 22:31:06');
INSERT INTO `t_remark` VALUES ('86f754c8fae84443b64a8fa9ccb35029', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:44', '2019-04-25 22:39:44');
INSERT INTO `t_remark` VALUES ('8821d67f470c41559d914d53be195871', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:33:55', '2019-04-25 22:33:55');
INSERT INTO `t_remark` VALUES ('89f680a56fa848d29f67f44a41f6c03b', 'caixukun123(默认昵称)', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:26:34', '2019-04-25 22:26:34');
INSERT INTO `t_remark` VALUES ('8a4b37f29e144afaa46ad52f0599f281', '123112(biger)', '.', 0, '2019-04-25 22:26:10', '2019-04-25 22:26:10');
INSERT INTO `t_remark` VALUES ('8d41ccfca4184f4ba8c8f5e0cfac0ac3', '123112(biger)', '.', 0, '2019-04-25 22:26:41', '2019-04-25 22:26:41');
INSERT INTO `t_remark` VALUES ('8ee263279617487e8ccacfb4f45528bc', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:36:31', '2019-04-25 22:36:31');
INSERT INTO `t_remark` VALUES ('8f1b9dfba35b4a758c9081b04b0d7779', 'caixukun123(默认昵称)', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:26:28', '2019-04-25 22:26:28');
INSERT INTO `t_remark` VALUES ('90c3eb476ef143e58d90adee9cce9634', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:59', '2019-04-25 22:30:59');
INSERT INTO `t_remark` VALUES ('9243e3ff899145cdb13218f739b356f1', '123112(biger)', '.', 0, '2019-04-25 22:36:44', '2019-04-25 22:36:44');
INSERT INTO `t_remark` VALUES ('9700e132ba2c42ed8df70fab6e50a086', '123112(biger)', '1', 0, '2019-04-25 22:45:15', '2019-04-25 22:45:15');
INSERT INTO `t_remark` VALUES ('98223d82973245a88b608fb7cfdf1342', '123112(biger)', '.', 0, '2019-04-25 22:31:00', '2019-04-25 22:31:00');
INSERT INTO `t_remark` VALUES ('982a98bc347f4452acde920ca4fb25ec', '123112(biger)', '.', 0, '2019-04-25 22:26:12', '2019-04-25 22:26:12');
INSERT INTO `t_remark` VALUES ('9b13b0490bf9413e98bd5603cda045a0', '123112(biger)', '.', 0, '2019-04-25 22:36:24', '2019-04-25 22:36:24');
INSERT INTO `t_remark` VALUES ('9c60cda3f72c4e5cb05645e70bdff114', '123112(biger)', '.', 0, '2019-04-25 22:30:51', '2019-04-25 22:30:51');
INSERT INTO `t_remark` VALUES ('9cdd1ce141ed4a7cbdfca46507e5f9b9', '黄钰朝', '测试远程服务器中。。。', 0, '2019-04-24 14:24:51', '2019-04-24 16:20:46');
INSERT INTO `t_remark` VALUES ('9fa38afc1df6480a9568fc76c947f82c', '222222(默认昵称)', '现在真的可以玩耍了，刚刚跑去笔试，没同步数据库，崩了现在真的可以玩耍了，刚刚跑去笔试，没同步数据库，崩了现在真的可以玩耍了，刚刚跑去笔试，没同步数据库，崩了现在真的可以玩耍了，刚刚跑去笔试，没同步数据库，崩了现在真的可以玩耍了，刚刚跑去笔试，没同步数据库，崩了现在真的可以玩耍了，刚刚跑去笔试，没同步数据库，崩了现在真的可以玩耍了，刚刚跑去笔试，没同步数据库，崩了现在真的可以玩耍了，刚刚跑去笔试，没', 0, '2019-04-25 01:14:38', '2019-04-25 01:14:38');
INSERT INTO `t_remark` VALUES ('a3d9c278cae24472947f1e9f6e88fb66', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:36:45', '2019-04-25 22:36:45');
INSERT INTO `t_remark` VALUES ('a4e0f59bf2f34462b94376f8ac84c04c', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:57', '2019-04-25 22:30:57');
INSERT INTO `t_remark` VALUES ('a83a97f603f14fe1b877dc3960e5e671', 'woshiyuqidalao(默认昵称)', '我是煜淇大佬，前来观摩', 0, '2019-04-25 08:45:15', '2019-04-25 08:45:15');
INSERT INTO `t_remark` VALUES ('a99c9d0f766c448bb5503eeb50706b30', 'caixukun123(默认昵称)', '{remark:手机虎扑|虎扑客户端|关注虎扑欢迎访问虎扑，请先注册或者登录NBA虎扑首页|NBA|CBA|电竞|国际足球|中国足球|赛车|装备|识货|社区|步行街|路人王|更多首页|新闻|比赛中心|赛程|球队|选秀|百科|街球|NBA论坛利拉德，已经是世界第一等！利拉德被低估了的实力和决心。勇士的傲慢让自己坐实了反派角色勇士为什么就能被揍成这样？利拉德，', 0, '2019-04-25 22:36:30', '2019-04-25 22:36:30');
INSERT INTO `t_remark` VALUES ('aa7179750a9647ae8f94290f6dabc931', '123112(biger)', '1', 0, '2019-04-25 22:47:02', '2019-04-25 22:47:02');
INSERT INTO `t_remark` VALUES ('ac3690df93c0416b9897c9485c6e4fc1', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:56', '2019-04-25 22:39:56');
INSERT INTO `t_remark` VALUES ('b2c0b75895f94f1eb7a143597dfffe2b', '123112(biger)', '1', 0, '2019-04-25 22:45:09', '2019-04-25 22:45:09');
INSERT INTO `t_remark` VALUES ('b3666d79c59c4757ac9bc9f57c2378f3', 'caixukun123(默认昵称)', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:26:28', '2019-04-25 22:26:28');
INSERT INTO `t_remark` VALUES ('b6d01dba52ae47fbba4e4fc4ea43b233', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:38:51', '2019-04-25 22:38:51');
INSERT INTO `t_remark` VALUES ('b78a0c10baca4534ab977af97d952633', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:36:47', '2019-04-25 22:36:47');
INSERT INTO `t_remark` VALUES ('b7dfb730ee0440129865e7928ae7480b', '123112(biger)', '1', 0, '2019-04-25 22:44:56', '2019-04-25 22:44:56');
INSERT INTO `t_remark` VALUES ('ba57cad421794022b482c80cccb4e8b8', '123112(biger)', '.', 0, '2019-04-25 22:38:03', '2019-04-25 22:38:03');
INSERT INTO `t_remark` VALUES ('bb49ffd52a3845acbbba67351720099a', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:00', '2019-04-25 22:31:00');
INSERT INTO `t_remark` VALUES ('bc182bd91123418e83fc6082348fe357', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:02', '2019-04-25 22:31:02');
INSERT INTO `t_remark` VALUES ('be81b02a1cbd414bb10abfe468d708d4', '222222(默认昵称)', '', 0, '2019-04-25 01:16:25', '2019-04-25 01:16:25');
INSERT INTO `t_remark` VALUES ('bef39da7cc1d49bea2515e481e9492d1', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:56', '2019-04-25 22:30:56');
INSERT INTO `t_remark` VALUES ('c14e018919f243e7aa3c80473b91df47', 'xiaopan(默认昵称)', '全明制作人的影迷大家好，我是练习时长两年半的个人练习生曾彦祖，喜欢唱、跳、rap、篮球。music', 0, '2019-04-25 12:10:26', '2019-04-25 12:10:26');
INSERT INTO `t_remark` VALUES ('c1cd1a237bfd443f850102427673bb94', 'a1179374184(默认昵称)', '这房子好贵', 0, '2019-04-25 00:55:18', '2019-04-25 00:55:18');
INSERT INTO `t_remark` VALUES ('c38b63dddb7e4bad83cccaae96908e28', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:00', '2019-04-25 22:31:00');
INSERT INTO `t_remark` VALUES ('c39df814ae5c4508b5b2907cb3241ba5', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:33:51', '2019-04-25 22:33:51');
INSERT INTO `t_remark` VALUES ('c4dc714aa0804e81bfc63befa42ebba7', '987654(默认昵称)', '大学生陈宇前来报到', 0, '2019-04-25 00:28:41', '2019-04-25 00:28:41');
INSERT INTO `t_remark` VALUES ('c54b0bb509f54ef7a5dc25924e4f44d6', 'xiaopan(默认昵称)', '实现', 0, '2019-04-25 20:39:37', '2019-04-25 20:39:37');
INSERT INTO `t_remark` VALUES ('c6f21f8e5c2f4b0bb2e4195aebd2f79a', '123456(默认昵称)', ';rm-rf/;', 0, '2019-04-25 21:57:13', '2019-04-25 21:57:13');
INSERT INTO `t_remark` VALUES ('ca03c517080948e799883dafb7c0c5a5', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:32:30', '2019-04-25 22:32:30');
INSERT INTO `t_remark` VALUES ('cadda994bec446bea3b329109d69f644', '123112(biger)', '.', 0, '2019-04-25 22:30:46', '2019-04-25 22:30:46');
INSERT INTO `t_remark` VALUES ('cb6378750cbd4696add073fb527a1826', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:33:48', '2019-04-25 22:33:48');
INSERT INTO `t_remark` VALUES ('cc9ff526d8f543c3be74c90b65deddce', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:41', '2019-04-25 22:30:41');
INSERT INTO `t_remark` VALUES ('cf2c4a14fdaf47b2bdbef6011568f813', '蔡徐坤', '大家好，我是练习时长两年半的个人练习生蔡徐坤', 0, '2019-04-24 16:32:31', '2019-04-25 01:08:53');
INSERT INTO `t_remark` VALUES ('d24ffde8db6348e4bc8d046eabdac5be', 'caixukun123(默认昵称)', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:30:24', '2019-04-25 22:30:24');
INSERT INTO `t_remark` VALUES ('d492c9980e544fb283dfabe2e1c11b0b', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:30:49', '2019-04-25 22:30:49');
INSERT INTO `t_remark` VALUES ('d58682ae7ce9451faea879ff3d5d9f0c', '123112(biger)', '.', 0, '2019-04-25 22:38:00', '2019-04-25 22:38:00');
INSERT INTO `t_remark` VALUES ('d71d038cf5b9421d8add3ff35190cbe6', 'chencile(默认昵称)', '啊，钰朝大佬牛逼', 0, '2019-04-25 21:52:55', '2019-04-25 21:52:55');
INSERT INTO `t_remark` VALUES ('d74b736dd2264d088394f229a06a39ad', 'wzm1742415101(默认昵称)', '这东西真好用', 0, '2019-04-25 22:42:25', '2019-04-25 22:42:25');
INSERT INTO `t_remark` VALUES ('d820f584553f4853af14379df2abdfd8', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:07', '2019-04-25 22:31:07');
INSERT INTO `t_remark` VALUES ('d9167c37a12c46cc82af9566bebd41bc', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:57', '2019-04-25 22:30:57');
INSERT INTO `t_remark` VALUES ('d9fb9ed3741342f086dfca0e70ee63af', '123112(biger)', '.', 0, '2019-04-25 22:37:56', '2019-04-25 22:37:56');
INSERT INTO `t_remark` VALUES ('daabb8cf130b4871a66c205b7f9e3bc1', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:57', '2019-04-25 22:39:57');
INSERT INTO `t_remark` VALUES ('db79d3b773ce443dbadda2643d1e0263', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:52', '2019-04-25 22:30:52');
INSERT INTO `t_remark` VALUES ('dcde480c1a544ca7a45115f520b5e3a5', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:36:46', '2019-04-25 22:36:46');
INSERT INTO `t_remark` VALUES ('dd15a460fad24331b77f6fbc090a6e9e', 'caixukun123(默认昵称)', '11', 0, '2019-04-25 22:31:00', '2019-04-25 22:31:00');
INSERT INTO `t_remark` VALUES ('dd377078264041d4b8d683313b18bd9d', 'xiaopan(默认昵称)', '？？？', 0, '2019-04-25 12:30:01', '2019-04-25 12:30:01');
INSERT INTO `t_remark` VALUES ('dde36a6c0a324ba89c4a950f13cdb3c1', '123112(biger)', '.', 0, '2019-04-25 22:26:23', '2019-04-25 22:26:23');
INSERT INTO `t_remark` VALUES ('ddedfcd85e434f50a90f29635b84b5d0', 'caixukun(默认昵称)', '第一', 0, '2019-04-25 21:45:43', '2019-04-25 21:45:43');
INSERT INTO `t_remark` VALUES ('e0b7951488d2450b959564853e73edb1', '123112(biger)', '.', 0, '2019-04-25 22:26:04', '2019-04-25 22:26:04');
INSERT INTO `t_remark` VALUES ('e0ff081b9db145668de3f02d8e927cb8', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:05', '2019-04-25 22:31:05');
INSERT INTO `t_remark` VALUES ('e1674fb14cda460d8ff0ac4c6598ae52', '123112(biger)', '.', 0, '2019-04-25 22:30:47', '2019-04-25 22:30:47');
INSERT INTO `t_remark` VALUES ('e3e955bd338545b2843b472a5eb48ac1', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:55', '2019-04-25 22:30:55');
INSERT INTO `t_remark` VALUES ('e40493777a804f779be2007f420322c6', '123112(biger)', '.', 0, '2019-04-25 22:26:31', '2019-04-25 22:26:31');
INSERT INTO `t_remark` VALUES ('e558c8c5ccea432ab48ffb2deceebe93', '123112(biger)', '.', 0, '2019-04-25 22:36:33', '2019-04-25 22:36:33');
INSERT INTO `t_remark` VALUES ('e5ddf0a647e043cc8399d129ba163bad', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:03', '2019-04-25 22:31:03');
INSERT INTO `t_remark` VALUES ('e9eddaf759f2490fb32339a0fcab2a11', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:55', '2019-04-25 22:30:55');
INSERT INTO `t_remark` VALUES ('e9f04225944e414a9db519f276aaf0fa', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:36:44', '2019-04-25 22:36:44');
INSERT INTO `t_remark` VALUES ('ea188749a894417da07ac4c3c643160f', 'caixukun123(默认昵称)', '123', 0, '2019-04-25 22:30:50', '2019-04-25 22:30:50');
INSERT INTO `t_remark` VALUES ('ea82f1f83ab64a79ad6d619b508fc455', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:54', '2019-04-25 22:30:54');
INSERT INTO `t_remark` VALUES ('ea9ea2f437e74becbe211166f55ddfe8', 'caixukun123(默认昵称)', '大家好，我是练习时长两年。。。呸，我是本酒店管理系统的唯一超管黄钰朝，很荣幸成为置顶留言哈哈哈（后端程序员装逼时刻），各位大佬如果想尝试标签注入或者sql注入，请开始你的表演，但是正常来说是没有用的（吧），所以不要尝试太多次，以保证留言的质量', 0, '2019-04-25 22:25:39', '2019-04-25 22:25:39');
INSERT INTO `t_remark` VALUES ('ebb8599953aa431ab3e43676b9cab057', '123112(biger)', '.', 0, '2019-04-25 22:26:09', '2019-04-25 22:26:09');
INSERT INTO `t_remark` VALUES ('eda8ab541bf144319ae845a4506ad19a', 'caixukun123(默认昵称)', '123', 0, '2019-04-25 22:30:51', '2019-04-25 22:30:51');
INSERT INTO `t_remark` VALUES ('efeae674369f4862b850a62f41eb1bbe', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:31:02', '2019-04-25 22:31:02');
INSERT INTO `t_remark` VALUES ('efef3050b341422397815968242b46f5', '123112(biger)', '.', 0, '2019-04-25 22:26:16', '2019-04-25 22:26:16');
INSERT INTO `t_remark` VALUES ('f2d7c84abd2549d8ab7de94a56ea8a71', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:42', '2019-04-25 22:30:42');
INSERT INTO `t_remark` VALUES ('f332c64d981e46a585200be35d0b1929', '123112(biger)', '.', 0, '2019-04-25 22:26:26', '2019-04-25 22:26:26');
INSERT INTO `t_remark` VALUES ('f3d4e8a005cf476686619056725b20c3', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:38:18', '2019-04-25 22:38:18');
INSERT INTO `t_remark` VALUES ('f7e7612dad9844e99444d784c2041117', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:44', '2019-04-25 22:39:44');
INSERT INTO `t_remark` VALUES ('fa59903d3f8d4baf8b008d426f917008', '123112(biger)', '101220', 0, '2019-04-25 22:47:20', '2019-04-25 22:47:20');
INSERT INTO `t_remark` VALUES ('fba856010a8e413ea2a407eee25a5ad1', 'caixukun123(默认昵称)', '1', 0, '2019-04-25 22:30:53', '2019-04-25 22:30:53');
INSERT INTO `t_remark` VALUES ('fdc6d72a8f004142ad5b4dcdea0d5fb4', 'caixukun123(默认昵称)', '2', 0, '2019-04-25 22:39:43', '2019-04-25 22:39:43');
INSERT INTO `t_remark` VALUES ('fe3b7851ab7649a48ed3d93799e9925d', '123112(biger)', '1', 0, '2019-04-25 22:46:59', '2019-04-25 22:46:59');
INSERT INTO `t_remark` VALUES ('fe51e9f445f844fcb2384b787b60f0a6', 'xiaopan(默认昵称)', '实现', 0, '2019-04-25 20:27:09', '2019-04-25 20:27:09');
-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`status` smallint(1) UNSIGNED NOT NULL COMMENT '状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_room
-- ----------------------------
DROP TABLE IF EXISTS `t_room`;
CREATE TABLE `t_room` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '房间名称',
`number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '房间编号',
`photo` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default.jpg' COMMENT '房间照片',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '房间类型',
`area` decimal(32, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '房间面积',
`bed_width` decimal(32, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '床宽',
`price` decimal(10, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '房间价格',
`book_status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '空闲' COMMENT '被订状态',
`level` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '房间等级',
`score` decimal(20, 0) UNSIGNED NOT NULL DEFAULT 4 COMMENT '房间评分',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '没有备注信息' COMMENT '备注信息',
`remark_num` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '评分数量',
`hotel_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '酒店id',
`creator_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '创建者id',
`editor_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '修改者id',
`status` smallint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '房间状态(0可用）',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '插入时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `fk_editor_id`(`editor_id`) USING BTREE,
INDEX `fk_creator_id`(`creator_id`) USING BTREE,
INDEX `fk_hotel_id`(`hotel_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_room
-- ----------------------------
INSERT INTO `t_room` VALUES ('07b184b88a7445d1929383b8eca1cbbc', '阿布扎比宫殿酒店(Emirates Palace)商务间3059342', '3059342', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 112, 3, 6199, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('0ae1e0cb4a2e41a68feb8aa8a2dc5f90', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068342', '3068342', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 112, 3, 8199, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('10ed47323a2246be974f9846c54cb9de', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528345', '4528345', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 115, 3, 9499, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('13eda81a106c43929ff83c3f38ae0036', '维多利亚帝后饭店(Empress Hotel)商务间3028345', '3028345', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 115, 3, 5499, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('14ceb8fc5903415eaf3ca192985476be', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528341', '4528341', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 111, 3, 9099, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('20425a3bb42c40f6bd5a687aaf212356', '维多利亚帝后饭店(Empress Hotel)商务间3028346', '3028346', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 116, 3, 5599, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('28485cc05daa4b098106601c70d44624', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068346', '3068346', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 116, 3, 8599, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('2dce5f1352a44e8b9cb841c2cbd13231', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068340', '3068340', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 110, 3, 7999, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('2fb0d35466d64d7e92f4b735e2ebe5ba', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068348', '3068348', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 118, 3, 8799, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('32ce513863f5418cb892f0a98d69e643', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528342', '4528342', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 112, 3, 9199, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('35fb9f1c232e4d0d95f1a5f4089f797b', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528340', '4528340', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 110, 3, 8999, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('381d0255277644f1ae45aafd60c2bfb4', '阿布扎比宫殿酒店(Emirates Palace)商务间3059347', '3059347', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 117, 3, 6699, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('3c244501780642b5a8354ae9f78a0290', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068341', '3068341', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 111, 3, 8099, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('459399c7f8234e4e85698225511b6074', '阿布扎比宫殿酒店(Emirates Palace)商务间3059340', '3059340', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 110, 3, 5999, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('45dd54c3ea894f5bb943f7077d539541', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528346', '4528346', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 116, 3, 9599, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('4a9b2c8a14614780a3f22c7b04d2485d', '阿布扎比宫殿酒店(Emirates Palace)商务间3059346', '3059346', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 116, 3, 6599, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('667655b36236420bbb8d5743309bc937', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528347', '4528347', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 117, 3, 9699, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('6982c6a3b7cd428aae99a19f63fae21d', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528348', '4528348', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 118, 3, 9799, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('6a7ceb57ad564ddea7fbd464abeac1f9', '阿布扎比商务间3059388', '3059388', 'default.jpg', '双人', 70, 3, 4999, '空闲', '5', 4, '', 0, '0', '0', '0', 0, '2019-04-24 20:17:26', '2019-04-24 20:17:26');
INSERT INTO `t_room` VALUES ('6cea281c12384925bcc5089794039c95', '阿布扎比宫殿酒店(Emirates Palace)商务间3059348', '3059348', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 118, 3, 6799, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('71651961b39a45d2b9e88055c04448c0', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528343', '4528343', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 113, 3, 9299, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('7d855cac9332470f8687222c7ebce345', '阿布扎比宫殿酒店(Emirates Palace)商务间3059349', '3059349', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 119, 3, 6899, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('8438c75ca89a428d86c8e6962653c494', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528343', '4528343', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 113, 3, 9299, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('87343aa923c2441396a2e0b79b5b50cf', '维多利亚帝后饭店(Empress Hotel)商务间3028349', '3028349', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 119, 3, 5899, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('8770543b8f104347a0f85cb86a647317', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068344', '3068344', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 114, 3, 8399, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('89905bf05ec2487fa596d1c3aa332ea1', '维多利亚帝后饭店(Empress Hotel)商务间3028341', '3028341', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 111, 3, 5099, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('8a628f7158144d908123566702190a91', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528340', '4528340', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 110, 3, 8999, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('8cc50028d61b4f8ea2568b2be2c66a3e', '阿布扎比宫殿酒店(Emirates Palace)商务间3059344', '3059344', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 114, 3, 6399, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('907005d3b29c4b148415c77358cdb8c3', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528344', '4528344', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 114, 3, 9399, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('935225cae6dc4ff3afd8c47b0474fb32', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528348', '4528348', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 118, 3, 9799, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('9c2b100a187243ddb6f2df2141b07c31', '维多利亚帝后饭店(Empress Hotel)商务间3028342', '3028342', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 112, 3, 5199, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('9c60788043944a1396bd8fbed7c232ba', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528341', '4528341', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 111, 3, 9099, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('b081018983f442508e478291f3b7fb0c', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528344', '4528344', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 114, 3, 9399, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('b0b75b7154934e87ae228861c69aa0fc', '阿布扎比宫殿酒店(Emirates Palace)商务间3059341', '3059341', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 111, 3, 6099, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('b4d2b0ef3d144d01b651be6b3797bd4b', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528346', '4528346', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 116, 3, 9599, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('bcdedc4ea2c34dc98f74585ff35279cc', '维多利亚帝后饭店(Empress Hotel)商务间3028343', '3028343', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 113, 3, 5299, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('bd960cbb82ea476cab8ef6188cb4d025', '维多利亚帝后饭店(Empress Hotel)商务间3028347', '3028347', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 117, 3, 5699, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('c3a9221bfbe24955bc77c938ddcd380c', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528345', '4528345', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 115, 3, 9499, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('c85ba01193bc49c7beb0c7aca4028b56', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528349', '4528349', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 119, 3, 9899, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
INSERT INTO `t_room` VALUES ('cbab76bd6c4d45d99eab37649ea5efe8', '维多利亚帝后饭店(Empress Hotel)商务间3028340', '3028340', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 110, 3, 4999, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('ce314819811a447b89eb329e8214d1f8', '阿布扎比宫殿酒店(Emirates Palace)商务间3059343', '3059343', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 113, 3, 6299, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('d4dc23c3e60749f88eabaca82255cdc8', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068349', '3068349', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 119, 3, 8899, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('d92579914aee4db685f00cd183076a22', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528342', '4528342', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 112, 3, 9199, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('e0fba000a9984dc8a229f61c8d8104b0', '阿布扎比宫殿酒店(Emirates Palace)商务间3059345', '3059345', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 115, 3, 6499, '空闲', '8星级', 5, '“满足你的一切愿望，实现你当国王的梦想”', 0, '0', '0', '0', 0, '2019-04-24 17:42:15', '2019-04-24 17:42:15');
INSERT INTO `t_room` VALUES ('efb236173fa643c093fc22da242be711', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528349', '4528349', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 119, 3, 9899, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:49:13', '2019-04-24 17:49:13');
INSERT INTO `t_room` VALUES ('f077db7830594cd78ea070c8d4dc7d75', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068343', '3068343', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 113, 3, 8299, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('f163a64cfc044ae18de8224470a34675', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068347', '3068347', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 117, 3, 8699, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('f5c60eda3e2a417f81fe42e6b211f587', '迪拜帆船酒店(Dubai Lugger Hotel)商务间3068345', '3068345', 'b7fb2f8ad4df4440a762381ad8c56f0d.jpg', '双人', 115, 3, 8499, '空闲', '7星级', 5, '“位于中东地区阿拉伯联合酋长国迪拜酋长国的迪拜市，为全世界最豪华的酒店”', 0, '0', '0', '0', 0, '2019-04-24 17:44:20', '2019-04-24 17:44:20');
INSERT INTO `t_room` VALUES ('f652de18f97e43199b766ff7f9cf3039', '维多利亚帝后饭店(Empress Hotel)商务间3028344', '3028344', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 114, 3, 5399, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('fa86eabc53c94fc3881fa90569191ef6', '维多利亚帝后饭店(Empress Hotel)商务间3028348', '3028348', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '双人', 118, 3, 5799, '空闲', '7星级', 5, '“加拿大CP HOTEL系列著名饭店之一”', 0, '0', '0', '0', 0, '2019-04-24 17:47:00', '2019-04-24 17:47:00');
INSERT INTO `t_room` VALUES ('fbbd12a93f934856bf2fd36d71682120', '文莱帝国酒店(Empire Hotel& Country Club)商务间4528347', '4528347', 'e93f57968f8d413f853b9130ff00bf0f.jpg', '多人', 117, 3, 9699, '空闲', '8星级', 5, '“十万元一晚的帝王级享受，对于懂得享受和追求奢华感觉的人士绝对是最佳的选择”', 0, '0', '0', '0', 0, '2019-04-24 17:51:28', '2019-04-24 17:51:28');
-- ----------------------------
-- Table structure for t_serv
-- ----------------------------
DROP TABLE IF EXISTS `t_serv`;
CREATE TABLE `t_serv` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '服务编号',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '服务名称',
`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '服务内容',
`time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '服务时长',
`status` smallint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '服务状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1234' COMMENT '登陆密码',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'USER' COMMENT '用户类型',
`phone_number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号码',
`id_number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '身份证号',
`nick_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '默认昵称' COMMENT '用户昵称',
`photo` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户头像',
`balance` decimal(32, 0) NOT NULL DEFAULT 0 COMMENT '账户余额',
`pay_pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '4QrcOUm6Wau+VuBX8g+IPg==' COMMENT '支付密码',
`status` smallint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '账户状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '插入时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('012aa177e364413999f8f14469272b0f', 'hrzgj666', 'nL+KTcuOMGgrkn81LWVZoA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 08:40:26', '2019-04-25 08:40:26');
INSERT INTO `t_user` VALUES ('022dfb00bfa34680b9aeab94b215fec8', 'Billie', 'cXxh5tMOXLlMPrapZ0CcsQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 22:34:03', '2019-04-25 22:34:03');
INSERT INTO `t_user` VALUES ('04847a4e4ac74dbf9ca4d76595833559', '123456789', 'JfnnlDI7RTiF9RgfG2JNCw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 14:02:08', '2019-04-25 14:02:08');
INSERT INTO `t_user` VALUES ('04c2501024ac4c9187f9aec9b7f65639', 'test17', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999170, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('0ab4a07a8e754cf4b6ed4ba68cb31982', 'test2', '1234', 'user', '', '', '', 'test', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:33:50', '2019-04-20 20:33:50');
INSERT INTO `t_user` VALUES ('0f46a983ae6244e28dcb26eea8c28136', 'huangyuchao', 's7PhSEzQyYERwLKkP9vtXg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:38:38', '2019-04-25 00:38:38');
INSERT INTO `t_user` VALUES ('0f5f1f0f69bf4ebf905832edf7d83831', 'test25', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999250, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('10f2da64d1164912b2c378fcd12cdd85', 'test13', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999130, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('11a04040cd0844caa84f7b81f5d4132d', '1111sysg', 'ljhZYtpDwNEjy+gvskn1tw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 01:27:16', '2019-04-25 01:27:16');
INSERT INTO `t_user` VALUES ('139e1cc8c6bd4fa1a2d01ee2b6ef5ff5', 'a1179374184', 'Khr/4ea4Gkq8XF8G7AG9Wg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:19:33', '2019-04-25 00:19:33');
INSERT INTO `t_user` VALUES ('145caacaf3aa46e99700e7a28deaf890', 'test500', 'LkCKwuQFjIiwI/dfDlvBqg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 21:33:06', '2019-04-25 21:33:06');
INSERT INTO `t_user` VALUES ('14f3fc11f3634fdab52a412b9bfd1444', 'wzm1742415101', 'K36jKn7OyLsjJKgQIetHzQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 22:40:51', '2019-04-25 22:40:51');
INSERT INTO `t_user` VALUES ('15692a63cdcb490b8a78c83bf5966996', 'Woshicxk', 'ReSBIBTYPd5WZuvfWo7R7Q==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 22:35:16', '2019-04-25 22:35:16');
INSERT INTO `t_user` VALUES ('15ba1147233b47d282524b03201e1b41', 'test2', '1234', 'user', '', '', '', 'test', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('164b6dd1546047438d6a4000e7e31030', 'caixukun', 'JfnnlDI7RTiF9RgfG2JNCw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 21:42:30', '2019-04-25 21:42:30');
INSERT INTO `t_user` VALUES ('17283549c2b143d6a2bf740aa6b6c8d5', 'Dffffe', 'tNsCcc0FKtwaQgfaEi2Y4A==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 01:22:53', '2019-04-25 01:22:53');
INSERT INTO `t_user` VALUES ('186a3a21340a4525adbabce20d0ff307', 'test29', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999290, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('21bac58f55f341e9b0e0badaf26394a2', '', 'test1111', 'USER', '15816019723', '440823199912202117', 'tssg134', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-21 17:29:06', '2019-04-21 17:29:06');
INSERT INTO `t_user` VALUES ('2417679251d64ce995ea02ec2d2e738c', 'test27', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999270, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('2b16b05326c1467894f070748635ebad', 'test11', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999110, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('2d14f3e43c604805a9c3b18a1ba92c75', '311800', '4QrcOUm6Wau+VuBX8g+IPg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 06:55:58', '2019-04-25 06:55:58');
INSERT INTO `t_user` VALUES ('2d6bb9ab3cca4d649194a9669ed97983', 'cxk888', 'Dpm70Wa9pSE6jzW1zo1PkA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-24 19:13:17', '2019-04-24 19:13:17');
INSERT INTO `t_user` VALUES ('31d05dba2d764d74b32fe09a7c67912a', 'test24', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999240, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('32e1224f54be447c906ed616c5caed99', 'jiansheng', '6Afx/PgtEy+bsBjKZzihnw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 01:04:04', '2019-04-25 01:04:04');
INSERT INTO `t_user` VALUES ('346d8802d4bc4c82bfc63a639573c83d', 'test0', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 9990, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('376e1bffba494804b57993f505cd1c22', 'test11', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999110, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('38e654cd1227401fa5d52dac5411f313', 'test19', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999190, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('3a5cc535880a4205af03eb1cbfe0a384', 'test7878', 'B/fnrs0MSg0QVQUJ4HBUPA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:06:33', '2019-04-25 00:06:33');
INSERT INTO `t_user` VALUES ('3cfe4868ee0742499e44c816ac77467d', '987654', 'bETlzRfwAZxksELkp0VBKg==', 'USER', '13622222222', '123456789098765', '朗朗', '6a1ec22b842f4ac88365c1e65898f568.jpg', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:27:44', '2019-04-25 00:38:02');
INSERT INTO `t_user` VALUES ('3d51cae9985e418cb1935db832f5efee', 'test3', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99930, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('3dac54027ceb4e6bb32d5509dfd8fa76', 'test28', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999280, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('41798d7d039e4c37872b32de42f6194a', 'test14', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999140, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('41df6d2f51724557989985afa2da40b7', 'test5', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99950, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('4795e336285043f89a0d80338edd6dad', 'test6', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99960, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('4c520fa91a8e4a99b15153f5e5c2a09c', 'test18', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999180, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('4eb4f6a6410f4bb79326b83336b6f2b1', 'test1', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99910, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('4f3a92eadd8e493bbaa1db2fd589be70', 'test16', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999160, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('556e52b747c04f628d9a396195789c75', 'xiaopan', '3Eg+gKegvZ73HYz5c2c5JA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 12:07:02', '2019-04-25 12:07:02');
INSERT INTO `t_user` VALUES ('59b1655bb4464a39a2315aef90bf6877', 'test4', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99940, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('59e145bd82f24de69a480fe39e17beb6', 'test29', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999290, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('5b86d6ffe8fd43c6afad55147134d50d', 'woshiyuqidalao', 'nL+KTcuOMGgrkn81LWVZoA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 08:44:00', '2019-04-25 08:44:00');
INSERT INTO `t_user` VALUES ('5be07df07fe34ff197995fe353154ff0', 'test1', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99910, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('5bf689171bb547d19fbb1901e113e996', 'test7', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99970, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('5cb9b57ad9ef4c8b9d55e0f37d47fe43', 'test1010', 'v9dL879MDsh9UbrTI0/MmQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:03:25', '2019-04-25 00:03:25');
INSERT INTO `t_user` VALUES ('63d8022f9ef04063acd9db29c146584f', 'chencile', 'CE5/dqycSLo+wX9Nqqrgww==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 21:52:11', '2019-04-25 21:52:11');
INSERT INTO `t_user` VALUES ('64efe412b01a43c88ab1324a2592308d', 'test2333', '2+etbTK+RmWzcW/2ml0bJg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-24 16:38:21', '2019-04-24 16:38:21');
INSERT INTO `t_user` VALUES ('66c5c05305d3445cb32e71afdeedaa23', 'Abcdef', '4QrcOUm6Wau+VuBX8g+IPg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:49:52', '2019-04-25 00:49:52');
INSERT INTO `t_user` VALUES ('6c3549e21efa4bd991bbfb7befabc6ab', 'test88882', 'mifkJ+63z+8GeC/5okjcvw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-24 16:49:15', '2019-04-24 16:49:15');
INSERT INTO `t_user` VALUES ('6d124f48c2a1420eaa55bbd139947b2a', 'test24', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999240, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('727cee3b93b442d4b71e3d9e84e5ad25', 'test9', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99990, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('7bed29c52d0a4412a2b8b8f3b1f22c19', 'test1111', 'test1111', 'USER', '15816019723', '440823199912202117', 'qqqasdf', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-21 17:39:01', '2019-04-21 17:39:01');
INSERT INTO `t_user` VALUES ('7cab00de5e204ed5a79285c058d5c25c', 'test0', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 9990, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('847417e919d74d21a183b537962e0a9c', 'test19', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999190, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('85a42b05bc9f4eaab8972f87df64a9c7', 'test14', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999140, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('89c83e8e9f0e49099f52c54e4104c93d', '123cyc', 'LnpKpwJvC1UFCDFk4nizQQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 01:06:52', '2019-04-25 01:06:52');
INSERT INTO `t_user` VALUES ('8a020caf8e3740dfa6ca6fb4a3432311', 'test6666', 'Tr86wFLHVKvnro7wV+kkvw==', 'USER', '13536372301', '440823199912202117', '12345678901234567890', '', 0, 'Ftek/KdELdo62TyacmWX5A==', 0, '2019-04-20 20:43:42', '2019-04-21 02:29:32');
INSERT INTO `t_user` VALUES ('8ab7086bde1048489778c0a1e73b4f71', 'ppp123456', 'JfnnlDI7RTiF9RgfG2JNCw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 01:13:16', '2019-04-25 01:13:16');
INSERT INTO `t_user` VALUES ('8c7086c4f4694da8b0407b717188f0d4', 'test26', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999260, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('8cab411a15d24fc3a58853eae402a0a0', 'test28', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999280, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('906938fcf8b2404093b636e348de9d5e', 'test20', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999200, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('91fdb6ad45a140ea8b70c63e862063af', 'test20', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999200, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('948ea8f36bf142699a95702f32d36172', 'test7', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99970, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('982d24deab6e4b54a0c89926c148aa56', 'test22', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999220, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('986b7ac3fda24d6b886f717e538f3fab', 'chenille', 'O5ZmmNkqUAnsUAjeNnnJcA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 21:50:35', '2019-04-25 21:50:35');
INSERT INTO `t_user` VALUES ('99b867f28c014d2ca8f14ccac528b360', 'test2', '1234', 'user', '', '', '', 'test', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('9e78bcdf51d14d8cb623a437622f1dcb', 'test23', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999230, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('a0638e2200a349559c4671a2db15768c', 'test88881', '2AirQug8Z3L75BQxUzoujA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-24 16:48:17', '2019-04-24 16:48:17');
INSERT INTO `t_user` VALUES ('a0a7943c9b0f445d9d97a869587696b2', '123112', '4QrcOUm6Wau+VuBX8g+IPg==', 'USER', '13111111111', '111111111111111111', 'biger', '81f098970a2448849ea01abad947b3e4.pdf', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 22:18:43', '2019-04-25 22:23:02');
INSERT INTO `t_user` VALUES ('a10b8c56668345049458d5f54ab6e45f', 'medw1n', 'ZwsUcorZkCrsujLiL6T2vQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 22:19:27', '2019-04-25 22:19:27');
INSERT INTO `t_user` VALUES ('a187278c81944233a86c7e2e725376c5', 'test26', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999260, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('a39dca5ab0ee49d2861c8b3bd238ea43', '222222', '4861iBoKH9qtASltdVSGjQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 01:01:19', '2019-04-25 01:01:19');
INSERT INTO `t_user` VALUES ('a92090e6c6e74ded80f765985b01d081', 'test10', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999100, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('aa2e491f62e14597a6d44a80272c0d7a', 'test12', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999120, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('ac1646f3765c48a88c036b3d068389c3', 'test8', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99980, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('acf1ac1b1826489d92e613b81660374a', 'test27', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999270, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('ad4adc60498e4bc0873220771db596f4', 'test3', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99930, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('ae48795a3da942c2bd629ec8e33e12e4', 'test10', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999100, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('b024d15bd93e4e99bac49bbf256c1f93', 'test13', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999130, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('b0dc07bbd287444399ee100d35dc34f9', 'test9', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99990, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('b4688bc8567f4b829419204cceeeba29', 'test17', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999170, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('b720395217484fbf97d6fff071933811', 'test18', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999180, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('b80c72cf9d7b43bbb0ded5cd20317353', 'test4', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99940, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('bdda533fedde452f817527386e70d762', 'test404', 'PrC3Z+3KqoAeOIwoDF1O9A==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:07:43', '2019-04-25 00:07:43');
INSERT INTO `t_user` VALUES ('c346ea3088ae4cf3934e59a531245af7', 'test2', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99920, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('c53cce10735d4117aa0cbc69c90b4913', 'chenille_0318', 'CE5/dqycSLo+wX9Nqqrgww==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 21:50:04', '2019-04-25 21:50:04');
INSERT INTO `t_user` VALUES ('c6cd987782f64a589cc356b01fd0fa35', 'test12', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999120, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('c7cb031100da4f11923aac94c57d8a91', 'caixukun123', 'jPFdaq9zTNHxXblLukpuWg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 22:17:11', '2019-04-25 22:17:11');
INSERT INTO `t_user` VALUES ('c809571f96744de9a10d91445645db3d', 'test21', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999210, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('c85b599fa53a4590810c7e93147cfd74', 'test21', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999210, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('c8fa6515088d4bc1872082458b281ec3', 'test88889', 'mifkJ+63z+8GeC/5okjcvw==', 'USER', '15816019723', '440823199912202117', '黄', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-24 16:40:51', '2019-04-24 17:23:36');
INSERT INTO `t_user` VALUES ('ca402850b37841048552763ee086c5e0', 'l123456', 'xXViZTx4P664ts2RfvJYwQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 17:28:47', '2019-04-25 17:28:47');
INSERT INTO `t_user` VALUES ('cca5a7e9ab534317975b984bf78f0e54', 'test2222', 'iKx4AVsqegtTbH3WedYDLQ==', 'USER', '15816019723', '440823199912202117', 'qqqasdf', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-21 17:43:15', '2019-04-21 17:43:15');
INSERT INTO `t_user` VALUES ('cdc69b1141bc43baa12ea26c82503d98', 'test9999', 'sd5WqSjZxUAFACmGYmSoKw==', 'USER', '15816019723', '440823199912202113', '默认昵称', 'eb377ec4e4084e898aba7dda86632cba.jpg', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:00:26', '2019-04-25 00:02:05');
INSERT INTO `t_user` VALUES ('ceacd341135542218795450a946c22f0', 'test6', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99960, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('cf0ca5fd92aa44028be6975001c2fd73', 'test15', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999150, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('d132fc1ce4e24c5f8f4bfb54e77cdea5', 'test16', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999160, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('d2c77a9fa07c4802ba5afa14410a0009', '1234567', '/OqSD3QStdp74M9CuMk3WQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 08:15:01', '2019-04-25 08:15:01');
INSERT INTO `t_user` VALUES ('d3e150a8cc3442cd82413fe629ba8b4b', 'Qwerty', '2FeO34RYzgb7xbt2pYxcpA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 01:23:22', '2019-04-25 01:23:22');
INSERT INTO `t_user` VALUES ('d7cab5c9dfff40a1b53f5080d963a13d', 'test25', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999250, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
INSERT INTO `t_user` VALUES ('dac00243234949e185370902c636f578', 'test8888', 'v9dL879MDsh9UbrTI0/MmQ==', 'ADMIN', '15816019723', '440823199912202117', '我的新昵称', 'a3b15733ce4140c08aa813fb73fcd4bd.jpg', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-21 02:33:37', '2019-04-24 16:34:27');
INSERT INTO `t_user` VALUES ('daf2b614d4c9463fb34ec81d8ffc4792', 'ikun9527', '4QrcOUm6Wau+VuBX8g+IPg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 22:13:51', '2019-04-25 22:13:51');
INSERT INTO `t_user` VALUES ('db66f538aa6049e0aa759d7072711646', 'fhjkuhnf', '6Afx/PgtEy+bsBjKZzihnw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 08:22:03', '2019-04-25 08:22:03');
INSERT INTO `t_user` VALUES ('dee2ba0987af4028af7d6a6a35b6826b', 'test5', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99950, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('dfdcab2a783246ae9e14d395caab2947', 'test2', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99920, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:37', '2019-04-20 20:20:37');
INSERT INTO `t_user` VALUES ('e320ffde876446ae949d924a8ec1da79', 'Cerbur', 'WM9wP2ZDl+xPCsNZuEtWXA==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:21:10', '2019-04-25 00:21:10');
INSERT INTO `t_user` VALUES ('e6f76da68caf448ba6b67e780a2d7696', 'cclover', '6Afx/PgtEy+bsBjKZzihnw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 13:56:40', '2019-04-25 13:56:40');
INSERT INTO `t_user` VALUES ('e830a36cf81048bfb3648c479e4b3ccd', 'huangyuchao123', 'GFk0Hsb9pDJIH80oXMUl6g==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:38:59', '2019-04-25 00:38:59');
INSERT INTO `t_user` VALUES ('e9761b5333c04bc88730b891873f6f3c', 'woshichenyu', 'NfqcWeArIl7T5oixBJrQrg==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:15:26', '2019-04-25 00:15:26');
INSERT INTO `t_user` VALUES ('f00da52b308840cb9c835cf2eb162c0a', 'hyc2333', 'xH7XKPhStEhYjeMpisQrHw==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-24 16:39:08', '2019-04-24 16:39:08');
INSERT INTO `t_user` VALUES ('f1929fdffd39495ba1aad2405c27cb59', '123333', 'M42BHVMlU1V8ozvkW2veVQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 10:16:52', '2019-04-25 10:16:52');
INSERT INTO `t_user` VALUES ('f36b16fe4dee4b38a510e6c4d5b389e4', 'test22', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999220, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('f7af8e09806148e684e8707a8aa8ccb5', 'test8', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 99980, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('fb3a74b295404dc38627d3eeeb1d779d', '12345678', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 'USER', '', '', '默认昵称', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:27:11', '2019-04-25 00:27:11');
INSERT INTO `t_user` VALUES ('fb942b30f55d43ca9b52bf275dd3f8dc', '123456', '4QrcOUm6Wau+VuBX8g+IPg==', 'USER', '13424567876', '440102010101010101', ';deletefromuser;', '', 0, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-25 00:59:18', '2019-04-25 21:58:50');
INSERT INTO `t_user` VALUES ('fd8f21ac4da14ee0924eba4faf8458c2', 'test23', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999230, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:21:30', '2019-04-20 20:21:30');
INSERT INTO `t_user` VALUES ('fed597e60a414793849e544e615fa71a', 'test15', 'gdyb21LQTcIANtvYMT7QVQ==', 'user', '15816019724', '440823199912202118', 'tom', '默认头像.jpg', 999150, '4QrcOUm6Wau+VuBX8g+IPg==', 0, '2019-04-20 20:20:38', '2019-04-20 20:20:38');
-- ----------------------------
-- Table structure for tb_base
-- ----------------------------
DROP TABLE IF EXISTS `tb_base`;
CREATE TABLE `tb_base` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`status` smallint(1) UNSIGNED NOT NULL COMMENT '状态',
`gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;