remoteのサーバの状態をpushするためのデータベース及びテーブルを作成するためのSQL文

serverstatus.sql

-- See https://pandanote.info/?p=7242 for details.
drop database if exists serverstatus;
create database serverstatus;
grant all privileges on serverstatus.* to 'serverstatus'@'%' identified by 'Some password to store the status of the remote server.';
grant all privileges on serverstatus.* to 'serverstatus'@'localhost' identified by 'Some password to store the status of the remote server.';
use serverstatus;
drop table if exists serverstatus;
create table serverstatus (
	   id int not null auto_increment,
	   status int not null,
	   updated_at timestamp not null,
	   primary key(id)
);