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
(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
(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, 2, 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, 3, 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, 5, 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, 5, 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
(2, 'product', 'rnd', 1, 0, 0, '产品主库', '', 'default', '', NULL, '1', NULL, NULL, 0, 'admin', '2024-04-02 14:30:13', '0'),
(3, 'product', 'rnd', 2, 0, 0, '产品主库', '', 'default', '', NULL, '1', NULL, NULL, 0, 'admin', '2024-04-02 14:30:55', '0'),
(4, 'project', 'rnd', 0, 2, 0, '项目主库', '', 'default', '', ',,', '1', NULL, NULL, 0, 'admin', '2024-04-02 14:34:13', '0'),
(5, 'execution', 'rnd', 0, 2, 3, '迭代主库', '', 'default', '', NULL, '1', NULL, NULL, 0, 'admin', '2024-04-02 14:35:32', '0'),
(6, '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
(2, 1, 0, '首页', 0, ',2,', 1, 10, 'story', 0, '', '', '', '0'),
(3, 1, 0, '新闻中心', 0, ',3,', 1, 20, 'story', 0, '', '', '', '0'),
(4, 1, 0, '成果展示', 0, ',4,', 1, 30, 'story', 0, '', '', '', '0'),
(5, 1, 0, '售后服务', 0, ',5,', 1, 40, 'story', 0, '', '', '', '0'),
(6, 1, 0, '诚聘英才', 0, ',6,', 1, 50, 'story', 0, '', '', '', '0'),
(7, 1, 0, '合作洽谈', 0, ',7,', 1, 60, 'story', 0, '', '', '', '0'),
(8, 1, 0, '关于我们', 0, ',8,', 1, 70, 'story', 0, '', '', '', '0'),
(9, 1, 0, '企业管理', 0, ',9,', 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;\">建立公司企业网站，可以更好对外展示。</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;\">开发出企业网站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);
TRUNCATE TABLE `zt_searchindex`;
INSERT 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 &lt__ br___  /&gt_ 24320 21457 24182 36890 36807 39564 25910 &lt__ br___  /&gt_', '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  &nbsp 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 &nbsp', '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 &nbsp', '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 &nbsp', '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 &nbsp', '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, 2, '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, 3, '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, 4, '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, 5, '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, 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'),
(6, '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'),
(7, 'rnd', 0, 1, 0, 8, '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, '首页设计和开发', '首页设计和开发&#039;, &#039;作为一名本公司的用户，我希望可以在首页看到该公司网站的基本内容，例如最新动态、部分成果展示、联系信息、工商信息等。&lt;br /&gt;', '开发并通过验收&lt;br /&gt;', ''),
(2, 1, '新闻中心的设计和开发。', '新闻中心的设计和开发。\', \'作为一名本公司的用户，我希望可以在新闻中心看到该公司网站的企业新闻，这样可以通过新闻了解企业的最新动态。<br />', '', ''),
(3, 1, '成果展示的设计和开发', '成果展示的设计和开发\', \'&nbsp;作为一名本公司的用户，我希望可以在成果展示看到该公司网站的企业新闻，这样可以方便我进行了解该公司的产品并进行购买。&nbsp;<br />', '', ''),
(4, 1, '售后服务的设计和开发', '售后服务的设计和开发\', \'作为一名本公司的用户，我希望可以在售后服务看到该公司网站的售后服务，这样可以方便我联系该公司来解决我的问题。&nbsp;<br />', '', ''),
(5, 1, '诚聘英才的设计和开发', '诚聘英才的设计和开发\', \'作为一名求职者，我希望可以在诚聘英才里看到该公司的招聘信息，这样可以方便我应聘该公司。&nbsp;<br />', '', ''),
(6, 1, '合作洽谈的设计和开发', '合作洽谈的设计和开发\', \'作为一名合作商，我希望可以在合作洽谈里看到该公司对外的合作内容，这样可以方便我和该公司进行合作洽谈。&nbsp;<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, 2, 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, 2, 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, 3, 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, 3, 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, 4, 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, 4, 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, 5, 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, 5, 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_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', '', '', '', '');