[#24059] - [4.0] Prepare Database for checked_out in workflow tables
- Fixed in Code Base
- 24 Sep 2019
- Medium
- Build: 4.0-dev
- # 24059
- Diff
- chmst:workflow-database-checkedout
- Success continuous-integration/travis-ci/pr The Travis CI build passed Details
- Success continuous-integration/appveyor/pr AppVeyor build succeeded Details
- Success continuous-integration/drone/pr the build was successful Details
- Pending JTracker/HumanTestResults Human Test Results: 1 Successful 0 Failed. Details
User tests: Successful: Unsuccessful:
This pr adds the fields checked_out and checked_out_time to the workflow tables.
If this is done, the views of the workflow component can use the checked_out functions as other components.
Testing Instructions
Install a new application and inspect tables: workflows, workflow_stages and workflow_transitions.
Everything should work as before.
NOTE: I could test only the mysql database Would be great if I get help with testing the postgres part.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | SQL Administration com_admin Postgresql Installation |
| Title |
|
||||||
| Title |
|
||||||
@amitranjan2 you are right, there are also DEFAULT '0'. But this is not in scope of this PR, it is better you make an extra PR for this.
| Labels |
Added:
?
|
||
@amitranjan2 you are right, there are also DEFAULT '0'. But this is not in scope of this PR, it is better you make an extra PR for this.
Okay
I have tested this item
After applying the patch and installing Joomla! 4.0.0-alpha8-dev again I have the new columns checked_out and checked_out_time on the workflow tables.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24059.
on pgsql side seem's fine to me
I have tested this item
Tested it on mysql
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24059.
@drmenzelit can you please retest?
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24059.
| Status | Pending | ⇒ | Ready to Commit |
Status "Ready To Commit".
| Labels |
Added:
?
|
||
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-09-24 10:13:20 |
| Closed_By | ⇒ | wilsonge |
Thankyou!
joomla-cms/administrator/components/com_admin/sql/updates/mysql/4.0.0-2018-06-06.sql
Line 5 in 1bda2b3
DEFAULT should be numeric 1
Please look at Line 6 also