Thursday, June 20, 2013

Drupal 7 major database differences

I found some major differences in Drupal 7 database with Drupal 6 as described below in short:

Database 

  • Master/slave concept may be used for more than one databases
  • By default engine: Innodb

Cache 

  • There are more tables like cache_bootstrap, cache_field, cache_image, cache_update.

Comment 

  • New column "language"
  • Field API concept has been used

Field

  • field_config - The field_config table stores field configuration information.
  • field_config_instance -The field_config_instance table stores field configuration information.
  • field_data_body - The field_data_body table stores details about the body field of an entity.
  • field_revision_body - The field_revision_body table stores information about revisions to body fields.

Flood 

  • flood - The flood table controls the threshold of events, such as the number of contact attempts.
  • expiration int - New column  "Expiration timestamp, expired events are purged on cron run.

Files

  • files_managed - The files_managed table stores information about uploaded files.
  • file_usage - The file_usage table stores information for tracking where a file is used.

Images

  • image_styles  - The image_styles table stores configuration options for image styles.
  • image_effects  - The table stores configuration options for image effects.

Node

  • node - node table is almost same
  • field api concept has been used.

Session

  • ssid - New column in "session" table : Secure session ID; the value is generated by PHP’s Session API.
Taxonomy
  • Some difference in name of tables only 
  • field api concept has been used.

User

  • init - A field in "users" table saves E-mail address used for initial account creation
  • field api concept has been used.

Request: If any developer find any other major difference, please comment. 

No comments: