Spring Security - Third Edition

Initializing the database

We can now remove the src/main/resources/database directory and all contents in that directory. This directory contains several .sql files, and we will consolidate and move them to the next step:

Now, we need to create a data.sql file that will contain our seed data, as follows:

    //src/main/resources/data.sql:

• Take a look at the following SQL statement, depicting the password for user1:

        insert into calendar_users(id,username,email,password,        first_name,last_name)         values(0,'[e-mail]','[e-mail]',        '$2a$04$qr7RWyqOnWWC1nwotUW1nOe1RD5.        mKJVHK16WZy6v49pymu1WDHmi','User','1');

• Take a look at the following SQL statement, depicting the password for admin1 : 

 insert into calendar_users(id,username,email,password, ...