– phpMyAdmin SQL Dump
– version 4.4.3
– http://www.phpmyadmin.net
– Host: localhost:3306
– Generation Time: Jul 03, 2015 at 02:09 AM
– Server version: 5.5.42
– PHP Version: 5.4.40
SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
SET time_zone = “+00:00”;
/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 /;
–
– Database: bitnami_redmine
–
– Table structure for table attachments
CREATE TABLE IF NOT EXISTS attachments
(
id
int(11) NOT NULL,
container_id
int(11) DEFAULT NULL,
container_type
varchar(30) DEFAULT NULL,
filename
varchar(255) NOT NULL DEFAULT ”,
disk_filename
varchar(255) NOT NULL DEFAULT ”,
filesize
int(11) NOT NULL DEFAULT ‘0’,
content_type
varchar(255) DEFAULT ”,
digest
varchar(40) NOT NULL DEFAULT ”,
downloads
int(11) NOT NULL DEFAULT ‘0’,
author_id
int(11) NOT NULL DEFAULT ‘0’,
created_on
datetime DEFAULT NULL,
description
varchar(255) DEFAULT NULL,
disk_directory
varchar(255) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
–
– Truncate table before insert attachments
TRUNCATE TABLE attachments
;
– Dumping data for table attachments
INSERT INTO attachments
(id
, container_id
, container_type
, filename
, disk_filename
, filesize
, content_type
, digest
, downloads
, author_id
, created_on
, description
, disk_directory
) VALUES
(1, 25, ‘Issue’, ‘ui.PNG’, ‘150625150512_ui.PNG’, 29791, ‘image/png’, ‘8bda813157ed1d19352eb0dbb81f3595’, 0, 3, ‘2015-06-25 15:05:12’, ”, ‘2015/06’),
(2, 276, ‘Issue’, ‘이미지 2.png’, ‘150630162631_832d63e77cf9ca97e406132a9698ba1e.png’, 25651, ‘image/png’, ‘06040dd23e9f0ce2169d42d8102a3970’, 0, 7, ‘2015-06-30 16:26:31’, ”, ‘2015/06’),
(5, 1, ‘Project’, ‘guide_redmine.pptx’, ‘150702104858_guide_redmine.pptx’, 323732, ‘application/vnd.openxmlformats-officedocument.presentationml.presentation’, ‘aa9aec272f927a5d3b7375a23cf9a6f4’, 5, 22, ‘2015-07-02 10:48:58’, ”, ‘2015/07’),
(6, 348, ‘Issue’, ‘이미지 1.png’, ‘150702154451_1ffc346d0df7326606c2e5214d542dcc.png’, 26225, ‘image/png’, ‘253c819a1e43ef80d72d23869aa752a6’, 0, 7, ‘2015-07-02 15:44:51’, ”, ‘2015/07’),
(7, 1, ‘Project’, ‘TIPS_개발검수_LIST_150630.xlsx’, ‘150702164124_3cf632aff659d6103f2d715377754c0a.xlsx’, 207508, ‘application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’, ‘db053b8fccdb94e0ddf269904b6535ce’, 0, 20, ‘2015-07-02 16:41:24’, ”, ‘2015/07’),
(8, 1, ‘Project’, ‘TIPS_개발검수_LIST_150629.xlsx’, ‘150702164124_2d467493442f7c184dc2e533c5828578.xlsx’, 195380, ‘application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’, ‘42f1ebb9106c8e3f7a4042ca18a50fd7’, 0, 20, ‘2015-07-02 16:41:24’, ”, ‘2015/07’),
(10, 361, ‘Issue’, ‘style1.JPG’, ‘150702165823_style1.JPG’, 11511, ‘image/jpeg’, ‘c311369723cdce76efaa43c48e95c2db’, 0, 8, ‘2015-07-02 16:58:23’, ”, ‘2015/07’),
(12, 362, ‘Issue’, ‘Capture.PNG’, ‘150702173414_Capture.PNG’, 18447, ‘image/png’, ‘3fe0342baf5960b52365bc9e622734c5’, 0, 12, ‘2015-07-02 17:34:14’, ”, ‘2015/07’),
(13, 363, ‘Issue’, ‘SQL.PNG’, ‘150702174045_SQL.PNG’, 41245, ‘image/png’, ‘cbfa3b9e87cc3e996eb64c802fe16773’, 0, 12, ‘2015-07-02 17:40:45’, ”, ‘2015/07’),
(14, 363, ‘Issue’, ‘建表语句.PNG’, ‘150702174058_1a0acafcb7cb9c972913f2e736b9f849.PNG’, 56739, ‘image/png’, ‘17c462c52fd68b8316ffcd1bf24c0c23’, 0, 12, ‘2015-07-02 17:40:58’, ”, ‘2015/07’),
(15, 365, ‘Issue’, ‘MP_01_INVENT_NOTIFY_EDIT.PNG’, ‘150703110020_MP_01_INVENT_NOTIFY_EDIT.PNG’, 21942, ‘image/png’, ‘e0dc3eddc5f4f4a31d93f8bbf2ed1b64’, 0, 12, ‘2015-07-03 11:00:20’, ”, ‘2015/07’),
(16, 365, ‘Issue’, ‘PM_17_FR_REG_LIST.PNG’, ‘150703110020_PM_17_FR_REG_LIST.PNG’, 17936, ‘image/png’, ‘a5c32a7341316cda3a2ebc8bb19e8ca1’, 0, 12, ‘2015-07-03 11:00:20’, ”, ‘2015/07’),
(17, 366, ‘Issue’, ‘PM_17_FR_REG_LIST.PNG’, ‘150703111035_PM_17_FR_REG_LIST.PNG’, 17973, ‘image/png’, ‘ba63abd5aea36eb3c9ca271eef827387’, 0, 12, ‘2015-07-03 11:10:35’, ”, ‘2015/07’),
(18, 368, ‘Issue’, ‘1.JPG’, ‘150703130704_1.JPG’, 18665, ‘image/jpeg’, ‘9d689503a82e2c7d7b1ae75e6db21a73’, 0, 10, ‘2015-07-03 13:07:04’, ”, ‘2015/07’),
(19, 369, ‘Issue’, ‘2.JPG’, ‘150703131040_2.JPG’, 36220, ‘image/jpeg’, ‘69b6a64dc323d2963827c820ac8cb618’, 0, 10, ‘2015-07-03 13:10:40’, ”, ‘2015/07’),
(20, 370, ‘Issue’, ‘3.JPG’, ‘150703131248_3.JPG’, 52917, ‘image/jpeg’, ‘cb98b83d38b4f0e0195075aed2bb11e3’, 0, 10, ‘2015-07-03 13:12:48’, ”, ‘2015/07’),
(21, 371, ‘Issue’, ‘4.JPG’, ‘150703131405_4.JPG’, 38254, ‘image/jpeg’, ‘b5af6ed235911b7bc04049d83d12f738’, 0, 10, ‘2015-07-03 13:14:05’, ”, ‘2015/07’);
–
– Table structure for table auth_sources
CREATE TABLE IF NOT EXISTS auth_sources
(
id
int(11) NOT NULL,
type
varchar(30) NOT NULL DEFAULT ”,
name
varchar(60) NOT NULL DEFAULT ”,
host
varchar(60) DEFAULT NULL,
port
int(11) DEFAULT NULL,
account
varchar(255) DEFAULT NULL,
account_password
varchar(255) DEFAULT ”,
base_dn
varchar(255) DEFAULT NULL,
attr_login
varchar(30) DEFAULT NULL,
attr_firstname
varchar(30) DEFAULT NULL,
attr_lastname
varchar(30) DEFAULT NULL,
attr_mail
varchar(30) DEFAULT NULL,
onthefly_register
tinyint(1) NOT NULL DEFAULT ‘0’,
tls
tinyint(1) NOT NULL DEFAULT ‘0’,
filter
varchar(255) DEFAULT NULL,
timeout
int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert auth_sources
TRUNCATE TABLE auth_sources
;
–
– Table structure for table boards
CREATE TABLE IF NOT EXISTS boards
(
id
int(11) NOT NULL,
project_id
int(11) NOT NULL,
name
varchar(255) NOT NULL DEFAULT ”,
description
varchar(255) DEFAULT NULL,
position
int(11) DEFAULT ‘1’,
topics_count
int(11) NOT NULL DEFAULT ‘0’,
messages_count
int(11) NOT NULL DEFAULT ‘0’,
last_message_id
int(11) DEFAULT NULL,
parent_id
int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
–
– Truncate table before insert boards
TRUNCATE TABLE boards
;
– Dumping data for table boards
INSERT INTO boards
(id
, project_id
, name
, description
, position
, topics_count
, messages_count
, last_message_id
, parent_id
) VALUES
(2, 1, ‘项目交流’, ‘For all members.’, 1, 0, 0, NULL, NULL),
(3, 1, ‘会议记录’, ‘会议记录’, 1, 6, 7, 13, 2),
(4, 1, ‘开发相关’, ‘开发注意事项’, 2, 2, 2, 15, 2);
–
– Table structure for table changes
CREATE TABLE IF NOT EXISTS changes
(
id
int(11) NOT NULL,
changeset_id
int(11) NOT NULL,
action
varchar(1) NOT NULL DEFAULT ”,
path
text NOT NULL,
from_path
text,
from_revision
varchar(255) DEFAULT NULL,
revision
varchar(255) DEFAULT NULL,
branch
varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert changes
TRUNCATE TABLE changes
;
–
– Table structure for table changesets
CREATE TABLE IF NOT EXISTS changesets
(
id
int(11) NOT NULL,
repository_id
int(11) NOT NULL,
revision
varchar(255) NOT NULL,
committer
varchar(255) DEFAULT NULL,
committed_on
datetime NOT NULL,
comments
longtext,
commit_date
date DEFAULT NULL,
scmid
varchar(255) DEFAULT NULL,
user_id
int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert changesets
TRUNCATE TABLE changesets
;
–
– Table structure for table changesets_issues
CREATE TABLE IF NOT EXISTS changesets_issues
(
changeset_id
int(11) NOT NULL,
issue_id
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert changesets_issues
TRUNCATE TABLE changesets_issues
;
–
– Table structure for table changeset_parents
CREATE TABLE IF NOT EXISTS changeset_parents
(
changeset_id
int(11) NOT NULL,
parent_id
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert changeset_parents
TRUNCATE TABLE changeset_parents
;
–
– Table structure for table comments
CREATE TABLE IF NOT EXISTS comments
(
id
int(11) NOT NULL,
commented_type
varchar(30) NOT NULL DEFAULT ”,
commented_id
int(11) NOT NULL DEFAULT ‘0’,
author_id
int(11) NOT NULL DEFAULT ‘0’,
comments
text,
created_on
datetime NOT NULL,
updated_on
datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
–
– Truncate table before insert comments
TRUNCATE TABLE comments
;
– Dumping data for table comments
INSERT INTO comments
(id
, commented_type
, commented_id
, author_id
, comments
, created_on
, updated_on
) VALUES
(1, ‘News’, 2, 7, ‘9. Grid中有日期输入类型的,需要限制只能输入8位数字,且保存前需要校验日期正确性\r\n\r\n–添加onmouseleave事件\r\nfunction tabMain_tpg2_edEPR_YMD_onmouseleave(obj:Edit, e:MouseEventInfo)\r\n{\r\n //check yyyymmdd\r\n var reg = new RegExp(“^(?:(?!0000)[0-9]{4}(?:(?:0[1-9]|1[0-2])(?:0[1-9]|1[0-9]|2[0-8])|(?:0[13-9]|1[0-2])(?:29|30)|(?:0[13578]|1[02])-31)|(?:[0-9]{2}(?:0[48]|[2468][048]|[13579][26])|(?:0[48]|[2468][048]|[13579][26])00)0229)$”);\r\n if(!reg.test(tabMain.tpg2.edEPR_YMD.text))\r\n {\r\n tabMain.tpg2.edEPR_YMD.setFocus();\r\n alert(“Invalid 제품출시예정일자”);\r\n }\r\n}’, ‘2015-06-26 14:04:30’, ‘2015-06-26 14:04:30’),
(2, ‘News’, 2, 7, ‘9. Grid中有日期输入类型的,需要限制只能输入8位数字,且保存前需要校验日期正确性\r\n1-控件选择edit\r\n2-属性值设置inputtype=”number” maxlength=”8” inputfilter=”sign”’, ‘2015-06-26 14:13:12’, ‘2015-06-26 14:13:12’);
–
– Table structure for table custom_fields
CREATE TABLE IF NOT EXISTS custom_fields
(
id
int(11) NOT NULL,
type
varchar(30) NOT NULL DEFAULT ”,
name
varchar(30) NOT NULL DEFAULT ”,
field_format
varchar(30) NOT NULL DEFAULT ”,
possible_values
text,
regexp
varchar(255) DEFAULT ”,
min_length
int(11) DEFAULT NULL,
max_length
int(11) DEFAULT NULL,
is_required
tinyint(1) NOT NULL DEFAULT ‘0’,
is_for_all
tinyint(1) NOT NULL DEFAULT ‘0’,
is_filter
tinyint(1) NOT NULL DEFAULT ‘0’,
position
int(11) DEFAULT ‘1’,
searchable
tinyint(1) DEFAULT ‘0’,
default_value
text,
editable
tinyint(1) DEFAULT ‘1’,
visible
tinyint(1) NOT NULL DEFAULT ‘1’,
multiple
tinyint(1) DEFAULT ‘0’,
format_store
text,
description
text
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
–
– Truncate table before insert custom_fields
TRUNCATE TABLE custom_fields
;
– Dumping data for table custom_fields
INSERT INTO custom_fields
(id
, type
, name
, field_format
, possible_values
, regexp
, min_length
, max_length
, is_required
, is_for_all
, is_filter
, position
, searchable
, default_value
, editable
, visible
, multiple
, format_store
, description
) VALUES
(1, ‘IssueCustomField’, ‘Defect Type’, ‘list’, ‘—\n- UI\n- Functional\n- SQL\n- Dev Rules\n- Other\n’, ”, NULL, NULL, 1, 1, 1, 1, 1, ”, 1, 1, 0, ‘— !ruby/hash:ActiveSupport::HashWithIndifferentAccess\nurl_pattern: ””\nedit_tag_style: ””\n’, ”);
–
– Table structure for table custom_fields_projects
CREATE TABLE IF NOT EXISTS custom_fields_projects
(
custom_field_id
int(11) NOT NULL DEFAULT ‘0’,
project_id
int(11) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert custom_fields_projects
TRUNCATE TABLE custom_fields_projects
;
–
– Table structure for table custom_fields_roles
CREATE TABLE IF NOT EXISTS custom_fields_roles
(
custom_field_id
int(11) NOT NULL,
role_id
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert custom_fields_roles
TRUNCATE TABLE custom_fields_roles
;
–
– Table structure for table custom_fields_trackers
CREATE TABLE IF NOT EXISTS custom_fields_trackers
(
custom_field_id
int(11) NOT NULL DEFAULT ‘0’,
tracker_id
int(11) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert custom_fields_trackers
TRUNCATE TABLE custom_fields_trackers
;
– Dumping data for table custom_fields_trackers
INSERT INTO custom_fields_trackers
(custom_field_id
, tracker_id
) VALUES
(1, 1);
–
– Table structure for table custom_values
CREATE TABLE IF NOT EXISTS custom_values
(
id
int(11) NOT NULL,
customized_type
varchar(30) NOT NULL DEFAULT ”,
customized_id
int(11) NOT NULL DEFAULT ‘0’,
custom_field_id
int(11) NOT NULL DEFAULT ‘0’,
value
text
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
–
– Truncate table before insert custom_values
TRUNCATE TABLE custom_values
;
– Dumping data for table custom_values
INSERT INTO custom_values
(id
, customized_type
, customized_id
, custom_field_id
, value
) VALUES
(1, ‘Issue’, 68, 1, ‘UI’),
(2, ‘Issue’, 355, 1, ‘UI’),
(3, ‘Issue’, 132, 1, ‘UI’),
(4, ‘Issue’, 67, 1, ‘UI’),
(5, ‘Issue’, 62, 1, ‘Other’),
(6, ‘Issue’, 354, 1, ‘UI’),
(7, ‘Issue’, 133, 1, ‘UI’),
(8, ‘Issue’, 359, 1, ‘UI’),
(9, ‘Issue’, 358, 1, ‘UI’),
(10, ‘Issue’, 357, 1, ‘UI’),
(12, ‘Issue’, 346, 1, ‘Functional’),
(13, ‘Issue’, 343, 1, ‘Functional’),
(14, ‘Issue’, 345, 1, ‘UI’),
(15, ‘Issue’, 362, 1, ‘Functional’),
(16, ‘Issue’, 363, 1, ‘SQL’),
(17, ‘Issue’, 356, 1, ‘Functional’),
(18, ‘Issue’, 344, 1, ‘Functional’),
(19, ‘Issue’, 364, 1, ‘UI’),
(20, ‘Issue’, 365, 1, ‘UI’),
(21, ‘Issue’, 366, 1, ‘UI’),
(22, ‘Issue’, 319, 1, ‘SQL’),
(23, ‘Issue’, 351, 1, ‘UI’),
(24, ‘Issue’, 352, 1, ‘UI’),
(25, ‘Issue’, 349, 1, ‘Functional’),
(26, ‘Issue’, 372, 1, ‘Dev Rules’),
(27, ‘Issue’, 353, 1, ‘Dev Rules’),
(28, ‘Issue’, 350, 1, ‘Dev Rules’),
(29, ‘Issue’, 373, 1, ‘UI’),
(30, ‘Issue’, 126, 1, ‘Functional’),
(31, ‘Issue’, 20, 1, ‘UI’),
(32, ‘Issue’, 24, 1, ‘Functional’),
(33, ‘Issue’, 25, 1, ‘UI’),
(34, ‘Issue’, 26, 1, ‘Functional’),
(35, ‘Issue’, 27, 1, ‘UI’),
(36, ‘Issue’, 28, 1, ‘Other’),
(37, ‘Issue’, 30, 1, ‘Other’),
(38, ‘Issue’, 180, 1, ‘UI’),
(39, ‘Issue’, 181, 1, ‘UI’),
(40, ‘Issue’, 182, 1, ‘Functional’),
(41, ‘Issue’, 183, 1, ‘UI’),
(42, ‘Issue’, 184, 1, ‘Functional’),
(43, ‘Issue’, 46, 1, ‘Functional’),
(44, ‘Issue’, 172, 1, ‘Functional’),
(45, ‘Issue’, 70, 1, ‘Functional’),
(46, ‘Issue’, 125, 1, ‘Functional’),
(47, ‘Issue’, 34, 1, ‘Functional’);
–
– Table structure for table documents
CREATE TABLE IF NOT EXISTS documents
(
id
int(11) NOT NULL,
project_id
int(11) NOT NULL DEFAULT ‘0’,
category_id
int(11) NOT NULL DEFAULT ‘0’,
title
varchar(60) NOT NULL DEFAULT ”,
description
text,
created_on
datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert documents
TRUNCATE TABLE documents
;
–
– Table structure for table email_addresses
CREATE TABLE IF NOT EXISTS email_addresses
(
id
int(11) NOT NULL,
user_id
int(11) NOT NULL,
address
varchar(255) NOT NULL,
is_default
tinyint(1) NOT NULL DEFAULT ‘0’,
notify
tinyint(1) NOT NULL DEFAULT ‘1’,
created_on
datetime NOT NULL,
updated_on
datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
–
– Truncate table before insert email_addresses
TRUNCATE TABLE email_addresses
;
– Dumping data for table email_addresses
INSERT INTO email_addresses
(id
, user_id
, address
, is_default
, notify
, created_on
, updated_on
) VALUES
(1, 1, ‘user@example.com’, 1, 1, ‘2015-06-25 11:16:47’, ‘2015-06-25 11:16:47’),
(2, 3, ‘zy1.wang@samsung.com’, 1, 1, ‘2015-06-25 11:29:24’, ‘2015-06-25 11:29:24’),
(4, 5, ‘liang3.wang@samsung.com’, 1, 1, ‘2015-06-25 12:11:45’, ‘2015-06-25 12:11:45’),
(5, 6, ‘yi.zhang@samsung.com’, 1, 1, ‘2015-06-25 12:47:04’, ‘2015-06-25 12:47:04’),
(6, 7, ‘shihai.gong@samsung.com’, 1, 1, ‘2015-06-25 13:00:20’, ‘2015-06-25 13:00:20’),
(7, 8, ‘safw@sfa.com’, 1, 1, ‘2015-06-25 13:14:50’, ‘2015-06-25 13:14:50’),
(8, 9, ‘hl.shi@samsung.com’, 1, 1, ‘2015-06-25 13:20:03’, ‘2015-06-25 13:20:03’),
(9, 10, ‘chonghu.gao@samsung.com’, 1, 1, ‘2015-06-25 13:23:30’, ‘2015-06-25 13:23:30’),
(10, 11, ‘lu1.yao@samsung.com’, 1, 1, ‘2015-06-25 13:24:07’, ‘2015-06-25 13:24:07’),
(11, 12, ‘weipng.yang@samsung.com’, 1, 1, ‘2015-06-25 13:25:08’, ‘2015-06-25 13:25:08’),
(12, 13, ‘hm1.ju@samsung.net’, 1, 1, ‘2015-06-25 13:43:56’, ‘2015-06-25 13:43:56’),
(13, 14, ‘jiajing.xu@samsung.com’, 1, 1, ‘2015-06-25 13:48:05’, ‘2015-06-25 13:48:05’),
(14, 15, ‘wenbo1.shi@samsung.com’, 1, 1, ‘2015-06-25 13:50:26’, ‘2015-06-25 13:50:26’),
(15, 16, ‘miao3.li@samsung.com’, 1, 1, ‘2015-06-25 14:36:07’, ‘2015-06-25 14:36:07’),
(16, 17, ‘guanbo.zhang@partner.samsung.com’, 1, 1, ‘2015-06-26 10:14:25’, ‘2015-06-26 10:14:25’),
(17, 18, ‘js.jiao@samsung.com’, 1, 1, ‘2015-06-26 15:10:21’, ‘2015-06-26 15:10:21’),
(18, 19, ‘ming.cao@samsung.com’, 1, 1, ‘2015-06-29 14:51:49’, ‘2015-06-29 14:51:49’),
(19, 20, ‘zhibin.mao@samsung.com’, 1, 1, ‘2015-06-29 14:55:33’, ‘2015-06-29 14:55:33’),
(20, 21, ‘efwf@asfda.com’, 1, 1, ‘2015-06-30 10:18:40’, ‘2015-06-30 10:18:40’),
(21, 22, ‘tset@123.com’, 1, 1, ‘2015-07-02 09:23:50’, ‘2015-07-02 09:23:50’),
(22, 23, ‘jh0614.noh@opentide.com’, 1, 1, ‘2015-07-03 10:16:17’, ‘2015-07-03 10:16:17’),
(23, 24, ‘hyungi.moon@opentide.com’, 1, 1, ‘2015-07-03 10:17:28’, ‘2015-07-03 10:17:28’),
(24, 25, ‘gahyun.choi@samsung.com’, 1, 1, ‘2015-07-03 10:20:30’, ‘2015-07-03 10:20:30’),
(25, 26, ‘ahhyeon.kim@opentide.com’, 1, 1, ‘2015-07-03 10:21:15’, ‘2015-07-03 10:21:15’),
(26, 27, ‘tj.roh@opentide.com’, 1, 1, ‘2015-07-03 10:22:06’, ‘2015-07-03 10:22:06’),
(27, 28, ‘kyungho.shim@samsung.com’, 1, 1, ‘2015-07-03 10:23:08’, ‘2015-07-03 10:23:08’);
–
– Table structure for table enabled_modules
CREATE TABLE IF NOT EXISTS enabled_modules
(
id
int(11) NOT NULL,
project_id
int(11) DEFAULT NULL,
name
varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
–
– Truncate table before insert enabled_modules
TRUNCATE TABLE enabled_modules
;
– Dumping data for table enabled_modules
INSERT INTO enabled_modules
(id
, project_id
, name
) VALUES
(1, 1, ‘issue_tracking’),
(2, 1, ‘time_tracking’),
(3, 1, ‘news’),
(4, 1, ‘documents’),
(5, 1, ‘files’),
(6, 1, ‘wiki’),
(7, 1, ‘repository’),
(8, 1, ‘boards’),
(9, 1, ‘calendar’),
(10, 1, ‘gantt’);
–
– Table structure for table enumerations
CREATE TABLE IF NOT EXISTS enumerations
(
id
int(11) NOT NULL,
name
varchar(30) NOT NULL DEFAULT ”,
position
int(11) DEFAULT ‘1’,
is_default
tinyint(1) NOT NULL DEFAULT ‘0’,
type
varchar(255) DEFAULT NULL,
active
tinyint(1) NOT NULL DEFAULT ‘1’,
project_id
int(11) DEFAULT NULL,
parent_id
int(11) DEFAULT NULL,
position_name
varchar(30) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
–
– Truncate table before insert enumerations
TRUNCATE TABLE enumerations
;
– Dumping data for table enumerations
INSERT INTO enumerations
(id
, name
, position
, is_default
, type
, active
, project_id
, parent_id
, position_name
) VALUES
(1, ‘Low’, 1, 0, ‘IssuePriority’, 1, NULL, NULL, ‘lowest’),
(2, ‘Normal’, 2, 1, ‘IssuePriority’, 1, NULL, NULL, ‘default’),
(3, ‘High’, 3, 0, ‘IssuePriority’, 1, NULL, NULL, ‘high3’),
(4, ‘Urgent’, 4, 0, ‘IssuePriority’, 1, NULL, NULL, ‘high2’),
(5, ‘Immediate’, 5, 0, ‘IssuePriority’, 1, NULL, NULL, ‘highest’),
(6, ‘User documentation’, 1, 0, ‘DocumentCategory’, 1, NULL, NULL, NULL),
(7, ‘Technical documentation’, 2, 0, ‘DocumentCategory’, 1, NULL, NULL, NULL),
(8, ‘Design’, 1, 0, ‘TimeEntryActivity’, 1, NULL, NULL, NULL),
(9, ‘Development’, 2, 0, ‘TimeEntryActivity’, 1, NULL, NULL, NULL);
–
– Table structure for table groups_users
CREATE TABLE IF NOT EXISTS groups_users
(
group_id
int(11) NOT NULL,
user_id
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert groups_users
TRUNCATE TABLE groups_users
;
– Dumping data for table groups_users
INSERT INTO groups_users
(group_id
, user_id
) VALUES
(29, 23),
(29, 24),
(29, 25),
(29, 26),
(29, 27),
(29, 28);
–
– Table structure for table issues
CREATE TABLE IF NOT EXISTS issues
(
id
int(11) NOT NULL,
tracker_id
int(11) NOT NULL,
project_id
int(11) NOT NULL,
subject
varchar(255) NOT NULL DEFAULT ”,
description
text,
due_date
date DEFAULT NULL,
category_id
int(11) DEFAULT NULL,
status_id
int(11) NOT NULL,
assigned_to_id
int(11) DEFAULT NULL,
priority_id
int(11) NOT NULL,
fixed_version_id
int(11) DEFAULT NULL,
author_id
int(11) NOT NULL,
lock_version
int(11) NOT NULL DEFAULT ‘0’,
created_on
datetime DEFAULT NULL,
updated_on
datetime DEFAULT NULL,
start_date
date DEFAULT NULL,
done_ratio
int(11) NOT NULL DEFAULT ‘0’,
estimated_hours
float DEFAULT NULL,
parent_id
int(11) DEFAULT NULL,
root_id
int(11) DEFAULT NULL,
lft
int(11) DEFAULT NULL,
rgt
int(11) DEFAULT NULL,
is_private
tinyint(1) NOT NULL DEFAULT ‘0’,
closed_on
datetime DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=374 DEFAULT CHARSET=utf8;
–
– Truncate table before insert issues
TRUNCATE TABLE issues
;
– Dumping data for table issues
INSERT INTO issues
(id
, tracker_id
, project_id
, subject
, description
, due_date
, category_id
, status_id
, assigned_to_id
, priority_id
, fixed_version_id
, author_id
, lock_version
, created_on
, updated_on
, start_date
, done_ratio
, estimated_hours
, parent_id
, root_id
, lft
, rgt
, is_private
, closed_on
) VALUES
(1, 4, 1, ‘PM Screen Review[20150625]’, ‘started by yd1.zhang’, ‘2015-06-26’, NULL, 3, 3, 3, NULL, 3, 466, ‘2015-06-25 13:10:25’, ‘2015-07-03 15:41:14’, ‘2015-06-25’, 97, 0.7, NULL, 1, 1, 258, 0, NULL),
(2, 4, 1, ‘OS Screen Review[20150625]’, ‘started by zy1.wang’, NULL, NULL, 1, 3, 2, NULL, 3, 22, ‘2015-06-25 13:10:56’, ‘2015-07-03 14:56:57’, ‘2015-06-25’, 95, NULL, NULL, 2, 1, 40, 0, NULL),
(4, 1, 1, ‘PM_08 存在硬编码’, ‘function fnSearchMain(obj:Button, e:ClickEventInfo)\r\n{\r\n var param = “INVT_NO=20130705002”//+parent.INVENT_NO \r\n +” NA_CD=”+parent.NA_CD\r\n +” NA_DEG=”+parent.NA_DEG\r\n +” PGSTEP_CD=”+parent.PGSTEP_CD;\r\n actionSubmit(“selectDsMain”,param); \r\n actionSubmit(“selectDsInput”,param); \r\n}\r\n’, NULL, NULL, 4, 3, 2, NULL, 3, 4, ‘2015-06-25 13:23:03’, ‘2015-07-01 13:46:11’, ‘2015-06-25’, 0, NULL, 1, 1, 2, 3, 0, NULL),
(5, 1, 1, ‘PM_02 script部分第36行“ tabMain.tabpage1.gridMain, “中名”tabpage1“和“gridMain”未安装规范命名。其他地方也有类似的问题。’, ‘script部分第36行“ tabMain.tabpage1.gridMain, “中名”tabpage1“和“gridMain”未安装规范命名。其他地方也有类似的问题。’, NULL, NULL, 6, 5, 2, NULL, 8, 4, ‘2015-06-25 13:25:42’, ‘2015-06-30 13:27:07’, ‘2015-06-25’, 0, NULL, 1, 1, 4, 5, 0, ‘2015-06-30 13:27:07’),
(6, 1, 1, ‘PM_02 script部分第57行、58行“ 代码未缩进;55行代码未换行。’, ‘script部分第57行、58行“ 代码未缩进;55行代码未换行。’, NULL, NULL, 5, 5, 2, NULL, 8, 5, ‘2015-06-25 13:26:24’, ‘2015-07-02 16:37:49’, ‘2015-06-25’, 100, NULL, 1, 1, 6, 7, 0, ‘2015-06-30 13:23:31’),
(7, 1, 1, ‘PM_02 script部分fnInitLAWFM_NM函数中“actionSubmit(“selectDsLawfm”);’, ‘script部分fnInitLAWFM_NM函数中“actionSubmit(“selectDsLawfm”);\r\n ”提交后不能再有其他代码。’, NULL, NULL, 5, 5, 2, NULL, 8, 7, ‘2015-06-25 13:26:54’, ‘2015-07-02 16:37:50’, ‘2015-06-25’, 100, NULL, 1, 1, 8, 9, 0, ‘2015-06-30 13:23:06’),
(8, 1, 1, ‘PM_02 script部分gridMain_oncellclick事件不能调用其他事件。’, ‘script部分gridMain_oncellclick事件不能调用其他事件。’, NULL, NULL, 5, 5, 2, NULL, 8, 6, ‘2015-06-25 13:27:18’, ‘2015-07-02 16:37:50’, ‘2015-06-25’, 100, NULL, 1, 1, 10, 11, 0, ‘2015-06-30 13:22:25’),
(9, 1, 1, ‘PM_02 画面上“”的颜色应该为红色’, ‘画面上“”的颜色应该为红色’, NULL, NULL, 5, 5, 2, NULL, 8, 5, ‘2015-06-25 13:27:34’, ‘2015-07-02 16:37:50’, ‘2015-06-25’, 100, NULL, 1, 1, 12, 13, 0, ‘2015-06-30 13:21:51’),
(10, 1, 1, ‘PM_02 画面上“발명상담서”部分和上面表格中间是否需要空很大空间?’, ‘画面上“발명상담서”部分和上面表格中间是否需要空很大空间?’, NULL, NULL, 5, 5, 2, NULL, 8, 6, ‘2015-06-25 13:27:49’, ‘2015-07-02 16:37:50’, ‘2015-06-25’, 100, NULL, 1, 1, 14, 15, 0, ‘2015-06-30 13:21:32’),
(11, 1, 1, ‘PM_02 画面上“발명상담서”部分没有数据时不能显示“undefined”’, ‘画面上“발명상담서”部分没有数据时不能显示“undefined”’, NULL, NULL, 5, 5, 2, NULL, 8, 5, ‘2015-06-25 13:28:51’, ‘2015-07-02 16:37:50’, ‘2015-06-25’, 100, NULL, 1, 1, 16, 17, 0, ‘2015-06-30 13:28:16’),
(12, 1, 1, ‘PM_02_INVENT_CONSULT_LISTService 第24行未缩进’, ‘PM_02_INVENT_CONSULT_LISTService 第24行未缩进’, NULL, NULL, 5, 5, 2, NULL, 8, 4, ‘2015-06-25 13:30:12’, ‘2015-07-02 16:37:57’, ‘2015-06-25’, 100, NULL, NULL, 12, 1, 2, 0, ‘2015-06-30 13:28:38’),
(13, 1, 1, ‘PM_02_INVENT_CONSULT_LISTQuery 第71行关键字未对齐’, ‘PM_02_INVENT_CONSULT_LISTQuery 第71行关键字未对齐’, NULL, NULL, 5, 5, 2, NULL, 8, 4, ‘2015-06-25 13:32:49’, ‘2015-07-02 16:37:57’, ‘2015-06-25’, 100, NULL, NULL, 13, 1, 2, 0, ‘2015-06-30 13:28:57’),
(14, 1, 1, ‘PM_03 script部分第25行“tabMain.tabpage1.grdMainDown” 中名”tabpage1“未安装规范命名。其他地方也有类似的问题。’, ‘script部分第25行“tabMain.tabpage1.grdMainDown” 中名”tabpage1“未安装规范命名。其他地方也有类似的问题。’, NULL, NULL, 5, 13, 2, NULL, 8, 4, ‘2015-06-25 13:48:39’, ‘2015-07-02 16:37:50’, ‘2015-06-25’, 100, NULL, 1, 1, 18, 19, 0, ‘2015-06-30 13:29:34’),
(15, 1, 1, ‘PM_03 script部分第57~61行变量未按照规范命名。其他地方也有类似的问题。’, ‘script部分第57~61行变量未按照规范命名。其他地方也有类似的问题。’, NULL, NULL, 5, 13, 2, NULL, 8, 4, ‘2015-06-25 13:49:34’, ‘2015-07-02 16:37:51’, ‘2015-06-25’, 100, NULL, 1, 1, 20, 21, 0, ‘2015-06-30 13:30:12’),
(16, 1, 1, ‘PM_03_SR_PROGRESS_LISTService 中第27、28行常量应该有final、static修饰’, ‘PM_03_SR_PROGRESS_LISTService 中第27、28行常量应该有final、static修饰’, NULL, NULL, 5, 13, 2, NULL, 8, 3, ‘2015-06-25 13:56:09’, ‘2015-07-02 16:37:51’, ‘2015-06-25’, 100, NULL, 1, 1, 22, 23, 0, ‘2015-06-30 13:31:12’),
(17, 1, 1, ‘PM_03 SQL关键字未右对齐’, ‘PM_03 SQL关键字未右对齐’, NULL, NULL, 5, 13, 2, NULL, 8, 3, ‘2015-06-25 14:02:56’, ‘2015-07-02 16:37:51’, ‘2015-06-25’, 100, NULL, 1, 1, 24, 25, 0, ‘2015-06-29 15:15:51’),
(18, 1, 1, ‘PM_02 画面中“발명구분*”内容应该居左对齐’, ”, NULL, NULL, 5, 5, 2, NULL, 8, 5, ‘2015-06-25 14:45:09’, ‘2015-07-02 16:37:51’, ‘2015-06-25’, 100, NULL, 1, 1, 26, 27, 0, ‘2015-06-30 13:31:28’),
(19, 4, 1, ‘MP_01 Review[20150625]’, ”, NULL, NULL, 3, 3, 2, NULL, 3, 12, ‘2015-06-25 14:45:30’, ‘2015-07-03 14:52:23’, ‘2015-06-25’, 100, NULL, NULL, 19, 1, 18, 0, NULL),
(20, 1, 1, ‘MP_01 查询条件未校验’, ‘说明书上有 \r\n\r\n发明申报日期: 开始日期 ~ 结束日期用 CalendarBox 实现\r\n - 期限(From, To)为必填值。\r\n\r\n现在不填From也可以查询\r\n’, NULL, NULL, 5, 11, 2, NULL, 3, 7, ‘2015-06-25 14:46:15’, ‘2015-07-03 15:50:55’, ‘2015-06-25’, 100, NULL, 19, 19, 2, 3, 0, ‘2015-07-03 15:50:55’),
(21, 1, 1, ‘MP_01 UI Tab上方的文字错位’, ”, NULL, NULL, 5, 7, 2, NULL, 3, 5, ‘2015-06-25 14:47:15’, ‘2015-07-01 10:38:05’, ‘2015-06-25’, 100, NULL, 19, 19, 4, 5, 0, ‘2015-07-01 10:38:05’),
(22, 1, 1, ‘PM_02 表格最下面表格线显示不正常’, ”, NULL, NULL, 5, 5, 2, NULL, 8, 4, ‘2015-06-25 14:47:40’, ‘2015-07-02 16:37:51’, ‘2015-06-25’, 100, NULL, 1, 1, 28, 29, 0, ‘2015-06-30 13:31:44’),
(23, 1, 1, ‘PM_03 画面中两个表格中数据的对齐方式都有问题’, ‘具体规则:”- Grid中,文字居左对齐,等长内容或状态居中,数字居右’, NULL, NULL, 5, 13, 2, NULL, 8, 3, ‘2015-06-25 14:53:32’, ‘2015-07-02 16:37:51’, ‘2015-06-25’, 100, NULL, 1, 1, 30, 31, 0, ‘2015-06-30 13:32:12’),
(24, 1, 1, ‘MP_01 新增功能无效’, ‘提示 ok,cancel,点任意一个都不可以通过。’, NULL, NULL, 5, 11, 2, NULL, 3, 6, ‘2015-06-25 14:58:16’, ‘2015-07-03 15:44:45’, ‘2015-06-25’, 100, NULL, 19, 19, 6, 7, 0, ‘2015-07-03 15:44:45’),
(25, 1, 1, ‘MP_01 UI问题’, ‘见附件’, NULL, NULL, 5, 11, 2, NULL, 3, 7, ‘2015-06-25 15:05:15’, ‘2015-07-03 15:48:57’, ‘2015-06-25’, 100, NULL, 19, 19, 8, 9, 0, ‘2015-07-03 15:48:57’),
(26, 1, 1, ‘MP_01 阶段二 保存失败,提示INV_NO不能插入空值,请确认’, ”, NULL, NULL, 5, 11, 2, NULL, 3, 7, ‘2015-06-25 15:05:40’, ‘2015-07-03 15:47:02’, ‘2015-06-25’, 100, NULL, 19, 19, 10, 11, 0, ‘2015-07-03 15:47:02’),
(27, 1, 1, ‘MP_01 Tab2保存时,产品预计上市日期 未作校验,随便输入8位数字都可以’, ”, NULL, NULL, 5, 11, 2, NULL, 3, 7, ‘2015-06-25 15:08:33’, ‘2015-07-03 15:51:23’, ‘2015-06-25’, 100, NULL, 19, 19, 12, 13, 0, ‘2015-07-03 15:51:23’),
(28, 1, 1, ‘MP_01 Tab跳转逻辑问题’, ‘当产品适用与否 = N时,\r\nTab内容本来就不可编辑,\r\n当双击其它行 或者 Tab跳转时,\r\n 没必要再弹一个Confirm出来确认是否要跳转。’, NULL, NULL, 5, 11, 2, NULL, 3, 7, ‘2015-06-25 15:16:09’, ‘2015-07-03 15:53:06’, ‘2015-06-25’, 100, NULL, 19, 19, 14, 15, 0, ‘2015-07-03 15:53:06’),
(29, 1, 1, ‘PM_05 “발명자의견요청”下发的输入框中不能输入多行数据,不能回车换行’, ”, NULL, NULL, 5, 9, 2, NULL, 8, 4, ‘2015-06-25 15:16:25’, ‘2015-07-02 16:37:52’, ‘2015-06-25’, 100, NULL, 1, 1, 32, 33, 0, ‘2015-06-30 13:32:32’),
(30, 1, 1, ‘MP_01 行记录跳转失败’, ‘当产品适用与否 = Y, 双击其它行,提示Confirm 点击OK,弹出 无须保存,但Tab内的数据没有变化。\r\n\r\n提示Confrim点击Cancel,主Grid的被选中行变了,但Tab没变,数据发生不一致的情况 。’, NULL, NULL, 5, 11, 2, NULL, 3, 9, ‘2015-06-25 15:18:00’, ‘2015-07-03 15:52:23’, ‘2015-06-25’, 100, NULL, 19, 19, 16, 17, 0, ‘2015-07-03 15:52:23’),
(31, 1, 1, ‘PM_05 画面下方表格中数据对齐不符合规则’, ‘具体规则:Grid中,文字居左对齐,等长内容或状态居中,数字居右’, NULL, NULL, 5, 9, 2, NULL, 8, 3, ‘2015-06-25 15:19:26’, ‘2015-07-02 16:37:52’, ‘2015-06-25’, 100, NULL, 1, 1, 34, 35, 0, ‘2015-06-30 13:32:55’),
(32, 1, 1, ‘PM_05 画面上邮件附件不能有“硬编码”’, ”, NULL, NULL, 5, 9, 2, NULL, 8, 4, ‘2015-06-25 15:21:14’, ‘2015-07-02 16:37:52’, ‘2015-06-25’, 100, NULL, 1, 1, 36, 37, 0, ‘2015-06-30 13:33:11’),
(33, 1, 1, ‘PM_05 script部分第55,61行“<=”用法有误,建议用“=”’, ”, NULL, NULL, 5, 9, 2, NULL, 8, 4, ‘2015-06-25 15:24:33’, ‘2015-07-02 16:37:52’, ‘2015-06-25’, 100, NULL, 1, 1, 38, 39, 0, ‘2015-06-30 13:33:38’),
(34, 1, 1, ‘OS_01 未完成列表’, ‘1.下拉框的值出不来。\r\n2.保存前校验逻辑无法验证\r\n3.填写值,但保存之前进行其它Record双击,需要Confrim是否保存,不能直接跳转。\r\n4.Mail_Clob 查不出值时显示NoData,\r\n5。Mail内容与其它UI统一,置灰太难看了’, NULL, NULL, 3, 3, 2, NULL, 3, 5, ‘2015-06-25 15:46:08’, ‘2015-07-03 15:42:48’, ‘2015-06-25’, 100, NULL, 2, 2, 2, 3, 0, NULL),
(35, 1, 1, ‘PM_05 部分SQL语句关键字为右对齐’, ”, NULL, NULL, 5, 9, 2, NULL, 8, 3, ‘2015-06-25 15:47:46’, ‘2015-07-02 16:37:52’, ‘2015-06-25’, 100, NULL, 1, 1, 40, 41, 0, ‘2015-06-30 13:33:53’),
(36, 1, 1, ‘PM_05 Service文件注释作者有误’, ‘/*\r\n
- \r\n *
- Created by : chonghu.gao\r\n *
- Created Date : 2015. 06. 11\r\n *
(37, 1, 1, ‘PM_05_KR_DRAFT_PROGRESS_LISTService 第34行未使用泛型’, ‘saveMain(List
– Table structure for table issue_categories
CREATE TABLE IF NOT EXISTS issue_categories
(
id
int(11) NOT NULL,
project_id
int(11) NOT NULL DEFAULT ‘0’,
name
varchar(30) NOT NULL DEFAULT ”,
assigned_to_id
int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert issue_categories
TRUNCATE TABLE issue_categories
;
–
– Table structure for table issue_relations
CREATE TABLE IF NOT EXISTS issue_relations
(
id
int(11) NOT NULL,
issue_from_id
int(11) NOT NULL,
issue_to_id
int(11) NOT NULL,
relation_type
varchar(255) NOT NULL DEFAULT ”,
delay
int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
–
– Truncate table before insert issue_relations
TRUNCATE TABLE issue_relations
;
– Dumping data for table issue_relations
INSERT INTO issue_relations
(id
, issue_from_id
, issue_to_id
, relation_type
, delay
) VALUES
(1, 28, 180, ‘copied_to’, NULL);
–
– Table structure for table issue_statuses
CREATE TABLE IF NOT EXISTS issue_statuses
(
id
int(11) NOT NULL,
name
varchar(30) NOT NULL DEFAULT ”,
is_closed
tinyint(1) NOT NULL DEFAULT ‘0’,
position
int(11) DEFAULT ‘1’,
default_done_ratio
int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
–
– Truncate table before insert issue_statuses
TRUNCATE TABLE issue_statuses
;
– Dumping data for table issue_statuses
INSERT INTO issue_statuses
(id
, name
, is_closed
, position
, default_done_ratio
) VALUES
(1, ‘New’, 0, 1, NULL),
(2, ‘In Progress’, 0, 2, NULL),
(3, ‘Resolved’, 0, 3, NULL),
(4, ‘Feedback’, 0, 4, NULL),
(5, ‘Closed’, 1, 9, NULL),
(6, ‘Rejected’, 1, 5, NULL),
(8, ‘In Development’, 0, 6, NULL),
(9, ‘Development Finished’, 0, 7, NULL),
(10, ‘In Review’, 0, 8, NULL),
(11, ‘Review Finished’, 0, 10, NULL),
(12, ‘Document Updated’, 0, 11, NULL),
(13, ‘Pending&Need Confirm’, 0, 12, NULL),
(14, ‘Done&Need Confirm’, 0, 13, NULL),
(15, ‘Ignore’, 0, 14, NULL),
(16, ‘Fixed’, 0, 15, NULL);
–
– Table structure for table journals
CREATE TABLE IF NOT EXISTS journals
(
id
int(11) NOT NULL,
journalized_id
int(11) NOT NULL DEFAULT ‘0’,
journalized_type
varchar(30) NOT NULL DEFAULT ”,
user_id
int(11) NOT NULL DEFAULT ‘0’,
notes
text,
created_on
datetime NOT NULL,
private_notes
tinyint(1) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB AUTO_INCREMENT=1650 DEFAULT CHARSET=utf8;
–
– Truncate table before insert journals
TRUNCATE TABLE journals
;
– Dumping data for table journals
INSERT INTO journals
(id
, journalized_id
, journalized_type
, user_id
, notes
, created_on
, private_notes
) VALUES
(7, 10, ‘Issue’, 8, ”, ‘2015-06-25 13:28:10’, 0),
(8, 7, ‘Issue’, 8, ”, ‘2015-06-25 13:28:30’, 0),
(9, 15, ‘Issue’, 8, ”, ‘2015-06-25 13:57:04’, 0),
(10, 14, ‘Issue’, 8, ”, ‘2015-06-25 13:57:36’, 0),
(11, 11, ‘Issue’, 8, ”, ‘2015-06-25 13:58:14’, 0),
(12, 10, ‘Issue’, 8, ”, ‘2015-06-25 13:58:39’, 0),
(13, 9, ‘Issue’, 8, ”, ‘2015-06-25 13:59:03’, 0),
(14, 8, ‘Issue’, 8, ”, ‘2015-06-25 13:59:34’, 0),
(15, 7, ‘Issue’, 8, ”, ‘2015-06-25 14:00:02’, 0),
(16, 6, ‘Issue’, 8, ”, ‘2015-06-25 14:00:26’, 0),
(17, 5, ‘Issue’, 8, ”, ‘2015-06-25 14:00:51’, 0),
(18, 20, ‘Issue’, 3, ”, ‘2015-06-25 14:46:33’, 0),
(19, 18, ‘Issue’, 8, ‘规则:”- Grid中,文字居左对齐,等长内容或状态居中,数字居右’, ‘2015-06-25 14:55:46’, 0),
(20, 30, ‘Issue’, 3, ‘这同样也导致 ,新建功能不能使用。’, ‘2015-06-25 15:18:47’, 0),
(21, 25, ‘Issue’, 3, NULL, ‘2015-06-25 15:19:39’, 0),
(22, 26, ‘Issue’, 3, NULL, ‘2015-06-25 15:19:39’, 0),
(23, 27, ‘Issue’, 3, NULL, ‘2015-06-25 15:19:39’, 0),
(24, 28, ‘Issue’, 3, NULL, ‘2015-06-25 15:19:39’, 0),
(25, 30, ‘Issue’, 3, NULL, ‘2015-06-25 15:19:39’, 0),
(26, 33, ‘Issue’, 8, ”, ‘2015-06-25 15:25:16’, 0),
(27, 17, ‘Issue’, 13, ”, ‘2015-06-25 15:59:14’, 0),
(28, 23, ‘Issue’, 13, ”, ‘2015-06-25 16:00:12’, 0),
(29, 16, ‘Issue’, 13, ”, ‘2015-06-25 16:01:21’, 0),
(30, 15, ‘Issue’, 13, ”, ‘2015-06-25 16:06:11’, 0),
(31, 14, ‘Issue’, 13, ”, ‘2015-06-25 16:09:48’, 0),
(32, 36, ‘Issue’, 9, ‘确认是虎哥做的’, ‘2015-06-25 19:06:16’, 0),
(33, 36, ‘Issue’, 9, ”, ‘2015-06-25 19:06:26’, 0),
(34, 38, ‘Issue’, 9, ‘ctrl + shift + f是未缩进的,确认中’, ‘2015-06-25 19:12:03’, 0),
(35, 37, ‘Issue’, 9, ‘改为Map
– Table structure for table journal_details
CREATE TABLE IF NOT EXISTS journal_details
(
id
int(11) NOT NULL,
journal_id
int(11) NOT NULL DEFAULT ‘0’,
property
varchar(30) NOT NULL DEFAULT ”,
prop_key
varchar(30) NOT NULL DEFAULT ”,
old_value
text,
value
text
) ENGINE=InnoDB AUTO_INCREMENT=1875 DEFAULT CHARSET=utf8;
–
– Truncate table before insert journal_details
TRUNCATE TABLE journal_details
;
– Dumping data for table journal_details
INSERT INTO journal_details
(id
, journal_id
, property
, prop_key
, old_value
, value
) VALUES
(8, 7, ‘attr’, ‘assigned_to_id’, NULL, ‘5’),
(9, 8, ‘attr’, ‘assigned_to_id’, NULL, ‘5’),
(10, 9, ‘attr’, ‘subject’, ‘script部分第57~61行变量未按照规范命名。其他地方也有类似的问题。’, ‘PM_03 script部分第57~61行变量未按照规范命名。其他地方也有类似的问题。’),
(11, 9, ‘attr’, ‘parent_id’, NULL, ‘1’),
(12, 10, ‘attr’, ‘subject’, ‘script部分第25行“tabMain.tabpage1.grdMainDown” 中名”tabpage1“未安装规范命名。其他地方也有类似的问题。’, ‘PM_03 script部分第25行“tabMain.tabpage1.grdMainDown” 中名”tabpage1“未安装规范命名。其他地方也有类似的问题。’),
(13, 10, ‘attr’, ‘parent_id’, NULL, ‘1’),
(14, 11, ‘attr’, ‘subject’, ‘画面上“발명상담서”部分没有数据时不能显示“undefined”’, ‘PM_02 画面上“발명상담서”部分没有数据时不能显示“undefined”’),
(15, 11, ‘attr’, ‘parent_id’, NULL, ‘1’),
(16, 12, ‘attr’, ‘subject’, ‘画面上“발명상담서”部分和上面表格中间是否需要空很大空间?’, ‘PM_02 画面上“발명상담서”部分和上面表格中间是否需要空很大空间?’),
(17, 12, ‘attr’, ‘parent_id’, NULL, ‘1’),
(18, 13, ‘attr’, ‘subject’, ‘画面上“”的颜色应该为红色’, ‘PM_02 画面上“”的颜色应该为红色’),
(19, 13, ‘attr’, ‘parent_id’, NULL, ‘1’),
(20, 14, ‘attr’, ‘subject’, ‘script部分gridMain_oncellclick事件不能调用其他事件。’, ‘PM_02 script部分gridMain_oncellclick事件不能调用其他事件。’),
(21, 14, ‘attr’, ‘parent_id’, NULL, ‘1’),
(22, 15, ‘attr’, ‘subject’, ‘script部分fnInitLAWFM_NM函数中“actionSubmit(“selectDsLawfm”);’, ‘PM_02 script部分fnInitLAWFM_NM函数中“actionSubmit(“selectDsLawfm”);’),
(23, 15, ‘attr’, ‘parent_id’, NULL, ‘1’),
(24, 16, ‘attr’, ‘subject’, ‘script部分第57行、58行“ 代码未缩进;55行代码未换行。’, ‘PM_02 script部分第57行、58行“ 代码未缩进;55行代码未换行。’),
(25, 16, ‘attr’, ‘parent_id’, NULL, ‘1’),
(26, 17, ‘attr’, ‘subject’, ‘script部分第36行“ tabMain.tabpage1.gridMain, “中名”tabpage1“和“gridMain”未安装规范命名。其他地方也有类似的问题。’, ‘PM_02 script部分第36行“ tabMain.tabpage1.gridMain, “中名”tabpage1“和“gridMain”未安装规范命名。其他地方也有类似的问题。’),
(27, 17, ‘attr’, ‘parent_id’, NULL, ‘1’),
(28, 18, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(29, 21, ‘attr’, ‘assigned_to_id’, NULL, ‘7’),
(30, 22, ‘attr’, ‘assigned_to_id’, NULL, ‘7’),
(31, 23, ‘attr’, ‘assigned_to_id’, NULL, ‘7’),
(32, 24, ‘attr’, ‘assigned_to_id’, NULL, ‘7’),
(33, 25, ‘attr’, ‘assigned_to_id’, NULL, ‘7’),
(34, 26, ‘attr’, ‘subject’, ‘PM_05 script部分第55,61行“<=”’, ‘PM_05 script部分第55,61行“<=”用法有误,建议用“=”’),
(35, 26, ‘attr’, ‘assigned_to_id’, NULL, ‘9’),
(36, 26, ‘attr’, ‘parent_id’, NULL, ‘1’),
(37, 27, ‘attr’, ‘status_id’, ‘1’, ‘3’),
(38, 28, ‘attr’, ‘status_id’, ‘1’, ‘4’),
(39, 29, ‘attr’, ‘status_id’, ‘1’, ‘3’),
(40, 30, ‘attr’, ‘status_id’, ‘1’, ‘3’),
(41, 31, ‘attr’, ‘status_id’, ‘1’, ‘3’),
(42, 32, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(43, 33, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(44, 34, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(45, 35, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(46, 36, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(47, 37, ‘attr’, ‘status_id’, ‘1’, ‘3’),
(48, 38, ‘attr’, ‘status_id’, ‘1’, ‘3’),
(49, 39, ‘attr’, ‘status_id’, ‘1’, ‘3’),
(50, 40, ‘attr’, ‘subject’, ‘LAWFM_NM 的align属性未设置,和画面UI不一致’, ‘dsSubMain body显示 的align属性未设置,和画面UI不一致’),
(51, 41, ‘attr’, ‘subject’, ‘dsSubMain的row_size和标准不一致’, ‘SPEC_PM_11 dsSubMain的row_size和标准不一致’),
(52, 42, ‘attr’, ‘subject’, ‘dsSubMain body显示 的align属性未设置,和画面UI不一致’, ‘SPEC_PM_11 dsSubMain body显示 的align属性未设置,和画面UI不一致’),
(55, 45, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(56, 46, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(57, 47, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(58, 48, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(59, 49, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(60, 50, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(61, 51, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(62, 52, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(63, 53, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(64, 54, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(65, 55, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(66, 56, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(67, 57, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(68, 58, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(69, 59, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(70, 60, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(71, 61, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(72, 62, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(73, 62, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(74, 63, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(75, 64, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(76, 65, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(77, 66, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(78, 67, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(79, 68, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(80, 68, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(81, 69, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(82, 70, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(83, 71, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(84, 72, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(85, 73, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(86, 73, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(87, 74, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(88, 75, ‘attr’, ‘subject’, ‘“단계완료”按钮坐标位置和设计书不符’, ‘PM_07 画面“단계완료”按钮坐标位置和设计书不符’),
(89, 76, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(90, 76, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(91, 77, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(92, 78, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(93, 79, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(94, 80, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(95, 81, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(96, 82, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(97, 83, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(98, 84, ‘attr’, ‘subject’, ‘MA_04_KR_PROGRESS_MASTER_LISTQuery.xdfl 样式’, ‘MA_04_KR_PROGRESS_MASTER_LISTQuery.xdfl SYSDATE’),
(99, 85, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(100, 86, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(101, 87, ‘attr’, ‘subject’, ‘MA_04_KR_PROGRESS_MASTER_LISTQuery.xdfl SYSDATE’, ‘MA_04_KR_PROGRESS_MASTER_LISTQuery.xdfl SYSDATE以及样式’),
(102, 88, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(103, 89, ‘attr’, ‘assigned_to_id’, ‘8’, ‘5’),
(104, 90, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(105, 91, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(106, 92, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(107, 93, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(108, 94, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(109, 95, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(110, 96, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(111, 97, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(112, 98, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(113, 99, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(114, 100, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(115, 101, ‘attr’, ‘subject’, ‘OS_01 功能完成度低,无法Review’, ‘OS_01 未完成列表’),
(116, 102, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(117, 102, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(118, 103, ‘attr’, ‘assigned_to_id’, NULL, ‘3’),
(119, 104, ‘attr’, ‘assigned_to_id’, NULL, ‘5’),
(120, 105, ‘attr’, ‘assigned_to_id’, NULL, ‘5’),
(121, 106, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(122, 107, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(123, 108, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(124, 109, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(125, 109, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(126, 110, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(127, 111, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(128, 112, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(129, 112, ‘attr’, ‘priority_id’, ‘2’, ‘1’),
(130, 113, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(131, 113, ‘attr’, ‘priority_id’, ‘1’, ‘2’),
(132, 114, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(133, 115, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(134, 115, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(135, 116, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(136, 117, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(137, 118, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(138, 119, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(139, 120, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(140, 121, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(141, 122, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(142, 123, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(143, 124, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(144, 125, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(145, 126, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(146, 127, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(147, 128, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(148, 129, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(149, 130, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(150, 131, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(151, 132, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(152, 133, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(153, 134, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(154, 135, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(155, 136, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(156, 137, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(157, 138, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(158, 139, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(159, 140, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(160, 141, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(161, 142, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(162, 143, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(163, 144, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(164, 145, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(165, 146, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(166, 147, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(167, 148, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(168, 149, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(169, 150, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(170, 151, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(171, 152, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(172, 154, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(173, 155, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(174, 156, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(175, 157, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(176, 158, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(177, 159, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(178, 160, ‘attr’, ‘assigned_to_id’, NULL, ‘9’),
(179, 161, ‘attr’, ‘assigned_to_id’, NULL, ‘9’),
(180, 162, ‘attr’, ‘assigned_to_id’, NULL, ‘9’),
(181, 163, ‘attr’, ‘assigned_to_id’, NULL, ‘6’),
(182, 164, ‘attr’, ‘assigned_to_id’, NULL, ‘6’),
(183, 165, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(184, 166, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(185, 167, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(186, 168, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(187, 169, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(188, 170, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(189, 171, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(190, 172, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(191, 173, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(192, 174, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(193, 175, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(194, 176, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(195, 177, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(196, 178, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(197, 179, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(198, 180, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(199, 181, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(200, 182, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(201, 183, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(202, 184, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(203, 185, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(204, 186, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(205, 187, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(206, 188, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(207, 189, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(208, 190, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(209, 191, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(210, 192, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(211, 193, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(212, 194, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(213, 195, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(214, 196, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(215, 197, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(216, 198, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(217, 199, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(218, 200, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(219, 201, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(220, 202, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(221, 203, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(222, 204, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(223, 205, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(224, 206, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(225, 207, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(226, 208, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(227, 209, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(228, 210, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(229, 211, ‘attr’, ‘assigned_to_id’, NULL, ‘3’),
(230, 212, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(231, 213, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(232, 214, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(233, 215, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(234, 215, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(235, 216, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(236, 217, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(237, 218, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(238, 219, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(239, 220, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(240, 222, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(241, 223, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(242, 224, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(243, 226, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(244, 227, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(245, 228, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(246, 229, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(247, 230, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(248, 231, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(249, 232, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(250, 233, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(251, 234, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(252, 235, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(253, 236, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(254, 237, ‘attr’, ‘due_date’, NULL, ‘2015-06-26’),
(255, 237, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(256, 237, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(257, 237, ‘attr’, ‘estimated_hours’, NULL, ‘0.1’),
(258, 238, ‘attr’, ‘due_date’, NULL, ‘2015-06-26’),
(259, 238, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(260, 238, ‘attr’, ‘estimated_hours’, NULL, ‘0.1’),
(261, 239, ‘attr’, ‘due_date’, NULL, ‘2015-06-26’),
(262, 239, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(263, 239, ‘attr’, ‘estimated_hours’, NULL, ‘0.5’),
(264, 240, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(265, 241, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(266, 242, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(267, 243, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(268, 244, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(269, 245, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(270, 246, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(271, 247, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(272, 248, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(273, 249, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(274, 250, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(275, 251, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(276, 252, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(277, 253, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(278, 254, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(279, 255, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(280, 256, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(281, 257, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(282, 258, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(283, 259, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(284, 260, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(285, 261, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(286, 262, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(287, 263, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(288, 264, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(289, 265, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(290, 266, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(291, 267, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(292, 268, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(293, 269, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(294, 270, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(295, 271, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(296, 272, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(297, 273, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(298, 274, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(299, 275, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(300, 276, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(301, 276, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(302, 277, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(303, 279, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(304, 280, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(305, 281, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(306, 281, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(307, 282, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(308, 283, ‘attr’, ‘subject’, ‘OS_07 dsMain的整体高度偏大’, ‘OS_07 dsMain和dsInput 的整体高度偏大’),
(309, 284, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(310, 285, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(311, 286, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(312, 287, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(313, 288, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(314, 289, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(315, 290, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(316, 291, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(317, 292, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(318, 293, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(319, 295, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(320, 296, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(321, 297, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(322, 298, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(323, 299, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(324, 300, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(325, 301, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(326, 302, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(327, 303, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(328, 304, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(329, 305, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(330, 306, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(331, 307, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(332, 308, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(333, 309, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(334, 310, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(335, 311, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(336, 312, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(337, 313, ‘relation’, ‘copied_to’, NULL, ‘180’),
(338, 314, ‘relation’, ‘copied_from’, NULL, ‘28’),
(339, 315, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(340, 316, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(341, 317, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(342, 318, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(343, 319, ‘attr’, ‘subject’, ‘OS_12 画面最大化以后 呵呵控件互相叠加’, ‘OS_7 画面最大化以后 呵呵控件互相叠加’),
(344, 319, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(345, 320, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(346, 321, ‘attr’, ‘subject’, ‘OS_12 发送邮件控件的颜色不对,id = taMAIL’, ‘OS_7发送邮件控件的颜色不对,id = taMAIL’),
(347, 321, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(348, 322, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(349, 323, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(350, 324, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(351, 325, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(352, 326, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(353, 327, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(354, 328, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(355, 329, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(356, 330, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(357, 331, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(358, 332, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(359, 333, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(360, 334, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(361, 335, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(362, 336, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(363, 337, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(364, 338, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(365, 339, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(366, 340, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(367, 341, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(368, 342, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(369, 343, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(370, 344, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(371, 345, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(372, 346, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(373, 347, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(374, 348, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(375, 349, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(376, 350, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(377, 351, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(378, 352, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(379, 353, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(380, 354, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(381, 355, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(382, 356, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(383, 357, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(384, 358, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(385, 359, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(386, 360, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(387, 361, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(388, 362, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(389, 363, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(390, 364, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(391, 365, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(392, 366, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(393, 367, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(394, 368, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(395, 369, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(396, 370, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(397, 371, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(398, 372, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(399, 373, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(400, 374, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(401, 375, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(402, 376, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(403, 377, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(404, 378, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(405, 379, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(406, 380, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(407, 381, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(408, 382, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(409, 383, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(410, 384, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(411, 385, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(412, 386, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(413, 387, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(414, 387, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(415, 388, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(416, 389, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(417, 389, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(418, 390, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(419, 391, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(420, 391, ‘attr’, ‘done_ratio’, ‘0’, ‘50’),
(421, 392, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(422, 393, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(423, 394, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(424, 395, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(425, 396, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(426, 397, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(427, 398, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(428, 399, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(429, 400, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(430, 401, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(431, 402, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(432, 403, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(433, 404, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(434, 405, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(435, 406, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(436, 407, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(437, 408, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(438, 409, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(439, 410, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(440, 411, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(441, 412, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(442, 413, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(443, 414, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(444, 415, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(445, 416, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(446, 417, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(447, 418, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(448, 419, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(449, 420, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(450, 421, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(451, 422, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(452, 423, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(453, 424, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(454, 424, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(455, 425, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(456, 426, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(457, 427, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(458, 428, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(459, 429, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(460, 430, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(461, 431, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(462, 432, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(463, 433, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(464, 434, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(465, 435, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(466, 436, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(467, 437, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(468, 438, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(469, 439, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(470, 440, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(471, 441, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(472, 442, ‘attr’, ‘status_id’, ‘4’, ‘2’),
(473, 443, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(474, 444, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(475, 445, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(476, 446, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(477, 447, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(478, 448, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(479, 449, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(480, 450, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(481, 451, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(482, 452, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(483, 453, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(484, 454, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(485, 455, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(486, 456, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(487, 457, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(488, 458, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(489, 459, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(490, 460, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(491, 461, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(492, 462, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(493, 463, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(494, 464, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(495, 465, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(496, 466, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(497, 467, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(498, 468, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(499, 469, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(500, 470, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(501, 471, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(502, 472, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(503, 473, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(504, 474, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(505, 475, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(506, 476, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(507, 477, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(508, 477, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(509, 478, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(510, 479, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(511, 480, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(512, 481, ‘attr’, ‘status_id’, ‘11’, ‘12’),
(513, 482, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(514, 483, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(516, 485, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(517, 486, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(521, 488, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(522, 489, ‘attr’, ‘due_date’, ‘2015-06-26’, ‘2015-06-25’),
(523, 490, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(524, 491, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(525, 492, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(526, 493, ‘attr’, ‘due_date’, ‘2015-06-23’, ‘2015-06-26’),
(527, 493, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(528, 493, ‘attr’, ‘start_date’, ‘2015-06-19’, ‘2015-06-24’),
(529, 494, ‘attr’, ‘due_date’, ‘2015-06-26’, ‘2015-06-24’),
(530, 494, ‘attr’, ‘start_date’, ‘2015-06-24’, ‘2015-06-19’),
(531, 495, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(532, 496, ‘attr’, ‘status_id’, ‘11’, ‘12’),
(533, 497, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(534, 497, ‘attr’, ‘assigned_to_id’, ‘8’, ‘3’),
(535, 497, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(536, 498, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(537, 499, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(538, 500, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(539, 501, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(540, 502, ‘attr’, ‘assigned_to_id’, ‘9’, ‘3’),
(541, 503, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(542, 504, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(543, 504, ‘attr’, ‘assigned_to_id’, ‘9’, ‘3’),
(544, 505, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(545, 506, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(546, 506, ‘attr’, ‘assigned_to_id’, ‘9’, ‘3’),
(547, 507, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(548, 508, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(549, 508, ‘attr’, ‘assigned_to_id’, ‘9’, ‘3’),
(550, 509, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(551, 510, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(552, 511, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(553, 512, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(554, 513, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(555, 513, ‘attr’, ‘assigned_to_id’, ‘9’, ‘3’),
(556, 514, ‘attr’, ‘assigned_to_id’, ‘13’, ‘3’),
(557, 515, ‘attr’, ‘assigned_to_id’, ‘13’, ‘3’),
(558, 516, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(559, 516, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(560, 517, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(561, 518, ‘attr’, ‘assigned_to_id’, ‘10’, ‘3’),
(562, 519, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(563, 520, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(564, 521, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(565, 522, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(566, 523, ‘attr’, ‘status_id’, ‘11’, ‘12’),
(567, 524, ‘attr’, ‘status_id’, ‘12’, ‘8’),
(568, 524, ‘attr’, ‘done_ratio’, ‘100’, ‘50’),
(569, 526, ‘attr’, ‘assigned_to_id’, NULL, ‘14’),
(570, 527, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(571, 528, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(572, 529, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(573, 530, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(574, 530, ‘attr’, ‘assigned_to_id’, ‘5’, ‘3’),
(575, 531, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(576, 532, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(577, 533, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(578, 534, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(579, 535, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(580, 536, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(581, 537, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(582, 539, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(583, 540, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(584, 541, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(585, 542, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(586, 543, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(587, 544, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(588, 545, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(589, 546, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(590, 547, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(591, 547, ‘attr’, ‘assigned_to_id’, ‘15’, ‘3’),
(592, 548, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(593, 549, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(594, 550, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(595, 551, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(596, 552, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(597, 553, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(598, 554, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(599, 555, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(600, 556, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(601, 557, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(602, 558, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(603, 559, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(604, 560, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(605, 561, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(606, 562, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(607, 563, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(608, 564, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(609, 565, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(610, 566, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(611, 567, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(612, 568, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(613, 569, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(614, 571, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(615, 572, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(616, 573, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(617, 574, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(618, 575, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(619, 576, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(620, 577, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(621, 578, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(622, 579, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(623, 580, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(624, 581, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(625, 582, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(626, 583, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(627, 584, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(628, 585, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(629, 586, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(630, 587, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(631, 588, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(632, 589, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(633, 590, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(634, 591, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(635, 592, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(636, 593, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(637, 594, ‘attr’, ‘due_date’, NULL, ‘2015-06-24’),
(638, 594, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(639, 594, ‘attr’, ‘start_date’, ‘2015-06-29’, ‘2015-06-22’),
(640, 595, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(641, 595, ‘attr’, ‘assigned_to_id’, ‘11’, ‘3’),
(642, 596, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(643, 597, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(644, 598, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(645, 599, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(646, 600, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(647, 600, ‘attr’, ‘assigned_to_id’, ‘11’, ‘3’),
(648, 601, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(649, 602, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(650, 603, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(651, 603, ‘attr’, ‘assigned_to_id’, ‘11’, ‘3’),
(652, 604, ‘attr’, ‘due_date’, NULL, ‘2015-06-29’),
(653, 605, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(654, 605, ‘attr’, ‘assigned_to_id’, ‘15’, ‘3’),
(655, 606, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(656, 607, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(657, 608, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(658, 608, ‘attr’, ‘assigned_to_id’, ‘16’, ‘3’),
(659, 609, ‘attr’, ‘status_id’, ‘4’, ‘2’),
(660, 610, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(661, 611, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(662, 612, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(663, 613, ‘attr’, ‘status_id’, ‘11’, ‘12’),
(664, 614, ‘attr’, ‘done_ratio’, ‘0’, ‘80’),
(665, 615, ‘attr’, ‘assigned_to_id’, ‘3’, ‘9’),
(666, 616, ‘attr’, ‘assigned_to_id’, ‘3’, ‘9’),
(667, 617, ‘attr’, ‘assigned_to_id’, ‘3’, ‘9’),
(668, 618, ‘attr’, ‘assigned_to_id’, ‘3’, ‘14’),
(669, 619, ‘attr’, ‘assigned_to_id’, ‘3’, ‘14’),
(670, 620, ‘attr’, ‘assigned_to_id’, ‘3’, ‘14’),
(671, 621, ‘attr’, ‘assigned_to_id’, ‘3’, ‘8’),
(672, 622, ‘attr’, ‘assigned_to_id’, ‘3’, ‘8’),
(673, 623, ‘attr’, ‘assigned_to_id’, ‘3’, ‘8’),
(674, 624, ‘attr’, ‘assigned_to_id’, ‘3’, ‘8’),
(675, 625, ‘attr’, ‘assigned_to_id’, ‘3’, ‘8’),
(676, 626, ‘attr’, ‘assigned_to_id’, ‘10’, ‘9’),
(677, 627, ‘attr’, ‘assigned_to_id’, ‘16’, ‘14’),
(678, 628, ‘attr’, ‘assigned_to_id’, ‘9’, ‘10’),
(679, 629, ‘attr’, ‘assigned_to_id’, ‘14’, ‘16’),
(680, 630, ‘attr’, ‘status_id’, ‘12’, ‘8’),
(681, 631, ‘attr’, ‘status_id’, ‘12’, ‘8’),
(682, 632, ‘attr’, ‘status_id’, ‘12’, ‘8’),
(683, 633, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(684, 634, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(685, 635, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(686, 636, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(687, 637, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(688, 638, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(689, 639, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(690, 640, ‘attr’, ‘status_id’, ‘9’, ‘12’),
(691, 640, ‘attr’, ‘assigned_to_id’, ‘3’, ‘10’),
(692, 641, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(693, 641, ‘attr’, ‘assigned_to_id’, ‘17’, ‘3’),
(694, 641, ‘attr’, ‘done_ratio’, ‘0’, ‘70’),
(695, 642, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(696, 643, ‘attr’, ‘assigned_to_id’, ‘3’, ‘8’),
(697, 645, ‘attr’, ‘done_ratio’, ‘50’, ‘100’),
(698, 646, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(699, 647, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(700, 648, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(701, 649, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(702, 650, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(703, 651, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(704, 652, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(705, 653, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(706, 654, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(707, 655, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(708, 656, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(709, 657, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(710, 658, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(711, 659, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(712, 660, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(713, 661, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(714, 662, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(715, 663, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(716, 664, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(717, 665, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(718, 666, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(719, 667, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(720, 668, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(721, 669, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(722, 670, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(723, 671, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(724, 672, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(725, 673, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(726, 675, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(727, 676, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(728, 677, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(729, 678, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(730, 679, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(731, 680, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(732, 681, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(733, 682, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(734, 683, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(735, 684, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(736, 685, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(737, 686, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(738, 687, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(739, 687, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(740, 688, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(741, 689, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(742, 689, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(743, 690, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(744, 691, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(745, 692, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(746, 693, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(747, 694, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(748, 695, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(749, 696, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(750, 697, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(751, 697, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(752, 698, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(753, 698, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(754, 699, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(755, 700, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(756, 701, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(757, 702, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(758, 702, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(759, 703, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(760, 704, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(761, 704, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(762, 705, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(763, 706, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(764, 707, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(765, 708, ‘attr’, ‘due_date’, NULL, ‘2015-06-30’),
(766, 708, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(767, 708, ‘attr’, ‘estimated_hours’, NULL, ‘1.0’),
(768, 709, ‘attr’, ‘assigned_to_id’, NULL, ‘17’),
(769, 710, ‘attr’, ‘assigned_to_id’, NULL, ‘17’),
(770, 711, ‘attr’, ‘assigned_to_id’, NULL, ‘17’),
(771, 712, ‘attr’, ‘assigned_to_id’, NULL, ‘17’),
(772, 713, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(773, 714, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(774, 715, ‘attr’, ‘status_id’, ‘6’, ‘3’),
(775, 716, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(776, 717, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(777, 718, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(778, 719, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(779, 720, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(780, 721, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(781, 722, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(782, 723, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(783, 724, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(784, 725, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(785, 726, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(786, 727, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(787, 728, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(788, 728, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(789, 728, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(790, 729, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(791, 730, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(792, 731, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(793, 731, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(794, 732, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(795, 733, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(796, 734, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(797, 735, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(798, 736, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(799, 737, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(800, 738, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(801, 740, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(802, 740, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(803, 741, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(804, 745, ‘attr’, ‘assigned_to_id’, NULL, ‘17’),
(805, 747, ‘attr’, ‘assigned_to_id’, NULL, ‘17’),
(806, 748, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(807, 749, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(808, 750, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(809, 751, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(810, 752, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(811, 754, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(812, 755, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(813, 756, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(814, 757, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(815, 757, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(816, 758, ‘attr’, ‘assigned_to_id’, NULL, ‘17’),
(817, 760, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(818, 761, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(819, 762, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(820, 762, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(821, 763, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(822, 764, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(823, 766, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(824, 766, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(825, 767, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(826, 767, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(827, 768, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(828, 769, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(829, 769, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(830, 770, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(831, 771, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(832, 772, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(833, 773, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(834, 774, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(835, 775, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(836, 776, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(837, 776, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(838, 777, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(839, 778, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(840, 779, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(841, 780, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(842, 781, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(843, 782, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(844, 782, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(845, 783, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(846, 783, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(847, 784, ‘attr’, ‘tracker_id’, ‘5’, ‘1’),
(848, 784, ‘attr’, ‘subject’, ‘PM_02_INVENT_CONSULT_LIST’, ‘PM_02_INVENT_CONSULT_LIST Tab命名’),
(849, 784, ‘attr’, ‘status_id’, ‘9’, ‘1’),
(850, 784, ‘attr’, ‘assigned_to_id’, ‘9’, ‘5’),
(851, 785, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(852, 785, ‘attr’, ‘priority_id’, ‘2’, ‘1’),
(853, 785, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(854, 786, ‘attr’, ‘subject’, ‘PM_02_INVENT_CONSULT_LIST Tab命名’, ‘PM_02_INVENT_CONSULT_LIST’),
(855, 786, ‘attr’, ‘assigned_to_id’, ‘5’, ‘9’),
(856, 787, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(857, 787, ‘attr’, ‘assigned_to_id’, ‘7’, ‘17’),
(858, 788, ‘attr’, ‘tracker_id’, ‘1’, ‘5’),
(859, 789, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(860, 790, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(861, 792, ‘attr’, ‘tracker_id’, ‘5’, ‘1’),
(862, 793, ‘attr’, ‘tracker_id’, ‘5’, ‘1’),
(863, 794, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(864, 794, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(865, 795, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(866, 796, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(867, 797, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(868, 797, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(869, 799, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(870, 800, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(871, 801, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(872, 802, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(873, 802, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(874, 803, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(875, 804, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(876, 805, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(877, 806, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(878, 807, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(879, 808, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(880, 809, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(881, 809, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(882, 810, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(883, 810, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(884, 812, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(885, 813, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(886, 813, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(887, 814, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(888, 816, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(889, 817, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(890, 817, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(891, 818, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(892, 820, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(893, 822, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(894, 827, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(895, 827, ‘attr’, ‘assigned_to_id’, ‘17’, ‘8’),
(896, 827, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(897, 830, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(898, 830, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(899, 830, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(900, 831, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(901, 831, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(902, 831, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(903, 832, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(904, 832, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(905, 832, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(906, 833, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(907, 833, ‘attr’, ‘assigned_to_id’, ‘17’, ‘8’),
(908, 833, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(909, 834, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(910, 834, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(911, 834, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(912, 835, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(913, 835, ‘attr’, ‘assigned_to_id’, ‘17’, ‘7’),
(914, 835, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(915, 836, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(916, 836, ‘attr’, ‘assigned_to_id’, ‘17’, ‘8’),
(917, 836, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(918, 837, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(919, 838, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(920, 839, ‘attr’, ‘due_date’, NULL, ‘2015-07-01’),
(921, 839, ‘attr’, ‘start_date’, ‘2015-06-30’, ‘2015-07-01’),
(922, 839, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(923, 839, ‘attr’, ‘estimated_hours’, NULL, ‘0.1’),
(924, 840, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(925, 841, ‘attr’, ‘assigned_to_id’, NULL, ‘3’),
(926, 842, ‘attr’, ‘due_date’, NULL, ‘2015-07-01’),
(927, 842, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(928, 842, ‘attr’, ‘start_date’, ‘2015-06-30’, ‘2015-07-01’),
(929, 842, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(930, 842, ‘attr’, ‘estimated_hours’, NULL, ‘0.1’),
(931, 843, ‘attr’, ‘assigned_to_id’, NULL, ‘3’),
(932, 844, ‘attr’, ‘assigned_to_id’, NULL, ‘3’),
(933, 845, ‘attr’, ‘assigned_to_id’, NULL, ‘3’),
(934, 846, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(935, 847, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(936, 848, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(937, 849, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(938, 850, ‘attr’, ‘tracker_id’, ‘5’, ‘1’),
(939, 851, ‘attr’, ‘tracker_id’, ‘5’, ‘1’),
(940, 852, ‘attr’, ‘tracker_id’, ‘5’, ‘1’),
(941, 853, ‘attr’, ‘subject’, ‘OS_08 S而vice层变量命名不规范’, ‘OS_08 Service层变量命名不规范’),
(942, 854, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(943, 854, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(944, 855, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(945, 855, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(946, 856, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(947, 856, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(948, 857, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(949, 857, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(950, 858, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(951, 858, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(952, 859, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(953, 859, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(954, 863, ‘attr’, ‘assigned_to_id’, ‘9’, ‘5’),
(955, 864, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(956, 865, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(957, 865, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(958, 866, ‘attr’, ‘assigned_to_id’, ‘13’, ‘20’),
(959, 867, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(960, 868, ‘attr’, ‘assigned_to_id’, ‘13’, ‘20’),
(961, 869, ‘attr’, ‘assigned_to_id’, ‘13’, ‘20’),
(962, 870, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(963, 871, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(964, 872, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(965, 873, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(966, 874, ‘attr’, ‘assigned_to_id’, ‘13’, ‘20’),
(967, 875, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(968, 876, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(969, 877, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(970, 878, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(971, 878, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(972, 879, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(973, 880, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(974, 881, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(975, 882, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(976, 883, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(977, 884, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(978, 885, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(979, 886, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(980, 887, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(981, 888, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(982, 889, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(983, 890, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(984, 891, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(985, 892, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(986, 893, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(987, 894, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(988, 895, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(989, 896, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(990, 897, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(991, 898, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(992, 899, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(993, 900, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(994, 901, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(995, 902, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(996, 903, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(997, 904, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(998, 905, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(999, 906, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1000, 907, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1001, 908, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1002, 909, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1003, 910, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1004, 911, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1005, 912, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1006, 913, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1007, 914, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1008, 915, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1009, 916, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1010, 917, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1011, 919, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1012, 920, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1013, 921, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1014, 922, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1015, 923, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1016, 924, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1017, 925, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1018, 926, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1019, 927, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1020, 928, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1021, 929, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1022, 930, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1023, 931, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1024, 932, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1025, 933, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1026, 934, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1027, 935, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1028, 936, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1029, 937, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1030, 938, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1031, 939, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1032, 940, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1033, 941, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1034, 942, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1035, 943, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1036, 944, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1037, 945, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1038, 946, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1039, 947, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1040, 948, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1041, 949, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1042, 950, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1043, 951, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1044, 951, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1045, 952, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(1046, 953, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1047, 954, ‘attr’, ‘assigned_to_id’, ‘15’, ‘14’),
(1048, 955, ‘attr’, ‘assigned_to_id’, ‘15’, ‘14’),
(1049, 956, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(1050, 957, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1051, 958, ‘attr’, ‘assigned_to_id’, ‘5’, ‘3’),
(1052, 959, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1053, 959, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1054, 960, ‘attr’, ‘assigned_to_id’, ‘5’, ‘17’),
(1055, 961, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1056, 961, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1057, 962, ‘attr’, ‘assigned_to_id’, ‘5’, ‘17’),
(1058, 963, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1059, 963, ‘attr’, ‘assigned_to_id’, ‘3’, ‘7’),
(1060, 965, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1061, 965, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1062, 966, ‘attr’, ‘assigned_to_id’, ‘5’, ‘17’),
(1063, 967, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(1064, 968, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1065, 968, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1066, 969, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1067, 970, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1068, 970, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1069, 971, ‘attr’, ‘assigned_to_id’, ‘5’, ‘3’),
(1070, 972, ‘attr’, ‘assigned_to_id’, ‘5’, ‘3’),
(1071, 973, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1072, 973, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1073, 974, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1074, 974, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1075, 975, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1076, 976, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1077, 977, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1078, 978, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1079, 979, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1080, 980, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1081, 981, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1082, 982, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1083, 983, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1084, 984, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(1085, 985, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1086, 986, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1087, 987, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1088, 988, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1089, 989, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1090, 990, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1091, 991, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1092, 991, ‘attr’, ‘assigned_to_id’, ‘3’, NULL),
(1093, 995, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1094, 995, ‘attr’, ‘assigned_to_id’, ‘10’, NULL),
(1095, 996, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1096, 997, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1097, 997, ‘attr’, ‘assigned_to_id’, ‘6’, NULL),
(1098, 998, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1099, 999, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1100, 999, ‘attr’, ‘assigned_to_id’, ‘8’, NULL),
(1101, 1000, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1102, 1001, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1103, 1002, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1104, 1003, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1105, 1003, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1106, 1004, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1107, 1005, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1108, 1006, ‘attr’, ‘status_id’, ‘1’, ‘13’),
(1109, 1007, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1110, 1007, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1111, 1008, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1112, 1008, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1113, 1009, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1114, 1009, ‘attr’, ‘assigned_to_id’, ‘10’, NULL),
(1115, 1010, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1116, 1010, ‘attr’, ‘assigned_to_id’, ‘8’, NULL),
(1117, 1011, ‘attr’, ‘subject’, ‘Customer_150630_2(画面:PM_02_INVENT_CONSULT_LIST)’, ‘Customer_150630_3(画面:PM_02_INVENT_CONSULT_LIST)’),
(1118, 1012, ‘attr’, ‘status_id’, ‘1’, ‘14’),
(1119, 1013, ‘attr’, ‘status_id’, ‘1’, ‘14’),
(1120, 1014, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1121, 1015, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(1122, 1016, ‘attr’, ‘tracker_id’, ‘4’, ‘1’),
(1123, 1017, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1124, 1018, ‘attr’, ‘subject’, ‘待确认问题汇总[3个]’, ‘待确认问题汇总[2个]’),
(1125, 1019, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1126, 1020, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1127, 1020, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1128, 1021, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1129, 1022, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1130, 1022, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1131, 1023, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(1132, 1024, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1133, 1024, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1134, 1025, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(1135, 1026, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1136, 1027, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1137, 1028, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1138, 1029, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1139, 1030, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1140, 1030, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1141, 1031, ‘attr’, ‘status_id’, ‘14’, ‘3’),
(1142, 1031, ‘attr’, ‘assigned_to_id’, ‘19’, ‘16’);
INSERT INTO journal_details
(id
, journal_id
, property
, prop_key
, old_value
, value
) VALUES
(1143, 1032, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1144, 1033, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1145, 1034, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1146, 1034, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1147, 1035, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(1148, 1036, ‘attr’, ‘assigned_to_id’, ‘8’, ‘9’),
(1149, 1036, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1150, 1037, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1151, 1038, ‘attr’, ‘assigned_to_id’, ‘8’, ‘3’),
(1152, 1040, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(1153, 1041, ‘attr’, ‘assigned_to_id’, ‘5’, ‘20’),
(1154, 1042, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1155, 1043, ‘attr’, ‘status_id’, ‘14’, ‘3’),
(1156, 1044, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1157, 1045, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1158, 1046, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1159, 1047, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1160, 1050, ‘attr’, ‘assigned_to_id’, ‘16’, ‘3’),
(1161, 1051, ‘attr’, ‘assigned_to_id’, ‘16’, ‘8’),
(1162, 1052, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1163, 1052, ‘attr’, ‘assigned_to_id’, ‘8’, ‘16’),
(1164, 1052, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1165, 1053, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1166, 1053, ‘attr’, ‘assigned_to_id’, ‘8’, ‘16’),
(1167, 1054, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1168, 1055, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1169, 1055, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(1170, 1056, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1171, 1056, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1172, 1058, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1173, 1059, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1174, 1061, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1175, 1062, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1176, 1063, ‘attr’, ‘done_ratio’, ‘100’, ‘0’),
(1177, 1064, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1178, 1065, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1179, 1066, ‘attr’, ‘done_ratio’, ‘100’, ‘0’),
(1180, 1067, ‘attr’, ‘done_ratio’, ‘100’, ‘0’),
(1181, 1068, ‘attr’, ‘done_ratio’, ‘100’, ‘0’),
(1182, 1069, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1183, 1070, ‘attr’, ‘tracker_id’, ‘5’, ‘1’),
(1184, 1071, ‘attr’, ‘subject’, ‘PM_05 最下面表格中等长数据应该居中,请检查所以表格。’, ‘PM_05 最下面表格中等长数据应该居中,请检查所有表格。’),
(1185, 1073, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1186, 1074, ‘attr’, ‘assigned_to_id’, ‘19’, ‘8’),
(1187, 1075, ‘attr’, ‘assigned_to_id’, ‘19’, ‘6’),
(1188, 1076, ‘attr’, ‘assigned_to_id’, ‘19’, ‘15’),
(1189, 1077, ‘attr’, ‘assigned_to_id’, ‘19’, ‘3’),
(1190, 1080, ‘attr’, ‘assigned_to_id’, ‘19’, ‘6’),
(1191, 1081, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1192, 1082, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1193, 1082, ‘attr’, ‘assigned_to_id’, ‘8’, ‘9’),
(1194, 1083, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1195, 1084, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(1196, 1085, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1197, 1086, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1198, 1086, ‘attr’, ‘assigned_to_id’, ‘8’, ‘17’),
(1199, 1087, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1200, 1088, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1201, 1089, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1202, 1090, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1203, 1091, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1204, 1092, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1205, 1093, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1206, 1094, ‘attr’, ‘status_id’, ‘12’, ‘8’),
(1207, 1095, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1208, 1095, ‘attr’, ‘assigned_to_id’, ‘10’, ‘3’),
(1209, 1096, ‘attr’, ‘assigned_to_id’, ‘10’, ‘17’),
(1210, 1097, ‘attr’, ‘assigned_to_id’, ‘10’, ‘17’),
(1211, 1098, ‘attr’, ‘assigned_to_id’, ‘10’, ‘9’),
(1216, 1104, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1217, 1105, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1218, 1107, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1219, 1107, ‘attr’, ‘done_ratio’, ‘70’, ‘90’),
(1220, 1108, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1221, 1109, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1222, 1110, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1223, 1111, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1224, 1111, ‘attr’, ‘assigned_to_id’, ‘7’, ‘20’),
(1225, 1112, ‘attr’, ‘status_id’, ‘13’, ‘2’),
(1226, 1113, ‘attr’, ‘assigned_to_id’, ‘19’, ‘3’),
(1227, 1114, ‘attr’, ‘assigned_to_id’, ‘19’, ‘3’),
(1228, 1115, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1229, 1115, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1230, 1116, ‘attr’, ‘subject’, ‘PM_16 SQL部分PM_16_FR_OA_ACT_COMP_LIST.select命名不符合规范’, ‘PM_16 SQL部分PM_16_FR_OA_ACT_COMP_LIST.selec 和 dsAction中的命名不一致,请确认。’),
(1231, 1117, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1232, 1118, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1233, 1119, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1234, 1121, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1235, 1121, ‘attr’, ‘assigned_to_id’, ‘8’, ‘15’),
(1236, 1122, ‘attr’, ‘assigned_to_id’, ‘19’, ‘5’),
(1237, 1123, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1238, 1124, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1239, 1125, ‘attr’, ‘assigned_to_id’, ‘16’, ‘3’),
(1240, 1126, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1241, 1126, ‘attr’, ‘assigned_to_id’, ‘7’, ‘20’),
(1242, 1127, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1243, 1128, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1244, 1129, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1245, 1130, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1246, 1131, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1247, 1132, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1248, 1133, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1249, 1134, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1250, 1135, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1251, 1136, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1252, 1137, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1253, 1138, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1254, 1139, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1255, 1140, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1256, 1141, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1257, 1141, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1258, 1142, ‘attr’, ‘assigned_to_id’, ‘19’, ‘16’),
(1259, 1143, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1260, 1143, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1261, 1144, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1262, 1144, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1263, 1145, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1264, 1145, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1265, 1146, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1266, 1146, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1267, 1147, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1268, 1148, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1269, 1149, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1270, 1149, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1271, 1150, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1272, 1150, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1273, 1151, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1274, 1151, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1275, 1152, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1276, 1152, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1277, 1153, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1278, 1153, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1279, 1154, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1280, 1154, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1281, 1155, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1282, 1155, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1283, 1156, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1284, 1157, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1285, 1158, ‘attr’, ‘assigned_to_id’, ‘13’, ‘14’),
(1286, 1159, ‘attr’, ‘assigned_to_id’, ‘6’, ‘20’),
(1287, 1160, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1288, 1161, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1289, 1162, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1290, 1163, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1291, 1164, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1292, 1165, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1293, 1166, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1294, 1167, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1295, 1168, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1296, 1169, ‘attr’, ‘tracker_id’, ‘5’, ‘4’),
(1297, 1170, ‘attachment’, ‘4’, NULL, ‘Desert.jpg’),
(1298, 1172, ‘attr’, ‘assigned_to_id’, ‘19’, ‘11’),
(1299, 1173, ‘attachment’, ‘4’, ‘Desert.jpg’, NULL),
(1300, 1175, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1301, 1176, ‘attr’, ‘due_date’, NULL, ‘2015-07-01’),
(1302, 1176, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1303, 1177, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1304, 1178, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1305, 1179, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1306, 1180, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1307, 1181, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1308, 1182, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1309, 1183, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1310, 1184, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1311, 1185, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1312, 1186, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1313, 1187, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1314, 1188, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1315, 1189, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1316, 1190, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1317, 1191, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1318, 1192, ‘attr’, ‘status_id’, ‘1’, ‘13’),
(1319, 1193, ‘attr’, ‘assigned_to_id’, ‘19’, ‘11’),
(1320, 1194, ‘attr’, ‘status_id’, ‘1’, ‘13’),
(1321, 1196, ‘attr’, ‘assigned_to_id’, ‘19’, ‘8’),
(1322, 1197, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1323, 1198, ‘attr’, ‘assigned_to_id’, ‘16’, ‘3’),
(1324, 1199, ‘attr’, ‘assigned_to_id’, ‘6’, ‘20’),
(1325, 1200, ‘attr’, ‘assigned_to_id’, ‘6’, ‘17’),
(1326, 1200, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1327, 1201, ‘attr’, ‘assigned_to_id’, ‘6’, ‘20’),
(1328, 1201, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1329, 1202, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1330, 1202, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1331, 1203, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1332, 1204, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1333, 1204, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1334, 1205, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1335, 1205, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1336, 1206, ‘attr’, ‘due_date’, NULL, ‘2015-07-01’),
(1337, 1206, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1338, 1206, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1339, 1206, ‘attr’, ‘estimated_hours’, NULL, ‘0.2’),
(1340, 1207, ‘attr’, ‘due_date’, NULL, ‘2015-07-01’),
(1341, 1207, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1342, 1207, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1343, 1208, ‘attr’, ‘due_date’, NULL, ‘2015-07-01’),
(1344, 1208, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1345, 1208, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1346, 1209, ‘attr’, ‘due_date’, NULL, ‘2015-07-01’),
(1347, 1209, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1348, 1209, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1349, 1210, ‘attr’, ‘assigned_to_id’, ‘6’, ‘8’),
(1350, 1210, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1351, 1213, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1352, 1215, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1353, 1216, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1354, 1218, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1355, 1219, ‘attr’, ‘assigned_to_id’, ‘19’, ‘16’),
(1356, 1220, ‘attr’, ‘assigned_to_id’, ‘19’, ‘16’),
(1357, 1221, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1358, 1222, ‘attr’, ‘status_id’, ‘2’, ‘14’),
(1359, 1223, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(1360, 1224, ‘attr’, ‘assigned_to_id’, ‘20’, ‘7’),
(1361, 1225, ‘attr’, ‘status_id’, ‘6’, ‘2’),
(1362, 1226, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(1363, 1227, ‘attr’, ‘status_id’, ‘1’, ‘8’),
(1364, 1228, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1365, 1229, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1366, 1230, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1367, 1230, ‘attr’, ‘assigned_to_id’, ‘3’, ‘16’),
(1368, 1231, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1369, 1232, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1370, 1233, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1371, 1234, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1372, 1235, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1373, 1236, ‘attr’, ‘status_id’, ‘5’, ‘12’),
(1374, 1237, ‘attr’, ‘status_id’, ‘12’, ‘8’),
(1375, 1240, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1376, 1241, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1377, 1242, ‘attr’, ‘status_id’, ‘3’, ‘6’),
(1378, 1243, ‘attr’, ‘status_id’, ‘6’, ‘3’),
(1379, 1244, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1380, 1245, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1381, 1246, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1382, 1246, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1383, 1247, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1384, 1248, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1385, 1249, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1386, 1250, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1387, 1251, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1388, 1252, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1389, 1253, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1390, 1254, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1391, 1254, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1392, 1255, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1393, 1256, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1394, 1257, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1395, 1258, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1396, 1259, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1397, 1260, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1398, 1261, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1399, 1262, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1400, 1263, ‘attr’, ‘assigned_to_id’, ‘14’, NULL),
(1401, 1264, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1402, 1265, ‘attr’, ‘status_id’, ‘4’, ‘2’),
(1403, 1265, ‘attr’, ‘assigned_to_id’, ‘20’, ‘8’),
(1404, 1266, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1405, 1267, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1406, 1268, ‘attr’, ‘assigned_to_id’, ‘6’, NULL),
(1407, 1269, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1408, 1270, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1409, 1271, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1410, 1272, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1411, 1273, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1412, 1274, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1413, 1275, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1414, 1276, ‘attr’, ‘status_id’, ‘9’, ‘5’),
(1415, 1277, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1416, 1277, ‘attr’, ‘assigned_to_id’, ‘3’, NULL),
(1417, 1278, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1418, 1278, ‘attr’, ‘assigned_to_id’, ‘3’, NULL),
(1419, 1279, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1420, 1279, ‘attr’, ‘assigned_to_id’, ‘12’, NULL),
(1421, 1280, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1422, 1281, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1423, 1281, ‘attr’, ‘assigned_to_id’, ‘10’, ‘3’),
(1424, 1282, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1425, 1283, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1426, 1283, ‘attr’, ‘assigned_to_id’, ‘5’, NULL),
(1427, 1284, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1428, 1284, ‘attr’, ‘assigned_to_id’, ‘5’, NULL),
(1429, 1285, ‘attr’, ‘status_id’, ‘8’, ‘9’),
(1430, 1285, ‘attr’, ‘assigned_to_id’, ‘13’, ‘3’),
(1431, 1286, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1432, 1286, ‘attr’, ‘assigned_to_id’, ‘3’, NULL),
(1433, 1287, ‘attr’, ‘status_id’, ‘9’, ‘10’),
(1434, 1287, ‘attr’, ‘assigned_to_id’, ‘3’, NULL),
(1435, 1288, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(1436, 1289, ‘attr’, ‘assigned_to_id’, NULL, ‘8’),
(1437, 1290, ‘attr’, ‘assigned_to_id’, NULL, ‘12’),
(1438, 1291, ‘attr’, ‘assigned_to_id’, NULL, ‘12’),
(1439, 1292, ‘attr’, ‘assigned_to_id’, NULL, ‘15’),
(1440, 1293, ‘attr’, ‘assigned_to_id’, NULL, ‘7’),
(1441, 1294, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1442, 1294, ‘attr’, ‘assigned_to_id’, ‘7’, ‘20’),
(1443, 1294, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1444, 1295, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(1445, 1296, ‘attr’, ‘assigned_to_id’, NULL, ‘10’),
(1446, 1297, ‘attr’, ‘assigned_to_id’, NULL, ‘16’),
(1447, 1298, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1448, 1298, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1449, 1299, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1450, 1300, ‘attr’, ‘assigned_to_id’, ‘3’, NULL),
(1451, 1301, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1452, 1302, ‘attr’, ‘assigned_to_id’, NULL, ‘7’),
(1453, 1303, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1454, 1304, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1455, 1305, ‘attr’, ‘assigned_to_id’, ‘8’, ‘20’),
(1456, 1306, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1457, 1307, ‘attr’, ‘assigned_to_id’, ‘8’, ‘20’),
(1458, 1308, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1459, 1308, ‘attr’, ‘done_ratio’, ‘0’, ‘80’),
(1460, 1309, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1461, 1310, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1462, 1310, ‘attr’, ‘assigned_to_id’, ‘14’, ‘20’),
(1463, 1310, ‘attr’, ‘done_ratio’, ‘80’, ‘100’),
(1464, 1311, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1465, 1312, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1466, 1312, ‘attr’, ‘assigned_to_id’, ‘19’, ‘12’),
(1467, 1313, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1468, 1313, ‘attr’, ‘assigned_to_id’, ‘12’, ‘20’),
(1469, 1314, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1470, 1315, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1471, 1316, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1472, 1316, ‘attr’, ‘assigned_to_id’, ‘7’, ‘3’),
(1473, 1317, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1474, 1318, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1475, 1318, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1476, 1319, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1477, 1320, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1478, 1320, ‘attr’, ‘assigned_to_id’, ‘17’, NULL),
(1479, 1321, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1480, 1321, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1481, 1322, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1482, 1322, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1483, 1323, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1484, 1323, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1485, 1324, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1486, 1325, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1487, 1325, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1488, 1327, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1489, 1327, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1490, 1328, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1491, 1328, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1492, 1329, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1493, 1329, ‘attr’, ‘assigned_to_id’, ‘8’, ‘6’),
(1494, 1331, ‘attr’, ‘assigned_to_id’, ‘19’, ‘8’),
(1495, 1332, ‘attr’, ‘status_id’, ‘2’, ‘13’),
(1496, 1333, ‘attr’, ‘status_id’, ‘6’, ‘3’),
(1497, 1334, ‘attr’, ‘status_id’, ‘13’, ‘15’),
(1498, 1335, ‘attr’, ‘assigned_to_id’, ‘10’, ‘9’),
(1499, 1336, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1500, 1337, ‘attr’, ‘status_id’, ‘1’, ‘13’),
(1501, 1338, ‘attr’, ‘status_id’, ‘1’, ‘13’),
(1502, 1339, ‘attr’, ‘status_id’, ‘13’, ‘15’),
(1503, 1340, ‘attr’, ‘status_id’, ‘15’, ‘13’),
(1504, 1341, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1505, 1342, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1506, 1343, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1507, 1344, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1508, 1345, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1509, 1346, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1510, 1347, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1511, 1348, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1512, 1349, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1513, 1350, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1514, 1351, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1515, 1352, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1516, 1353, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1517, 1354, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1518, 1355, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1519, 1356, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1520, 1357, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1521, 1358, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1522, 1359, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1523, 1360, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1524, 1361, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1525, 1362, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1526, 1363, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1527, 1364, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1528, 1365, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1529, 1366, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1530, 1367, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1531, 1368, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1532, 1369, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1533, 1370, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1534, 1371, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1535, 1372, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1536, 1373, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1537, 1374, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1538, 1375, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1539, 1376, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1540, 1377, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1541, 1378, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1542, 1379, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1543, 1380, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1544, 1381, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1545, 1382, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1546, 1383, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1547, 1384, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1548, 1385, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1549, 1386, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1550, 1387, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1551, 1388, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1552, 1389, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1553, 1390, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1554, 1391, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1555, 1392, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1556, 1393, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1557, 1394, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1558, 1395, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1559, 1396, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1560, 1397, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1561, 1398, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1562, 1399, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1563, 1400, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1564, 1401, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1565, 1402, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1566, 1403, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1567, 1404, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1568, 1405, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1569, 1406, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1570, 1407, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1571, 1408, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1572, 1409, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1573, 1410, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1574, 1411, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1575, 1412, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1576, 1413, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1577, 1414, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1578, 1415, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1579, 1416, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1580, 1417, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1581, 1418, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1582, 1419, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1583, 1420, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1584, 1421, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1585, 1422, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1586, 1423, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1587, 1424, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1588, 1425, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1589, 1426, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1590, 1427, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1591, 1428, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1592, 1429, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1593, 1430, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1594, 1431, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1595, 1432, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1596, 1433, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1597, 1434, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1598, 1435, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1599, 1436, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1600, 1437, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1601, 1438, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1602, 1439, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1603, 1440, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1604, 1441, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1605, 1442, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1606, 1443, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1607, 1444, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1608, 1445, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1609, 1446, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1610, 1447, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1611, 1448, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1612, 1449, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1613, 1450, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1614, 1451, ‘attr’, ‘subject’, ‘按钮高度为20px,和其他页面统一。’, ‘按钮高度为20px,和其他画面统一。’),
(1615, 1452, ‘attr’, ‘status_id’, ‘6’, ‘3’),
(1616, 1452, ‘attr’, ‘assigned_to_id’, ‘10’, ‘9’),
(1617, 1453, ‘attr’, ‘status_id’, ‘6’, ‘3’),
(1618, 1453, ‘attr’, ‘assigned_to_id’, ‘10’, ‘9’),
(1619, 1454, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1620, 1455, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1621, 1456, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1622, 1457, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1623, 1458, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1624, 1459, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1625, 1460, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1626, 1461, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1627, 1462, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1628, 1463, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1629, 1464, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1630, 1465, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1631, 1466, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1632, 1467, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1633, 1468, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1634, 1469, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1635, 1470, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1636, 1471, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1637, 1472, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1638, 1473, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1639, 1474, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1640, 1475, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1641, 1476, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1642, 1477, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1643, 1478, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1644, 1479, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1645, 1480, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1646, 1481, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1647, 1482, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1648, 1483, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1649, 1484, ‘attr’, ‘status_id’, ‘6’, ‘3’),
(1650, 1484, ‘attr’, ‘assigned_to_id’, ‘10’, ‘9’),
(1651, 1484, ‘cf’, ‘1’, NULL, ‘UI’),
(1652, 1485, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1653, 1485, ‘attr’, ‘assigned_to_id’, ‘10’, ‘7’),
(1654, 1485, ‘cf’, ‘1’, NULL, ‘UI’),
(1655, 1486, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1656, 1486, ‘attr’, ‘assigned_to_id’, ‘9’, ‘10’),
(1657, 1486, ‘cf’, ‘1’, NULL, ‘UI’),
(1658, 1487, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1659, 1487, ‘attr’, ‘assigned_to_id’, ‘9’, ‘10’),
(1660, 1488, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1661, 1488, ‘attr’, ‘assigned_to_id’, ‘9’, ‘10’),
(1662, 1488, ‘cf’, ‘1’, NULL, ‘UI’),
(1663, 1489, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1664, 1489, ‘attr’, ‘assigned_to_id’, ‘9’, ‘10’),
(1665, 1489, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1666, 1489, ‘cf’, ‘1’, NULL, ‘Other’),
(1667, 1490, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1668, 1490, ‘cf’, ‘1’, NULL, ‘UI’),
(1669, 1491, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1670, 1491, ‘attr’, ‘assigned_to_id’, ‘9’, ‘10’),
(1671, 1491, ‘cf’, ‘1’, NULL, ‘UI’),
(1672, 1492, ‘cf’, ‘1’, NULL, ‘UI’),
(1673, 1493, ‘cf’, ‘1’, NULL, ‘UI’),
(1674, 1494, ‘cf’, ‘1’, NULL, ‘UI’),
(1675, 1495, ‘attachment’, ‘11’, ‘style2.JPG’, NULL),
(1676, 1496, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1677, 1497, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1678, 1498, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1679, 1499, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1680, 1500, ‘attr’, ‘assigned_to_id’, ‘19’, ‘15’),
(1681, 1501, ‘attr’, ‘tracker_id’, ‘6’, ‘4’),
(1682, 1503, ‘attr’, ‘assigned_to_id’, ‘19’, ‘12’),
(1683, 1504, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1684, 1504, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1685, 1504, ‘cf’, ‘1’, NULL, ‘Functional’),
(1686, 1505, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1687, 1505, ‘attr’, ‘assigned_to_id’, ‘7’, ‘11’),
(1688, 1506, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1689, 1506, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1690, 1506, ‘cf’, ‘1’, NULL, ‘Functional’),
(1691, 1508, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1692, 1508, ‘attr’, ‘assigned_to_id’, ‘7’, ‘11’),
(1693, 1509, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1694, 1509, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1695, 1509, ‘cf’, ‘1’, NULL, ‘UI’),
(1696, 1510, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1697, 1510, ‘attr’, ‘assigned_to_id’, ‘7’, ‘11’),
(1698, 1511, ‘attr’, ‘assigned_to_id’, ‘19’, ‘5’),
(1699, 1512, ‘attr’, ‘status_id’, ‘13’, ‘15’),
(1700, 1514, ‘attr’, ‘assigned_to_id’, ‘19’, ‘8’),
(1701, 1515, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1702, 1516, ‘attr’, ‘assigned_to_id’, ‘12’, ‘3’),
(1703, 1517, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1704, 1517, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1705, 1517, ‘cf’, ‘1’, NULL, ‘Functional’),
(1706, 1518, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1707, 1518, ‘attr’, ‘assigned_to_id’, ‘7’, ‘11’),
(1708, 1519, ‘attr’, ‘assigned_to_id’, ‘19’, ‘7’),
(1709, 1520, ‘attr’, ‘assigned_to_id’, ‘19’, ‘7’),
(1710, 1522, ‘attr’, ‘assigned_to_id’, ‘19’, ‘11’),
(1711, 1523, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1712, 1523, ‘attr’, ‘assigned_to_id’, ‘15’, ‘16’),
(1713, 1524, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1714, 1525, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1715, 1525, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1716, 1525, ‘cf’, ‘1’, NULL, ‘Functional’),
(1717, 1526, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1718, 1526, ‘attr’, ‘assigned_to_id’, ‘7’, ‘11’),
(1719, 1527, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1720, 1528, ‘attr’, ‘status_id’, ‘14’, ‘3’),
(1721, 1529, ‘attr’, ‘priority_id’, ‘5’, ‘4’),
(1722, 1531, ‘attr’, ‘tracker_id’, ‘1’, ‘4’),
(1723, 1531, ‘attr’, ‘assigned_to_id’, NULL, ‘19’),
(1724, 1532, ‘attr’, ‘tracker_id’, ‘4’, ‘6’),
(1725, 1534, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1726, 1535, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1727, 1536, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1728, 1536, ‘cf’, ‘1’, NULL, ‘SQL’),
(1729, 1537, ‘attr’, ‘status_id’, ‘10’, ‘11’),
(1730, 1538, ‘attr’, ‘assigned_to_id’, ‘16’, ‘3’),
(1731, 1539, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1732, 1539, ‘cf’, ‘1’, NULL, ‘UI’),
(1733, 1540, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1734, 1541, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1735, 1542, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1736, 1542, ‘cf’, ‘1’, NULL, ‘UI’),
(1737, 1543, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1738, 1544, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1739, 1545, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1740, 1546, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1741, 1553, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1742, 1553, ‘cf’, ‘1’, NULL, ‘Functional’),
(1743, 1554, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1744, 1555, ‘attr’, ‘priority_id’, ‘2’, ‘5’),
(1745, 1556, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1746, 1557, ‘attr’, ‘tracker_id’, ‘6’, ‘4’),
(1747, 1558, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1748, 1558, ‘attr’, ‘priority_id’, ‘2’, ‘1’),
(1749, 1559, ‘attr’, ‘assigned_to_id’, ‘3’, ‘5’),
(1750, 1559, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(1751, 1560, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1752, 1561, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1753, 1562, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1754, 1562, ‘cf’, ‘1’, NULL, ‘Dev Rules’),
(1755, 1564, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1756, 1564, ‘cf’, ‘1’, NULL, ‘Dev Rules’),
(1757, 1565, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1758, 1565, ‘attr’, ‘assigned_to_id’, ‘10’, ‘7’),
(1759, 1566, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1760, 1567, ‘attr’, ‘assigned_to_id’, ‘19’, ‘10’),
(1761, 1568, ‘attr’, ‘parent_id’, NULL, ‘221’),
(1762, 1569, ‘attr’, ‘assigned_to_id’, ‘10’, ‘3’),
(1763, 1570, ‘attr’, ‘assigned_to_id’, ‘19’, ‘3’),
(1764, 1570, ‘attr’, ‘parent_id’, NULL, ‘221’),
(1765, 1571, ‘attr’, ‘parent_id’, NULL, ‘221’),
(1766, 1572, ‘attr’, ‘assigned_to_id’, ‘19’, ‘3’),
(1767, 1573, ‘attr’, ‘status_id’, ‘10’, ‘5’),
(1768, 1574, ‘attr’, ‘status_id’, ‘10’, ‘5’),
(1769, 1575, ‘attr’, ‘assigned_to_id’, ‘19’, ‘3’),
(1770, 1575, ‘attr’, ‘parent_id’, NULL, ‘221’),
(1771, 1576, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1772, 1577, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1773, 1578, ‘attr’, ‘status_id’, ‘11’, ‘5’),
(1774, 1579, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1775, 1580, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1776, 1580, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1777, 1581, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1778, 1581, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1779, 1582, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1780, 1583, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1781, 1584, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1782, 1585, ‘attr’, ‘subject’, ‘设计说明书中描述的业务问题(三)’, ‘设计说明书中描述的业务不明确’),
(1783, 1586, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1784, 1586, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(1785, 1587, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1786, 1587, ‘attr’, ‘assigned_to_id’, ‘3’, ‘10’),
(1787, 1588, ‘attr’, ‘assigned_to_id’, ‘3’, ‘19’),
(1788, 1588, ‘attr’, ‘priority_id’, ‘2’, ‘3’),
(1789, 1589, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1790, 1590, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1791, 1591, ‘attr’, ‘status_id’, ‘11’, ‘8’),
(1792, 1591, ‘attr’, ‘assigned_to_id’, ‘3’, ‘10’),
(1793, 1592, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1794, 1592, ‘attr’, ‘assigned_to_id’, ‘3’, ‘10’),
(1795, 1593, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1796, 1594, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1797, 1595, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1798, 1596, ‘attr’, ‘status_id’, ‘2’, ‘3’),
(1799, 1597, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1800, 1598, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1801, 1599, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1802, 1600, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1803, 1601, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1804, 1602, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1805, 1603, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1806, 1604, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1807, 1605, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1808, 1606, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1809, 1607, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1810, 1608, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1811, 1609, ‘attr’, ‘assigned_to_id’, ‘3’, ‘11’),
(1812, 1610, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1813, 1610, ‘cf’, ‘1’, NULL, ‘Functional’),
(1814, 1611, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1815, 1611, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1816, 1612, ‘attr’, ‘assigned_to_id’, ‘10’, ‘7’),
(1817, 1613, ‘attr’, ‘assigned_to_id’, ‘10’, ‘7’),
(1818, 1614, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1819, 1614, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1820, 1615, ‘attr’, ‘assigned_to_id’, ‘10’, ‘7’),
(1821, 1616, ‘attr’, ‘assigned_to_id’, ‘10’, ‘7’),
(1822, 1617, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1823, 1617, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1824, 1618, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1825, 1618, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1826, 1619, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1827, 1619, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1828, 1620, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1829, 1620, ‘attr’, ‘done_ratio’, ‘0’, ‘100’),
(1830, 1621, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1831, 1622, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1832, 1623, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1833, 1624, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1834, 1625, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1835, 1626, ‘attr’, ‘assigned_to_id’, ‘11’, ‘14’),
(1836, 1626, ‘cf’, ‘1’, NULL, ‘Functional’),
(1837, 1627, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1838, 1627, ‘cf’, ‘1’, NULL, ‘Functional’),
(1839, 1628, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1840, 1629, ‘attr’, ‘status_id’, ‘2’, ‘16’),
(1841, 1630, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1842, 1630, ‘cf’, ‘1’, NULL, ‘UI’),
(1843, 1632, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1844, 1632, ‘cf’, ‘1’, NULL, ‘Functional’),
(1845, 1633, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1846, 1633, ‘cf’, ‘1’, NULL, ‘UI’),
(1847, 1634, ‘attr’, ‘status_id’, ‘6’, ‘16’),
(1848, 1634, ‘cf’, ‘1’, NULL, ‘Functional’),
(1849, 1635, ‘attr’, ‘status_id’, ‘16’, ‘1’),
(1850, 1636, ‘attr’, ‘status_id’, ‘1’, ‘2’),
(1851, 1637, ‘attr’, ‘status_id’, ‘2’, ‘4’),
(1852, 1638, ‘attr’, ‘status_id’, ‘4’, ‘5’),
(1853, 1639, ‘attr’, ‘assigned_to_id’, ‘11’, ‘3’),
(1854, 1639, ‘cf’, ‘1’, NULL, ‘Functional’),
(1855, 1640, ‘attr’, ‘assigned_to_id’, ‘11’, ‘3’),
(1856, 1640, ‘cf’, ‘1’, NULL, ‘Functional’),
(1857, 1641, ‘attr’, ‘assigned_to_id’, ‘11’, ‘3’),
(1858, 1641, ‘cf’, ‘1’, NULL, ‘Functional’),
(1859, 1642, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1860, 1642, ‘cf’, ‘1’, NULL, ‘Functional’),
(1861, 1643, ‘attr’, ‘assigned_to_id’, ‘11’, ‘7’),
(1862, 1643, ‘cf’, ‘1’, NULL, ‘UI’),
(1863, 1644, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1864, 1644, ‘cf’, ‘1’, NULL, ‘Functional’),
(1865, 1645, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1866, 1645, ‘cf’, ‘1’, NULL, ‘UI’),
(1867, 1646, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1868, 1646, ‘cf’, ‘1’, NULL, ‘UI’),
(1869, 1647, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1870, 1647, ‘cf’, ‘1’, NULL, ‘UI’),
(1871, 1648, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1872, 1648, ‘cf’, ‘1’, NULL, ‘Other’),
(1873, 1649, ‘attr’, ‘status_id’, ‘3’, ‘5’),
(1874, 1649, ‘cf’, ‘1’, NULL, ‘Other’);
–
– Table structure for table members
CREATE TABLE IF NOT EXISTS members
(
id
int(11) NOT NULL,
user_id
int(11) NOT NULL DEFAULT ‘0’,
project_id
int(11) NOT NULL DEFAULT ‘0’,
created_on
datetime DEFAULT NULL,
mail_notification
tinyint(1) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
–
– Truncate table before insert members
TRUNCATE TABLE members
;
– Dumping data for table members
INSERT INTO members
(id
, user_id
, project_id
, created_on
, mail_notification
) VALUES
(1, 6, 1, ‘2015-06-25 12:56:57’, 0),
(2, 5, 1, ‘2015-06-25 12:56:57’, 0),
(3, 3, 1, ‘2015-06-25 12:57:02’, 0),
(4, 7, 1, ‘2015-06-25 13:16:25’, 0),
(5, 8, 1, ‘2015-06-25 13:16:25’, 0),
(6, 10, 1, ‘2015-06-25 13:24:16’, 0),
(7, 9, 1, ‘2015-06-25 13:24:16’, 0),
(8, 11, 1, ‘2015-06-25 13:26:51’, 0),
(9, 12, 1, ‘2015-06-25 13:26:51’, 0),
(10, 13, 1, ‘2015-06-25 13:45:36’, 0),
(11, 14, 1, ‘2015-06-25 19:45:29’, 0),
(12, 15, 1, ‘2015-06-25 19:45:29’, 0),
(13, 16, 1, ‘2015-06-25 19:45:29’, 0),
(14, 17, 1, ‘2015-06-26 10:19:40’, 0),
(15, 18, 1, ‘2015-06-29 14:49:46’, 0),
(16, 19, 1, ‘2015-06-29 14:54:13’, 0),
(17, 20, 1, ‘2015-06-29 14:56:30’, 0),
(18, 21, 1, ‘2015-06-30 10:19:04’, 0),
(27, 29, 1, ‘2015-07-03 10:31:30’, 0),
(28, 23, 1, ‘2015-07-03 10:31:30’, 0),
(29, 24, 1, ‘2015-07-03 10:31:30’, 0),
(30, 25, 1, ‘2015-07-03 10:31:30’, 0),
(31, 26, 1, ‘2015-07-03 10:31:30’, 0),
(32, 27, 1, ‘2015-07-03 10:31:30’, 0),
(33, 28, 1, ‘2015-07-03 10:31:30’, 0);
–
– Table structure for table member_roles
CREATE TABLE IF NOT EXISTS member_roles
(
id
int(11) NOT NULL,
member_id
int(11) NOT NULL,
role_id
int(11) NOT NULL,
inherited_from
int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
–
– Truncate table before insert member_roles
TRUNCATE TABLE member_roles
;
– Dumping data for table member_roles
INSERT INTO member_roles
(id
, member_id
, role_id
, inherited_from
) VALUES
(1, 1, 4, NULL),
(2, 2, 4, NULL),
(3, 3, 3, NULL),
(4, 3, 4, NULL),
(5, 4, 4, NULL),
(6, 5, 4, NULL),
(7, 6, 4, NULL),
(8, 7, 4, NULL),
(9, 8, 4, NULL),
(10, 9, 4, NULL),
(11, 10, 4, NULL),
(12, 11, 4, NULL),
(13, 12, 4, NULL),
(14, 13, 4, NULL),
(15, 14, 4, NULL),
(16, 15, 3, NULL),
(17, 15, 4, NULL),
(18, 16, 3, NULL),
(19, 16, 4, NULL),
(20, 5, 3, NULL),
(21, 11, 3, NULL),
(22, 17, 4, NULL),
(23, 18, 4, NULL),
(38, 27, 4, NULL),
(39, 28, 4, 38),
(40, 29, 4, 38),
(41, 30, 4, 38),
(42, 31, 4, 38),
(43, 32, 4, 38),
(44, 33, 4, 38);
–
– Table structure for table messages
CREATE TABLE IF NOT EXISTS messages
(
id
int(11) NOT NULL,
board_id
int(11) NOT NULL,
parent_id
int(11) DEFAULT NULL,
subject
varchar(255) NOT NULL DEFAULT ”,
content
text,
author_id
int(11) DEFAULT NULL,
replies_count
int(11) NOT NULL DEFAULT ‘0’,
last_reply_id
int(11) DEFAULT NULL,
created_on
datetime NOT NULL,
updated_on
datetime NOT NULL,
locked
tinyint(1) DEFAULT ‘0’,
sticky
int(11) DEFAULT ‘0’
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
–
– Truncate table before insert messages
TRUNCATE TABLE messages
;
– Dumping data for table messages
INSERT INTO messages
(id
, board_id
, parent_id
, subject
, content
, author_id
, replies_count
, last_reply_id
, created_on
, updated_on
, locked
, sticky
) VALUES
(5, 3, NULL, ‘[06/26]会议记录’, ‘1.form size相关\r\n韩方已经给出了标准的form大小(1070*250),请在这个大小下进行开发.\r\n\r\n2.命名相关\r\n再次强调了开发时要遵守Dataset和query ID的命名规范.\r\n(韩方发现ds+字段名字等不规范形式的命名较多)\r\n\r\n1)dataset命名\r\n-Tpg(tabPage)的缩写要改成Tab\r\n-类似dsPROD_APPL_YN的下拉框性dataset是dsCombo \r\n-名字重复的情况去掉1\r\n ex)dsName, dsName2, dsName3\r\n \r\n2)query命名\r\n-页面名字.要有(insert,select,update,delete),save改为insert\r\n-页面名字.select重复时末尾加2位数字加以区分,但第一个要去掉01\r\n ex) PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER,\r\n PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER_02, \r\n PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER_03\r\n(请参照\DOC\04.Test\customer\TIPS_개발검수_LIST_150626.xlsx的编号为7,8的内容)\r\n\r\n3.共同部分(重点)\r\n1) BSP 用户查询(社内发明者添加或 发明者信息中add row时) popup : STW_USER_SEARCH.xfdl\r\n2) BSP 用户查询(社外发明者) popup : VIST_VISR_SEARCH_01.xfdl \r\n3) 页面字段排列 : left排列\r\n4) 共同邮件POPUP : CommEpMailPopup\r\n5) 共同审批 POPUP : CommEpApprovalCustomPopup\r\n6) 共同附件 : CommMultiFileUploadPopup\r\n7) 邮件附件查询:\r\n ->附件查询逻辑是: 在SINGLE_MAIL.MAIL_FILE_ID和FILE_ATTACH_ITEM.FILE_ID 两个字段行join后查询.\r\n 对于附件信息,目前只获取附件名(FILE_NM)和附件路径(FILE PATH)即可.\r\n’, 19, 0, NULL, ‘2015-06-30 14:54:51’, ‘2015-06-30 14:54:51’, 0, 0),
(6, 3, NULL, ‘[06/29]会议记录’, ‘1.日期相关\r\n->页面中有输入日期的部分使用都Calendar.(不是手动输入的text)\r\n\r\n2.阶段详细别页面\r\n->左侧上端标题出现错别字\r\n ex)PM_05, PM_08\r\n 还是存在按钮位置,Gird Layout问题.(还是强调页面布局问题)\r\n\r\n3.页面中存在的Mail Form相关\r\n- mail form的定义:\r\n->所有的样式都是从文档样式共同Form中获取.\r\n Binding Data由相关Master gird中获取.\r\n 比如右上侧(ex.阶段结束)按钮点击时不是弹出共同邮件popup,而是后台直接保存到Mail表中(参考下面的第二条Java Mail发送)\r\n 文档样式查看: BSP > 시스템 관리 > 기준정보 > 문서양식관리 (目前该菜单只有我和张延都D能访问)\r\n 1)System: BSP, server:BSP, 样式ID:TIPS_MAIL\r\n -> 阶段详细别相关form在以后程序说明中会有相关定义.\r\n 2)Java Mail发送(参考wiki)\r\n -> http://55.101.200.107:9999/sector9/doku.php?id=java:%EB%A9%94%EC%9D%BC%EB%B3%B4%EB%82%B4%EA%B8%B0&s[]=mail\r\n’, 19, 0, NULL, ‘2015-06-30 14:55:21’, ‘2015-06-30 14:55:21’, 0, 0),
(7, 3, NULL, ‘[06/30]会议记录’, ‘1.transaction 命名相关\r\n类似selectMain, saveMain等 transaction ID的命名需要规范\r\n(目前被定义为selectMain, saveMain, saveDsMGrid等等)\r\nID Rule : [Prefix] + [Dataset ID or Grid Id or Process Name]\r\nDataset 查询 Transaction \r\nTransaction ID : selectGridMessage ( = selectDsMessage)Dataset 保存 Transaction\r\nTransaction ID : saveGrdMain ( = saveDsMain)Multi Dataset 查询 Transaction\r\n// 用户信息查询 Dataset List 查询\r\nTransaction ID : getUserInfoDSMulti Dataset 저장 Transaction\r\n// 用户信息保存\r\nTransaction ID : saveUserInfoDS\r\n(上述内容在TIPS_개발검수_LIST_150629.xlsx中的编号为21的内容)\r\n’, 19, 1, 8, ‘2015-06-30 14:55:54’, ‘2015-06-30 14:55:54’, 0, 0),
(8, 3, 7, ‘RE: [06/30]会议记录’, ‘已经更新到开发人员CheckList中。’, 3, 0, NULL, ‘2015-06-30 14:59:48’, ‘2015-06-30 14:59:48’, 0, 0),
(9, 4, NULL, ‘常见的错误列表’, ‘•1. 保存前的校验调用公共方法,需要自己配置相关字段。\r\n•2. 页面数据填写了但未保存,页面移动前需要Confirm。[代码及提示消息可参考MP_04]\r\n•3. 必填项的 * 用红色标示\r\n•4. Tab下方有蓝线,随页面大小变化会调整[参考PM_01]\r\n•5. 画布大小全部统一,1070*250\r\n•6. Grid行高全部统一:Header22,Row20\r\n•7. 查询用的字段需要校验【根据说明书指示】\r\n•8. QueryID规则再次明确: 对主表的多个查询,第一个ID不用加后缀,从第二个ID开始,用_02,_03等结尾。\r\n•9. Grid中有日期输入类型的,需要限制只能输入8位数字,且保存前需要校验日期正确性。\r\n•10.Grid中有数字输入类型的,限制只能输入数字,长度与数据库一致。\r\n•11.再次确认自己Grid中对齐方式是否正确。\r\n•12.再次强调控件命名规则不规范:\r\ndataset的命名规则\r\n-Tpg(tabPage)的缩写要改成Tab\r\n-类似dsPROD_APPL_YN的下拉框性dataset是dsCombo \r\n-名字重复的情况去掉1/dsName, dsName2, dsName3\r\n•13. QueryID命名仍然不规范\r\nquery命名规则\r\n-页面名字.要有(insert,select,update,delete),save改为insert\r\n-页面名字.select重复时末尾加2位数字加以区分,但第一个要去掉01\r\n ->PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER, PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER_02, PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER_03\r\n\r\n•14.如果开发中发现以下公司名时需要更改.\r\nUI Script 内 Copyright 部分 \r\n
\r\n: Samsung Techwin -> Hanwha Techwin\r\n\r\n
\r\nex) Copyright ⓒ 2015 Samsung Techwin Co., Ltd. All Rights Reserved| Confidential -> Copyright ⓒ 2015 Hanwha Techwin Co., Ltd. All Rights Reserved| Confidential\r\n\r\n\r\n•15.transaction 命名相关\r\n类似selectMain, saveMain等 transaction ID的命名需要规范\r\n(目前被定义为selectMain, saveMain, saveDsMGrid等等)\r\nID Rule : [Prefix] + [Dataset ID or Grid Id or Process Name]\r\nDataset 查询 Transaction \r\nTransaction ID : selectGridMessage ( = selectDsMessage)Dataset 保存 Transaction\r\nTransaction ID : saveGrdMain ( = saveDsMain)Multi Dataset 查询 Transaction\r\n// 用户信息查询 Dataset List 查询\r\nTransaction ID : getUserInfoDSMulti Dataset 저장 Transaction\r\n// 用户信息保存\r\nTransaction ID : saveUserInfoDS \r\n\r\n•16.页面设置\r\nUX Studio - Options - Environment - Project Explorer - FDL PARSING设置为All,\r\n把Show title设置为at Project Explorer时可设置文件名旁边添加页面名称.\r\n请在每个页面的Properties中的titletext设置为程序说明书的程序名\r\n
\r\n20150630 updated\r\n‘, 18, 0, NULL, ‘2015-06-30 15:04:17’, ‘2015-06-30 15:05:06’, 0, 1),
(10, 3, NULL, ‘[07/01]会议记录’, ‘1.附件下载相关\r\n-附件下载参考既存系统的代码及wiki\r\nwiki: 3.1.11.첨부파일/엑셀\r\n\r\n2.Namo编辑器问题\r\n-共同审批窗口/邮件窗口文本内容出现无法编辑\r\n->经确认发现,这个问题是Namo编辑器没有在本地正确安装导致的问题.\r\n打开以下链接下载Namo web editor并重新安装namo\r\nhttp://55.101.200.107:8082/bsp/Install/x_installAX_manual.html\r\n\r\n3.Gird上的字段相关\r\n-Gird上的字段都要完全显示出来,不要遮盖,不要两行显示(PM_12).\r\n如果grid上字段很多时可以用横向的滚动条.’, 19, 0, NULL, ‘2015-07-01 10:22:08’, ‘2015-07-01 10:42:21’, 0, 0),
(12, 3, NULL, ‘[07/02]会议记录’, ‘1.关于页面中数据是Insert OR Update问题\r\n->原则上有表的PK只有一个时是Update,否则insert(但不是绝对的哦)\r\n一般适用于발명마스터, SR진행, 발명자의견, 특허출원, 국내/해외초안, 국내/해외OA, 특허등록等对流程有影响的表.\r\n\r\n2.关于韩国用GDC的redmine的建议\r\n->提出建议后韩国愿意使用我们的redmine,但韩国对redmine不太熟悉,我们需要提供一些资料.\r\n\r\n3.关于阶段详细内Mail,附件Form\r\n->韩国目前重新设计Mail,附件保存的逻辑.因此我们暂时保留保存的功能.\r\nGDC目前只做到Mail Form样式查询显示就可以,如何保存暂时保留.\r\n\r\n\r\n\r\n’, 19, 0, NULL, ‘2015-07-02 09:56:37’, ‘2015-07-02 10:00:15’, 0, 0),
(13, 3, NULL, ‘[07/03]会议记录’, ‘1.关于韩国使用redmine问题\r\n-需要区分韩国和GDC之间的Code或分类.\r\n-redmine要有Excel下载功能\r\n-redmine中添加成员\r\n-申请防火墙\r\n\r\n’, 19, 0, NULL, ‘2015-07-03 10:00:54’, ‘2015-07-03 10:00:54’, 0, 0),
(15, 4, NULL, ‘PM画面统计’, ‘PM_01_INVENT_ACCEPT_LIST <=====> MA_01_APPLY_MASTER_LIST.xfdl\r\nPM_02_INVENT_CONSULT_LIST <=====> MA_01_APPLY_MASTER_LIST.xfdl\r\nPM_03_SR_PROGRESS_LIST <=====> MA_01_APPLY_MASTER_LIST.xfdl\r\nPM_04_KR_APPLY_REVIEW_LIST <=====> MA_01_APPLY_MASTER_LIST.xfdl\r\nPM_05_KR_DRAFT_PROGRESS_LIST <=====> MA_01_APPLY_MASTER_LIST.xfdl\r\nPM_06_FR_DRAFT_PROGRESS_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_07_FR_DRAFT_REVIEW_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_08_KR_APPLY_COMP_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_09_KR_APPLY_COMP_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_10_KR_OA_ACT_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_11_KR_OA_ACT_COMP_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_12_KR_REG_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_13_KR_END_LIST <=====> MA_02_KR_REGIST_MASTER_LIST.xfdl\r\nPM_16_FR_OA_ACT_COMP_LIST <=====> MA_03_FR_REGIST_MASTER_LIST.xfdl\r\nPM_17_FR_REG_LIST <=====> MA_03_FR_REGIST_MASTER_LIST.xfdl\r\nPM_18_FR_END_LIST <=====> MA_03_FR_REGIST_MASTER_LIST.xfdl’, 17, 0, NULL, ‘2015-07-03 10:49:48’, ‘2015-07-03 10:49:48’, 0, 0);
–
– Table structure for table news
CREATE TABLE IF NOT EXISTS news
(
id
int(11) NOT NULL,
project_id
int(11) DEFAULT NULL,
title
varchar(60) NOT NULL DEFAULT ”,
summary
varchar(255) DEFAULT ”,
description
text,
author_id
int(11) NOT NULL DEFAULT ‘0’,
created_on
datetime DEFAULT NULL,
comments_count
int(11) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
–
– Truncate table before insert news
TRUNCATE TABLE news
;
– Dumping data for table news
INSERT INTO news
(id
, project_id
, title
, summary
, description
, author_id
, created_on
, comments_count
) VALUES
(1, 1, ‘Redmine start to use.’, ”, ‘pls write down issues, questions here.’, 3, ‘2015-06-25 13:50:50’, 0),
(2, 1, ‘Dev updated function[common]’, ”, ‘* 1. 保存前的校验调用公共方法,需要自己配置相关字段。\r\n* 2. 页面数据填写了但未保存,页面移动前需要Confirm。[代码及提示消息可参考MP_04]\r\n* 3. 必填项的 * 用红色标示\r\n* 4. Tab下方有蓝线,随页面大小变化会调整[参考PM_01]\r\n* 5. 画布大小全部统一,1070*250\r\n* 6. Grid行高全部统一:Header22,Row20\r\n* 7. 查询用的字段需要校验【根据说明书指示】\r\n* 8. QueryID规则再次明确: 对主表的多个查询,第一个ID不用加后缀,从第二个ID开始,用_02,_03等结尾。\r\n* 9. Grid中有日期输入类型的,需要限制只能输入8位数字,且保存前需要校验日期正确性。\r\n* 10.Grid中有数字输入类型的,限制只能输入数字,长度与数据库一致。\r\n* 11.再次确认自己Grid中对齐方式是否正确。\r\n* 12.再次强调控件命名规则不规范:\r\n dataset的命名规则\r\n-Tpg(tabPage)的缩写要改成Tab\r\n-类似dsPROD_APPL_YN的下拉框性dataset是dsCombo \r\n-名字重复的情况去掉1/dsName, dsName2, dsName3\r\n* 13. QueryID命名仍然不规范\r\nquery命名规则\r\n-页面名字.要有(insert,select,update,delete),save改为insert\r\n-页面名字.select重复时末尾加2位数字加以区分,但第一个要去掉01\r\n ->PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER, PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER_02, PM_01_INVENT_ACCEPT_LIST.selectTIPS_INVENT_MASTER_03\r\n\r\n* 14.如果开发中发现以下公司名时需要更改.\r\n\r\nUI Script 内 Copyright 部分 \r\n\r\n : Samsung Techwin -> Hanwha Techwin\r\n\r\n ex) Copyright ⓒ 2015 Samsung Techwin Co., Ltd. All Rights Reserved| Confidential -> Copyright ⓒ 2015 Hanwha Techwin Co., Ltd. All Rights Reserved| Confidential\r\n\r\n* 15.transaction 命名相关\r\n\r\n类似selectMain, saveMain等 transaction ID的命名需要规范\r\n\r\n(目前被定义为selectMain, saveMain, saveDsMGrid等等)\r\nID Rule : [Prefix] + [Dataset ID or Grid Id or Process Name]\r\nDataset 查询 Transaction \r\nTransaction ID : selectGridMessage ( = selectDsMessage)Dataset 保存 Transaction\r\nTransaction ID : saveGrdMain ( = saveDsMain)Multi Dataset 查询 Transaction\r\n// 用户信息查询 Dataset List 查询\r\nTransaction ID : getUserInfoDSMulti Dataset 저장 Transaction\r\n// 用户信息保存\r\nTransaction ID : saveUserInfoDS\r\n\r\n 20150630 updated\r\n* 16.页面设置\r\nUX Studio - Options - Environment - Project Explorer - FDL PARSING设置为All,\r\n把Show title设置为at Project Explorer时可设置文件名旁边添加页面名称.\r\n请在每个页面的Properties中的titletext设置为程序说明书的程序名’, 3, ‘2015-06-25 19:54:37’, 2),
(4, 1, ‘Cross Test Namelist’, ”, ‘* 张延都[yd1.zhang] <—> 张毅[yi.zhang]\r\n\r\n* 姚璐[lu1.yao] <—> 李苗[miao3.li]\r\n\r\n* 巩世海[shihai.gong] <—> 张关波[guanbo.zhang]\r\n\r\n* 是灏亮[hl.shi] <—> 王亮[liang3.wang]\r\n\r\n* 徐佳晶[jiajing.xu] <—> 史文博[wenbo1.shi]\r\n\r\n* 高崇虎[chonghu.gao] <—> 鞠慧明[hm1.ju]\r\n\r\n* 杨维平[weiping.yang] <—> 韩磊\r\n\r\n\r\n\r\n’, 3, ‘2015-06-30 10:00:24’, 0),
(5, 1, ‘共同审批/邮件popup文本内容无法编辑问题’, ‘共同审批/邮件popup文本内容无法编辑问题’, ‘如果开发中发现共同审批窗口或邮件窗口中无法编辑文本内容时,请参照以下内容:\r\n\r\n经确认发现,这个问题是Namo编辑器没有在本地正确安装导致的问题.\r\n打开以下链接下载Namo web editor并重新安装namo即可.\r\nhttp://55.101.200.107:8082/bsp/Install/x_installAX_manual.html’, 19, ‘2015-07-01 10:25:53’, 0);
–
– Table structure for table open_id_authentication_associations
CREATE TABLE IF NOT EXISTS open_id_authentication_associations
(
id
int(11) NOT NULL,
issued
int(11) DEFAULT NULL,
lifetime
int(11) DEFAULT NULL,
handle
varchar(255) DEFAULT NULL,
assoc_type
varchar(255) DEFAULT NULL,
server_url
blob,
secret
blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert open_id_authentication_associations
TRUNCATE TABLE open_id_authentication_associations
;
–
– Table structure for table open_id_authentication_nonces
CREATE TABLE IF NOT EXISTS open_id_authentication_nonces
(
id
int(11) NOT NULL,
timestamp
int(11) NOT NULL,
server_url
varchar(255) DEFAULT NULL,
salt
varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert open_id_authentication_nonces
TRUNCATE TABLE open_id_authentication_nonces
;
–
– Table structure for table projects
CREATE TABLE IF NOT EXISTS projects
(
id
int(11) NOT NULL,
name
varchar(255) NOT NULL DEFAULT ”,
description
text,
homepage
varchar(255) DEFAULT ”,
is_public
tinyint(1) NOT NULL DEFAULT ‘1’,
parent_id
int(11) DEFAULT NULL,
created_on
datetime DEFAULT NULL,
updated_on
datetime DEFAULT NULL,
identifier
varchar(255) DEFAULT NULL,
status
int(11) NOT NULL DEFAULT ‘1’,
lft
int(11) DEFAULT NULL,
rgt
int(11) DEFAULT NULL,
inherit_members
tinyint(1) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
–
– Truncate table before insert projects
TRUNCATE TABLE projects
;
– Dumping data for table projects
INSERT INTO projects
(id
, name
, description
, homepage
, is_public
, parent_id
, created_on
, updated_on
, identifier
, status
, lft
, rgt
, inherit_members
) VALUES
(1, ‘TechWin_BSP_TIPS’, ”, ”, 1, NULL, ‘2015-06-25 12:55:59’, ‘2015-06-25 12:55:59’, ‘techwin_bsp_tips’, 1, 1, 2, 0);
–
– Table structure for table projects_trackers
CREATE TABLE IF NOT EXISTS projects_trackers
(
project_id
int(11) NOT NULL DEFAULT ‘0’,
tracker_id
int(11) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert projects_trackers
TRUNCATE TABLE projects_trackers
;
– Dumping data for table projects_trackers
INSERT INTO projects_trackers
(project_id
, tracker_id
) VALUES
(1, 1),
(1, 4),
(1, 5),
(1, 6);
–
– Table structure for table queries
CREATE TABLE IF NOT EXISTS queries
(
id
int(11) NOT NULL,
project_id
int(11) DEFAULT NULL,
name
varchar(255) NOT NULL DEFAULT ”,
filters
text,
user_id
int(11) NOT NULL DEFAULT ‘0’,
column_names
text,
sort_criteria
text,
group_by
varchar(255) DEFAULT NULL,
type
varchar(255) DEFAULT NULL,
visibility
int(11) DEFAULT ‘0’,
options
text
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
–
– Truncate table before insert queries
TRUNCATE TABLE queries
;
– Dumping data for table queries
INSERT INTO queries
(id
, project_id
, name
, filters
, user_id
, column_names
, sort_criteria
, group_by
, type
, visibility
, options
) VALUES
(1, 1, ‘0626’, ‘—\nstatus_id:\n :operator: o\n :values:\n - ””\nassigned_to_id:\n :operator: =\n :values:\n - me\n’, 6, NULL, NULL, ”, ‘IssueQuery’, 0, ‘—\n:draw_relations: \n:draw_progress_line: \n’),
(2, 1, ‘Defect View’, ‘—\nstatus_id:\n :operator: o\n :values:\n - ””\ntracker_id:\n :operator: =\n :values:\n - ”1”\n’, 18, NULL, ‘—\n- - assigned_to\n - asc\n’, ‘status’, ‘IssueQuery’, 0, ‘—\n:draw_relations: \n:draw_progress_line: \n’),
(4, 1, ‘Korea View’, ‘—\nstatus_id:\n :operator: ”!”\n :values:\n - ”5”\nauthor_id:\n :operator: =\n :values:\n - ”26”\n - ”23”\n - ”27”\n - ”24”\n - ”28”\n - ”25”\n’, 18, NULL, ‘—\n- - priority\n - asc\n’, ‘status’, ‘IssueQuery’, 2, ‘—\n:draw_relations: \n:draw_progress_line: \n’),
(5, 1, ‘UnFinished Defect’, ‘—\nstatus_id:\n :operator: =\n :values:\n - ”1”\n - ”2”\ntracker_id:\n :operator: =\n :values:\n - ”1”\n’, 3, NULL, NULL, ‘assigned_to’, ‘IssueQuery’, 0, ‘—\n:draw_relations: \n:draw_progress_line: \n’),
(6, 1, ‘User story View’, ‘—\nstatus_id:\n :operator: o\n :values:\n - ””\ntracker_id:\n :operator: =\n :values:\n - ”5”\n’, 18, ‘—\n- :tracker\n- :status\n- :priority\n- :subject\n- :assigned_to\n- :done_ratio\n’, ‘—\n- - subject\n - asc\n’, ‘status’, ‘IssueQuery’, 0, ‘—\n:draw_relations: \n:draw_progress_line: \n’),
(7, 1, ‘Q&A View’, ‘—\nstatus_id:\n :operator: o\n :values:\n - ””\ntracker_id:\n :operator: =\n :values:\n - ”6”\n’, 18, ‘—\n- :tracker\n- :status\n- :subject\n- :assigned_to\n- :done_ratio\n’, ‘—\n- - project\n - asc\n’, ‘status’, ‘IssueQuery’, 0, ‘—\n:draw_relations: \n:draw_progress_line: \n’);
–
– Table structure for table queries_roles
CREATE TABLE IF NOT EXISTS queries_roles
(
query_id
int(11) NOT NULL,
role_id
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert queries_roles
TRUNCATE TABLE queries_roles
;
–
– Table structure for table repositories
CREATE TABLE IF NOT EXISTS repositories
(
id
int(11) NOT NULL,
project_id
int(11) NOT NULL DEFAULT ‘0’,
url
varchar(255) NOT NULL DEFAULT ”,
login
varchar(60) DEFAULT ”,
password
varchar(255) DEFAULT ”,
root_url
varchar(255) DEFAULT ”,
type
varchar(255) DEFAULT NULL,
path_encoding
varchar(64) DEFAULT NULL,
log_encoding
varchar(64) DEFAULT NULL,
extra_info
text,
identifier
varchar(255) DEFAULT NULL,
is_default
tinyint(1) DEFAULT ‘0’,
created_on
datetime DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
–
– Truncate table before insert repositories
TRUNCATE TABLE repositories
;
– Dumping data for table repositories
INSERT INTO repositories
(id
, project_id
, url
, login
, password
, root_url
, type
, path_encoding
, log_encoding
, extra_info
, identifier
, is_default
, created_on
) VALUES
(1, 1, ‘https://109.52.63.91/svn/TechWin_BSP/STW%20BSP%20TIPS/SRC‘, ‘zy1.wang’, ‘zy1.wang’, ”, ‘Repository::Subversion’, NULL, NULL, NULL, ”, 1, ‘2015-07-03 15:25:01’);
–
– Table structure for table roles
CREATE TABLE IF NOT EXISTS roles
(
id
int(11) NOT NULL,
name
varchar(30) NOT NULL DEFAULT ”,
position
int(11) DEFAULT ‘1’,
assignable
tinyint(1) DEFAULT ‘1’,
builtin
int(11) NOT NULL DEFAULT ‘0’,
permissions
text,
issues_visibility
varchar(30) NOT NULL DEFAULT ‘default’,
users_visibility
varchar(30) NOT NULL DEFAULT ‘all’
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
–
– Truncate table before insert roles
TRUNCATE TABLE roles
;
– Dumping data for table roles
INSERT INTO roles
(id
, name
, position
, assignable
, builtin
, permissions
, issues_visibility
, users_visibility
) VALUES
(1, ‘Non member’, 1, 1, 1, ‘—\n- :view_issues\n- :add_issues\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :add_messages\n- :view_files\n- :browse_repository\n- :view_changesets\n’, ‘default’, ‘all’),
(2, ‘Anonymous’, 2, 1, 2, ‘—\n- :view_issues\n- :view_gantt\n- :view_calendar\n- :view_time_entries\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :view_files\n- :browse_repository\n- :view_changesets\n’, ‘default’, ‘all’),
(3, ‘Manager’, 3, 1, 0, ‘—\n- :add_project\n- :edit_project\n- :close_project\n- :select_project_modules\n- :manage_members\n- :manage_versions\n- :add_subprojects\n- :manage_categories\n- :view_issues\n- :add_issues\n- :edit_issues\n- :copy_issues\n- :manage_issue_relations\n- :manage_subtasks\n- :set_issues_private\n- :set_own_issues_private\n- :add_issue_notes\n- :edit_issue_notes\n- :edit_own_issue_notes\n- :view_private_notes\n- :set_notes_private\n- :delete_issues\n- :manage_public_queries\n- :save_queries\n- :view_issue_watchers\n- :add_issue_watchers\n- :delete_issue_watchers\n- :log_time\n- :view_time_entries\n- :edit_time_entries\n- :edit_own_time_entries\n- :manage_project_activities\n- :manage_news\n- :comment_news\n- :add_documents\n- :edit_documents\n- :delete_documents\n- :view_documents\n- :manage_files\n- :view_files\n- :manage_wiki\n- :rename_wiki_pages\n- :delete_wiki_pages\n- :view_wiki_pages\n- :export_wiki_pages\n- :view_wiki_edits\n- :edit_wiki_pages\n- :delete_wiki_pages_attachments\n- :protect_wiki_pages\n- :manage_repository\n- :browse_repository\n- :view_changesets\n- :commit_access\n- :manage_related_issues\n- :manage_boards\n- :add_messages\n- :edit_messages\n- :edit_own_messages\n- :delete_messages\n- :delete_own_messages\n- :view_calendar\n- :view_gantt\n’, ‘all’, ‘all’),
(4, ‘Developer’, 4, 1, 0, ‘—\n- :manage_versions\n- :manage_categories\n- :view_issues\n- :add_issues\n- :edit_issues\n- :view_private_notes\n- :set_notes_private\n- :manage_issue_relations\n- :manage_subtasks\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :edit_wiki_pages\n- :delete_wiki_pages\n- :add_messages\n- :edit_own_messages\n- :view_files\n- :manage_files\n- :browse_repository\n- :view_changesets\n- :commit_access\n- :manage_related_issues\n’, ‘default’, ‘all’),
(5, ‘Reporter’, 5, 1, 0, ‘—\n- :view_issues\n- :add_issues\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :add_messages\n- :edit_own_messages\n- :view_files\n- :browse_repository\n- :view_changesets\n’, ‘default’, ‘all’);
–
– Table structure for table schema_migrations
CREATE TABLE IF NOT EXISTS schema_migrations
(
version
varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert schema_migrations
TRUNCATE TABLE schema_migrations
;
– Dumping data for table schema_migrations
INSERT INTO schema_migrations
(version
) VALUES
(‘1’),
(‘10’),
(‘100’),
(‘101’),
(‘102’),
(‘103’),
(‘104’),
(‘105’),
(‘106’),
(‘107’),
(‘108’),
(‘11’),
(‘12’),
(‘13’),
(‘14’),
(‘15’),
(‘16’),
(‘17’),
(‘18’),
(‘19’),
(‘2’),
(‘20’),
(‘20090214190337’),
(‘20090312172426’),
(‘20090312194159’),
(‘20090318181151’),
(‘20090323224724’),
(‘20090401221305’),
(‘20090401231134’),
(‘20090403001910’),
(‘20090406161854’),
(‘20090425161243’),
(‘20090503121501’),
(‘20090503121505’),
(‘20090503121510’),
(‘20090614091200’),
(‘20090704172350’),
(‘20090704172355’),
(‘20090704172358’),
(‘20091010093521’),
(‘20091017212227’),
(‘20091017212457’),
(‘20091017212644’),
(‘20091017212938’),
(‘20091017213027’),
(‘20091017213113’),
(‘20091017213151’),
(‘20091017213228’),
(‘20091017213257’),
(‘20091017213332’),
(‘20091017213444’),
(‘20091017213536’),
(‘20091017213642’),
(‘20091017213716’),
(‘20091017213757’),
(‘20091017213835’),
(‘20091017213910’),
(‘20091017214015’),
(‘20091017214107’),
(‘20091017214136’),
(‘20091017214236’),
(‘20091017214308’),
(‘20091017214336’),
(‘20091017214406’),
(‘20091017214440’),
(‘20091017214519’),
(‘20091017214611’),
(‘20091017214644’),
(‘20091017214720’),
(‘20091017214750’),
(‘20091025163651’),
(‘20091108092559’),
(‘20091114105931’),
(‘20091123212029’),
(‘20091205124427’),
(‘20091220183509’),
(‘20091220183727’),
(‘20091220184736’),
(‘20091225164732’),
(‘20091227112908’),
(‘20100129193402’),
(‘20100129193813’),
(‘20100221100219’),
(‘20100313132032’),
(‘20100313171051’),
(‘20100705164950’),
(‘20100819172912’),
(‘20101104182107’),
(‘20101107130441’),
(‘20101114115114’),
(‘20101114115359’),
(‘20110220160626’),
(‘20110223180944’),
(‘20110223180953’),
(‘20110224000000’),
(‘20110226120112’),
(‘20110226120132’),
(‘20110227125750’),
(‘20110228000000’),
(‘20110228000100’),
(‘20110401192910’),
(‘20110408103312’),
(‘20110412065600’),
(‘20110511000000’),
(‘20110902000000’),
(‘20111201201315’),
(‘20120115143024’),
(‘20120115143100’),
(‘20120115143126’),
(‘20120127174243’),
(‘20120205111326’),
(‘20120223110929’),
(‘20120301153455’),
(‘20120422150750’),
(‘20120705074331’),
(‘20120707064544’),
(‘20120714122000’),
(‘20120714122100’),
(‘20120714122200’),
(‘20120731164049’),
(‘20120930112914’),
(‘20121026002032’),
(‘20121026003537’),
(‘20121209123234’),
(‘20121209123358’),
(‘20121213084931’),
(‘20130110122628’),
(‘20130201184705’),
(‘20130202090625’),
(‘20130207175206’),
(‘20130207181455’),
(‘20130215073721’),
(‘20130215111127’),
(‘20130215111141’),
(‘20130217094251’),
(‘20130602092539’),
(‘20130710182539’),
(‘20130713104233’),
(‘20130713111657’),
(‘20130729070143’),
(‘20130911193200’),
(‘20131004113137’),
(‘20131005100610’),
(‘20131124175346’),
(‘20131210180802’),
(‘20131214094309’),
(‘20131215104612’),
(‘20131218183023’),
(‘20140228130325’),
(‘20140903143914’),
(‘20140920094058’),
(‘20141029181752’),
(‘20141029181824’),
(‘20141109112308’),
(‘20141122124142’),
(‘20150113194759’),
(‘20150113211532’),
(‘20150113213922’),
(‘20150113213955’),
(‘20150208105930’),
(‘21’),
(‘22’),
(‘23’),
(‘24’),
(‘25’),
(‘26’),
(‘27’),
(‘28’),
(‘29’),
(‘3’),
(‘30’),
(‘31’),
(‘32’),
(‘33’),
(‘34’),
(‘35’),
(‘36’),
(‘37’),
(‘38’),
(‘39’),
(‘4’),
(‘40’),
(‘41’),
(‘42’),
(‘43’),
(‘44’),
(‘45’),
(‘46’),
(‘47’),
(‘48’),
(‘49’),
(‘5’),
(‘50’),
(‘51’),
(‘52’),
(‘53’),
(‘54’),
(‘55’),
(‘56’),
(‘57’),
(‘58’),
(‘59’),
(‘6’),
(‘60’),
(‘61’),
(‘62’),
(‘63’),
(‘64’),
(‘65’),
(‘66’),
(‘67’),
(‘68’),
(‘69’),
(‘7’),
(‘70’),
(‘71’),
(‘72’),
(‘73’),
(‘74’),
(‘75’),
(‘76’),
(‘77’),
(‘78’),
(‘79’),
(‘8’),
(‘80’),
(‘81’),
(‘82’),
(‘83’),
(‘84’),
(‘85’),
(‘86’),
(‘87’),
(‘88’),
(‘89’),
(‘9’),
(‘90’),
(‘91’),
(‘92’),
(‘93’),
(‘94’),
(‘95’),
(‘96’),
(‘97’),
(‘98’),
(‘99’);
–
– Table structure for table settings
CREATE TABLE IF NOT EXISTS settings
(
id
int(11) NOT NULL,
name
varchar(255) NOT NULL DEFAULT ”,
value
text,
updated_on
datetime DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
–
– Truncate table before insert settings
TRUNCATE TABLE settings
;
– Dumping data for table settings
INSERT INTO settings
(id
, name
, value
, updated_on
) VALUES
(1, ‘mail_from’, ‘redmine@example.net’, ‘2015-06-25 11:27:59’),
(2, ‘bcc_recipients’, ‘1’, ‘2015-06-25 11:27:59’),
(3, ‘plain_text_mail’, ‘0’, ‘2015-06-25 11:27:59’),
(4, ‘default_notification_option’, ‘none’, ‘2015-06-25 11:27:59’),
(5, ‘notified_events’, ‘— []\n’, ‘2015-06-25 11:27:59’),
(6, ‘emails_header’, ”, ‘2015-06-25 11:27:59’),
(7, ‘emails_footer’, ‘You have received this notification because you have either subscribed to it, or are involved in it.\r\nTo change your notification preferences, please click here: http://hostname/my/account‘, ‘2015-06-25 11:27:59’),
(8, ‘login_required’, ‘1’, ‘2015-06-25 11:31:05’),
(9, ‘autologin’, ‘7’, ‘2015-06-25 11:28:42’),
(10, ‘self_registration’, ‘3’, ‘2015-06-25 11:33:26’),
(11, ‘unsubscribe’, ‘0’, ‘2015-06-25 11:33:26’),
(12, ‘password_min_length’, ‘5’, ‘2015-06-25 11:28:42’),
(13, ‘lost_password’, ‘1’, ‘2015-06-25 11:28:42’),
(14, ‘max_additional_emails’, ‘1’, ‘2015-06-25 11:28:42’),
(15, ‘openid’, ‘0’, ‘2015-06-25 11:28:42’),
(16, ‘rest_api_enabled’, ‘0’, ‘2015-06-25 11:28:42’),
(17, ‘jsonp_enabled’, ‘0’, ‘2015-06-25 11:28:42’),
(18, ‘session_lifetime’, ‘0’, ‘2015-06-25 11:28:42’),
(19, ‘session_timeout’, ‘0’, ‘2015-06-25 11:28:42’),
(20, ‘ui_theme’, ”, ‘2015-06-25 12:55:04’),
(21, ‘default_language’, ‘en’, ‘2015-06-25 12:55:04’),
(22, ‘force_default_language_for_anonymous’, ‘0’, ‘2015-06-25 12:55:04’),
(23, ‘force_default_language_for_loggedin’, ‘0’, ‘2015-06-25 12:55:04’),
(24, ‘start_of_week’, ”, ‘2015-06-25 12:55:04’),
(25, ‘date_format’, ”, ‘2015-06-25 12:55:04’),
(26, ‘time_format’, ”, ‘2015-06-25 12:55:04’),
(27, ‘user_format’, ‘lastname_firstname’, ‘2015-06-25 12:55:04’),
(28, ‘gravatar_enabled’, ‘0’, ‘2015-06-25 12:55:04’),
(29, ‘gravatar_default’, ”, ‘2015-06-25 12:55:04’),
(30, ‘thumbnails_enabled’, ‘0’, ‘2015-06-25 12:55:04’),
(31, ‘thumbnails_size’, ‘100’, ‘2015-06-25 12:55:04’);
–
– Table structure for table time_entries
CREATE TABLE IF NOT EXISTS time_entries
(
id
int(11) NOT NULL,
project_id
int(11) NOT NULL,
user_id
int(11) NOT NULL,
issue_id
int(11) DEFAULT NULL,
hours
float NOT NULL,
comments
varchar(255) DEFAULT NULL,
activity_id
int(11) NOT NULL,
spent_on
date NOT NULL,
tyear
int(11) NOT NULL,
tmonth
int(11) NOT NULL,
tweek
int(11) NOT NULL,
created_on
datetime NOT NULL,
updated_on
datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
–
– Truncate table before insert time_entries
TRUNCATE TABLE time_entries
;
– Dumping data for table time_entries
INSERT INTO time_entries
(id
, project_id
, user_id
, issue_id
, hours
, comments
, activity_id
, spent_on
, tyear
, tmonth
, tweek
, created_on
, updated_on
) VALUES
(1, 1, 7, 25, 1, ”, 9, ‘2015-06-26’, 2015, 6, 26, ‘2015-06-26 09:31:33’, ‘2015-06-26 09:31:33’),
(2, 1, 7, 25, 1, ”, 9, ‘2015-06-26’, 2015, 6, 26, ‘2015-06-26 09:32:35’, ‘2015-06-26 09:32:35’),
(3, 1, 19, 202, 1, ”, 9, ‘2015-06-29’, 2015, 6, 27, ‘2015-06-29 16:35:55’, ‘2015-06-29 16:35:55’),
(4, 1, 19, 251, 1, ”, 8, ‘2015-06-30’, 2015, 6, 27, ‘2015-06-30 15:30:31’, ‘2015-06-30 15:30:31’);
–
– Table structure for table tokens
CREATE TABLE IF NOT EXISTS tokens
(
id
int(11) NOT NULL,
user_id
int(11) NOT NULL DEFAULT ‘0’,
action
varchar(30) NOT NULL DEFAULT ”,
value
varchar(40) NOT NULL DEFAULT ”,
created_on
datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
–
– Truncate table before insert tokens
TRUNCATE TABLE tokens
;
– Dumping data for table tokens
INSERT INTO tokens
(id
, user_id
, action
, value
, created_on
) VALUES
(1, 1, ‘feeds’, ‘9dadfb77fbd03b807e4550ce3603ff64a836da1f’, ‘2015-06-25 11:25:55’),
(2, 6, ‘feeds’, ‘9a894d20c159b22f4ce5914d3ae34c8ac3ee102a’, ‘2015-06-25 12:47:36’),
(3, 3, ‘feeds’, ‘f1168367d193a032d7021caf708d3004fbddd349’, ‘2015-06-25 12:56:13’),
(5, 8, ‘feeds’, ‘fddb8ff72c2cfef0441f32ba937514583725def5’, ‘2015-06-25 13:16:13’),
(6, 9, ‘feeds’, ‘7fbbe8137342864fc5933601beaba3bc50f6da5f’, ‘2015-06-25 13:21:15’),
(7, 10, ‘feeds’, ‘90f72f3ded7754289380eaad7c976f0f48ed527a’, ‘2015-06-25 13:46:12’),
(8, 15, ‘feeds’, ‘2d212706868af7d21e97a5415bab4d7197b45425’, ‘2015-06-25 13:58:37’),
(9, 16, ‘feeds’, ‘f00f8b5d62215e3e41e64ce798843b7f2265b594’, ‘2015-06-25 14:36:56’),
(10, 13, ‘feeds’, ‘3a9ce5eb2a68872108eb364b2c9242fd95f1f07f’, ‘2015-06-25 15:36:26’),
(11, 14, ‘feeds’, ‘15cfd205093bc4053b044b7af482eeaf17a30aae’, ‘2015-06-25 21:02:58’),
(13, 7, ‘feeds’, ‘52de95076c1784e82c338e5b49c67962dd13ab12’, ‘2015-06-26 09:07:03’),
(14, 17, ‘feeds’, ‘dfc66b081fbaf597a25caad6d1127e34d34a1783’, ‘2015-06-26 10:26:46’),
(17, 5, ‘feeds’, ‘f284449c0703cad6146a84189a75acd9e56cd514’, ‘2015-06-26 12:01:38’),
(21, 11, ‘feeds’, ‘8d8b2ca3b550e4b67c3ce5e7691002847c37d40f’, ‘2015-06-26 13:40:56’),
(22, 18, ‘feeds’, ‘df6661f8305581f2ccb18187c8cdc732adbd963b’, ‘2015-06-26 15:10:53’),
(23, 12, ‘autologin’, ‘f0a59e696dcf218fc806b22036046d8ebbde3c66’, ‘2015-06-26 16:10:37’),
(24, 12, ‘feeds’, ‘af3df0d5bba73c13783788ab886485a380328fc2’, ‘2015-06-26 16:10:38’),
(26, 16, ‘autologin’, ‘5b2d475ea1b45205e16af68a55061ce7fb82d873’, ‘2015-06-27 14:51:24’),
(27, 11, ‘autologin’, ‘841e43eaec2daa6f0330d7d91d6f2ace25112a3d’, ‘2015-06-29 14:32:02’),
(28, 19, ‘feeds’, ‘c374becb60b0c890e57dbdd9df6af6e8744d5a0c’, ‘2015-06-29 14:52:19’),
(29, 20, ‘feeds’, ‘74c5935b4e66c995e0d126c7a991de38e7f01915’, ‘2015-06-29 14:57:12’),
(30, 7, ‘autologin’, ‘70a92210df50af4499d8092276c1f4824d2b7933’, ‘2015-06-29 15:01:25’),
(33, 5, ‘autologin’, ‘28b98fdc51e29b986199d8acd5c8fb1c5a29e0ce’, ‘2015-06-30 13:47:27’),
(34, 17, ‘autologin’, ‘ad882116ca828e68b978f29bba6899186ab0e6cf’, ‘2015-07-01 09:41:33’),
(35, 22, ‘feeds’, ‘a3e9fe6270570371d097e9bb6a1e94bc79628fee’, ‘2015-07-02 09:24:43’),
(37, 8, ‘autologin’, ‘b26fac852d4f161585aa5a08f08e96435e7e8bb1’, ‘2015-07-03 09:01:05’),
(38, 23, ‘feeds’, ‘0cb4d5e6f7eeef3abec8981c139d645d3fae9293’, ‘2015-07-03 10:16:38’),
(39, 19, ‘autologin’, ‘e3c78f3941ac2d4d8d40ea3a4b16b742105e9ca5’, ‘2015-07-03 10:26:10’),
(40, 27, ‘feeds’, ‘624a5032964e30507b6a49e89b422382d3e3c098’, ‘2015-07-03 10:31:55’),
(41, 10, ‘autologin’, ‘941e7e8512303e4ff1b703781b9122b026cd7d53’, ‘2015-07-03 11:16:36’),
(42, 25, ‘feeds’, ‘fa5153a113bd15e38d6cf1fe5b3104ee0ca80105’, ‘2015-07-03 13:02:36’),
(43, 6, ‘autologin’, ‘4a19a7ad06f51f4c9ff00cd2c344c29bf06d4edf’, ‘2015-07-03 13:17:43’),
(44, 13, ‘autologin’, ‘b9c8172577d26eeffc66de8b0e2db52652e6b71b’, ‘2015-07-03 13:38:13’),
(45, 9, ‘autologin’, ‘df343c789326ae93bfdb542af618888a955ccb76’, ‘2015-07-03 15:11:12’);
–
– Table structure for table trackers
CREATE TABLE IF NOT EXISTS trackers
(
id
int(11) NOT NULL,
name
varchar(30) NOT NULL DEFAULT ”,
is_in_chlog
tinyint(1) NOT NULL DEFAULT ‘0’,
position
int(11) DEFAULT ‘1’,
is_in_roadmap
tinyint(1) NOT NULL DEFAULT ‘1’,
fields_bits
int(11) DEFAULT ‘0’,
default_status_id
int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
–
– Truncate table before insert trackers
TRUNCATE TABLE trackers
;
– Dumping data for table trackers
INSERT INTO trackers
(id
, name
, is_in_chlog
, position
, is_in_roadmap
, fields_bits
, default_status_id
) VALUES
(1, ‘Defect’, 1, 1, 0, 0, 1),
(4, ‘Issue’, 0, 2, 1, 0, 1),
(5, ‘UserStory’, 0, 3, 1, 0, 1),
(6, ‘QA’, 0, 4, 1, 0, 1);
–
– Table structure for table users
CREATE TABLE IF NOT EXISTS users
(
id
int(11) NOT NULL,
login
varchar(255) NOT NULL DEFAULT ”,
hashed_password
varchar(40) NOT NULL DEFAULT ”,
firstname
varchar(30) NOT NULL DEFAULT ”,
lastname
varchar(255) NOT NULL DEFAULT ”,
admin
tinyint(1) NOT NULL DEFAULT ‘0’,
status
int(11) NOT NULL DEFAULT ‘1’,
last_login_on
datetime DEFAULT NULL,
language
varchar(5) DEFAULT ”,
auth_source_id
int(11) DEFAULT NULL,
created_on
datetime DEFAULT NULL,
updated_on
datetime DEFAULT NULL,
type
varchar(255) DEFAULT NULL,
identity_url
varchar(255) DEFAULT NULL,
mail_notification
varchar(255) NOT NULL DEFAULT ”,
salt
varchar(64) DEFAULT NULL,
must_change_passwd
tinyint(1) NOT NULL DEFAULT ‘0’,
passwd_changed_on
datetime DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
–
– Truncate table before insert users
TRUNCATE TABLE users
;
– Dumping data for table users
INSERT INTO users
(id
, login
, hashed_password
, firstname
, lastname
, admin
, status
, last_login_on
, language
, auth_source_id
, created_on
, updated_on
, type
, identity_url
, mail_notification
, salt
, must_change_passwd
, passwd_changed_on
) VALUES
(1, ‘admin’, ‘b6cac94b7fe24a059bbaacb52b8edef6a40d8e48’, ‘Samsung’, ‘Admin’, 1, 1, ‘2015-07-03 14:59:41’, ‘en’, NULL, ‘2015-06-25 11:16:33’, ‘2015-06-25 11:16:33’, ‘User’, NULL, ‘all’, ‘3b3adf8a369a58ea57110f7e2216cce1’, 0, NULL),
(2, ”, ”, ”, ‘Anonymous’, 0, 0, NULL, ”, NULL, ‘2015-06-25 11:23:07’, ‘2015-06-25 11:23:07’, ‘AnonymousUser’, NULL, ‘only_my_events’, NULL, 0, NULL),
(3, ‘zy1.wang’, ‘f28dc95a0c80852600f534a1739e6009805c029d’, ‘周阳’, ‘王’, 0, 1, ‘2015-07-03 15:26:20’, ‘en’, NULL, ‘2015-06-25 11:29:24’, ‘2015-06-25 11:29:24’, ‘User’, NULL, ‘none’, ‘af126ee25df3875d43cf83bc0f321774’, 0, ‘2015-06-25 11:29:24’),
(5, ‘liang3.wang’, ‘f8a95b2c691a87de531dd15b64552d6df28b34a7’, ‘亮’, ‘王’, 0, 1, ‘2015-07-03 08:30:16’, ‘zh’, NULL, ‘2015-06-25 12:11:45’, ‘2015-06-25 12:13:46’, ‘User’, NULL, ‘only_my_events’, ‘9c147fa8df4011b556dac1bae02c109b’, 0, ‘2015-06-25 12:11:45’),
(6, ‘yi.zhang’, ‘88ef8409cfeae7be4f1ebaf38f2fe6c34392f00f’, ‘毅’, ‘张’, 0, 1, ‘2015-07-03 13:17:43’, ‘zh’, NULL, ‘2015-06-25 12:47:04’, ‘2015-06-25 12:55:38’, ‘User’, NULL, ‘none’, ‘58dc955a50d1c16dde8d9629361ea94f’, 0, ‘2015-06-25 12:47:04’),
(7, ‘shihai.gong’, ‘27c41fbbdd1d715e74cf47dd713d9d6dd074c527’, ‘世海’, ‘巩’, 0, 1, ‘2015-07-03 14:38:03’, ‘zh’, NULL, ‘2015-06-25 13:00:20’, ‘2015-06-25 13:17:16’, ‘User’, NULL, ‘none’, ‘83a332b1652211d5463098636b33f549’, 0, ‘2015-06-25 13:00:20’),
(8, ‘yd1.zhang’, ‘cd96fb5e93087db7290ac4c389d85399ecef894f’, ‘延都’, ‘张’, 0, 1, ‘2015-07-03 09:01:05’, ‘zh’, NULL, ‘2015-06-25 13:14:50’, ‘2015-06-25 13:14:50’, ‘User’, NULL, ‘none’, ‘c0bd23fc15403e9f74286cb261384ef8’, 0, ‘2015-06-25 13:14:50’),
(9, ‘hl.shi’, ‘48a1b76abe4bc2026e1cbb13a9a32c29bb5dcc24’, ‘灏亮’, ‘是’, 0, 1, ‘2015-07-03 15:11:12’, ‘zh’, NULL, ‘2015-06-25 13:20:03’, ‘2015-06-25 13:46:33’, ‘User’, NULL, ‘only_my_events’, ‘dd12ecba93158b72b010dc4c30f45596’, 0, ‘2015-06-25 13:20:03’),
(10, ‘chonghu.gao’, ‘ffa1f0d99ad36133ca455e00fad4d378fd2d4986’, ‘崇虎’, ‘高’, 0, 1, ‘2015-07-03 12:51:25’, ‘zh’, NULL, ‘2015-06-25 13:23:30’, ‘2015-06-25 13:47:26’, ‘User’, NULL, ‘all’, ‘d54443abc035f04eccf6986ed255b25a’, 0, ‘2015-06-25 13:23:30’),
(11, ‘lu.yao’, ‘807b377437383b228e000586d60417e0069aac64’, ‘璐’, ‘姚’, 0, 1, ‘2015-07-03 15:48:22’, ‘en’, NULL, ‘2015-06-25 13:24:07’, ‘2015-06-25 13:24:07’, ‘User’, NULL, ‘none’, ‘4fb2155d169b2ef6b4a0cf0affc9a94a’, 0, ‘2015-06-25 13:24:07’),
(12, ‘weiping.yang’, ‘59797157770763ab4a8a3784d2eed68b4dd453a3’, ‘维平’, ‘杨’, 0, 1, ‘2015-07-03 13:59:34’, ‘zh’, NULL, ‘2015-06-25 13:25:08’, ‘2015-06-25 13:25:08’, ‘User’, NULL, ‘none’, ‘1de095c89cad6b3efd4515032e8963d3’, 0, ‘2015-06-25 13:25:08’),
(13, ‘hm1.ju’, ‘344bebadc1c9f4daf6ea0cde03835b8cfb5b9bac’, ‘慧明’, ‘鞠’, 0, 1, ‘2015-07-03 13:38:13’, ‘en’, NULL, ‘2015-06-25 13:43:56’, ‘2015-06-25 13:43:56’, ‘User’, NULL, ‘none’, ‘2a743e43874da7ede2fab25b7ef0b72b’, 0, ‘2015-06-25 13:43:56’),
(14, ‘jiajing.xu’, ‘a097411e308b2778752391b054375dee1db9772f’, ‘佳晶’, ‘徐’, 0, 1, ‘2015-07-01 17:05:13’, ‘en’, NULL, ‘2015-06-25 13:48:05’, ‘2015-06-26 13:40:59’, ‘User’, NULL, ‘none’, ‘00e16dc0ec6f3004abab6b02b6d0baf6’, 0, ‘2015-06-25 13:48:05’),
(15, ‘swb6220’, ‘7b50a102522557d5a6e897f5f5b678e51a119a7e’, ‘文博’, ‘史’, 0, 1, ‘2015-07-03 08:40:19’, ‘zh’, NULL, ‘2015-06-25 13:50:26’, ‘2015-06-25 13:50:26’, ‘User’, NULL, ‘none’, ‘3d51b7c9d7c3ed1c38ef71b476a6c742’, 0, ‘2015-06-25 13:50:26’),
(16, ‘miao3.li’, ‘bad43add5a53f60ff018961bc578483943c14de9’, ‘苗’, ‘李’, 0, 1, ‘2015-07-03 14:30:03’, ‘en’, NULL, ‘2015-06-25 14:36:07’, ‘2015-06-26 13:41:19’, ‘User’, NULL, ‘none’, ‘48cdc7fda34a2003e3457c7c6dc18d6c’, 0, ‘2015-06-25 14:36:07’),
(17, ‘guanbo.zhang’, ‘b56c5d429520ad2906af5ca9b4f459fedd70d119’, ‘关波’, ‘张’, 0, 1, ‘2015-07-03 08:58:06’, ‘en’, NULL, ‘2015-06-26 10:14:25’, ‘2015-06-26 12:31:52’, ‘User’, NULL, ‘none’, ‘b77c5a73ea8e93c1951faee862a950ef’, 0, ‘2015-06-26 10:14:25’),
(18, ‘jiaojs’, ‘dbbeda69779fe39ad4b8b5ccf8dd097f4064c025’, ‘晋生’, ‘焦’, 0, 1, ‘2015-07-03 08:47:28’, ‘zh’, NULL, ‘2015-06-26 15:10:21’, ‘2015-07-03 11:15:51’, ‘User’, NULL, ‘none’, ‘c6f1cce6856e01149b89cc46e2532d22’, 0, ‘2015-06-26 15:10:21’),
(19, ‘ming.cao’, ‘8d1c106eb50815502fdad0126c91522157b1eb9c’, ‘明’, ‘曹’, 0, 1, ‘2015-07-03 10:26:10’, ‘ko’, NULL, ‘2015-06-29 14:51:49’, ‘2015-07-03 13:36:20’, ‘User’, NULL, ‘none’, ‘10e06098ea6c24276e492784f11d35db’, 0, ‘2015-06-29 14:51:49’),
(20, ‘zhibin.mao’, ‘7e418172b3d0a68ea7eb88dc858a3102646f0353’, ‘智斌’, ‘毛’, 0, 1, ‘2015-07-03 09:04:55’, ‘en’, NULL, ‘2015-06-29 14:55:33’, ‘2015-07-01 16:58:06’, ‘User’, NULL, ‘none’, ‘677e2f3af6c435ef3287e4769928ef32’, 0, ‘2015-06-29 14:55:33’),
(21, ‘lei1.han’, ‘361b3bf548c8cb42507c90f60995fe19f62007dc’, ‘磊’, ‘韩’, 0, 1, ‘2015-06-30 10:18:40’, ‘zh’, NULL, ‘2015-06-30 10:18:40’, ‘2015-06-30 10:18:40’, ‘User’, NULL, ‘none’, ‘7313cd6f26f292c6cd0568c6a54a66aa’, 0, ‘2015-06-30 10:18:40’),
(22, ‘customer01’, ‘a15d122761d12ffedf16880f40e1c590e3dec24e’, ‘Customer’, ‘Korea’, 0, 1, ‘2015-07-03 13:01:31’, ‘ko’, NULL, ‘2015-07-02 09:23:50’, ‘2015-07-02 09:47:39’, ‘User’, NULL, ‘none’, ‘2035dd4d81cf05190233a1cb490133f7’, 0, ‘2015-07-02 09:23:50’),
(23, ‘jh0614.noh’, ‘4de72bb1cd9e640dd018605d3f5b45ebe975f93d’, ‘준현’, ‘노’, 0, 1, ‘2015-07-03 10:16:17’, ‘ko’, NULL, ‘2015-07-03 10:16:17’, ‘2015-07-03 10:16:17’, ‘User’, NULL, ‘none’, ‘aceab31eb5cb5b0ee1d526a5bf17f224’, 0, ‘2015-07-03 10:16:17’),
(24, ‘hyungi.moon’, ‘6d7947a95537b170bd809429d700a019e9b17cb4’, ‘현기’, ‘문’, 0, 1, ‘2015-07-03 10:17:28’, ‘ko’, NULL, ‘2015-07-03 10:17:28’, ‘2015-07-03 10:17:28’, ‘User’, NULL, ‘none’, ‘971536cfc68b7c3f8e357d14296384ab’, 0, ‘2015-07-03 10:17:28’),
(25, ‘gahyun.choi’, ‘1c865d5a84d5cf343fbfcc7c6ea3dcb9267f920f’, ‘가현’, ‘최’, 0, 1, ‘2015-07-03 13:02:36’, ‘ko’, NULL, ‘2015-07-03 10:20:30’, ‘2015-07-03 10:20:30’, ‘User’, NULL, ‘none’, ‘2150bfc6cd132f064e10b5975b9aaa0a’, 0, ‘2015-07-03 10:20:30’),
(26, ‘ahhyeon.kim@opentide.com’, ‘6c4865388367e7e1dd756ca2fe54c6a3199a6f98’, ‘아현’, ‘김’, 0, 1, ‘2015-07-03 10:21:15’, ‘ko’, NULL, ‘2015-07-03 10:21:15’, ‘2015-07-03 10:21:15’, ‘User’, NULL, ‘none’, ‘25e614515e3d7e182fa04aa0121ac973’, 0, ‘2015-07-03 10:21:15’),
(27, ‘tj.roh’, ‘292ad49d88ab2b2cac358df4cbc664a29fbe8eb6’, ‘태진’, ‘노’, 0, 1, ‘2015-07-03 10:31:55’, ‘ko’, NULL, ‘2015-07-03 10:22:06’, ‘2015-07-03 10:22:06’, ‘User’, NULL, ‘none’, ‘158f0065cd1bf1d86b2b550d105e2242’, 0, ‘2015-07-03 10:22:06’),
(28, ‘kyungho.shim’, ‘084d1eb9e7bda7d03640f9e8d0294d081e387e2e’, ‘경호’, ‘심’, 0, 1, ‘2015-07-03 10:23:08’, ‘ko’, NULL, ‘2015-07-03 10:23:08’, ‘2015-07-03 10:23:08’, ‘User’, NULL, ‘none’, ‘20bbc5affee6932aebfd0334854e3bf9’, 0, ‘2015-07-03 10:23:08’),
(29, ”, ”, ”, ‘BSP_Customer’, 0, 1, NULL, ”, NULL, ‘2015-07-03 10:29:22’, ‘2015-07-03 10:29:22’, ‘Group’, NULL, ”, NULL, 0, NULL);
–
– Table structure for table user_preferences
CREATE TABLE IF NOT EXISTS user_preferences
(
id
int(11) NOT NULL,
user_id
int(11) NOT NULL DEFAULT ‘0’,
others
text,
hide_mail
tinyint(1) DEFAULT ‘0’,
time_zone
varchar(255) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
–
– Truncate table before insert user_preferences
TRUNCATE TABLE user_preferences
;
– Dumping data for table user_preferences
INSERT INTO user_preferences
(id
, user_id
, others
, hide_mail
, time_zone
) VALUES
(1, 1, ‘— {}\n’, 0, NULL),
(2, 3, ‘—\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, NULL),
(3, 5, ‘—\n:no_self_notified: ”1”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ‘Beijing’),
(4, 6, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(5, 7, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, ‘Beijing’),
(6, 8, ‘— {}\n’, 0, NULL),
(7, 9, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, ‘Hong Kong’),
(8, 10, ‘—\n:no_self_notified: ”1”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, ”),
(9, 11, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(10, 12, ‘— {}\n’, 0, NULL),
(11, 13, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(12, 14, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(13, 15, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, ”),
(14, 16, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(15, 17, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, ”),
(16, 18, ‘—\n:no_self_notified: ”1”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, ”),
(17, 19, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n:my_page_layout:\n top:\n - issuesassignedtome\n left: []\n right: []\n’, 0, ”),
(18, 20, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n:gantt_zoom: 2\n:gantt_months: 6\n’, 0, ”),
(19, 21, ‘— {}\n’, 0, NULL),
(20, 22, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(21, 23, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(22, 24, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(23, 25, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(24, 26, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(25, 27, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”),
(26, 28, ‘—\n:no_self_notified: ”0”\n:comments_sorting: asc\n:warn_on_leaving_unsaved: ”1”\n’, 0, ”);
–
– Table structure for table versions
CREATE TABLE IF NOT EXISTS versions
(
id
int(11) NOT NULL,
project_id
int(11) NOT NULL DEFAULT ‘0’,
name
varchar(255) NOT NULL DEFAULT ”,
description
varchar(255) DEFAULT ”,
effective_date
date DEFAULT NULL,
created_on
datetime DEFAULT NULL,
updated_on
datetime DEFAULT NULL,
wiki_page_title
varchar(255) DEFAULT NULL,
status
varchar(255) DEFAULT ‘open’,
sharing
varchar(255) NOT NULL DEFAULT ‘none’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert versions
TRUNCATE TABLE versions
;
–
– Table structure for table watchers
CREATE TABLE IF NOT EXISTS watchers
(
id
int(11) NOT NULL,
watchable_type
varchar(255) NOT NULL DEFAULT ”,
watchable_id
int(11) NOT NULL DEFAULT ‘0’,
user_id
int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
–
– Truncate table before insert watchers
TRUNCATE TABLE watchers
;
– Dumping data for table watchers
INSERT INTO watchers
(id
, watchable_type
, watchable_id
, user_id
) VALUES
(1, ‘News’, 1, 3),
(2, ‘News’, 2, 3),
(4, ‘Issue’, 51, 14),
(5, ‘Issue’, 51, 3),
(6, ‘Issue’, 52, 14),
(7, ‘Issue’, 52, 3),
(8, ‘Issue’, 56, 14),
(10, ‘Issue’, 223, 14),
(11, ‘News’, 4, 3),
(16, ‘Message’, 5, 19),
(17, ‘Message’, 6, 19),
(18, ‘Message’, 7, 19),
(19, ‘Message’, 7, 3),
(20, ‘Message’, 9, 18),
(23, ‘Message’, 10, 19),
(24, ‘News’, 5, 19),
(26, ‘Issue’, 306, 11),
(27, ‘Issue’, 306, 3),
(28, ‘Message’, 12, 19),
(31, ‘Message’, 13, 19),
(34, ‘Message’, 15, 17);
–
– Table structure for table wikis
CREATE TABLE IF NOT EXISTS wikis
(
id
int(11) NOT NULL,
project_id
int(11) NOT NULL,
start_page
varchar(255) NOT NULL,
status
int(11) NOT NULL DEFAULT ‘1’
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
–
– Truncate table before insert wikis
TRUNCATE TABLE wikis
;
– Dumping data for table wikis
INSERT INTO wikis
(id
, project_id
, start_page
, status
) VALUES
(1, 1, ‘Wiki’, 1);
–
– Table structure for table wiki_contents
CREATE TABLE IF NOT EXISTS wiki_contents
(
id
int(11) NOT NULL,
page_id
int(11) NOT NULL,
author_id
int(11) DEFAULT NULL,
text
longtext,
comments
varchar(255) DEFAULT ”,
updated_on
datetime NOT NULL,
version
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert wiki_contents
TRUNCATE TABLE wiki_contents
;
–
– Table structure for table wiki_content_versions
CREATE TABLE IF NOT EXISTS wiki_content_versions
(
id
int(11) NOT NULL,
wiki_content_id
int(11) NOT NULL,
page_id
int(11) NOT NULL,
author_id
int(11) DEFAULT NULL,
data
longblob,
compression
varchar(6) DEFAULT ”,
comments
varchar(255) DEFAULT ”,
updated_on
datetime NOT NULL,
version
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert wiki_content_versions
TRUNCATE TABLE wiki_content_versions
;
–
– Table structure for table wiki_pages
CREATE TABLE IF NOT EXISTS wiki_pages
(
id
int(11) NOT NULL,
wiki_id
int(11) NOT NULL,
title
varchar(255) NOT NULL,
created_on
datetime NOT NULL,
protected
tinyint(1) NOT NULL DEFAULT ‘0’,
parent_id
int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert wiki_pages
TRUNCATE TABLE wiki_pages
;
–
– Table structure for table wiki_redirects
CREATE TABLE IF NOT EXISTS wiki_redirects
(
id
int(11) NOT NULL,
wiki_id
int(11) NOT NULL,
title
varchar(255) DEFAULT NULL,
redirects_to
varchar(255) DEFAULT NULL,
created_on
datetime NOT NULL,
redirects_to_wiki_id
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
–
– Truncate table before insert wiki_redirects
TRUNCATE TABLE wiki_redirects
;
–
– Table structure for table workflows
CREATE TABLE IF NOT EXISTS workflows
(
id
int(11) NOT NULL,
tracker_id
int(11) NOT NULL DEFAULT ‘0’,
old_status_id
int(11) NOT NULL DEFAULT ‘0’,
new_status_id
int(11) NOT NULL DEFAULT ‘0’,
role_id
int(11) NOT NULL DEFAULT ‘0’,
assignee
tinyint(1) NOT NULL DEFAULT ‘0’,
author
tinyint(1) NOT NULL DEFAULT ‘0’,
type
varchar(30) DEFAULT NULL,
field_name
varchar(30) DEFAULT NULL,
rule
varchar(30) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=565 DEFAULT CHARSET=utf8;
–
– Truncate table before insert workflows
TRUNCATE TABLE workflows
;
– Dumping data for table workflows
INSERT INTO workflows
(id
, tracker_id
, old_status_id
, new_status_id
, role_id
, assignee
, author
, type
, field_name
, rule
) VALUES
(1, 1, 1, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(7, 1, 2, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(8, 1, 2, 4, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(14, 1, 3, 5, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(15, 1, 3, 6, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(17, 1, 4, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(19, 1, 4, 5, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(27, 1, 6, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(29, 1, 6, 4, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(91, 1, 1, 2, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(96, 1, 2, 4, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(100, 1, 3, 5, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(103, 1, 4, 5, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(132, 1, 3, 5, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(133, 1, 4, 5, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(146, 4, 1, 1, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(151, 4, 2, 1, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(155, 4, 2, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(156, 4, 2, 3, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(157, 4, 2, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(158, 4, 2, 3, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(159, 4, 2, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(161, 4, 2, 4, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(166, 4, 2, 5, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(171, 4, 2, 6, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(176, 4, 3, 2, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(181, 4, 3, 4, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(186, 4, 4, 2, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(191, 4, 4, 3, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(196, 4, 5, 2, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(201, 4, 5, 3, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(206, 4, 5, 4, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(211, 4, 6, 2, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(216, 4, 6, 4, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(221, 1, 3, 6, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(223, 1, 6, 2, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(225, 1, 1, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(226, 1, 1, 2, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(227, 1, 1, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(228, 1, 2, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(229, 1, 2, 3, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(230, 1, 2, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(231, 1, 2, 4, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(232, 1, 2, 4, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(233, 1, 2, 4, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(234, 1, 3, 5, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(235, 1, 3, 5, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(236, 1, 3, 6, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(237, 1, 3, 6, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(238, 1, 3, 6, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(239, 1, 4, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(240, 1, 4, 2, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(241, 1, 4, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(242, 1, 4, 5, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(243, 1, 4, 5, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(244, 1, 6, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(245, 1, 6, 2, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(246, 1, 6, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(247, 1, 6, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(248, 1, 6, 3, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(250, 1, 6, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(251, 1, 6, 4, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(252, 1, 6, 4, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(253, 1, 6, 4, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(254, 1, 6, 4, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(315, 5, 1, 8, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(316, 5, 1, 8, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(317, 5, 1, 8, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(318, 5, 1, 8, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(319, 5, 1, 8, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(320, 5, 8, 9, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(321, 5, 8, 9, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(322, 5, 8, 9, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(323, 5, 8, 9, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(324, 5, 8, 9, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(325, 5, 9, 10, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(326, 5, 9, 10, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(327, 5, 9, 10, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(328, 5, 9, 10, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(329, 5, 9, 10, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(330, 5, 10, 11, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(331, 5, 10, 11, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(332, 5, 10, 11, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(333, 5, 10, 11, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(334, 5, 10, 11, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(350, 5, 12, 8, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(351, 5, 12, 8, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(352, 5, 12, 8, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(353, 5, 12, 8, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(354, 5, 12, 8, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(355, 5, 9, 12, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(356, 5, 9, 12, 2, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(357, 5, 9, 12, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(358, 5, 9, 12, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(359, 5, 9, 12, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(360, 4, 1, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(361, 4, 1, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(362, 4, 1, 2, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(363, 4, 1, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(364, 4, 1, 13, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(365, 4, 1, 13, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(367, 4, 1, 13, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(368, 4, 1, 14, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(369, 4, 1, 14, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(371, 4, 1, 14, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(372, 4, 2, 13, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(373, 4, 2, 13, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(375, 4, 2, 13, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(376, 4, 2, 14, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(377, 4, 2, 14, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(379, 4, 2, 14, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(380, 4, 2, 15, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(381, 4, 2, 15, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(382, 4, 2, 15, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(383, 4, 2, 15, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(384, 4, 13, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(385, 4, 13, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(387, 4, 13, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(388, 4, 13, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(389, 4, 13, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(391, 4, 13, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(392, 4, 13, 15, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(393, 4, 13, 15, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(395, 4, 13, 15, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(396, 4, 14, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(397, 4, 14, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(399, 4, 14, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(400, 4, 14, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(401, 4, 14, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(403, 4, 14, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(404, 4, 14, 15, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(405, 4, 14, 15, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(407, 4, 14, 15, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(408, 4, 15, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(409, 4, 15, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(411, 4, 15, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(412, 4, 15, 13, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(413, 4, 15, 13, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(415, 4, 15, 13, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(416, 4, 15, 14, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(417, 4, 15, 14, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(419, 4, 15, 14, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(420, 5, 5, 12, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(421, 5, 11, 5, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(422, 5, 9, 5, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(423, 5, 10, 5, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(424, 6, 1, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(425, 6, 1, 13, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(426, 6, 1, 14, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(427, 6, 2, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(428, 6, 2, 13, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(429, 6, 2, 14, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(430, 6, 2, 15, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(431, 6, 13, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(432, 6, 13, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(433, 6, 13, 15, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(434, 6, 14, 2, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(435, 6, 14, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(436, 6, 14, 15, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(437, 6, 15, 3, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(438, 6, 15, 13, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(439, 6, 15, 14, 1, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(455, 6, 1, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(456, 6, 1, 13, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(457, 6, 1, 14, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(458, 6, 2, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(459, 6, 2, 13, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(460, 6, 2, 14, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(461, 6, 2, 15, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(462, 6, 13, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(463, 6, 13, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(464, 6, 13, 15, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(465, 6, 14, 2, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(466, 6, 14, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(467, 6, 14, 15, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(468, 6, 15, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(469, 6, 15, 13, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(470, 6, 15, 14, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(486, 6, 1, 2, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(487, 6, 1, 13, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(488, 6, 1, 14, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(489, 6, 2, 3, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(490, 6, 2, 13, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(491, 6, 2, 14, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(492, 6, 2, 15, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(493, 6, 13, 2, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(494, 6, 13, 3, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(495, 6, 13, 15, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(496, 6, 14, 2, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(497, 6, 14, 3, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(498, 6, 14, 15, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(499, 6, 15, 3, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(500, 6, 15, 13, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(501, 6, 15, 14, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(517, 6, 1, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(518, 6, 1, 13, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(519, 6, 1, 14, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(520, 6, 2, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(521, 6, 2, 13, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(522, 6, 2, 14, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(523, 6, 2, 15, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(524, 6, 13, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(525, 6, 13, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(526, 6, 13, 15, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(527, 6, 14, 2, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(528, 6, 14, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(529, 6, 14, 15, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(530, 6, 15, 3, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(531, 6, 15, 13, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(532, 6, 15, 14, 5, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(548, 4, 2, 4, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(549, 4, 2, 6, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(550, 4, 4, 3, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(551, 4, 4, 6, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(552, 4, 4, 5, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(553, 4, 6, 5, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(554, 5, 11, 8, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(555, 1, 4, 1, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(556, 1, 2, 16, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(557, 1, 16, 1, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(560, 1, 6, 16, 4, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(561, 1, 2, 16, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(562, 1, 6, 16, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(563, 1, 16, 3, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL),
(564, 1, 16, 6, 3, 0, 0, ‘WorkflowTransition’, NULL, NULL);
–
– Indexes for dumped tables
–
– Indexes for table attachments
ALTER TABLE attachments
ADD PRIMARY KEY (id
),
ADD KEY index_attachments_on_author_id
(author_id
),
ADD KEY index_attachments_on_created_on
(created_on
),
ADD KEY index_attachments_on_container_id_and_container_type
(container_id
,container_type
);
–
– Indexes for table auth_sources
ALTER TABLE auth_sources
ADD PRIMARY KEY (id
),
ADD KEY index_auth_sources_on_id_and_type
(id
,type
);
–
– Indexes for table boards
ALTER TABLE boards
ADD PRIMARY KEY (id
),
ADD KEY boards_project_id
(project_id
),
ADD KEY index_boards_on_last_message_id
(last_message_id
);
–
– Indexes for table changes
ALTER TABLE changes
ADD PRIMARY KEY (id
),
ADD KEY changesets_changeset_id
(changeset_id
);
–
– Indexes for table changesets
ALTER TABLE changesets
ADD PRIMARY KEY (id
),
ADD UNIQUE KEY changesets_repos_rev
(repository_id
,revision
),
ADD KEY index_changesets_on_user_id
(user_id
),
ADD KEY index_changesets_on_repository_id
(repository_id
),
ADD KEY index_changesets_on_committed_on
(committed_on
),
ADD KEY changesets_repos_scmid
(repository_id
,scmid
);
–
– Indexes for table changesets_issues
ALTER TABLE changesets_issues
ADD UNIQUE KEY changesets_issues_ids
(changeset_id
,issue_id
);
–
– Indexes for table changeset_parents
ALTER TABLE changeset_parents
ADD KEY changeset_parents_changeset_ids
(changeset_id
),
ADD KEY changeset_parents_parent_ids
(parent_id
);
–
– Indexes for table comments
ALTER TABLE comments
ADD PRIMARY KEY (id
),
ADD KEY index_comments_on_commented_id_and_commented_type
(commented_id
,commented_type
),
ADD KEY index_comments_on_author_id
(author_id
);
–
– Indexes for table custom_fields
ALTER TABLE custom_fields
ADD PRIMARY KEY (id
),
ADD KEY index_custom_fields_on_id_and_type
(id
,type
);
–
– Indexes for table custom_fields_projects
ALTER TABLE custom_fields_projects
ADD UNIQUE KEY index_custom_fields_projects_on_custom_field_id_and_project_id
(custom_field_id
,project_id
);
–
– Indexes for table custom_fields_roles
ALTER TABLE custom_fields_roles
ADD UNIQUE KEY custom_fields_roles_ids
(custom_field_id
,role_id
);
–
– Indexes for table custom_fields_trackers
ALTER TABLE custom_fields_trackers
ADD UNIQUE KEY index_custom_fields_trackers_on_custom_field_id_and_tracker_id
(custom_field_id
,tracker_id
);
–
– Indexes for table custom_values
ALTER TABLE custom_values
ADD PRIMARY KEY (id
),
ADD KEY custom_values_customized
(customized_type
,customized_id
),
ADD KEY index_custom_values_on_custom_field_id
(custom_field_id
);
–
– Indexes for table documents
ALTER TABLE documents
ADD PRIMARY KEY (id
),
ADD KEY documents_project_id
(project_id
),
ADD KEY index_documents_on_category_id
(category_id
),
ADD KEY index_documents_on_created_on
(created_on
);
–
– Indexes for table email_addresses
ALTER TABLE email_addresses
ADD PRIMARY KEY (id
),
ADD KEY index_email_addresses_on_user_id
(user_id
);
–
– Indexes for table enabled_modules
ALTER TABLE enabled_modules
ADD PRIMARY KEY (id
),
ADD KEY enabled_modules_project_id
(project_id
);
–
– Indexes for table enumerations
ALTER TABLE enumerations
ADD PRIMARY KEY (id
),
ADD KEY index_enumerations_on_project_id
(project_id
),
ADD KEY index_enumerations_on_id_and_type
(id
,type
);
–
– Indexes for table groups_users
ALTER TABLE groups_users
ADD UNIQUE KEY groups_users_ids
(group_id
,user_id
);
–
– Indexes for table issues
ALTER TABLE issues
ADD PRIMARY KEY (id
),
ADD KEY issues_project_id
(project_id
),
ADD KEY index_issues_on_status_id
(status_id
),
ADD KEY index_issues_on_category_id
(category_id
),
ADD KEY index_issues_on_assigned_to_id
(assigned_to_id
),
ADD KEY index_issues_on_fixed_version_id
(fixed_version_id
),
ADD KEY index_issues_on_tracker_id
(tracker_id
),
ADD KEY index_issues_on_priority_id
(priority_id
),
ADD KEY index_issues_on_author_id
(author_id
),
ADD KEY index_issues_on_created_on
(created_on
),
ADD KEY index_issues_on_root_id_and_lft_and_rgt
(root_id
,lft
,rgt
);
–
– Indexes for table issue_categories
ALTER TABLE issue_categories
ADD PRIMARY KEY (id
),
ADD KEY issue_categories_project_id
(project_id
),
ADD KEY index_issue_categories_on_assigned_to_id
(assigned_to_id
);
–
– Indexes for table issue_relations
ALTER TABLE issue_relations
ADD PRIMARY KEY (id
),
ADD UNIQUE KEY index_issue_relations_on_issue_from_id_and_issue_to_id
(issue_from_id
,issue_to_id
),
ADD KEY index_issue_relations_on_issue_from_id
(issue_from_id
),
ADD KEY index_issue_relations_on_issue_to_id
(issue_to_id
);
–
– Indexes for table issue_statuses
ALTER TABLE issue_statuses
ADD PRIMARY KEY (id
),
ADD KEY index_issue_statuses_on_position
(position
),
ADD KEY index_issue_statuses_on_is_closed
(is_closed
);
–
– Indexes for table journals
ALTER TABLE journals
ADD PRIMARY KEY (id
),
ADD KEY journals_journalized_id
(journalized_id
,journalized_type
),
ADD KEY index_journals_on_user_id
(user_id
),
ADD KEY index_journals_on_journalized_id
(journalized_id
),
ADD KEY index_journals_on_created_on
(created_on
);
–
– Indexes for table journal_details
ALTER TABLE journal_details
ADD PRIMARY KEY (id
),
ADD KEY journal_details_journal_id
(journal_id
);
–
– Indexes for table members
ALTER TABLE members
ADD PRIMARY KEY (id
),
ADD UNIQUE KEY index_members_on_user_id_and_project_id
(user_id
,project_id
),
ADD KEY index_members_on_user_id
(user_id
),
ADD KEY index_members_on_project_id
(project_id
);
–
– Indexes for table member_roles
ALTER TABLE member_roles
ADD PRIMARY KEY (id
),
ADD KEY index_member_roles_on_member_id
(member_id
),
ADD KEY index_member_roles_on_role_id
(role_id
);
–
– Indexes for table messages
ALTER TABLE messages
ADD PRIMARY KEY (id
),
ADD KEY messages_board_id
(board_id
),
ADD KEY messages_parent_id
(parent_id
),
ADD KEY index_messages_on_last_reply_id
(last_reply_id
),
ADD KEY index_messages_on_author_id
(author_id
),
ADD KEY index_messages_on_created_on
(created_on
);
–
– Indexes for table news
ALTER TABLE news
ADD PRIMARY KEY (id
),
ADD KEY news_project_id
(project_id
),
ADD KEY index_news_on_author_id
(author_id
),
ADD KEY index_news_on_created_on
(created_on
);
–
– Indexes for table open_id_authentication_associations
ALTER TABLE open_id_authentication_associations
ADD PRIMARY KEY (id
);
–
– Indexes for table open_id_authentication_nonces
ALTER TABLE open_id_authentication_nonces
ADD PRIMARY KEY (id
);
–
– Indexes for table projects
ALTER TABLE projects
ADD PRIMARY KEY (id
),
ADD KEY index_projects_on_lft
(lft
),
ADD KEY index_projects_on_rgt
(rgt
);
–
– Indexes for table projects_trackers
ALTER TABLE projects_trackers
ADD UNIQUE KEY projects_trackers_unique
(project_id
,tracker_id
),
ADD KEY projects_trackers_project_id
(project_id
);
–
– Indexes for table queries
ALTER TABLE queries
ADD PRIMARY KEY (id
),
ADD KEY index_queries_on_project_id
(project_id
),
ADD KEY index_queries_on_user_id
(user_id
);
–
– Indexes for table queries_roles
ALTER TABLE queries_roles
ADD UNIQUE KEY queries_roles_ids
(query_id
,role_id
);
–
– Indexes for table repositories
ALTER TABLE repositories
ADD PRIMARY KEY (id
),
ADD KEY index_repositories_on_project_id
(project_id
);
–
– Indexes for table roles
ALTER TABLE roles
ADD PRIMARY KEY (id
);
–
– Indexes for table schema_migrations
ALTER TABLE schema_migrations
ADD UNIQUE KEY unique_schema_migrations
(version
);
–
– Indexes for table settings
ALTER TABLE settings
ADD PRIMARY KEY (id
),
ADD KEY index_settings_on_name
(name
);
–
– Indexes for table time_entries
ALTER TABLE time_entries
ADD PRIMARY KEY (id
),
ADD KEY time_entries_project_id
(project_id
),
ADD KEY time_entries_issue_id
(issue_id
),
ADD KEY index_time_entries_on_activity_id
(activity_id
),
ADD KEY index_time_entries_on_user_id
(user_id
),
ADD KEY index_time_entries_on_created_on
(created_on
);
–
– Indexes for table tokens
ALTER TABLE tokens
ADD PRIMARY KEY (id
),
ADD UNIQUE KEY tokens_value
(value
),
ADD KEY index_tokens_on_user_id
(user_id
);
–
– Indexes for table trackers
ALTER TABLE trackers
ADD PRIMARY KEY (id
);
–
– Indexes for table users
ALTER TABLE users
ADD PRIMARY KEY (id
),
ADD KEY index_users_on_id_and_type
(id
,type
),
ADD KEY index_users_on_auth_source_id
(auth_source_id
),
ADD KEY index_users_on_type
(type
);
–
– Indexes for table user_preferences
ALTER TABLE user_preferences
ADD PRIMARY KEY (id
),
ADD KEY index_user_preferences_on_user_id
(user_id
);
–
– Indexes for table versions
ALTER TABLE versions
ADD PRIMARY KEY (id
),
ADD KEY versions_project_id
(project_id
),
ADD KEY index_versions_on_sharing
(sharing
);
–
– Indexes for table watchers
ALTER TABLE watchers
ADD PRIMARY KEY (id
),
ADD KEY watchers_user_id_type
(user_id
,watchable_type
),
ADD KEY index_watchers_on_user_id
(user_id
),
ADD KEY index_watchers_on_watchable_id_and_watchable_type
(watchable_id
,watchable_type
);
–
– Indexes for table wikis
ALTER TABLE wikis
ADD PRIMARY KEY (id
),
ADD KEY wikis_project_id
(project_id
);
–
– Indexes for table wiki_contents
ALTER TABLE wiki_contents
ADD PRIMARY KEY (id
),
ADD KEY wiki_contents_page_id
(page_id
),
ADD KEY index_wiki_contents_on_author_id
(author_id
);
–
– Indexes for table wiki_content_versions
ALTER TABLE wiki_content_versions
ADD PRIMARY KEY (id
),
ADD KEY wiki_content_versions_wcid
(wiki_content_id
),
ADD KEY index_wiki_content_versions_on_updated_on
(updated_on
);
–
– Indexes for table wiki_pages
ALTER TABLE wiki_pages
ADD PRIMARY KEY (id
),
ADD KEY wiki_pages_wiki_id_title
(wiki_id
,title
),
ADD KEY index_wiki_pages_on_wiki_id
(wiki_id
),
ADD KEY index_wiki_pages_on_parent_id
(parent_id
);
–
– Indexes for table wiki_redirects
ALTER TABLE wiki_redirects
ADD PRIMARY KEY (id
),
ADD KEY wiki_redirects_wiki_id_title
(wiki_id
,title
),
ADD KEY index_wiki_redirects_on_wiki_id
(wiki_id
);
–
– Indexes for table workflows
ALTER TABLE workflows
ADD PRIMARY KEY (id
),
ADD KEY wkfs_role_tracker_old_status
(role_id
,tracker_id
,old_status_id
),
ADD KEY index_workflows_on_old_status_id
(old_status_id
),
ADD KEY index_workflows_on_role_id
(role_id
),
ADD KEY index_workflows_on_new_status_id
(new_status_id
);
–
– AUTO_INCREMENT for dumped tables
–
– AUTO_INCREMENT for table attachments
ALTER TABLE attachments
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
– AUTO_INCREMENT for table auth_sources
ALTER TABLE auth_sources
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table boards
ALTER TABLE boards
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
– AUTO_INCREMENT for table changes
ALTER TABLE changes
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table changesets
ALTER TABLE changesets
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table comments
ALTER TABLE comments
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
– AUTO_INCREMENT for table custom_fields
ALTER TABLE custom_fields
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
– AUTO_INCREMENT for table custom_values
ALTER TABLE custom_values
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=48;
– AUTO_INCREMENT for table documents
ALTER TABLE documents
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table email_addresses
ALTER TABLE email_addresses
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
– AUTO_INCREMENT for table enabled_modules
ALTER TABLE enabled_modules
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
– AUTO_INCREMENT for table enumerations
ALTER TABLE enumerations
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
– AUTO_INCREMENT for table issues
ALTER TABLE issues
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=374;
– AUTO_INCREMENT for table issue_categories
ALTER TABLE issue_categories
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table issue_relations
ALTER TABLE issue_relations
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
– AUTO_INCREMENT for table issue_statuses
ALTER TABLE issue_statuses
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
– AUTO_INCREMENT for table journals
ALTER TABLE journals
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1650;
– AUTO_INCREMENT for table journal_details
ALTER TABLE journal_details
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1875;
– AUTO_INCREMENT for table members
ALTER TABLE members
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34;
– AUTO_INCREMENT for table member_roles
ALTER TABLE member_roles
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=45;
– AUTO_INCREMENT for table messages
ALTER TABLE messages
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
– AUTO_INCREMENT for table news
ALTER TABLE news
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
– AUTO_INCREMENT for table open_id_authentication_associations
ALTER TABLE open_id_authentication_associations
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table open_id_authentication_nonces
ALTER TABLE open_id_authentication_nonces
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table projects
ALTER TABLE projects
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
– AUTO_INCREMENT for table queries
ALTER TABLE queries
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
– AUTO_INCREMENT for table repositories
ALTER TABLE repositories
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
– AUTO_INCREMENT for table roles
ALTER TABLE roles
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
– AUTO_INCREMENT for table settings
ALTER TABLE settings
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
– AUTO_INCREMENT for table time_entries
ALTER TABLE time_entries
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
– AUTO_INCREMENT for table tokens
ALTER TABLE tokens
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=46;
– AUTO_INCREMENT for table trackers
ALTER TABLE trackers
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
– AUTO_INCREMENT for table users
ALTER TABLE users
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;
– AUTO_INCREMENT for table user_preferences
ALTER TABLE user_preferences
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
– AUTO_INCREMENT for table versions
ALTER TABLE versions
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table watchers
ALTER TABLE watchers
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=35;
– AUTO_INCREMENT for table wikis
ALTER TABLE wikis
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
– AUTO_INCREMENT for table wiki_contents
ALTER TABLE wiki_contents
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table wiki_content_versions
ALTER TABLE wiki_content_versions
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table wiki_pages
ALTER TABLE wiki_pages
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table wiki_redirects
ALTER TABLE wiki_redirects
MODIFY id
int(11) NOT NULL AUTO_INCREMENT;
– AUTO_INCREMENT for table workflows
ALTER TABLE workflows
MODIFY id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=565;
/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;