Схема таблиц БД drupal 7.15

Drupal 7.15 (v 0.61 / 94)

accesslog [statistics]
- aid (serial)
- sid (varchar 128)
- title (varchar 255)
- path (varchar 255)
- url (text)
- hostname (varchar 128)
- uid (int)
- timer (int)
- timestamp (int)
index
- PRIMARY
- accesslog_timestamp
- uid

actions [system]
- aid (varchar 255)
- type (varchar 32)
- callback (varchar 255)
- parameters (blob)
- label (varchar 255)
index
- PRIMARY

aggregator_category [aggregator]
- cid (serial)
- title (varchar 255)
- description (text)
- block (int)
index
- PRIMARY
- title

aggregator_category_feed [aggregator]
- fid (int)
- cid (int)
index
- PRIMARY
- fid

aggregator_category_item [aggregator]
- iid (int)
- cid (int)
index
- PRIMARY
- fid

aggregator_feed [aggregator]
- fid (serial)
- title (varchar 255)
- url (varchar 255)
- refresh (int)
- checked (int)
- queued (int)
- link (varchar 255)
- description (text)
- image (text)
- hash (varchar 64)
- etag (varchar 255)
- modified (int)
- block (int)
index
- PRIMARY
- url
- title
- queued

aggregator_item [aggregator]
- iid (serial)
- fid (int)
- title (varchar 255)
- link (varchar 255)
- author (varchar 255)
- description (text)
- timestamp (int)
- guid (varchar 255)
index
- PRIMARY
- fid

authmap [user]
- aid (serial)
- uid (int)
- authname (varchar 128)
- module (varchar 128)
index
- PRIMARY
- authname

batch [systems]
- bid (int)
- token (varchar 64)
- timestamp (int)
- batch (blob)
index
- PRIMARY
- token

block [block]
- bid (serial)
- module (varchar 64)
- delta (varchar 32)
- theme (varchar 64)
- status (int)
- weight (int)
- region (varchar 64)
- custom (int)
- visibility (int)
- pages (text)
- title (varchar 64)
- cache (int)
index
- PRIMARY
- tmd
- list

block_custom [block]
- bid (serial)
- body (text)
- info (varchar 128)
- format (varchar 255)
index
- PRIMARY
- info

block_node_type [node]
- module (varchar 64)
- delta (varchar 32)
- type (varchar 32)
index
- PRIMARY
- type

block_role [block]
- module (varchar 64)
- delta (varchar 32)
- rid (int)
index
- PRIMARY
- rid

blocked_ips [system]
- iid (serial)
- ip (varchar 40)
index
- PRIMARY
- ip

book [book]
- mlid (int)
- nid (int)
- bid (int)
index
- PRIMARY
- nid
- bid

cache_block [block]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_bootstrap [system]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_field [field]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_filter [filter]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_form [system]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_image [image]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_menu [system]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_page [system]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_path [system]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

cache_update [update]
- cid (varchar 255)
- data (blob)
- expire (int)
- created (int)
- serialized (int)
index
- PRIMARY
- expire

comment [comment]
- cid (serial)
- pid (int)
- nid (ind)
- uid (int)
- subject (varchar 64)
- hostname (varchar 128)
- created (int)
- changed (int)
- status (int)
- thread (varchar 255)
- name (varchar 60)
- mail (varchar 64)
- homepage (varchar 255)
- language (varchar 12)
index
- PRIMARY
- comment_status_pid
- comment_num_new
- comment_uid
- comment_nid_language
- comment_created

contact [contact]
- cid (serial)
- category (varchar 255)
- recipients (text)
- reply (text)
- weight (int)
- selected (int)
index
- PRIMARY
- category
- list

date_format_locale [system]
- format (varchar 100)
- type (varchar 64)
- language (varchar 12)
index
- PRIMARY

date_format_type [system]
- type (varchar 64)
- title (varchar 255)
- locked (int)
index
- PRIMARY
- title

date_formats [system]
- dfid (serial)
- format (varchar 100)
- type (varchar 64)
- locked (int)
index
- PRIMARY
- formats

field_config [field]
- id (serial)
- field_name (varchar 32)
- type (varchar 128)
- module (varchar 128)
- active (int)
- storage_type (varchar 128)
- storage_module (varchar 128)
- storage_active (int)
- locked (int)
- data (blob)
- cardinality (int)
- translatable (int)
- deleted (int)
index
- PRIMARY
- field_name
- active
- storage_active
- deleted
- module
- storage_module
- type
- storage_type

