+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: Tables without primary key (/thread-197387.html)
Tables without primary key - jimski - 2016-08-11
Looks like default installation of MyBB creates multiple tables without primary key.
Is this a good database design practice ?
RE: Tables without primary key - Josh H. - 2016-08-12
(2016-08-11, 10:36 PM)jimski Wrote: Looks like default installation of MyBB creates multiple tables without primary key.
Is this a good database design practice ?
Generally no, but we're avoiding significant database changes at this point in the software's lifecycle (stability > tiny performance bumps, especially when our QA group is as small as it is at the moment), and trying to get 2.0 prepared, which will actually use indexes properly.
RE: Tables without primary key - jimski - 2016-08-12
Understood, I look forward to 2.0.
Implementing primary keys will also help with pg_admin because currently pg_admin will not allow editing any fields in tables without primary keys so a developer who would like to extent MyBB on Postgres will have to install yet another tool just to edit the database.
Thanks