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".
  • internet | Nederdev
    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 1454050672 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 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 UPDATE cache SET data a 62 s 6 blocks a 7 s 11 description s 62 Stores block settings such as region and visibility settings s 6 fields a 13 s 3 bid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 29 Primary Key Unique block ID s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 126 The module from which the block originates for example user for the Who s Online block and block for any custom blocks s 5 delta a 5 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 1 0 s 11 description s 36 Unique ID for block within a module s 5 theme a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 47 The theme under which the block settings apply s 6 status 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 49 Block enabled status 1 enabled 0 disabled 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 27 Block weight within region s 6 region a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 43 Theme region within which the block is set s 6 custom 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 169 Flag to indicate how users may control visibility of the block 0 Users cannot control 1 On by default but can be hidden 2 Hidden by default but can be shown s 8 throttle 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 113 Flag to indicate whether or not to remove block when website traffic is high 1 throttle 0 do not throttle s 10 visibility 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 169 Flag to indicate how to show blocks on pages 0 Show on all pages except listed pages 1 Show only on listed pages 2 Use custom PHP code to determine visibility s 5 pages a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 148 Contents of the Pages block contains either a list of paths on which to include exclude the block or PHP code depending on visibility setting s 5 title a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 154 Custom title for the block Empty string will use block default title lt none gt will remove the title text will cause block to use specified title s 5 cache a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 4 tiny s 11 description s 215 Binary flag to indicate block cache mode 1 Do not cache 1 Cache per role 2 Cache per user 4 Cache per page 8 Block cache global See BLOCK CACHE constants in block module for more detailed information s 11 primary key a 1 i 0 s 3 bid s 11 unique keys a 1 s 3 tmd a 3 i 0 s 5 theme i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 5 i 0 s 5 theme i 1 s 6 status i 2 s 6 region i 3 s 6 weight i 4 s 6 module s 6 module s 5 block s 4 name s 6 blocks s 12 blocks roles a 6 s 11 description s 57 Sets up access permissions for blocks based on user roles s 6 fields a 3 s 6 module a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 11 description s 48 The block s origin module from blocks module s 5 delta a 4 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 11 description s 60 The block s unique delta within module from blocks delta s 3 rid a 4 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 11 description s 42 The user s role ID from users roles rid s 11 primary key a 3 i 0 s 6 module i 1 s 5 delta i 2 s 3 rid s 7 indexes a 1 s 3 rid a 1 i 0 s 3 rid s 6 module s 5 block s 4 name s 12 blocks roles s 5 boxes a 6 s 11 description s 38 Stores contents of custom made blocks s 6 fields a 4 s 3 bid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 25 The block s blocks bid s 4 body a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 15 Block contents s 4 info a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 18 Block description s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 69 Block body s filter formats format for example 1 Filtered HTML s 11 unique keys a 1 s 4 info a 1 i 0 s 4 info s 11 primary key a 1 i 0 s 3 bid s 6 module s 5 block s 4 name s 5 boxes s 11 cache block a 6 s 11 description s 204 Cache table for the Block module to store already built blocks identified by module delta and various contexts which may change the block such as theme locale and caching mode defined for the block 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 5 block s 4 name s 11 cache block s 8 comments a 6 s 11 description s 36 Stores comments and associated data s 6 fields a 14 s 3 cid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 31 Primary Key Unique comment ID s 3 pid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 117 The comments cid to which this comment is a reply If set to 0 this comment is not a reply to an existing comment s 3 nid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 48 The node nid to which this comment is a reply s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 101 The users uid who authored the comment If set to 0 this comment was created by an anonymous user s 7 subject a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 18 The comment title s 7 comment a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 17 The comment body s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 23 The author s host name s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 89 The time that the comment was created or last edited by its author as a Unix timestamp s 6 status 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 69 The published status of a comment 0 Published 1 Not Published s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 48 The filter formats format of the comment body s 6 thread a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 11 description s 62 The vancode representation of the comment s place in a thread s 4 name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 124 The comment author s name Uses users name if the user is logged in otherwise uses the value typed into the comment form s 4 mail a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 0 s 11 description s 169 The comment author s e mail address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 8 homepage a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 0 s 11 description s 172 The comment author s home page address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 7 indexes a 3 s 3 pid a 1 i 0 s 3 pid s 3 nid a 1 i 0 s 3 nid s 6 status a 1 i 0 s 6 status s 11 primary key a 1 i 0 s 3 cid s 6 module s 7 comment s 4 name s 8 comments s 23 node comment statistics a 6 s 11 description s 82 Maintains statistics of node and comments posts to show new and updated flags s 6 fields a 5 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 53 The node nid for which the statistics are compiled s 22 last comment timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 99 The Unix timestamp of the last comment that was posted within this node from comments timestamp s 17 last comment name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 83 The name of the latest author to post a comment on this node from comments name s 16 last comment uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 85 The user ID of the latest author to post a comment on this node from comments uid s 13 comment count 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 42 The total number of comments on this node s 11 primary key a 1 i 0 s 3 nid s 7 indexes a 1 s 22 node comment timestamp a 1 i 0 s 22 last comment timestamp s 6 module s 7 comment s 4 name s 23 node comment statistics s 8 watchdog a 6 s 11 description s 46 Table that contains logs of all system events s 6 fields a 11 s 3 wid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 38 Primary Key Unique watchdog event ID s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 52 The users uid of the user who triggered the event s 4 type a 5 s 4 type s 7 varchar s 6 length i 16 s 8 not null b 1 s 7 default s 0 s 11 description s 60 Type of log message for example user or page not found s 7 message a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 55 Text of log message to be passed into the t function s 9 variables a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 101 Serialized array of variables that match the message string and that is passed into the t function s 8 severity 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 The severity level of the event ranges from 0 Emergency to 7 Debug s 4 link 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 37 Link to view the result of the event s 8 location a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 31 URL of the origin of the event s 7 referer a 3 s 4 type s 4 text s 8 not null b 0 s 11 description s 22 URL of referring page s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 45 Hostname of the user who triggered the event s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 38 Unix timestamp of when event occurred s 11 primary key a 1 i 0 s 3 wid s 7 indexes a 1 s 4 type a 1 i 0 s 4 type s 6 module s 5 dblog s 4 name s 8 watchdog s 7 filters a 7 s 11 description s 74 Table that maps filters HTML corrector to input formats Filtered HTML s 6 fields a 5 s 3 fid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 41 Primary Key Auto incrementing filter ID s 6 format a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 74 Foreign key The filter formats format to which this filter is assigned s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 32 The origin module of the filter s 5 delta 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 62 ID to identify which filter within module is being referenced 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 31 Weight of filter within format s 11 primary key a 1 i 0 s 3 fid s 11 unique keys a 1 s 3 fmd a 3 i 0 s 6 format i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 4 i 0 s 6 format i 1 s 6 weight i 2 s 6 module i 3 s 5 delta s 6 module s 6 filter s 4 name s 7 filters s 14 filter formats a 6 s 11 description s 73 Stores input formats custom groupings of filters such as Filtered HTML s 6 fields a 4 s 6 format a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 34 Primary Key Unique ID for format 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 41 Name of the input format Filtered HTML s 5 roles 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 57 A comma separated string of roles references role rid s 5 cache 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 77 Flag to indicate whether format is cachable 1 cachable 0 not cachable s 11 primary key a 1 i 0 s 6 format s 11 unique keys a 1 s 4 name a 1 i 0 s 4 name s 6 module s 6 filter s 4 name s 14 filter formats s 12 cache filter a 6 s 11 description s 128 Cache table for the Filter module to store already filtered pieces of text identified by input format and md5 hash of the text 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 filter s 4 name s 12 cache filter s 9 languages a 6 s 11 description s 46 List of all available languages in the system s 6 fields a 11 s 8 language a 5 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 description s 36 Language code e g de or en US s 4 name a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 25 Language name in English s 6 native a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 21 Native language name s 9 direction a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 61 Direction of language Left to Right 0 Right to Left 1 s 7 enabled a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 41 Enabled flag 1 Enabled 0 Disabled s 7 plurals a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 42 Number of plural indexes in this language s 7 formula a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b

    Original URL path: http://nederdev.nl/tags/internet?destination=taxonomy%2Fterm%2F21 (2016-01-29)
    Open archived version from archive


  • Gilde van Front-Enders | Nederdev
    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 or

    Original URL path: http://nederdev.nl/blog/gilde-van-front-enders?destination=node%2F22 (2016-01-29)
    Open archived version from archive

  • business | Nederdev
    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 1454050736 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 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 UPDATE cache SET data a 62 s 6 blocks a 7 s 11 description s 62 Stores block settings such as region and visibility settings s 6 fields a 13 s 3 bid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 29 Primary Key Unique block ID s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 126 The module from which the block originates for example user for the Who s Online block and block for any custom blocks s 5 delta a 5 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 1 0 s 11 description s 36 Unique ID for block within a module s 5 theme a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 47 The theme under which the block settings apply s 6 status 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 49 Block enabled status 1 enabled 0 disabled 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 27 Block weight within region s 6 region a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 43 Theme region within which the block is set s 6 custom 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 169 Flag to indicate how users may control visibility of the block 0 Users cannot control 1 On by default but can be hidden 2 Hidden by default but can be shown s 8 throttle 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 113 Flag to indicate whether or not to remove block when website traffic is high 1 throttle 0 do not throttle s 10 visibility 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 169 Flag to indicate how to show blocks on pages 0 Show on all pages except listed pages 1 Show only on listed pages 2 Use custom PHP code to determine visibility s 5 pages a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 148 Contents of the Pages block contains either a list of paths on which to include exclude the block or PHP code depending on visibility setting s 5 title a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 154 Custom title for the block Empty string will use block default title lt none gt will remove the title text will cause block to use specified title s 5 cache a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 4 tiny s 11 description s 215 Binary flag to indicate block cache mode 1 Do not cache 1 Cache per role 2 Cache per user 4 Cache per page 8 Block cache global See BLOCK CACHE constants in block module for more detailed information s 11 primary key a 1 i 0 s 3 bid s 11 unique keys a 1 s 3 tmd a 3 i 0 s 5 theme i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 5 i 0 s 5 theme i 1 s 6 status i 2 s 6 region i 3 s 6 weight i 4 s 6 module s 6 module s 5 block s 4 name s 6 blocks s 12 blocks roles a 6 s 11 description s 57 Sets up access permissions for blocks based on user roles s 6 fields a 3 s 6 module a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 11 description s 48 The block s origin module from blocks module s 5 delta a 4 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 11 description s 60 The block s unique delta within module from blocks delta s 3 rid a 4 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 11 description s 42 The user s role ID from users roles rid s 11 primary key a 3 i 0 s 6 module i 1 s 5 delta i 2 s 3 rid s 7 indexes a 1 s 3 rid a 1 i 0 s 3 rid s 6 module s 5 block s 4 name s 12 blocks roles s 5 boxes a 6 s 11 description s 38 Stores contents of custom made blocks s 6 fields a 4 s 3 bid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 25 The block s blocks bid s 4 body a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 15 Block contents s 4 info a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 18 Block description s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 69 Block body s filter formats format for example 1 Filtered HTML s 11 unique keys a 1 s 4 info a 1 i 0 s 4 info s 11 primary key a 1 i 0 s 3 bid s 6 module s 5 block s 4 name s 5 boxes s 11 cache block a 6 s 11 description s 204 Cache table for the Block module to store already built blocks identified by module delta and various contexts which may change the block such as theme locale and caching mode defined for the block 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 5 block s 4 name s 11 cache block s 8 comments a 6 s 11 description s 36 Stores comments and associated data s 6 fields a 14 s 3 cid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 31 Primary Key Unique comment ID s 3 pid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 117 The comments cid to which this comment is a reply If set to 0 this comment is not a reply to an existing comment s 3 nid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 48 The node nid to which this comment is a reply s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 101 The users uid who authored the comment If set to 0 this comment was created by an anonymous user s 7 subject a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 18 The comment title s 7 comment a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 17 The comment body s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 23 The author s host name s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 89 The time that the comment was created or last edited by its author as a Unix timestamp s 6 status 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 69 The published status of a comment 0 Published 1 Not Published s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 48 The filter formats format of the comment body s 6 thread a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 11 description s 62 The vancode representation of the comment s place in a thread s 4 name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 124 The comment author s name Uses users name if the user is logged in otherwise uses the value typed into the comment form s 4 mail a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 0 s 11 description s 169 The comment author s e mail address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 8 homepage a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 0 s 11 description s 172 The comment author s home page address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 7 indexes a 3 s 3 pid a 1 i 0 s 3 pid s 3 nid a 1 i 0 s 3 nid s 6 status a 1 i 0 s 6 status s 11 primary key a 1 i 0 s 3 cid s 6 module s 7 comment s 4 name s 8 comments s 23 node comment statistics a 6 s 11 description s 82 Maintains statistics of node and comments posts to show new and updated flags s 6 fields a 5 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 53 The node nid for which the statistics are compiled s 22 last comment timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 99 The Unix timestamp of the last comment that was posted within this node from comments timestamp s 17 last comment name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 83 The name of the latest author to post a comment on this node from comments name s 16 last comment uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 85 The user ID of the latest author to post a comment on this node from comments uid s 13 comment count 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 42 The total number of comments on this node s 11 primary key a 1 i 0 s 3 nid s 7 indexes a 1 s 22 node comment timestamp a 1 i 0 s 22 last comment timestamp s 6 module s 7 comment s 4 name s 23 node comment statistics s 8 watchdog a 6 s 11 description s 46 Table that contains logs of all system events s 6 fields a 11 s 3 wid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 38 Primary Key Unique watchdog event ID s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 52 The users uid of the user who triggered the event s 4 type a 5 s 4 type s 7 varchar s 6 length i 16 s 8 not null b 1 s 7 default s 0 s 11 description s 60 Type of log message for example user or page not found s 7 message a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 55 Text of log message to be passed into the t function s 9 variables a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 101 Serialized array of variables that match the message string and that is passed into the t function s 8 severity 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 The severity level of the event ranges from 0 Emergency to 7 Debug s 4 link 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 37 Link to view the result of the event s 8 location a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 31 URL of the origin of the event s 7 referer a 3 s 4 type s 4 text s 8 not null b 0 s 11 description s 22 URL of referring page s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 45 Hostname of the user who triggered the event s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 38 Unix timestamp of when event occurred s 11 primary key a 1 i 0 s 3 wid s 7 indexes a 1 s 4 type a 1 i 0 s 4 type s 6 module s 5 dblog s 4 name s 8 watchdog s 7 filters a 7 s 11 description s 74 Table that maps filters HTML corrector to input formats Filtered HTML s 6 fields a 5 s 3 fid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 41 Primary Key Auto incrementing filter ID s 6 format a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 74 Foreign key The filter formats format to which this filter is assigned s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 32 The origin module of the filter s 5 delta 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 62 ID to identify which filter within module is being referenced 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 31 Weight of filter within format s 11 primary key a 1 i 0 s 3 fid s 11 unique keys a 1 s 3 fmd a 3 i 0 s 6 format i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 4 i 0 s 6 format i 1 s 6 weight i 2 s 6 module i 3 s 5 delta s 6 module s 6 filter s 4 name s 7 filters s 14 filter formats a 6 s 11 description s 73 Stores input formats custom groupings of filters such as Filtered HTML s 6 fields a 4 s 6 format a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 34 Primary Key Unique ID for format 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 41 Name of the input format Filtered HTML s 5 roles 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 57 A comma separated string of roles references role rid s 5 cache 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 77 Flag to indicate whether format is cachable 1 cachable 0 not cachable s 11 primary key a 1 i 0 s 6 format s 11 unique keys a 1 s 4 name a 1 i 0 s 4 name s 6 module s 6 filter s 4 name s 14 filter formats s 12 cache filter a 6 s 11 description s 128 Cache table for the Filter module to store already filtered pieces of text identified by input format and md5 hash of the text 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 filter s 4 name s 12 cache filter s 9 languages a 6 s 11 description s 46 List of all available languages in the system s 6 fields a 11 s 8 language a 5 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 description s 36 Language code e g de or en US s 4 name a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 25 Language name in English s 6 native a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 21 Native language name s 9 direction a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 61 Direction of language Left to Right 0 Right to Left 1 s 7 enabled a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 41 Enabled flag 1 Enabled 0 Disabled s 7 plurals a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description

    Original URL path: http://nederdev.nl/tags/business?destination=taxonomy%2Fterm%2F22 (2016-01-29)
    Open archived version from archive

  • Theme override functies in Drupal | Nederdev
    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 32 s 8

    Original URL path: http://nederdev.nl/articles/theme-override-functies-drupal?destination=node%2F19 (2016-01-29)
    Open archived version from archive

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

    Original URL path: http://nederdev.nl/blog/safari-voor-windows?destination=node%2F25 (2016-01-29)
    Open archived version from archive

  • safari | Nederdev
    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 1454050831 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 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 UPDATE cache SET data a 62 s 6 blocks a 7 s 11 description s 62 Stores block settings such as region and visibility settings s 6 fields a 13 s 3 bid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 29 Primary Key Unique block ID s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 126 The module from which the block originates for example user for the Who s Online block and block for any custom blocks s 5 delta a 5 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 1 0 s 11 description s 36 Unique ID for block within a module s 5 theme a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 47 The theme under which the block settings apply s 6 status 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 49 Block enabled status 1 enabled 0 disabled 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 27 Block weight within region s 6 region a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 43 Theme region within which the block is set s 6 custom 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 169 Flag to indicate how users may control visibility of the block 0 Users cannot control 1 On by default but can be hidden 2 Hidden by default but can be shown s 8 throttle 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 113 Flag to indicate whether or not to remove block when website traffic is high 1 throttle 0 do not throttle s 10 visibility 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 169 Flag to indicate how to show blocks on pages 0 Show on all pages except listed pages 1 Show only on listed pages 2 Use custom PHP code to determine visibility s 5 pages a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 148 Contents of the Pages block contains either a list of paths on which to include exclude the block or PHP code depending on visibility setting s 5 title a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 154 Custom title for the block Empty string will use block default title lt none gt will remove the title text will cause block to use specified title s 5 cache a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 4 tiny s 11 description s 215 Binary flag to indicate block cache mode 1 Do not cache 1 Cache per role 2 Cache per user 4 Cache per page 8 Block cache global See BLOCK CACHE constants in block module for more detailed information s 11 primary key a 1 i 0 s 3 bid s 11 unique keys a 1 s 3 tmd a 3 i 0 s 5 theme i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 5 i 0 s 5 theme i 1 s 6 status i 2 s 6 region i 3 s 6 weight i 4 s 6 module s 6 module s 5 block s 4 name s 6 blocks s 12 blocks roles a 6 s 11 description s 57 Sets up access permissions for blocks based on user roles s 6 fields a 3 s 6 module a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 11 description s 48 The block s origin module from blocks module s 5 delta a 4 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 11 description s 60 The block s unique delta within module from blocks delta s 3 rid a 4 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 11 description s 42 The user s role ID from users roles rid s 11 primary key a 3 i 0 s 6 module i 1 s 5 delta i 2 s 3 rid s 7 indexes a 1 s 3 rid a 1 i 0 s 3 rid s 6 module s 5 block s 4 name s 12 blocks roles s 5 boxes a 6 s 11 description s 38 Stores contents of custom made blocks s 6 fields a 4 s 3 bid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 25 The block s blocks bid s 4 body a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 15 Block contents s 4 info a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 18 Block description s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 69 Block body s filter formats format for example 1 Filtered HTML s 11 unique keys a 1 s 4 info a 1 i 0 s 4 info s 11 primary key a 1 i 0 s 3 bid s 6 module s 5 block s 4 name s 5 boxes s 11 cache block a 6 s 11 description s 204 Cache table for the Block module to store already built blocks identified by module delta and various contexts which may change the block such as theme locale and caching mode defined for the block 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 5 block s 4 name s 11 cache block s 8 comments a 6 s 11 description s 36 Stores comments and associated data s 6 fields a 14 s 3 cid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 31 Primary Key Unique comment ID s 3 pid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 117 The comments cid to which this comment is a reply If set to 0 this comment is not a reply to an existing comment s 3 nid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 48 The node nid to which this comment is a reply s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 101 The users uid who authored the comment If set to 0 this comment was created by an anonymous user s 7 subject a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 18 The comment title s 7 comment a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 17 The comment body s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 23 The author s host name s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 89 The time that the comment was created or last edited by its author as a Unix timestamp s 6 status 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 69 The published status of a comment 0 Published 1 Not Published s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 48 The filter formats format of the comment body s 6 thread a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 11 description s 62 The vancode representation of the comment s place in a thread s 4 name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 124 The comment author s name Uses users name if the user is logged in otherwise uses the value typed into the comment form s 4 mail a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 0 s 11 description s 169 The comment author s e mail address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 8 homepage a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 0 s 11 description s 172 The comment author s home page address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 7 indexes a 3 s 3 pid a 1 i 0 s 3 pid s 3 nid a 1 i 0 s 3 nid s 6 status a 1 i 0 s 6 status s 11 primary key a 1 i 0 s 3 cid s 6 module s 7 comment s 4 name s 8 comments s 23 node comment statistics a 6 s 11 description s 82 Maintains statistics of node and comments posts to show new and updated flags s 6 fields a 5 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 53 The node nid for which the statistics are compiled s 22 last comment timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 99 The Unix timestamp of the last comment that was posted within this node from comments timestamp s 17 last comment name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 83 The name of the latest author to post a comment on this node from comments name s 16 last comment uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 85 The user ID of the latest author to post a comment on this node from comments uid s 13 comment count 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 42 The total number of comments on this node s 11 primary key a 1 i 0 s 3 nid s 7 indexes a 1 s 22 node comment timestamp a 1 i 0 s 22 last comment timestamp s 6 module s 7 comment s 4 name s 23 node comment statistics s 8 watchdog a 6 s 11 description s 46 Table that contains logs of all system events s 6 fields a 11 s 3 wid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 38 Primary Key Unique watchdog event ID s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 52 The users uid of the user who triggered the event s 4 type a 5 s 4 type s 7 varchar s 6 length i 16 s 8 not null b 1 s 7 default s 0 s 11 description s 60 Type of log message for example user or page not found s 7 message a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 55 Text of log message to be passed into the t function s 9 variables a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 101 Serialized array of variables that match the message string and that is passed into the t function s 8 severity 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 The severity level of the event ranges from 0 Emergency to 7 Debug s 4 link 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 37 Link to view the result of the event s 8 location a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 31 URL of the origin of the event s 7 referer a 3 s 4 type s 4 text s 8 not null b 0 s 11 description s 22 URL of referring page s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 45 Hostname of the user who triggered the event s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 38 Unix timestamp of when event occurred s 11 primary key a 1 i 0 s 3 wid s 7 indexes a 1 s 4 type a 1 i 0 s 4 type s 6 module s 5 dblog s 4 name s 8 watchdog s 7 filters a 7 s 11 description s 74 Table that maps filters HTML corrector to input formats Filtered HTML s 6 fields a 5 s 3 fid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 41 Primary Key Auto incrementing filter ID s 6 format a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 74 Foreign key The filter formats format to which this filter is assigned s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 32 The origin module of the filter s 5 delta 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 62 ID to identify which filter within module is being referenced 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 31 Weight of filter within format s 11 primary key a 1 i 0 s 3 fid s 11 unique keys a 1 s 3 fmd a 3 i 0 s 6 format i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 4 i 0 s 6 format i 1 s 6 weight i 2 s 6 module i 3 s 5 delta s 6 module s 6 filter s 4 name s 7 filters s 14 filter formats a 6 s 11 description s 73 Stores input formats custom groupings of filters such as Filtered HTML s 6 fields a 4 s 6 format a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 34 Primary Key Unique ID for format 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 41 Name of the input format Filtered HTML s 5 roles 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 57 A comma separated string of roles references role rid s 5 cache 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 77 Flag to indicate whether format is cachable 1 cachable 0 not cachable s 11 primary key a 1 i 0 s 6 format s 11 unique keys a 1 s 4 name a 1 i 0 s 4 name s 6 module s 6 filter s 4 name s 14 filter formats s 12 cache filter a 6 s 11 description s 128 Cache table for the Filter module to store already filtered pieces of text identified by input format and md5 hash of the text 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 filter s 4 name s 12 cache filter s 9 languages a 6 s 11 description s 46 List of all available languages in the system s 6 fields a 11 s 8 language a 5 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 description s 36 Language code e g de or en US s 4 name a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 25 Language name in English s 6 native a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 21 Native language name s 9 direction a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s

    Original URL path: http://nederdev.nl/tags/safari?destination=taxonomy%2Fterm%2F24 (2016-01-29)
    Open archived version from archive

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

    Original URL path: http://nederdev.nl/blog/veel-web-20-sites-niet-gebruiksvriendelijk?destination=node%2F26 (2016-01-29)
    Open archived version from archive

  • html | Nederdev
    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 1454051027 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 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 UPDATE cache SET data a 62 s 6 blocks a 7 s 11 description s 62 Stores block settings such as region and visibility settings s 6 fields a 13 s 3 bid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 29 Primary Key Unique block ID s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 126 The module from which the block originates for example user for the Who s Online block and block for any custom blocks s 5 delta a 5 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 7 default s 1 0 s 11 description s 36 Unique ID for block within a module s 5 theme a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 47 The theme under which the block settings apply s 6 status 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 49 Block enabled status 1 enabled 0 disabled 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 27 Block weight within region s 6 region a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 43 Theme region within which the block is set s 6 custom 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 169 Flag to indicate how users may control visibility of the block 0 Users cannot control 1 On by default but can be hidden 2 Hidden by default but can be shown s 8 throttle 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 113 Flag to indicate whether or not to remove block when website traffic is high 1 throttle 0 do not throttle s 10 visibility 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 169 Flag to indicate how to show blocks on pages 0 Show on all pages except listed pages 1 Show only on listed pages 2 Use custom PHP code to determine visibility s 5 pages a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 148 Contents of the Pages block contains either a list of paths on which to include exclude the block or PHP code depending on visibility setting s 5 title a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 154 Custom title for the block Empty string will use block default title lt none gt will remove the title text will cause block to use specified title s 5 cache a 5 s 4 type s 3 int s 8 not null b 1 s 7 default i 1 s 4 size s 4 tiny s 11 description s 215 Binary flag to indicate block cache mode 1 Do not cache 1 Cache per role 2 Cache per user 4 Cache per page 8 Block cache global See BLOCK CACHE constants in block module for more detailed information s 11 primary key a 1 i 0 s 3 bid s 11 unique keys a 1 s 3 tmd a 3 i 0 s 5 theme i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 5 i 0 s 5 theme i 1 s 6 status i 2 s 6 region i 3 s 6 weight i 4 s 6 module s 6 module s 5 block s 4 name s 6 blocks s 12 blocks roles a 6 s 11 description s 57 Sets up access permissions for blocks based on user roles s 6 fields a 3 s 6 module a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 11 description s 48 The block s origin module from blocks module s 5 delta a 4 s 4 type s 7 varchar s 6 length i 32 s 8 not null b 1 s 11 description s 60 The block s unique delta within module from blocks delta s 3 rid a 4 s 4 type s 3 int s 8 unsigned b 1 s 8 not null b 1 s 11 description s 42 The user s role ID from users roles rid s 11 primary key a 3 i 0 s 6 module i 1 s 5 delta i 2 s 3 rid s 7 indexes a 1 s 3 rid a 1 i 0 s 3 rid s 6 module s 5 block s 4 name s 12 blocks roles s 5 boxes a 6 s 11 description s 38 Stores contents of custom made blocks s 6 fields a 4 s 3 bid a 4 s 4 type s 6 serial s 8 unsigned b 1 s 8 not null b 1 s 11 description s 25 The block s blocks bid s 4 body a 4 s 4 type s 4 text s 8 not null b 0 s 4 size s 3 big s 11 description s 15 Block contents s 4 info a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 18 Block description s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 69 Block body s filter formats format for example 1 Filtered HTML s 11 unique keys a 1 s 4 info a 1 i 0 s 4 info s 11 primary key a 1 i 0 s 3 bid s 6 module s 5 block s 4 name s 5 boxes s 11 cache block a 6 s 11 description s 204 Cache table for the Block module to store already built blocks identified by module delta and various contexts which may change the block such as theme locale and caching mode defined for the block 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 5 block s 4 name s 11 cache block s 8 comments a 6 s 11 description s 36 Stores comments and associated data s 6 fields a 14 s 3 cid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 31 Primary Key Unique comment ID s 3 pid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 117 The comments cid to which this comment is a reply If set to 0 this comment is not a reply to an existing comment s 3 nid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 48 The node nid to which this comment is a reply s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 101 The users uid who authored the comment If set to 0 this comment was created by an anonymous user s 7 subject a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 18 The comment title s 7 comment a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 17 The comment body s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 23 The author s host name s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 89 The time that the comment was created or last edited by its author as a Unix timestamp s 6 status 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 69 The published status of a comment 0 Published 1 Not Published s 6 format a 5 s 4 type s 3 int s 4 size s 5 small s 8 not null b 1 s 7 default i 0 s 11 description s 48 The filter formats format of the comment body s 6 thread a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 1 s 11 description s 62 The vancode representation of the comment s place in a thread s 4 name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 124 The comment author s name Uses users name if the user is logged in otherwise uses the value typed into the comment form s 4 mail a 4 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 0 s 11 description s 169 The comment author s e mail address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 8 homepage a 4 s 4 type s 7 varchar s 6 length i 255 s 8 not null b 0 s 11 description s 172 The comment author s home page address from the comment form if user is anonymous and the Anonymous users may must leave their contact information setting is turned on s 7 indexes a 3 s 3 pid a 1 i 0 s 3 pid s 3 nid a 1 i 0 s 3 nid s 6 status a 1 i 0 s 6 status s 11 primary key a 1 i 0 s 3 cid s 6 module s 7 comment s 4 name s 8 comments s 23 node comment statistics a 6 s 11 description s 82 Maintains statistics of node and comments posts to show new and updated flags s 6 fields a 5 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 53 The node nid for which the statistics are compiled s 22 last comment timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 99 The Unix timestamp of the last comment that was posted within this node from comments timestamp s 17 last comment name a 4 s 4 type s 7 varchar s 6 length i 60 s 8 not null b 0 s 11 description s 83 The name of the latest author to post a comment on this node from comments name s 16 last comment uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 85 The user ID of the latest author to post a comment on this node from comments uid s 13 comment count 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 42 The total number of comments on this node s 11 primary key a 1 i 0 s 3 nid s 7 indexes a 1 s 22 node comment timestamp a 1 i 0 s 22 last comment timestamp s 6 module s 7 comment s 4 name s 23 node comment statistics s 8 watchdog a 6 s 11 description s 46 Table that contains logs of all system events s 6 fields a 11 s 3 wid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 38 Primary Key Unique watchdog event ID s 3 uid a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 52 The users uid of the user who triggered the event s 4 type a 5 s 4 type s 7 varchar s 6 length i 16 s 8 not null b 1 s 7 default s 0 s 11 description s 60 Type of log message for example user or page not found s 7 message a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 55 Text of log message to be passed into the t function s 9 variables a 4 s 4 type s 4 text s 8 not null b 1 s 4 size s 3 big s 11 description s 101 Serialized array of variables that match the message string and that is passed into the t function s 8 severity 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 The severity level of the event ranges from 0 Emergency to 7 Debug s 4 link 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 37 Link to view the result of the event s 8 location a 3 s 4 type s 4 text s 8 not null b 1 s 11 description s 31 URL of the origin of the event s 7 referer a 3 s 4 type s 4 text s 8 not null b 0 s 11 description s 22 URL of referring page s 8 hostname a 5 s 4 type s 7 varchar s 6 length i 128 s 8 not null b 1 s 7 default s 0 s 11 description s 45 Hostname of the user who triggered the event s 9 timestamp a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 38 Unix timestamp of when event occurred s 11 primary key a 1 i 0 s 3 wid s 7 indexes a 1 s 4 type a 1 i 0 s 4 type s 6 module s 5 dblog s 4 name s 8 watchdog s 7 filters a 7 s 11 description s 74 Table that maps filters HTML corrector to input formats Filtered HTML s 6 fields a 5 s 3 fid a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 41 Primary Key Auto incrementing filter ID s 6 format a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i 0 s 11 description s 74 Foreign key The filter formats format to which this filter is assigned s 6 module a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 32 The origin module of the filter s 5 delta 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 62 ID to identify which filter within module is being referenced 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 31 Weight of filter within format s 11 primary key a 1 i 0 s 3 fid s 11 unique keys a 1 s 3 fmd a 3 i 0 s 6 format i 1 s 6 module i 2 s 5 delta s 7 indexes a 1 s 4 list a 4 i 0 s 6 format i 1 s 6 weight i 2 s 6 module i 3 s 5 delta s 6 module s 6 filter s 4 name s 7 filters s 14 filter formats a 6 s 11 description s 73 Stores input formats custom groupings of filters such as Filtered HTML s 6 fields a 4 s 6 format a 3 s 4 type s 6 serial s 8 not null b 1 s 11 description s 34 Primary Key Unique ID for format 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 41 Name of the input format Filtered HTML s 5 roles 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 57 A comma separated string of roles references role rid s 5 cache 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 77 Flag to indicate whether format is cachable 1 cachable 0 not cachable s 11 primary key a 1 i 0 s 6 format s 11 unique keys a 1 s 4 name a 1 i 0 s 4 name s 6 module s 6 filter s 4 name s 14 filter formats s 12 cache filter a 6 s 11 description s 128 Cache table for the Filter module to store already filtered pieces of text identified by input format and md5 hash of the text 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 filter s 4 name s 12 cache filter s 9 languages a 6 s 11 description s 46 List of all available languages in the system s 6 fields a 11 s 8 language a 5 s 4 type s 7 varchar s 6 length i 12 s 8 not null b 1 s 7 default s 0 s 11 description s 36 Language code e g de or en US s 4 name a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 25 Language name in English s 6 native a 5 s 4 type s 7 varchar s 6 length i 64 s 8 not null b 1 s 7 default s 0 s 11 description s 21 Native language name s 9 direction a 4 s 4 type s 3 int s 8 not null b 1 s 7 default i

    Original URL path: http://nederdev.nl/tags/html?destination=taxonomy%2Fterm%2F25 (2016-01-29)
    Open archived version from archive



  •