../rpki='robots' content='index, nofollow'/>
<link rel='stylesheet' type='text/css' href='/cgit.css'/>
<link rel='shortcut icon' href='/favicon.ico'/>
<link rel='alternate' title='Atom feed' href='https://git.hactrn.net/sra/rpki.net/atom/schemas/sql/pubd.sql?h=master' type='application/atom+xml'/>
<link rel='vcs-git' href='https://git.hactrn.net/sra/rpki.net' title='sra/rpki.net Git repository'/>
</head>
<body>
<div id='cgit'><table id='header'>
<tr>
<td class='logo' rowspan='2'><a href='/'><img src='/cgit.png' alt='cgit logo'/></a></td>
<td class='main'><a href='/'>index</a> : <a title='sra/rpki.net' href='/sra/rpki.net/'>sra/rpki.net</a></td><td class='form'><form method='get'>
<input type='hidden' name='id' value='5c0340d79966f52bcb5ff180a96b576f450cbca6'/><select name='h' onchange='this.form.submit();'>
<option value='master' selected='selected'>master</option>
<option value='zone-cleanup'>zone-cleanup</option>
</select> <input type='submit' value='switch'/></form></td></tr>
<tr><td class='sub'>Dragon Research Labs RPKI Toolkit</td><td class='sub right'>git user</td></tr></table>
<table class='tabs'><tr><td>
<a href='/sra/rpki.net/about/'>about</a><a href='/sra/rpki.net/'>summary</a><a href='/sra/rpki.net/refs/?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>refs</a><a href='/sra/rpki.net/log/schemas/sql/pubd.sql'>log</a><a class='active' href='/sra/rpki.net/tree/schemas/sql/pubd.sql?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>tree</a><a href='/sra/rpki.net/commit/schemas/sql/pubd.sql?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>commit</a><a href='/sra/rpki.net/diff/schemas/sql/pubd.sql?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>diff</a></td><td class='form'><form class='right' method='get' action='/sra/rpki.net/log/schemas/sql/pubd.sql'>
<input type='hidden' name='id' value='5c0340d79966f52bcb5ff180a96b576f450cbca6'/><select name='qt'>
<option value='grep'>log msg</option>
<option value='author'>author</option>
<option value='committer'>committer</option>
<option value='range'>range</option>
</select>
<input class='txt' type='search' size='10' name='q' value=''/>
<input type='submit' value='search'/>
</form>
</td></tr></table>
<div class='path'>path: <a href='/sra/rpki.net/tree/?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>root</a>/<a href='/sra/rpki.net/tree/schemas?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>schemas</a>/<a href='/sra/rpki.net/tree/schemas/sql?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>sql</a>/<a href='/sra/rpki.net/tree/schemas/sql/pubd.sql?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>pubd.sql</a></div><div class='content'>blob: 3a58ec00ff96dba8b4166af5382925fb907ae931 (<a href='/sra/rpki.net/plain/schemas/sql/pubd.sql?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>plain</a>) (<a href='/sra/rpki.net/blame/schemas/sql/pubd.sql?id=5c0340d79966f52bcb5ff180a96b576f450cbca6'>blame</a>)
<table summary='blob content' class='blob'>
<tr><td class='linenumbers'><pre><a id='n1' href='#n1'>1</a>
<a id='n2' href='#n2'>2</a>
<a id='n3' href='#n3'>3</a>
<a id='n4' href='#n4'>4</a>
<a id='n5' href='#n5'>5</a>
<a id='n6' href='#n6'>6</a>
<a id='n7' href='#n7'>7</a>
<a id='n8' href='#n8'>8</a>
<a id='n9' href='#n9'>9</a>
<a id='n10' href='#n10'>10</a>
<a id='n11' href='#n11'>11</a>
<a id='n12' href='#n12'>12</a>
<a id='n13' href='#n13'>13</a>
<a id='n14' href='#n14'>14</a>
<a id='n15' href='#n15'>15</a>
<a id='n16' href='#n16'>16</a>
<a id='n17' href='#n17'>17</a>
<a id='n18' href='#n18'>18</a>
<a id='n19' href='#n19'>19</a>
<a id='n20' href='#n20'>20</a>
<a id='n21' href='#n21'>21</a>
<a id='n22' href='#n22'>22</a>
<a id='n23' href='#n23'>23</a>
<a id='n24' href='#n24'>24</a>
<a id='n25' href='#n25'>25</a>
<a id='n26' href='#n26'>26</a>
<a id='n27' href='#n27'>27</a>
<a id='n28' href='#n28'>28</a>
<a id='n29' href='#n29'>29</a>
<a id='n30' href='#n30'>30</a>
<a id='n31' href='#n31'>31</a>
<a id='n32' href='#n32'>32</a>
<a id='n33' href='#n33'>33</a>
<a id='n34' href='#n34'>34</a>
<a id='n35' href='#n35'>35</a>
<a id='n36' href='#n36'>36</a>
<a id='n37' href='#n37'>37</a>
<a id='n38' href='#n38'>38</a>
<a id='n39' href='#n39'>39</a>
<a id='n40' href='#n40'>40</a>
<a id='n41' href='#n41'>41</a>
<a id='n42' href='#n42'>42</a>
<a id='n43' href='#n43'>43</a>
<a id='n44' href='#n44'>44</a>
<a id='n45' href='#n45'>45</a>
<a id='n46' href='#n46'>46</a>
<a id='n47' href='#n47'>47</a>
<a id='n48' href='#n48'>48</a>
<a id='n49' href='#n49'>49</a>
<a id='n50' href='#n50'>50</a>
<a id='n51' href='#n51'>51</a>
<a id='n52' href='#n52'>52</a>
<a id='n53' href='#n53'>53</a>
<a id='n54' href='#n54'>54</a>
<a id='n55' href='#n55'>55</a>
<a id='n56' href='#n56'>56</a>
<a id='n57' href='#n57'>57</a>
<a id='n58' href='#n58'>58</a>
<a id='n59' href='#n59'>59</a>
</pre></td>
<td class='lines'><pre><code><style>pre { line-height: 125%; }
td.linenos .normal { color: inherit; background-color: transparent; padding-left: 5px; padding-right: 5px; }
span.linenos { color: inherit; background-color: transparent; padding-left: 5px; padding-right: 5px; }
td.linenos .special { color: #000000; background-color: #ffffc0; padding-left: 5px; padding-right: 5px; }
span.linenos.special { color: #000000; background-color: #ffffc0; padding-left: 5px; padding-right: 5px; }
.highlight .hll { background-color: #ffffcc }
.highlight .c { color: #888888 } /* Comment */
.highlight .err { color: #a61717; background-color: #e3d2d2 } /* Error */
.highlight .k { color: #008800; font-weight: bold } /* Keyword */
.highlight .ch { color: #888888 } /* Comment.Hashbang */
.highlight .cm { color: #888888 } /* Comment.Multiline */
.highlight .cp { color: #cc0000; font-weight: bold } /* Comment.Preproc */
.highlight .cpf { color: #888888 } /* Comment.PreprocFile */
.highlight .c1 { color: #888888 } /* Comment.Single */
.highlight .cs { color: #cc0000; font-weight: bold; background-color: #fff0f0 } /* Comment.Special */
.highlight .gd { color: #000000; background-color: #ffdddd } /* Generic.Deleted */
.highlight .ge { font-style: italic } /* Generic.Emph */
.highlight .ges { font-weight: bold; font-style: italic } /* Generic.EmphStrong */
.highlight .gr { color: #aa0000 } /* Generic.Error */
.highlight .gh { color: #333333 } /* Generic.Heading */
.highlight .gi { color: #000000; background-color: #ddffdd } /* Generic.Inserted */
.highlight .go { color: #888888 } /* Generic.Output */
.highlight .gp { color: #555555 } /* Generic.Prompt */
.highlight .gs { font-weight: bold } /* Generic.Strong */
.highlight .gu { color: #666666 } /* Generic.Subheading */
.highlight .gt { color: #aa0000 } /* Generic.Traceback */
.highlight .kc { color: #008800; font-weight: bold } /* Keyword.Constant */
.highlight .kd { color: #008800; font-weight: bold } /* Keyword.Declaration */
.highlight .kn { color: #008800; font-weight: bold } /* Keyword.Namespace */
.highlight .kp { color: #008800 } /* Keyword.Pseudo */
.highlight .kr { color: #008800; font-weight: bold } /* Keyword.Reserved */
.highlight .kt { color: #888888; font-weight: bold } /* Keyword.Type */
.highlight .m { color: #0000DD; font-weight: bold } /* Literal.Number */
.highlight .s { color: #dd2200; background-color: #fff0f0 } /* Literal.String */
.highlight .na { color: #336699 } /* Name.Attribute */
.highlight .nb { color: #003388 } /* Name.Builtin */
.highlight .nc { color: #bb0066; font-weight: bold } /* Name.Class */
.highlight .no { color: #003366; font-weight: bold } /* Name.Constant */
.highlight .nd { color: #555555 } /* Name.Decorator */
.highlight .ne { color: #bb0066; font-weight: bold } /* Name.Exception */
.highlight .nf { color: #0066bb; font-weight: bold } /* Name.Function */
.highlight .nl { color: #336699; font-style: italic } /* Name.Label */
.highlight .nn { color: #bb0066; font-weight: bold } /* Name.Namespace */
.highlight .py { color: #336699; font-weight: bold } /* Name.Property */
.highlight .nt { color: #bb0066; font-weight: bold } /* Name.Tag */
.highlight .nv { color: #336699 } /* Name.Variable */
.highlight .ow { color: #008800 } /* Operator.Word */
.highlight .w { color: #bbbbbb } /* Text.Whitespace */
.highlight .mb { color: #0000DD; font-weight: bold } /* Literal.Number.Bin */
.highlight .mf { color: #0000DD; font-weight: bold } /* Literal.Number.Float */
.highlight .mh { color: #0000DD; font-weight: bold } /* Literal.Number.Hex */
.highlight .mi { color: #0000DD; font-weight: bold } /* Literal.Number.Integer */
.highlight .mo { color: #0000DD; font-weight: bold } /* Literal.Number.Oct */
.highlight .sa { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Affix */
.highlight .sb { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Backtick */
.highlight .sc { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Char */
.highlight .dl { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Delimiter */
.highlight .sd { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Doc */
.highlight .s2 { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Double */
.highlight .se { color: #0044dd; background-color: #fff0f0 } /* Literal.String.Escape */
.highlight .sh { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Heredoc */
.highlight .si { color: #3333bb; background-color: #fff0f0 } /* Literal.String.Interpol */
.highlight .sx { color: #22bb22; background-color: #f0fff0 } /* Literal.String.Other */
.highlight .sr { color: #008800; background-color: #fff0ff } /* Literal.String.Regex */
.highlight .s1 { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Single */
.highlight .ss { color: #aa6600; background-color: #fff0f0 } /* Literal.String.Symbol */
.highlight .bp { color: #003388 } /* Name.Builtin.Pseudo */
.highlight .fm { color: #0066bb; font-weight: bold } /* Name.Function.Magic */
.highlight .vc { color: #336699 } /* Name.Variable.Class */
.highlight .vg { color: #dd7700 } /* Name.Variable.Global */
.highlight .vi { color: #3333bb } /* Name.Variable.Instance */
.highlight .vm { color: #336699 } /* Name.Variable.Magic */
.highlight .il { color: #0000DD; font-weight: bold } /* Literal.Number.Integer.Long */</style><div class="highlight"><pre><span></span><span class="o">--</span><span class="w"> </span><span class="err">$</span><span class="n">Id</span><span class="err">$</span>

<span class="o">--</span><span class="w"> </span><span class="n">Copyright</span><span class="w"> </span><span class="p">(</span><span class="n">C</span><span class="p">)</span><span class="w"> </span><span class="mi">2009</span><span class="o">--</span><span class="mi">2010</span><span class="w">  </span><span class="n">Internet</span><span class="w"> </span><span class="n">Systems</span><span class="w"> </span><span class="n">Consortium</span><span class="w"> </span><span class="p">(</span><span class="ss">&quot;ISC&quot;</span><span class="p">)</span>
<span class="o">--</span>
<span class="o">--</span><span class="w"> </span><span class="n">Permission</span><span class="w"> </span><span class="k">to</span><span class="w"> </span><span class="k">use</span><span class="p">,</span><span class="w"> </span><span class="n">copy</span><span class="p">,</span><span class="w"> </span><span class="k">modify</span><span class="p">,</span><span class="w"> </span><span class="ow">and</span><span class="w"> </span><span class="n">distribute</span><span class="w"> </span><span class="n">this</span><span class="w"> </span><span class="n">software</span><span class="w"> </span><span class="k">for</span><span class="w"> </span><span class="ow">any</span>
<span class="o">--</span><span class="w"> </span><span class="n">purpose</span><span class="w"> </span><span class="k">with</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="k">without</span><span class="w"> </span><span class="n">fee</span><span class="w"> </span><span class="k">is</span><span class="w"> </span><span class="n">hereby</span><span class="w"> </span><span class="n">granted</span><span class="p">,</span><span class="w"> </span><span class="n">provided</span><span class="w"> </span><span class="n">that</span><span class="w"> </span><span class="n">the</span><span class="w"> </span><span class="n">above</span>
<span class="o">--</span><span class="w"> </span><span class="n">copyright</span><span class="w"> </span><span class="n">notice</span><span class="w"> </span><span class="ow">and</span><span class="w"> </span><span class="n">this</span><span class="w"> </span><span class="n">permission</span><span class="w"> </span><span class="n">notice</span><span class="w"> </span><span class="n">appear</span><span class="w"> </span><span class="ow">in</span><span class="w"> </span><span class="ow">all</span><span class="w"> </span><span class="n">copies</span><span class="p">.</span>
<span class="o">--</span>
<span class="o">--</span><span class="w"> </span><span class="n">THE</span><span class="w"> </span><span class="n">SOFTWARE</span><span class="w"> </span><span class="k">IS</span><span class="w"> </span><span class="n">PROVIDED</span><span class="w"> </span><span class="ss">&quot;AS IS&quot;</span><span class="w"> </span><span class="ow">AND</span><span class="w"> </span><span class="n">ISC</span><span class="w"> </span><span class="n">DISCLAIMS</span><span class="w"> </span><span class="ow">ALL</span><span class="w"> </span><span class="n">WARRANTIES</span><span class="w"> </span><span class="k">WITH</span>
<span class="o">--</span><span class="w"> </span><span class="n">REGARD</span><span class="w"> </span><span class="k">TO</span><span class="w"> </span><span class="n">THIS</span><span class="w"> </span><span class="n">SOFTWARE</span><span class="w"> </span><span class="n">INCLUDING</span><span class="w"> </span><span class="ow">ALL</span><span class="w"> </span><span class="n">IMPLIED</span><span class="w"> </span><span class="n">WARRANTIES</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="n">MERCHANTABILITY</span>
<span class="o">--</span><span class="w"> </span><span class="ow">AND</span><span class="w"> </span><span class="n">FITNESS</span><span class="p">.</span><span class="w">  </span><span class="ow">IN</span><span class="w"> </span><span class="k">NO</span><span class="w"> </span><span class="n">EVENT</span><span class="w"> </span><span class="n">SHALL</span><span class="w"> </span><span class="n">ISC</span><span class="w"> </span><span class="n">BE</span><span class="w"> </span><span class="n">LIABLE</span><span class="w"> </span><span class="k">FOR</span><span class="w"> </span><span class="ow">ANY</span><span class="w"> </span><span class="n">SPECIAL</span><span class="p">,</span><span class="w"> </span><span class="n">DIRECT</span><span class="p">,</span>
<span class="o">--</span><span class="w"> </span><span class="n">INDIRECT</span><span class="p">,</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="n">CONSEQUENTIAL</span><span class="w"> </span><span class="n">DAMAGES</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="ow">ANY</span><span class="w"> </span><span class="n">DAMAGES</span><span class="w"> </span><span class="n">WHATSOEVER</span><span class="w"> </span><span class="n">RESULTING</span><span class="w"> </span><span class="k">FROM</span>
<span class="o">--</span><span class="w"> </span><span class="n">LOSS</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="k">USE</span><span class="p">,</span><span class="w"> </span><span class="k">DATA</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="n">PROFITS</span><span class="p">,</span><span class="w"> </span><span class="n">WHETHER</span><span class="w"> </span><span class="ow">IN</span><span class="w"> </span><span class="n">AN</span><span class="w"> </span><span class="k">ACTION</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="n">CONTRACT</span><span class="p">,</span><span class="w"> </span><span class="n">NEGLIGENCE</span>
<span class="o">--</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="n">OTHER</span><span class="w"> </span><span class="n">TORTIOUS</span><span class="w"> </span><span class="k">ACTION</span><span class="p">,</span><span class="w"> </span><span class="n">ARISING</span><span class="w"> </span><span class="k">OUT</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="ow">IN</span><span class="w"> </span><span class="k">CONNECTION</span><span class="w"> </span><span class="k">WITH</span><span class="w"> </span><span class="n">THE</span><span class="w"> </span><span class="k">USE</span><span class="w"> </span><span class="ow">OR</span>
<span class="o">--</span><span class="w"> </span><span class="n">PERFORMANCE</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="n">THIS</span><span class="w"> </span><span class="n">SOFTWARE</span><span class="p">.</span>

<span class="o">--</span><span class="w"> </span><span class="n">Copyright</span><span class="w"> </span><span class="p">(</span><span class="n">C</span><span class="p">)</span><span class="w"> </span><span class="mi">2008</span><span class="w">  </span><span class="n">American</span><span class="w"> </span><span class="n">Registry</span><span class="w"> </span><span class="k">for</span><span class="w"> </span><span class="n">Internet</span><span class="w"> </span><span class="n">Numbers</span><span class="w"> </span><span class="p">(</span><span class="ss">&quot;ARIN&quot;</span><span class="p">)</span>
<span class="o">--</span>
<span class="o">--</span><span class="w"> </span><span class="n">Permission</span><span class="w"> </span><span class="k">to</span><span class="w"> </span><span class="k">use</span><span class="p">,</span><span class="w"> </span><span class="n">copy</span><span class="p">,</span><span class="w"> </span><span class="k">modify</span><span class="p">,</span><span class="w"> </span><span class="ow">and</span><span class="w"> </span><span class="n">distribute</span><span class="w"> </span><span class="n">this</span><span class="w"> </span><span class="n">software</span><span class="w"> </span><span class="k">for</span><span class="w"> </span><span class="ow">any</span>
<span class="o">--</span><span class="w"> </span><span class="n">purpose</span><span class="w"> </span><span class="k">with</span><span class="w"> </span><span class="ow">or</span><span class="w"> </span><span class="k">without</span><span class="w"> </span><span class="n">fee</span><span class="w"> </span><span class="k">is</span><span class="w"> </span><span class="n">hereby</span><span class="w"> </span><span class="n">granted</span><span class="p">,</span><span class="w"> </span><span class="n">provided</span><span class="w"> </span><span class="n">that</span><span class="w"> </span><span class="n">the</span><span class="w"> </span><span class="n">above</span>
<span class="o">--</span><span class="w"> </span><span class="n">copyright</span><span class="w"> </span><span class="n">notice</span><span class="w"> </span><span class="ow">and</span><span class="w"> </span><span class="n">this</span><span class="w"> </span><span class="n">permission</span><span class="w"> </span><span class="n">notice</span><span class="w"> </span><span class="n">appear</span><span class="w"> </span><span class="ow">in</span><span class="w"> </span><span class="ow">all</span><span class="w"> </span><span class="n">copies</span><span class="p">.</span>
<span class="o">--</span>
<span class="o">--</span><span class="w"> </span><span class="n">THE</span><span class="w"> </span><span class="n">SOFTWARE</span><span class="w"> </span><span class="k">IS</span><span class="w"> </span><span class="n">PROVIDED</span><span class="w"> </span><span class="ss">&quot;AS IS&quot;</span><span class="w"> </span><span class="ow">AND</span><span class="w"> </span><span class="n">ARIN</span><span class="w"> </span><span class="n">DISCLAIMS</span><span class="w"> </span><span class="ow">ALL</span><span class="w"> </span><span class="n">WARRANTIES</span><span class="w"> </span><span class="k">WITH</span>
<span class="o">--</span><span class="w"> </span><span class="n">REGARD</span><span class="w"> </span><span class="k">TO</span><span class="w"> </span><span class="n">THIS</span><span class="w"> </span><span class="n">SOFTWARE</span><span class="w"> </span><span class="n">INCLUDING</span><span class="w"> </span><span class="ow">ALL</span><span class="w"> </span><span class="n">IMPLIED</span><span class="w"> </span><span class="n">WARRANTIES</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="n">MERCHANTABILITY</span>
<span class="o">--</span><span class="w"> </span><span class="ow">AND</span><span class="w"> </span><span class="n">FITNESS</span><span class="p">.</span><span class="w">  </span><span class="ow">IN</span><span class="w"> </span><span class="k">NO</span><span class="w"> </span><span class="n">EVENT</span><span class="w"> </span><span class="n">SHALL</span><span class="w"> </span><span class="n">ARIN</span><span class="w"> </span><span class="n">BE</span><span class="w"> </span><span class="n">LIABLE</span><span class="w"> </span><span class="k">FOR</span><span class="w"> </span><span class="ow">ANY</span><span class="w"> </span><span class="n">SPECIAL</span><span class="p">,</span><span class="w"> </span><span class="n">DIRECT</span><span class="p">,</span>
<span class="o">--</span><span class="w"> </span><span class="n">INDIRECT</span><span class="p">,</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="n">CONSEQUENTIAL</span><span class="w"> </span><span class="n">DAMAGES</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="ow">ANY</span><span class="w"> </span><span class="n">DAMAGES</span><span class="w"> </span><span class="n">WHATSOEVER</span><span class="w"> </span><span class="n">RESULTING</span><span class="w"> </span><span class="k">FROM</span>
<span class="o">--</span><span class="w"> </span><span class="n">LOSS</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="k">USE</span><span class="p">,</span><span class="w"> </span><span class="k">DATA</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="n">PROFITS</span><span class="p">,</span><span class="w"> </span><span class="n">WHETHER</span><span class="w"> </span><span class="ow">IN</span><span class="w"> </span><span class="n">AN</span><span class="w"> </span><span class="k">ACTION</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="n">CONTRACT</span><span class="p">,</span><span class="w"> </span><span class="n">NEGLIGENCE</span>
<span class="o">--</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="n">OTHER</span><span class="w"> </span><span class="n">TORTIOUS</span><span class="w"> </span><span class="k">ACTION</span><span class="p">,</span><span class="w"> </span><span class="n">ARISING</span><span class="w"> </span><span class="k">OUT</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="ow">OR</span><span class="w"> </span><span class="ow">IN</span><span class="w"> </span><span class="k">CONNECTION</span><span class="w"> </span><span class="k">WITH</span><span class="w"> </span><span class="n">THE</span><span class="w"> </span><span class="k">USE</span><span class="w"> </span><span class="ow">OR</span>
<span class="o">--</span><span class="w"> </span><span class="n">PERFORMANCE</span><span class="w"> </span><span class="k">OF</span><span class="w"> </span><span class="n">THIS</span><span class="w"> </span><span class="n">SOFTWARE</span><span class="p">.</span>

<span class="o">--</span><span class="w"> </span><span class="k">SQL</span><span class="w"> </span><span class="n">objects</span><span class="w"> </span><span class="n">needed</span><span class="w"> </span><span class="k">by</span><span class="w"> </span><span class="n">pubd</span><span class="p">.</span><span class="n">py</span><span class="p">.</span>

<span class="o">--</span><span class="w"> </span><span class="n">The</span><span class="w"> </span><span class="n">config</span><span class="w"> </span><span class="nc">table</span><span class="w"> </span><span class="k">is</span><span class="w"> </span><span class="n">weird</span><span class="w"> </span><span class="n">because</span><span class="w"> </span><span class="n">we</span><span class="err">&#39;</span><span class="n">re</span><span class="w"> </span><span class="n">really</span><span class="w"> </span><span class="k">only</span><span class="w"> </span><span class="k">using</span><span class="w"> </span><span class="n">it</span>
<span class="o">--</span><span class="w"> </span><span class="k">to</span><span class="w"> </span><span class="n">store</span><span class="w"> </span><span class="n">one</span><span class="w"> </span><span class="n">BPKI</span><span class="w"> </span><span class="n">CRL</span><span class="p">,</span><span class="w"> </span><span class="n">but</span><span class="w"> </span><span class="n">putting</span><span class="w"> </span><span class="n">this</span><span class="w"> </span><span class="n">here</span><span class="w"> </span><span class="n">lets</span><span class="w"> </span><span class="n">us</span><span class="w"> </span><span class="k">use</span><span class="w"> </span><span class="n">a</span><span class="w"> </span><span class="n">lot</span><span class="w"> </span><span class="k">of</span>
<span class="o">--</span><span class="w"> </span><span class="n">existing</span><span class="w"> </span><span class="n">machinery</span><span class="w"> </span><span class="ow">and</span><span class="w"> </span><span class="n">the</span><span class="w"> </span><span class="n">alternatives</span><span class="w"> </span><span class="k">are</span><span class="w"> </span><span class="n">whacky</span><span class="w"> </span><span class="ow">in</span><span class="w"> </span><span class="n">other</span><span class="w"> </span><span class="n">ways</span><span class="p">.</span>

<span class="k">DROP</span><span class="w"> </span><span class="nc">TABLE</span><span class="w"> </span><span class="k">IF</span><span class="w"> </span><span class="ow">EXISTS</span><span class="w"> </span><span class="n">client</span><span class="p">;</span>
<span class="k">DROP</span><span class="w"> </span><span class="nc">TABLE</span><span class="w"> </span><span class="k">IF</span><span class="w"> </span><span class="ow">EXISTS</span><span class="w"> </span><span class="n">config</span><span class="p">;</span>

<span class="k">CREATE</span><span class="w"> </span><span class="nc">TABLE</span><span class="w"> </span><span class="n">config</span><span class="w"> </span><span class="p">(</span>
<span class="w">        </span><span class="n">config_id</span><span class="w">               </span><span class="n">SERIAL</span><span class="w"> </span><span class="ow">NOT</span><span class="w"> </span><span class="k">NULL</span><span class="p">,</span>
<span class="w">        </span><span class="n">bpki_crl</span><span class="w">                </span><span class="n">LONGBLOB</span><span class="p">,</span>
<span class="w">        </span><span class="k">PRIMARY</span><span class="w"> </span><span class="k">KEY</span><span class="w">             </span><span class="p">(</span><span class="n">config_id</span><span class="p">)</span>
<span class="p">)</span><span class="w"> </span><span class="n">ENGINE</span><span class="o">=</span><span class="n">InnoDB</span><span class="p">;</span>

<span class="k">CREATE</span><span class="w"> </span><span class="nc">TABLE</span><span class="w"> </span><span class="n">client</span><span class="w"> </span><span class="p">(</span>
<span class="w">        </span><span class="n">client_id</span><span class="w">               </span><span class="n">SERIAL</span><span class="w"> </span><span class="ow">NOT</span><span class="w"> </span><span class="k">NULL</span><span class="p">,</span>
<span class="w">        </span><span class="n">client_handle</span><span class="w">           </span><span class="nc">VARCHAR</span><span class="p">(</span><span class="mi">255</span><span class="p">)</span><span class="w"> </span><span class="ow">NOT</span><span class="w"> </span><span class="k">NULL</span><span class="p">,</span>
<span class="w">        </span><span class="n">base_uri</span><span class="w">                </span><span class="nc">TEXT</span><span class="p">,</span>
<span class="w">        </span><span class="n">bpki_cert</span><span class="w">               </span><span class="n">LONGBLOB</span><span class="p">,</span>
<span class="w">        </span><span class="n">bpki_glue</span><span class="w">               </span><span class="n">LONGBLOB</span><span class="p">,</span>
<span class="w">        </span><span class="n">last_cms_timestamp</span><span class="w">      </span><span class="nc">DATETIME</span><span class="p">,</span>
<span class="w">        </span><span class="k">PRIMARY</span><span class="w"> </span><span class="k">KEY</span><span class="w">             </span><span class="p">(</span><span class="n">client_id</span><span class="p">),</span>
<span class="w">        </span><span class="k">UNIQUE</span><span class="w">                  </span><span class="p">(</span><span class="n">client_handle</span><span class="p">)</span>
<span class="p">)</span><span class="w"> </span><span class="n">ENGINE</span><span class="o">=</span><span class="n">InnoDB</span><span class="p">;</span>

<span class="o">--</span><span class="w"> </span><span class="k">Local</span><span class="w"> </span><span class="nl">Variables</span><span class="p">:</span>
<span class="o">--</span><span class="w"> </span><span class="n">indent</span><span class="o">-</span><span class="n">tabs</span><span class="o">-</span><span class="nl">mode</span><span class="p">:</span><span class="w"> </span><span class="n">nil</span>
<span class="c1">-- End:</span>
</pre></div>
</code></pre></td></tr></table>
</div> <!-- class=content -->
<div class='footer'>generated by <a href='https://git.zx2c4.com/cgit/about/'>cgit v1.2.3</a> (<a href='https://git-scm.com/'>git 2.25.1</a>) at 2025-05-16 18:54:18 +0000</div>
</div> <!-- id=cgit -->
</body>
</html>
