X-Git-Url: https://git.squeep.com/?a=blobdiff_plain;f=documentation%2Fmedia%2Fsqlite-er.svg;h=0d151f41186b93cc694552de79499581d421f299;hb=3ca7fccb306d0b23626befc3791ffa360b3db1e7;hp=e4a9c87feb8cb36a80907a60ed7d3b1f118e1e03;hpb=c37d8040d243375b0344d605444d0614a4d5f5d7;p=websub-hub

diff --git a/documentation/media/sqlite-er.svg b/documentation/media/sqlite-er.svg
index e4a9c87..0d151f4 100644
--- a/documentation/media/sqlite-er.svg
+++ b/documentation/media/sqlite-er.svg
@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
 <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
  "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
-<!-- Generated by graphviz version 2.49.0 (20210828.1703)
+<!-- Generated by graphviz version 2.50.0 (20211204.2007)
  -->
 <!-- Title: WebsubHubERD Pages: 1 -->
 <svg width="922pt" height="1084pt"
@@ -11,7 +11,7 @@
 <polygon fill="white" stroke="transparent" points="-4,4 -4,-1079.63 918,-1079.63 918,4 -4,4"/>
 <text text-anchor="middle" x="457" y="-1050.83" font-family="Times,serif" font-size="26.00">Websub Hub Entity&#45;Relations</text>
 <text text-anchor="middle" x="457" y="-1021.83" font-family="Times,serif" font-size="26.00">SQLite</text>
-<text text-anchor="middle" x="457" y="-992.83" font-family="Times,serif" font-size="26.00">Schema 1.0.3</text>
+<text text-anchor="middle" x="457" y="-992.83" font-family="Times,serif" font-size="26.00">Schema 1.1.0</text>
 <!-- topic -->
 <g id="node1" class="node">
 <title>topic</title>
@@ -52,6 +52,10 @@
 <text text-anchor="start" x="92.5" y="-335.93" font-family="Times,serif" font-size="14.00">content_hash</text>
 <polygon fill="none" stroke="black" points="0,-308.13 0,-329.13 280,-329.13 280,-308.13 0,-308.13"/>
 <text text-anchor="start" x="93.5" y="-314.93" font-family="Times,serif" font-size="14.00">content_type</text>
+<polygon fill="none" stroke="black" points="0,-287.13 0,-308.13 280,-308.13 280,-287.13 0,-287.13"/>
+<text text-anchor="start" x="105.5" y="-293.93" font-family="Times,serif" font-size="14.00">http_etag</text>
+<polygon fill="none" stroke="black" points="0,-266.13 0,-287.13 280,-287.13 280,-266.13 0,-266.13"/>
+<text text-anchor="start" x="73.5" y="-272.93" font-family="Times,serif" font-size="14.00">http_last_modified</text>
 </g>
 <!-- topic_fetch_in_progress -->
 <g id="node2" class="node">
@@ -234,17 +238,19 @@
 <!-- authentication -->
 <g id="node8" class="node">
 <title>authentication</title>
-<polygon fill="lightblue" stroke="transparent" points="67,-790.13 67,-813.13 213,-813.13 213,-790.13 67,-790.13"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="68,-791.13 68,-812.13 212,-812.13 212,-791.13 68,-791.13"/>
-<text text-anchor="start" x="71" y="-797.93" font-family="Times,serif" font-size="14.00">AUTHENTICATION</text>
+<polygon fill="lightblue" stroke="transparent" points="67,-811.13 67,-834.13 213,-834.13 213,-811.13 67,-811.13"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="68,-812.13 68,-833.13 212,-833.13 212,-812.13 68,-812.13"/>
+<text text-anchor="start" x="71" y="-818.93" font-family="Times,serif" font-size="14.00">AUTHENTICATION</text>
+<polygon fill="none" stroke="black" points="67,-790.13 67,-811.13 213,-811.13 213,-790.13 67,-790.13"/>
+<text text-anchor="start" x="112.5" y="-796.93" font-family="Times,serif" font-size="14.00">created</text>
 <polygon fill="none" stroke="black" points="67,-769.13 67,-790.13 213,-790.13 213,-769.13 67,-769.13"/>
-<text text-anchor="start" x="112.5" y="-775.93" font-family="Times,serif" font-size="14.00">created</text>
+<text text-anchor="start" x="73.5" y="-775.93" font-family="Times,serif" font-size="14.00">last_authenticated</text>
 <polygon fill="none" stroke="black" points="67,-748.13 67,-769.13 213,-769.13 213,-748.13 67,-748.13"/>
-<text text-anchor="start" x="73.5" y="-754.93" font-family="Times,serif" font-size="14.00">last_authenticated</text>
+<text text-anchor="start" x="106.5" y="-754.93" font-family="Times,serif" font-size="14.00">identifier</text>
 <polygon fill="none" stroke="black" points="67,-727.13 67,-748.13 213,-748.13 213,-727.13 67,-727.13"/>
-<text text-anchor="start" x="106.5" y="-733.93" font-family="Times,serif" font-size="14.00">identifier</text>
+<text text-anchor="start" x="103.5" y="-733.93" font-family="Times,serif" font-size="14.00">credential</text>
 <polygon fill="none" stroke="black" points="67,-706.13 67,-727.13 213,-727.13 213,-706.13 67,-706.13"/>
-<text text-anchor="start" x="103.5" y="-712.93" font-family="Times,serif" font-size="14.00">credential</text>
+<text text-anchor="start" x="112.5" y="-712.93" font-family="Times,serif" font-size="14.00">otp_key</text>
 </g>
 </g>
 </svg>