const Sequelize = require('sequelize');

const mysql = new Sequelize({
  database: 'database',
  username: 'root',
  password: 'pass',
  host: 'mysql.server',
  port: 3306,
  pool: {
    max: 5,
    idle: 30000,
    acquire: 60000,
  },
  dialect: 'mysql',
  operatorsAliases: false
});

/*Model MobileAction*/

const MobileAction = mysql.define('mobile_actions', {
  action_id: { type: Sequelize.INTEGER, primaryKey: true},
  action_code: Sequelize.TEXT,
  network_id: Sequelize.INTEGER,
  action_subid: Sequelize.TEXT,
  random_ref: Sequelize.INTEGER,
  network_id: Sequelize.INTEGER,
  idfa_gaid: Sequelize.TEXT,

},{timestamps: false})

/*Model Network*/

const Network = mysql.define('networks', {
  network_id: { type: Sequelize.INTEGER, primaryKey: true},
  action_code_append: Sequelize.TEXT,
  idfa_param: Sequelize.TEXT,
  gaid_param: Sequelize.INTEGER,
  action_lander_param: Sequelize.TEXT,
  pubid_param: Sequelize.INTEGER,
  siteid_param: Sequelize.INTEGER,
  rand_ref_param: Sequelize.TEXT,
  rand_ref_app_param: Sequelize.TEXT,

},{timestamps: false})

/*Model RandomRef*/

const RandomRef = mysql.define('random_refs_alexa', {
  id: { type: Sequelize.INTEGER, primaryKey: true},
  url: Sequelize.TEXT,

},{timestamps: false,tableName: 'random_refs_alexa'})

/*Model RandomApp*/

const RandomApp = mysql.define('random_apps', {
  id: { type: Sequelize.INTEGER, primaryKey: true},
  random_app: Sequelize.TEXT,

},{timestamps: false})

/*Model Supplier*/

const Supplier = mysql.define('campaign_category', {
  id: { type: Sequelize.INTEGER, primaryKey: true},
  supplier_network_id: Sequelize.INTEGER,

},{timestamps: false,tableName: 'campaign_category'})

/*Model SupplierToken*/

const SupplierToken = mysql.define('supplier_networks', {
  id: { type: Sequelize.INTEGER, primaryKey: true},
  idfa_token: Sequelize.TEXT,
  gaid_token: Sequelize.TEXT,
  pubid_token: Sequelize.TEXT,
  siteid_token: Sequelize.TEXT,

},{timestamps: false})




exports.mysql = mysql;