forked from easysoft/zentaopms
-
Notifications
You must be signed in to change notification settings - Fork 0
/
endemo.sql
707 lines (707 loc) · 70.1 KB
/
endemo.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
INSERT INTO `zt_acl` (`account`, `objectType`, `objectID`, `type`, `source`) VALUES
('admin', 'program', 1, 'whitelist', 'add'),
('projectManager', 'program', 1, 'whitelist', 'add');
REPLACE INTO `zt_action` (`id`, `objectType`, `objectID`, `product`, `project`, `execution`, `actor`, `action`, `date`, `comment`, `extra`, `read`, `vision`, `efforted`) VALUES
(1, 'user', 1, ',0,', 0, 0, 'admin', 'login', '2024-04-02 14:13:44', '', '', '0', 'rnd', 0),
(2, 'program', 1, ',0,', 0, 0, 'admin', 'opened', '2024-04-02 14:25:12', '', '', '0', 'rnd', 0),
(3, 'product', 1, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 14:30:13', '', '', '0', 'rnd', 0),
(4, 'product', 2, ',2,', 0, 0, 'admin', 'opened', '2024-04-02 14:30:55', '', '', '0', 'rnd', 0),
(5, 'project', 2, ',1,', 2, 0, 'admin', 'managed', '2024-04-02 14:34:13', '', '1', '0', 'rnd', 0),
(6, 'project', 2, ',1,', 2, 0, 'admin', 'opened', '2024-04-02 14:34:13', '', '', '0', 'rnd', 0),
(7, 'execution', 3, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 14:35:32', '', '1', '0', 'rnd', 0),
(8, 'execution', 4, ',1,', 2, 4, 'admin', 'opened', '2024-04-02 14:36:20', '', '1', '0', 'rnd', 0),
(9, 'stakeholder', 1, ',0,', 0, 0, 'admin', 'added', '2024-04-02 14:37:57', '', '', '0', 'rnd', 0),
(10, 'productplan', 1, ',2,', 0, 0, 'admin', 'opened', '2024-04-02 14:42:47', '', '', '0', 'rnd', 0),
(11, 'story', 1, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:20', '', '', '0', 'rnd', 0),
(12, 'story', 2, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(13, 'story', 3, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(14, 'story', 4, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(15, 'story', 5, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(16, 'story', 6, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(17, 'story', 7, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(18, 'productplan', 1, ',1,', 0, 0, 'admin', 'linkstory', '2024-04-02 15:01:21', '', '1,2,3,4,5,6,7', '0', 'rnd', 0),
(19, 'user', 2, ',0,', 0, 0, 'productManager', 'login', '2024-04-02 15:03:53', '', '', '0', 'rnd', 0),
(20, 'story', 1, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(21, 'story', 2, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(22, 'story', 3, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(23, 'story', 4, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(24, 'whitelist', 1, ',0,', 0, 0, 'admin', 'managedwhitelist', '2024-04-02 15:45:12', '', 'program', '0', 'rnd', 0),
(25, 'project', 2, ',1,2,', 2, 0, 'admin', 'managed', '2024-04-02 15:48:09', '', '1,2', '0', 'rnd', 0),
(26, 'story', 1, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(27, 'story', 2, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(28, 'story', 3, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(29, 'story', 4, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(30, 'story', 1, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(31, 'story', 2, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(32, 'story', 3, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(33, 'story', 4, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(34, 'task', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(35, 'task', 2, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(36, 'task', 3, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(37, 'task', 4, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(38, 'task', 5, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(39, 'task', 6, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(40, 'task', 7, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(41, 'task', 8, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(42, 'user', 2, ',0,', 0, 0, 'productManager', 'logout', '2024-04-02 15:57:37', '', '', '0', 'rnd', 0),
(43, 'user', 3, ',0,', 0, 0, 'projectManager', 'login', '2024-04-02 15:57:49', '', '', '0', 'rnd', 0),
(44, 'task', 1, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(45, 'task', 2, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(46, 'task', 3, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(47, 'task', 4, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(48, 'task', 5, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(49, 'task', 6, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(50, 'task', 7, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(51, 'task', 8, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(52, 'task', 5, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(53, 'task', 6, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(54, 'task', 7, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(55, 'task', 8, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(56, 'task', 1, ',1,', 2, 3, 'projectManager', 'finished', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(57, 'execution', 3, ',1,', 2, 3, 'projectManager', 'syncexecution', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(58, 'project', 2, ',1,2,', 2, 0, 'projectManager', 'syncproject', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(59, 'program', 1, ',0,', 0, 0, 'projectManager', 'syncprogram', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(60, 'task', 2, ',1,', 2, 3, 'projectManager', 'started', '2024-04-02 15:59:20', '', '', '0', 'rnd', 0),
(61, 'task', 8, ',1,', 2, 3, 'admin', 'finished', '2024-04-02 16:00:18', '', '', '0', 'rnd', 0),
(62, 'task', 7, ',1,', 2, 3, 'admin', 'finished', '2024-04-02 16:00:50', '', '', '0', 'rnd', 0),
(63, 'task', 5, ',1,', 2, 3, 'admin', 'started', '2024-04-02 16:01:01', '', '', '0', 'rnd', 0),
(64, 'task', 6, ',1,', 2, 3, 'admin', 'started', '2024-04-02 16:01:05', '', '', '0', 'rnd', 0),
(65, 'build', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:07:17', '', '', '0', 'rnd', 0),
(66, 'story', 4, ',1,', 2, 3, 'admin', 'linked2build', '2024-04-02 16:07:31', '', '1', '0', 'rnd', 0),
(67, 'build', 1, ',1,', 2, 3, 'admin', 'linkstory', '2024-04-02 16:07:31', '', '4', '0', 'rnd', 0),
(68, 'bug', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:12:08', '', '', '0', 'rnd', 0),
(69, 'bug', 2, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:13:53', '', '', '0', 'rnd', 0),
(70, 'bug', 3, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:14:38', '', '', '0', 'rnd', 0),
(71, 'bug', 4, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:15:52', '', '', '1', 'rnd', 0),
(72, 'bug', 4, ',1,', 2, 3, 'admin', 'edited', '2024-04-02 16:16:52', '', '', '1', 'rnd', 0),
(73, 'bug', 4, ',1,', 2, 3, 'admin', 'resolved', '2024-04-02 16:17:49', '', 'fixed', '1', 'rnd', 0),
(74, 'case', 1, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:20:31', '', '', '0', 'rnd', 0),
(75, 'case', 1, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:20:32', '', '2', '0', 'rnd', 0),
(76, 'case', 1, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:20:32', '', '3', '0', 'rnd', 0),
(77, 'case', 1, ',1,', 0, 0, 'admin', 'edited', '2024-04-02 16:21:30', '', '', '0', 'rnd', 0),
(78, 'case', 2, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:23:34', '', '', '0', 'rnd', 0),
(79, 'case', 2, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:23:34', '', '2', '0', 'rnd', 0),
(80, 'case', 2, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:23:34', '', '3', '0', 'rnd', 0),
(81, 'case', 1, ',1,', 0, 0, 'admin', 'edited', '2024-04-02 16:23:56', '', '', '0', 'rnd', 0),
(82, 'case', 3, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:24:38', '', '', '0', 'rnd', 0),
(83, 'case', 3, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:24:39', '', '2', '0', 'rnd', 0),
(84, 'case', 3, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:24:42', '', '3', '0', 'rnd', 0),
(85, 'case', 4, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:25:09', '', '', '0', 'rnd', 0),
(86, 'case', 4, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:25:09', '', '2', '0', 'rnd', 0),
(87, 'case', 4, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:25:09', '', '3', '0', 'rnd', 0),
(88, 'testtask', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:26:35', '', '', '0', 'rnd', 0),
(89, 'case', 1, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:04', '', '1', '0', 'rnd', 0),
(90, 'case', 2, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:05', '', '1', '0', 'rnd', 0),
(91, 'case', 3, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:05', '', '1', '0', 'rnd', 0),
(92, 'case', 4, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:05', '', '1', '0', 'rnd', 0),
(93, 'case', 4, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0),
(94, 'case', 3, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0),
(95, 'case', 2, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0),
(96, 'case', 1, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0);
REPLACE INTO `zt_actionrecent` (`id`, `objectType`, `objectID`, `product`, `project`, `execution`, `actor`, `action`, `date`, `comment`, `extra`, `read`, `vision`, `efforted`) VALUES
(1, 'user', 1, ',0,', 0, 0, 'admin', 'login', '2024-04-02 14:13:44', '', '', '0', 'rnd', 0),
(2, 'program', 1, ',0,', 0, 0, 'admin', 'opened', '2024-04-02 14:25:12', '', '', '0', 'rnd', 0),
(3, 'product', 1, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 14:30:13', '', '', '0', 'rnd', 0),
(4, 'product', 2, ',2,', 0, 0, 'admin', 'opened', '2024-04-02 14:30:55', '', '', '0', 'rnd', 0),
(5, 'project', 2, ',1,', 2, 0, 'admin', 'managed', '2024-04-02 14:34:13', '', '1', '0', 'rnd', 0),
(6, 'project', 2, ',1,', 2, 0, 'admin', 'opened', '2024-04-02 14:34:13', '', '', '0', 'rnd', 0),
(7, 'execution', 3, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 14:35:32', '', '1', '0', 'rnd', 0),
(8, 'execution', 4, ',1,', 2, 4, 'admin', 'opened', '2024-04-02 14:36:20', '', '1', '0', 'rnd', 0),
(9, 'stakeholder', 1, ',0,', 0, 0, 'admin', 'added', '2024-04-02 14:37:57', '', '', '0', 'rnd', 0),
(10, 'productplan', 1, ',2,', 0, 0, 'admin', 'opened', '2024-04-02 14:42:47', '', '', '0', 'rnd', 0),
(11, 'story', 1, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:20', '', '', '0', 'rnd', 0),
(12, 'story', 2, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(13, 'story', 3, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(14, 'story', 4, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(15, 'story', 5, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(16, 'story', 6, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(17, 'story', 7, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 15:01:21', '', '', '0', 'rnd', 0),
(18, 'productplan', 1, ',1,', 0, 0, 'admin', 'linkstory', '2024-04-02 15:01:21', '', '1,2,3,4,5,6,7', '0', 'rnd', 0),
(19, 'user', 2, ',0,', 0, 0, 'productManager', 'login', '2024-04-02 15:03:53', '', '', '0', 'rnd', 0),
(20, 'story', 1, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(21, 'story', 2, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(22, 'story', 3, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(23, 'story', 4, ',1,', 0, 0, '系统', 'reviewpassed', '2024-04-02 15:04:35', '', 'pass|draft', '0', 'rnd', 0),
(24, 'whitelist', 1, ',0,', 0, 0, 'admin', 'managedwhitelist', '2024-04-02 15:45:12', '', 'program', '0', 'rnd', 0),
(25, 'project', 2, ',1,2,', 2, 0, 'admin', 'managed', '2024-04-02 15:48:09', '', '1,2', '0', 'rnd', 0),
(26, 'story', 1, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(27, 'story', 2, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(28, 'story', 3, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(29, 'story', 4, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 15:48:57', '', '2', '0', 'rnd', 0),
(30, 'story', 1, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(31, 'story', 2, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(32, 'story', 3, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(33, 'story', 4, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 15:49:22', '', '3', '0', 'rnd', 0),
(34, 'task', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(35, 'task', 2, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(36, 'task', 3, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(37, 'task', 4, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(38, 'task', 5, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(39, 'task', 6, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(40, 'task', 7, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(41, 'task', 8, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 15:57:17', '', '', '0', 'rnd', 0),
(42, 'user', 2, ',0,', 0, 0, 'productManager', 'logout', '2024-04-02 15:57:37', '', '', '0', 'rnd', 0),
(43, 'user', 3, ',0,', 0, 0, 'projectManager', 'login', '2024-04-02 15:57:49', '', '', '0', 'rnd', 0),
(44, 'task', 1, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(45, 'task', 2, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(46, 'task', 3, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(47, 'task', 4, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(48, 'task', 5, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(49, 'task', 6, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(50, 'task', 7, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(51, 'task', 8, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:26', '', 'projectManager', '0', 'rnd', 0),
(52, 'task', 5, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(53, 'task', 6, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(54, 'task', 7, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(55, 'task', 8, ',1,', 2, 3, 'projectManager', 'assigned', '2024-04-02 15:58:39', '', 'admin', '0', 'rnd', 0),
(56, 'task', 1, ',1,', 2, 3, 'projectManager', 'finished', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(57, 'execution', 3, ',1,', 2, 3, 'projectManager', 'syncexecution', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(58, 'project', 2, ',1,2,', 2, 0, 'projectManager', 'syncproject', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(59, 'program', 1, ',0,', 0, 0, 'projectManager', 'syncprogram', '2024-04-02 15:58:54', '', '', '0', 'rnd', 0),
(60, 'task', 2, ',1,', 2, 3, 'projectManager', 'started', '2024-04-02 15:59:20', '', '', '0', 'rnd', 0),
(61, 'task', 8, ',1,', 2, 3, 'admin', 'finished', '2024-04-02 16:00:18', '', '', '0', 'rnd', 0),
(62, 'task', 7, ',1,', 2, 3, 'admin', 'finished', '2024-04-02 16:00:50', '', '', '0', 'rnd', 0),
(63, 'task', 5, ',1,', 2, 3, 'admin', 'started', '2024-04-02 16:01:01', '', '', '0', 'rnd', 0),
(64, 'task', 6, ',1,', 2, 3, 'admin', 'started', '2024-04-02 16:01:05', '', '', '0', 'rnd', 0),
(65, 'build', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:07:17', '', '', '0', 'rnd', 0),
(66, 'story', 4, ',1,', 2, 3, 'admin', 'linked2build', '2024-04-02 16:07:31', '', '1', '0', 'rnd', 0),
(67, 'build', 1, ',1,', 2, 3, 'admin', 'linkstory', '2024-04-02 16:07:31', '', '4', '0', 'rnd', 0),
(68, 'bug', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:12:08', '', '', '0', 'rnd', 0),
(69, 'bug', 2, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:13:53', '', '', '0', 'rnd', 0),
(70, 'bug', 3, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:14:38', '', '', '0', 'rnd', 0),
(71, 'bug', 4, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:15:52', '', '', '0', 'rnd', 0),
(72, 'bug', 4, ',1,', 2, 3, 'admin', 'edited', '2024-04-02 16:16:52', '', '', '0', 'rnd', 0),
(73, 'bug', 4, ',1,', 2, 3, 'admin', 'resolved', '2024-04-02 16:17:49', '', 'fixed', '0', 'rnd', 0),
(74, 'case', 1, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:20:31', '', '', '0', 'rnd', 0),
(75, 'case', 1, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:20:32', '', '2', '0', 'rnd', 0),
(76, 'case', 1, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:20:32', '', '3', '0', 'rnd', 0),
(77, 'case', 1, ',1,', 0, 0, 'admin', 'edited', '2024-04-02 16:21:30', '', '', '0', 'rnd', 0),
(78, 'case', 2, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:23:34', '', '', '0', 'rnd', 0),
(79, 'case', 2, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:23:34', '', '2', '0', 'rnd', 0),
(80, 'case', 2, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:23:34', '', '3', '0', 'rnd', 0),
(81, 'case', 1, ',1,', 0, 0, 'admin', 'edited', '2024-04-02 16:23:56', '', '', '0', 'rnd', 0),
(82, 'case', 3, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:24:38', '', '', '0', 'rnd', 0),
(83, 'case', 3, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:24:39', '', '2', '0', 'rnd', 0),
(84, 'case', 3, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:24:42', '', '3', '0', 'rnd', 0),
(85, 'case', 4, ',1,', 0, 0, 'admin', 'opened', '2024-04-02 16:25:09', '', '', '0', 'rnd', 0),
(86, 'case', 4, ',1,', 2, 0, 'admin', 'linked2project', '2024-04-02 16:25:09', '', '2', '0', 'rnd', 0),
(87, 'case', 4, ',1,', 2, 3, 'admin', 'linked2execution', '2024-04-02 16:25:09', '', '3', '0', 'rnd', 0),
(88, 'testtask', 1, ',1,', 2, 3, 'admin', 'opened', '2024-04-02 16:26:35', '', '', '0', 'rnd', 0),
(89, 'case', 1, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:04', '', '1', '0', 'rnd', 0),
(90, 'case', 2, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:05', '', '1', '0', 'rnd', 0),
(91, 'case', 3, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:05', '', '1', '0', 'rnd', 0),
(92, 'case', 4, ',1,', 2, 3, 'admin', 'linked2testtask', '2024-04-02 16:30:05', '', '1', '0', 'rnd', 0),
(93, 'case', 4, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0),
(94, 'case', 3, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0),
(95, 'case', 2, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0),
(96, 'case', 1, ',1,', 2, 3, 'admin', 'run', '2024-04-02 16:30:26', '', '1', '0', 'rnd', 0);
REPLACE INTO `zt_bug` (`id`, `project`, `product`, `injection`, `identify`, `branch`, `module`, `execution`, `plan`, `story`, `storyVersion`, `task`, `toTask`, `toStory`, `title`, `keywords`, `severity`, `pri`, `type`, `os`, `browser`, `hardware`, `found`, `steps`, `status`, `subStatus`, `color`, `confirmed`, `activatedCount`, `activatedDate`, `feedbackBy`, `notifyEmail`, `mailto`, `openedBy`, `openedDate`, `openedBuild`, `assignedTo`, `assignedDate`, `deadline`, `resolvedBy`, `resolution`, `resolvedBuild`, `resolvedDate`, `closedBy`, `closedDate`, `duplicateBug`, `relatedBug`, `case`, `caseVersion`, `feedback`, `result`, `repo`, `mr`, `entry`, `lines`, `v1`, `v2`, `repoType`, `issueKey`, `testtask`, `lastEditedBy`, `lastEditedDate`, `deleted`) VALUES
(1, 2, 1, 0, 0, 0, 1, 3, 0, 1, 1, 1, 0, 0, '首页页面问题', '', 3, 1, 'codeerror', 'linux', 'chrome', '', '', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[步骤] 进入首页</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果] 出现乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望] 正常显示</span></p>', 'active', '', '', 0, 0, NULL, '', '', '', 'admin', '2024-04-02 16:12:08', 'trunk', 'admin', '2024-04-02 16:12:08', NULL, '', '', '', NULL, '', NULL, 0, '', 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', 0, '', NULL, '0'),
(2, 2, 1, 0, 0, 0, 2, 3, 0, 4, 1, 8, 0, 0, '新闻中心页面问题', '', 3, 2, 'codeerror', '', '', '', '', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[步骤] 进入首页</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果] 出现乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望] 正常显示</span></p>', 'active', '', '', 0, 0, NULL, '', '', '', 'admin', '2024-04-02 16:13:53', 'trunk', 'admin', '2024-04-02 16:13:53', NULL, '', '', '', NULL, '', NULL, 0, '', 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', 0, '', NULL, '0'),
(3, 2, 1, 0, 0, 0, 4, 3, 0, 4, 1, 7, 0, 0, '成果展示页面问题', '', 3, 1, 'codeerror', '', '', '', '', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[步骤] 进入首页</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果] 出现乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望] 正常显示</span></p>', 'active', '', '', 0, 0, NULL, '', '', '', 'admin', '2024-04-02 16:14:38', 'trunk', '', NULL, NULL, '', '', '', NULL, '', NULL, 0, '', 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', 0, '', NULL, '0'),
(4, 2, 1, 0, 0, 0, 4, 3, 0, 4, 1, 8, 0, 0, '售后服务页面问题', '', 3, 1, 'codeerror', '', '', '', '', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[步骤] 进入售后服务</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果]乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望]正常显示</span></p>', 'resolved', '', '', 1, 0, NULL, '', '', '', 'admin', '2024-04-02 16:15:52', 'trunk', 'admin', '2024-04-02 16:17:48', NULL, 'admin', 'fixed', 'trunk', '2024-04-02 00:00:00', '', NULL, 0, '', 0, 0, 0, 0, 0, 0, NULL, '', '', '', '', '', 0, 'admin', '2024-04-02 16:17:48', '0');
REPLACE INTO `zt_build` (`id`, `project`, `product`, `branch`, `execution`, `builds`, `name`, `scmPath`, `filePath`, `date`, `stories`, `bugs`, `artifactRepoID`, `builder`, `desc`, `createdBy`, `createdDate`, `deleted`) VALUES
(1, 2, 1, '0', 3, '', '第一期版本', '', '', '2024-04-02', ',4', '', 0, 'admin', '', 'admin', '2024-04-02 16:07:17', '0');
REPLACE INTO `zt_burn` (`execution`, `product`, `task`, `date`, `estimate`, `left`, `consumed`, `storyPoint`) VALUES
(3, 0, 0, '2024-04-02', 35, 35, 19, 2);
REPLACE INTO `zt_case` (`id`, `project`, `product`, `execution`, `branch`, `lib`, `module`, `path`, `story`, `storyVersion`, `title`, `precondition`, `keywords`, `pri`, `type`, `auto`, `frame`, `stage`, `howRun`, `script`, `scriptedBy`, `scriptedDate`, `scriptStatus`, `scriptLocation`, `status`, `subStatus`, `color`, `frequency`, `order`, `openedBy`, `openedDate`, `reviewedBy`, `reviewedDate`, `lastEditedBy`, `lastEditedDate`, `version`, `linkCase`, `fromBug`, `fromCaseID`, `fromCaseVersion`, `deleted`, `lastRunner`, `lastRunDate`, `lastRunResult`, `scene`, `sort`) VALUES
(1, 0, 1, 0, 0, 0, 0, 0, 4, 1, '售后服务的测试用例', '', '', 1, 'feature', 'no', '', 'feature', '', '', '', NULL, '', '', 'normal', '', '', '1', 0, 'admin', '2024-04-02 16:20:31', '', NULL, 'admin', '2024-04-02 16:23:55', 2, '', 0, 0, 1, '0', 'admin', '2024-04-02 16:30:26', 'pass', 0, 0),
(2, 0, 1, 0, 0, 0, 0, 0, 1, 1, '首页的测试用例', '', '', 3, 'feature', 'no', '', 'feature', '', '', '', NULL, '', '', 'normal', '', '', '1', 0, 'admin', '2024-04-02 16:23:33', '', NULL, '', NULL, 1, '', 0, 0, 1, '0', 'admin', '2024-04-02 16:30:26', 'pass', 0, 0),
(3, 0, 1, 0, 0, 0, 0, 0, 2, 1, '新闻中心的测试用例', '', '', 3, 'feature', 'no', '', 'feature', '', '', '', NULL, '', '', 'normal', '', '', '1', 0, 'admin', '2024-04-02 16:24:38', '', NULL, '', NULL, 1, '', 0, 0, 1, '0', 'admin', '2024-04-02 16:30:26', 'pass', 0, 0),
(4, 0, 1, 0, 0, 0, 0, 0, 3, 1, '成果展示测试用例', '', '', 3, 'feature', 'no', '', 'feature', '', '', '', NULL, '', '', 'normal', '', '', '1', 0, 'admin', '2024-04-02 16:25:09', '', NULL, '', NULL, 1, '', 0, 0, 1, '0', 'admin', '2024-04-02 16:30:26', 'pass', 0, 0);
REPLACE INTO `zt_casestep` (`id`, `parent`, `case`, `version`, `type`, `desc`, `expect`) VALUES
(1, 0, 1, 1, 'step', '进入首页', '正常显示'),
(2, 0, 1, 2, 'item', '进入首页', '正常显示'),
(3, 0, 2, 1, 'step', '进入首页', '正常显示'),
(4, 0, 2, 1, 'group', '检查项', ''),
(5, 4, 2, 1, 'step', '点击新闻中心', '进入新闻中心'),
(6, 0, 3, 1, 'step', '进入新闻中心', '正常显示'),
(7, 0, 4, 1, 'step', '进入成果展示', '正常显示');
REPLACE INTO `zt_dept` (`id`, `name`, `parent`, `path`, `grade`, `order`, `position`, `function`, `manager`) VALUES
(1, '经理', 0, ',1,', 1, 0, '', '', ''),
(2, '开发', 0, ',2,', 1, 0, '', '', ''),
(3, '测试', 0, ',3,', 1, 0, '', '', ''),
(4, '市场', 0, ',4,', 1, 0, '', '', ''),
(5, '产品', 1, ',1,5,', 2, 0, '', '', ''),
(6, '项目', 1, ',1,6,', 2, 0, '', '', ''),
(7, '编程', 2, ',2,7,', 2, 0, '', '', ''),
(8, '美工', 2, ',2,8,', 2, 0, '', '', '');
REPLACE INTO `zt_doclib` (`id`, `type`, `vision`, `product`, `project`, `execution`, `name`, `baseUrl`, `acl`, `groups`, `users`, `main`, `collector`, `desc`, `order`, `addedBy`, `addedDate`, `deleted`) VALUES
(1, 'product', 'rnd', 1, 0, 0, '产品主库', '', 'default', '', NULL, '1', NULL, NULL, 0, 'admin', '2024-04-02 14:30:13', '0'),
(2, 'product', 'rnd', 2, 0, 0, '产品主库', '', 'default', '', NULL, '1', NULL, NULL, 0, 'admin', '2024-04-02 14:30:55', '0'),
(3, 'project', 'rnd', 0, 2, 0, '项目主库', '', 'default', '', ',,', '1', NULL, NULL, 0, 'admin', '2024-04-02 14:34:13', '0'),
(4, 'execution', 'rnd', 0, 2, 3, '迭代主库', '', 'default', '', NULL, '1', NULL, NULL, 0, 'admin', '2024-04-02 14:35:32', '0'),
(5, 'execution', 'rnd', 0, 2, 4, '迭代主库', '', 'default', '', NULL, '1', NULL, NULL, 0, 'admin', '2024-04-02 14:36:20', '0');
REPLACE INTO `zt_effort` (`id`, `objectType`, `objectID`, `product`, `project`, `execution`, `account`, `work`, `vision`, `date`, `left`, `consumed`, `begin`, `end`, `extra`, `order`, `deleted`) VALUES
(1, 'task', 1, ',1,', 2, 3, 'projectManager', '', 'rnd', '2024-04-02', 0, 8, 0000, 0000, NULL, 0, '0'),
(2, 'task', 8, ',1,', 2, 3, 'admin', '', 'rnd', '2024-04-02', 0, 5, 0000, 0000, NULL, 0, '0'),
(3, 'task', 7, ',1,', 2, 3, 'admin', '', 'rnd', '2024-04-02', 0, 6, 0000, 0000, NULL, 0, '0');
REPLACE INTO `zt_history` (`id`, `action`, `field`, `old`, `new`, `diff`) VALUES
(1, 44, 'assignedTo', '', 'projectManager', ''),
(2, 45, 'assignedTo', '', 'projectManager', ''),
(3, 46, 'assignedTo', '', 'projectManager', ''),
(4, 47, 'assignedTo', '', 'projectManager', ''),
(5, 48, 'assignedTo', '', 'projectManager', ''),
(6, 49, 'assignedTo', '', 'projectManager', ''),
(7, 50, 'assignedTo', '', 'projectManager', ''),
(8, 51, 'assignedTo', '', 'projectManager', ''),
(9, 52, 'assignedTo', 'projectManager', 'admin', ''),
(10, 53, 'assignedTo', 'projectManager', 'admin', ''),
(11, 54, 'assignedTo', 'projectManager', 'admin', ''),
(12, 55, 'assignedTo', 'projectManager', 'admin', ''),
(13, 56, 'realStarted', '', '2024-04-02 15:58', ''),
(14, 56, 'left', '7', '0', ''),
(15, 56, 'consumed', '0', '8', ''),
(16, 56, 'assignedTo', 'projectManager', 'admin', ''),
(17, 56, 'status', 'wait', 'done', ''),
(18, 56, 'finishedDate', '', '2024-04-02 15:58', ''),
(19, 56, 'finishedBy', '', 'projectManager', ''),
(20, 60, 'status', 'wait', 'doing', ''),
(21, 60, 'realStarted', '', '2024-04-02 15:59', ''),
(22, 61, 'realStarted', '', '2024-04-02 15:00', ''),
(23, 61, 'left', '5', '0', ''),
(24, 61, 'consumed', '0', '5', ''),
(25, 61, 'status', 'wait', 'done', ''),
(26, 61, 'finishedDate', '', '2024-04-02 15:59', ''),
(27, 61, 'finishedBy', '', 'admin', ''),
(28, 62, 'realStarted', '', '2024-04-02 16:00', ''),
(29, 62, 'left', '5', '0', ''),
(30, 62, 'consumed', '0', '6', ''),
(31, 62, 'status', 'wait', 'done', ''),
(32, 62, 'finishedDate', '', '2024-04-02 16:00', ''),
(33, 62, 'finishedBy', '', 'admin', ''),
(34, 63, 'status', 'wait', 'doing', ''),
(35, 63, 'realStarted', '', '2024-04-02 16:00', ''),
(36, 64, 'status', 'wait', 'doing', ''),
(37, 64, 'realStarted', '', '2024-04-02 16:01', ''),
(38, 72, 'title', '成果展示页面问题', '售后服务页面问题', '001- <del>成果展示页面问题</del>\n001+ <ins>售后服务页面问题</ins>'),
(39, 72, 'pri', '3', '1', ''),
(40, 72, 'steps', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\"> [步骤]进入成果展示</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果]乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望]正常显示</span></p>', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[步骤]</span><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">进入售后服务</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果]乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望]正常显示</span></p>', '001- <del><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\"> [步骤]进入成果展示</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果]乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望]正常显示</span></p></del>\n001+ <ins><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[步骤]</span><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">进入售后服务</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[结果]乱码</span></p><p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">[期望]正常显示</span></p></ins>'),
(41, 73, 'status', 'active', 'resolved', ''),
(42, 73, 'confirmed', '0', '1', ''),
(43, 73, 'resolvedBuild', '', 'trunk', ''),
(44, 73, 'resolution', '', 'fixed', '001- <del></del>\n001+ <ins>fixed</ins>'),
(45, 73, 'resolvedBy', '', 'admin', ''),
(46, 73, 'resolvedDate', '', '2024-04-02', ''),
(47, 73, 'assignedTo', '', 'admin', ''),
(48, 77, 'story', '1', '4', ''),
(49, 77, 'version', '1', '2', ''),
(50, 81, 'stage', '', 'feature', '');
REPLACE INTO `zt_kanbancell` (`id`, `kanban`, `lane`, `column`, `type`, `cards`) VALUES
(1, 3, 1, 1, 'story', ',1,2,3,4,'),
(2, 3, 1, 2, 'story', ''),
(3, 3, 1, 3, 'story', ''),
(4, 3, 1, 4, 'story', ''),
(5, 3, 1, 5, 'story', ''),
(6, 3, 1, 6, 'story', ''),
(7, 3, 1, 7, 'story', ''),
(8, 3, 1, 8, 'story', ''),
(9, 3, 1, 9, 'story', ''),
(10, 3, 1, 10, 'story', ''),
(11, 3, 1, 11, 'story', ''),
(12, 3, 2, 12, 'bug', ',3,2,1,'),
(13, 3, 2, 13, 'bug', ''),
(14, 3, 2, 14, 'bug', ''),
(15, 3, 2, 15, 'bug', ''),
(16, 3, 2, 16, 'bug', ',4,'),
(17, 3, 2, 17, 'bug', ''),
(18, 3, 2, 18, 'bug', ''),
(19, 3, 2, 19, 'bug', ''),
(20, 3, 2, 20, 'bug', ''),
(21, 3, 3, 21, 'task', ',3,4,'),
(22, 3, 3, 22, 'task', ''),
(23, 3, 3, 23, 'task', ',6,5,2,'),
(24, 3, 3, 24, 'task', ',7,8,1,'),
(25, 3, 3, 25, 'task', ''),
(26, 3, 3, 26, 'task', ''),
(27, 3, 3, 27, 'task', ''),
(28, 4, 4, 28, 'story', ''),
(29, 4, 4, 29, 'story', ''),
(30, 4, 4, 30, 'story', ''),
(31, 4, 4, 31, 'story', ''),
(32, 4, 4, 32, 'story', ''),
(33, 4, 4, 33, 'story', ''),
(34, 4, 4, 34, 'story', ''),
(35, 4, 4, 35, 'story', ''),
(36, 4, 4, 36, 'story', ''),
(37, 4, 4, 37, 'story', ''),
(38, 4, 4, 38, 'story', ''),
(39, 4, 5, 39, 'bug', ''),
(40, 4, 5, 40, 'bug', ''),
(41, 4, 5, 41, 'bug', ''),
(42, 4, 5, 42, 'bug', ''),
(43, 4, 5, 43, 'bug', ''),
(44, 4, 5, 44, 'bug', ''),
(45, 4, 5, 45, 'bug', ''),
(46, 4, 5, 46, 'bug', ''),
(47, 4, 5, 47, 'bug', ''),
(48, 4, 6, 48, 'task', ''),
(49, 4, 6, 49, 'task', ''),
(50, 4, 6, 50, 'task', ''),
(51, 4, 6, 51, 'task', ''),
(52, 4, 6, 52, 'task', ''),
(53, 4, 6, 53, 'task', ''),
(54, 4, 6, 54, 'task', '');
REPLACE INTO `zt_kanbancolumn` (`id`, `parent`, `type`, `region`, `group`, `name`, `color`, `limit`, `order`, `archived`, `deleted`) VALUES
(1, 0, 'backlog', 0, 0, 'Backlog', '#333', -1, 0, '0', '0'),
(2, 0, 'ready', 0, 0, '准备好', '#333', -1, 0, '0', '0'),
(3, -1, 'develop', 0, 0, '开发', '#333', -1, 0, '0', '0'),
(4, 3, 'developing', 0, 0, '进行中', '#333', -1, 0, '0', '0'),
(5, 3, 'developed', 0, 0, '完成', '#333', -1, 0, '0', '0'),
(6, -1, 'test', 0, 0, '测试', '#333', -1, 0, '0', '0'),
(7, 6, 'testing', 0, 0, '进行中', '#333', -1, 0, '0', '0'),
(8, 6, 'tested', 0, 0, '完成', '#333', -1, 0, '0', '0'),
(9, 0, 'verified', 0, 0, '已验收', '#333', -1, 0, '0', '0'),
(10, 0, 'released', 0, 0, '已发布', '#333', -1, 0, '0', '0'),
(11, 0, 'closed', 0, 0, '已关闭', '#333', -1, 0, '0', '0'),
(12, 0, 'unconfirmed', 0, 0, '待确认', '#333', -1, 0, '0', '0'),
(13, 0, 'confirmed', 0, 0, '已确认', '#333', -1, 0, '0', '0'),
(14, -1, 'resolving', 0, 0, '解决中', '#333', -1, 0, '0', '0'),
(15, 14, 'fixing', 0, 0, '进行中', '#333', -1, 0, '0', '0'),
(16, 14, 'fixed', 0, 0, '完成', '#333', -1, 0, '0', '0'),
(17, -1, 'test', 0, 0, '测试', '#333', -1, 0, '0', '0'),
(18, 17, 'testing', 0, 0, '测试中', '#333', -1, 0, '0', '0'),
(19, 17, 'tested', 0, 0, '测试完毕', '#333', -1, 0, '0', '0'),
(20, 0, 'closed', 0, 0, '已关闭', '#333', -1, 0, '0', '0'),
(21, 0, 'wait', 0, 0, '未开始', '#333', -1, 0, '0', '0'),
(22, -1, 'develop', 0, 0, '开发', '#333', -1, 0, '0', '0'),
(23, 22, 'developing', 0, 0, '研发中', '#333', -1, 0, '0', '0'),
(24, 22, 'developed', 0, 0, '研发完毕', '#333', -1, 0, '0', '0'),
(25, 0, 'pause', 0, 0, '已暂停', '#333', -1, 0, '0', '0'),
(26, 0, 'canceled', 0, 0, '已取消', '#333', -1, 0, '0', '0'),
(27, 0, 'closed', 0, 0, '已关闭', '#333', -1, 0, '0', '0'),
(28, 0, 'backlog', 0, 0, 'Backlog', '#333', -1, 0, '0', '0'),
(29, 0, 'ready', 0, 0, '准备好', '#333', -1, 0, '0', '0'),
(30, -1, 'develop', 0, 0, '开发', '#333', -1, 0, '0', '0'),
(31, 30, 'developing', 0, 0, '进行中', '#333', -1, 0, '0', '0'),
(32, 30, 'developed', 0, 0, '完成', '#333', -1, 0, '0', '0'),
(33, -1, 'test', 0, 0, '测试', '#333', -1, 0, '0', '0'),
(34, 33, 'testing', 0, 0, '进行中', '#333', -1, 0, '0', '0'),
(35, 33, 'tested', 0, 0, '完成', '#333', -1, 0, '0', '0'),
(36, 0, 'verified', 0, 0, '已验收', '#333', -1, 0, '0', '0'),
(37, 0, 'released', 0, 0, '已发布', '#333', -1, 0, '0', '0'),
(38, 0, 'closed', 0, 0, '已关闭', '#333', -1, 0, '0', '0'),
(39, 0, 'unconfirmed', 0, 0, '待确认', '#333', -1, 0, '0', '0'),
(40, 0, 'confirmed', 0, 0, '已确认', '#333', -1, 0, '0', '0'),
(41, -1, 'resolving', 0, 0, '解决中', '#333', -1, 0, '0', '0'),
(42, 41, 'fixing', 0, 0, '进行中', '#333', -1, 0, '0', '0'),
(43, 41, 'fixed', 0, 0, '完成', '#333', -1, 0, '0', '0'),
(44, -1, 'test', 0, 0, '测试', '#333', -1, 0, '0', '0'),
(45, 44, 'testing', 0, 0, '测试中', '#333', -1, 0, '0', '0'),
(46, 44, 'tested', 0, 0, '测试完毕', '#333', -1, 0, '0', '0'),
(47, 0, 'closed', 0, 0, '已关闭', '#333', -1, 0, '0', '0'),
(48, 0, 'wait', 0, 0, '未开始', '#333', -1, 0, '0', '0'),
(49, -1, 'develop', 0, 0, '开发', '#333', -1, 0, '0', '0'),
(50, 49, 'developing', 0, 0, '研发中', '#333', -1, 0, '0', '0'),
(51, 49, 'developed', 0, 0, '研发完毕', '#333', -1, 0, '0', '0'),
(52, 0, 'pause', 0, 0, '已暂停', '#333', -1, 0, '0', '0'),
(53, 0, 'canceled', 0, 0, '已取消', '#333', -1, 0, '0', '0'),
(54, 0, 'closed', 0, 0, '已关闭', '#333', -1, 0, '0', '0');
REPLACE INTO `zt_kanbanlane` (`id`, `execution`, `type`, `region`, `group`, `groupby`, `extra`, `name`, `color`, `order`, `lastEditedTime`, `deleted`) VALUES
(1, 3, 'story', 0, 0, '', '', '研发需求', '#7ec5ff', 5, '2024-04-02 15:49:22', '0'),
(2, 3, 'bug', 0, 0, '', '', 'Bug', '#ba55d3', 10, '2024-04-02 16:17:49', '0'),
(3, 3, 'task', 0, 0, '', '', '任务', '#4169e1', 15, '2024-04-02 16:01:05', '0'),
(4, 4, 'story', 0, 0, '', '', '研发需求', '#7ec5ff', 5, NULL, '0'),
(5, 4, 'bug', 0, 0, '', '', 'Bug', '#ba55d3', 10, NULL, '0'),
(6, 4, 'task', 0, 0, '', '', '任务', '#4169e1', 15, NULL, '0');
REPLACE INTO `zt_module` (`id`, `root`, `branch`, `name`, `parent`, `path`, `grade`, `order`, `type`, `from`, `owner`, `collector`, `short`, `deleted`) VALUES
(1, 1, 0, '首页', 0, ',1,', 1, 10, 'story', 0, '', '', '', '0'),
(2, 1, 0, '新闻中心', 0, ',2,', 1, 20, 'story', 0, '', '', '', '0'),
(3, 1, 0, '成果展示', 0, ',3,', 1, 30, 'story', 0, '', '', '', '0'),
(4, 1, 0, '售后服务', 0, ',4,', 1, 40, 'story', 0, '', '', '', '0'),
(5, 1, 0, '诚聘英才', 0, ',5,', 1, 50, 'story', 0, '', '', '', '0'),
(6, 1, 0, '合作洽谈', 0, ',6,', 1, 60, 'story', 0, '', '', '', '0'),
(7, 1, 0, '关于我们', 0, ',7,', 1, 70, 'story', 0, '', '', '', '0'),
(8, 1, 0, '企业管理', 0, ',8,', 1, 0, 'line', 0, '', '', '', '0');
REPLACE INTO `zt_product` (`id`, `program`, `name`, `code`, `shadow`, `bind`, `line`, `type`, `status`, `subStatus`, `desc`, `PO`, `QD`, `RD`, `feedback`, `ticket`, `acl`, `groups`, `whitelist`, `reviewer`, `PMT`, `draftStories`, `activeStories`, `changingStories`, `reviewingStories`, `finishedStories`, `closedStories`, `totalStories`, `unresolvedBugs`, `closedBugs`, `fixedBugs`, `totalBugs`, `plans`, `releases`, `createdBy`, `createdDate`, `createdVersion`, `closedDate`, `order`, `vision`, `deleted`) VALUES
(1, 1, '公司企业网站建设', '', 0, '0', 0, 'normal', 'normal', '', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">建立公司企业网站，可以更好对外展示。</span></p>', 'productManager', '', 'projectManager', '', '', 'open', '', '', '', NULL, 0, 0, 0, 7, 0, 0, 7, 0, 0, 0, 0, 1, 0, 'admin', '2024-04-02 14:30:12', '20.0.beta2', NULL, 5, 'rnd', '0'),
(2, 1, '企业内部工时管理系统', '', 0, '0', 0, 'normal', 'normal', '', '', 'productManager', '', 'productManager', '', '', 'open', '', '', '', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'admin', '2024-04-02 14:30:55', '20.0.beta2', NULL, 10, 'rnd', '0');
REPLACE INTO `zt_productplan` (`id`, `product`, `branch`, `parent`, `title`, `status`, `desc`, `begin`, `end`, `finishedDate`, `closedDate`, `order`, `closedReason`, `createdBy`, `createdDate`, `deleted`) VALUES
(1, 1, '0', 0, '1.0版本', 'wait', '<p><span style=\"font-size:13px;font-family:\'Source Han Sans CN\', PingFangSC, \'Microsoft YaHei\', HiraginoSansGB, Roboto, Helvetica, Tahoma, sans-serif;\">开发出企业网站1.0版本。</span></p>', '2030-01-01', '2030-01-01', NULL, NULL, '0', '', 'admin', '2024-04-02 14:42:47', '0');
REPLACE INTO `zt_project` (`id`, `project`, `charter`, `model`, `type`, `category`, `lifetime`, `budget`, `budgetUnit`, `attribute`, `percent`, `milestone`, `output`, `auth`, `storyType`, parent`, `path`, `grade`, `name`, `code`, `hasProduct`, `begin`, `end`, `firstEnd`, `realBegan`, `realEnd`, `days`, `status`, `subStatus`, `pri`, `desc`, `version`, `parentVersion`, `planDuration`, `realDuration`, `progress`, `estimate`, `left`, `consumed`, `teamCount`, `market`, `openedBy`, `openedDate`, `openedVersion`, `lastEditedBy`, `lastEditedDate`, `closedBy`, `closedDate`, `closedReason`, `canceledBy`, `canceledDate`, `suspendedDate`, `PO`, `PM`, `QD`, `RD`, `team`, `acl`, `whitelist`, `order`, `vision`, `stageBy`, `displayCards`, `fluidBoard`, `multiple`, `parallel`, `colWidth`, `minColWidth`, `maxColWidth`, `deleted`) VALUES
(1, 0, 0, '', 'program', '', '', '', 'CNY', '', 0, '0', NULL, '', '', 0, ',1,', 1, '企业管理', '', 1, '2024-04-02', '2059-12-31', NULL, '2024-04-02', NULL, 0, 'doing', '', '1', '', 0, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 'admin', '2024-04-02 14:25:12', '', '', NULL, '', NULL, '', '', NULL, NULL, '', '0', '', '', '', 'open', 'admin,projectManager', 5, 'rnd', 'product', 0, '0', '1', 0, 264, 200, 384, '0'),
(2, 0, 0, 'scrum', 'project', '', '', '', 'CNY', '', 0, '0', NULL, 'extend', 'story,requirement', 1, ',1,2,', 2, '企业管理系统', '', 1, '2024-04-02', '2059-12-31', '2059-12-31', '2024-04-02', NULL, 0, 'doing', '', '1', '', 0, 0, 0, 0, 24.50, 52, 40, 13, 3, 0, 'admin', '2024-04-02 14:34:13', '', 'admin', '2024-04-02 14:34:13', '', NULL, '', '', NULL, NULL, '', 'projectManager', '', '', '企业管理系统', 'open', '', 10, 'rnd', 'product', 0, '0', '1', 0, 264, 200, 384, '0'),
(3, 2, 0, '', 'sprint', '', 'long', '0', 'CNY', '', 0, '0', NULL, '', '', 2, ',2,3,', 1, '企业网站第一期', '', 1, '2024-04-02', '2024-04-15', '2024-04-15', '2024-04-02', NULL, 10, 'doing', '', '1', '', 0, 0, 0, 0, 24.50, 52, 40, 13, 0, 0, 'admin', '2024-04-02 14:35:31', '20.0.beta2', 'admin', '2024-04-02 14:35:31', '', NULL, '', '', NULL, NULL, 'productManager', 'projectManager', '', 'productManager', '企业网站第一期 ', 'open', '', 15, 'rnd', 'product', 0, '0', '1', 0, 264, 200, 384, '0'),
(4, 2, 0, '', 'sprint', '', 'long', '0', 'CNY', '', 0, '0', NULL, '', '', 2, ',2,4,', 1, '企业网站第二期', '', 1, '2024-04-02', '2024-05-02', NULL, NULL, NULL, 23, 'wait', '', '1', '', 0, 0, 0, 0, 0.00, 0, 0, 0, 0, 0, 'admin', '2024-04-02 14:36:20', '20.0.beta2', 'admin', '2024-04-02 14:36:20', '', NULL, '', '', NULL, NULL, 'productManager', 'projectManager', 'admin', 'productManager', '企业网站第二期', 'open', '', 20, 'rnd', 'product', 0, '0', '1', 0, 264, 200, 384, '0');
REPLACE INTO `zt_projectadmin` (`group`, `account`, `programs`, `projects`, `products`, `executions`) VALUES
(1, 'admin', NULL, '2', NULL, NULL);
REPLACE INTO `zt_projectcase` (`project`, `product`, `case`, `count`, `version`, `order`) VALUES
(2, 1, 1, 1, 1, 1),
(2, 1, 2, 1, 1, 2),
(2, 1, 3, 1, 1, 3),
(2, 1, 4, 1, 1, 4),
(3, 1, 1, 1, 1, 1),
(3, 1, 2, 1, 1, 2),
(3, 1, 3, 1, 1, 3),
(3, 1, 4, 1, 1, 4);
REPLACE INTO `zt_projectproduct` (`project`, `product`, `branch`, `plan`) VALUES
(2, 1, 0, '0'),
(2, 2, 0, '0'),
(3, 1, 0, '0'),
(4, 1, 0, '0');
REPLACE INTO `zt_projectstory` (`project`, `product`, `branch`, `story`, `version`, `order`) VALUES
(2, 1, 0, 1, 1, 1),
(2, 1, 0, 2, 1, 2),
(2, 1, 0, 3, 1, 3),
(2, 1, 0, 4, 1, 4),
(3, 1, 0, 1, 1, 1),
(3, 1, 0, 2, 1, 2),
(3, 1, 0, 3, 1, 3),
(3, 1, 0, 4, 1, 4);
REPLACE INTO `zt_searchdict` (`key`, `value`) VALUES
(12289, '、'),
(12290, '。'),
(19968, '一'),
(19994, '业'),
(20013, '中'),
(20026, '为'),
(20080, '买'),
(20081, '乱'),
(20102, '了'),
(20108, '二'),
(20110, '于'),
(20135, '产'),
(20197, '以'),
(20204, '们'),
(20219, '任'),
(20225, '企'),
(20316, '作'),
(20363, '例'),
(20415, '便'),
(20449, '信'),
(20837, '入'),
(20844, '公'),
(20851, '关'),
(20869, '内'),
(20915, '决'),
(20986, '出'),
(20998, '分'),
(21040, '到'),
(21153, '务'),
(21160, '动'),
(21457, '发'),
(21487, '可'),
(21496, '司'),
(21512, '合'),
(21517, '名'),
(21518, '后'),
(21644, '和'),
(21697, '品'),
(21806, '售'),
(21830, '商'),
(22312, '在'),
(22522, '基'),
(22806, '外'),
(22909, '好'),
(22914, '如'),
(23481, '容'),
(23545, '对'),
(23637, '展'),
(24037, '工'),
(24076, '希'),
(24120, '常'),
(24182, '并'),
(24212, '应'),
(24314, '建'),
(24320, '开'),
(24515, '心'),
(24577, '态'),
(24687, '息'),
(25104, '成'),
(25105, '我'),
(25143, '户'),
(25165, '才'),
(25307, '招'),
(25910, '收'),
(26032, '新'),
(26041, '方'),
(26102, '时'),
(26174, '显'),
(26356, '更'),
(26368, '最'),
(26381, '服'),
(26395, '望'),
(26399, '期'),
(26412, '本'),
(26469, '来'),
(26524, '果'),
(26679, '样'),
(27491, '正'),
(27493, '步'),
(27714, '求'),
(27965, '洽'),
(27979, '测'),
(29256, '版'),
(29616, '现'),
(29702, '理'),
(29992, '用'),
(30340, '的'),
(30475, '看'),
(30721, '码'),
(31034, '示'),
(31435, '立'),
(31449, '站'),
(31532, '第'),
(31561, '等'),
(31649, '管'),
(31995, '系'),
(32467, '结'),
(32479, '统'),
(32593, '网'),
(32773, '者'),
(32844, '职'),
(32852, '联'),
(32856, '聘'),
(33521, '英'),
(34892, '行'),
(35299, '解'),
(35745, '计'),
(35774, '设'),
(35797, '试'),
(35802, '诚'),
(35813, '该'),
(35848, '谈'),
(36141, '购'),
(36807, '过'),
(36825, '这'),
(36827, '进'),
(36890, '通'),
(37096, '部'),
(37324, '里'),
(38382, '问'),
(38395, '闻'),
(38754, '面'),
(39029, '页'),
(39064, '题'),
(39318, '首'),
(39564, '验'),
(39588, '骤'),
(65292, '，');
REPLACE INTO `zt_searchindex` (`id`, `vision`, `objectType`, `objectID`, `title`, `content`, `addedDate`, `editedDate`) VALUES
(1, 'rnd', 'program', 1, ' 20225 19994 31649 29702', '', '2024-04-02 14:25:12', '2024-04-02 14:25:12'),
(2, 'rnd', 'product', 1, ' 20844 21496 20225 19994 32593 31449 24314 35774', ' 24314 31435 20844 21496 20225 19994 32593 31449 65292 21487 20197 26356 22909 23545 22806 23637 31034 12290', '2024-04-02 14:30:13', '2024-04-02 14:30:13'),
(3, 'rnd', 'product', 2, ' 20225 19994 20869 37096 24037 26102 31649 29702 31995 32479', '', '2024-04-02 14:30:55', '2024-04-02 14:30:55'),
(4, 'rnd', 'project', 2, ' 20225 19994 31649 29702 31995 32479', '', '2024-04-02 14:34:13', '2024-04-02 14:34:13'),
(5, 'rnd', 'execution', 3, ' 20225 19994 32593 31449 31532 19968 26399', '', '2024-04-02 14:35:32', '2024-04-02 14:35:32'),
(6, 'rnd', 'execution', 4, ' 20225 19994 32593 31449 31532 20108 26399', '', '2024-04-02 14:36:20', '2024-04-02 14:36:20'),
(7, 'rnd', 'productplan', 1, ' 1.0__ 29256 26412', ' 24320 21457 20986 20225 19994 32593 31449 1.0__ 29256 26412 12290', '2024-04-02 14:42:47', '2024-04-02 14:42:47'),
(8, 'rnd', 'story', 1, ' 39318 39029 35774 35745 21644 24320 21457', ' 39318 39029 35774 35745 21644 24320 21457 &____ |039| &____ |039| 20316 20026 19968 21517 26412 20844 21496 30340 29992 25143 65292 25105 24076 26395 21487 20197 22312 39318 39029 30475 21040 35813 20844 21496 32593 31449 30340 22522 26412 20869 23481 65292 20363 22914 26368 26032 21160 24577 12289 37096 20998 25104 26524 23637 31034 12289 32852 31995 20449 24687 12289 24037 21830 20449 24687 31561 12290 <__ br___ />_ 24320 21457 24182 36890 36807 39564 25910 <__ br___ />_', '2024-04-02 15:01:20', '2024-04-02 15:01:20'),
(9, 'rnd', 'story', 2, ' 26032 38395 20013 24515 30340 35774 35745 21644 24320 21457 12290', ' 26032 38395 20013 24515 30340 35774 35745 21644 24320 21457 12290 20316 20026 19968 21517 26412 20844 21496 30340 29992 25143 65292 25105 24076 26395 21487 20197 22312 26032 38395 20013 24515 30475 21040 35813 20844 21496 32593 31449 30340 20225 19994 26032 38395 65292 36825 26679 21487 20197 36890 36807 26032 38395 20102 35299 20225 19994 30340 26368 26032 21160 24577 12290', '2024-04-02 15:01:21', '2024-04-02 15:01:21'),
(10, 'rnd', 'story', 3, ' 25104 26524 23637 31034 30340 35774 35745 21644 24320 21457', ' 25104 26524 23637 31034 30340 35774 35745 21644 24320 21457   20316 20026 19968 21517 26412 20844 21496 30340 29992 25143 65292 25105 24076 26395 21487 20197 22312 25104 26524 23637 31034 30475 21040 35813 20844 21496 32593 31449 30340 20225 19994 26032 38395 65292 36825 26679 21487 20197 26041 20415 25105 36827 34892 20102 35299 35813 20844 21496 30340 20135 21697 24182 36827 34892 36141 20080 12290  ', '2024-04-02 15:01:21', '2024-04-02 15:01:21'),
(11, 'rnd', 'story', 4, ' 21806 21518 26381 21153 30340 35774 35745 21644 24320 21457', ' 21806 21518 26381 21153 30340 35774 35745 21644 24320 21457 20316 20026 19968 21517 26412 20844 21496 30340 29992 25143 65292 25105 24076 26395 21487 20197 22312 21806 21518 26381 21153 30475 21040 35813 20844 21496 32593 31449 30340 21806 21518 26381 21153 65292 36825 26679 21487 20197 26041 20415 25105 32852 31995 35813 20844 21496 26469 35299 20915 25105 30340 38382 39064 12290  ', '2024-04-02 15:01:21', '2024-04-02 15:01:21'),
(12, 'rnd', 'story', 5, ' 35802 32856 33521 25165 30340 35774 35745 21644 24320 21457', ' 35802 32856 33521 25165 30340 35774 35745 21644 24320 21457 20316 20026 19968 21517 27714 32844 32773 65292 25105 24076 26395 21487 20197 22312 35802 32856 33521 25165 37324 30475 21040 35813 20844 21496 30340 25307 32856 20449 24687 65292 36825 26679 21487 20197 26041 20415 25105 24212 32856 35813 20844 21496 12290  ', '2024-04-02 15:01:21', '2024-04-02 15:01:21'),
(13, 'rnd', 'story', 6, ' 21512 20316 27965 35848 30340 35774 35745 21644 24320 21457', ' 21512 20316 27965 35848 30340 35774 35745 21644 24320 21457 20316 20026 19968 21517 21512 20316 21830 65292 25105 24076 26395 21487 20197 22312 21512 20316 27965 35848 37324 30475 21040 35813 20844 21496 23545 22806 30340 21512 20316 20869 23481 65292 36825 26679 21487 20197 26041 20415 25105 21644 35813 20844 21496 36827 34892 21512 20316 27965 35848 12290  ', '2024-04-02 15:01:21', '2024-04-02 15:01:21'),
(14, 'rnd', 'story', 7, ' 20851 20110 25105 20204 30340 35774 35745 21644 24320 21457', ' 20851 20110 25105 20204 30340 35774 35745 21644 24320 21457 25105 24076 26395 21487 20197 22312 20851 20110 25105 20204 37324 30475 21040 35813 20844 21496 30340 22522 26412 20449 24687 65292 36825 26679 21487 20197 26041 20415 25105 20102 35299 35813 20844 21496 12290', '2024-04-02 15:01:21', '2024-04-02 15:01:21'),
(15, 'rnd', 'task', 1, ' 39318 39029 39029 38754 30340 35774 35745', ' 39318 39029 39029 38754 30340 35774 35745', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(16, 'rnd', 'task', 2, ' 39318 39029 39029 38754 30340 24320 21457', ' 39318 39029 39029 38754 30340 24320 21457', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(17, 'rnd', 'task', 3, ' 26032 38395 20013 24515 30340 35774 35745', ' 26032 38395 20013 24515 30340 35774 35745', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(18, 'rnd', 'task', 4, ' 26032 38395 20013 24515 30340 24320 21457', ' 26032 38395 20013 24515 30340 24320 21457', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(19, 'rnd', 'task', 5, ' 25104 26524 23637 31034 30340 35774 35745', ' 25104 26524 23637 31034 30340 35774 35745', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(20, 'rnd', 'task', 6, ' 25104 26524 23637 31034 30340 24320 21457', ' 25104 26524 23637 31034 30340 24320 21457', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(21, 'rnd', 'task', 7, ' 21806 21518 26381 21153 30340 35774 35745', ' 21806 21518 26381 21153 30340 35774 35745', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(22, 'rnd', 'task', 8, ' 21806 21518 26381 21153 30340 24320 21457', ' 21806 21518 26381 21153 30340 24320 21457', '2024-04-02 15:57:17', '2024-04-02 15:57:17'),
(23, 'rnd', 'build', 1, ' 31532 19968 26399 29256 26412', '', '2024-04-02 16:07:17', '2024-04-02 16:07:17'),
(24, 'rnd', 'bug', 1, ' 39318 39029 39029 38754 38382 39064', ' 27493 39588 36827 20837 39318 39029 32467 26524 20986 29616 20081 30721 26399 26395 27491 24120 26174 31034', '2024-04-02 16:12:08', '2024-04-02 16:12:08'),
(25, 'rnd', 'bug', 2, ' 26032 38395 20013 24515 39029 38754 38382 39064', ' 27493 39588 36827 20837 39318 39029 32467 26524 20986 29616 20081 30721 26399 26395 27491 24120 26174 31034', '2024-04-02 16:13:53', '2024-04-02 16:13:53'),
(26, 'rnd', 'bug', 3, ' 25104 26524 23637 31034 39029 38754 38382 39064', ' 27493 39588 36827 20837 39318 39029 32467 26524 20986 29616 20081 30721 26399 26395 27491 24120 26174 31034', '2024-04-02 16:14:38', '2024-04-02 16:14:38'),
(28, 'rnd', 'bug', 4, ' 21806 21518 26381 21153 39029 38754 38382 39064', ' 27493 39588 36827 20837 21806 21518 26381 21153 32467 26524 20081 30721 26399 26395 27491 24120 26174 31034', '2024-04-02 16:15:52', '2024-04-02 16:16:52'),
(31, 'rnd', 'case', 2, ' 39318 39029 30340 27979 35797 29992 20363', '', '2024-04-02 16:23:34', '2024-04-02 16:23:34'),
(32, 'rnd', 'case', 1, ' 21806 21518 26381 21153 30340 27979 35797 29992 20363', ' 36827 20837 39318 39029 27491 24120 26174 31034', '2024-04-02 16:20:31', '2024-04-02 16:23:56'),
(33, 'rnd', 'case', 3, ' 26032 38395 20013 24515 30340 27979 35797 29992 20363', '', '2024-04-02 16:24:38', '2024-04-02 16:24:38'),
(34, 'rnd', 'case', 4, ' 25104 26524 23637 31034 27979 35797 29992 20363', '', '2024-04-02 16:25:09', '2024-04-02 16:25:09'),
(35, 'rnd', 'testtask', 1, ' 20225 19994 32593 31449 31532 19968 26399 27979 35797 20219 21153', '', '2024-04-02 16:26:35', '2024-04-02 16:26:35');
REPLACE INTO `zt_story` (`id`, `vision`, `parent`, `product`, `branch`, `module`, `plan`, `source`, `sourceNote`, `fromBug`, `feedback`, `title`, `keywords`, `type`, `category`, `pri`, `estimate`, `status`, `subStatus`, `color`, `stage`, `stagedBy`, `mailto`, `lib`, `fromStory`, `fromVersion`, `openedBy`, `openedDate`, `assignedTo`, `assignedDate`, `approvedDate`, `lastEditedBy`, `lastEditedDate`, `changedBy`, `changedDate`, `reviewedBy`, `reviewedDate`, `releasedDate`, `closedBy`, `closedDate`, `closedReason`, `activatedDate`, `toBug`, `linkStories`, `linkRequirements`, `twins`, `duplicateStory`, `version`, `storyChanged`, `feedbackBy`, `notifyEmail`, `BSA`, `duration`, `demand`, `submitedBy`, `roadmap`, `URChanged`, `retractedReason`, `retractedBy`, `retractedDate`, `deleted`) VALUES
(1, 'rnd', 0, 1, 0, 1, '1', '', '', 0, 0, '首页设计和开发', '', 'story', 'feature', 1, 1, 'active', '', '', 'developing', '', '', 0, 0, 1, 'admin', '2024-04-02 15:01:20', '', NULL, NULL, 'productManager', '2024-04-02 15:04:35', '', NULL, ',productManager', '2024-04-02 15:04:35', NULL, '', NULL, '', NULL, 0, '', '', '', 0, 1, '0', '', '', '', '', 0, '', '', '0', '', '', NULL, '0'),
(2, 'rnd', 0, 1, 0, 2, '1', '', '', 0, 0, '新闻中心的设计和开发。', '', 'story', 'feature', 1, 1, 'active', '', '', 'projected', '', '', 0, 0, 1, 'admin', '2024-04-02 15:01:20', '', NULL, NULL, 'productManager', '2024-04-02 15:04:35', '', NULL, ',productManager', '2024-04-02 15:04:35', NULL, '', NULL, '', NULL, 0, '', '', '', 0, 1, '0', '', '', '', '', 0, '', '', '0', '', '', NULL, '0'),
(3, 'rnd', 0, 1, 0, 3, '1', '', '', 0, 0, '成果展示的设计和开发', '', 'story', 'feature', 1, 0, 'active', '', '', 'developing', '', '', 0, 0, 1, 'admin', '2024-04-02 15:01:20', '', NULL, NULL, 'productManager', '2024-04-02 15:04:35', '', NULL, ',productManager', '2024-04-02 15:04:35', NULL, '', NULL, '', NULL, 0, '', '', '', 0, 1, '0', '', '', '', '', 0, '', '', '0', '', '', NULL, '0'),
(4, 'rnd', 0, 1, 0, 4, '1', '', '', 0, 0, '售后服务的设计和开发', '', 'story', 'feature', 1, 1, 'active', '', '', 'developed', '', '', 0, 0, 1, 'admin', '2024-04-02 15:01:20', '', NULL, NULL, 'productManager', '2024-04-02 15:04:35', '', NULL, ',productManager', '2024-04-02 15:04:35', NULL, '', NULL, '', NULL, 0, '', '', '', 0, 1, '0', '', '', '', '', 0, '', '', '0', '', '', NULL, '0'),
(5, 'rnd', 0, 1, 0, 5, '1', '', '', 0, 0, '诚聘英才的设计和开发', '', 'story', 'feature', 1, 1, 'reviewing', '', '', 'planned', '', '', 0, 0, 1, 'admin', '2024-04-02 15:01:20', '', NULL, NULL, '', NULL, '', NULL, '', NULL, NULL, '', NULL, '', NULL, 0, '', '', '', 0, 1, '0', '', '', '', '', 0, '', '', '0', '', '', NULL, '0'),
(6, 'rnd', 0, 1, 0, 6, '1', '', '', 0, 0, '合作洽谈的设计和开发', '', 'story', 'feature', 1, 1, 'reviewing', '', '', 'planned', '', '', 0, 0, 1, 'admin', '2024-04-02 15:01:20', '', NULL, NULL, '', NULL, '', NULL, '', NULL, NULL, '', NULL, '', NULL, 0, '', '', '', 0, 1, '0', '', '', '', '', 0, '', '', '0', '', '', NULL, '0'),
(7, 'rnd', 0, 1, 0, 7, '1', '', '', 0, 0, '关于我们的设计和开发', '', 'story', 'feature', 1, 1, 'reviewing', '', '', 'planned', '', '', 0, 0, 1, 'admin', '2024-04-02 15:01:20', '', NULL, NULL, '', NULL, '', NULL, '', NULL, NULL, '', NULL, '', NULL, 0, '', '', '', 0, 1, '0', '', '', '', '', 0, '', '', '0', '', '', NULL, '0');
REPLACE INTO `zt_storyreview` (`story`, `version`, `reviewer`, `result`, `reviewDate`) VALUES
(1, 1, 'productManager', 'pass', '2024-04-02 15:04:35'),
(2, 1, 'productManager', 'pass', '2024-04-02 15:04:35'),
(3, 1, 'productManager', 'pass', '2024-04-02 15:04:35'),
(4, 1, 'productManager', 'pass', '2024-04-02 15:04:35'),
(5, 1, 'productManager', '', NULL),
(6, 1, 'productManager', '', NULL),
(7, 1, 'productManager', '', NULL);
REPLACE INTO `zt_storyspec` (`story`, `version`, `title`, `spec`, `verify`, `files`) VALUES
(1, 1, '首页设计和开发', '首页设计和开发', '作为一名本公司的用户，我希望可以在首页看到该公司网站的基本内容，例如最新动态、部分成果展示、联系信息、工商信息等。<br />', '开发并通过验收<br />', ''),
(2, 1, '新闻中心的设计和开发。', '新闻中心的设计和开发。\', \'作为一名本公司的用户，我希望可以在新闻中心看到该公司网站的企业新闻，这样可以通过新闻了解企业的最新动态。<br />', '', ''),
(3, 1, '成果展示的设计和开发', '成果展示的设计和开发\', \' 作为一名本公司的用户，我希望可以在成果展示看到该公司网站的企业新闻，这样可以方便我进行了解该公司的产品并进行购买。 <br />', '', ''),
(4, 1, '售后服务的设计和开发', '售后服务的设计和开发\', \'作为一名本公司的用户，我希望可以在售后服务看到该公司网站的售后服务，这样可以方便我联系该公司来解决我的问题。 <br />', '', ''),
(5, 1, '诚聘英才的设计和开发', '诚聘英才的设计和开发\', \'作为一名求职者，我希望可以在诚聘英才里看到该公司的招聘信息，这样可以方便我应聘该公司。 <br />', '', ''),
(6, 1, '合作洽谈的设计和开发', '合作洽谈的设计和开发\', \'作为一名合作商，我希望可以在合作洽谈里看到该公司对外的合作内容，这样可以方便我和该公司进行合作洽谈。 <br />', '', ''),
(7, 1, '关于我们的设计和开发', '关于我们的设计和开发\', \'我希望可以在关于我们里看到该公司的基本信息，这样可以方便我了解该公司。<br />', '', '');
REPLACE INTO `zt_task` (`id`, `project`, `parent`, `execution`, `module`, `design`, `story`, `storyVersion`, `designVersion`, `fromBug`, `feedback`, `fromIssue`, `name`, `type`, `mode`, `pri`, `estimate`, `consumed`, `left`, `deadline`, `status`, `subStatus`, `color`, `mailto`, `keywords`, `desc`, `version`, `openedBy`, `openedDate`, `assignedTo`, `assignedDate`, `estStarted`, `realStarted`, `finishedBy`, `finishedDate`, `finishedList`, `canceledBy`, `canceledDate`, `closedBy`, `closedDate`, `planDuration`, `realDuration`, `closedReason`, `lastEditedBy`, `lastEditedDate`, `activatedDate`, `order`, `repo`, `mr`, `entry`, `lines`, `v1`, `v2`, `deleted`, `vision`) VALUES
(1, 2, 0, 3, 1, 0, 1, 1, 1, 0, 0, 0, '首页页面的设计', 'design', '', 1, 7, 8, 0, NULL, 'done', '', '', NULL, '', '首页页面的设计', 1, 'admin', '2024-04-02 15:57:16', 'admin', '2024-04-02 15:58:53', NULL, '2024-04-02 15:58:00', 'projectManager', '2024-04-02 15:58:00', NULL, '', NULL, '', NULL, 0, 0, '', 'projectManager', '2024-04-02 15:58:53', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd'),
(2, 2, 0, 3, 1, 0, 1, 1, 1, 0, 0, 0, '首页页面的开发', 'devel', '', 3, 8, 0, 8, NULL, 'doing', '', '', NULL, '', '首页页面的开发', 1, 'admin', '2024-04-02 15:57:16', 'projectManager', '2024-04-02 15:58:26', NULL, '2024-04-02 15:59:00', '', NULL, NULL, '', NULL, '', NULL, 0, 0, '', 'projectManager', '2024-04-02 15:59:19', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd'),
(3, 2, 0, 3, 2, 0, 2, 1, 1, 0, 0, 0, '新闻中心的设计', 'design', '', 3, 7, 0, 7, NULL, 'wait', '', '', NULL, '', '新闻中心的设计', 1, 'admin', '2024-04-02 15:57:16', 'projectManager', '2024-04-02 15:58:26', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, 0, 0, '', 'projectManager', '2024-04-02 15:58:26', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd'),
(4, 2, 0, 3, 2, 0, 2, 1, 1, 0, 0, 0, '新闻中心的开发', 'devel', '', 3, 7, 0, 7, NULL, 'wait', '', '', NULL, '', '新闻中心的开发', 1, 'admin', '2024-04-02 15:57:16', 'projectManager', '2024-04-02 15:58:26', NULL, NULL, '', NULL, NULL, '', NULL, '', NULL, 0, 0, '', 'projectManager', '2024-04-02 15:58:26', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd'),
(5, 2, 0, 3, 3, 0, 3, 1, 1, 0, 0, 0, '成果展示的设计', 'design', '', 3, 6, 0, 6, NULL, 'doing', '', '', NULL, '', '成果展示的设计', 1, 'admin', '2024-04-02 15:57:16', 'admin', '2024-04-02 15:58:39', NULL, '2024-04-02 16:00:00', '', NULL, NULL, '', NULL, '', NULL, 0, 0, '', 'admin', '2024-04-02 16:01:01', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd'),
(6, 2, 0, 3, 3, 0, 3, 1, 1, 0, 0, 0, '成果展示的开发', 'devel', '', 3, 7, 0, 7, NULL, 'doing', '', '', NULL, '', '成果展示的开发', 1, 'admin', '2024-04-02 15:57:16', 'admin', '2024-04-02 15:58:39', NULL, '2024-04-02 16:01:00', '', NULL, NULL, '', NULL, '', NULL, 0, 0, '', 'admin', '2024-04-02 16:01:05', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd'),
(7, 2, 0, 3, 4, 0, 4, 1, 1, 0, 0, 0, '售后服务的设计', 'design', '', 3, 5, 6, 0, NULL, 'done', '', '', NULL, '', '售后服务的设计', 1, 'admin', '2024-04-02 15:57:16', 'admin', '2024-04-02 16:00:49', NULL, '2024-04-02 16:00:00', 'admin', '2024-04-02 16:00:00', NULL, '', NULL, '', NULL, 0, 0, '', 'admin', '2024-04-02 16:00:49', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd'),
(8, 2, 0, 3, 4, 0, 4, 1, 1, 0, 0, 0, '售后服务的开发', 'devel', '', 3, 5, 5, 0, NULL, 'done', '', '', NULL, '', '售后服务的开发', 1, 'admin', '2024-04-02 15:57:16', 'admin', '2024-04-02 16:00:18', NULL, '2024-04-02 15:00:00', 'admin', '2024-04-02 15:59:00', NULL, '', NULL, '', NULL, 0, 0, '', 'admin', '2024-04-02 16:00:18', NULL, 0, 0, 0, '', '', '', '', '0', 'rnd');
REPLACE INTO `zt_taskspec` (`task`, `version`, `name`, `estStarted`, `deadline`) VALUES
(1, 1, '首页页面的设计', NULL, NULL),
(2, 1, '首页页面的开发', NULL, NULL),
(3, 1, '新闻中心的设计', NULL, NULL),
(4, 1, '新闻中心的开发', NULL, NULL),
(5, 1, '成果展示的设计', NULL, NULL),
(6, 1, '成果展示的开发', NULL, NULL),
(7, 1, '售后服务的设计', NULL, NULL),
(8, 1, '售后服务的开发', NULL, NULL);
REPLACE INTO `zt_team` (`id`, `root`, `type`, `account`, `role`, `position`, `limited`, `join`, `days`, `hours`, `estimate`, `consumed`, `left`, `order`) VALUES
(1, 2, 'project', 'admin', '', '', 'no', '2024-04-02', 0, 7.0, 0.00, 0.00, 0.00, 0),
(2, 2, 'project', 'projectManager', '项目经理', '', 'no', '2024-04-02', 0, 7.0, 0.00, 0.00, 0.00, 0),
(3, 3, 'execution', 'admin', '', '', 'no', '2024-04-02', 10, 7.0, 0.00, 0.00, 0.00, 0),
(4, 3, 'execution', 'projectManager', '项目经理', '', 'no', '2024-04-02', 10, 7.0, 0.00, 0.00, 0.00, 0),
(5, 3, 'execution', 'productManager', '产品经理', '', 'no', '2024-04-02', 10, 7.0, 0.00, 0.00, 0.00, 0),
(6, 2, 'project', 'productManager', '产品经理', '', 'no', '2024-04-02', 10, 7.0, 0.00, 0.00, 0.00, 0),
(7, 4, 'execution', 'admin', '', '', 'no', '2024-04-02', 23, 7.0, 0.00, 0.00, 0.00, 0),
(8, 4, 'execution', 'productManager', '产品经理', '', 'no', '2024-04-02', 23, 7.0, 0.00, 0.00, 0.00, 0),
(9, 4, 'execution', 'projectManager', '项目经理', '', 'no', '2024-04-02', 23, 7.0, 0.00, 0.00, 0.00, 0);
REPLACE INTO `zt_testresult` (`id`, `run`, `case`, `version`, `job`, `compile`, `caseResult`, `stepResults`, `ZTFResult`, `node`, `lastRunner`, `date`, `duration`, `xml`, `deploy`) VALUES
(1, 4, 4, 1, 0, 0, 'pass', 'a:1:{i:7;a:2:{s:6:\"result\";s:4:\"pass\";s:4:\"real\";s:0:\"\";}}', NULL, 0, 'admin', '2024-04-02 16:30:26', 0, NULL, 0),
(2, 3, 3, 1, 0, 0, 'pass', 'a:1:{i:6;a:2:{s:6:\"result\";s:4:\"pass\";s:4:\"real\";s:0:\"\";}}', NULL, 0, 'admin', '2024-04-02 16:30:26', 0, NULL, 0),
(3, 2, 2, 1, 0, 0, 'pass', 'a:2:{i:3;a:2:{s:6:\"result\";s:4:\"pass\";s:4:\"real\";s:0:\"\";}i:5;a:2:{s:6:\"result\";s:4:\"pass\";s:4:\"real\";s:0:\"\";}}', NULL, 0, 'admin', '2024-04-02 16:30:26', 0, NULL, 0),
(4, 1, 1, 2, 0, 0, 'pass', 'a:1:{i:2;a:2:{s:6:\"result\";s:4:\"pass\";s:4:\"real\";s:0:\"\";}}', NULL, 0, 'admin', '2024-04-02 16:30:26', 0, NULL, 0);
REPLACE INTO `zt_testrun` (`id`, `task`, `case`, `version`, `assignedTo`, `lastRunner`, `lastRunDate`, `lastRunResult`, `status`) VALUES
(1, 1, 1, 2, '', 'admin', '2024-04-02 16:30:26', 'pass', 'normal'),
(2, 1, 2, 1, '', 'admin', '2024-04-02 16:30:26', 'pass', 'normal'),
(3, 1, 3, 1, '', 'admin', '2024-04-02 16:30:26', 'pass', 'normal'),
(4, 1, 4, 1, '', 'admin', '2024-04-02 16:30:26', 'pass', 'normal');
REPLACE INTO `zt_testtask` (`id`, `project`, `product`, `name`, `execution`, `build`, `type`, `owner`, `pri`, `begin`, `end`, `realBegan`, `realFinishedDate`, `mailto`, `desc`, `report`, `status`, `testreport`, `auto`, `subStatus`, `createdBy`, `createdDate`, `deleted`, `members`) VALUES
(1, 2, 1, '企业网站第一期测试任务', 3, '1', 'integrate', 'admin', 1, '2024-04-02', '2024-04-05', NULL, NULL, '', '', NULL, 'wait', 0, 'no', '', 'admin', '2024-04-02 16:26:35', '0', '');
REPLACE INTO `zt_user` (`company`, `dept`, `account`, `type`, `password`, `role`, `realname`, `nickname`, `commiter`, `avatar`, `birthday`, `gender`, `email`, `skype`, `qq`, `mobile`, `phone`, `weixin`, `dingding`, `slack`, `whatsapp`, `address`, `zipcode`, `nature`, `analysis`, `strategy`, `join`, `visits`, `ip`, `last`, `fails`, `locked`, `ranzhi`, `score`, `scoreLevel`, `deleted`) VALUES
(0, 5, 'productManager', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'po', '产品经理', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 3, '192.168.0.8', 1338866083, 0, null, '', 0, 0, '0'),
(0, 6, 'projectManager', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'pm', '项目经理', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 4, '10.0.2.2', 1619580798, 0, null, '', 0, 0, '0'),
(0, 2, 'dev1', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'dev', '开发甲', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 3, '10.0.2.2', 1619586993, 0, null, '', 0, 0, '1'),
(0, 2, 'dev2', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'dev', '开发乙', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 2, '10.0.2.2', 1619587173, 0, null, '', 0, 0, '1'),
(0, 2, 'dev3', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'dev', '开发丙', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 2, '10.0.2.2', 1619587220, 0, null, '', 0, 0, '1'),
(0, 3, 'tester1', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'qa', '测试甲', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 3, '192.168.0.8', 1338865739, 0, null, '', 0, 0, '1'),
(0, 3, 'tester2', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'qa', '测试乙', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 2, '192.168.0.8', 1338865450, 0, null, '', 0, 0, '1'),
(0, 3, 'tester3', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'qa', '测试丙', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 1, '192.168.0.8', 1338865125, 0, null, '', 0, 0, '1'),
(0, 1, 'testManager', 'inside', 'e10adc3949ba59abbe56e057f20f883e', 'qd', '测试经理', '', '', '', null, 'm', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null, 6, '192.168.0.8', 1338865842, 0, null, '', 0, 0, '1');
REPLACE INTO `zt_usergroup` (`account`, `group`, `project`) VALUES
('productManager', 5, ''),
('projectManager', 4, ''),
('dev1', 2, ''),
('dev2', 2, ''),
('dev3', 2, ''),
('tester3', 3, ''),
('tester2', 3, ''),
('tester1', 3, ''),
('testManager', 8, '');
REPLACE INTO `zt_userview` (`account`, `programs`, `projects`, `products`, `sprints`) VALUES
('admin', '', '', '', ''),
('dev1', '', '', '', ''),
('dev2', '', '', '', ''),
('dev3', '', '', '', ''),
('productManager', '', '', '', ''),
('projectManager', '', '', '', ''),
('tester1', '', '', '', ''),
('tester2', '', '', '', ''),
('tester3', '', '', '', ''),
('testManager', '', '', '', '');