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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
