yurake/k8s-3tier-webapp

kubernetes/mysql/init/init.sql

Summary

Maintainability

Test Coverage

Issues

CREATE DATABASE webapp;
CREATE user 'webapp' identified by 'webapp';
GRANT ALL PRIVILEGES on webapp.* to 'webapp';
use webapp;

CREATE TABLE msg (
  id int(5) unsigned not null auto_increment,
  msg varchar(255) not null,
  created_time datetime not null default current_timestamp,
  updated_time datetime not null default current_timestamp on update current_timestamp,
  primary key (id)
);