November 22, 2017
Define Database Schema
You can download the schema.sql – Spring4Restful_v01_schema.zip here, and run it with MySQL client. /* create database */ CREATE DATABASE itblogs DEFAULT CHARACTER SET utf8; USE itblogs; CREATE TABLE COMPANY( id BIGINT NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, background VARCHAR(255) NOT NULL, PRIMARY KEY (id) ); CREATE TABLE SHOP ( id