drupal book 的結構

 

 


DB 內的 Table

 

book

+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| mlid  | int(10) unsigned | NO   | PRI | 0       |       |
| nid   | int(10) unsigned | NO   | UNI | 0       |       |
| bid   | int(10) unsigned | NO   | MUL | 0       |       |
+-------+------------------+------+-----+---------+-------+

在同一目錄內的文章(nid)會有相同的 bid

select * from book where bid = 211;

+------+------+-----+
| mlid | nid  | bid |
+------+------+-----+
|  346 |  211 | 211 |
| 1052 |  323 | 211 |
| 1053 |  320 | 211 |
| 1054 |  233 | 211 |
| 1055 |  165 | 211 |
| 1056 |  924 | 211 |
| 1079 |  925 | 211 |
| 2387 | 2462 | 211 |
| 2391 | 2466 | 211 |
+------+------+-----+

menu_links

+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| menu_name    | varchar(32)      | NO   | MUL |         |                |
| mlid         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| plid         | int(10) unsigned | NO   |     | 0       |                |
| link_path    | varchar(255)     | NO   | MUL |         |                |
...

plid    # parent node's menu link id

 


Troubleshoot

 

book 的結構不正常時

/etc/init.d/memcached restart