'use strict';
module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('stores', {
      id: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: Sequelize.INTEGER
      },
      storeName: {
        type: Sequelize.STRING
      },
      storeUrl: {
        type: Sequelize.STRING
      },
      ownerName: {
        type: Sequelize.STRING
      },
      contactNumber: {
        type: Sequelize.STRING
      },
      whatsAppNumber: {
        type: Sequelize.STRING
      },
      address1: {
        type: Sequelize.STRING
      },
      address2: {
        type: Sequelize.STRING
      },
      pincode: {
        type: Sequelize.INTEGER
      },
      location: {
        type: Sequelize.STRING
      },
      storeImage: {
        type: Sequelize.STRING
      },
	  storeDoc: {
        type: Sequelize.STRING
      },
      openingTime: {
        type: Sequelize.TIME
      },
      closingTime: {
        type: Sequelize.TIME
      },
      features: {
        type: Sequelize.STRING
      },
      disclaimer: {
        type: Sequelize.STRING
      },
      storeType: {
        type: Sequelize.INTEGER
      },
	  otp: {
        type: Sequelize.INTEGER
      },
	  verifyOtp: {
        type: Sequelize.INTEGER
      },
	  storeStatus: {
        type: Sequelize.INTEGER
      },
	  returnPolicy: {
        type: Sequelize.STRING
      },
	  pickup: {
        type: Sequelize.INTEGER
      },
	  wideDiscount: {
        type: Sequelize.STRING
      },
	  wideDiscountType: {
        type: Sequelize.INTEGER
      },
	  cashondelivery: {
        type: Sequelize.INTEGER
      },
	  upi: {
        type: Sequelize.STRING
      },
	  planType: {
        type: Sequelize.INTEGER
      },
	  planValidity: {
        type: Sequelize.INTEGER
      },
	  planStatus: {
        type: Sequelize.INTEGER
      },
	  startDate: {
        type: Sequelize.DATE
      },
	  endDate: {
        type: Sequelize.DATE
      },
	  status: {
        type: Sequelize.INTEGER
      },
      createdBy: {
        type: Sequelize.INTEGER
      },
      updatedBy: {
        type: Sequelize.INTEGER
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    });
  },
  async down(queryInterface, Sequelize) {
    await queryInterface.dropTable('stores');
  }
};