exports.up = function(knex) {
  return knex.schema.createTable('user_security', function(t) {
    t.increments('id').unsigned().primary();
    t.int('user_id').notNull();
    t.foreign('user_id').references('users.id');

    t.boolean('twofa').notNull().defaultTo(false);
    t.string('pin').notNull();
    t.string('otp_secret').nullable();
    t.string('seed').nullable();

    t.boolean('email_verified').notNull().default(false)
    t.boolean('phone_verified').notNull().default(false)
    t.boolean('kyc_verified').notNull().default(false)

    t.timestamps();
  })
};

exports.down = function(knex) {
  return knex.schema.dropTable('user_security');
};dex</a> : <a href='/coinos-server.git/'>coinos-server.git</a></td><td class='form'><form method='get'>
<input type='hidden' name='id' value='bf262fde314bd33f5040eccb5ac775ed92d6b766'/><select name='h' onchange='this.form.submit();'>
<option value='ark2'>ark2</option>
<option value='assets'>assets</option>
<option value='base'>base</option>
<option value='build'>build</option>
<option value='bun-elysia'>bun-elysia</option>
<option value='cashreq'>cashreq</option>
<option value='changeDefaultPass'>changeDefaultPass</option>
<option value='cjs'>cjs</option>
<option value='classic'>classic</option>
<option value='cln-rest'>cln-rest</option>
<option value='conversions'>conversions</option>
<option value='dChanges'>dChanges</option>
<option value='dev'>dev</option>
<option value='logging'>logging</option>
<option value='master'>master</option>
<option value='masterZ'>masterZ</option>
<option value='no-challenge'>no-challenge</option>
<option value='notifications'>notifications</option>
<option value='prod'>prod</option>
<option value='rJuly19'>rJuly19</option>
<option value='readme-update'>readme-update</option>
<option value='readmeUpdate'>readmeUpdate</option>
<option value='regtest-fulcrum'>regtest-fulcrum</option>
<option value='retransmit'>retransmit</option>
<option value='setup-updates'>setup-updates</option>
<option value='square'>square</option>
<option value='stageUpdate'>stageUpdate</option>
<option value='stageUpdate2'>stageUpdate2</option>
<option value='staging'>staging</option>
<option value='taxi'>taxi</option>
<option value='tdex'>tdex</option>
<option value='test'>test</option>
<option value='tickets'>tickets</option>
<option value='v1.0.0'>v1.0.0</option>
<option value='vue'>vue</option>
<option value='withdraw'>withdraw</option>
</select> <input type='submit' value='switch'/></form></td></tr>
<tr><td class='sub'>coinos server — legacy coinos.io backend (Lightning, on-chain, Liquid)</td><td class='sub right'>coinos</td></tr></table>
<table class='tabs'><tr><td>
<a href='/coinos-server.git/about/?h=regtest-data'>about</a><a href='/coinos-server.git/?h=regtest-data'>summary</a><a href='/coinos-server.git/refs/?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>refs</a><a href='/coinos-server.git/log/scripts/apiParse.js?h=regtest-data'>log</a><a class='active' href='/coinos-server.git/tree/scripts/apiParse.js?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>tree</a><a href='/coinos-server.git/commit/scripts/apiParse.js?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>commit</a><a href='/coinos-server.git/diff/scripts/apiParse.js?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>diff</a><a href='/coinos-server.git/stats/scripts/apiParse.js?h=regtest-data'>stats</a></td><td class='form'><form class='right' method='get' action='/coinos-server.git/log/scripts/apiParse.js'>
<input type='hidden' name='h' value='regtest-data'/><input type='hidden' name='id' value='bf262fde314bd33f5040eccb5ac775ed92d6b766'/><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='/coinos-server.git/tree/?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>root</a>/<a href='/coinos-server.git/tree/scripts?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>scripts</a>/<a href='/coinos-server.git/tree/scripts/apiParse.js?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>apiParse.js</a></div><div class='content'>blob: ec2a33c10a5ab8ddada4a304896f38610c592db0 (<a href='/coinos-server.git/plain/scripts/apiParse.js?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>plain</a>) (<a href='/coinos-server.git/blame/scripts/apiParse.js?h=regtest-data&amp;id=bf262fde314bd33f5040eccb5ac775ed92d6b766'>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>
</pre></td>
<td class='lines'><pre><code>