Sql code rectification

Can somebody help with the errors in the code
I am unable to run it on netbeans.

CREATE TABLE users(
  id int GENERATED ALWAYS AS IDENTITY ,
  first_name varchar(20) DEFAULT NULL,
  last_name varchar(20) DEFAULT NULL,
  username varchar(250) DEFAULT NULL,
  password varchar(20) DEFAULT NULL,
  PRIMARY KEY (id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE todos (
id bigint(20) GENERATED ALWAYS AS IDENTITY ,
  description varchar(255) DEFAULT NULL,
  is_done bit(1) NOT NULL,
  target_date datetime(6) DEFAULT NULL,
  username varchar(255) DEFAULT NULL,
  title varchar(255) DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

I am getting the following errors :

[Exception, Error code 30,000, SQLState 42X01] Syntax error: Encountered "ENGINE" at line 8, column 2.
Line 8, column 2


[Exception, Error code 30,000, SQLState 42X01] Syntax error: Encountered "(" at line 2, column 10.
Line 11, column 10

Hi there, which database management system are you using