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.
No comments:
Post a Comment