When creating a Page record, there's a "Published" checkbox. Where is that bit stored in the database?

Comments

styro’s picture

it is the status field in the node table.

--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal

Rotwang’s picture

Is there documentation of where each of the fields end up in the database?

pwolanin’s picture

for D6 install the schema module

For D5, not really complete, see for some: http://drupal.org/node/22754

---
Work: BioRAFT

styro’s picture

I don't really keep up with the current state of the docs - it might be documented now but I'm not aware of it.

But for the most part, Drupals schema is pretty easy to just figure out by looking at it. Anything that doesn't make sense usually does after having a search for tables/fields in the source code.

I don't mean that to sound like a cop out answer - even if it was documented there is still the issue of whether or not the docs were up to date or accurate (the schema does change a bit from version to version). A quick browse of the database and/or code will always at least reflect how your current site works.

--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal