dump tarefas

DROP TABLE IF EXISTS usuarios;
CREATE TABLE usuarios (
  id INT NOT NULL AUTO_INCREMENT,
  nome VARCHAR(45) NOT NULL,
  login VARCHAR(45) NOT NULL,
  email VARCHAR(45) NOT NULL,
  senha VARCHAR(128) NOT NULL,

  CONSTRAINT pk_usuarios PRIMARY KEY(id)
) AUTO_INCREMENT=1;

DROP TABLE IF EXISTS categorias;
CREATE TABLE categorias (
  id INT NOT NULL AUTO_INCREMENT,
  nome VARCHAR(45) NOT NULL,

  CONSTRAINT pk_categorias PRIMARY KEY(id)
) AUTO_INCREMENT=1;

DROP TABLE IF EXISTS tarefas;
CREATE TABLE tarefas (
    id INT NOT NULL AUTO_INCREMENT,
    title VARCHAR(100) NOT NULL,
    descricao TEXT NOT NULL,
    categorias_id INT NOT NULL,
    usuarios_id INT NOT NULL,

    CONSTRAINT pk_tarefas PRIMARY KEY(id),
    CONSTRAINT fk_usuarios_id FOREIGN KEY(usuarios_id) REFERENCES usuarios(id) ON DELETE CASCADE,
    CONSTRAINT fk_categorias_id FOREIGN KEY(categorias_id) REFERENCES categorias(id) ON DELETE CASCADE
) AUTO_INCREMENT=1;