mahara-contributors team mailing list archive

[Robert Lyon <1881978@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: Medium
     Assignee: Robert Lyon (robertl-9)
         Status: New

** Description changed:

- 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 and not auto
- increment one themselves as they potentially could get out of sync.
+ 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.

** Changed in: mahara
     Assignee: (unassigned) => Robert Lyon (robertl-9)

** Changed in: mahara
   Importance: Undecided => Medium

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1881978

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

Status in Mahara:
  New

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1881978/+subscriptions