New deployment unit
org.kie.example project1 1.0.0-SNAPSHOT
Clone repository
file:///home/tkobayas/usr/local/BPMS/sample_git/helloProcess/repository1 file:///home/tkobayas/usr/local/BPMS/sample_git/helloTask/repository1
Import Project
file:///home/tkobayas/usr/local/RHPAM/sample_git/helloTask/helloTask
System.out.println("Task1 Entry");
System.out.println("Task1 Exit");
System.out.println("Task2 Entry");
System.out.println("Task2 Exit");kie.maven.settings.custom
bin/standalone.sh -Dkie.maven.settings.custom=/home/tkobayas/.m2/brms-settings.xml
git clone ssh://brmsAdmin@localhost:8001/repository1 git clone ssh://brmsAdmin@localhost:8001/repository1
- kie-server deployment
com.sample simple-jbpm-kjar 1.0.0-SNAPSHOT com.sample:simple-jbpm-kjar:1.0.0-SNAPSHOT simple-jbpm-kjar_1.0.0-SNAPSHOT
touch jboss-brms.war.dodeploy business-central.war.dodeploy business-central-server.war.dodeploy designer.war.dodeploy jbpm-human-task.war.dodeploy
touch business-central.war.dodeploy dashbuilder.war.dodeploy kie-server.war.dodeploy
patch
./apply-updates.sh /home/tkobayas/usr/local/BRMS/622/jboss-eap-6.4 eap6.x ./apply-updates.sh /home/tkobayas/usr/local/BPMS/622/jboss-eap-6.4 eap6.x
- jcl-over-slf4j-1.5.11.jar と slf4j-api-1.6.0.jar の組み合わせはアウト。
http://stackoverflow.com/questions/3519978/logging-framework-incompatibility
BRMS 5.3.0 の brms-standalone の war には jcl-over-slf4j-1.6.0.jar が入っているが、brms-standalone/jboss-as/client/drools/ 以下や、 brms-deployable/jboss-brms-engine/binaries/ 以下には jcl-over-slf4j-1.5.11.jar が入っている。
- EAP6でユーザ追加
- bin/add-user.sh -a --user brmsAdmin --password password1! --role ADMIN,kie-user
- bin/add-user.sh -a --user brmsAdmin --password password1! --role admin,analyst,kie-server,rest-all,kiemgmt
- bin/add-user.sh -a --user bpmsAdmin --password password1! --role admin,analyst,kie-server,rest-all,kiemgmt
- Eclipse で一括 sourcepath
=========================
BRMS/BPMS 6 でDB変更
standalone.xml
<subsystem xmlns="urn:jboss:domain:datasources:1.1">
<datasources>
<datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:mysql://localhost:3306/bpms601</connection-url>
<driver>mysql</driver>
<security>
<user-name>mysql</user-name>
<password>mysql</password>
</security>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>business-central.war/WEB-INF/classes/META-INF/persistence.xml
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
business-central.war/WEB-INF/jboss-deployment-structure.xml
dashbuilder.war/WEB-INF/jboss-deployment-structure.xml
<dependencies>
...
<module name="com.mysql" />
</dependencies>
dodeploy
touch jboss-brms.war.dodeploy touch business-central.war.dodeploy touch business-central-server.war.dodeploy touch designer.war.dodeploy touch jbpm-human-task.war.dodeploy
======
BPMS 6 REST deploy
Maven curl -u bpmsAdmin:password1! -X POST http://localhost:8080/business-central/rest/repositories/repository1/projects/project1/maven/install jBPM curl -u bpmsAdmin:password1! -X POST http://localhost:8080/business-central/rest/deployment/org.kie.example:project1:1.0.0-SNAPSHOT/undeploy curl -u bpmsAdmin:password1! -X POST http://localhost:8080/business-central/rest/deployment/org.kie.example:project1:1.0.0-SNAPSHOT/deploy?strategy=PER_PROCESS_INSTANCE curl -u bpmsAdmin:password1! -X POST http://localhost:8080/business-central/rest/deployment/org.kie.example:project1:1.0.0-SNAPSHOT/deploy curl -u bpmsAdmin:password1! -X POST http://localhost:8080/business-central/rest/deployment/com.sample:jbpm-example:1.0.0-SNAPSHOT/deploy curl -u bpmsAdmin:password1! -X GET http://localhost:8080/business-central/rest/runtime/org.kie.example:project1:1.0.0-SNAPSHOT/process/project1.helloProcess (Since BPMS 6.1.0) curl -u bpmsAdmin:password1! -X GET http://localhost:8080/business-central/rest/task/1 curl -u bpmsAdmin:password1! -X POST http://localhost:8080/business-central/rest/runtime/example:project4:1.0.0-SNAPSHOT/process/project4.bp1/start curl -u bpmsAdmin:password1! -X POST http://localhost:8080/business-central/rest/runtime/org.kie.example:project1:1.0.0-SNAPSHOT/process/instance/1/abort
curl -u kieserver:kieserver1! -d @request01.json -H "Content-Type: application/json" -X POST 'http://localhost:8080/kie-server/services/rest/server/containers/instances/DroolsSampleProject_1.0.2-SNAPSHOT'
Controller
curl -u kieserver:kieserver1! -X GET 'http://localhost:8080/business-central/rest/controller/management/servers/default-kie-server/containers' curl -u kieserver:kieserver1! -d @request.xml -H "Content-Type: application/xml" -X PUT 'http://localhost:8080/business-central/rest/controller/management/servers/default-kie-server/containers/org.kie.example:project1:1.0.0-SNAPSHOT'
request.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<container-spec-details>
<container-id>org.kie.example:project1:1.0.0-SNAPSHOT</container-id>
<container-name>org.kie.example:project1:1.0.0-SNAPSHOT</container-name>
<server-template-key>
<server-id>default-kie-server</server-id>
</server-template-key>
<release-id>
<artifact-id>project1</artifact-id>
<group-id>org.kie.example</group-id>
<version>1.0.0-SNAPSHOT</version>
</release-id>
<configs>
<entry>
<key>PROCESS</key>
<value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="processConfig">
<strategy>PerProcessInstance</strategy>
<kie-base-name/>
<kie-session-name/>
<merge-mode>Merge Collections</merge-mode>
</value>
</entry>
<entry>
<key>RULE</key>
<value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ruleConfig">
<scannerStatus>STOPPED</scannerStatus>
</value>
</entry>
</configs>
<status>STARTED</status>
</container-spec-details>======
cluster
export JBOSS_HOME= cd /home/tkobayas/usr/local/BRMS/602/cluster/node1/jboss-bpms-brms-6.0.2.GA-redhat-5-supplementary-tools/zookeeper-3.3.4-redhat-1/bin ./zkServer.sh start cd /home/tkobayas/usr/local/BRMS/602/cluster/node1/jboss-bpms-brms-6.0.2.GA-redhat-5-supplementary-tools/helix-core-0.6.2-incubating-redhat-1/bin ./run-helix-controller.sh --zkSvr localhost:2181 --cluster brms-cluster 2>&1 > /tmp/controller.log & cd /home/tkobayas/usr/local/BRMS/602/cluster/node1/jboss-eap-6.1 bin/domain.sh
BRMS 5.3.1 テーブル
mysql> desc Attachment;
+-------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| accessType | int(11) | YES | | NULL | |
| attachedAt | datetime | YES | | NULL | |
| attachmentContentId | bigint(20) | NO | | NULL | |
| contentType | varchar(255) | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| attachment_size | int(11) | YES | | NULL | |
| attachedBy_id | varchar(255) | YES | MUL | NULL | |
| TaskData_Attachments_Id | bigint(20) | YES | MUL | NULL | |
+-------------------------+--------------+------+-----+---------+----------------+
9 rows in set (0.01 sec)
mysql> desc BooleanExpression;
+---------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| expression | longtext | YES | | NULL | |
| type | varchar(255) | YES | | NULL | |
| Escalation_Constraints_Id | bigint(20) | YES | MUL | NULL | |
+---------------------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> desc Content;
+---------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| content | longblob | YES | | NULL | |
+---------+------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)
mysql> desc Deadline
-> ;
+----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------------+-------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| deadline_date | datetime | YES | | NULL | |
| escalated | smallint(6) | YES | | NULL | |
| Deadlines_StartDeadLine_Id | bigint(20) | YES | MUL | NULL | |
| Deadlines_EndDeadLine_Id | bigint(20) | YES | MUL | NULL | |
+----------------------------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> desc Delegation_delegates;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc Escalation;
+------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | YES | | NULL | |
| Deadline_Escalation_Id | bigint(20) | YES | MUL | NULL | |
+------------------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql> desc EventTypes;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| InstanceId | bigint(20) | NO | MUL | NULL | |
| element | varchar(255) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc I18NText;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| language | varchar(255) | YES | | NULL | |
| shortText | varchar(255) | YES | | NULL | |
| text | longtext | YES | | NULL | |
| Task_Subjects_Id | bigint(20) | YES | MUL | NULL | |
| Task_Names_Id | bigint(20) | YES | MUL | NULL | |
| Task_Descriptions_Id | bigint(20) | YES | MUL | NULL | |
| Reassignment_Documentation_Id | bigint(20) | YES | MUL | NULL | |
| Notification_Subjects_Id | bigint(20) | YES | MUL | NULL | |
| Notification_Names_Id | bigint(20) | YES | MUL | NULL | |
| Notification_Documentation_Id | bigint(20) | YES | MUL | NULL | |
| Notification_Descriptions_Id | bigint(20) | YES | MUL | NULL | |
| Deadline_Documentation_Id | bigint(20) | YES | MUL | NULL | |
+-------------------------------+--------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
mysql> desc NodeInstanceLog;
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| log_date | datetime | YES | | NULL | |
| nodeId | varchar(255) | YES | | NULL | |
| nodeInstanceId | varchar(255) | YES | | NULL | |
| nodeName | varchar(255) | YES | | NULL | |
| processId | varchar(255) | YES | | NULL | |
| processInstanceId | bigint(20) | NO | | NULL | |
| type | int(11) | NO | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
mysql> desc Notification;
+-----------------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+-------------+------+-----+---------+----------------+
| DTYPE | varchar(31) | NO | | NULL | |
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| priority | int(11) | NO | | NULL | |
| Escalation_Notifications_Id | bigint(20) | YES | MUL | NULL | |
+-----------------------------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> desc Notification_BAs;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc Notification_Recipients;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc Notification_email_header;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| Notification_id | bigint(20) | NO | PRI | NULL | |
| emailHeaders_id | bigint(20) | NO | UNI | NULL | |
| mapkey | varchar(255) | NO | PRI | NULL | |
+-----------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> desc OrganizationalEntity;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| DTYPE | varchar(31) | NO | | NULL | |
| id | varchar(255) | NO | PRI | NULL | |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc PeopleAssignments_BAs;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc PeopleAssignments_ExclOwners;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc PeopleAssignments_PotOwners;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc PeopleAssignments_Recipients;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc PeopleAssignments_Stakeholders;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc ProcessInstanceInfo;
+--------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+--------------+------+-----+---------+----------------+
| InstanceId | bigint(20) | NO | PRI | NULL | auto_increment |
| OPTLOCK | int(11) | YES | | NULL | |
| processId | varchar(255) | YES | | NULL | |
| startDate | datetime | YES | | NULL | |
| lastReadDate | datetime | YES | | NULL | |
| lastModificationDate | datetime | YES | | NULL | |
| state | int(11) | NO | | NULL | |
| processInstanceByteArray | longblob | YES | | NULL | |
+--------------------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
mysql> desc ProcessInstanceLog;
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| end_date | datetime | YES | | NULL | |
| processId | varchar(255) | YES | | NULL | |
| processInstanceId | bigint(20) | NO | | NULL | |
| start_date | datetime | YES | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> desc Reassignment;
+-----------------------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| Escalation_Reassignments_Id | bigint(20) | YES | MUL | NULL | |
+-----------------------------+------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> desc Reassignment_potentialOwners;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| task_id | bigint(20) | NO | MUL | NULL | |
| entity_id | varchar(255) | NO | MUL | NULL | |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc SessionInfo;
+----------------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| lastModificationDate | datetime | YES | | NULL | |
| rulesByteArray | longblob | YES | | NULL | |
| startDate | datetime | YES | | NULL | |
| OPTLOCK | int(11) | YES | | NULL | |
+----------------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> desc SubTasksStrategy;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| DTYPE | varchar(100) | NO | | NULL | |
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | YES | | NULL | |
| Task_Id | bigint(20) | YES | MUL | NULL | |
+---------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> desc Task;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| archived | smallint(6) | YES | | NULL | |
| allowedToDelegate | varchar(255) | YES | | NULL | |
| priority | int(11) | NO | | NULL | |
| activationTime | datetime | YES | | NULL | |
| completedOn | datetime | YES | | NULL | |
| createdOn | datetime | YES | | NULL | |
| documentAccessType | int(11) | YES | | NULL | |
| documentContentId | bigint(20) | NO | | NULL | |
| documentType | varchar(255) | YES | | NULL | |
| expirationTime | datetime | YES | | NULL | |
| faultAccessType | int(11) | YES | | NULL | |
| faultContentId | bigint(20) | NO | | NULL | |
| faultName | varchar(255) | YES | | NULL | |
| faultType | varchar(255) | YES | | NULL | |
| outputAccessType | int(11) | YES | | NULL | |
| outputContentId | bigint(20) | NO | | NULL | |
| outputType | varchar(255) | YES | | NULL | |
| parentId | bigint(20) | NO | | NULL | |
| previousStatus | int(11) | YES | | NULL | |
| processId | varchar(255) | YES | | NULL | |
| processInstanceId | bigint(20) | NO | | NULL | |
| processSessionId | int(11) | NO | | NULL | |
| skipable | bit(1) | NO | | NULL | |
| status | varchar(255) | YES | | NULL | |
| workItemId | bigint(20) | NO | | NULL | |
| OPTLOCK | int(11) | YES | | NULL | |
| taskInitiator_id | varchar(255) | YES | MUL | NULL | |
| actualOwner_id | varchar(255) | YES | MUL | NULL | |
| createdBy_id | varchar(255) | YES | MUL | NULL | |
+--------------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)
mysql> desc VariableInstanceLog;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| log_date | datetime | YES | | NULL | |
| processId | varchar(255) | YES | | NULL | |
| processInstanceId | bigint(20) | NO | | NULL | |
| value | varchar(255) | YES | | NULL | |
| variableId | varchar(255) | YES | | NULL | |
| variableInstanceId | varchar(255) | YES | | NULL | |
+--------------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
mysql> desc WorkItemInfo;
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| workItemId | bigint(20) | NO | PRI | NULL | auto_increment |
| creationDate | datetime | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| processInstanceId | bigint(20) | NO | | NULL | |
| state | bigint(20) | NO | | NULL | |
| OPTLOCK | int(11) | YES | | NULL | |
| workItemByteArray | longblob | YES | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
mysql> desc email_header;
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| body | longtext | YES | | NULL | |
| fromAddress | varchar(255) | YES | | NULL | |
| language | varchar(255) | YES | | NULL | |
| replyToAddress | varchar(255) | YES | | NULL | |
| subject | varchar(255) | YES | | NULL | |
+----------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> desc task_comment;
+----------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| addedAt | datetime | YES | | NULL | |
| text | longtext | YES | | NULL | |
| addedBy_id | varchar(255) | YES | MUL | NULL | |
| TaskData_Comments_Id | bigint(20) | YES | MUL | NULL | |
+----------------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
