import { Sequelize } from "sequelize";

const sequelize = new Sequelize({
  dialect: "mariadb",
  host: "localhost",
  port: 3306,
  username: "emp2",
  password: "titok",
  database: "emp2"

});

const Employee = sequelize.define('employee', {
  id: {
    type: Sequelize.INTEGER,
    autoIncrement: true,
    allowNull: false,
    primaryKey: true
  },
  name: {
    type: Sequelize.STRING,
    allowNull: false
  },
  city: {
    type: Sequelize.STRING,
    allowNull: true
  },
  salary: {
    type: Sequelize.DOUBLE,
    allowNull: true
  }
});

await sequelize.sync({
    alter: true
});

Employee.create({
  name: 'Erős István',
  city: 'Szeged',
  salary: 392
});