Hi friends of Drupal,

is there somewhere a document or some information about the database-structure inside Drupal?

I would like to convert from web-app (http://www.web-app.org) and suppose noone has written a conversion tool yet.

Any bits information are valued! :-)

Yours
Dushan

Comments

LuckyOne’s picture

Any bits information are valued! :-)

Well, best way is to download current Drupal version, I guess. You will see .sql files with database structure inside of it. Hope this helps.

Adagio’s picture

You may also be interested in something like DBDesigner?

kbahey’s picture

If you do not want to download, here is the database schema structure directly from a web page, thanks to ViewCVS.
--
Consulting: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

nomore21’s picture

Thanks, folks...

maybe there is a document flying around somwhere, saying: "This belongs there, this belongs there, etc..."

How is the data organised in the "users" and "forum" tables? What are your suggestion on imprting news articles?

Thanks a million! :-)
dushan

Steven’s picture

The database structure can be hard to understand if you don't know the inner workings of Drupal. Users are relatively simple, but the forum uses the taxonomy system for the forum structure, and the node system for content/posts.

Still, there are scripts floating around for conversion from other systems (mambo, postnuke, ...), it is probably best to base yourself on one of these.

--
If you have a problem, please search before posting a question.

Anonymous’s picture

How is the forum type, i.e. container vs. forum defined in the schema. What variable determines that, and in what container is it in?

webapp-1’s picture

Please note that webapp moved to http://www.web-app.net the script has also improved alot since!

Piya’s picture

Hi drupal lovers...

I want to study working of each table in the database of drupal.I have installed a fresh copy of drupal but I cant find how to interrelate these tables..Can anybody help me for this...???