archive-nl.com » NL » N » NEDERDEV.NL

Total: 306

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Meet me at | Nederdev
    expire or 0 for never s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 created a 4 s 11 description s 61 A Unix timestamp indicating when the cache entry was created s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 headers a 3 s 11 description s 51 Any custom HTTP headers to be added to cached data s 4 type s 4 text s 8 not null b 0 s 10 serialized a 5 s 11 description s 64 A flag to indicate whether content is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 91 Whether or not related terms are enabled

    Original URL path: http://nederdev.nl/meet-me?destination=node%2F83 (2016-01-29)
    Open archived version from archive


  • Programme Drupal DevRoom @ FOSDEM | Nederdev
    is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 91 Whether or not related terms are enabled within the vocabulary 0 disabled 1 enabled s 9 hierarchy a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 93 The type of hierarchy allowed within the vocabulary 0 disabled 1 single 2 multiple s 8 multiple a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 105 Whether or not multiple terms from this vocabulary may be

    Original URL path: http://nederdev.nl/blog/programme-drupal-devroom-fosdem?destination=node%2F70 (2016-01-29)
    Open archived version from archive

  • Drupal is 1337! | Nederdev
    description s 79 A Unix timestamp indicating when the cache entry should expire or 0 for never s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 created a 4 s 11 description s 61 A Unix timestamp indicating when the cache entry was created s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 headers a 3 s 11 description s 51 Any custom HTTP headers to be added to cached data s 4 type s 4 text s 8 not null b 0 s 10 serialized a 5 s 11 description s 64 A flag to indicate whether content is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny

    Original URL path: http://nederdev.nl/blog/drupal-1337?destination=node%2F75 (2016-01-29)
    Open archived version from archive

  • R.I.P. and donations for research on cancer | Nederdev
    8 not null b 1 s 7 default i 0 s 7 created a 4 s 11 description s 61 A Unix timestamp indicating when the cache entry was created s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 headers a 3 s 11 description s 51 Any custom HTTP headers to be added to cached data s 4 type s 4 text s 8 not null b 0 s 10 serialized a 5 s 11 description s 64 A flag to indicate whether content is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 91 Whether or not related terms are enabled within the vocabulary 0 disabled 1 enabled s 9 hierarchy a 6

    Original URL path: http://nederdev.nl/node/57?destination=node%2F57 (2016-01-29)
    Open archived version from archive

  • DrupalJam IV: Enschede | Nederdev
    null b 0 s 10 serialized a 5 s 11 description s 64 A flag to indicate whether content is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 91 Whether or not related terms are enabled within the vocabulary 0 disabled 1 enabled s 9 hierarchy a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 93 The type of hierarchy allowed within the vocabulary 0 disabled 1 single 2 multiple s 8 multiple a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4

    Original URL path: http://nederdev.nl/work/drupaljam-iv-enschede?destination=node%2F74 (2016-01-29)
    Open archived version from archive

  • FOSDEM 2009 | Nederdev
    default i 0 s 7 headers a 3 s 11 description s 51 Any custom HTTP headers to be added to cached data s 4 type s 4 text s 8 not null b 0 s 10 serialized a 5 s 11 description s 64 A flag to indicate whether content is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 91 Whether or not related terms are enabled within the vocabulary 0 disabled 1 enabled s 9 hierarchy a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 93 The type of hierarchy allowed within the vocabulary 0 disabled 1

    Original URL path: http://nederdev.nl/work/fosdem-2009?destination=node%2F73 (2016-01-29)
    Open archived version from archive

  • FOSDEM 2009 | Nederdev
    7 headers a 3 s 11 description s 51 Any custom HTTP headers to be added to cached data s 4 type s 4 text s 8 not null b 0 s 10 serialized a 5 s 11 description s 64 A flag to indicate whether content is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 91 Whether or not related terms are enabled within the vocabulary 0 disabled 1 enabled s 9 hierarchy a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 93 The type of hierarchy allowed within the vocabulary 0 disabled 1 single 2 multiple s

    Original URL path: http://nederdev.nl/node/72?destination=node%2F72 (2016-01-29)
    Open archived version from archive

  • DrupalJam IV: Enschede | Nederdev
    created a 4 s 11 description s 61 A Unix timestamp indicating when the cache entry was created s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 headers a 3 s 11 description s 51 Any custom HTTP headers to be added to cached data s 4 type s 4 text s 8 not null b 0 s 10 serialized a 5 s 11 description s 64 A flag to indicate whether content is serialized 1 or not 0 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 3 cid s 6 module s 6 system s 4 name s 10 cache menu s 5 files a 6 s 11 description s 38 Stores information for uploaded files s 6 fields a 8 s 3 fid a 4 s 11 description s 29 Primary Key Unique files ID s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 uid a 5 s 11 description s 60 The users uid of the user who is associated with the file s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 8 filename a 5 s 11 description s 17 Name of the file s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filepath a 5 s 11 description s 41 Path of the file relative to Drupal root s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filemime a 5 s 11 description s 19 The file MIME type s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 filesize a 5 s 11 description s 30 The size of the file in bytes s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 6 status a 4 s 11 description s 65 A flag indicating whether file is temporary 1 or permanent 0 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 5 s 11 description s 43 UNIX timestamp for when the file was added s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 indexes a 3 s 3 uid a 1 i 0 s 3 uid s 6 status a 1 i 0 s 6 status s 9 timestamp a 1 i 0 s 9 timestamp s 11 primary key a 1 i 0 s 3 fid s 6 module s 6 system s 4 name s 5 files s 5 flood a 6 s 11 description s 79 Flood controls the threshold of events such as the number of contact attempts s 6 fields a 4 s 3 fid a 3 s 11 description s 22 Unique flood event ID s 4 type s 6 serial s 8 not null b 1 s 5 event a 5 s 11 description s 29 Name of event e g contact s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 24 Hostname of the visitor s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 23 Timestamp of the event s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 1 i 0 s 3 fid s 7 indexes a 1 s 5 allow a 3 i 0 s 5 event i 1 s 8 hostname i 2 s 9 timestamp s 6 module s 6 system s 4 name s 5 flood s 7 history a 6 s 11 description s 50 A record of which users have read which node s s 6 fields a 3 s 3 uid a 4 s 11 description s 41 The users uid that read the node nid s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 3 nid a 4 s 11 description s 29 The node nid that was read s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 9 timestamp a 4 s 11 description s 46 The Unix timestamp at which the read occurred s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 primary key a 2 i 0 s 3 uid i 1 s 3 nid s 7 indexes a 1 s 3 nid a 1 i 0 s 3 nid s 6 module s 6 system s 4 name s 7 history s 11 menu router a 6 s 11 description s 56 Maps paths to various callbacks access page and title s 6 fields a 20 s 4 path a 5 s 11 description s 49 Primary Key the Drupal path this entry describes s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 load functions a 3 s 11 description s 129 A serialized array of function names like node load to be called to load an object corresponding to a part of the current path s 4 type s 4 text s 8 not null b 1 s 16 to arg functions a 3 s 11 description s 139 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 s 4 type s 4 text s 8 not null b 1 s 15 access callback a 5 s 11 description s 86 The callback which determines the access to this router path Defaults to user access s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 16 access arguments a 3 s 11 description s 56 A serialized array of arguments for the access callback s 4 type s 4 text s 8 not null b 0 s 13 page callback a 5 s 11 description s 47 The name of the function that renders the page s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 page arguments a 3 s 11 description s 54 A serialized array of arguments for the page callback s 4 type s 4 text s 8 not null b 0 s 3 fit a 4 s 11 description s 53 A numeric representation of how specific the path is s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 12 number parts a 5 s 11 description s 36 Number of parts in this router path s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 tab parent a 5 s 11 description s 98 Only for local tasks tabs the router path of the parent page which may also be a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 8 tab root a 5 s 11 description s 118 Router path of the closest non tab parent page For pages that are not local tasks this will be the same as the path s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 title a 5 s 11 description s 81 The title for the current page or the title for the tab if this is a local task s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 14 title callback a 5 s 11 description s 54 A function which will alter the title Defaults to t s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 15 title arguments a 5 s 11 description s 133 A serialized array of arguments for the title callback If empty the title will be used as the sole argument for the title callback s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 4 s 11 description s 74 Numeric representation of the type of the menu item like MENU LOCAL TASK s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 block callback a 5 s 11 description s 92 Name of a function used to render the block on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description a 3 s 11 description s 27 A description of this item s 4 type s 4 text s 8 not null b 1 s 8 position a 5 s 11 description s 90 The position of the block left or right on the system administration page for this item s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 weight a 4 s 11 description s 78 Weight of the element Lighter weights are higher up heavier weights go down s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 file a 3 s 11 description s 92 The file to include for this element usually the page callback function lives in this file s 4 type s 4 text s 4 size s 6 medium s 7 indexes a 3 s 3 fit a 1 i 0 s 3 fit s 10 tab parent a 1 i 0 s 10 tab parent s 21 tab root weight title a 3 i 0 a 2 i 0 s 8 tab root i 1 i 64 i 1 s 6 weight i 2 s 5 title s 11 primary key a 1 i 0 s 4 path s 6 module s 6 system s 4 name s 11 menu router s 10 menu links a 6 s 11 description s 44 Contains the individual links within a menu s 6 fields a 25 s 9 menu name a 5 s 11 description s 98 The menu name All links with the same menu name such as navigation are part of the same menu s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 4 mlid a 4 s 11 description s 51 The menu link ID mlid is the integer primary key s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 4 plid a 5 s 11 description s 126 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 9 link path a 5 s 11 description s 53 The Drupal path or external path this link points to s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 router path a 5 s 11 description s 114 For links corresponding to a Drupal path external 0 this connects the link to a menu router path for joins s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 10 link title a 5 s 11 description s 99 The text displayed for the link which may be modified by a title callback stored in menu router s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 7 options a 3 s 11 description s 115 A serialized array of options to be passed to the url or l function such as a query string or HTML attributes s 4 type s 4 text s 8 not null b 0 s 6 module a 5 s 11 description s 48 The name of the module that generated this link s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 6 system s 6 hidden a 5 s 11 description s 168 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 external a 5 s 11 description s 120 A flag to indicate if the link points to a full URL starting with a protocol like http 1 external 0 internal s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 12 has children a 5 s 11 description s 99 Flag indicating whether any links have this link as a parent 1 children exist 0 no children s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 8 expanded a 5 s 11 description s 210 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 6 weight a 4 s 11 description s 59 Link weight among links in the same menu at the same depth s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 depth a 5 s 11 description s 80 The depth relative to the top level A link with plid 0 will have depth 1 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 10 customized a 5 s 11 description s 110 A flag to indicate that the user has manually created or edited the link 1 customized 0 not customized s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 2 p1 a 5 s 11 description s 219 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 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p2 a 5 s 11 description s 49 The second mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p3 a 5 s 11 description s 48 The third mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p4 a 5 s 11 description s 49 The fourth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p5 a 5 s 11 description s 48 The fifth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p6 a 5 s 11 description s 48 The sixth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p7 a 5 s 11 description s 50 The seventh mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p8 a 5 s 11 description s 49 The eighth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 2 p9 a 5 s 11 description s 48 The ninth mlid in the materialized path See p1 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 7 updated a 5 s 11 description s 81 Flag that indicates that this link was generated during the update from Drupal 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 5 small s 7 indexes a 4 s 9 path menu a 2 i 0 a 2 i 0 s 9 link path i 1 i 128 i 1 s 9 menu name s 22 menu plid expand child a 4 i 0 s 9 menu name i 1 s 4 plid i 2 s 8 expanded i 3 s 12 has children s 12 menu parents a 10 i 0 s 9 menu name i 1 s 2 p1 i 2 s 2 p2 i 3 s 2 p3 i 4 s 2 p4 i 5 s 2 p5 i 6 s 2 p6 i 7 s 2 p7 i 8 s 2 p8 i 9 s 2 p9 s 11 router path a 1 i 0 a 2 i 0 s 11 router path i 1 i 128 s 11 primary key a 1 i 0 s 4 mlid s 6 module s 6 system s 4 name s 10 menu links s 9 semaphore a 6 s 11 description s 121 Table for holding semaphores locks flags etc that cannot be stored as Drupal variables since they must not be cached s 6 fields a 3 s 4 name a 5 s 11 description s 25 Primary Key Unique name s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 value a 5 s 11 description s 8 A value s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 expire a 4 s 11 description s 79 A Unix timestamp with microseconds indicating when the semaphore should expire s 4 type s 5 float s 4 size s 3 big s 8 not null b 1 s 7 indexes a 1 s 6 expire a 1 i 0 s 6 expire s 11 primary key a 1 i 0 s 4 name s 6 module s 6 system s 4 name s 9 semaphore s 8 sessions a 6 s 11 description s 139 Drupal s session handlers read and write into the sessions table Each record represents a user session either anonymous or authenticated s 6 fields a 6 s 3 uid a 4 s 11 description s 68 The users uid corresponding to a session or 0 for anonymous user s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 3 sid a 5 s 11 description s 71 Primary key A session ID The value is generated by PHP s Session API s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 8 hostname a 5 s 11 description s 52 The IP address that last used this session ID sid s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 9 timestamp a 4 s 11 description s 104 The Unix timestamp when this session last requested a page Old records are purged by PHP automatically s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 5 cache a 4 s 11 description s 118 The time of this user s last post This is used when the site has specified a minimum cache lifetime See cache get s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 7 session a 4 s 11 description s 208 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 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 primary key a 1 i 0 s 3 sid s 7 indexes a 2 s 9 timestamp a 1 i 0 s 9 timestamp s 3 uid a 1 i 0 s 3 uid s 6 module s 6 system s 4 name s 8 sessions s 6 system a 6 s 11 description s 105 A list of all modules themes and theme engines that are or have been installed in Drupal s file system s 6 fields a 10 s 8 filename a 5 s 11 description s 103 The path of the primary file for this item relative to the Drupal root e g modules node node module s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 name a 5 s 11 description s 32 The name of the item e g node s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 type a 5 s 11 description s 60 The type of the item either module theme or theme engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 5 owner a 5 s 11 description s 55 A theme s parent Can be either a theme or an engine s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 6 status a 4 s 11 description s 55 Boolean indicating whether or not this item is enabled s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 8 throttle a 5 s 11 description s 102 Boolean indicating whether this item is disabled when the throttle module disables throttleable items s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 9 bootstrap a 4 s 11 description s 138 Boolean indicating whether this module is loaded during Drupal s early bootstrapping phase e g even before the page cache is consulted s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 14 schema version a 5 s 11 description s 238 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 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 5 small s 6 weight a 4 s 11 description s 127 The order in which this module s hooks should be invoked relative to other modules Equal weighted modules are ordered by name s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 info a 3 s 11 description s 166 A serialized array containing information from the module s info file keys can include name description package version core dependencies dependents and php s 4 type s 4 text s 8 not null b 0 s 11 primary key a 1 i 0 s 8 filename s 7 indexes a 3 s 7 modules a 4 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 6 weight i 3 s 8 filename s 9 bootstrap a 5 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 6 status i 2 s 9 bootstrap i 3 s 6 weight i 4 s 8 filename s 9 type name a 2 i 0 a 2 i 0 s 4 type i 1 i 12 i 1 s 4 name s 6 module s 6 system s 4 name s 6 system s 9 url alias a 7 s 11 description s 95 A list of URL aliases for Drupal paths a user may visit either the source or destination path s 6 fields a 4 s 3 pid a 4 s 11 description s 31 A unique path alias identifier s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 3 src a 5 s 11 description s 48 The Drupal path this alias is for e g node 12 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 3 dst a 5 s 11 description s 49 The alias for this path e g title of the story s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 8 language a 5 s 11 description s 151 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 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 unique keys a 1 s 16 dst language pid a 3 i 0 s 3 dst i 1 s 8 language i 2 s 3 pid s 11 primary key a 1 i 0 s 3 pid s 7 indexes a 1 s 16 src language pid a 3 i 0 s 3 src i 1 s 8 language i 2 s 3 pid s 6 module s 6 system s 4 name s 9 url alias s 9 term data a 6 s 11 description s 24 Stores term information s 6 fields a 5 s 3 tid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 28 Primary Key Unique term ID s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 69 The vocabulary vid of the vocabulary to which the term is assigned s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 14 The term name s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 26 A description of the term s 6 weight a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 51 The weight of this term in relation to other terms s 11 primary key a 1 i 0 s 3 tid s 7 indexes a 2 s 13 taxonomy tree a 3 i 0 s 3 vid i 1 s 6 weight i 2 s 4 name s 8 vid name a 2 i 0 s 3 vid i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 9 term data s 14 term hierarchy a 6 s 11 description s 51 Stores the hierarchical relationship between terms s 6 fields a 2 s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 45 Primary Key The term data tid of the term s 6 parent a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 77 Primary Key The term data tid of the term s parent 0 indicates no parent s 7 indexes a 1 s 6 parent a 1 i 0 s 6 parent s 11 primary key a 2 i 0 s 3 tid i 1 s 6 parent s 6 module s 8 taxonomy s 4 name s 14 term hierarchy s 9 term node a 6 s 11 description s 42 Stores the relationship of terms to nodes s 6 fields a 3 s 3 nid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node nid of the node s 3 vid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 40 Primary Key The node vid of the node s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 64 Primary Key The term data tid of a term assigned to the node s 7 indexes a 2 s 3 vid a 1 i 0 s 3 vid s 3 nid a 1 i 0 s 3 nid s 11 primary key a 2 i 0 s 3 tid i 1 s 3 vid s 6 module s 8 taxonomy s 4 name s 9 term node s 13 term relation a 7 s 11 description s 52 Stores non hierarchical relationships between terms s 6 fields a 3 s 4 trid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 37 Primary Key Unique term relation ID s 4 tid1 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 56 The term data tid of the first term in a relationship s 4 tid2 a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 57 The term data tid of the second term in a relationship s 11 unique keys a 1 s 9 tid1 tid2 a 2 i 0 s 4 tid1 i 1 s 4 tid2 s 7 indexes a 1 s 4 tid2 a 1 i 0 s 4 tid2 s 11 primary key a 1 i 0 s 4 trid s 6 module s 8 taxonomy s 4 name s 13 term relation s 12 term synonym a 6 s 11 description s 21 Stores term synonyms s 6 fields a 3 s 4 tsid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 36 Primary Key Unique term synonym ID s 3 tid a 5 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 11 description s 32 The term data tid of the term s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 24 The name of the synonym s 7 indexes a 2 s 3 tid a 1 i 0 s 3 tid s 8 name tid a 2 i 0 s 4 name i 1 s 3 tid s 11 primary key a 1 i 0 s 4 tsid s 6 module s 8 taxonomy s 4 name s 12 term synonym s 10 vocabulary a 6 s 11 description s 30 Stores vocabulary information s 6 fields a 11 s 3 vid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 34 Primary Key Unique vocabulary ID s 4 name a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 23 Name of the vocabulary s 11 description a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 30 Description of the vocabulary s 4 help a 5 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 11 description s 40 Help text to display for the vocabulary s 9 relations a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 91 Whether or not related terms are enabled within the vocabulary 0 disabled 1 enabled s 9 hierarchy a 6 s 4 type s 3 int s 8 unsigned b 1 s

    Original URL path: http://nederdev.nl/blog/drupaljam-iv-enschede?destination=node%2F69 (2016-01-29)
    Open archived version from archive



  •