const { DataTypes } = require('sequelize');

const attributes = {
  id: {
    type: DataTypes.INTEGER(11),
    primaryKey: true,
    autoIncrement: true,
    allowNull: false
  },
  uuid: {
    type: DataTypes.STRING(255),
    allowNull: false,
    comment: "unique UUID as more secure reference"
  },
  password: {
    type: DataTypes.STRING(255),  // Encrypted Password type ?? 
    allowNull: false,
    validate: {
      len: [8, 255]
    }
  },
  email: {
    type: DataTypes.STRING(255),
    validate: {
      isEmail: true
    }
  },
  sms: {
    type: DataTypes.STRING(255),
    validate: {
      is: /^[0-9]+$/ // replace spaces, brackets, dashes dynamically prior to create
    }
  },
  email_verified: {
    type: DataTypes.BOOLEAN,
    allowNull: false,
    defaultValue: false,
  },
  sms_verified: {
    type: DataTypes.BOOLEAN,
    allowNull: false,
    defaultValue: false,
  },
  access: {
    type: DataTypes.ENUM,
    values: ['Member', 'Tester', 'Admin'],
    defaultValue: 'Member'
  }
}

const options = {
  tableName: "users",
  comment: "",
  timestamps: true,
  createdAt: 'created_at',
  updatedAt: 'updated_at',
  indexes: [
    {fields: ['uuid', 'email']}
  ]
};

db["User"] = db.define("users_model", attributes, options);


  // *** Move to user_preferences *** 
//   unit: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: 'SAT',
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "unit"
//   },
//   currency: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: "CAD",
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "currency"
//   },
//   currencies: {
//     type: DataTypes.JSON,
//     allowNull: false,
//     defaultValue: ["USD"],
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "currencies"
//   },

//   fiat: { ??? 
//     type: DataTypes.BOOLEAN,
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "fiat"
//   },

// ** Remove - redundant / unnecessary **
//   account_id: {
//     type: DataTypes.INTEGER(11),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "account_id"
//   },
//   twofa: { = otp_secret NOT NULL
//     type: DataTypes.INTEGER(1),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "twofa"
//   },

// *** Move to user_keys ***

//   otpsecret: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: "CAD",
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "otpsecret"
//   },
//   pin: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "pin"
//   },
//   seed: {
//     type: DataTypes.STRING(255),
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "seed"
//   },

// ** What are these exactly ... ? **
//   ip: { ?? 
//     type: DataTypes.INTEGER.UNSIGNED,
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "ip"
//   },

//   index: {
//     type: DataTypes.INTEGER,
//     allowNull: true,
//     defaultValue: 0,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "index"
//   },

// };

// *** Add breakout table
//   subscriptions: {
//     type: DataTypes.TEXT,
//     get: function() {
//       return JSON.parse(this.getDataValue("subscriptions"));
//     },
//     set: function(value) {
//       return this.setDataValue("subscriptions", JSON.stringify(value));
//     },
//     allowNull: true,
//     defaultValue: null,
//     primaryKey: false,
//     autoIncrement: false,
//     comment: null,
//     field: "subscriptions"
//   },

  // *** replaced with other field(s) ***
  // locked: { - embed logic with user status (?)
  //   type: DataTypes.BOOLEAN,
  //   allowNull: true,
  //   defaultValue: false,
  //   primaryKey: false,
  //   autoIncrement: false,
  //   comment: null,
  //   field: "locked"
  // },

  

