Hands-On Spring Security 5 for Reactive Applications

Creating a new table in MySQL database

We will use the same schema as the MySQL DB that we used in Chapter 2, Deep Diving into Spring Security. Keep everything as is, and then create a new table in the MySQL database for storing persistent tokens by executing the following DDL statement in the MySQL workbench:

create table persistent_logins(     series varchar(64) not null primary key,        username varchar(75) not null,     token varchar(100) not null,     last_used timestamp not null);