add accounts.contract, user.subscriptions

1 files changed, 4 insertions, 2 deletions

diff --git a/db/normalized/user_preferences.js b/db/normalized/user_preferences.js
index fafe5f1a..36956dc0 100644
--- a/db/normalized/user_preferences.js
+++ b/db/normalized/user_preferences.js
@@ -8,11 +8,13 @@ exports.up = function(knex) {
     t.enum('default_currency', ['CAD', 'USD']).notNull().defaultTo('CAD');
     t.enum('default_fiat', ['CAD', 'USD']).notNull().defaultTo('CAD');
     t.set('show_currencies', ['CAD', 'USD']).notNull().defaultTo('CAD');
-
+    t.longtext(`subscriptions`).collate('utf8mb4').nullable(); // CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL")
     t.timestamps();
+    
+    // knex.raw("ALTER TABLE users MODIFY `subscriptions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL")
   })
 }
 
 exports.down = function(knex) {
   return knex.schema.dropTable('user_preferences');
-};
\ No newline at end of file
+};