spring:
profiles: dev
datasource:
schema: classpath:db/schema.sql
url: jdbc:h2:~/h2/test;MODE=MySql
driver-class-name: org.h2.Driver
username: sa
initialize: true
h2:
console:
enabled: true
CREATE TABLE alc_city (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR,
state VARCHAR,
country VARCHAR,
delete_able INT,
deleted_at TIMESTAMP
);
INSERT INTO alc_city (name, state, country, delete_able, deleted_at)
VALUES ('San Francisco', 'CA', 'US', 1, '2016-10-10 10:11:20');
