SBI Company Profile

SBI is now established as the World's leader in licensing of cover version & other music repertoire. We can supply high quality productions on demand for you to license in any territory(s). For many years we have been working closely with the distributors and companies throughout the world as well as supplying some of the biggest independant dance labels, particularly in Asia. We can also supply single productions or compilations for Television, Multimedia, Background Music, Karaoke, Premium Labels or any other purpose. We offer very good terms, a fast response and a quick turn around. SBI now offer over 200,000 recordings. This includes cover versions of every major hit from the 1940's to the present day. Currently we produce around 50 new chart titles every month. SBI has a vast range of DANCE music, MOVIE & SHOW music, NEW AGE music, CHRISTMAS & SPECIAL CONCEPT music, CLASSICAL repertoire, CHILDREN'S music, NON-STOP MEGAMIXES, REMAKES and much more... SBI can produce SPECIAL PRODUCTIONS on request. These include Dance remixes, Megamixes, Instrumental versions, Foreign song translations and anything you care to imagine! SBI can offer it's entire catalogue in KARAOKE format. We can therefore supply a playback version (with no vocal) and a complete vocal guide of each title. SBI can also supply every title in our catalogue in CDG format with on-screen text for karaoke. SBI have over 2000 titles available with video footage and can supply video to ANY title on demand. Array ( [shorturl_link] => Array ( [description] => ShortURL Links Table. [fields] => Array ( [lid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [length] => 22 ) [orig_url] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => ) [created] => Array ( [type] => int [not null] => 1 [default] => 0 ) [remote_ip] => Array ( [type] => varchar [length] => 20 [not null] => [default] => ) ) [indexes] => Array ( [shorturl_orig_url] => Array ( [0] => orig_url ) ) [primary key] => Array ( [0] => lid ) [module] => shorturl [name] => shorturl_link ) [shorturl_access] => Array ( [fields] => Array ( [aid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 ) [url_id] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [length] => 22 ) [url_key] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => ) [remote_ip] => Array ( [type] => varchar [length] => 20 [not null] => 1 [default] => ) [referer] => Array ( [type] => text [not null] => 1 [size] => normal ) [browser] => Array ( [type] => text [not null] => 1 [size] => normal ) [access_time] => Array ( [type] => int [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => aid ) [module] => shorturl [name] => shorturl_access ) [content_node_field] => Array ( [fields] => Array ( [field_name] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => ) [type] => Array ( [type] => varchar [length] => 127 [not null] => 1 [default] => ) [global_settings] => Array ( [type] => text [size] => medium [not null] => 1 [serialize] => 1 ) [required] => Array ( [type] => int [size] => tiny [not null] => 1 [default] => 0 ) [multiple] => Array ( [type] => int [size] => tiny [not null] => 1 [default] => 0 ) [db_storage] => Array ( [type] => int [size] => tiny [not null] => 1 [default] => 1 ) [module] => Array ( [type] => varchar [length] => 127 [not null] => 1 [default] => ) [db_columns] => Array ( [type] => text [size] => medium [not null] => 1 [serialize] => 1 ) [active] => Array ( [type] => int [size] => tiny [not null] => 1 [default] => 0 ) [locked] => Array ( [type] => int [size] => tiny [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => field_name ) [module] => content [name] => content_node_field ) [content_node_field_instance] => Array ( [fields] => Array ( [field_name] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => ) [type_name] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => ) [weight] => Array ( [type] => int [not null] => 1 [default] => 0 ) [label] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => ) [widget_type] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => ) [widget_settings] => Array ( [type] => text [size] => medium [not null] => 1 [serialize] => 1 ) [display_settings] => Array ( [type] => text [size] => medium [not null] => 1 [serialize] => 1 ) [description] => Array ( [type] => text [size] => medium [not null] => 1 ) [widget_module] => Array ( [type] => varchar [length] => 127 [not null] => 1 [default] => ) [widget_active] => Array ( [type] => int [size] => tiny [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => field_name [1] => type_name ) [module] => content [name] => content_node_field_instance ) [cache_content] => Array ( [description] => Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => content [name] => cache_content ) [content_type_contact] => Array ( [fields] => Array ( [vid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [nid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [field_address_value] => Array ( [type] => text [size] => big [not null] => [views] => 1 ) [field_address_format] => Array ( [type] => int [unsigned] => 1 [not null] => [views] => ) [field_telephone_value] => Array ( [type] => text [size] => big [not null] => [views] => 1 ) [field_telephone_format] => Array ( [type] => int [unsigned] => 1 [not null] => [views] => ) [field_fax_value] => Array ( [type] => text [size] => big [not null] => [views] => 1 ) [field_fax_format] => Array ( [type] => int [unsigned] => 1 [not null] => [views] => ) [field_mobile_value] => Array ( [type] => text [size] => big [not null] => [views] => 1 ) [field_mobile_format] => Array ( [type] => int [unsigned] => 1 [not null] => [views] => ) [field_email_email] => Array ( [type] => varchar [length] => 255 [not null] => ) ) [primary key] => Array ( [0] => vid ) [indexes] => Array ( [nid] => Array ( [0] => nid ) ) [content fields] => Array ( [0] => field_address [1] => field_telephone [2] => field_fax [3] => field_mobile [4] => field_email ) [module] => content [name] => content_type_contact ) [date_format_types] => Array ( [description] => For storing configured date format types. [fields] => Array ( [type] => Array ( [description] => The date format type, e.g. medium. [type] => varchar [length] => 200 [not null] => 1 ) [title] => Array ( [description] => The human readable name of the format type. [type] => varchar [length] => 255 [not null] => 1 ) [locked] => Array ( [description] => Whether or not this is a system provided format. [type] => int [size] => tiny [default] => 0 [not null] => 1 ) ) [primary key] => Array ( [0] => type ) [module] => date_api [name] => date_format_types ) [date_formats] => Array ( [description] => For storing configured date formats. [fields] => Array ( [dfid] => Array ( [description] => The date format identifier. [type] => serial [not null] => 1 [unsigned] => 1 ) [format] => Array ( [description] => The date format string. [type] => varchar [length] => 100 [not null] => 1 ) [type] => Array ( [description] => The date format type, e.g. medium. [type] => varchar [length] => 200 [not null] => 1 ) [locked] => Array ( [description] => Whether or not this format can be modified. [type] => int [size] => tiny [default] => 0 [not null] => 1 ) ) [primary key] => Array ( [0] => dfid ) [unique keys] => Array ( [formats] => Array ( [0] => format [1] => type ) ) [module] => date_api [name] => date_formats ) [date_format_locale] => Array ( [description] => For storing configured date formats for each locale. [fields] => Array ( [format] => Array ( [description] => The date format string. [type] => varchar [length] => 100 [not null] => 1 ) [type] => Array ( [description] => The date format type, e.g. medium. [type] => varchar [length] => 200 [not null] => 1 ) [language] => Array ( [description] => A {languages}.language for this format to be used with. [type] => varchar [length] => 12 [not null] => 1 ) ) [primary key] => Array ( [0] => type [1] => language ) [module] => date_api [name] => date_format_locale ) [mollom] => Array ( [description] => Stores Mollom responses for content. [fields] => Array ( [entity] => Array ( [description] => Entity type of the content. [type] => varchar [length] => 32 [not null] => 1 [default] => ) [id] => Array ( [description] => Unique entity ID of the content. [type] => varchar [length] => 32 [not null] => 1 [default] => ) [session_id] => Array ( [description] => Session hash returned by Mollom. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [form_id] => Array ( [description] => The form_id of the form being protected. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [changed] => Array ( [description] => Unix timestamp when the data was changed. [type] => int [not null] => 1 [default] => 0 ) [spam] => Array ( [description] => Text analysis spam check result. [type] => int [size] => tiny [not null] => ) [quality] => Array ( [description] => Text analysis quality check result. [type] => float [size] => tiny [not null] => ) [profanity] => Array ( [description] => Text analysis profanity check result. [type] => float [size] => tiny [not null] => ) [languages] => Array ( [description] => Text analysis language check result. [type] => varchar [length] => 255 [not null] => 1 [default] => ) ) [indexes] => Array ( [session_id] => Array ( [0] => session_id ) ) [primary key] => Array ( [0] => entity [1] => id ) [foreign keys] => Array ( [mollom_form_id] => Array ( [table] => mollom_form [columns] => Array ( [form_id] => form_id ) ) ) [module] => mollom [name] => mollom ) [mollom_form] => Array ( [description] => Stores configuration of forms protected by Mollom. [fields] => Array ( [form_id] => Array ( [description] => The protected form ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [mode] => Array ( [description] => Protection mode for the form. [type] => int [size] => tiny [not null] => 1 [default] => 0 ) [checks] => Array ( [description] => Text analyis checks to perform. [type] => text [not null] => [serialize] => 1 ) [discard] => Array ( [description] => Whether to discard (1) or retain (0) bad posts. [type] => int [size] => tiny [not null] => 1 [default] => 1 ) [enabled_fields] => Array ( [description] => Form elements to analyze. [type] => text [not null] => [serialize] => 1 ) [strictness] => Array ( [description] => Strictness of text analysis checks. [type] => varchar [length] => 8 [not null] => 1 [default] => normal ) [module] => Array ( [description] => Module name owning the form. [type] => varchar [length] => 255 [not null] => 1 [default] => ) ) [primary key] => Array ( [0] => form_id ) [module] => mollom [name] => mollom_form ) [cache_mollom] => Array ( [description] => Cache table for the Mollom module to store information for forms it protects. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => mollom [name] => cache_mollom ) [blocks] => Array ( [description] => Stores block settings, such as region and visibility settings. [fields] => Array ( [bid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique block ID. ) [module] => Array ( [type] => varchar [length] => 64 [not null] => 1 [default] => [description] => The module from which the block originates; for example, 'user' for the Who's Online block, and 'block' for any custom blocks. ) [delta] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => 0 [description] => Unique ID for block within a module. ) [theme] => Array ( [type] => varchar [length] => 64 [not null] => 1 [default] => [description] => The theme under which the block settings apply. ) [status] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Block enabled status. (1 = enabled, 0 = disabled) ) [weight] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Block weight within region. ) [region] => Array ( [type] => varchar [length] => 64 [not null] => 1 [default] => [description] => Theme region within which the block is set. ) [custom] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Flag to indicate how users may control visibility of the block. (0 = Users cannot control, 1 = On by default, but can be hidden, 2 = Hidden by default, but can be shown) ) [throttle] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Flag to indicate whether or not to remove block when website traffic is high. (1 = throttle, 0 = do not throttle) ) [visibility] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Flag to indicate how to show blocks on pages. (0 = Show on all pages except listed pages, 1 = Show only on listed pages, 2 = Use custom PHP code to determine visibility) ) [pages] => Array ( [type] => text [not null] => 1 [description] => Contents of the "Pages" block; contains either a list of paths on which to include/exclude the block or PHP code, depending on "visibility" setting. ) [title] => Array ( [type] => varchar [length] => 64 [not null] => 1 [default] => [description] => Custom title for the block. (Empty string will use block default title, <none> will remove the title, text will cause block to use specified title.) ) [cache] => Array ( [type] => int [not null] => 1 [default] => 1 [size] => tiny [description] => Binary flag to indicate block cache mode. (-1: Do not cache, 1: Cache per role, 2: Cache per user, 4: Cache per page, 8: Block cache global) See BLOCK_CACHE_* constants in block.module for more detailed information. ) ) [primary key] => Array ( [0] => bid ) [unique keys] => Array ( [tmd] => Array ( [0] => theme [1] => module [2] => delta ) ) [indexes] => Array ( [list] => Array ( [0] => theme [1] => status [2] => region [3] => weight [4] => module ) ) [module] => block [name] => blocks ) [blocks_roles] => Array ( [description] => Sets up access permissions for blocks based on user roles [fields] => Array ( [module] => Array ( [type] => varchar [length] => 64 [not null] => 1 [description] => The block's origin module, from {blocks}.module. ) [delta] => Array ( [type] => varchar [length] => 32 [not null] => 1 [description] => The block's unique delta within module, from {blocks}.delta. ) [rid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [description] => The user's role ID from {users_roles}.rid. ) ) [primary key] => Array ( [0] => module [1] => delta [2] => rid ) [indexes] => Array ( [rid] => Array ( [0] => rid ) ) [module] => block [name] => blocks_roles ) [boxes] => Array ( [description] => Stores contents of custom-made blocks. [fields] => Array ( [bid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 [description] => The block's {blocks}.bid. ) [body] => Array ( [type] => text [not null] => [size] => big [description] => Block contents. ) [info] => Array ( [type] => varchar [length] => 128 [not null] => 1 [default] => [description] => Block description. ) [format] => Array ( [type] => int [size] => small [not null] => 1 [default] => 0 [description] => Block body's {filter_formats}.format; for example, 1 = Filtered HTML. ) ) [unique keys] => Array ( [info] => Array ( [0] => info ) ) [primary key] => Array ( [0] => bid ) [module] => block [name] => boxes ) [cache_block] => Array ( [description] => Cache table for the Block module to store already built blocks, identified by module, delta, and various contexts which may change the block, such as theme, locale, and caching mode defined for the block. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => block [name] => cache_block ) [comments] => Array ( [description] => Stores comments and associated data. [fields] => Array ( [cid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique comment ID. ) [pid] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => The {comments}.cid to which this comment is a reply. If set to 0, this comment is not a reply to an existing comment. ) [nid] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => The {node}.nid to which this comment is a reply. ) [uid] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => The {users}.uid who authored the comment. If set to 0, this comment was created by an anonymous user. ) [subject] => Array ( [type] => varchar [length] => 64 [not null] => 1 [default] => [description] => The comment title. ) [comment] => Array ( [type] => text [not null] => 1 [size] => big [description] => The comment body. ) [hostname] => Array ( [type] => varchar [length] => 128 [not null] => 1 [default] => [description] => The author's host name. ) [timestamp] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => The time that the comment was created, or last edited by its author, as a Unix timestamp. ) [status] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny [description] => The published status of a comment. (0 = Published, 1 = Not Published) ) [format] => Array ( [type] => int [size] => small [not null] => 1 [default] => 0 [description] => The {filter_formats}.format of the comment body. ) [thread] => Array ( [type] => varchar [length] => 255 [not null] => 1 [description] => The vancode representation of the comment's place in a thread. ) [name] => Array ( [type] => varchar [length] => 60 [not null] => [description] => The comment author's name. Uses {users}.name if the user is logged in, otherwise uses the value typed into the comment form. ) [mail] => Array ( [type] => varchar [length] => 64 [not null] => [description] => The comment author's e-mail address from the comment form, if user is anonymous, and the 'Anonymous users may/must leave their contact information' setting is turned on. ) [homepage] => Array ( [type] => varchar [length] => 255 [not null] => [description] => The comment author's home page address from the comment form, if user is anonymous, and the 'Anonymous users may/must leave their contact information' setting is turned on. ) ) [indexes] => Array ( [pid] => Array ( [0] => pid ) [nid] => Array ( [0] => nid ) [comment_uid] => Array ( [0] => uid ) [status] => Array ( [0] => status ) ) [primary key] => Array ( [0] => cid ) [module] => comment [name] => comments ) [node_comment_statistics] => Array ( [description] => Maintains statistics of node and comments posts to show "new" and "updated" flags. [fields] => Array ( [nid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {node}.nid for which the statistics are compiled. ) [last_comment_timestamp] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => The Unix timestamp of the last comment that was posted within this node, from {comments}.timestamp. ) [last_comment_name] => Array ( [type] => varchar [length] => 60 [not null] => [description] => The name of the latest author to post a comment on this node, from {comments}.name. ) [last_comment_uid] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => The user ID of the latest author to post a comment on this node, from {comments}.uid. ) [comment_count] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The total number of comments on this node. ) ) [primary key] => Array ( [0] => nid ) [indexes] => Array ( [node_comment_timestamp] => Array ( [0] => last_comment_timestamp ) [comment_count] => Array ( [0] => comment_count ) [last_comment_uid] => Array ( [0] => last_comment_uid ) ) [module] => comment [name] => node_comment_statistics ) [contact] => Array ( [description] => Contact form category settings. [fields] => Array ( [cid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 [description] => Primary Key: Unique category ID. ) [category] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Category name. ) [recipients] => Array ( [type] => text [not null] => 1 [size] => big [description] => Comma-separated list of recipient e-mail addresses. ) [reply] => Array ( [type] => text [not null] => 1 [size] => big [description] => Text of the auto-reply message. ) [weight] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => The category's weight. ) [selected] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Flag to indicate whether or not category is selected by default. (1 = Yes, 0 = No) ) ) [primary key] => Array ( [0] => cid ) [unique keys] => Array ( [category] => Array ( [0] => category ) ) [indexes] => Array ( [list] => Array ( [0] => weight [1] => category ) ) [module] => contact [name] => contact ) [watchdog] => Array ( [description] => Table that contains logs of all system events. [fields] => Array ( [wid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique watchdog event ID. ) [uid] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => The {users}.uid of the user who triggered the event. ) [type] => Array ( [type] => varchar [length] => 16 [not null] => 1 [default] => [description] => Type of log message, for example "user" or "page not found." ) [message] => Array ( [type] => text [not null] => 1 [size] => big [description] => Text of log message to be passed into the t() function. ) [variables] => Array ( [type] => text [not null] => 1 [size] => big [description] => Serialized array of variables that match the message string and that is passed into the t() function. ) [severity] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny [description] => The severity level of the event; ranges from 0 (Emergency) to 7 (Debug) ) [link] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Link to view the result of the event. ) [location] => Array ( [type] => text [not null] => 1 [description] => URL of the origin of the event. ) [referer] => Array ( [type] => text [not null] => [description] => URL of referring page. ) [hostname] => Array ( [type] => varchar [length] => 128 [not null] => 1 [default] => [description] => Hostname of the user who triggered the event. ) [timestamp] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => Unix timestamp of when event occurred. ) ) [primary key] => Array ( [0] => wid ) [indexes] => Array ( [type] => Array ( [0] => type ) ) [module] => dblog [name] => watchdog ) [filters] => Array ( [description] => Table that maps filters (HTML corrector) to input formats (Filtered HTML). [fields] => Array ( [fid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Auto-incrementing filter ID. ) [format] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => Foreign key: The {filter_formats}.format to which this filter is assigned. ) [module] => Array ( [type] => varchar [length] => 64 [not null] => 1 [default] => [description] => The origin module of the filter. ) [delta] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => ID to identify which filter within module is being referenced. ) [weight] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Weight of filter within format. ) ) [primary key] => Array ( [0] => fid ) [unique keys] => Array ( [fmd] => Array ( [0] => format [1] => module [2] => delta ) ) [indexes] => Array ( [list] => Array ( [0] => format [1] => weight [2] => module [3] => delta ) ) [module] => filter [name] => filters ) [filter_formats] => Array ( [description] => Stores input formats: custom groupings of filters, such as Filtered HTML. [fields] => Array ( [format] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique ID for format. ) [name] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Name of the input format (Filtered HTML). ) [roles] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => A comma-separated string of roles; references {role}.rid. ) [cache] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Flag to indicate whether format is cachable. (1 = cachable, 0 = not cachable) ) ) [primary key] => Array ( [0] => format ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [module] => filter [name] => filter_formats ) [cache_filter] => Array ( [description] => Cache table for the Filter module to store already filtered pieces of text, identified by input format and md5 hash of the text. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => filter [name] => cache_filter ) [menu_custom] => Array ( [description] => Holds definitions for top-level custom menus (for example, Primary Links). [fields] => Array ( [menu_name] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => [description] => Primary Key: Unique key for menu. This is used as a block delta so length is 32. ) [title] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Menu title; displayed at top of block. ) [description] => Array ( [type] => text [not null] => [description] => Menu description. ) ) [primary key] => Array ( [0] => menu_name ) [module] => menu [name] => menu_custom ) [node] => Array ( [description] => The base table for nodes. [fields] => Array ( [nid] => Array ( [description] => The primary identifier for a node. [type] => serial [unsigned] => 1 [not null] => 1 ) [vid] => Array ( [description] => The current {node_revisions}.vid version identifier. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [type] => Array ( [description] => The {node_type}.type of this node. [type] => varchar [length] => 32 [not null] => 1 [default] => ) [language] => Array ( [description] => The {languages}.language of this node. [type] => varchar [length] => 12 [not null] => 1 [default] => ) [title] => Array ( [description] => The title of this node, always treated as non-markup plain text. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [uid] => Array ( [description] => The {users}.uid that owns this node; initially, this is the user that created it. [type] => int [not null] => 1 [default] => 0 ) [status] => Array ( [description] => Boolean indicating whether the node is published (visible to non-administrators). [type] => int [not null] => 1 [default] => 1 ) [created] => Array ( [description] => The Unix timestamp when the node was created. [type] => int [not null] => 1 [default] => 0 ) [changed] => Array ( [description] => The Unix timestamp when the node was most recently saved. [type] => int [not null] => 1 [default] => 0 ) [comment] => Array ( [description] => Whether comments are allowed on this node: 0 = no, 1 = read only, 2 = read/write. [type] => int [not null] => 1 [default] => 0 ) [promote] => Array ( [description] => Boolean indicating whether the node should be displayed on the front page. [type] => int [not null] => 1 [default] => 0 ) [moderate] => Array ( [description] => Previously, a boolean indicating whether the node was "in moderation"; mostly no longer used. [type] => int [not null] => 1 [default] => 0 ) [sticky] => Array ( [description] => Boolean indicating whether the node should be displayed at the top of lists in which it appears. [type] => int [not null] => 1 [default] => 0 ) [tnid] => Array ( [description] => The translation set id for this node, which equals the node id of the source post in each set. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [translate] => Array ( [description] => A boolean indicating whether this translation page needs to be updated. [type] => int [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [node_changed] => Array ( [0] => changed ) [node_created] => Array ( [0] => created ) [node_moderate] => Array ( [0] => moderate ) [node_promote_status] => Array ( [0] => promote [1] => status ) [node_status_type] => Array ( [0] => status [1] => type [2] => nid ) [node_title_type] => Array ( [0] => title [1] => Array ( [0] => type [1] => 4 ) ) [node_type] => Array ( [0] => Array ( [0] => type [1] => 4 ) ) [uid] => Array ( [0] => uid ) [tnid] => Array ( [0] => tnid ) [translate] => Array ( [0] => translate ) ) [unique keys] => Array ( [vid] => Array ( [0] => vid ) ) [primary key] => Array ( [0] => nid ) [module] => node [name] => node ) [node_access] => Array ( [description] => Identifies which realm/grant pairs a user must possess in order to view, update, or delete specific nodes. [fields] => Array ( [nid] => Array ( [description] => The {node}.nid this record affects. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [gid] => Array ( [description] => The grant ID a user must possess in the specified realm to gain this row's privileges on the node. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [realm] => Array ( [description] => The realm in which the user must possess the grant ID. Each node access node can define one or more realms. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [grant_view] => Array ( [description] => Boolean indicating whether a user with the realm/grant pair can view this node. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny ) [grant_update] => Array ( [description] => Boolean indicating whether a user with the realm/grant pair can edit this node. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny ) [grant_delete] => Array ( [description] => Boolean indicating whether a user with the realm/grant pair can delete this node. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny ) ) [primary key] => Array ( [0] => nid [1] => gid [2] => realm ) [module] => node [name] => node_access ) [node_counter] => Array ( [description] => Access statistics for {node}s. [fields] => Array ( [nid] => Array ( [description] => The {node}.nid for these statistics. [type] => int [not null] => 1 [default] => 0 ) [totalcount] => Array ( [description] => The total number of times the {node} has been viewed. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => big ) [daycount] => Array ( [description] => The total number of times the {node} has been viewed today. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => medium ) [timestamp] => Array ( [description] => The most recent time the {node} has been viewed. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => nid ) [module] => node [name] => node_counter ) [node_revisions] => Array ( [description] => Stores information about each saved version of a {node}. [fields] => Array ( [nid] => Array ( [description] => The {node} this version belongs to. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [vid] => Array ( [description] => The primary identifier for this version. [type] => serial [unsigned] => 1 [not null] => 1 ) [uid] => Array ( [description] => The {users}.uid that created this version. [type] => int [not null] => 1 [default] => 0 ) [title] => Array ( [description] => The title of this version. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [body] => Array ( [description] => The body of this version. [type] => text [not null] => 1 [size] => big ) [teaser] => Array ( [description] => The teaser of this version. [type] => text [not null] => 1 [size] => big ) [log] => Array ( [description] => The log entry explaining the changes in this version. [type] => text [not null] => 1 [size] => big ) [timestamp] => Array ( [description] => A Unix timestamp indicating when this version was created. [type] => int [not null] => 1 [default] => 0 ) [format] => Array ( [description] => The input format used by this version's body. [type] => int [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [nid] => Array ( [0] => nid ) [uid] => Array ( [0] => uid ) ) [primary key] => Array ( [0] => vid ) [module] => node [name] => node_revisions ) [node_type] => Array ( [description] => Stores information about all defined {node} types. [fields] => Array ( [type] => Array ( [description] => The machine-readable name of this type. [type] => varchar [length] => 32 [not null] => 1 ) [name] => Array ( [description] => The human-readable name of this type. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [module] => Array ( [description] => The base string used to construct callbacks corresponding to this node type. [type] => varchar [length] => 255 [not null] => 1 ) [description] => Array ( [description] => A brief description of this type. [type] => text [not null] => 1 [size] => medium ) [help] => Array ( [description] => Help information shown to the user when creating a {node} of this type. [type] => text [not null] => 1 [size] => medium ) [has_title] => Array ( [description] => Boolean indicating whether this type uses the {node}.title field. [type] => int [unsigned] => 1 [not null] => 1 [size] => tiny ) [title_label] => Array ( [description] => The label displayed for the title field on the edit form. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [has_body] => Array ( [description] => Boolean indicating whether this type uses the {node_revisions}.body field. [type] => int [unsigned] => 1 [not null] => 1 [size] => tiny ) [body_label] => Array ( [description] => The label displayed for the body field on the edit form. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [min_word_count] => Array ( [description] => The minimum number of words the body must contain. [type] => int [unsigned] => 1 [not null] => 1 [size] => small ) [custom] => Array ( [description] => A boolean indicating whether this type is defined by a module (FALSE) or by a user via a module like the Content Construction Kit (TRUE). [type] => int [not null] => 1 [default] => 0 [size] => tiny ) [modified] => Array ( [description] => A boolean indicating whether this type has been modified by an administrator; currently not used in any way. [type] => int [not null] => 1 [default] => 0 [size] => tiny ) [locked] => Array ( [description] => A boolean indicating whether the administrator can change the machine name of this type. [type] => int [not null] => 1 [default] => 0 [size] => tiny ) [orig_type] => Array ( [description] => The original machine-readable name of this node type. This may be different from the current type name if the locked field is 0. [type] => varchar [length] => 255 [not null] => 1 [default] => ) ) [primary key] => Array ( [0] => type ) [module] => node [name] => node_type ) [profile_fields] => Array ( [description] => Stores profile field information. [fields] => Array ( [fid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique profile field ID. ) [title] => Array ( [type] => varchar [length] => 255 [not null] => [description] => Title of the field shown to the end user. ) [name] => Array ( [type] => varchar [length] => 128 [not null] => 1 [default] => [description] => Internal name of the field used in the form HTML and URLs. ) [explanation] => Array ( [type] => text [not null] => [description] => Explanation of the field to end users. ) [category] => Array ( [type] => varchar [length] => 255 [not null] => [description] => Profile category that the field will be grouped under. ) [page] => Array ( [type] => varchar [length] => 255 [not null] => [description] => Title of page used for browsing by the field's value ) [type] => Array ( [type] => varchar [length] => 128 [not null] => [description] => Type of form field. ) [weight] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Weight of field in relation to other profile fields. ) [required] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Whether the user is required to enter a value. (0 = no, 1 = yes) ) [register] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Whether the field is visible in the user registration form. (1 = yes, 0 = no) ) [visibility] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => The level of visibility for the field. (0 = hidden, 1 = private, 2 = public on profile but not member list pages, 3 = public on profile and list pages) ) [autocomplete] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Whether form auto-completion is enabled. (0 = disabled, 1 = enabled) ) [options] => Array ( [type] => text [not null] => [description] => List of options to be used in a list selection field. ) ) [indexes] => Array ( [category] => Array ( [0] => category ) ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [primary key] => Array ( [0] => fid ) [module] => profile [name] => profile_fields ) [profile_values] => Array ( [description] => Stores values for profile fields. [fields] => Array ( [fid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {profile_fields}.fid of the field. ) [uid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {users}.uid of the profile user. ) [value] => Array ( [type] => text [not null] => [description] => The value for the field. ) ) [primary key] => Array ( [0] => uid [1] => fid ) [indexes] => Array ( [fid] => Array ( [0] => fid ) ) [module] => profile [name] => profile_values ) [variable] => Array ( [description] => Named variable/value pairs created by Drupal core or any other module or theme. All variables are cached in memory at the start of every Drupal request so developers should not be careless about what is stored here. [fields] => Array ( [name] => Array ( [description] => The name of the variable. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [value] => Array ( [description] => The value of the variable. [type] => text [not null] => 1 [size] => big ) ) [primary key] => Array ( [0] => name ) [module] => system [name] => variable ) [actions] => Array ( [description] => Stores action information. [fields] => Array ( [aid] => Array ( [description] => Primary Key: Unique actions ID. [type] => varchar [length] => 255 [not null] => 1 [default] => 0 ) [type] => Array ( [description] => The object that that action acts on (node, user, comment, system or custom types.) [type] => varchar [length] => 32 [not null] => 1 [default] => ) [callback] => Array ( [description] => The callback function that executes when the action runs. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [parameters] => Array ( [description] => Parameters to be passed to the callback function. [type] => text [not null] => 1 [size] => big ) [description] => Array ( [description] => Description of the action. [type] => varchar [length] => 255 [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => aid ) [module] => system [name] => actions ) [actions_aid] => Array ( [description] => Stores action IDs for non-default actions. [fields] => Array ( [aid] => Array ( [description] => Primary Key: Unique actions ID. [type] => serial [unsigned] => 1 [not null] => 1 ) ) [primary key] => Array ( [0] => aid ) [module] => system [name] => actions_aid ) [batch] => Array ( [description] => Stores details about batches (processes that run in multiple HTTP requests). [fields] => Array ( [bid] => Array ( [description] => Primary Key: Unique batch ID. [type] => serial [unsigned] => 1 [not null] => 1 ) [token] => Array ( [description] => A string token generated against the current user's session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it. [type] => varchar [length] => 64 [not null] => 1 ) [timestamp] => Array ( [description] => A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time. [type] => int [not null] => 1 ) [batch] => Array ( [description] => A serialized array containing the processing data for the batch. [type] => text [not null] => [size] => big ) ) [primary key] => Array ( [0] => bid ) [indexes] => Array ( [token] => Array ( [0] => token ) ) [module] => system [name] => batch ) [cache] => Array ( [description] => Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => system [name] => cache ) [cache_form] => Array ( [description] => Cache table for the form system to store recently built forms and their storage data, to be used in subsequent page requests. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => system [name] => cache_form ) [cache_page] => Array ( [description] => Cache table used to store compressed pages for anonymous users, if page caching is enabled. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => system [name] => cache_page ) [cache_menu] => Array ( [description] => Cache table for the menu system to store router information as well as generated link trees for various menu/page/user combinations. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => system [name] => cache_menu ) [files] => Array ( [description] => Stores information for uploaded files. [fields] => Array ( [fid] => Array ( [description] => Primary Key: Unique files ID. [type] => serial [unsigned] => 1 [not null] => 1 ) [uid] => Array ( [description] => The {users}.uid of the user who is associated with the file. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [filename] => Array ( [description] => Name of the file. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [filepath] => Array ( [description] => Path of the file relative to Drupal root. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [filemime] => Array ( [description] => The file MIME type. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [filesize] => Array ( [description] => The size of the file in bytes. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [status] => Array ( [description] => A flag indicating whether file is temporary (0) or permanent (1). [type] => int [not null] => 1 [default] => 0 ) [timestamp] => Array ( [description] => UNIX timestamp for when the file was added. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [uid] => Array ( [0] => uid ) [status] => Array ( [0] => status ) [timestamp] => Array ( [0] => timestamp ) ) [primary key] => Array ( [0] => fid ) [module] => system [name] => files ) [flood] => Array ( [description] => Flood controls the threshold of events, such as the number of contact attempts. [fields] => Array ( [fid] => Array ( [description] => Unique flood event ID. [type] => serial [not null] => 1 ) [event] => Array ( [description] => Name of event (e.g. contact). [type] => varchar [length] => 64 [not null] => 1 [default] => ) [hostname] => Array ( [description] => Hostname of the visitor. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [timestamp] => Array ( [description] => Timestamp of the event. [type] => int [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => fid ) [indexes] => Array ( [allow] => Array ( [0] => event [1] => hostname [2] => timestamp ) ) [module] => system [name] => flood ) [history] => Array ( [description] => A record of which {users} have read which {node}s. [fields] => Array ( [uid] => Array ( [description] => The {users}.uid that read the {node} nid. [type] => int [not null] => 1 [default] => 0 ) [nid] => Array ( [description] => The {node}.nid that was read. [type] => int [not null] => 1 [default] => 0 ) [timestamp] => Array ( [description] => The Unix timestamp at which the read occurred. [type] => int [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => uid [1] => nid ) [indexes] => Array ( [nid] => Array ( [0] => nid ) ) [module] => system [name] => history ) [menu_router] => Array ( [description] => Maps paths to various callbacks (access, page and title) [fields] => Array ( [path] => Array ( [description] => Primary Key: the Drupal path this entry describes [type] => varchar [length] => 255 [not null] => 1 [default] => ) [load_functions] => Array ( [description] => A serialized array of function names (like node_load) to be called to load an object corresponding to a part of the current path. [type] => text [not null] => 1 ) [to_arg_functions] => Array ( [description] => A serialized array of function names (like user_uid_optional_to_arg) to be called to replace a part of the router path with another string. [type] => text [not null] => 1 ) [access_callback] => Array ( [description] => The callback which determines the access to this router path. Defaults to user_access. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [access_arguments] => Array ( [description] => A serialized array of arguments for the access callback. [type] => text [not null] => ) [page_callback] => Array ( [description] => The name of the function that renders the page. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [page_arguments] => Array ( [description] => A serialized array of arguments for the page callback. [type] => text [not null] => ) [fit] => Array ( [description] => A numeric representation of how specific the path is. [type] => int [not null] => 1 [default] => 0 ) [number_parts] => Array ( [description] => Number of parts in this router path. [type] => int [not null] => 1 [default] => 0 [size] => small ) [tab_parent] => Array ( [description] => Only for local tasks (tabs) - the router path of the parent page (which may also be a local task). [type] => varchar [length] => 255 [not null] => 1 [default] => ) [tab_root] => Array ( [description] => Router path of the closest non-tab parent page. For pages that are not local tasks, this will be the same as the path. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [title] => Array ( [description] => The title for the current page, or the title for the tab if this is a local task. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [title_callback] => Array ( [description] => A function which will alter the title. Defaults to t() [type] => varchar [length] => 255 [not null] => 1 [default] => ) [title_arguments] => Array ( [description] => A serialized array of arguments for the title callback. If empty, the title will be used as the sole argument for the title callback. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [type] => Array ( [description] => Numeric representation of the type of the menu item, like MENU_LOCAL_TASK. [type] => int [not null] => 1 [default] => 0 ) [block_callback] => Array ( [description] => Name of a function used to render the block on the system administration page for this item. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [description] => Array ( [description] => A description of this item. [type] => text [not null] => 1 ) [position] => Array ( [description] => The position of the block (left or right) on the system administration page for this item. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [weight] => Array ( [description] => Weight of the element. Lighter weights are higher up, heavier weights go down. [type] => int [not null] => 1 [default] => 0 ) [file] => Array ( [description] => The file to include for this element, usually the page callback function lives in this file. [type] => text [size] => medium ) ) [indexes] => Array ( [fit] => Array ( [0] => fit ) [tab_parent] => Array ( [0] => tab_parent ) [tab_root_weight_title] => Array ( [0] => Array ( [0] => tab_root [1] => 64 ) [1] => weight [2] => title ) ) [primary key] => Array ( [0] => path ) [module] => system [name] => menu_router ) [menu_links] => Array ( [description] => Contains the individual links within a menu. [fields] => Array ( [menu_name] => Array ( [description] => The menu name. All links with the same menu name (such as 'navigation') are part of the same menu. [type] => varchar [length] => 32 [not null] => 1 [default] => ) [mlid] => Array ( [description] => The menu link ID (mlid) is the integer primary key. [type] => serial [unsigned] => 1 [not null] => 1 ) [plid] => Array ( [description] => The parent link ID (plid) is the mlid of the link above in the hierarchy, or zero if the link is at the top level in its menu. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [link_path] => Array ( [description] => The Drupal path or external path this link points to. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [router_path] => Array ( [description] => For links corresponding to a Drupal path (external = 0), this connects the link to a {menu_router}.path for joins. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [link_title] => Array ( [description] => The text displayed for the link, which may be modified by a title callback stored in {menu_router}. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [options] => Array ( [description] => A serialized array of options to be passed to the url() or l() function, such as a query string or HTML attributes. [type] => text [not null] => ) [module] => Array ( [description] => The name of the module that generated this link. [type] => varchar [length] => 255 [not null] => 1 [default] => system ) [hidden] => Array ( [description] => A flag for whether the link should be rendered in menus. (1 = a disabled menu item that may be shown on admin screens, -1 = a menu callback, 0 = a normal, visible link) [type] => int [not null] => 1 [default] => 0 [size] => small ) [external] => Array ( [description] => A flag to indicate if the link points to a full URL starting with a protocol, like http:// (1 = external, 0 = internal). [type] => int [not null] => 1 [default] => 0 [size] => small ) [has_children] => Array ( [description] => Flag indicating whether any links have this link as a parent (1 = children exist, 0 = no children). [type] => int [not null] => 1 [default] => 0 [size] => small ) [expanded] => Array ( [description] => Flag for whether this link should be rendered as expanded in menus - expanded links always have their child links displayed, instead of only when the link is in the active trail (1 = expanded, 0 = not expanded) [type] => int [not null] => 1 [default] => 0 [size] => small ) [weight] => Array ( [description] => Link weight among links in the same menu at the same depth. [type] => int [not null] => 1 [default] => 0 ) [depth] => Array ( [description] => The depth relative to the top level. A link with plid == 0 will have depth == 1. [type] => int [not null] => 1 [default] => 0 [size] => small ) [customized] => Array ( [description] => A flag to indicate that the user has manually created or edited the link (1 = customized, 0 = not customized). [type] => int [not null] => 1 [default] => 0 [size] => small ) [p1] => Array ( [description] => The first mlid in the materialized path. If N = depth, then pN must equal the mlid. If depth > 1 then p(N-1) must equal the plid. All pX where X > depth must equal zero. The columns p1 .. p9 are also called the parents. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p2] => Array ( [description] => The second mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p3] => Array ( [description] => The third mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p4] => Array ( [description] => The fourth mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p5] => Array ( [description] => The fifth mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p6] => Array ( [description] => The sixth mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p7] => Array ( [description] => The seventh mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p8] => Array ( [description] => The eighth mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [p9] => Array ( [description] => The ninth mlid in the materialized path. See p1. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [updated] => Array ( [description] => Flag that indicates that this link was generated during the update from Drupal 5. [type] => int [not null] => 1 [default] => 0 [size] => small ) ) [indexes] => Array ( [path_menu] => Array ( [0] => Array ( [0] => link_path [1] => 128 ) [1] => menu_name ) [menu_plid_expand_child] => Array ( [0] => menu_name [1] => plid [2] => expanded [3] => has_children ) [menu_parents] => Array ( [0] => menu_name [1] => p1 [2] => p2 [3] => p3 [4] => p4 [5] => p5 [6] => p6 [7] => p7 [8] => p8 [9] => p9 ) [router_path] => Array ( [0] => Array ( [0] => router_path [1] => 128 ) ) ) [primary key] => Array ( [0] => mlid ) [module] => system [name] => menu_links ) [semaphore] => Array ( [description] => Table for holding semaphores, locks, flags, etc. that cannot be stored as Drupal variables since they must not be cached. [fields] => Array ( [name] => Array ( [description] => Primary Key: Unique name. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [value] => Array ( [description] => A value. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [expire] => Array ( [description] => A Unix timestamp with microseconds indicating when the semaphore should expire. [type] => float [size] => big [not null] => 1 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => name ) [module] => system [name] => semaphore ) [sessions] => Array ( [description] => Drupal's session handlers read and write into the sessions table. Each record represents a user session, either anonymous or authenticated. [fields] => Array ( [uid] => Array ( [description] => The {users}.uid corresponding to a session, or 0 for anonymous user. [type] => int [unsigned] => 1 [not null] => 1 ) [sid] => Array ( [description] => Primary key: A session ID. The value is generated by PHP's Session API. [type] => varchar [length] => 64 [not null] => 1 [default] => ) [hostname] => Array ( [description] => The IP address that last used this session ID (sid). [type] => varchar [length] => 128 [not null] => 1 [default] => ) [timestamp] => Array ( [description] => The Unix timestamp when this session last requested a page. Old records are purged by PHP automatically. [type] => int [not null] => 1 [default] => 0 ) [cache] => Array ( [description] => The time of this user's last post. This is used when the site has specified a minimum_cache_lifetime. See cache_get(). [type] => int [not null] => 1 [default] => 0 ) [session] => Array ( [description] => The serialized contents of $_SESSION, an array of name/value pairs that persists across page requests by this session ID. Drupal loads $_SESSION from here at the start of each request and saves it at the end. [type] => text [not null] => [size] => big ) ) [primary key] => Array ( [0] => sid ) [indexes] => Array ( [timestamp] => Array ( [0] => timestamp ) [uid] => Array ( [0] => uid ) ) [module] => system [name] => sessions ) [system] => Array ( [description] => A list of all modules, themes, and theme engines that are or have been installed in Drupal's file system. [fields] => Array ( [filename] => Array ( [description] => The path of the primary file for this item, relative to the Drupal root; e.g. modules/node/node.module. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [name] => Array ( [description] => The name of the item; e.g. node. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [type] => Array ( [description] => The type of the item, either module, theme, or theme_engine. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [owner] => Array ( [description] => A theme's 'parent'. Can be either a theme or an engine. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [status] => Array ( [description] => Boolean indicating whether or not this item is enabled. [type] => int [not null] => 1 [default] => 0 ) [throttle] => Array ( [description] => Boolean indicating whether this item is disabled when the throttle.module disables throttleable items. [type] => int [not null] => 1 [default] => 0 [size] => tiny ) [bootstrap] => Array ( [description] => Boolean indicating whether this module is loaded during Drupal's early bootstrapping phase (e.g. even before the page cache is consulted). [type] => int [not null] => 1 [default] => 0 ) [schema_version] => Array ( [description] => The module's database schema version number. -1 if the module is not installed (its tables do not exist); 0 or the largest N of the module's hook_update_N() function that has either been run or existed when the module was first installed. [type] => int [not null] => 1 [default] => -1 [size] => small ) [weight] => Array ( [description] => The order in which this module's hooks should be invoked relative to other modules. Equal-weighted modules are ordered by name. [type] => int [not null] => 1 [default] => 0 ) [info] => Array ( [description] => A serialized array containing information from the module's .info file; keys can include name, description, package, version, core, dependencies, dependents, and php. [type] => text [not null] => ) ) [primary key] => Array ( [0] => filename ) [indexes] => Array ( [modules] => Array ( [0] => Array ( [0] => type [1] => 12 ) [1] => status [2] => weight [3] => filename ) [bootstrap] => Array ( [0] => Array ( [0] => type [1] => 12 ) [1] => status [2] => bootstrap [3] => weight [4] => filename ) [type_name] => Array ( [0] => Array ( [0] => type [1] => 12 ) [1] => name ) ) [module] => system [name] => system ) [url_alias] => Array ( [description] => A list of URL aliases for Drupal paths; a user may visit either the source or destination path. [fields] => Array ( [pid] => Array ( [description] => A unique path alias identifier. [type] => serial [unsigned] => 1 [not null] => 1 ) [src] => Array ( [description] => The Drupal path this alias is for; e.g. node/12. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [dst] => Array ( [description] => The alias for this path; e.g. title-of-the-story. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [language] => Array ( [description] => The language this alias is for; if blank, the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language. [type] => varchar [length] => 12 [not null] => 1 [default] => ) ) [unique keys] => Array ( [dst_language_pid] => Array ( [0] => dst [1] => language [2] => pid ) ) [primary key] => Array ( [0] => pid ) [indexes] => Array ( [src_language_pid] => Array ( [0] => src [1] => language [2] => pid ) ) [module] => system [name] => url_alias ) [term_data] => Array ( [description] => Stores term information. [fields] => Array ( [tid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 [description] => Primary Key: Unique term ID. ) [vid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {vocabulary}.vid of the vocabulary to which the term is assigned. ) [name] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => The term name. ) [description] => Array ( [type] => text [not null] => [size] => big [description] => A description of the term. ) [weight] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => The weight of this term in relation to other terms. ) ) [primary key] => Array ( [0] => tid ) [indexes] => Array ( [taxonomy_tree] => Array ( [0] => vid [1] => weight [2] => name ) [vid_name] => Array ( [0] => vid [1] => name ) ) [module] => taxonomy [name] => term_data ) [term_hierarchy] => Array ( [description] => Stores the hierarchical relationship between terms. [fields] => Array ( [tid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: The {term_data}.tid of the term. ) [parent] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: The {term_data}.tid of the term's parent. 0 indicates no parent. ) ) [indexes] => Array ( [parent] => Array ( [0] => parent ) ) [primary key] => Array ( [0] => tid [1] => parent ) [module] => taxonomy [name] => term_hierarchy ) [term_node] => Array ( [description] => Stores the relationship of terms to nodes. [fields] => Array ( [nid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: The {node}.nid of the node. ) [vid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: The {node}.vid of the node. ) [tid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: The {term_data}.tid of a term assigned to the node. ) ) [indexes] => Array ( [vid] => Array ( [0] => vid ) [nid] => Array ( [0] => nid ) ) [primary key] => Array ( [0] => tid [1] => vid ) [module] => taxonomy [name] => term_node ) [term_relation] => Array ( [description] => Stores non-hierarchical relationships between terms. [fields] => Array ( [trid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique term relation ID. ) [tid1] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {term_data}.tid of the first term in a relationship. ) [tid2] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {term_data}.tid of the second term in a relationship. ) ) [unique keys] => Array ( [tid1_tid2] => Array ( [0] => tid1 [1] => tid2 ) ) [indexes] => Array ( [tid2] => Array ( [0] => tid2 ) ) [primary key] => Array ( [0] => trid ) [module] => taxonomy [name] => term_relation ) [term_synonym] => Array ( [description] => Stores term synonyms. [fields] => Array ( [tsid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique term synonym ID. ) [tid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {term_data}.tid of the term. ) [name] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => The name of the synonym. ) ) [indexes] => Array ( [tid] => Array ( [0] => tid ) [name_tid] => Array ( [0] => name [1] => tid ) ) [primary key] => Array ( [0] => tsid ) [module] => taxonomy [name] => term_synonym ) [vocabulary] => Array ( [description] => Stores vocabulary information. [fields] => Array ( [vid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 [description] => Primary Key: Unique vocabulary ID. ) [name] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Name of the vocabulary. ) [description] => Array ( [type] => text [not null] => [size] => big [description] => Description of the vocabulary. ) [help] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Help text to display for the vocabulary. ) [relations] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny [description] => Whether or not related terms are enabled within the vocabulary. (0 = disabled, 1 = enabled) ) [hierarchy] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny [description] => The type of hierarchy allowed within the vocabulary. (0 = disabled, 1 = single, 2 = multiple) ) [multiple] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny [description] => Whether or not multiple terms from this vocabulary may be assigned to a node. (0 = disabled, 1 = enabled) ) [required] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny [description] => Whether or not terms are required for nodes using this vocabulary. (0 = disabled, 1 = enabled) ) [tags] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [size] => tiny [description] => Whether or not free tagging is enabled for the vocabulary. (0 = disabled, 1 = enabled) ) [module] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => The module which created the vocabulary. ) [weight] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => The weight of the vocabulary in relation to other vocabularies. ) ) [primary key] => Array ( [0] => vid ) [indexes] => Array ( [list] => Array ( [0] => weight [1] => name ) ) [module] => taxonomy [name] => vocabulary ) [vocabulary_node_types] => Array ( [description] => Stores which node types vocabularies may be used with. [fields] => Array ( [vid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: the {vocabulary}.vid of the vocabulary. ) [type] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => [description] => The {node}.type of the node type for which the vocabulary may be used. ) ) [primary key] => Array ( [0] => type [1] => vid ) [indexes] => Array ( [vid] => Array ( [0] => vid ) ) [module] => taxonomy [name] => vocabulary_node_types ) [cache_update] => Array ( [description] => Cache table for the Update module to store information about available releases, fetched from central server. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => update [name] => cache_update ) [access] => Array ( [description] => Stores site access rules. [fields] => Array ( [aid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique access ID. ) [mask] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Text mask used for filtering access. ) [type] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Type of access rule: name, mail or host. ) [status] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Whether rule is to allow(1) or deny(0) access. ) ) [primary key] => Array ( [0] => aid ) [module] => user [name] => access ) [authmap] => Array ( [description] => Stores distributed authentication mapping. [fields] => Array ( [aid] => Array ( [description] => Primary Key: Unique authmap ID. [type] => serial [unsigned] => 1 [not null] => 1 ) [uid] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => User's {users}.uid. ) [authname] => Array ( [type] => varchar [length] => 128 [not null] => 1 [default] => [description] => Unique authentication name. ) [module] => Array ( [type] => varchar [length] => 128 [not null] => 1 [default] => [description] => Module which is controlling the authentication. ) ) [unique keys] => Array ( [authname] => Array ( [0] => authname ) ) [primary key] => Array ( [0] => aid ) [module] => user [name] => authmap ) [permission] => Array ( [description] => Stores permissions for users. [fields] => Array ( [pid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique permission ID. ) [rid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The {role}.rid to which the permissions are assigned. ) [perm] => Array ( [type] => text [not null] => [size] => big [description] => List of permissions being assigned. ) [tid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Originally intended for taxonomy-based permissions, but never used. ) ) [primary key] => Array ( [0] => pid ) [indexes] => Array ( [rid] => Array ( [0] => rid ) ) [module] => user [name] => permission ) [role] => Array ( [description] => Stores user roles. [fields] => Array ( [rid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 [description] => Primary Key: Unique role id. ) [name] => Array ( [type] => varchar [length] => 64 [not null] => 1 [default] => [description] => Unique role name. ) ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [primary key] => Array ( [0] => rid ) [module] => user [name] => role ) [users] => Array ( [description] => Stores user data. [fields] => Array ( [uid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 [description] => Primary Key: Unique user ID. ) [name] => Array ( [type] => varchar [length] => 60 [not null] => 1 [default] => [description] => Unique user name. ) [pass] => Array ( [type] => varchar [length] => 32 [not null] => 1 [default] => [description] => User's password (md5 hash). ) [mail] => Array ( [type] => varchar [length] => 64 [not null] => [default] => [description] => User's email address. ) [mode] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Per-user comment display mode (threaded vs. flat), used by the {comment} module. ) [sort] => Array ( [type] => int [not null] => [default] => 0 [size] => tiny [description] => Per-user comment sort order (newest vs. oldest first), used by the {comment} module. ) [threshold] => Array ( [type] => int [not null] => [default] => 0 [size] => tiny [description] => Previously used by the {comment} module for per-user preferences; no longer used. ) [theme] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => User's default theme. ) [signature] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => User's signature. ) [signature_format] => Array ( [type] => int [size] => small [not null] => 1 [default] => 0 [description] => The {filter_formats}.format of the signature. ) [created] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => Timestamp for when user was created. ) [access] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => Timestamp for previous time user accessed the site. ) [login] => Array ( [type] => int [not null] => 1 [default] => 0 [description] => Timestamp for user's last login. ) [status] => Array ( [type] => int [not null] => 1 [default] => 0 [size] => tiny [description] => Whether the user is active(1) or blocked(0). ) [timezone] => Array ( [type] => varchar [length] => 8 [not null] => [description] => User's timezone. ) [language] => Array ( [type] => varchar [length] => 12 [not null] => 1 [default] => [description] => User's default language. ) [picture] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => [description] => Path to the user's uploaded picture. ) [init] => Array ( [type] => varchar [length] => 64 [not null] => [default] => [description] => Email address used for initial account creation. ) [data] => Array ( [type] => text [not null] => [size] => big [description] => A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future version of Drupal. ) [timezone_name] => Array ( [type] => varchar [length] => 50 [not null] => 1 [default] => [description] => Per-user timezone name. ) ) [indexes] => Array ( [access] => Array ( [0] => access ) [created] => Array ( [0] => created ) [mail] => Array ( [0] => mail ) ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [primary key] => Array ( [0] => uid ) [module] => user [name] => users ) [users_roles] => Array ( [description] => Maps users to roles. [fields] => Array ( [uid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: {users}.uid for user. ) [rid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => Primary Key: {role}.rid for role. ) ) [primary key] => Array ( [0] => uid [1] => rid ) [indexes] => Array ( [rid] => Array ( [0] => rid ) ) [module] => user [name] => users_roles ) [captcha_points] => Array ( [description] => This table describes which challenges should be added to which forms. [export] => Array ( [key] => form_id [identifier] => captcha [default hook] => captcha_default_points [status] => mark_status [api] => Array ( [owner] => captcha [api] => captcha [minimum_version] => 1 [current_version] => 1 ) ) [fields] => Array ( [form_id] => Array ( [description] => The form_id of the form to add a CAPTCHA to. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [module] => Array ( [description] => The module that provides the challenge. [type] => varchar [length] => 64 ) [captcha_type] => Array ( [description] => The challenge type to use. [type] => varchar [length] => 64 ) ) [primary key] => Array ( [0] => form_id ) [module] => captcha [name] => captcha_points ) [captcha_sessions] => Array ( [description] => Stores the data about CAPTCHA sessions (solution, IP address, timestamp, ...). [fields] => Array ( [csid] => Array ( [description] => CAPTCHA session ID. [type] => serial [not null] => 1 ) [token] => Array ( [description] => One time CAPTCHA token. [type] => varchar [length] => 64 [not null] => ) [uid] => Array ( [description] => User's {users}.uid. [type] => int [not null] => 1 [default] => 0 ) [sid] => Array ( [description] => Session ID of the user. [type] => varchar [length] => 64 [not null] => 1 [default] => ) [ip_address] => Array ( [description] => IP address of the visitor. [type] => varchar [length] => 128 [not null] => ) [timestamp] => Array ( [description] => A Unix timestamp indicating when the challenge was generated. [type] => int [not null] => 1 [default] => 0 ) [form_id] => Array ( [description] => The form_id of the form where the CAPTCHA is added to. [type] => varchar [length] => 128 [not null] => 1 ) [solution] => Array ( [description] => Solution of the challenge. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [status] => Array ( [description] => Status of the CAPTCHA session (unsolved, solved, ...) [type] => int [not null] => 1 [default] => 0 ) [attempts] => Array ( [description] => The number of attempts. [type] => int [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => csid ) [indexes] => Array ( [csid_ip] => Array ( [0] => csid [1] => ip_address ) ) [module] => captcha [name] => captcha_sessions ) [ctools_object_cache] => Array ( [description] => A special cache used to store objects that are being edited; it serves to save state in an ordinarily stateless environment. [fields] => Array ( [sid] => Array ( [type] => varchar [length] => 64 [not null] => 1 [description] => The session ID this cache object belongs to. ) [name] => Array ( [type] => varchar [length] => 128 [not null] => 1 [description] => The name of the object this cache is attached to. ) [obj] => Array ( [type] => varchar [length] => 32 [not null] => 1 [description] => The type of the object this cache is attached to; this essentially represents the owner so that several sub-systems can use this cache. ) [updated] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The time this cache was created or updated. ) [data] => Array ( [type] => text [size] => big [description] => Serialized data being stored. [serialize] => 1 ) ) [primary key] => Array ( [0] => sid [1] => obj [2] => name ) [indexes] => Array ( [updated] => Array ( [0] => updated ) ) [module] => ctools [name] => ctools_object_cache ) [ctools_css_cache] => Array ( [description] => A special cache used to store CSS that must be non-volatile. [fields] => Array ( [cid] => Array ( [type] => varchar [length] => 128 [description] => The CSS ID this cache object belongs to. [not null] => 1 ) [filename] => Array ( [type] => varchar [length] => 255 [description] => The filename this CSS is stored in. ) [css] => Array ( [type] => text [size] => big [description] => CSS being stored. [serialize] => 1 ) [filter] => Array ( [type] => int [size] => tiny [description] => Whether or not this CSS needs to be filtered. ) ) [primary key] => Array ( [0] => cid ) [module] => ctools [name] => ctools_css_cache ) [currencyapi] => Array ( [description] => Table to cache currency rates that have been looked up by the Currency API module. [fields] => Array ( [currency_from] => Array ( [description] => ISO 4217 3-character currency code for destination currency, as a character string. [type] => varchar [length] => 10 [not null] => 1 [default] => ) [currency_to] => Array ( [description] => ISO 4217 3-character currency code for destination currency, as a character string. [type] => varchar [length] => 10 [not null] => 1 [default] => ) [rate] => Array ( [description] => Conversion rate, currency_to per currency_from, as a floating point number. [type] => float [size] => normal [not null] => 1 [default] => 0 ) [timestamp] => Array ( [description] => The time that the conversion rate was created, or last edited by its author, as a Unix timestamp. [type] => int [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => currency_from [1] => currency_to ) [module] => currency_api [name] => currencyapi ) [ip2cc] => Array ( [description] => TODO [fields] => Array ( [ip_from] => Array ( [description] => TODO [type] => float [size] => big [not null] => 1 [default] => 0 ) [ip_to] => Array ( [description] => TODO [type] => float [size] => big [not null] => 1 [default] => 0 ) [country_code] => Array ( [description] => TODO [type] => char [length] => 2 [not null] => 1 ) [net_name] => Array ( [description] => TODO [type] => varchar [length] => 128 [not null] => 1 ) [as_number] => Array ( [description] => TODO [type] => int [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => ip_from [1] => ip_to ) [module] => ip2cc [name] => ip2cc ) [nodewords] => Array ( [description] => The table containing the meta tag values for all the pages. [fields] => Array ( [mtid] => Array ( [description] => The primary key. [type] => serial [not null] => 1 ) [type] => Array ( [description] => The type of object to which the meta tag refers (node, user, page, etc...). [type] => int [size] => small [unsigned] => 1 [not null] => 1 [default] => 0 ) [id] => Array ( [description] => The object ID. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [name] => Array ( [description] => The meta tag name. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [content] => Array ( [description] => The content of the meta tag. [type] => text [size] => big [not null] => 1 ) ) [indexes] => Array ( [nodewords_name] => Array ( [0] => Array ( [0] => name [1] => 6 ) ) [nodewords_type_id] => Array ( [0] => type [1] => id ) ) [unique keys] => Array ( [nodewords_type_id_name] => Array ( [0] => type [1] => id [2] => name ) ) [primary key] => Array ( [0] => mtid ) [module] => nodewords [name] => nodewords ) [nodewords_custom] => Array ( [description] => The table containing data for custom pages. [fields] => Array ( [pid] => Array ( [description] => The primary key. [type] => serial [not null] => 1 ) [name] => Array ( [description] => The page name as shown in the list of custom pages. [type] => varchar [length] => 128 [not null] => 1 [default] => ) [path] => Array ( [description] => The page path. [type] => text [size] => medium [not null] => 1 ) [weight] => Array ( [description] => The weight of the page. [type] => int [size] => small [not null] => 1 [default] => 0 ) [enabled] => Array ( [description] => A flag set when the page is enabled. [type] => int [size] => small [unsigned] => 1 [not null] => 1 [default] => 1 ) ) [primary key] => Array ( [0] => pid ) [module] => nodewords [name] => nodewords_custom ) [page_title] => Array ( [fields] => Array ( [type] => Array ( [type] => varchar [length] => 15 [not null] => 1 [default] => node ) [id] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [page_title] => Array ( [type] => varchar [length] => 255 [not null] => 1 [default] => ) ) [primary key] => Array ( [0] => type [1] => id ) [module] => page_title [name] => page_title ) [panels_display] => Array ( [export] => Array ( [object] => panels_display [bulk export] => [export callback] => panels_export_display [can disable] => [identifier] => display ) [fields] => Array ( [did] => Array ( [type] => serial [not null] => 1 [no export] => 1 ) [layout] => Array ( [type] => varchar [length] => 255 [default] => ) [layout_settings] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [panel_settings] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [cache] => Array ( [type] => text [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [title] => Array ( [type] => varchar [length] => 255 [default] => ) [hide_title] => Array ( [type] => int [size] => tiny [default] => 0 [no export] => 1 ) [title_pane] => Array ( [type] => int [default] => 0 [no export] => 1 ) ) [primary key] => Array ( [0] => did ) [module] => panels [name] => panels_display ) [panels_pane] => Array ( [export] => Array ( [can disable] => [identifier] => pane [bulk export] => ) [fields] => Array ( [pid] => Array ( [type] => serial [not null] => 1 ) [did] => Array ( [type] => int [not null] => 1 [default] => 0 [no export] => 1 ) [panel] => Array ( [type] => varchar [length] => 32 [default] => ) [type] => Array ( [type] => varchar [length] => 32 [default] => ) [subtype] => Array ( [type] => varchar [length] => 64 [default] => ) [shown] => Array ( [type] => int [size] => tiny [default] => 1 ) [access] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [configuration] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [cache] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [style] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [css] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [extras] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [initial ] => Array ( ) ) [position] => Array ( [type] => int [size] => small [default] => 0 ) ) [primary key] => Array ( [0] => pid ) [indexes] => Array ( [did_idx] => Array ( [0] => did ) ) [module] => panels [name] => panels_pane ) [panels_renderer_pipeline] => Array ( [description] => Contains renderer pipelines for Panels. Each pipeline contains one or more renderers and access rules to select which renderer gets used. [export] => Array ( [identifier] => pipeline [bulk export] => 1 [primary key] => rpid [api] => Array ( [owner] => panels [api] => pipelines [minimum_version] => 1 [current_version] => 1 ) ) [fields] => Array ( [rpid] => Array ( [type] => serial [description] => A database primary key to ensure uniqueness. [not null] => 1 [no export] => 1 ) [name] => Array ( [type] => varchar [length] => 255 [description] => Unique ID for this content. Used to identify it programmatically. ) [admin_title] => Array ( [type] => varchar [length] => 255 [description] => Administrative title for this pipeline. ) [admin_description] => Array ( [type] => text [size] => big [description] => Administrative description for this pipeline. [object default] => ) [weight] => Array ( [type] => int [size] => small [default] => 0 ) [settings] => Array ( [type] => text [size] => big [description] => Serialized settings for the actual pipeline. The contents of this field are up to the plugin that uses it. [serialize] => 1 [object default] => Array ( ) ) ) [primary key] => Array ( [0] => rpid ) [module] => panels [name] => panels_renderer_pipeline ) [panels_layout] => Array ( [description] => Contains exportable customized layouts for this site. [export] => Array ( [identifier] => layout [bulk export] => 1 [primary key] => lid [api] => Array ( [owner] => panels [api] => layouts [minimum_version] => 1 [current_version] => 1 ) ) [fields] => Array ( [lid] => Array ( [type] => serial [description] => A database primary key to ensure uniqueness. [not null] => 1 [no export] => 1 ) [name] => Array ( [type] => varchar [length] => 255 [description] => Unique ID for this content. Used to identify it programmatically. ) [admin_title] => Array ( [type] => varchar [length] => 255 [description] => Administrative title for this layout. ) [admin_description] => Array ( [type] => text [size] => big [description] => Administrative description for this layout. [object default] => ) [category] => Array ( [type] => varchar [length] => 255 [description] => Administrative category for this layout. ) [plugin] => Array ( [type] => varchar [length] => 255 [description] => The layout plugin that owns this layout. ) [settings] => Array ( [type] => text [size] => big [description] => Serialized settings for the actual layout. The contents of this field are up to the plugin that uses it. [serialize] => 1 [object default] => Array ( ) ) ) [primary key] => Array ( [0] => lid ) [module] => panels [name] => panels_layout ) [panels_mini] => Array ( [export] => Array ( [identifier] => mini [load callback] => panels_mini_load [load all callback] => panels_mini_load_all [save callback] => panels_mini_save [delete callback] => panels_mini_delete [export callback] => panels_mini_export [api] => Array ( [owner] => panels_mini [api] => panels_default [minimum_version] => 1 [current_version] => 1 ) ) [fields] => Array ( [pid] => Array ( [type] => serial [not null] => 1 [no export] => 1 [description] => The primary key for uniqueness. ) [name] => Array ( [type] => varchar [length] => 255 [description] => The unique name of the mini panel. ) [category] => Array ( [type] => varchar [length] => 64 [description] => The category this mini panel appears in on the add content pane. ) [did] => Array ( [type] => int [no export] => 1 [description] => The display ID of the panel. ) [admin_title] => Array ( [type] => varchar [length] => 128 [description] => The administrative title of the mini panel. ) [admin_description] => Array ( [type] => text [size] => big [description] => Administrative title of this mini panel. [object default] => ) [requiredcontexts] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [description] => An array of required contexts. ) [contexts] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [description] => An array of contexts embedded into the panel. ) [relationships] => Array ( [type] => text [size] => big [serialize] => 1 [object default] => Array ( ) [description] => An array of relationships embedded into the panel. ) ) [primary key] => Array ( [0] => pid ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [module] => panels_mini [name] => panels_mini ) [path_redirect] => Array ( [description] => Stores information on redirects. [fields] => Array ( [rid] => Array ( [type] => serial [not null] => 1 [description] => Primary Key: Unique path redirect ID. ) [source] => Array ( [type] => varchar [length] => 255 [not null] => 1 [description] => The source path to redirect from. ) [redirect] => Array ( [type] => varchar [length] => 255 [not null] => 1 [description] => The destination path to redirect to. ) [query] => Array ( [type] => varchar [length] => 255 [not null] => [description] => The query string to send to the destination. ) [fragment] => Array ( [type] => varchar [length] => 50 [not null] => [description] => An internal page anchor append to the destination. ) [language] => Array ( [description] => The language this redirect is for; if blank, the alias will be used for unknown languages. [type] => varchar [length] => 12 [not null] => 1 [default] => ) [type] => Array ( [type] => int [size] => small [not null] => 1 [description] => The HTTP status code to use for the redirect. ) [last_used] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The timestamp of when the redirect was last used. ) ) [primary key] => Array ( [0] => rid ) [unique keys] => Array ( [source_language] => Array ( [0] => source [1] => language ) ) [module] => path_redirect [name] => path_redirect ) [xmlsitemap] => Array ( [description] => The base table for xmlsitemap links. [fields] => Array ( [id] => Array ( [description] => Primary key with type; a unique id for the item. [type] => int [not null] => 1 [unsigned] => 1 [default] => 0 ) [type] => Array ( [description] => Primary key with id; the type of item (e.g. node, user, etc.). [type] => varchar [length] => 32 [not null] => 1 [default] => ) [subtype] => Array ( [description] => A sub-type identifier for the link (node type, menu name, term VID, etc.). [type] => varchar [length] => 128 [not null] => 1 [default] => ) [loc] => Array ( [description] => The URL to the item relative to the Drupal path. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [language] => Array ( [description] => The {languages}.language of this link or an empty string if it is language-neutral. [type] => varchar [length] => 12 [not null] => 1 [default] => ) [access] => Array ( [description] => A boolean that represents if the item is viewable by the anonymous user. This field is useful to store the result of node_access() so we can retain changefreq and priority_override information. [type] => int [size] => tiny [not null] => 1 [default] => 1 ) [status] => Array ( [description] => An integer that represents if the item is included in the sitemap. [type] => int [size] => tiny [not null] => 1 [default] => 1 ) [status_override] => Array ( [description] => A boolean that if TRUE means that the status field has been overridden from its default value. [type] => int [size] => tiny [not null] => 1 [default] => 0 ) [lastmod] => Array ( [description] => The UNIX timestamp of last modification of the item. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [priority] => Array ( [description] => The priority of this URL relative to other URLs on your site. Valid values range from 0.0 to 1.0. [type] => float [default] => ) [priority_override] => Array ( [description] => A boolean that if TRUE means that the priority field has been overridden from its default value. [type] => int [size] => tiny [not null] => 1 [default] => 0 ) [changefreq] => Array ( [description] => The average time in seconds between changes of this item. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [changecount] => Array ( [description] => The number of times this item has been changed. Used to help calculate the next changefreq value. [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => id [1] => type ) [indexes] => Array ( [loc] => Array ( [0] => loc ) [access_status_loc] => Array ( [0] => access [1] => status [2] => loc ) [type_subtype] => Array ( [0] => type [1] => subtype ) [language] => Array ( [0] => language ) ) [module] => xmlsitemap [name] => xmlsitemap ) [xmlsitemap_sitemap] => Array ( [fields] => Array ( [smid] => Array ( [description] => The sitemap ID (the hashed value of {xmlsitemap}.context. [type] => varchar [length] => 64 [not null] => 1 ) [context] => Array ( [description] => Serialized array with the sitemaps context [type] => text [not null] => 1 [serialize] => 1 ) [updated] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [links] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [chunks] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) [max_filesize] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 ) ) [primary key] => Array ( [0] => smid ) [module] => xmlsitemap [name] => xmlsitemap_sitemap ) [views_view] => Array ( [description] => Stores the general data for a view. [fields] => Array ( [vid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 [description] => The view ID of the field, defined by the database. [no export] => 1 ) [name] => Array ( [type] => varchar [length] => 32 [default] => [not null] => 1 [description] => The unique name of the view. This is the primary field views are loaded from, and is used so that views may be internal and not necessarily in the database. May only be alphanumeric characters plus underscores. ) [description] => Array ( [type] => varchar [length] => 255 [default] => [description] => A description of the view for the admin interface. ) [tag] => Array ( [type] => varchar [length] => 255 [default] => [description] => A tag used to group/sort views in the admin interface ) [base_table] => Array ( [type] => varchar [length] => 64 [default] => [not null] => 1 [description] => What table this view is based on, such as node, user, comment, or term. ) [core] => Array ( [type] => int [default] => 0 [description] => Stores the drupal core version of the view. ) ) [primary key] => Array ( [0] => vid ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [module] => views [name] => views_view ) [views_display] => Array ( [description] => Stores information about each display attached to a view. [fields] => Array ( [vid] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The view this display is attached to. [no export] => 1 ) [id] => Array ( [type] => varchar [length] => 64 [default] => [not null] => 1 [description] => An identifier for this display; usually generated from the display_plugin, so should be something like page or page_1 or block_2, etc. ) [display_title] => Array ( [type] => varchar [length] => 64 [default] => [not null] => 1 [description] => The title of the display, viewable by the administrator. ) [display_plugin] => Array ( [type] => varchar [length] => 64 [default] => [not null] => 1 [description] => The type of the display. Usually page, block or embed, but is pluggable so may be other things. ) [position] => Array ( [type] => int [default] => 0 [description] => The order in which this display is loaded. ) [display_options] => Array ( [type] => text [size] => big [description] => A serialized array of options for this display; it contains options that are generally only pertinent to that display plugin type. [serialize] => 1 [serialized default] => a:0:{} ) ) [indexes] => Array ( [vid] => Array ( [0] => vid [1] => position ) ) [primary key] => Array ( [0] => vid [1] => id ) [module] => views [name] => views_display ) [cache_views] => Array ( [description] => Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 0 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => views [name] => cache_views ) [views_object_cache] => Array ( [description] => A special cache used to store objects that are being edited; it serves to save state in an ordinarily stateless environment. [fields] => Array ( [sid] => Array ( [type] => varchar [length] => 64 [description] => The session ID this cache object belongs to. ) [name] => Array ( [type] => varchar [length] => 32 [description] => The name of the view this cache is attached to. ) [obj] => Array ( [type] => varchar [length] => 32 [description] => The name of the object this cache is attached to; this essentially represents the owner so that several sub-systems can use this cache. ) [updated] => Array ( [type] => int [unsigned] => 1 [not null] => 1 [default] => 0 [description] => The time this cache was created or updated. ) [data] => Array ( [type] => text [description] => Serialized data being stored. [serialize] => 1 [size] => big ) ) [indexes] => Array ( [sid_obj_name] => Array ( [0] => sid [1] => obj [2] => name ) [updated] => Array ( [0] => updated ) ) [module] => views [name] => views_object_cache ) [cache_views_data] => Array ( [description] => Cache table for views to store pre-rendered queries, results, and display output. [fields] => Array ( [cid] => Array ( [description] => Primary Key: Unique cache ID. [type] => varchar [length] => 255 [not null] => 1 [default] => ) [data] => Array ( [description] => A collection of data to cache. [type] => blob [not null] => [size] => big ) [expire] => Array ( [description] => A Unix timestamp indicating when the cache entry should expire, or 0 for never. [type] => int [not null] => 1 [default] => 0 ) [created] => Array ( [description] => A Unix timestamp indicating when the cache entry was created. [type] => int [not null] => 1 [default] => 0 ) [headers] => Array ( [description] => Any custom HTTP headers to be added to cached data. [type] => text [not null] => ) [serialized] => Array ( [description] => A flag to indicate whether content is serialized (1) or not (0). [type] => int [size] => small [not null] => 1 [default] => 1 ) ) [indexes] => Array ( [expire] => Array ( [0] => expire ) ) [primary key] => Array ( [0] => cid ) [module] => views [name] => cache_views_data ) [panels_node] => Array ( [fields] => Array ( [nid] => Array ( [type] => int [not null] => 1 [default] => 0 ) [css_id] => Array ( [type] => varchar [length] => 255 ) [did] => Array ( [type] => int [not null] => 1 ) [pipeline] => Array ( [type] => varchar [length] => 255 ) ) [primary key] => Array ( [0] => did ) [module] => panels_node [name] => panels_node ) [page_manager_handlers] => Array ( [export] => Array ( [identifier] => handler [bulk export] => 1 [export callback] => page_manager_export_task_handler [primary key] => did [api] => Array ( [owner] => page_manager [api] => pages_default [minimum_version] => 1 [current_version] => 1 ) ) [fields] => Array ( [did] => Array ( [type] => serial [not null] => 1 [description] => Primary ID field for the table. Not used for anything except internal lookups. [no export] => 1 ) [name] => Array ( [type] => varchar [length] => 255 [description] => Unique ID for this task handler. Used to identify it programmatically. ) [task] => Array ( [type] => varchar [length] => 64 [description] => ID of the task this handler is for. ) [subtask] => Array ( [type] => varchar [length] => 64 [description] => ID of the subtask this handler is for. [not null] => 1 [default] => ) [handler] => Array ( [type] => varchar [length] => 64 [description] => ID of the task handler being used. ) [weight] => Array ( [type] => int [description] => The order in which this handler appears. Lower numbers go first. ) [conf] => Array ( [type] => text [size] => big [description] => Serialized configuration of the handler, if needed. [not null] => 1 [serialize] => 1 [object default] => Array ( ) ) ) [primary key] => Array ( [0] => did ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [indexes] => Array ( [fulltask] => Array ( [0] => task [1] => subtask [2] => weight ) ) [module] => page_manager [name] => page_manager_handlers ) [page_manager_weights] => Array ( [description] => Contains override weights for page_manager handlers that are in code. [fields] => Array ( [name] => Array ( [type] => varchar [length] => 255 [description] => Unique ID for this task handler. Used to identify it programmatically. [not null] => 1 [default] => ) [weight] => Array ( [type] => int [description] => The order in which this handler appears. Lower numbers go first. ) ) [primary key] => Array ( [0] => name ) [indexes] => Array ( [weights] => Array ( [0] => name [1] => weight ) ) [module] => page_manager [name] => page_manager_weights ) [page_manager_pages] => Array ( [description] => Contains page subtasks for implementing pages with arbitrary tasks. [export] => Array ( [identifier] => page [bulk export] => 1 [export callback] => page_manager_page_export [api] => Array ( [owner] => page_manager [api] => pages_default [minimum_version] => 1 [current_version] => 1 ) ) [fields] => Array ( [pid] => Array ( [type] => serial [not null] => 1 [description] => Primary ID field for the table. Not used for anything except internal lookups. [no export] => 1 ) [name] => Array ( [type] => varchar [length] => 255 [description] => Unique ID for this subtask. Used to identify it programmatically. ) [task] => Array ( [type] => varchar [length] => 64 [description] => What type of page this is, so that we can use the same mechanism for creating tighter UIs for targeted pages. [default] => page ) [admin_title] => Array ( [type] => varchar [length] => 255 [description] => Human readable title for this page subtask. ) [admin_description] => Array ( [type] => text [size] => big [description] => Administrative description of this item. [object default] => ) [path] => Array ( [type] => varchar [length] => 255 [description] => The menu path that will invoke this task. ) [access] => Array ( [type] => text [size] => big [description] => Access configuration for this path. [not null] => 1 [serialize] => 1 [object default] => Array ( ) ) [menu] => Array ( [type] => text [size] => big [description] => Serialized configuration of Drupal menu visibility settings for this item. [not null] => 1 [serialize] => 1 [object default] => Array ( ) ) [arguments] => Array ( [type] => text [size] => big [description] => Configuration of arguments for this menu item. [not null] => 1 [serialize] => 1 [object default] => Array ( ) ) [conf] => Array ( [type] => text [size] => big [description] => Serialized configuration of the page, if needed. [not null] => 1 [serialize] => 1 [object default] => Array ( ) ) ) [primary key] => Array ( [0] => pid ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) [indexes] => Array ( [task] => Array ( [0] => task ) ) [module] => page_manager [name] => page_manager_pages ) )

SBI Registered Office

SBI Global Limited
249 Cranbrook Road
Ilford
Essex
IG1 4TG
United Kingdom

REGISTERED IN ENGLAND No. 2959700



SBI GLOBAL GROUP COMPANIES
SBI GLOBAL LIMITED
United Kingdom
SBI GROUP ASIA LTD.
Thailand
SBI KTV ASIA Co., Ltd.
Thailand
SBI Abraxa Holdings Co., Ltd.
Thailand

SBI Group Departments

This is the website for global licensing and corporate company information. We have other websites that may cater for your specific requirements:

SBI Karaoke

Are you looking for karaoke discs or downloads? SBI Karaoke is the solution to all your karaoke licensing needs. more...

SBI Performance Licensing

Are you looking for backing tracks for professional performance? SBI Performance Licensing caters for professional singers with a huge catalogue of backing tracks. more...

Search our catalogue

You can use title, artist, movie or show names together if you wish (eg. "beatles love me do"), or even just part of the full name you are looking for.
You can search for a title in a specific year. If you want to see ALL titles available for a certain year, leave the Title/Artist field empty and simply enter the year here.