The artefact_plans_plan and artefact_plans_task tables should not have auto increment on artefact column

Bug #1881978 reported by Robert Lyon
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Medium
Robert Lyon

Bug Description

The artefact_plans_plan and artefact_plans_task tables are for holding extra information about plan or task artefacts and so they should be given the artefact id value from the artefact table. In fact they are foreign keyed to the artefact table.
They should not auto increment an id themselves as that makes no sense.

We need to drop the auto increment from these tables.

Revision history for this message
Robert Lyon (robertl-9) wrote :

This problem was discovered when trying to migrate one site to another

description: updated
Changed in mahara:
assignee: nobody → Robert Lyon (robertl-9)
importance: Undecided → Medium
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/11003

Changed in mahara:
milestone: none → 20.10.0
status: New → In Progress
Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/11003
Committed: https://git.mahara.org/mahara/mahara/commit/202e4679742a95a487fe402adcd65496ad1e7e2f
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit 202e4679742a95a487fe402adcd65496ad1e7e2f
Author: Robert Lyon <email address hidden>
Date: Thu Jun 4 12:10:08 2020 +1200

Bug 1881978: Removing sequence on db columns that should not have them

As they have a foreign key to a sequence field on another table

Change-Id: I3851cda3b951ef7bbe9165a2f968d6b8fc863537
Signed-off-by: Robert Lyon <email address hidden>

Robert Lyon (robertl-9)
Changed in mahara:
status: In Progress → Fix Committed
Robert Lyon (robertl-9)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.