https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&feed=atom&action=history
/Applications/MobileNotes.app - Revision history
2024-03-28T18:59:04Z
Revision history for this page on the wiki
MediaWiki 1.31.14
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=116920&oldid=prev
IAdam1n at 18:18, 16 September 2021
2021-09-16T18:18:18Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 18:18, 16 September 2021</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Line 501:</td>
<td colspan="2" class="diff-lineno">Line 501:</td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | short text</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | short text</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
</tr>
<tr>
<td class="diff-marker">−</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>For the two date / time fields in this table: This is a floating point number and indicates the number of seconds since <del class="diffchange diffchange-inline">1 January </del>2001.</div></td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>For the two date / time fields in this table: This is a floating point number and indicates the number of seconds since <ins class="diffchange diffchange-inline">{{date|</ins>2001<ins class="diffchange diffchange-inline">|01|01}}</ins>.</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===ZNOTEBODY===</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===ZNOTEBODY===</div></td>
</tr>
</table>
IAdam1n
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=53573&oldid=prev
Britta: adding conversion script
2016-07-23T23:37:48Z
<p>adding conversion script</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 23:37, 23 July 2016</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Line 576:</td>
<td colspan="2" class="diff-lineno">Line 576:</td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | big blob, content unknown (?)</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | big blob, content unknown (?)</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>== Convert ==</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>A script for converting a notes.sqlite file into a usable series of text files:</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#!/bin/bash</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>set -e</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>function adjust() {</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> date -j -f '%Y-%m-%d %H:%M:%S' "$1" +'%m/%d/%Y %H:%M:%S'</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>}</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>rm -rf notes.d</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>mkdir -p notes.d</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>sqlite3 notes.sqlite 'select</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> z_pk as id,</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> datetime(zcreationdate + 978307200, "unixepoch", "localtime") as created,</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> datetime(zmodificationdate + 978307200, "unixepoch", "localtime") as modified,</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> ztitle as title from znote</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>' | while IFS='|' read -r id created modified title; do</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> file=notes.d/"$id".html</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> sqlite3 notes.sqlite 'select zcontent from znotebody where zowner = '"$id" >"$file"</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> SetFile -d "$(adjust "$created")" -m "$(adjust "$modified")" "$file"</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> title=${title//[\/:.]/_}</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> mv "$file" notes.d/"$id - ${title:0:$((260-${#file}))}".html</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>done</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Parents ==</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Parents ==</div></td>
</tr>
</table>
Britta
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=48851&oldid=prev
IAdam1n: Updating
2015-10-13T09:10:11Z
<p>Updating</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 09:10, 13 October 2015</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td>
</tr>
<tr>
<td class="diff-marker">−</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Notes]] is the built-in system application to take quick text notes. To backup or restore the data of this application without [[iTunes]], the following information might be useful. Initial data for this analysis comes from an [[<del class="diffchange diffchange-inline">N88ap</del>|iPhone 3GS]] with firmware 3.1.3, which was later restored / upgraded to an [[<del class="diffchange diffchange-inline">N90ap</del>|iPhone 4]] and finally to an [[<del class="diffchange diffchange-inline">N94ap</del>|iPhone 4S]] with iOS 5.0.1. On lower or higher firmware versions there might be small differences in the data.</div></td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Notes]] is the built-in system application to take quick text notes. To backup or restore the data of this application without [[iTunes]], the following information might be useful. Initial data for this analysis comes from an [[<ins class="diffchange diffchange-inline">N88AP</ins>|iPhone 3GS]] with firmware 3.1.3, which was later restored / upgraded to an [[<ins class="diffchange diffchange-inline">N90AP</ins>|iPhone 4]] and finally to an [[<ins class="diffchange diffchange-inline">N94AP</ins>|iPhone 4S]] with iOS 5.0.1. On lower or higher firmware versions there might be small differences in the data.</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In the folder <code>/var/mobile/Library/Notes/</code> there are two files:</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In the folder <code>/var/mobile/Library/Notes/</code> there are two files:</div></td>
</tr>
</table>
IAdam1n
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=41925&oldid=prev
5urd: template
2014-08-15T20:17:54Z
<p>template</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 20:17, 15 August 2014</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Line 578:</td>
<td colspan="2" class="diff-lineno">Line 578:</td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Parents ==</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Parents ==</div></td>
</tr>
<tr>
<td class="diff-marker">−</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">[[:/</del>|<del class="diffchange diffchange-inline">Root]]/[[/</del>Applications<del class="diffchange diffchange-inline">|Applications]]</del></div></td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">{{parent</ins>|Applications<ins class="diffchange diffchange-inline">}}</ins></div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Filesystem]]</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Filesystem]]</div></td>
</tr>
</table>
5urd
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=41761&oldid=prev
IAdam1n: Adding to Filesystem category and adding a parents section.
2014-08-11T17:30:28Z
<p>Adding to <a href="/wiki/Category:Filesystem" title="Category:Filesystem">Filesystem category</a> and adding a parents section.</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 17:30, 11 August 2014</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Line 576:</td>
<td colspan="2" class="diff-lineno">Line 576:</td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | big blob, content unknown (?)</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | big blob, content unknown (?)</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>== Parents ==</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[:/|Root]]/[[/Applications|Applications]]</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Filesystem]]</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Filesystem]]</div></td>
</tr>
</table>
IAdam1n
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=41757&oldid=prev
IAdam1n: Adding to Filesystem category.
2014-08-11T17:14:10Z
<p>Adding to <a href="/wiki/Category:Filesystem" title="Category:Filesystem">Filesystem category</a>.</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 17:14, 11 August 2014</td>
</tr><tr>
<td colspan="2" class="diff-lineno">Line 576:</td>
<td colspan="2" class="diff-lineno">Line 576:</td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | big blob, content unknown (?)</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|style="text-align:left;" | big blob, content unknown (?)</div></td>
</tr>
<tr>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
<td class="diff-marker"> </td>
<td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td>
</tr>
<tr>
<td colspan="2" class="diff-empty"> </td>
<td class="diff-marker">+</td>
<td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Filesystem]]</div></td>
</tr>
</table>
IAdam1n
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=35954&oldid=prev
Britta: Britta moved page Notes to /Applications/MobileNotes.app: moving to more specific title that seems to be more standard on the wiki for stock applications
2013-09-30T23:22:39Z
<p>Britta moved page <a href="/wiki/Notes" class="mw-redirect" title="Notes">Notes</a> to <a href="/wiki//Applications/MobileNotes.app" title="/Applications/MobileNotes.app">/Applications/MobileNotes.app</a>: moving to more specific title that seems to be more standard on the wiki for stock applications</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #222; text-align: center;">Revision as of 23:22, 30 September 2013</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>
Britta
https://www.theiphonewiki.com/w/index.php?title=/Applications/MobileNotes.app&diff=24613&oldid=prev
Http: initial page
2012-02-23T01:03:02Z
<p>initial page</p>
<p><b>New page</b></p><div>[[Notes]] is the built-in system application to take quick text notes. To backup or restore the data of this application without [[iTunes]], the following information might be useful. Initial data for this analysis comes from an [[N88ap|iPhone 3GS]] with firmware 3.1.3, which was later restored / upgraded to an [[N90ap|iPhone 4]] and finally to an [[N94ap|iPhone 4S]] with iOS 5.0.1. On lower or higher firmware versions there might be small differences in the data.<br />
<br />
In the folder <code>/var/mobile/Library/Notes/</code> there are two files:<br />
*<code>notes.sqlite</code><br />
*<code>notes.idx</code><br />
The second file is probably used for indexing and can be recreated if deleted (?). Looking at the file <code>notes.sqlite</code>, this is an [http://www.sqlite.org/ SQLite database] with the following tables in it:<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!Z_ENT<br />
!table name<br />
!name2<br />
|-<br />
|<br />
|sqlite_master<br />
|<br />
|-<br />
|1<br />
|ZACCOUNT<br />
|Account<br />
|-<br />
|2<br />
|ZNEXTID<br />
|NextId<br />
|-<br />
|3<br />
|ZNOTE<br />
|Note<br />
|-<br />
|4<br />
|ZNOTEBODY<br />
|NoteBody<br />
|-<br />
|5<br />
|ZNOTECHANGE<br />
|NoteChange<br />
|-<br />
|6<br />
|ZPROPERTY<br />
|Property<br />
|-<br />
|7<br />
|ZSTORE<br />
|Store<br />
|-<br />
|<br />
|Z_PRIMARYKEY<br />
|<br />
|-<br />
|<br />
|Z_METADATA<br />
|<br />
|}<br />
The name2 in this list is the value used for the hash in NSStoreModelVersionHashes in the bplist of the field Z_PLIST in the table Z_METADATA. The same name2 is used in the table Z_PRIMARYKEY, field Z_NAME.<br />
<br />
The following indexes are defined:<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!index name<br />
!table name<br />
!field name<br />
|-<br />
|ZACCOUNT_ZDEFAULTSTORE_INDEX<br />
|ZACCOUNT<br />
|ZDEFAULTSTORE<br />
|-<br />
|ZNOTE_ZINTEGERID_INDEX<br />
|ZNOTE<br />
|ZINTEGERID<br />
|-<br />
|ZNOTE_ZSTORE_INDEX<br />
|ZNOTE<br />
|ZSTORE<br />
|-<br />
|ZNOTE_ZBODY_INDEX<br />
|ZNOTE<br />
|ZBODY<br />
|-<br />
|ZNOTEBODY_ZOWNER_INDEX<br />
|ZNOTEBODY<br />
|ZOWNER<br />
|-<br />
|ZNOTECHANGE_ZSTORE_INDEX<br />
|ZNOTECHANGE<br />
|ZSTORE<br />
|-<br />
|ZSTORE_ZACCOUNT_INDEX<br />
|ZSTORE<br />
|ZACCOUNT<br />
|}<br />
<br />
==Tables==<br />
===sqlite_master===<br />
This table is contained in every SQLite database and contains general information about the content. It has these fields:<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!description<br />
|-<br />
|type<br />
|style="text-align:left;" | either 'table' or 'index'<br />
|-<br />
|name<br />
|style="text-align:left;" | name of the table or index<br />
|-<br />
|tbl_name<br />
|style="text-align:left;" | same as name for table, related table name for index<br />
|-<br />
|rootpage<br />
|style="text-align:left;" | integer, internal id where to find the data (?)<br />
|-<br />
|sql<br />
|style="text-align:left;" | creation statement<br />
|}<br />
<br />
This is the content of this table:<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!type<br />
!name<br />
!tbl_name<br />
!rootpage<br />
!sql<br />
|-<br />
|table<br />
|ZACCOUNT<br />
|ZACCOUNT<br />
|3<br />
|style="text-align:left;" | CREATE TABLE ZACCOUNT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZTYPE INTEGER, ZDEFAULTSTORE INTEGER, ZNAME VARCHAR, ZACCOUNTIDENTIFIER VARCHAR, ZCONSTRAINTSPATH VARCHAR )<br />
|-<br />
|table<br />
|ZNEXTID<br />
|ZNEXTID<br />
|5<br />
|style="text-align:left;" | CREATE TABLE ZNEXTID ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCOUNTER INTEGER )<br />
|-<br />
|table<br />
|ZNOTE<br />
|ZNOTE<br />
|6<br />
|style="text-align:left;" | CREATE TABLE ZNOTE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCONTENTTYPE INTEGER, ZDELETEDFLAG INTEGER, ZINTEGERID INTEGER, ZCONTAINSCJK INTEGER, ZEXTERNALSERVERINTID INTEGER, ZEXTERNALFLAGS INTEGER, ZISBOOKKEEPINGENTRY INTEGER, ZSTORE INTEGER, ZBODY INTEGER, ZCREATIONDATE TIMESTAMP, ZMODIFICATIONDATE TIMESTAMP, ZTITLE VARCHAR, ZGUID VARCHAR, ZAUTHOR VARCHAR, ZSERVERID VARCHAR, ZSUMMARY VARCHAR )<br />
|-<br />
|table<br />
|ZNOTEBODY<br />
|ZNOTEBODY<br />
|10<br />
|style="text-align:left;" | CREATE TABLE ZNOTEBODY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZOWNER INTEGER, ZCONTENT VARCHAR, ZEXTERNALCONTENTREF VARCHAR, ZEXTERNALREPRESENTATION BLOB )<br />
|-<br />
|table<br />
|ZNOTECHANGE<br />
|ZNOTECHANGE<br />
|12<br />
|style="text-align:left;" | CREATE TABLE ZNOTECHANGE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCHANGETYPE INTEGER, ZSTORE INTEGER, ZNOTESERVERINTIDS BLOB, ZNOTEINTEGERIDS BLOB, ZNOTESERVERIDS BLOB )<br />
|-<br />
|table<br />
|ZPROPERTY<br />
|ZPROPERTY<br />
|14<br />
|style="text-align:left;" | CREATE TABLE ZPROPERTY ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZPROPERTYKEY VARCHAR, ZPROPERTYVALUE BLOB )<br />
|-<br />
|table<br />
|ZSTORE<br />
|ZSTORE<br />
|15<br />
|style="text-align:left;" | CREATE TABLE ZSTORE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZACCOUNT INTEGER, ZEXTERNALIDENTIFIER VARCHAR, ZNAME VARCHAR, ZSYNCANCHOR VARCHAR )<br />
|-<br />
|table<br />
|Z_PRIMARYKEY<br />
|Z_PRIMARYKEY<br />
|17<br />
|style="text-align:left;" | CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER)<br />
|-<br />
|table<br />
|Z_METADATA<br />
|Z_METADATA<br />
|18<br />
|style="text-align:left;" | CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB)<br />
|-<br />
|index<br />
|ZACCOUNT_ZDEFAULTSTORE_INDEX<br />
|ZACCOUNT<br />
|4<br />
|style="text-align:left;" | CREATE INDEX ZACCOUNT_ZDEFAULTSTORE_INDEX ON ZACCOUNT (ZDEFAULTSTORE)<br />
|-<br />
|index<br />
|ZNOTE_ZINTEGERID_INDEX<br />
|ZNOTE<br />
|7<br />
|style="text-align:left;" | CREATE INDEX ZNOTE_ZINTEGERID_INDEX ON ZNOTE (ZINTEGERID)<br />
|-<br />
|index<br />
|ZNOTE_ZSTORE_INDEX<br />
|ZNOTE<br />
|8<br />
|style="text-align:left;" | CREATE INDEX ZNOTE_ZSTORE_INDEX ON ZNOTE (ZSTORE)<br />
|-<br />
|index<br />
|ZNOTE_ZBODY_INDEX<br />
|ZNOTE<br />
|9<br />
|style="text-align:left;" | CREATE INDEX ZNOTE_ZBODY_INDEX ON ZNOTE (ZBODY)<br />
|-<br />
|index<br />
|ZNOTEBODY_ZOWNER_INDEX<br />
|ZNOTEBODY<br />
|11<br />
|style="text-align:left;" | CREATE INDEX ZNOTEBODY_ZOWNER_INDEX ON ZNOTEBODY (ZOWNER)<br />
|-<br />
|index<br />
|ZNOTECHANGE_ZSTORE_INDEX<br />
|ZNOTECHANGE<br />
|13<br />
|style="text-align:left;" | CREATE INDEX ZNOTECHANGE_ZSTORE_INDEX ON ZNOTECHANGE (ZSTORE)<br />
|-<br />
|index<br />
|ZSTORE_ZACCOUNT_INDEX<br />
|ZSTORE<br />
|16<br />
|style="text-align:left;" | CREATE INDEX ZSTORE_ZACCOUNT_INDEX ON ZSTORE (ZACCOUNT)<br />
|}<br />
Please note that the values for rootpage might differ in every database.<br />
<br />
===Z_PRIMARYKEY===<br />
This is used by the framework and holds an entry for every table. These are the fields in there:<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!description<br />
|-<br />
|Z_ENT<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | The identifier of the table<br />
|-<br />
|Z_NAME<br />
|VARCHAR<br />
|style="text-align:left;" | one of these values: 'Account', 'NextId', 'Note', 'NoteBody', 'NoteChange', 'Property', 'Store'<br />
|-<br />
|Z_SUPER<br />
|INTEGER<br />
|style="text-align:left;" | always 0<br />
|-<br />
|Z_MAX<br />
|INTEGER<br />
|style="text-align:left;" | highest Z_PK in the according table<br />
|}<br />
<br />
===Z_METADATA===<br />
This table is used by the framework and holds configuration data. There is only one record in the table.<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!description<br />
|-<br />
|Z_VERSION<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | value 1<br />
|-<br />
|Z_UUID<br />
|VARCHAR(255)<br />
|style="text-align:left;" | value 'D1694631-D07A-4223-9A61-42689DA4C76A' (?)<br />
|-<br />
|Z_PLIST<br />
|BLOB<br />
|style="text-align:left;" | binary plist<br />
|}<br />
<br />
The bplist holds this data:<br />
*LastIndexTidAlreadySetUp=true<br />
*LocalAccountAndStoreAlreadySetUp=false<br />
*NSPersistenceFrameworkVersion=386<br />
*NSStoreModelVersionHashes=dict:<br />
**Account=*<br />
**NextId=*<br />
**Note=*<br />
**NoteBody=*<br />
**NoteChange=*<br />
**Property=*<br />
**Store=*<br />
*NSStoreModelVersionHashesVersion=3<br />
*NSStoreModelVersionIdentifiers=array:<br />
**(one empty string)<br />
*NSStoreType=SQLite<br />
<nowiki>*</nowiki>data, base64 encoded 32-byte hash (calculation?)<br />
<br />
===ZSTORE===<br />
This table has only one record in it.<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!value / description<br />
|-<br />
|Z_PK<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | primary key<br />
|-<br />
|Z_ENT<br />
|INTEGER<br />
|style="text-align:left;" | 7 (table identifier)<br />
|-<br />
|Z_OPT<br />
|INTEGER<br />
|style="text-align:left;" | 193 (?)<br />
|-<br />
|ZACCOUNT<br />
|INTEGER<br />
|style="text-align:left;" | 1 (foreign key to ZACCOUNT table)<br />
|-<br />
|ZEXTERNALIDENTIFIER<br />
|VARCHAR<br />
|style="text-align:left;" | 'local://local/store'<br />
|-<br />
|ZNAME<br />
|VARCHAR<br />
|style="text-align:left;" | 'LOCAL_NOTES_STORE'<br />
|-<br />
|ZSYNCANCHOR<br />
|VARCHAR<br />
|style="text-align:left;" | NULL<br />
|}<br />
<br />
===ZACCOUNT===<br />
This table has only one record in it. Maybe these entries define different [[iTunes]] users. (?)<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!value / description<br />
|-<br />
|Z_PK<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | primary key<br />
|-<br />
|Z_ENT<br />
|INTEGER<br />
|style="text-align:left;" | 1 (table identifier)<br />
|-<br />
|Z_OPT<br />
|INTEGER<br />
|style="text-align:left;" | 1 (?)<br />
|-<br />
|ZTYPE<br />
|INTEGER<br />
|style="text-align:left;" | 0 (?)<br />
|-<br />
|ZDEFAULTSTORE<br />
|INTEGER<br />
|style="text-align:left;" | 1 (foreign key to ZSTORE table)<br />
|-<br />
|ZNAME<br />
|VARCHAR<br />
|style="text-align:left;" | 'LOCAL_NOTES_ACCOUNT'<br />
|-<br />
|ZACCOUNTIDENTIFIER<br />
|VARCHAR<br />
|style="text-align:left;" | 'local://local/account'<br />
|-<br />
|ZCONSTRAINTSPATH<br />
|VARCHAR<br />
|style="text-align:left;" | NULL<br />
|}<br />
<br />
===ZNEXTID===<br />
This table has only one record in it.<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!value / description<br />
|-<br />
|Z_PK<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | primary key<br />
|-<br />
|Z_ENT<br />
|INTEGER<br />
|style="text-align:left;" | 2 (table identifier)<br />
|-<br />
|Z_OPT<br />
|INTEGER<br />
|style="text-align:left;" | 31 (?)<br />
|-<br />
|ZCOUNTER<br />
|INTEGER<br />
|style="text-align:left;" | 320 (?)<br />
|}<br />
<br />
===ZPROPERTY===<br />
This table contains three rows.<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!value / description<br />
|-<br />
|Z_PK<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | primary key<br />
|-<br />
|Z_ENT<br />
|INTEGER<br />
|style="text-align:left;" | always 6 (table identifier)<br />
|-<br />
|Z_OPT<br />
|INTEGER<br />
|style="text-align:left;" | unknown (?), values 186 / 27 / 27<br />
|-<br />
|ZPROPERTYKEY<br />
|VARCHAR<br />
|style="text-align:left;" | values 'LastTransactionID' / 'DeviceSyncAnchorKey' / 'ComputerSyncAnchorKey'<br />
|-<br />
|ZPROPERTYVALUE<br />
|BLOB<br />
|NULL for the two AnchorKeys, but LastTransactionID contains a value - beginning with BLOB from other table.<br />
|}<br />
<br />
<br />
===ZNOTE===<br />
This table contains general infos about each note. There is one record for every note.<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!value / description<br />
|-<br />
|Z_PK<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | primary key<br />
|-<br />
|Z_ENT<br />
|INTEGER<br />
|style="text-align:left;" | always 3 (table identifier)<br />
|-<br />
|Z_OPT<br />
|INTEGER<br />
|style="text-align:left;" | unknown (?), the values 1,2,5,9,12,31,32 are being used here<br />
|-<br />
|ZCONTENTTYPE<br />
|INTEGER<br />
|style="text-align:left;" | always 0<br />
|-<br />
|ZDELETEDFLAG<br />
|INTEGER<br />
|style="text-align:left;" | always 0<br />
|-<br />
|ZINTEGERID<br />
|INTEGER<br />
|style="text-align:left;" | always the value of Z_PK multiplied by 10<br />
|-<br />
|ZCONTAINSCJK<br />
|INTEGER<br />
|style="text-align:left;" | always 0<br />
|-<br />
|ZEXTERNALSERVERINTID<br />
|INTEGER<br />
|style="text-align:left;" | always -4294967296 (?)<br />
|-<br />
|ZEXTERNALFLAGS<br />
|INTEGER<br />
|style="text-align:left;" | always 0<br />
|-<br />
|ZISBOOKKEEPINGENTRY<br />
|INTEGER<br />
|style="text-align:left;" | always 0<br />
|-<br />
|ZSTORE<br />
|INTEGER<br />
|style="text-align:left;" | always 1 (foreign key to ZSTORE table)<br />
|-<br />
|ZBODY<br />
|INTEGER<br />
|style="text-align:left;" | foreign key to ZNOTEBODY table, value matches Z_PK of this table<br />
|-<br />
|ZCREATIONDATE<br />
|TIMESTAMP<br />
|style="text-align:left;" | creation date and time of the note<br />
|-<br />
|ZMODIFICATIONDATE<br />
|TIMESTAMP<br />
|style="text-align:left;" | last modification date and time of the note<br />
|-<br />
|ZTITLE<br />
|VARCHAR<br />
|style="text-align:left;" | title for overview list<br />
|-<br />
|ZGUID<br />
|VARCHAR<br />
|style="text-align:left;" | always NULL<br />
|-<br />
|ZAUTHOR<br />
|VARCHAR<br />
|style="text-align:left;" | always NULL<br />
|-<br />
|ZSERVERID<br />
|VARCHAR<br />
|style="text-align:left;" | always NULL<br />
|-<br />
|ZSUMMARY<br />
|VARCHAR<br />
|style="text-align:left;" | short text<br />
|}<br />
For the two date / time fields in this table: This is a floating point number and indicates the number of seconds since 1 January 2001.<br />
<br />
===ZNOTEBODY===<br />
This table contains general infos about each note. There is one record for every note.<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!value / description<br />
|-<br />
|Z_PK<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | primary key<br />
|-<br />
|Z_ENT<br />
|INTEGER<br />
|style="text-align:left;" | always 4 (table identifier)<br />
|-<br />
|Z_OPT<br />
|INTEGER<br />
|style="text-align:left;" | unknown (?), the values 1,2,3,5,9,10,12,31,32 are being used here<br />
|-<br />
|ZOWNER<br />
|INTEGER<br />
|style="text-align:left;" | always matches Z_PK<br />
|-<br />
|ZCONTENT<br />
|VARCHAR<br />
|style="text-align:left;" | '''This is the actual content text (HTML format).'''<br />
|-<br />
|ZEXTERNALCONTENTREF<br />
|VARCHAR<br />
|style="text-align:left;" | always NULL<br />
|-<br />
|ZEXTERNALREPRESENTATION<br />
|BLOB<br />
|style="text-align:left;" | always NULL<br />
|}<br />
<br />
===ZNOTECHANGE===<br />
The purpose of this table is unknown. It is probably related to changes and synchronization.<br />
{| class="wikitable" style="font-size: smaller; text-align: center; table-layout: fixed; border-collapse: collapse;" border="1"<br />
|-<br />
!field name<br />
!type<br />
!value / description<br />
|-<br />
|Z_PK<br />
|INTEGER PRIMARY KEY<br />
|style="text-align:left;" | primary key<br />
|-<br />
|Z_ENT<br />
|INTEGER<br />
|style="text-align:left;" | always 5 (table identifier)<br />
|-<br />
|ZCHANGETYPE<br />
|INTEGER<br />
|style="text-align:left;" | unknown (?), values of 0,1,2 exist<br />
|-<br />
|ZSTORE<br />
|INTEGER<br />
|style="text-align:left;" | always 1 (foreign key to ZSTORE)<br />
|-<br />
|ZNOTESERVERINTIDS<br />
|BLOB<br />
|style="text-align:left;" | big blob, content unknown (?)<br />
|-<br />
|ZNOTEINTEGERIDS<br />
|BLOB<br />
|style="text-align:left;" | big blob, content unknown (?)<br />
|-<br />
|ZNOTESERVERIDS<br />
|BLOB<br />
|style="text-align:left;" | big blob, content unknown (?)<br />
|}</div>
Http