** Summary changed:
- missing primary keys
+ Add "ID" surrogate key column to "view_access" table
** Changed in: mahara
Status: In Progress => Fix Committed
--
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/845948
Title:
Add "ID" surrogate key column to "view_access" table
Status in Mahara:
Fix Committed
Bug description:
It seems during the installation of Mahara several tables are created
without primary keys. This caused a headache for us when restoring
tables from a pg_dump script, duplicate records were created.
Specifically the table 'blocktype_installed_category', caused
duplicate block types in the UI (confusing some users). A further
check revealed the following tables also missing primary keys:
artefact_log
view_access
view_visit
blocktype_installed_category
Version: 1.4.0
Database: Postgres
OS: Linux/RHEL
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/845948/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
