From 4eacfda951f8275ac4f3a1283368884e53285ed0 Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Wed, 14 Jul 2021 18:00:30 -0700 Subject: update normalized models --- db/normalized/liquid_assets.js | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 db/normalized/liquid_assets.js (limited to 'db/normalized/liquid_assets.js') 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 -- cgit v1.2.3