field_config_instance [field]
- id (serial)
- field_id (int)
- field_name (varchar 32)
- entity_type (varchar 32)
- bundle (varchar 128)
- data (blob)
- deleted (int)
index
- PRIMARY
- field_name_bundle
- deleted

field_data_body []
- entity_type (varchar 128)
- bundle (varchar 128)
- deleted (int)
- entity_id (int)
- revision_id (int)
- language (varchar 32)
- delta (int)
- body_value (text)
- body_summary (text)
- body_format (varchar 255)
index
- PRIMARY
- entity_type
- bundle
- deleted
- entity_id
- revision_id
- language
- body_format

field_data_comment_body []
- entity_type (varchar 128)
- bundle (varchar 128)
- deleted (int)
- entity_id (int)
- revision_id (int)
- language (varchar 32)
- delta (int)
- comment_body_value (text)
- comment_body_format (varchar 255)
index
- PRIMARY
- entity_type
- bundle
- deleted
- entity_id
- revision_id
- language
- comment_body_format

field_data_taxonomy_forums []
- entity_type (varchar 128)
- bundle (varchar 128)
- deleted (int)
- entity_id (int)
- revision_id (int)
- language (varchar 32)
- delta (int)
- taxonomy_forums_tid (int)
index
- PRIMARY
- entity_type
- bundle
- deleted
- entity_id
- revision_id
- language
- comment_body_format

field_revision_body []
- entity_type (varchar 128)
- bundle (varchar 128)
- deleted (int)
- entity_id (int)
- revision_id (int)
- language (varchar 32)
- delta (int)
- body_value (text)
- body_summary (text)
- body_format (varchar 255)
index
- PRIMARY
- entity_type
- bundle
- deleted
- entity_id
- revision_id
- language
- body_format

field_revision_comment_body []
- entity_type (varchar 128)
- bundle (varchar 128)
- deleted (int)
- entity_id (int)
- revision_id (int)
- language (varchar 32)
- delta (int)
- comment_body_value (text)
- comment_body_format (varchar 255)
index
- PRIMARY
- entity_type
- bundle
- deleted
- entity_id
- revision_id
- language
- comment_body_format

field_revision_taxonomy_forums []
- entity_type (varchar 128)
- bundle (varchar 128)
- deleted (int)
- entity_id (int)
- revision_id (int)
- language (varchar 32)
- delta (int)
- delta (int)
- taxonomy_forums_tid (int)
index
- PRIMARY
- entity_type
- bundle
- deleted
- entity_id
- revision_id
- language
- comment_body_format

file_managed [system]
- fid (serial)
- uid (int)
- filename (varchar 255)
- uri (varchar 255)
- filemime (varchar 255)
- filesize (int)
- status (int)
- timestamp (int)
index
- PRIMARY
- uri
- uid
- status
- timestamp

file_usage [system]
- fid (int)
- module (varchar 255)
- type (varchar 64)
- id (int)
- count (int)
index
- PRIMARY
- type_id
- fid_count
- fid_module

filter [filter]
- format (varchar 255)
- module (varchar 64)
- name (varchar 32)
- weight (int)
- status (int)
- settings (blob)
index
- PRIMARY
- list

filter_format [filter]
- format (varchar 255)
- name (varchar 255)
- cache (int)
- status (int)
- weight (int)
index
- PRIMARY
- name
- status, weight

flood [system]
- fid (serial)
- event (varchar 64)
- identifier (varchar 128)
- timestamp (int)
- expiration (int)
index
- PRIMARY
- allow
- purge

forum [forum]
- nid (int)
- vid (int)
- tid (int)
index
- PRIMARY
- forum_topic
- tid

forum_index [forum]
- nid (int)
- title (voarchar 255)
- tid (int)
- sticky (int)
- created (int)
- last_comment_timestamp (int)
- comment_count (int)
index
- forum_topic
- created
- last_comment_timestamp

history [node]
- uid (int)
- nid (int)
- timestamp (int)
index
- PRIMARY
- nid

image_effects [image]
- ieid (serial)
- isid (int)
- weight (int)
- name (varchar 255)
- data (blob)
index
- PRIMARY
- isid
- weight

image_styles [image]
- isid (serial)
- name (varchar 255)
index
- PRIMARY
- name

languages [locale]
- language (varchar 12)
- name (varchar 64)
- native (varchar 64)
- direction (int)
- enabled (int)
- plurals (int)
- formula (varchar 128)
- domain (varchar 128)
- prefix (varchar 128)
- weight (int)
- javascript (varchar 64)
index
- PRIMARY
- list

locales_source [locale]
- lid (serial)
- location (text)
- textgroup (varchar 255)
- source (blob)
- context (varchar 255)
- version (varchar 20)
index
- PRIMARY
- source_context

