Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add sub-bullets in the description of the b-tree page type flag in fileformat2.html, for improved legibility. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ff214d6ba01b36546cd9850644b3956f |
| User & Date: | drh 2016-05-05 23:40:43 |
Context
|
2016-05-05
| ||
| 23:51 | Fix a typo in the Error and Warning log page. check-in: cf02ec8132 user: drh tags: trunk | |
| 23:40 | Add sub-bullets in the description of the b-tree page type flag in fileformat2.html, for improved legibility. check-in: ff214d6ba0 user: drh tags: trunk | |
| 13:33 | Merge changes from the 3.12 branch. check-in: d545903147 user: drh tags: trunk | |
Changes
Changes to pages/fileformat2.in.
562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 |
The b-tree page header is composed of the following fields:</p>
<center>
<i>B-tree Page Header Format</i><br>
<table border=1 width="80%">
<tr><th>Offset<th>Size<th>Description
<tr><td align=center valign=top>0<td align=center valign=top>1<td align=left>
^The one-byte flag at offset 0 indicating the b-tree page type.
^A value of 2 means the page is an interior index b-tree page.
^A value of 5 means the page is an interior table b-tree page.
^A value of 10 means the page is a leaf index b-tree page.
^A value of 13 means the page is a leaf table b-tree page.
^Any other value for the b-tree page type is an error.
<tr><td align=center valign=top>1<td align=center valign=top>2<td align=left>
^The two-byte integer at offset 1 gives the start of the
first freeblock on the page, or is zero if there are no freeblocks.
<tr><td align=center valign=top>3<td align=center valign=top>2<td align=left>
^The two-byte integer at offset 3 gives the number of cells on the page.
<tr><td align=center valign=top>5<td align=center valign=top>2<td align=left>
|
| | | | | |
562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 |
The b-tree page header is composed of the following fields:</p> <center> <i>B-tree Page Header Format</i><br> <table border=1 width="80%"> <tr><th>Offset<th>Size<th>Description <tr><td align=center valign=top>0<td align=center valign=top>1<td align=left> ^The one-byte flag at offset 0 indicating the b-tree page type.<ul> <li>^A value of 2 (0x02) means the page is an interior index b-tree page. <li>^A value of 5 (0x05) means the page is an interior table b-tree page. <li>^A value of 10 (0x0a) means the page is a leaf index b-tree page. <li>^A value of 13 (0x0d) means the page is a leaf table b-tree page.</ul> ^Any other value for the b-tree page type is an error. <tr><td align=center valign=top>1<td align=center valign=top>2<td align=left> ^The two-byte integer at offset 1 gives the start of the first freeblock on the page, or is zero if there are no freeblocks. <tr><td align=center valign=top>3<td align=center valign=top>2<td align=left> ^The two-byte integer at offset 3 gives the number of cells on the page. <tr><td align=center valign=top>5<td align=center valign=top>2<td align=left> |