drop database if exists springboot_demo; -- 数据库名不能用中划线-
create database springboot_demo charset utf8;
use springboot_demo;
create table `admin`(
  id bigint auto_increment,
  login_name varchar(255),
  password varchar(64),
  last_login_time datetime,
  remark  varchar(255),
  primary key (id)
);
insert into admin(loginName,password,remark) values ('admin','admin','测试数据:管理员用户');

create table `book`(
  id bigint auto_increment,
  name varchar(255),
  price double,
  author varchar(255),
  creator_id int ,
  remark  varchar(255),
  primary key (id)
);