update normalized models

1 files changed, 21 insertions, 0 deletions

diff --git a/db/normalized/liquid_assets.js b/db/normalized/liquid_assets.js
new file mode 100644
index 00000000..f16712d8
--- /dev/null
+++ b/db/normalized/liquid_assets.js
@@ -0,0 +1,21 @@
+exports.up = function(knex) {
+  return knex.schema.createTable('liquid_assets', function(t) {
+    t.increments('id').unsigned().primary();
+
+    t.string('asset_id').notNull();
+    t.string('name').notNull();
+
+    t.string('domain')
+    t.string('ticker').notNull();
+    t.int('precision').defaultTo(8);
+    t.string('issuer_pubkey')
+
+    t.boolean('registered').defaultTo(false);
+
+    t.timestamps();
+  })
+}
+
+exports.down = function(knex) {
+  return knex.schema.dropTable('liquid_assets');
+};
\ No newline at end of file