locales_target [locales]
- lid (int)
- translation (blob)
- language (varchar 12)
- plid (int)
- plural (int)
index
- PRIMARY
- lid
- plid
- plural

menu_custom [menu]
- description (varchar 32)
- fields (varchar 32)
- title (text)
index
- PRIMARY

menu_link [system]
- menu_name (varchar 32)
- mlid (int)
- plid (int)
- link_path (varchar 255)
- router_path (varchar 255)
- link_title (varchar 255)
- options (blob)
- module (varchar 255)
- hidden (int)
- external (int)
- has_children (int)
- expanded (int)
- weight (int)
- depth (int)
- customized (int)
- p1 (int)
- p2 (int)
- p3 (int)
- p4 (int)
- p5 (int)
- p6 (int)
- p7 (int)
- p8 (int)
- p9 (int)
- updated (int)
index
- PRIMARY
- path_menu
- menu_plid_expand_child
- menu_parents
- router_path

menu_router [susyem]
- path (varchar)
- load_functions (blob)
- to_arg_functions (blob)
- access_callback (varchar 255)
- access_arguments (blob)
- page_callback (varchar 255)
- page_arguments (blob)
- delivery_callback (varchar 255)
- fit (int)
- number_parts (int)
- context (int)
- tab_parent (varchar 255)
- tab_root (varchar 255)
- title (varchar 255)
- title_callback (varchar 255)
- title_arguments (varchar 255)
- theme_callback (varchar 255)
- theme_arguments (varchar 255)
- type (int)
- description (text)
- position (varchar 255)
- weight (int)
- include_file (text)
index
- PRIMARY
- fit
- tab_parent
- tab_root_weight_title

node [node]
- nid (serial)
- vid (int)
- type (varchar 32)
- language (varchar 12)
- title (varchar 255)
- uid (int)
- status (int)
- created (int)
- changed (int)
- comment (int)
- promote (int)
- sticky (int)
- tnid (int)
- translate (int)
index
- PRIMARY
- vid
- node_changed
- node_created
- node_frontpage
- node_status_type
- node_title_type
- node_type
- uid
- tnid
- translate

node_access [node]
- nid (int)
- gid (int)
- realm (varchar 255)
- grant_view (int)
- grant_update (int)
- grant_delete (int)
index
- PRIMARY

node_comment_statistics [comment]
- nid (int)
- cid (int)
- last_comment_timestamp (int)
- last_comment_name (varchar 60)
- last_comment_uid (int)
- comment_count (int)
index
- PRIMARY
- node_comment_timestamp
- comment_count
- last_comment_uid

node_counter [statistics]
- nid (int)
- totalcount (int)
- daycount (int)
- timestamp (int)
index
- PRIMARY

node_revision [node]
- nid (int)
- vid (int)
- uid (int)
- title (varchar 255)
- log (text)
- timestamp (int)
- status (int)
- comment (int)
- promote (int)
- sticky (int)
index
- PRIMARY
- nid
- uid

node_type [node]
- type (varchar 32)
- name (varchar 255)
- base (varchar 255)
- module (varchar 255)
- description (text)
- help (text)
- has_title (int)
- title_label (varchar 255)
- custom (int)
- modified (int)
- locked (int)
- disabled (int)
- orig_type (varchar 255)
index
- PRIMARY

openid_association []
- (int)

openid_nonce []
- (int)

poll []
- (int)

poll_choice []
- (int)

poll_vote []
- (int)

queue []
- (int)

rdf_mapping []
- (int)

registry []
- (int)

registry_file []
- (int)

role []
- (int)

role_permission []
- (int)

search_dataset []
- (int)

search_index []
- (int)

search_node_links []
- (int)

search_total []
- (int)

semaphore []
- (int)

sequences []
- (int)

sessions []
- (int)

shortcut_set []
- (int)

shortcut_set_users []
- (int)

system []
- (int)

taxonomy_index []
- (int)

taxonomy_term_data []
- tid (int)

taxonomy_term_hierarchy []
- (int)

taxonomy_vocabulary []
- (int)

tracker_node []
- (int)

tracker_user []
- (int)

trigger_assignments []
- (int)

url_alias []
- (int)

users [user]
- uid (int)
- name (varchar 60)
- pass (varchar 128)
- mail (varchar 254)
- theme (varchar 255)
- signature (varchar 255)
- created (int)
- access (int)
- login (int)
- status (int)
- ...

users_role [user]
- rid (int)
- ...

variable [system]
- description (varchar 128)
- value (blob)

watchdog []
- (int)