List of all tables in phpbb2 DB

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Registered User
Posts: 30
Joined: Sun Jun 08, 2008 10:08 am

List of all tables in phpbb2 DB

Post by helpfinder »

Hi Masters,
please can you present here list of all tables belong to phpbb2 database?
I know after installing some MODs there can be different number of tables like without this MODs.
I need basic tables list (after installing basic phpbb2) and then tables which are created if forum is using attachment MOD.

Thanx a lot for a quick answer.


User avatar
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric

Re: List of all tables in phpbb2 DB

Post by ric323 »

If you look in the full installation files, in ./install/schemas/mysql_schema.sql
you will see all the tables used by a standard phpBB installation.

There is no way to get a list of all possible MOD database additions, there are thousands.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions


Return to “[2.0.x] Convertors”