MyBB Community Forums › 1.8 Support › General Support v
Tables without primary key

Threaded Mode
Not Solved Tables without primary key
jimski Offline
Posts: 33
Threads: 6
Joined: Aug 2016
Reputation: 0
#1
Not Solved 2016-08-11, 10:36 PM
Looks like default installation of MyBB creates multiple tables without primary key. 

Is this a good database design practice ?
Find
Reply
Josh H. Offline

Former Staff
Posts: 3,791
Threads: 80
Joined: May 2011
Reputation: 94
#2
Not Solved 2016-08-12, 01:03 AM
(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.
PGP Key (Fingerprint: 23B6 F4C0 FE2D 45AA 61A0 1E86 DB87 09DC DD87 6E40)
Website Find
Reply
jimski Offline
Posts: 33
Threads: 6
Joined: Aug 2016
Reputation: 0
#3
Not Solved 2016-08-12, 08:44 AM (This post was last modified: 2016-08-12, 09:40 AM by jimski.)
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
Find
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)