sxCYSCZB

1server.port:8090
2spring.jpa.database=H2
3spring.datasource.url:jdbc:h2:mem:atm
4flyway.locations=classpath:resources/db/migration
5flyway.enabled=true
6spring.datasource.username:sa
7spring.datasource.password:
8spring.h2.console.enabled=true
9spring.jpa.show-sql=true
10security.basic.enabled:false
11spring.jpa.hibernate.ddl-auto=create
12
13    019-05-09 22:30:17.595  INFO 22734 --- [  restartedMain] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
142019-05-09 22:30:17.634  INFO 22734 --- [  restartedMain] org.hibernate.tool.hbm2ddl.SchemaExport  : HHH000227: Running hbm2ddl schema export
15Hibernate: drop table account if exists
16Hibernate: drop table bank if exists
17Hibernate: drop table client if exists
18Hibernate: create table account (id bigint generated by default as identity, balance decimal(19,2), number bigint, ownedr varchar(255), password varchar(255), id_bank bigint, primary key (id))
19Hibernate: create table bank (id bigint generated by default as identity, descricao varchar(255), primary key (id))
20Hibernate: create table client (id bigint generated by default as identity, nome varchar(255), primary key (id))
21Hibernate: alter table account add constraint FKpwnjbb07xe9slyywchx4ddqfm foreign key (id_bank) references bank
222019-05-09 22:30:17.640  INFO 22734 --- [  restartedMain] org.hibernate.tool.hbm2ddl.SchemaExport  : HHH000230: Schema export complete
23
24    CREATE TABLE bank(
25
26    id   BIGINT(20) PRIMARY KEY AUTO)INCREMENT,
27    nome VARCHAR(50) NOT NULL
28
29  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30
31 INSERT INTO bank (nome) VALUES ('SANTANDER');
32 INSERT INTO bank (nome) VALUES ('ITAU');
33 INSERT INTO bank (nome) VALUES ('SAFRA');