Documentation Source Text

Check-in [ff214d6ba0]
Login

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.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: ff214d6ba01b36546cd9850644b3956f915394df
User & Date: drh 2016-05-05 23:40:43.688
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
Unified Diff Ignore Whitespace Patch
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>