'/><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-ui.git/tree/?h=invoice-requests&amp;id=8cfba57fced2548f3d2cf7cccaf43844ddbc3520'>root</a>/<a href='/coinos-ui.git/tree/src?h=invoice-requests&amp;id=8cfba57fced2548f3d2cf7cccaf43844ddbc3520'>src</a>/<a href='/coinos-ui.git/tree/src/components?h=invoice-requests&amp;id=8cfba57fced2548f3d2cf7cccaf43844ddbc3520'>components</a>/<a href='/coinos-ui.git/tree/src/components/Check.svelte?h=invoice-requests&amp;id=8cfba57fced2548f3d2cf7cccaf43844ddbc3520'>Check.svelte</a></div><div class='content'>blob: 4c9f504b09619f581174cb478f6c2796b4194e65 (<a href='/coinos-ui.git/plain/src/components/Check.svelte?h=invoice-requests&amp;id=8cfba57fced2548f3d2cf7cccaf43844ddbc3520'>plain</a>) (<a href='/coinos-ui.git/blame/src/components/Check.svelte?h=invoice-requests&amp;id=8cfba57fced2548f3d2cf7cccaf43844ddbc3520'>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>
</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: #888 } /* Comment */
.highlight .err { color: #A61717; background-color: #E3D2D2 } /* Error */
.highlight .k { color: #080; font-weight: bold } /* Keyword */
.highlight .ch { color: #888 } /* Comment.Hashbang */
.highlight .cm { color: #888 } /* Comment.Multiline */
.highlight .cp { color: #C00; font-weight: bold } /* Comment.Preproc */
.highlight .cpf { color: #888 } /* Comment.PreprocFile */
.highlight .c1 { color: #888 } /* Comment.Single */
.highlight .cs { color: #C00; font-weight: bold; background-color: #FFF0F0 } /* Comment.Special */
.highlight .gd { color: #000; background-color: #FDD } /* Generic.Deleted */
.highlight .ge { font-style: italic } /* Generic.Emph */
.highlight .ges { font-weight: bold; font-style: italic } /* Generic.EmphStrong */
.highlight .gr { color: #A00 } /* Generic.Error */
.highlight .gh { color: #333 } /* Generic.Heading */
.highlight .gi { color: #000; background-color: #DFD } /* Generic.Inserted */
.highlight .go { color: #888 } /* Generic.Output */
.highlight .gp { color: #555 } /* Generic.Prompt */
.highlight .gs { font-weight: bold } /* Generic.Strong */
.highlight .gu { color: #666 } /* Generic.Subheading */
.highlight .gt { color: #A00 } /* Generic.Traceback */
.highlight .kc { color: #080; font-weight: bold } /* Keyword.Constant */
.highlight .kd { color: #080; font-weight: bold } /* Keyword.Declaration */
.highlight .kn { color: #080; font-weight: bold } /* Keyword.Namespace */
.highlight .kp { color: #080 } /* Keyword.Pseudo */
.highlight .kr { color: #080; font-weight: bold } /* Keyword.Reserved */
.highlight .kt { color: #888; font-weight: bold } /* Keyword.Type */
.highlight .m { color: #00D; font-weight: bold } /* Literal.Number */
.highlight .s { color: #D20; background-color: #FFF0F0 } /* Literal.String */
.highlight .na { color: #369 } /* Name.Attribute */
.highlight .nb { color: #038 } /* Name.Builtin */
.highlight .nc { color: #B06; font-weight: bold } /* Name.Class */
.highlight .no { color: #036; font-weight: bold } /* Name.Constant */
.highlight .nd { color: #555 } /* Name.Decorator */
.highlight .ne { color: #B06; font-weight: bold } /* Name.Exception */
.highlight .nf { color: #06B; font-weight: bold } /* Name.Function */
.highlight .nl { color: #369; font-style: italic } /* Name.Label */
.highlight .nn { color: #B06; font-weight: bold } /* Name.Namespace */
.highlight .py { color: #369; font-weight: bold } /* Name.Property */
.highlight .nt { color: #B06; font-weight: bold } /* Name.Tag */
.highlight .nv { color: #369 } /* Name.Variable */
.highlight .ow { color: #080 } /* Operator.Word */
.highlight .w { color: #BBB } /* Text.Whitespace */
.highlight .mb { color: #00D; font-weight: bold } /* Literal.Number.Bin */
.highlight .mf { color: #00D; font-weight: bold } /* Literal.Number.Float */
.highlight .mh { color: #00D; font-weight: bold } /* Literal.Number.Hex */
.highlight .mi { color: #00D; font-weight: bold } /* Literal.Number.Integer */
.highlight .mo { color: #00D; font-weight: bold } /* Literal.Number.Oct */
.highlight .sa { color: #D20; background-color: #FFF0F0 } /* Literal.String.Affix */
.highlight .sb { color: #D20; background-color: #FFF0F0 } /* Literal.String.Backtick */
.highlight .sc { color: #D20; background-color: #FFF0F0 } /* Literal.String.Char */
.highlight .dl { color: #D20; background-color: #FFF0F0 } /* Literal.String.Delimiter */
.highlight .sd { color: #D20; background-color: #FFF0F0 } /* Literal.String.Doc */
.highlight .s2 { color: #D20; background-color: #FFF0F0 } /* Literal.String.Double */
.highlight .se { color: #04D; background-color: #FFF0F0 } /* Literal.String.Escape */
.highlight .sh { color: #D20; background-color: #FFF0F0 } /* Literal.String.Heredoc */
.highlight .si { color: #33B; background-color: #FFF0F0 } /* Literal.String.Interpol */
.highlight .sx { color: #2B2; background-color: #F0FFF0 } /* Literal.String.Other */
.highlight .sr { color: #080; background-color: #FFF0FF } /* Literal.String.Regex */
.highlight .s1 { color: #D20; background-color: #FFF0F0 } /* Literal.String.Single */
.highlight .ss { color: #A60; background-color: #FFF0F0 } /* Literal.String.Symbol */
.highlight .bp { color: #038 } /* Name.Builtin.Pseudo */
.highlight .fm { color: #06B; font-weight: bold } /* Name.Function.Magic */
.highlight .vc { color: #369 } /* Name.Variable.Class */
.highlight .vg { color: #D70 } /* Name.Variable.Global */
.highlight .vi { color: #33B } /* Name.Variable.Instance */
.highlight .vm { color: #369 } /* Name.Variable.Magic */
.highlight .il { color: #00D; font-weight: bold } /* Literal.Number.Integer.Long */</style><div class="highlight"><pre><span></span>&lt;svg
	class=&quot;flex-shrink-0 w-5 h-5 text-gray-500 mr-1&quot;
	fill=&quot;currentColor&quot;
	viewBox=&quot;0 0 20 20&quot;
	xmlns=&quot;http://www.w3.org/2000/svg&quot;
	&gt;&lt;path
		fill-rule=&quot;evenodd&quot;
		d=&quot;M16.707 5.293a1 1 0 010 1.414l-8 8a1 1 0 01-1.414 0l-4-4a1 1 0 011.414-1.414L8 12.586l7.293-7.293a1 1 0 011.414 0z&quot;
		clip-rule=&quot;evenodd&quot;
	/&gt;&lt;/svg
&gt;
</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.51.0</a>) at 2026-11-13 08:42:37 +0000</div>
</div> <!-- id=cgit -->
</body>
</html>