text: DROP TABLE IF EXISTS links; 
  CREATE TABLE IF NOT EXISTS links (
      id INT PRIMARY KEY AUTO_INCREMENT,
      base_url VARCHAR(255) NOT NULL,
      shortened_url VARCHAR(255) NOT NULL,
      is_anonymous INT NOT NULL,
      user_id INT NULL,
      short_description VARCHAR(255) NOT NULL,
      expired_at DATE NULL,
      created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
      updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  );
  
  DROP TABLE IF EXISTS users; 
  CREATE TABLE IF NOT EXISTS users (
      id INT PRIMARY KEY AUTO_INCREMENT,
      firstname VARCHAR(255) NOT NULL,
      lastname VARCHAR(255) NOT NULL,
      email VARCHAR(255) NOT NULL UNIQUE,
      password VARCHAR(255) NOT NULL,
      role  ENUM('Admin', 'User') DEFAULT 'User',
      created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
      updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  );
  
  ALTER TABLE links ADD CONSTRAINT `fk_user_link` FOREIGN KEY(user_id) REFERENCES users(id);
  