Migration to create database and Teams table

001_up_create_DB_and_Teams.sql

BEGIN;

CREATE DATABASE IF NOT EXISTS my_application;

USE my_application;

/*
TABLE: Teams
DESC:  It is a real team such as UNIX Admins, DBAs or Human Resources.
*/

DROP   TABLE IF EXISTS Teams;
CREATE Teams (
  id         INTEGER PRIMARY KEY NOT NULL, 
  name       TEXT NOT NULL, 
  email      TEXT,
  create_on  TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  update_on  TIMESTAMP NULL
);

COMMIT;