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".
  • Nederdev | : web and Drupal stuff
    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 assigned to a node 0 disabled 1 enabled s 8 required 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 94 Whether or not terms are required for nodes using this vocabulary 0 disabled 1 enabled s 4 tags 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 86 Whether or not free tagging is enabled for the vocabulary 0 disabled 1 enabled s 6 module 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 The module which created the vocabulary 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 63 The weight of the vocabulary in relation to other vocabularies s 11 primary key a 1 i 0 s 3 vid s 7 indexes a 1 s 4 list a 2 i 0 s 6 weight i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 10 vocabulary s 21 vocabulary node types a 6 s 11 description s 54 Stores which node types vocabularies may be used with s 6 fields a 2 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 52 Primary Key the vocabulary vid of the vocabulary s 4 type a 5 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 11 description s 70 The node type of the node type for which the vocabulary may be used s 11 primary key a 2 i 0 s 4 type i 1 s 3 vid s 7 indexes a 1 s 3 vid a 1 i 0 s 3 vid s 6 module s 8 taxonomy s 4 name s 21 vocabulary node types s 12 cache update a 6 s 11 description s 109 Cache table for the Update module to store information about available releases fetched from central server s 6

    Original URL path: http://nederdev.nl/frontpage?page=4 (2016-01-29)
    Open archived version from archive


  • Nederdev | : web and Drupal stuff
    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 assigned to a node 0 disabled 1 enabled s 8 required 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 94 Whether or not terms are required for nodes using this vocabulary 0 disabled 1 enabled s 4 tags 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 86 Whether or not free tagging is enabled for the vocabulary 0 disabled 1 enabled s 6 module 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 The module which created the vocabulary 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 63 The weight of the vocabulary in relation to other vocabularies s 11 primary key a 1 i 0 s 3 vid s 7 indexes a 1 s 4 list a 2 i 0 s 6 weight i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 10 vocabulary s 21 vocabulary node types a 6 s 11 description s 54 Stores which node types vocabularies may be used with s 6 fields a 2 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 52 Primary Key the vocabulary vid of the vocabulary s 4 type a 5 s 4 type s 7 varchar s 6 length i

    Original URL path: http://nederdev.nl/frontpage?page=5 (2016-01-29)
    Open archived version from archive

  • Nederdev | : web and Drupal stuff
    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 assigned to a node 0 disabled 1 enabled s 8 required 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 94 Whether or not terms are required for nodes using this vocabulary 0 disabled 1 enabled s 4 tags 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 86 Whether or not free tagging is enabled for the vocabulary 0 disabled 1 enabled s 6 module 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 The module which created the vocabulary 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 63 The weight of the vocabulary in relation to other vocabularies s 11 primary key a 1 i 0 s 3 vid s 7 indexes a 1 s 4 list a 2 i 0 s 6 weight i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 10 vocabulary s 21 vocabulary node types a 6 s 11 description s 54 Stores which node types vocabularies may be used with s 6 fields a 2 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

    Original URL path: http://nederdev.nl/frontpage?page=6 (2016-01-29)
    Open archived version from archive

  • Nederdev | : web and Drupal stuff
    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 size s 4 tiny s 11 description s 105 Whether

    Original URL path: http://nederdev.nl/frontpage?page=7 (2016-01-29)
    Open archived version from archive

  • Nederdev | : web and Drupal stuff
    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 assigned to a node 0 disabled 1 enabled s 8 required 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 94 Whether or not terms are required for nodes using this vocabulary 0 disabled 1 enabled s 4 tags 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 86 Whether or not free tagging is enabled for the vocabulary 0 disabled 1 enabled s 6 module 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 The module which created the vocabulary 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 63 The weight of the vocabulary in relation to other vocabularies s 11 primary key a 1 i 0 s 3 vid s 7 indexes a 1 s 4 list a 2 i 0 s 6 weight i 1 s 4 name s 6 module s 8 taxonomy s 4 name s 10 vocabulary s 21 vocabulary node types a 6 s 11 description s 54 Stores which node types vocabularies may be used with s 6 fields a 2 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 52 Primary Key the vocabulary vid of the vocabulary s 4 type a 5 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 0 s 11 description s 70 The node type of the node type for which the vocabulary may be used s 11 primary key a 2 i 0 s 4 type i 1 s 3 vid s 7 indexes a 1 s 3 vid a 1 i 0 s 3 vid s 6 module s 8 taxonomy s 4 name s 21 vocabulary node types s 12 cache update a 6 s 11 description s 109 Cache table for the Update module to store information about available releases fetched from central server s 6 fields a 6 s 3 cid a 5 s 11 description s 29 Primary Key Unique cache ID s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 7 default s 0 s 4 data a 4 s 11 description s 30 A collection of data to cache s 4 type s 4 blob s 8 not null b 0 s 4 size s 3 big s 6 expire a 4 s 11 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 update s 4 name s 12 cache update s 6 upload a 6 s 11 description s 56 Stores uploaded file information and table associations s 6 fields a 6 s 3 fid 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 29 Primary Key The files fid 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 49 The node nid associated with the uploaded file 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 62 Primary Key The node vid associated with the uploaded file s 11 description 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 33 Description of the uploaded file s 4 list 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 71 Whether the file should be visibly listed on the node yes 1 or no 0 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 64 Weight of this upload in relation to other uploads in this node s 11 primary key a 2 i 0 s 3 vid i 1 s 3 fid s 7 indexes a 2 s 3 fid a 1 i 0 s 3 fid s

    Original URL path: http://nederdev.nl/frontpage?destination=frontpage (2016-01-29)
    Open archived version from archive

  • About | Nederdev
    theme paths a 1 i 0 s 12 modules user s 20 preprocess functions a 1 i 0 s 19 template preprocess s 19 user admin new role a 8 s 9 arguments a 1 s 4 form N s 4 file s 14 user admin inc s 4 type s 6 module s 10 theme path s 12 modules user s 8 function s 25 theme user admin new role s 13 include files a 1 i 0 s 29 modules user user admin inc s 11 theme paths a 1 i 0 s 12 modules user s 20 preprocess functions a 1 i 0 s 19 template preprocess s 18 user admin account a 8 s 9 arguments a 1 s 4 form N s 4 file s 14 user admin inc s 4 type s 6 module s 10 theme path s 12 modules user s 8 function s 24 theme user admin account s 13 include files a 1 i 0 s 29 modules user user admin inc s 11 theme paths a 1 i 0 s 12 modules user s 20 preprocess functions a 1 i 0 s 19 template preprocess s 16 user filter form a 8 s 9 arguments a 1 s 4 form N s 4 file s 14 user admin inc s 4 type s 6 module s 10 theme path s 12 modules user s 8 function s 22 theme user filter form s 13 include files a 1 i 0 s 29 modules user user admin inc s 11 theme paths a 1 i 0 s 12 modules user s 20 preprocess functions a 1 i 0 s 19 template preprocess s 12 user filters a 8 s 9 arguments a 1 s 4 form N s 4 file s 14 user admin inc s 4 type s 6 module s 10 theme path s 12 modules user s 8 function s 18 theme user filters s 13 include files a 1 i 0 s 29 modules user user admin inc s 11 theme paths a 1 i 0 s 12 modules user s 20 preprocess functions a 1 i 0 s 19 template preprocess s 14 user signature a 7 s 9 arguments a 1 s 9 signature N s 4 type s 6 module s 10 theme path s 12 modules user s 8 function s 20 theme user signature s 13 include files a 0 s 11 theme paths a 1 i 0 s 12 modules user s 20 preprocess functions a 1 i 0 s 19 template preprocess s 24 vocabindex admin vi form a 8 s 4 path s 34 sites all modules vocabindex theme s 8 template s 24 vocabindex admin vi form s 9 arguments a 1 s 4 form a 0 s 4 type s 6 module s 10 theme path s 28 sites all modules vocabindex s 13 include files a 0 s 11 theme paths a 1 i 0 s 34 sites all modules vocabindex theme s 20 preprocess functions a 1 i 0 s 19 template preprocess s 15 vocabindex page a 8 s 4 path s 34 sites all modules vocabindex theme s 8 template s 15 vocabindex page s 9 arguments a 4 s 6 parent N s 4 list N s 5 pager N s 11 pager alpha N s 4 type s 6 module s 10 theme path s 28 sites all modules vocabindex s 13 include files a 0 s 11 theme paths a 1 i 0 s 34 sites all modules vocabindex theme s 20 preprocess functions a 1 i 0 s 19 template preprocess s 15 vocabindex link a 8 s 4 path s 34 sites all modules vocabindex theme s 8 template s 15 vocabindex link s 9 arguments a 3 s 4 term N s 2 vi N s 3 dir N s 4 type s 6 module s 10 theme path s 28 sites all modules vocabindex s 13 include files a 0 s 11 theme paths a 1 i 0 s 34 sites all modules vocabindex theme s 20 preprocess functions a 1 i 0 s 19 template preprocess s 16 vocabindex pager a 8 s 4 path s 34 sites all modules vocabindex theme s 8 template s 16 vocabindex pager s 9 arguments a 1 s 7 letters N s 4 type s 6 module s 10 theme path s 28 sites all modules vocabindex s 13 include files a 0 s 11 theme paths a 1 i 0 s 34 sites all modules vocabindex theme s 20 preprocess functions a 1 i 0 s 19 template preprocess s 23 vocabindex pager letter a 8 s 4 path s 34 sites all modules vocabindex theme s 8 template s 23 vocabindex pager letter s 9 arguments a 3 s 6 letter N s 3 url N s 6 active N s 4 type s 6 module s 10 theme path s 28 sites all modules vocabindex s 13 include files a 0 s 11 theme paths a 1 i 0 s 34 sites all modules vocabindex theme s 20 preprocess functions a 1 i 0 s 19 template preprocess s 26 vocabindex pager separator a 7 s 4 path s 34 sites all modules vocabindex theme s 8 template s 26 vocabindex pager separator s 4 type s 6 module s 10 theme path s 28 sites all modules vocabindex s 13 include files a 0 s 11 theme paths a 1 i 0 s 34 sites all modules vocabindex theme s 20 preprocess functions a 1 i 0 s 19 template preprocess s 10 token help a 7 s 9 arguments a 3 s 4 type s 3 all s 6 prefix s 1 s 6 suffix s 1 s 4 type s 6 module s 10 theme path s 23 sites all modules token s 8 function s 16 theme token help s 13 include files a 0 s 11 theme paths a 1 i 0 s 23 sites all modules token s 20 preprocess functions a 1 i 0 s 19 template preprocess s 16 views mini pager a 10 s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 tags a 0 s 5 limit i 10 s 7 element i 0 s 10 parameters a 0 s 7 pattern s 18 views mini pager s 4 type s 6 module s 10 theme path s 23 sites all modules views s 8 function s 22 theme views mini pager s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 1 i 0 s 19 template preprocess s 16 views view field a 10 s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 7 pattern s 18 views view field s 9 arguments a 3 s 4 view N s 5 field N s 3 row N s 4 type s 6 module s 10 theme path s 23 sites all modules views s 8 function s 22 theme views view field s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 36 template preprocess views view field s 10 views view a 10 s 7 pattern s 12 views view s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 1 s 4 view N s 8 template s 10 views view s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 30 template preprocess views view s 22 views view unformatted a 10 s 7 pattern s 24 views view unformatted s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 view N s 7 options N s 4 rows N s 5 title N s 8 template s 22 views view unformatted s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 42 template preprocess views view unformatted s 15 views view list a 10 s 7 pattern s 17 views view list s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 view N s 7 options N s 4 rows N s 5 title N s 8 template s 15 views view list s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 35 template preprocess views view list s 15 views view grid a 10 s 7 pattern s 17 views view grid s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 view N s 7 options N s 4 rows N s 5 title N s 8 template s 15 views view grid s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 35 template preprocess views view grid s 16 views view table a 10 s 7 pattern s 18 views view table s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 view N s 7 options N s 4 rows N s 5 title N s 8 template s 16 views view table s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 36 template preprocess views view table s 18 views view summary a 10 s 7 pattern s 20 views view summary s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 view N s 7 options N s 4 rows N s 5 title N s 8 template s 18 views view summary s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 38 template preprocess views view summary s 30 views view summary unformatted a 10 s 7 pattern s 32 views view summary unformatted s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 view N s 7 options N s 4 rows N s 5 title N s 8 template s 30 views view summary unformatted s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 50 template preprocess views view summary unformatted s 14 views view rss a 10 s 7 pattern s 16 views view rss s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 4 s 4 view N s 7 options N s 4 rows N s 5 title N s 8 template s 14 views view rss s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 34 template preprocess views view rss s 22 views view row comment a 10 s 7 pattern s 24 views view row comment s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 3 s 4 view N s 7 options N s 3 row N s 8 template s 22 views view row comment s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 42 template preprocess views view row comment s 19 views view row node a 10 s 7 pattern s 21 views view row node s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 3 s 4 view N s 7 options N s 3 row N s 8 template s 19 views view row node s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 39 template preprocess views view row node s 17 views view fields a 10 s 7 pattern s 19 views view fields s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 9 arguments a 3 s 4 view N s 7 options N s 3 row N s 8 template s 17 views view fields s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 37 template preprocess views view fields s 18 views exposed form a 10 s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 8 template s 18 views exposed form s 7 pattern s 20 views exposed form s 9 arguments a 1 s 4 form N s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 2 i 0 s 19 template preprocess i 1 s 38 template preprocess views exposed form s 10 views more a 10 s 4 file s 9 theme inc s 4 path s 29 sites all modules views theme s 8 template s 10 views more s 7 pattern s 12 views more s 9 arguments a 1 s 8 more url N s 4 type s 6 module s 10 theme path s 23 sites all modules views s 13 include files a 1 i 0 s 41 sites all modules views theme theme inc s 11 theme paths a 1 i 0 s 29 sites all modules views theme s 20 preprocess functions a 1 i 0 s 19 template preprocess created 1454043874 expire 0 headers serialized 1 WHERE cid theme registry minnelli in var www vhosts nederdev nl httpdocs includes cache inc on line 109 user warning Table nederdev accesslog is marked as crashed and should be repaired query INSERT INTO accesslog title path url hostname uid sid timer timestamp values rss xml 109 73 111 38 0 3fdo74q2sajm5702fb5tipq416 528 1454043875 in var www vhosts nederdev nl httpdocs modules statistics statistics module on line 64 user warning Table nederdev cache is marked as crashed and should be repaired query SELECT data created headers expire serialized FROM cache WHERE cid schema in var www vhosts nederdev nl httpdocs includes cache inc on line 26 user warning Table nederdev cache is marked as crashed and should be repaired query SELECT data created headers expire serialized FROM cache WHERE cid locale nl in var www vhosts nederdev nl httpdocs includes cache inc on line 26 user warning Table nederdev cache is marked as crashed and should be repaired query UPDATE cache SET data a 838 s 6 delete s 11 verwijderen s 4 Save s 7 Bewaren s 10 Operations s 11 Bewerkingen s 6 Delete s 11 Verwijderen s 61 Base CAPTCHA module for adding challenges to arbitrary forms s 75 Basis CAPTCHA module om uitdagingen aan allerlei formulieren toe te voegen s 12 Spam control s 13 Spam controle s 32 Provides an image based CAPTCHA s 42 Voorziet een afbeelding gebaseerde CAPTCHA s 37 Provides a simple text based CAPTCHA s 48 Voorziet een eenvoudig tekst gebaseerde CAPTCHA s 10 Navigation b 1 s 6 Blocks s 7 Blokken s 4 List b 1 s 15 Configure block b 1 s 12 Delete block b 1 s 8 Comments b 1 s 61 List and edit site comments and the comment moderation queue b 1 s 8 Settings s 12 Instellingen s 14 Delete comment b 1 s 12 Edit comment b 1 s 12 Contact form b 1 s 71 Create a system contact form and set up categories for the form to use b 1 s 7 Contact b 1 s 13 Input formats b 1 s 19 Delete input format b 1 s 12 Compose tips b 1 s 4 Help b 1 s 5 block b 1 s 5 color b 1 s 7 comment b 1 s 7 contact b 1 s 6 filter b 1 s 4 help b 1 s 6 locale b 1 s 4 menu b 1 s 4 node b 1 s 4 path b 1 s 8 pathauto b 1 s 6 search b 1 s 10 statistics b 1 s 6 system b 1 s 8 taxonomy b 1 s 4 user b 1 s 18 Content management b 1 s 27 Manage your site s content b 1 s 7 Content b 1 s 43 View edit and delete your site s content b 1 s 13 Post settings b 1 s 13 Content types s 11 Inoudstypen s 14 Create content b 1 s 5 Title b 1 s 11 URL aliases b 1 s 46 Change your site s URL paths by aliasing them b 1 s 10 Edit alias b 1 s 12 Delete alias b 1 s 6 Search b 1 s 15 Search settings b 1 s 66 Configure relevance settings for search and other indexing options b 1 s 11 Clear index b 1 s 18 Top search phrases b 1 s 33 View most popular search phrases b 1 s 11 Recent hits b 1 s 43 View pages that have recently been visited b 1 s 9 Top pages b 1 s 41 View pages that have been hit frequently b 1 s 12 Top visitors b 1 s 34 View visitors that hit many pages b 1 s 13 Top referrers b 1 s 19 View top referrers b 1 s 19 Access log settings b 1 s 50 Control details about what and how your site logs b 1 s 13 File download b 1 s 10 Administer b 1 s 12 Compact mode b 1 s 18 Site configuration b 1 s 40 Adjust basic site configuration options b 1 s 13 Site building b 1 s 38 Control how your site looks and feels b 1 s 20 Administration theme b 1 s 55 Settings for how your administrative pages should look b 1 s 6 Themes b 1 s 57 Change which theme your site uses or allows users to set b 1 s 25 Select the default theme b 1 s 9 Configure b 1 s 15 Global settings b 1 s 7 Modules b 1 s 47 Enable or disable add on modules for your site b 1 s 9 Uninstall b 1 s 16 Site information b 1 s 15 Error reporting b 1 s 11 Performance b 1 s 11 File system b 1 s 68 Tell Drupal where to store uploaded files and how they are accessed b 1 s 13 Image toolkit b 1 s 74 Choose which image toolkit to use if you have installed optional toolkits b 1 s 14 RSS publishing b 1 s 13 Date and time b 1 s 16 Site maintenance b 1 s 63 Take the site off line for maintenance or bring it back online b 1 s 10 Clean URLs b 1 s 43 Enable or disable clean URLs for your site b 1 s 13 Status report b 1 s 74 Get a status report about your site s operation and any detected problems b 1 s 8 Run cron b 1 s 3 PHP b 1 s 3 SQL b 1 s 9 Edit term b 1 s 13 Taxonomy term b 1 s 21 Autocomplete taxonomy b 1 s 12 User account b 1 s 17 User autocomplete b 1 s 6 Log in b 1 s 20 Request new password b 1 s 15 User management b 1 s 61 Manage your site s users groups and access to site features b 1 s 5 Users b 1 s 26 List add and edit users b 1 s 13 User settings b 1 s 64 Determine access to features by selecting permissions for roles b 1 s 5 Roles b 1 s 30 List edit or add user roles b 1 s 9 Edit role b 1 s 12 Access rules b 1 s 9 Edit rule b 1 s 11 Delete rule b 1 s 7 Log out b 1 s 10 User login b 1 s 8 Username b 1 s 8 Password b 1 s 32 Request new password via e mail b 1 s 23 This field is required b 1 s 17 title required b 1 s 14 Page not found b 1 s 38 The requested page could not be found b 1 s 12 Left sidebar b 1 s 13 Right sidebar b 1 s 6 Header b 1 s 6 Footer b 1 s 59 Powered by Drupal an open source content management system b 1 s 16 Search this site b 1 s 39 Enter the terms you wish to search for b 1 s 11 HTML filter b 1 s 20 Line break converter b 1 s 10 URL filter b 1 s 14 HTML corrector b 1 s 4 view b 1 s 25 Drupal core update status b 1 s 10 Up to date b 1 s 30 Module and theme update status b 1 s 23 Enter your s username b 1 s 50 Enter the password that accompanies your username b 1 s 10 My account b 1 s 5 Views b 1 s 31 Ajax callback for view loading b 1 s 9 Languages b 1 s 4 Home b 1 s 6 Normal b 1 s 8 Defaults b 1 s 4 Type s 4 Type s 6 Author b 1 s 7 Replies b 1 s 12 Recent posts s 17 Recente berichten s 4 Page b 1 s 5 Block b 1 s 4 Feed b 1 s 15 Front page feed b 1 s 11 Views today b 1 s 7 Comment b 1 s 47 Display the comment with standard comment view b 1 s 27 Display the comment as RSS b 1 s 4 Node b 1 s 41 Display the node with standard node view b 1 s 16 Node ID from URL b 1 s 16 User ID from URL b 1 s 31 Default settings for this view b 1 s 54 Display the view as a page with a URL and menu links b 1 s 28 Display the view as a block b 1 s 10 Attachment b 1 s 48 Display the view as a feed such as an RSS feed b 1 s 11 Unformatted b 1 s 32 Displays rows one after another b 1 s 30 Displays rows as an HTML list b 1 s 4 Grid b 1 s 24 Displays rows in a grid b 1 s 5 Table b 1 s 25 Displays rows in a table b 1 s 7 Default b 1 s 8 RSS Feed b 1 s 34 Generates an RSS feed from a view b 1 s 6 Fields b 1 s 46 Displays the fields with an optional template b 1 s 11 Fixed entry b 1 s 8 PHP Code b 1 s 7 Numeric b 1 s 15 Add new comment b 1 s 57 Share your thoughts and opinions related to this posting b 1 s 3 Fri b 1 s 23 datetime username b 1 s 8 first b 1 s 12 previous b 1 s 8 next b 1 s 7 last b 1 s 4 View s 8 Weergave s 4 Edit b 1 s 9 Revisions b 1 s 5 Track b 1 s 9 Translate b 1 s 39 Comments are responses to node content b 1 s 25 The title of the comment b 1 s 4 Body b 1 s 24 The text of the comment b 1 s 2 ID b 1 s 23 The name of the poster b 1 s 16 Author s website b 1 s 9 Post date b 1 s 45 Date and time of when the comment was posted b 1 s 13 In moderation b 1 s 54 Whether or not the comment is currently in moderation b 1 s 9 Moderated b 1 s 9 View link b 1 s 42 Provide a simple link to view the comment b 1 s 9 Edit link b 1 s 42 Provide a simple link to edit the comment b 1 s 11 Delete link b 1 s 44 Provide a simple link to delete the comment b 1 s 13 Reply to link b 1 s 46 Provide a simple link to reply to the comment b 1 s 5 Depth b 1 s 51 Display the depth of the comment if it is threaded b 1 s 6 Thread b 1 s 35 The node the comment is a reply to b 1 s 31 The user who wrote the comment b 1 s 4 User b 1 s 10 Parent CID b 1 s 37 The Comment ID of the parent comment b 1 s 14 Parent comment b 1 s 17 Last comment time b 1 s 50 Date and time of when the last comment was posted b 1 s 19 Last comment author b 1 s 50 The name of the author of the last posted comment b 1 s 13 Comment count b 1 s 34 The number of comments a node has b 1 s 22 Updated commented date b 1 s 60 The most recent of last comment posted or node updated time b 1 s 42 Nodes are a Drupal site s primary content b 1 s 3 Nid b 1 s 24 The node ID of the node b 1 s 22 The title of the node b 1 s 29 The date the node was posted b 1 s 12 Updated date b 1 s 35 The date the node was last updated b 1 s 9 Published b 1 s 33 The published status of the node b 1 s 18 Published or admin b 1 s 67 Filters out unpublished nodes if the current user cannot view them b 1 s 22 Promoted to front page b 1 s 27 The front page of the node b 1 s 6 Sticky b 1 s 34 Whether or not the node is sticky b 1 s 4 Link b 1 s 34 Provide a simple link to the node b 1 s 39 Provide a simple link to edit the node b 1 s 41 Provide a simple link to delete the node b 1 s 8 Language b 1 s 31 The language the content is in b 1 s 12 Created date b 1 s 24 In the form of CCYYMMDD b 1 s 20 Created year month b 1 s 22 In the form of YYYYMM b 1 s 12 Created year b 1 s 20 In the form of YYYY b 1 s 13 Created month b 1 s 28 In the form of MM 01 12 b 1 s 12 Created week b 1 s 28 In the form of WW 01 53 b 1 s 13 Node revision b 1 s 49 Node revisions are a history of changes to nodes b 1 s 60 Relate a node revision to the user who created the revision b 1 s 6 Teaser b 1 s 3 Vid b 1 s 37 The revision ID of the node revision b 1 s 11 Log message b 1 s 54 The log message entered when the revision was created b 1 s 39 The date the node revision was created b 1 s 11 Revert link b 1 s 48 Provide a simple link to revert to the revision b 1 s 50 Provide a simple link to delete the node revision b 1 s 15 Has new content b 1 s 53 Show a marker if the node has new or updated content b 1 s 38 Show only nodes that have new content b 1 s 5 Score b 1 s 29 The score of the search item b 1 s 10 Links from b 1 s 30 Nodes that link from the node b 1 s 8 Links to b 1 s 28 Nodes that link to the node b 1 s 12 Search Terms b 1 s 24 The terms to search for b 1 s 15 Node statistics b 1 s 11 Total views b 1 s 51 The total number of times the node has been viewed b 1 s 57 The total number of times the node has been viewed today b 1 s 16 Most recent view b 1 s 46 The most recent time the node has been viewed b 1 s 10 Access log b 1 s 31 Stores site access information b 1 s 10 Session ID b 1 s 45 Browser session ID of user that visited page b 1 s 10 Page title b 1 s 22 Title of page visited b 1 s 4 Path s 3 Pad s 56 Internal path to page visited relative to Drupal root b 1 s 8 Referrer b 1 s 13 Referrer URI b 1 s 8 Hostname b 1 s 39 Hostname of user that visited the page b 1 s 30 The user who visited the site b 1 s 5 Timer b 1 s 48 Time in milliseconds that the page took to load b 1 s 9 Timestamp b 1 s 39 Timestamp of when the page was visited b 1 s 4 File b 1 s 47 Files maintained by Drupal and various modules b 1 s 7 File ID b 1 s 19 The ID of the file b 1 s 4 Name s 4 Naam s 21 The name of the file b 1 s 21 The path of the file b 1 s 9 Mime type b 1 s 26 The mime type of the file b 1 s 4 Size b 1 s 21 The size of the file b 1 s 6 Status b 1 s 23 The status of the file b 1 s 11 Upload date b 1 s 31 The date the file was uploaded b 1 s 8 Taxonomy b 1 s 15 Vocabulary name b 1 s 13 Vocabulary ID b 1 s 26 The taxonomy vocabulary ID b 1 s 4 Term b 1 s 37 Taxonomy terms are attached to nodes b 1 s 13 Uncategorized b 1 s 6 Weight s 7 Gewicht s 21 The term weight field b 1 s 16 Term description b 1 s 48 The description associated with a taxonomy term b 1 s 10 Vocabulary s 11 Vocabulaire s 66 Filter the results of Taxonomy Term to a particular vocabulary b 1 s 7 Term ID b 1 s 20 The taxonomy term ID b 1 s 9 All terms b 1 s 12 Term synonym b 1 s 59 Term synonyms may be used to find terms by alternate names b 1 s 6 Upload b 1 s 11 Description s 12 Beschrijving s 37 The description of the uploaded file b 1 s 6 Listed b 1 s 47 Whether or not the file is marked to be listed b 1 s 29 The weight used for sorting b 1 s 45 Users who have created accounts on your site b 1 s 3 Uid b 1 s 11 The user ID b 1 s 7 Current b 1 s 48 Filter the view to the currently logged in user b 1 s 24 The user or author name b 1 s 6 E mail b 1 s 7 Picture b 1 s 31 The user s picture if allowed b 1 s 30 The date the user was created b 1 s 11 Last access b 1 s 28 The user s last access date b 1 s 10 Last login b

    Original URL path: http://nederdev.nl/about (2016-01-29)
    Open archived version from archive

  • About | Nederdev
    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 8 not null b 1 s 7 default i 0 s 4 size s 4 tiny s 11 description s 93 The type of

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

  • Drupal & iDEAL | Nederdev
    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 assigned to a node 0 disabled 1 enabled s 8 required 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 94 Whether or not terms are required for nodes using this vocabulary 0 disabled 1 enabled s 4 tags a 6 s 4 type s 3 int s 8 unsigned b 1 s 8 not

    Original URL path: http://nederdev.nl/blog/drupal-ideal (2016-01-29)
    Open archived version from archive



  •