By mendobiz on

Hi Everyone,

I know that "newbieness" is a tiring state for everyone concerned, but simple questions sometimes need to be asked. I went through my site but could not find where Drupal stores the page, book, and story files.

Can someone direct me?

Thank you so much in advance!

-Mendobiz

⋅ Categories: Drupal 5.x

Comments

yelvington’s picture

yelvington commented

All nodes, all users and user profiles, all information OTHER than attached files (images, for example) are stored in the database.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

Nodes are stored in the "node" and "node_revisions" tables. Information about book pages parents is stored in the "book" table. Comments are stored in the "comments" table. Users are stored in the "users" and "profile_values" table. Taxonomies user several tables that begin with "term". Any others you want to know about?

Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database

NancyDru

vmira27’s picture

vmira27 commented

OK, the name of a node is stored on node tables but where is stored the content of a node?

For example, I have the following node: www.mysite.com/my_home, where my_home is a page which contain a link to a picture with my home and a short description as text: "My house is white".

Where (in what database or what file) I can find the link to that picture and that text?

Thank you!

Grumot’s picture

Grumot commented

Hi, concerning the text (body) it seems that we can find it in the table node_revisions...
http://drupal.org/node/70591
concerning the picture, I don't know. It's probably depending on what module you use?

edit: after having read it again, it seems that I havn't understood the question so well, have I? ;)
sorry for the out-of-the-topic answer

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

The node table contains current information, such as the current title, user ID, promoted and status flags, etc. The node table uses a node id (nid) and version id (vid) to point to the node_revisions table. That table contains the actual content in a column called "body" and the teaser in a column called "teaser." If the image was included with a simple IMG tag, then the HTML is part of the body. If it is included by another module (e.g. Image) then it is probably included elsewhere and there is an additional table that contains that information.

NancyDru