title: Automatically creating schema in Nodejs using sequelize
body: <p>I have a react+node app. I am using sequelize to create tables. I want sequelize to automatically create the <strong>schema(not the tables, the tables are being automatically created if not present already)</strong> in mysql and also populate one of the tables with a particular set of data.</p>
  
  <pre><code>const Sequelize = require('sequelize');
  const sequelize = new Sequelize('myschema','username','pass',{
      dialect:'mysql',
      host:'localhost'
  });
  
  module.exports = sequelize;
  </code></pre>
  
  <p>The tables are automatically created but I want to create the schema - 'myschema' automatically as well, once I run the app (so as to avoid manually creating the schema in production).</p>
  
  <pre><code>router.post('/somepath',(req,res,next)=&gt;{
  const 
  pathname=path.join(__dirname,'../','somefile.xlsx');
    let workbook=xlsx.readFile(pathname);
    var sheet_name_list = workbook.SheetNames;
    var data = xlsx.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]);//This is an array of json objects
  
  //updating the database.
  
  });
  </code></pre>
  
  <p>I want to populate the profile table with data from the array of json objects on startup <strong>if not there already</strong>.</p>