Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Ask? official ER-Diagram of myBB-DB
#1
Smile 
Hello,

is there any official ER-Diagram of myBB-DB available? myBB uses the MyISAM engine, which does not support foreign keys. Thus you cannot able reverse engineer the relations among tables automatically. The developers of the myBB must have one - but where to find it?
#2
I'm not sure there is actually an ER Diagram at all. The relationships are fairly simple though:

User has 0 to many posts
User has 0 to many threads
Threads have 1 to many posts
Forums have 0 to many threads
Posts have 0 to many attachments

etc.
#3
thanks for the explanation .... i really appreciate it Smile
#4
Quote:myBB uses the MyISAM engine, which does not support foreign keys.
Convert your tables to UTF-8 from the Admin CP.
Looking for people who actively play or DM Dungeons & Dragons.
Please PM me, working on a secret project ^^.
#5
(05-02-2012, 12:23 PM)Ansem Wrote:
Quote:myBB uses the MyISAM engine, which does not support foreign keys.
Convert your tables to UTF-8 from the Admin CP.

The database engine isn't the same thing as the database encoding.
No longer involved in the MyBB project.
#6
i tried but it didn't work ....
#7
If them being MyISAM is the issue, you can aways convert to InnoDB. InnoDB supports foreign keys.
No longer involved in the MyBB project.
#8
could u please tell me how ??
#9
http://community.mybb.com/thread-99805.html

You'd have to run that query replacing mybb_users with each table name, respectively.
No longer involved in the MyBB project.
#10
when i tried to convert mybb_post into innoDB, an error accured.
it said #1214 - The used table type doesn't support FULLTEXT indexes ...

what should I do?


Forum Jump:


Users browsing this thread: 1 Guest(s)