The answer is right before your eyes in the exception stack trace:
```
Failed to execute SQL script statement at line 10 of resource URL [file:/C:/Users//petstore/target/classes/db/h2/schema.sql]: CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE USERS ( ID INTEGER IDENTITY PRIMARY KEY, USERNAME
```
Hi, Tangara,
What database do you use?
Maybe try to use a simple embedded h2 database for test purpose.
So, your application.properties should have these: