exports.up = function(knex) {
  return knex.schema.createTable('users', function(t) {
    t.increments('id').unsigned().primary();

    t.string('uuid').notNull().index();
    t.string('username').notNull().index();
    t.string('password').notNull();
    t.string('email').nullable().index();
    t.string('phone').nullable();
    t.enum('access', ['Anonymous', 'Registered', 'Admin']).notNull().defaultTo('Anonymous');

    t.timestamps();
  })
};

exports.down = function(knex) {
  return knex.schema.dropTable('users');
};<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 href='/coinos-server.git/'>coinos-server.git</a></td><td class='form'><form method='get'>
<input type='hidden' name='id' value='9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'/><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' selected='selected'>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=square'>about</a><a href='/coinos-server.git/?h=square'>summary</a><a href='/coinos-server.git/refs/?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>refs</a><a href='/coinos-server.git/log/lib/webhooks.js.map?h=square'>log</a><a class='active' href='/coinos-server.git/tree/lib/webhooks.js.map?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>tree</a><a href='/coinos-server.git/commit/lib/webhooks.js.map?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>commit</a><a href='/coinos-server.git/diff/lib/webhooks.js.map?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>diff</a><a href='/coinos-server.git/stats/lib/webhooks.js.map?h=square'>stats</a></td><td class='form'><form class='right' method='get' action='/coinos-server.git/log/lib/webhooks.js.map'>
<input type='hidden' name='h' value='square'/><input type='hidden' name='id' value='9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'/><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=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>root</a>/<a href='/coinos-server.git/tree/lib?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>lib</a>/<a href='/coinos-server.git/tree/lib/webhooks.js.map?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>webhooks.js.map</a></div><div class='content'>blob: 40906dcdb7d799489f7707bff6e23b23ca74e09b (<a href='/coinos-server.git/plain/lib/webhooks.js.map?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>plain</a>) (<a href='/coinos-server.git/blame/lib/webhooks.js.map?h=square&amp;id=9c77d45cfb56e79e97b70678e21b8d6a56ec6c78'>blame</a>)
<table summary='blob content' class='blob'>
<tr><td class='linenumbers'><pre><a id='n1' href='#n1'>1</a>
</pre></td>
<td class='lines'><pre><code>